Getting the mysql where in delimited string to workhttps://www.joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when converted to...

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

DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 1968-05-05 4 otentre AhYe Usr 1964-08-08 Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Used to reference RAND with in a function CREATE VIEW dbo.vwRandom AS SELECT RAND() as RandomValue; GO...

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

Copy a table with structure and data into a temporary tablehttps://www.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 END GO -- Usage: -- EXECUTE dbo.usp_MakeTableTemp 'mySchema.myTable'; Post-Notes Added a dummy index to track row numbers. Copies structure (column_name, data_type, character_maximum_length) Copies data (should be exact copy)

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

Vertically align an asterisk on a linehttps://www.joellipman.com/articles/web-development/css/vertically-align-an-asterisk-on-a-line.html

02 September 2012 I have an unordered list of values (*, 1, 2, 3...) and for styling reasons I want the asterisk to be the same size as the numbers but not overlap any list item beneath it. By increasing the size of the asterisk, this often increases the line-height and...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 4 RJDsFMaeNcLrcMWw 1964-08-08 How? Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Drop the view if it already exists IF OBJECT_ID ('vwRandom', 'V') IS NOT NULL DROP VIEW vwRandom ; GO -- Used...

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

SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 they see the error they programmed in. Apparently this problem also happens when you have a Data File of varying column numbers. My solution below will also fix this. How? My data file had some empty rows amongst the data. The easy fix is by dealing...

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 you to change name and photo) Tap on the Manufacturer or Model name under "Specification" to change the details (lots of numbers!). Tap on Quick Reference image to change image. (if you have a different led, you can take a picture or use a screenshot...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Android: Replace return key with done, go, send...https://www.joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 } return handled; } }); Other Noteworthy Actions android:inputType In some cases, this will change the keyboard layout (eg. Numbers) text // Normal text textNoSuggestions // No suggestions/autocorrect textEmailAddress // valid email address...

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

Excel: convert degrees minutes seconds to decimalhttps://www.joellipman.com/articles/microsoft/excel/excel-convert-degrees-minutes-seconds-to-decimal.html

06 November 2014 Air Base 39°48′40″N 116°42′30″E 39 48 40 N 116 42 30 E 39.81111111 116.708333333 39.81111111 116.7083333 Note that negative numbers should be supported. I tend to use Excel to reduce the decimal point to only 7 decimal places (for importing to a...

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

Sort an associative array by values in Javascripthttps://www.joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 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. The original code is not my own either but that's...

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

URL Alias uniqueness with PHP & MySQLhttps://www.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 the PHP $p_Name here is the title of your article or product that will be changed into a string of only letters, numbers and underscores. Note that the PHP doesn't need a database connection here: function getUrlAlias($p_Name){ // lowercase and trim...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho CRM & Zoho Books: Get Books Currency and Tax IDshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-books-currency-and-tax-ids.html

24 September 2021 is that we are creating a Sales Order in Zoho Books from Zoho CRM and want to map the correct currency and tax by their ID numbers. How? Using the REST API and InvokeURL in Zoho Deluge to look at Zoho Books. This uses up an extra 2 calls so you could...

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

Zoho Creator / Shopify: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-get-all-active-products.html

12 October 2021 + "]"; info l_ProductIDs.size(); } Yields something like: [ 1234567890123, 2345678901234 ] 2 Well that produces a lot of ID numbers delimited by a comma. However, to match my use-case, I want a list to which I can give it an SKU, and it returns the...

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

GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 CPanel and went to the SSL/TLS manager and clicked on "Manage SSL sites" Opened the first certificate file (the one with numbers, letters with extension CRT), copied the contents to clipboard then pasted under "Install an SSL Website" into the...

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

Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

17 August 2022 { // // invalid searches will return 200 results non-matching, so let's double-check if(r_Result.get("invoice_numbers").containsIgnoreCase(v_InvoiceRef)) { // retrieve payment mode, amount and date v_PaymentMode =...

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

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

21 October 2022 Why? My use case here is to run a schedule that will populate a list with the upcoming dates for the next week (and for any numbers of weeks thereafter). This needs to be dynamic as it is a schedule run daily checking the availability of a staff member...

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

Zoho Deluge: Get the Week Number if Week starts on a Mondayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html

06 July 2023 2019 dateValue = '29-Dec-2019'; info dateValue.toString("YYYY"); // returns 2020 You should also pad single digit week numbers if we're going to store a year week value: v_ThisCurrentWeekNumber = if(zoho.currentdate.toString("u").toLong() ==...

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

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

25 March 2024 the ID in double-quotes in case I open it in MS Excel or another system that likes rounding 64-bit signed integers (long numbers): // // Generate a CSV of a Report in ZohoCreator l_CsvLines = List(); l_ApplicableProducts =...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://www.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 validation challenge code. In the Verification token field, enter a unique 32–80 character token containing only letters, numbers, underscores (_), or hyphens (-), which eBay uses to verify ownership of your endpoint. After entering your Notification...

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

ZohoBooks: Broken UK Banking Feedhttps://www.joellipman.com/articles/crm/zoho/zohobooks-broken-uk-banking-feed.html

16 October 2025 the feed means that duplicates will be created. You will need to delete the ones manually imported in order for the numbers to be brought in line. Notes and findings: Integration locks: The “Accounts associated with Integration cannot be marked...

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