Search - Joel Lipman .Com

1. JavaScript: / Category /; Created on 05 March 2020
2. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; What? This is an article documenting how to create a Zoho Creator Widget which includes the Bootstrap and jQuery frameworks as well as other JavaScript functionality. Why? Quite simply that at ...; Created on 24 October 2020
3. Import Excel CSV file as JavaScript array: / Excel /; ... convert to a JavaScript array of objects var my_object_array = [ , , ]; What I want again: Read a CSV file already uploaded with JavaScript Populate a JS array with each ...; Created on 05 October 2015
4. Sort an associative array by values in Javascript: / JavaScript /; What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. ...; Created on 29 September 2015
5. VBScript to retrieve Windows Product Key: / Windows OS /; What? A quick article with the code to retrieve your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as ...; Created on 23 September 2015
6. SSIS: Add Reference Microsoft.SqlServer.TxScript: / SQL Server Integration Services /; What? This article is so that I don't spend so long in googling what the TxScript referenced assembly is when creating an SSIS custom component. How? This is simply the "Script Component" under ...; Created on 03 June 2014
7. Export Joomla Users script: / Joomla /; ... allows the passwords to be in MD5. All I want is a quick bit of code to get all the users out of a Joomla CMS. How? I could just type a query on the database and get the same result, but this script ...; Created on 28 February 2014
8. SSRS Subscriptions cannot be created: / SQL Server Reporting Services /; Applies to: Microsoft Business Intelligence Development Studio 2008 (BIDS) Microsoft SQL Server 2008 R2 What? This article describes solutions to the error: Subscriptions cannot be created ...; Created on 22 November 2013
9. Problem creating SSRS report subscriptions: / SQL Server Reporting Services /; What? A quick article on if you are trying to create a new subscription to a SQL Server Reporting Server (SSRS) report and you are getting a warning message similar to the following: Message from ...; Created on 11 November 2013
10. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... (do they ever?). The script must be able to be copied into other SSIS packages. Need the option to merely tick input column names rather than hardcode these. "It " should be an acronym for IT, so "I ...; Created on 04 October 2013
11. Inline Labels in Form Fields using Javascript: / JavaScript /; ... still in use. I needed a back-to-basics solution and this is the one I have used since my fad of JavaScript 1.2 in the 90s. For broader compatibility, this is my recommended solution. How? We're ...; Created on 21 August 2012
12. Connect to Joomla database in standalone script: / Joomla /; APPLIES TO Joomla 2.5.x Why? I'm building a Joomla component which is to be compatible with Joomla versions 1.6.x to 2.5.x. Because I use dynamic scripts running in the background (mootools), some ...; Created on 17 August 2012
13. Basic Webpage Controls with JavaScript / COM: / JavaScript /; ... with JavaScript / COM This tutorial requires one of the following:AutoHotkey_L - has built-in COM Support (recommended)the COM Standard Library - for use with AHK BasicPurpose The purpose ...; Created on 05 July 2011
14. This file contains HTML or script code that may be erroneously interpreted by a web browser: / Hypertext Markup Language /; The Error: This file contains HTML or script code that may be erroneously interpreted by a web browser This is a common error when uploading files that the MediaWiki system does not allow. By making ...; Created on 08 October 2009
15. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; What? This is an article documenting how to send a Zoho Deluge Map request to an API which is expecting nested/2d/multi-dimensonal arrays. In the example below, we are posting to a PHP script for testing ...; Created on 03 February 2021
16. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... v_LineItem_Name = r_QuoteDetails.Product_Name; v_LineItem_Desc = r_QuoteDetails.Product_Description; v_LineItem_Price = r_QuoteDetails.Product_List_Price; v_LineItem_Quantity ...; Created on 06 December 2020
17. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... = Notifications[ID == v_NotifyID]; v_Text = r_NotifyDetails.Title; v_Content = r_NotifyDetails.Content; To close the dialog on the receiving page, you can add the following code: openUrl("#Script:dialog.close","same ...; Created on 06 November 2020
18. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; ... is written at a time when Javascript or interactive pages that change on the fly based on a mouse event in Zoho Creator automatically get removed on Save/Update of the page. The following uses the built-in ...; Created on 22 October 2020
19. Expecting ZC_SUBFORM_250 expression found COLLECTION: / Zoho /; ... error you may get when using the deluge script is: LIST value cannot be assigned to 'mySubform' -- or -- COLLECTION value cannot be assigned to 'mySubform' How? Quite simply the error is because ...; Created on 19 October 2020
20. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... sometimes it won't. Escaping the ampersand with a backslash or url encoding to %26 wasn't working for me. I spent several hours trying to write a script that could search for the existing records by company ...; Created on 28 August 2020