PHP & MySQL Search Enginehttps://joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 returns, line feeds, tabs and double-spaces # for mediawiki $str = str_replace('=', ' ', $str); // replace any equal signs with a single-space $str = str_replace('"', ' ', $str); // replace any double-quote signs with a single-space $str =...

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

Is it a scam? Gumtree.com's warning signshttps://joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 upfront. Remember, be wary of overseas sellers. Source: http://gumtree.force.com/Help/articles/General_Information/Warning-signs

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

SSRS Use T-SQL Like with a Parameterhttps://joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 rb WHERE rb.[GivenDate] BETWEEN @GivenDate AND @ToDate AND rb.[ContactName] LIKE '%'+@GivenName+'%' --WORKS! Enclose percent signs as strings. For anyone that thinks there exists stupid questions, here's a silly answer which I hope helps!

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• 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

A quick run through of setting up an export process in SITShttps://joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 run. In our demo, the link value uses all three primary keys of the CAP entity. They can be separated by double hashes/pound signs or a single tilda with the keys enclosed by double chevrons. Add the DataChange-out-tray Rule Element (DRE) records by...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

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

09 March 2022 v_Css = v_Css + ""; input.Form_Css = v_Css; } But wait we're not finished as there are the chevrons / less-than greater-than signs options to program into. For this simply append the following: else if(input.Calendar_Day_Select == "<") { // // set...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 button "Send Credit Application" off the contact record Sends ZohoSign template off to contact email Contact completes and signs the form via ZohoSign ZohoSign on completion triggers worklow from within ZohoCRM ZohoCRM webhook updates the tracking...

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