Assuming retrieving is required, the following 16 results were found.
-
What? We have a report in SQL Server Reporting Services 2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is that there appears a link that will run a stored...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
}) .catch( function( r_Error ){ document.write(JSON.stringify(r_Error)); }); }); ZOHO.embeddedApp.init(); [Note to self] Retrieving the record itself (not needed for this task): ZOHO.embeddedApp.on("PageLoad", function(r_Data) { // get id and module on...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
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 JSON list as a response and the total...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
So this is an article to list methods of retrieving the number of files in a folder/directory. Why? Why can't we just use a loop and file pattern native to the Autohotkey programming language: UserFolder:="C:" -- UserFolder := RegExReplace(...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
box under "Validation" for "Custom Validation" to create a function: Ensure you select parameters to input rather than retrieving the record data: I'm calling the Function Name "RejectLeave" then click on Edit Params I'm calling the Method Name...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
keys to the list declared previously. Sort the list of keys in ascending/descending order. Loop through the list of keys, retrieving each record // // build up sample map in random order l_MyListUnsorted = List:Map(); m_Record = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
!= null) { v_ResultingQuoteID = r_CreateCrmQuote.toMap().get("data").get(0).get("details").get("id"); } } } Retrieving a record with 2.1 JSON The following is a snippet when querying a CRM module (invoices) from a CRM function. The important fields I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
In the next snippet of code, I am getting the Zoho CRM record owner, looping through all salespersons in Zoho Books, and retrieving the salesperson_id. Also I have a connector to ZohoBooks called "joel_books". The "v_Filter" appears to do absolutely...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
set these. Mine don't as the Creator app I'm making is for staff only. REST Admin API: Usage: Here's a quick test I do retrieving 5 products using the REST admin API: // // app specific r_ShopifyAPI = API_Integration[Connection_Name == "Shopify API...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
A quick article on retrieving all the products from a WooCommerce instance on a client's Wordpress website. Why? A client of ours wants the information entered against products in their WooCommerce to display on their estimates in Zoho Books; such as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
} How? I recall covering this solution before but it boils simply down to the zoho.crm.getRelatedRecords() not retrieving related records which are clearly visible when using the CRM. The cause of the problem is the same as covered in my article Joel...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
and payload. Previously on... m_Header = Map(); m_Header.put("Content-Type","application/json"); // // app specific (retrieving from a ZohoCreator record that stores all these credentials) r_ShopifyAPI = API_Integration[Connection_Name == "Shopify...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
new query object $db->setQuery($query); // Load the results as a list of stdClass objects (see later for more options on retrieving data). $rows = $db->loadObjectList(); // Retrieve each value in the ObjectList foreach( $rows as $row ) { $this_user_id =...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
variables. For a success message to be returned based on the status of the stored procedure, please view my article SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel EXECUTE...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
NOT NULL Time report finished running? Need to check what finished? TimeDataRetrieval int NOT NULL Milliseconds spent retrieving the data. TimeProcessing int NOT NULL Milliseconds spent processing the report. TimeRendering int NOT NULL Milliseconds...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
more than one record was returned so you need to surround with brackets and append a [1] as per the above example. Retrieving nodes -- to get all below nodes from root node - STAFF SELECT Event_XML.query('/STAFF') FROM [dbo].[XML_EVENTS] -- to get all...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB