Search - Joel Lipman .Com

1. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... I created to store the record details of properties. It was a quicker way of detecting a change on the record rather than comparing all the fields, compare only 1 value which is a hash or MD5 of all the ...; Created on 19 September 2021
2. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirects: / Zoho /; ... Set the form to reload the existing record when it is submitted (either on "Successful form submission", or on properties "On Successful Submission" > "Direct To", or my favorite, Deluge "openUrl()"). ...; Created on 27 July 2021
3. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... 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 ...; Created on 10 December 2020
4. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... to the file explorer in the Microsoft Windows OS. Why? I had an app for use in MS Windows 7 to display the properties of sound files though this is also applicable to media files in general. ...; Created on 07 August 2020
5. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktops: / AutoHotkey /; ... on the profile, this will create another shortcut on your desktop. Then right-click the shortcut and view the properties, the target will have the profile number: RunWait, "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe" ...; Created on 18 July 2019
6. Windows Live Mail Error ID: 0x8DE00005: / Windows OS /; ... account when receiving mail or synchronising" in the account properties dialog. Add an account by selecting 'Accounts' tab and then clicking on 'Email' with the plus sign. Add your account ...; Created on 14 December 2016
7. Accessing Apimo WebService API: / API Miscellaneous /; ... 1) getting the agencies belonging to a company then 2) getting the properties for each agency: Other Methods Here's the cURL I couldn't get working. Instead I used Apimo's documentation with ...; Created on 29 March 2016
8. Android: Keytool and Google Maps displaying grey: / AndroidOS /; ... Determine your JDK folder dir jdk* and append the \bin. Note this for later. Right-click on the "Computer" icon/label (desktop / start menu) Select Properties Click on Change settings or Advanced ...; Created on 31 October 2014
9. SSIS: How to loop through multiple flat files as data sources: / SQL Server Integration Services /; ... Browse to the first file in the folder to loop through and select it. Set the connection manager name, specify columns as per usual. OK the connection manager and display its "Properties" Under ...; Created on 13 June 2014
10. SSRS Change Background Color of Image: / SQL Server Reporting Services /; ... status) to output: Green (for Success), Red (for Fail), Orange (for Unknown). Right-click on the rectangle and select Insert > Image Edit the Image Properties to specify the image to use. The ...; Created on 08 April 2014
11. SSRS Border Problem: / SQL Server Reporting Services /; ... one border??? How? In Design view, click on the first cell (top-left), hold down the shift key and click on the last cell (bottom-right). This selects all cells. Now open the "Properties" ...; Created on 20 January 2014
12. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... System.Globalization; // for cultureinfo and textinfo using System.Reflection; // for looping through properties using System.Threading; // for threading [Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute] public ...; Created on 04 October 2013
13. Reorder Columns in a Table: / Databases /; ... this: Method: MySQL ALTER TABLE table_name MODIFY COLUMN misplaced_column AFTER other_column; NOTE that annoyingly the column doesn't retain the default properties it had before the move ...; Created on 22 July 2013
14. SSIS Skip Rows in Excel Source file: / SQL Server Integration Services /; ... Properties panel for this. Under Custom Properties » OpenRowset, you should see the name of the Excel worksheet you specified as the datasource (eg. "Sheet1$"). Using the example above: Sheet1$A11:AL12 ...; Created on 04 April 2013
15. Restore MSSQL Error: Database is in use: / Databases /; ... the database to change, and then click Properties. In the Database Properties dialog box, click the Options page. From the Restrict Access option, select Single. If other users are connected to the ...; Created on 08 March 2013
16. Fix Oracle Tnsping 3511 without Windows Registry: / Oracle PL/SQL /; ... Setting environment variables using the Command prompt (DOS) wouldn't stick (session only). My Fix Right-click on "My Computer" > select "Properties" Click on "Advanced System Settings" Click ...; Created on 04 March 2013
17. Administrator Program Shortcut without Prompt: / Windows OS /; ... to display as (eg. "Visual Studio 2010") Click on OK to complete your shortcut. Additional: You can change the icon for the shortcut using the shortcut properties and browsing to the program it ...; Created on 25 February 2013
18. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... has to be listed in the "dataset properties" > "query parameter values" under "Parameter Name" and then the SSRS parameter value (eg. "[@my_ssrs_parameter]"). Internal .Net Framework Data Provider error ...; Created on 19 January 2012
19. SSRS Parameters in Oracle Stored Procedure: / SQL Server Reporting Services /; ... in the next screenshot. Note how all our variables are hidden and cannot be NULL. If you're unsure, right-click on your dataset and bring up its properties... Specify the query type as "Stored Procedure" ...; Created on 02 September 2011
20. Sort order a dropdown list in MS InfoPath without programming: / Infopath /; ... the above it would all work: Open your form in InfoPath Go into Design mode Go to "Controls" and add a Drop-down List Box to your form Right-click it and select "Drop-down List Box Properties" Under ...; Created on 21 July 2011