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 ...
What?
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 ...
... a quick test I do retrieving 5 products using the REST admin API:
//
// app specific
r_ShopifyAPI = API_Integration[Connection_Name == "Shopify API OAuth"];
v_ShopID = r_ShopifyAPI.Shop_ID;
v_ShopifyApiVersio ...
... 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 ...
... 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 ...
... D = 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 functio ...
...
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 ...
... Customization > Forms > Leave
Under "Form Properties" > Tick the box under "Validation" for "Custom Validation" to create a function:
Ensure you select parameters to input rather than retrieving ...
... 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 ...
What?
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:"
-- ...
... ASC');
// Reset the query using our 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();
// ...
... OUT 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 MY_PRETEND_STORED_PROCEDURE('value1','value2','value3',:errorcode,:errormsg)
Still ...
... datetime NOT NULL Time report started to run.
TimeEnd datetime NOT NULL Time report finished running? Need to check what finished?
TimeDataRetrieval int NOT NULL Milliseconds spent retrieving the ...
Situation:
I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.