Assuming number is required, the following 160 results were found.
-
// // init v_OutputMessage = ""; v_CrmSoRef = ""; v_CrmSoID = 0; // // get books so name (sales order number) r_BooksSoDetails = zoho.books.getRecordsByID("Salesorders",v_BooksOrgID,v_BooksSoID.toString()); for each r_SoBooks in r_BooksSoDetails {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
- GetOrders Documentation: https://developer.ebay.com/Devzone/XML/docs/Reference/eBay/GetOrders.html - eBay Errors by Number: https://developer.ebay.com/devzone/xml/docs/Reference/ebay/Errors/errormessages.htm */ // // declare v_Page = 1; v_PerPage =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
by url description => sort by description date => sort by date added (most recent or oldest first) hits => sort by hits (number of times clicked on) published => obviously by whether they're published or not... no idea why u would checked_out => sort by...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
day of week starting with Monday (1), i.e. mtwtfss 1 %w day of week starting with Sunday (0), i.e. smtwtfs 1 Week %U week number Sunday as first day of week 01–53 %W week number Monday as first day of week 01–53 %V week of the year 01–53 Month %m mm...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
blab actually means is that there is a chance one of your date values is BLANK, NULL or contains a non-numerical value in a number such as COMMA (,) and therefore the parsing (to extract year for example) will fail and stop the task (based on default...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
an Oracle stored procedure to work with SSRS. Main Example: My stored procedure will do the following: Get a student ID number based on the student username Get a student's names and date-of-birth based on the student ID number Agenda Outline Note: As...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
blog, I wrapped my SQL query within a common table expression: --Create CTE WITH tblDifference AS ( SELECT t1.*, ROW_NUMBER() OVER (ORDER BY t1.Date ASC, t1.Start ASC, t1.Room ASC, t1.Finish ASC) as 'RowNumber' FROM ( -- start your original SQL query...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
following examples): -- exist() returns 1 or 0 if node exists or not respectively SELECT Event_XML.exist('/STAFF/EMPLOYEE_NUMBER') FROM [dbo].[XML_EVENTS] -- query() returns typed XML SELECT Event_XML.query('/STAFF/EMPLOYEE_NUMBER') FROM...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
is all I need in this case. In my example, I need to submit an Active Directory (AD) username and receive a student ID number instead, all with the aim to improve performance on some SSRS queries which accept either an ID number or an AD name as user...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
NO modifications whatsoever) I start to get the "cannot connect to MYSQL." I contacted my webhost, and the problem is the number of MYSQL database queries. It goes up to about 200,000 in the first few minutes of use and then after that every page load...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when converted to...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
- Fixed Bug: Parameter initialization and class array correction (by Miguel Isasmendi) - Fun Bug: Debug mode shows number of seconds this module adds. - Date Uploaded: Tue, 23rd Aug 2011 2.0.3 - Optimizing code - Date Uploaded: Sun, 21st Aug 2011 2.0.2...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
--- Integrate JComments/Integrate Facebook Comments (for Product Reviews/Feedback). --- Auto-increment minor/major version number / Assign naming convention. --- Date Format for files (mysql format please cos unix will take my server's one). --- Enable...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? Zoho doesn't have a function to generate random numbers or strings. There are workarounds however. How?...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
r_CreateSO.get("salesorder"); v_NewSoID = r_NewSoDetails.get("salesorder_id"); v_NewRefNum = r_NewSoDetails.get("salesorder_number"); // // build up a reference map from the line items of the newly created sales order m_NewLineItems = Map(); for each...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
A very quick article on a cool snippet of code, another regular expression, I've been trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho Deluge - Some Useful Regular Expressions list but I felt...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
will now retrieve 10 products per page and loop through 3 pages for use in Zoho Deluge. If this works, we can increase the number of pages as well as the number of products per page: The GraphQL The key value to retrieve is "cursor"; we're also going to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
v_StripeAmount = v_AmountToPay * 100; v_StripeAmount = v_StripeAmount.floor(); v_StripeAmount = v_StripeAmount.toNumber(); info v_StripeAmount; // // Create payment intent in Stripe v_PaymentIntentEndpoint = "https://api.stripe.com/v1/payment_intents";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
of Goods Sold").toLong()); // // advanced tracking ones m_CreateBooksItem.put("track_serial_number",true); m_CreateBooksItem.put("track_batch_number",true); // // let's try creating it r_CreateItem =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
or update the estimate in ZohoBooks. You will need the returned estimate ID and I'm not 100% sure the attention/phone number goes along as my client didn't include these in her estimate template... But I'm sending them anyway. Note(s) The following code...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *