Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-push-multi-select-picklist-containing-commas-from-crm-to-creator.html

20 April 2020 What? A very quick article on how to push a multi-select picklist from CRM to Creator. Why? We're trying to create a record in Creator off a button on the CRM Potential/Deal record. The CRM module has a multi-select picklist which will use commas to...

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

Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 in a table EXEC SearchTables @Tablenames = 'T1' ,@SearchStr = '%TEST%' The above sample searches in table T1 with string containing TEST. 2. To search in a multiple table EXEC SearchTables @Tablenames = 'T2' ,@SearchStr = '%TEST%' The above sample...

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

T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings in a database and rather than a separate file, it stores...

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

ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 first the preparation of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well: Note that any IDs used in the snippets of code or screenshots...

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

Anti-Spam override for all submitted datahttps://www.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

03 February 2010 hopefully be able to keep it simple for non-programmers. The tweak below will stop any of your pages submitting content containing your banned words. We're going to modify a file containing 2 lines of code by default. The file is index2.php in your...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 -- 6) Correct internal Joomla links to categories -- 7) Update com_user (J15) as com_users (J30) -- 8) Update links containing view=frontpage (J15) to view=featured (J30) -- Affects: #__menu_types, #__menu --...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 on the options you set under "Tools > Options". When it's done it will popup an alert and then try to open the folder containing all the images it just created. Take a picture Go to Tools > then select "Take a picture". Wait a few seconds (default is...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 Allowing me to simply tick columns to apply this to (note that some of the images have been censored due to this project containing sensitive data): Script Component Task: Select Type Script Component Task: Transformation: Data Viewers Script...

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

XML Schema Referencehttps://www.joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 in complex type definitions choice Allows only one of the elements contained in the declaration to be present within the containing element complexContent Defines extensions or restrictions on a complex type that contains mixed content or elements only...

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

AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 Windows 7 Professional ; AutoHotkey: v1.33.02 ; Author: - ; Description: This program will remove the word EDIT and words containing an underscore (eg. 01_23) ; and then add an increment to the file name if a file with the same name exists. ; ; Date...

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

Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 This is an article to document how to include a subform and rows while you are creating a record containing the subform. Why? The use case here is for a Quote Builder in Zoho Creator: Create a quote record and include a subform containing the line...

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

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 the dataset. For the moment, I want the user to be able to select a date and then the report to return the month containing that date: I'm going to change the header from "Reinventing the wheel" to the Month and Year based on this parameter: Note that...

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

SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 (all MORNING!) so I went with solution #2 (above) and added the OR clause to all my dataset queries and joined the table containing the other parameter (@StudentADAccount) in each dataset query, which slowed it down a little but the requirement was met....

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

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 button (textbox which actions to the previous report with same parameters) and another link which leads to our report containing the call to the Stored Procedure. This page itself contains a basic dataset query just to check with the end-user: Note that...

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 a textbox that will be visible on the executed report (obviously replace the field name with the name of your field containing the location of the image - ours is "PhotoURL"): =" The file " & First(Fields!PhotoURL.Value, "PhotoDetails") &...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

List MediaWiki Articleshttps://www.joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

22 September 2011 My custom query To list access levels (this needs to check categories with access levels table), I have a separate table containing the wiki categories associated with local wiki groups (required to view the category): Page ID, Title, Content, Category,...

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

SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

07 November 2011 AND Fields!NOTALPHANUMERIC.Value=0, "Valid", "Not Valid" ) Additional If like us, you've made a report containing a link dependent on parameters submitted, we had to apply a similar IIF statement block to the Font color and the Action target as well...

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

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

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 overlap the item beneath it (in this case #2) so when a user clicked on #2 they would in fact be clicking on the item containing the asterisk above it. Objective Box List Before: Box List After * 1 2 3 * 1 2 3 How? Decrease the line-height of the...

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

T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 values which we found we could do with the built-in SOUNDEX function. How? Lets assume the following, we have a table containing: StudentID StudentDetail Soundex ----------------- ---------------------- ----------- 1 Data not yet available D300 2 Data...

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