Search - Joel Lipman .Com

21. Zoho Deluge: Generate List of TimeZones: / Zoho /; What? A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing ...; Created on 19 October 2021
22. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... = v_PhotoWithExt.subString(v_PhotoWithExt.lastIndexOf(".") + 1).toLowerCase(); // if(l_CompatiblePhotoExtensions.containsIgnoreCase(v_PhotoFileExtension)) { v_ThisPhotoSrc = "https://creator.zoho.com/file/appowner/appname/My_Form_Report/" ...; Created on 17 October 2021
23. Zoho Deluge: Zoho Bookings Get Available Slots: / Zoho /; ... = r_AvailableSlots.get("response").get("returnvalue").get("data"); if(!l_AvailableSlots.toString().containsIgnoreCase("Slots Not Available")) { for each r_AvailableSlot in l_AvailableSlots { if(!r_AvailableSlot.contains("00:00") ...; Created on 23 June 2021
24. Joomla CMS: Register to Read More: / Joomla /; ... engine to also ignore permissions so that the article can still be indexed in global search engines such as Google. How? It's been difficult to search for the right words but heres the method to ...; Created on 11 April 2020
25. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... from a 7 year old post; but now you can apply a containsIgnoreCase function to search the records: ... l_ProductDetails = Product[Product_Name.containsIgnoreCase(v_Name)]; ... Lastly, there ...; Created on 21 November 2019
26. Display Feeds to major Social Networks: / Web-Development /; What? A quick article on how I displayed feeds from the company's social network pages in one page. Why? There are 3rd-party apps that let you do this, some paid, some not. This was for a staff ...; Created on 16 May 2016
27. Import Excel CSV file as JavaScript array: / Excel /; ... row Account for strings containing double-quotes (and commas to ignore) Sort the resulting object array How? The function with comments: - Uses deprecated XMLHttpRequest to get file ...; Created on 05 October 2015
28. TravelPort Universal API - Ping Request with PHP-cURL: / API Miscellaneous /; Applies to: TravelPort Universal API PHP 4 or 5 cURL What? An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using ...; Created on 27 April 2015
29. MySQL: Find all non-alphanumeric rows: / MySQL /; ... -- return all records that contain non-alphanumeric characters SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9]+$'; -- return all records that are non-alphanumeric but ignore underscores SELECT ...; Created on 09 September 2013
30. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... Source: Ignore failure on Truncate, Output "KeyColumn" and "DataColumn". Derived Column Task: Trim and Replace special characters from "DataColumn" and "KeyColumn". Conditional Split Task: Check keycolumn ...; Created on 23 April 2013
31. Preg_Replace all strings between two tags: / Personal Home Page /; ... Surround string (apostrophes) with red styling but ignore escaped apostrophes: Convert: this='joe\'s string' » this='joe\'s string' $string_formatted = str_replace('\\\'', '\\\'', $string_formatted); ...; Created on 07 February 2013
32. Background Gradient Disappears on Long Pages: / Cascading Stylesheets /; What? This is a quick article on how to resolve the following issue: Overall body background color is blue. Background color of my contents is white. When I visit a small page on the site, the ...; Created on 20 November 2012
33. Migrate JComments from Joomla 1.5.x to Joomla 2.5.x: / Joomla /; ... _jcomments_settings -- ignored as this will load factory settings -- -------------------------------------------------------------------------------- /* INSERT INTO mydb_upgrade_j25.myprefix_jcomments_settings ( component, ...; Created on 07 June 2012
34. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... 3. Add an SSRS parameter Idem as in just specify a parameter as you would for any usual SSRS report. (Ignore my 2nd and 3rd SSRS parameters in my example as I didn't end up using them) 4. Add a ...; Created on 19 January 2012
35. Sort order a dropdown list in MS InfoPath without programming: / Infopath /; So this is for Microsoft Office Infopath 2007 (SharePoint 2007). The situation is that I started creating a SharePoint List (datasheet) and when I made my form dropdown read from the list, it just ...; Created on 21 July 2011
36. Joes Bug Tracker (JBT): / Product Documentation /; ... Permanent URL for this page (must ignore SEF, eg. "?option=com_joesbugtracker&id=") --- Display/Access based on User level --- Free-Text Changelog or Auto-generate - Added Admin Section: Manage Files ...; Created on 07 July 2011
37. Win32 Constants: / AutoHotkey /; ... MNC_IGNORE = 0 Const MNC_CLOSE = 1 Const MNC_EXECUTE = 2 Const MNC_SELECT = 3 ;#End Region ;#Region Background Mode Const TRANSPARENT = 1 Const OPAQUE = 2 ;#End Region ;#Region ListView ...; Created on 05 July 2011
38. Joes FREE Website Thumbnailer (JWT): / Product Documentation /; ... pictures. If you are batch processing a text file, you need to separate the website address and the given name with a pipe character ("|" - see "TEXT file example" mentioned earlier). It ignores space ...; Created on 28 June 2011
39. Formatting a date in an MDX query: / Transact-SQL /; ... as long as I did searching the web for a solution, then ignore all the above. Another built-in function is the text-formatter =Format(Fields!myDateTime.Value, "M/d/yy") ... 6/15/09 =Format(Fields!myDateTime.Value, ...; Created on 11 January 2011
40. Connection Strings for SQL Server: / SQL Server /; ... is the port value of -1 that tells the driver to use named pipes network protocol. This is available on Windows only. The value is ignored if Unix socket is used. Multiple servers Use this to connect ...; Created on 05 January 2011