Fix Oracle Tnsping 3511 without Windows Registryhttps://joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 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 on "Environment Variables" Under "System Variables" modify the variable...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Reorder Columns in a Tablehttps://joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 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 so I guess this has to be included: ALTER TABLE table_name MODIFY COLUMN misplaced_column BIT(1)...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: *

SSIS: How to loop through multiple flat files as data sourceshttps://joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 and select it. Set the connection manager name, specify columns as per usual. OK the connection manager and display its "Properties" Under Expressions, click the ellipsis Under Property, select "ConnectionString" In Expression, type...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Android: Keytool and Google Maps displaying greyhttps://joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 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 system settings Select the Advanced tab Click on the Environment Variables......

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

Accessing Apimo WebService APIhttps://joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 a complete PHP script of a more complex example of 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...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Windows Live Mail Error ID: 0x8DE00005https://joellipman.com/articles/microsoft/windows-os/windows-live-mail-error-id-0x8de00005.html

14 December 2016 Deactivate the account by deselecting "include this 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 and tick...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 and click 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"...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 a validation custom function: Login to ZohoPeople as an admin, Go to Settings > Customization > Forms > Leave Under "Form Properties" > Tick the box under "Validation" for "Custom Validation" to create a function: Ensure you select parameters to input...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttps://joellipman.com/articles/crm/zoho/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

27 July 2021 field. 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()"). Standard as for any usual form without a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 order. Method #3: Use an eTag I use to use an eTag for a database-driven system 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...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 "Title" (used as a multi-line cannot be used in the listview). Add a multi-line field called "Content" and change the properties on creation to allow 32000 characters. Keep the email field called "Email" Return to the Context Handler Function IDE (page...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://joellipman.com/articles/crm/zoho/zohocrm-get-organization-business-hours-via-deluge-api.html

28 March 2023 collection rather than inserting the collection into the subform using insert(). Invalid update task found corresponding properties: Trying to update a time field with a string is a no go. Set it to an atom time or nice SQL date/time (eg. "yyyy-MM-dd...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Change System Field Lengthhttps://joellipman.com/articles/crm/zoho/zoho-crm-change-system-field-length.html

19 June 2023 the layout (eg. "Standard") Click on the ellipsis/3 dots icon of the system field you want to hack and select "Edit Properties" Right-click on the "Number of Characters allowed" field and select "Inspect Element" Expand the DIV the field is in and...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 = "Test 1,Test 2,Test 3".toFile("test.csv"); f_TestFile.setParamName("file"); // // found if you open the report properties and select rename from the vertical ellipsis icon in the top right v_ReportLinkName = "All_Weekly_Calendar_Caches";...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Render to PDF with margins and page numbershttps://joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 + " "; if(c_Quote.Special_Edition.containsIgnoreCase("yes")) { v_ItemDescDisp = "SPECIAL EDITION "; } // // other properties to add to the description v_ItemDescDisp = v_ItemDescDisp + "Awesome Reason To Buy This #1 "; v_ItemDescDisp = v_ItemDescDisp +...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 dot notation: if (parsedOutput && typeof parsedOutput === "object") { // If the output is an object, you can access its properties document.writeln(parsedOutput.details.output || " Error: No parsed output found "); } else { // If the output is not an...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Windows 7 and Google Chrome incognito mode by defaulthttps://joellipman.com/articles/google/windows-7-and-google-chrome-incognito-mode-by-default.html

24 March 2010 on the Google Chrome icon in your taskbar Right-click on Google Chrome option in the context menu Left-click on Properties Add the word -incognito (including the hyphen/dash) to the end of the Target value Ok that and see if it works Note that if in...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

SSRS Border Problemhttps://joellipman.com/articles/microsoft/ssrs/ssrs-border-problem.html

20 January 2014 cell (top-left), hold down the shift key and click on the last cell (bottom-right). This selects all cells. Now open the "Properties" pane, find the "BorderStyle" and type the word "None" next to it (as its value). Press the "Enter" key if you need to....

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SSRS Change Background Color of Imagehttps://joellipman.com/articles/microsoft/ssrs/ssrs-change-background-color-of-image.html

08 April 2014 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 image can be an expression as well (I embed these and then refer to them in the expression...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB