Error 1065: Query was Emptyhttps://joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

13 December 2012 apostrophes is to change these to paired apostrophes, so: INSERT INTO myTable VALUES ('1', 'It\'s amazing!'); -- equally valid INSERT INTO myTable VALUES ('1', 'It''s amazing!'); Bear this in mind when you're implementing anti-injection security features.

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

Problem creating SSRS report subscriptionshttps://joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. Why? The problem happens because of the data source used in the report. For static data source connections, this is...

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

Add attribute xsl:nil=true on empty elements using XSLThttps://joellipman.com/articles/web-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

18 August 2014 1234567 JOEL LIPMAN Two things to do really: Add the xmlns:xsi namespace in the xsl:stylesheet tag so that "xsi:nil=true" is valid. Test for a string length of greater than 0 (not blank) and change the attribute of the element so that it's tag displays...

• Type: Article
• Author: Joel Lipman
• Category: XML Stylesheet Language Transformations
• Language: *

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 different entities, just use the parent/root entity, usually STU) XML is case sensitive so bear this in mind, tick the "Valid for Export" and decide whether blanks are included in the output or not. Select and right-click on the entity and select "Edit...

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

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

03 November 2014 the keyboard layout (eg. Numbers) text // Normal text textNoSuggestions // No suggestions/autocorrect textEmailAddress // valid email address textPersonName // name of a person textPostalAddress // standard postal address textPassword // password type...

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

Joes Search Module (JSM)https://joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 Module" (or "JSM"). Other Areas: One of the parameters is entitled "Search Area". This is the component to search so other valid values are: categories contacts newsfeeds weblinks To determine yours, do a standard search on your website and check the...

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

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

17 July 2019 m_Header parameters:m_Data.toString() ]; // NOTE: convert parameters variable to a string Common Error(s): {"error":"invalid_code"}: Happens if you have a wrong CODE or generated another one after the one you're using. You need to use the latest CODE as...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 Europe // COM for USA] so books.zoho.eu for Europe and books.zoho.com for US. {"code":2,"message":"The request passed is not valid."}: The parameters you are sending are not in the right format. {"code":15,"message":"Please ensure that the attachment...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 item. How? So first of all, you'll need an access token: please visit my article and read the first part on how to get a valid Access Token for the rest of these steps. Once we have an access token, we will check what notifications already exist (if...

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

Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttps://joellipman.com/articles/crm/zoho/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

02 November 2021 maintain the idea above and skip a selected day, I would write something like the following: // // initialize list to hold valid appointment dates l_AppointmentDates = List(); // // initialize Start Date v_GivenDate = '2022-07-21'; // // setup list to...

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

Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://joellipman.com/articles/crm/zoho/zoho-deluge-text-sms-using-twilio-api-localsense.html

16 December 2021 = invokeurl [ url :v_Endpoint type :POST parameters:m_Data ]; } Error(s) Encountered The 'To' number XXXXXXXXXX is not a valid phone number - Resolved: Do not url encode from and to phone numbers (also do not url encode the body/message). Number is...

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

Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-inventory-upload-image-to-item-record.html

21 June 2022 example you don't need the organization ID parameter at the end of the URL) {"code":2,"message":"The request passed is not valid."} The .setParamName() function is setting the data type to probably file or attachment when it should be image.

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

Zoho Recruit: Rollup Number of Recruit Candidates to CRM Accounthttps://joellipman.com/articles/crm/zoho/zoho-recruit-rollup-number-of-recruit-candidates-to-crm-account.html

19 October 2022 + v_SchoolName,1,10,m_Blank,"zcrm"); for each r_School in l_SchoolSearch { // check no search error and valid records are returned if(!isnull(r_School.get("id"))) { // check this record is the same school...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 have that attachment ID in its table already... or updates it if it does. You might want to add to the code to only push valid image file types as files. The report will work for Zoho Users... didn't really test on permissions and sharing the report, I...

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

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

25 March 2024 = "Cached_DataFile"; v_RecordID = c_Check.ID.toString(); // // using API upload file endpoint (either endpoints seem to be valid) //v_Endpoint =...

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 o_Headers); // now parse the output from the function var o_ParsedQuote = JSON.parse(JSON.stringify(r_QuotedRecord)); // valid? note the underscore before the details variable a_QuotedItems = []; if (o_ParsedQuote._code == "SUCCESS") { if...

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

MySQL Commands to display all columnshttps://joellipman.com/articles/database/mysql/mysql-commands-to-display-all-columns.html

28 October 2010 extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. The following is a MYSQL query that displays the structure of all the columns in all the...

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

SSRS Subscriptions cannot be createdhttps://joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. How? I'd like to say that the solution is far more complicated then this, but it isn't. This is one of those rare situations...

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

VBScript to retrieve Windows Product Keyhttps://joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 VB script file. There are other articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example applicable to Windows 7 Professional. Why? With the Windows 10 operating system offered as...

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

SELECT COUNT(DISTINCT name) FROM tablehttps://joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 an error 1054 comes up if you use the above statement. Why? The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but I get what you mean and it's sometimes difficult to explain why you want to use it. How? Method #1: Add an alias to the...

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