T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 me replying "why would you want to do that?". Anyway, I was looking for something like the record separator in Oracle SQL*Plus where a row of data (blank or made of symbols) separates two sets of data from within the same select query based on a column...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 v2008 (BIDS) SQL Server Reporting Services v2008 R2 (SSRS) Oracle SQL Developer v3 (you can use any equivalent, eg. SQL*Plus) Why? I think this is one of those very rare occasions that Microsoft people can say "it's so much easier using a Microsoft...

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

Regular Expression Basic Usage Exampleshttps://joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 expression matches all of the following sequences: abc adc a1c a&c The expression does not match: abb One or More — Plus The one or more operator '+' matches one or more occurrences of the preceding expression. For example, to find one or more...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Zoho Deluge: Setup an API Connection for InvokeURLhttps://joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 on "Create Now" on the appropriate box. If this is not your first app, just select "Server-based Applications", then on the plus icon to add new client. Fill in the new form to Create New Client: Client Name: put something descriptive so it is easy to...

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

Tagliatelle alla Carbonarahttps://joellipman.com/articles/_other-misc/tagliatelle-alla-carbonara.html

07 July 2009 1cm/½in wide 100g/3½oz unsalted butter 150ml/5fl oz white wine 6 free-range egg yolks 50g/2oz parmesan, freshly grated, plus extra for serving 50g/2oz aged pecorino, freshly grated salt and freshly ground black pepper 350g/12oz egg tagliatelle Method 1....

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

Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 receives whatever licenses to the work the party's predecessor in interest had or could give under the previous paragraph, plus a right to possession of the Corresponding Source of the work from the predecessor in interest, if the predecessor has it or...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

JDatabase: using the Joomla database with exampleshttps://joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source: http://docs.joomla.org/ for v1.5.x and for v2.5.x...

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

Access MySQL databases using Oracle SQL Developerhttps://joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 and click on Add Entry... Select the JAR file you downloaded earlier Create a new database connection (or click on the plus sign in the connections tab), select the mySQL tab and complete the login details and host location... Done! Additional I...

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

T-SQL Conversion failed when converting the varchar to data type inthttps://joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 failed when converting the varchar value ', ' to data type int My issue was silly T-SQL concatenation which requires plus signs and thinks it's super clever when it tries to add a number and a string together; then remembers it's a Microsoft by-product...

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

MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 files. /PURGE :: delete dest files/dirs that no longer exist in source. /MIR :: MIRror a directory tree (equivalent to /E plus /PURGE). /MOV :: MOVe files (delete from source after copying). /MOVE :: MOVE files AND dirs (delete from source after...

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

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

14 December 2016 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 'Manually configure server settings'. Configure server settings complete as per the image below...

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

Zoho Deluge - Get English Ordinalhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-english-ordinal.html

08 November 2018 Method #4: Combining method 2 & 3, we can reduce getting the ordinal to 2 lines plus the output: v_NextRenewalDate = '2018-11-06'; v_ThisDayDate = v_NextRenewalDate.toString("dd").toLong(); v_ThisDayDateLastChar =...

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

Zoho Deluge - Get Refresh/Access Token API v2https://joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 Professional Edition: 10000 + (Number of User licenses x 500) API calls/day [Maxiumum 500,000] Enterprise/Zoho One/CRM Plus: 15000 + (Number of User licenses x 1000) API calls/day [Maximum 1,000,000] Ultimate Edition: 15000 + (Number of User licenses x...

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 from the form invoking it but for generic messages you could get the "Notify" page to read from a form/report: Click on the plus icon to create a new form Select a blank form, let's call it "Notifications". Drag a single-line field and a multi-line...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 rather than getting my client to do this. The aim is to take up as little time as possible of the third-parties involved, plus the documentation online was in parts and requires going to several pages across the Internet. Here I have 1 page and 1...

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

Windows OS: Alt Codes / Symbols / Special Charactershttps://joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

03 June 2021 ƒ Dutch Florin 0131 ¤ Generic currency symbol 0164 Mathematics ÷ Division sign 0247 ° Degree symbol 0176 ¬ Not symbol 0172 ± Plus/minus 0177 µ Micro 0181 ‰ Per Mille (1/1000th) 0137 Website © Copyright symbol 0169 ® Registered symbol 0174 ™ Trademark...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Zoho Creator: Receive JSON via a Shopify Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 record, parsing the JSON webhook response beforehand. 1. Set up the Creator form Log-in to your Zoho Creator app Click on Plus sign to add a new form > blank Name the form, I'm going to call mine Shopify Webhook Payloads Drag some fields onto the form,...

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

Zoho Creator: Radio group into Calendar Carouselhttps://joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 Day Select). The key to remember here is that it isn't a week commencing date but more like the today's date minus 7 or plus 7 days depending on which way they navigate. We then need the offset so that when a user clicks on the #9 entry, the system will...

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

Zoho Deluge: Generate a loop or list of any sizehttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-a-list-of-any-size.html

21 October 2022 the string to start with, the second is the number of spaces to pad with. // // set number of times to iterate through loop (plus 1) v_CheckDaysAhead = 7; // // create a string with this many spaces using leftpad v_GeneratedList = leftpad(" ",...

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

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 time of print and although the solution below only connects to the OpenAI API, it is not currently connected to ChatGPT. The plus side however is that it is connected to the Internet unlike ChatGPT which only has information up to 2021. How? The basics...

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