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

25 March 2024 but as I'm not downloading it, this is apparently not the process. How? As a high-level overview: we'll generate the CSV rows and then a file; then we'll use invokeURL to upload the file. Generating the CSV Here's the simplified code to generate the CSV...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttp://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 (Zoho Survey)" r3 ON r2."ID" = r3."Respondent ID" LEFT JOIN "Pages (Zoho Survey)" p ON r."Page ID" = p."ID" LEFT JOIN "Rows (Zoho Survey)" r4 ON q."ID" = r4."Question ID" WHERE p."Title" 'GENERAL' ORDER BY "Response Date" DESC, "Attempt ID", "Page...

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

SSRS Use T-SQL Like with a Parameterhttp://www.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%' -- WARNING: 0 matching rows This returns nothing. Took me a while to figure why but it's the parameter that's the issue. You don't enclose it with...

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

SQL: Use CASE for Relevance columnhttp://www.joellipman.com/articles/database/mysql/sql-use-case-for-relevance-column.html

03 August 2013 to myself as I was playing with the relevance heuristics of a query. This example adds a column of relevance and sorts the rows accordingly. How? This has to be a real quick one for a dropdown search field which has to find relevant terms to...

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