Assuming above is required, the following 179 results were found.
-
My solution so far: The following script will convert to lowercase and then capitalize the first letter in addition to the above specification. I am storing it here so that I can work on improving it: /* Microsoft SQL Server Integration Services Script...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
0 and it will search. Samples : 1. To search data in a table EXEC SearchTables @Tablenames = 'T1' ,@SearchStr = '%TEST%' The above sample searches in table T1 with string containing TEST. 2. To search in a multiple table EXEC SearchTables @Tablenames =...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
2 You now have a big SELECT query which you can copy, paste and run against your SQL database. Simply run the query that the above outputted and you should get something like the following: Value Source Count ------- ------------------------- --------...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
- Type: Article
- Category: Static Items
- Language: *
-
Flags Const HHT_NOWHERE = $0001 Const HHT_ONHEADER = $0002 Const HHT_ONDIVIDER = $0004 Const HHT_ONDIVOPEN = $0008 Const HHT_ABOVE = $0100 Const HHT_BELOW = $0200 Const HHT_TORIGHT = $0400 Const HHT_TOLEFT = $0800 ;#End Region ;#Region List View sub...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
small letter a with diaeresis 133 85 U+00E0 à latin small letter a with grave 134 86 U+00E5 å latin small letter a with ring above 135 87 U+00E7 ç latin small letter c with cedilla 136 88 U+00EA ê latin small letter e with circumflex 137 89 U+00EB ë...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
issue in that Monitor 1,2, and 3 might not be in the order placed on the desk and not in the order of left to right. So the above code tries to determine the leftmost monitor and rightmost with the last being in the centre. First of all here's the code...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
should be empty for clarity results_file.txt is the resulting file, it will be created in the current working directory. Above and Beyond: Add to your Context Menu My absolute laziness drives me to write the instructions on adding this to the context...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
headers:m_Header ]; Problem: Value is empty and 'get' function cannot be applied Following a post similar to the above example by InvokeURL and then getting a JSON response back, the response does not seem to be read as a map: r_Response = invokeurl [...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
because of the delay/lag in that searchRecords will not find the corresponding CRM sales order record. Instead, do the above workflow to attach the files to the Sales Order in Zoho Books, then in your Creator app, do the following for a delayed...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
} if(!isNull(r_Coql.get("data"))) { v_MatchedAccountID = ifnull(r_Coql.get("data").get(0).get("id"),0); } Note that for the above, if there are no matching records, r_Coql will simply return an empty string. Hence the check for isNull on the keys info...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
TTL = 300 Type = CNAME CNAME = creator.cs.zohohost.com or creator.cs.zohohost.eu depending on the value obtained step 1c above. Add another CNAME record with the following: name as .myparentdomain.com ("code" is 6-character code obtained in step 1c...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
connection:"joels_connector" ]; info r_CreateTimeLog; You will find I've included the Hours decimal calculation above but it's not used and just for future reference. The API wants the total hours and minutes in the format "HH:mm" (eg. "34:06" = 34...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
but instead of "line_tax", replace this with "Line_Tax" (note the capitalized letters). I have included this in the example above. Line Item Tax doesn't display at line item lvel Previously submitting no tax would still put a 0.00 in the tax column of a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
} info m_Record.toString(); } Without a regex solution and the replacement back to commas then the above outputs: {"EmployeeID":"1","Name":"Joel Lipman","Address":"Kings Castle","Territory":"England"} {"EmployeeID":"11","Name":"General...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
An article to note something I didn't realize I needed: How to address the above error and how to update a Shipping Address for a specific Sales Order in Zoho Books. Why? You might think the following request to create a Sales Order in Zoho Books would...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
I use the full number in the first column) Sending a Text/SMS message // // using the account SID you obtained in the steps above v_Account_SID = "ABCDEFabcdef0123456789ABCDEFabcdef"; // // set this to the authtoken value obtained earlier v_Auth_Token =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
r_UploadPhoto = invokeurl [ url :v_Url type :POST files:f_base64 connection:"my_books_connection" ]; Caveat(s) The code above only uploads 1 photo... Update 2024: the code above STILL only uploads 1 photo. Error(s) Encountered {"code":37,"message":"The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Client ID and Client Secret. Do not share the Client ID and Client Secret with anyone. STEP 2: GENERATE A GRANT CODE On the above screen (Zoho API Console - Applications @ https://api-console.zoho.com/) Select your "Self Client" Enter in the applicable...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Sign
- Language: *
-
, 'Price Disrepency' ) AND po."Purchase Order Status" NOT IN ( 'Cancelled' ) The second dataset will be a grouping of the above, in addition to including the customer ID and invoice ID, I'm calling this one "Invoice Items vs SoPo Items": SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *