Search - Joel Lipman .Com

1. Zoho Projects: Get All Events: / Zoho /; ... are events in the past; status is a mandatory field // NB: range is an integer and the number of records to return (default=100; max=200) // NB: index is an integer and is the offset or starting index ...; Created on 22 July 2024
2. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... HTML entity equivalent and enclosing the ID in double-quotes in case I open it in MS Excel or another system that likes rounding 64-bit signed integers (long numbers): // // Generate a CSV of a ...; Created on 25 March 2024
3. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... integer, currency, decimal and double. You can search for a maximum of 10 criteria (with same or different columns) with equals and starts_with conditions. The only operator that is supported for encrypted ...; Created on 14 November 2023
4. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... specified in a previous multi-line text field l_PackageRefs = c_Appt.Associated_Package_Slips1.toList(); // // important to declare this as a list of integers l_PackagesToAdd = List:Int(); for ...; Created on 18 August 2022
5. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... an Integer/Long/Number datatype As the first part of your code, enter the following as code (you'll need to speify your own App Owner and App Name): // // ************************************************** ...; Created on 31 March 2022
6. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... to integers when the datatype is an integer and not a decimal: // syntax: // v_Test9.round(2); // round(v_Test9, 2); v_Test9 = 10.0; info v_Test9.round(2); // yields 10.00 v_Test10 = 10; info ...; Created on 08 February 2022
7. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
8. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... As Range Dim xRow As Range Dim SplitRow As Integer Dim xWs As Worksheet On Error Resume Next xTitleId = "JoelsTooCoolForExcel" Set WorkRng = Application.Selection Set ...; Created on 11 February 2019
9. Submit form as a server and not the client with cURL: / API Miscellaneous /; What? A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache ...; Created on 20 February 2015
10. Basic Android App using Google Maps and Current Location: / AndroidOS /; Applies to: Android Studio (Beta) 0.8.6 Google Android Maps API What? I am writing an app for a tablet running Android and wanted to include a Google Map. The following exercise focuses solely ...; Created on 10 October 2014
11. Regular Expression Basic Usage Examples: / Web-Development /; ... for a repeated expression. You specify a backreference with '\n', where n is an integer from 1 to 9 indicating the nth preceding subexpression in your regular expression. For example, to find a repeated ...; Created on 28 October 2013
12. Joomla Development: Possible XML Filters: / Joomla /; Applies to: Joomla! CMS 2.5.x Joomla Filter: Validation OnSave INT Forces the value to be an Integer UINT Forces the value to be an absolute number (-4.2 becomes 4.2) FLOAT Forces ...; Created on 17 October 2013
13. SSIS Convert a string into a date: / SQL Server Integration Services /; ... dates one which was imported as a string (DT_WSTR) and another as a integer (DT_R8). Why? It took me a long time to figure this and it was only by trawling through columns that someone mentioned ...; Created on 14 March 2013
14. Data Randomization Function in Oracle PL/SQL: / Oracle PL/SQL /; ... ELSE v_rand_param2 := p_original_range_2; END IF; -- Determined submitted value as 'INTEGER'; v_returnedval := TRUNC(DBMS_RANDOM.VALUE(v_rand_param1, ...; Created on 22 August 2012
15. Functions to convert Hex 2 RGB and vice-versa: / AutoHotkey /; ... StringSplit,_RGB,RGBString,%Delimiter% SetFormat, Integer, Hex _RGB1+=0 _RGB2+=0 _RGB3+=0 If StrLen(_RGB1) = 3 _RGB1= 0%_RGB1% If StrLen(_RGB2) = 3 _RGB2= 0%_RGB2% If StrLen(_RGB3) ...; Created on 27 September 2011
16. Add Image Mouseover effect in AutoHotkey GUI: / AutoHotkey /; ... if A_Gui = { if wparam is not Integer If InStr( wparam, ".cur" ) || InStr( wparam, ".ani" ) { ;LoadCursorFromFile IfNotExist, % WPARAM ; verify existance ...; Created on 25 January 2010
17. Prices get rounded up in Virtuemart: / Virtuemart /; This happened to a m8s website in VirtueMart 1.1.3. The issue here was that although all the prices lost their float/decimal and were rounded up to the nearest integer... At first we thought this was ...; Created on 27 September 2009
18. Advanced RokStories Styling: / Joomla /; ... nascetur ridiculus mus. Nulla pulvinar est. Integer urna. Pellentesque pulvinar dui a magna. Nulla facilisi. Proin imperdiet. Aliquam ornare, metus vitae gravida dignissim, nisi nisl ultricies felis, ac ...; Created on 01 July 2009
19. RocketTheme's Affinity July 2009 Release: / Joomla /; ... dis parturient montes, nascetur ridiculus mus. Nulla pulvinar est. Integer urna. Pellentesque pulvinar dui a magna. Nulla facilisi. Proin imperdiet. Aliquam ornare, metus vitae gravida dignissim, nisi ...; Created on 01 July 2009
20. Header (Adspace): Created on 17 April 2017