Assuming order is required, the following 135 results were found.
-
a datatype Boolean. Our function will then loop through each record and do what it has to do. The workaround here is that we order this by modified time. When the checkbox gets updated, this modifies the record and puts it at the bottom of the list. In...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
and list their IDs. How? So here's the function I came up with. It loops through a maximum of 2500 products sorted in order of ID ascending (starting with ID=0) retrieving 250 per call and using since_id to not list the same one twice. It then outputs a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
// // set results parameters m_SearchParam = Map(); m_SearchParam.put("sort_by", "Modified_Time"); m_SearchParam.put("sort_order", "asc"); // // loop through each page for each v_Page in l_Pages { l_SearchResults =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this function too often either for debugging/monitoring purposes but...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
"type": "custom" } } Tidied Up Want that in a practical format for use in ZohoCreator? Preferably not in the Zoho order, but that of the normal week (in other words, not alphabetical, numerical, or completely random order): void...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
as a scope but I'm sure you can lock it down to just the scopes you need. void ZohoBooks.fn_SendZohoBooksInvoice(int p_OrderID) { v_OrderID = ifnull(input.p_OrderID,0).toLong(); /*...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
m_Header.put("Xero-tenant-id",v_TenantID); // // get Xero invoices (page 1 - first 100 - default order is updated date) for each v_Page in l_Pages { m_Params = Map(); m_Params.put("page",v_Page); // // keep the page size low as this function will be...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
{ $('log').set('html', response); } }); // Send the form. this.send(); }); }); .aCoupleOfDivs { background-color:#efefef; border:2px solid #ccc; width:300px; float:left; } Basic Mootools Form in Joomla 2.5 Basic Mootools Form in Joomla 2.5 Name:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
is not easily recognized from the results ** ** ** ** Only finds the first table_name.column_name where the match occurred (ordered alphabetically). ** ** -> Example: if a table has two rows, both with the typo: ** ** Row1: EthnicCode DnYa ** ** Row2:...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
'(' + CAST(CHARACTER_MAXIMUM_LENGTH AS VARCHAR(10)) + ')' END FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @TableName ORDER BY ORDINAL_POSITION FOR XML PATH ('') ),1,1,'' ) + ';'; EXEC(@TableDeclaration); -- Get First Column Name SET @ColName=(...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
SELECT q.Employee AS EmployeeNo, RIGHT('000' + CAST(q.Employee AS VARCHAR), 3) + RIGHT( '00' + CAST( ( ROW_NUMBER() OVER (ORDER BY q.Employee) ) AS VARCHAR ), 2 ) AS QualificationRef FROM Qualifications q INNER JOIN Employee e ON RIGHT('000' +...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
t1 FULL OUTER JOIN [myDB2].[INFORMATION_SCHEMA].[COLUMNS] t2 ON t1.COLUMN_NAME=t2.COLUMN_NAME WHERE t2.COLUMN_NAME IS NULL ORDER BY t1.COLUMN_NAME -- columns in new database but not in old SELECT t2.* FROM [myDB1].[INFORMATION_SCHEMA].[COLUMNS] t1 FULL...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
displays the structure of all the columns in all the databases of the localhost: SELECT * FROM information_schema.COLUMNS ORDER BY TABLE_NAME, COLUMN_NAME The following is a MYSQL query that finds all columns (displayed as "tablename.columnname") that...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
- Type: Article
- Category: Static Items
- Language: *
-
= $04000000 Const WS_CLIPCHILDREN = $02000000 Const WS_MAXIMIZE = $01000000 Const WS_CAPTION = $00C00000 Const WS_BORDER = $00800000 Const WS_DLGFRAME = $00400000 Const WS_VSCROLL = $00200000 Const WS_HSCROLL = $00100000 Const WS_SYSMENU = $00080000...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
MsgBox 1: %v_Leftest% 2: %v_Central% 3: %v_Rightest% Now there is an 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...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
customise the website according to your interests. Security We are committed to ensuring that your information is secure. In order to prevent unauthorised access or disclosure we have put in place suitable physical, electronic and managerial procedures...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: en-GB
-
same material under section 10. 9. Acceptance Not Required for Having Copies. You are not required to accept this License in order to receive or run a copy of the Program. Ancillary propagation of a covered work occurring solely as a consequence of...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
sites you've done or how many times you used it (no audit trail). Client-side: Server solutions take up processing power in order to convert/download these on-the-fly. Use this program to generate the thumbnails and upload the images to your server....
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
street 2 and shipping street 2 from the Account module to the Quote module, then on convert, to map these to the Sales Order in CRM. As my client's sales team would only create sales orders in CRM and don't use the invoice module (that's for their...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *