Assuming returns is required, the following 90 results were found.
-
SELECT CAST(CAST(Event_XML AS XML).query('data(/STAFF/GENDER)') AS VARCHAR(10)) AS Gender FROM [dbo].[XML_EVENTS] -- Returns column GENDER for every record/row (eg. "Male") Or -- Using .value() SELECT CAST(Event_XML AS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
This is an article to hopefully resolve for you quicker than it took me, why a zoho.crm.searchRecords() returns some of the records but omits others. Why? The use-case was that we were creating a custom related list on a Zoho Finance > Sales Orders...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
a string of words delimited by spaces to a table: CREATE FUNCTION dbo.[ufn_StringToTable] ( @StringInput VARCHAR(MAX) ) RETURNS @OutputTable TABLE ( StringValue VARCHAR(10) ) AS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
What? A super quick article to demonstrate how an idiot like myself can misread the documentation. This particular article shows you how to customize the search results or response from using zoho.creator.getRecordById(). Why? My use case scenario is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
If you are in the administration panel and you are editing your weblinks and you come across this error: "404 - An error has occurred. Joomla! was unable to locate the stated resource." Just check that the category the link is in is published.
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Thought I'd put a note about this as I spent ages rewriting an entire system. The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check. The only solution is to not use it for...
- Type: Article
- Author: Joel Lipman
- Category: Microsoft
- Language: en-GB
-
of a specific week... Just to confuse everyone in the world, the day index for a Sunday is 7 (ie. myDate.toString("u") returns 7) and the week commences on a Sunday (ie. myDate.toStartOfWeek("EEEE") returns Sunday). In other words, the day counting...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
circumflex to exclude the clean alphanumeric rows: SELECT * FROM STUDENTS WHERE REGEXP_LIKE(S_SURNAME, '[^a-zA-Z0-9]') -- returns all rows where the student surname contains non-alphanumeric characters -- eg. O'Brien will be returned SELECT * FROM...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Label: Fn - Workdrive - Host Image Trigger: Off a button / Standalone Purpose: This uploads an image to workdrive and returns a publicly-accessible link/URL for use in your email signatures. Inputs: Loginuser Outputs: Email Scope(s): WorkDrive.team.ALL,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
in a StackExchange site: Method #1 =MATCH(B2, $A$2:$A$100, 0) -- Check whether value in B2 exists in range of A2:A100. -- Returns the index of column A in which the B2 value was found. -- Returns #N/A for a value which is NOT in column A. Drag the...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
If you want to get an element(s) based on limited criteria, you can use the following 3 methods: getElementById(id) - returns a reference to the first object with the specified ID getElementsByName(name) - Returns a collection of objects with the...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
limit: v_CoqlQuery = "select id, Deal_Name from Deals where ((Amount=0) and (Stage != 'Cancelled')) limit 400,2"; // returns 2 deals after the first 400 records // OR v_CoqlQuery = "select id, Deal_Name from Deals where ((Amount=0) and (Stage !=...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
about a company. Unfortunately, if you do this simply using Zoho Deluge in a button, there are no new lines/carriage returns or styling that you can apply, which pops up as a message box to the sales person; but all on one line and not that readable....
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
list to see what custom options you already have. By default you should have one called "wallpaper": /imagine a flower // returns 4 square pictures of a flower /imagine a flower --wallpaper // appends "--w 1920 --h 1024 --hd" // returns 4 pictures of a...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name = My_Date.toString("E"); // returns "Mon" How? Well a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
for aircraft data - [1.8.5] App: theme adjustments - [1.8.5] App: compatibility & stability fixes - [1.8.4] Hangar: factory returns photos as well - [1.8.4] App: theme and style fixes - [1.8.4] App: code improvements - [1.8.3] App: fix to previous fix -...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? Zoho doesn't have a function to generate random numbers or...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
then try this standard function. Note this has only been tested in Zoho Creator rather than Zoho CRM. How? This function returns the distance as the crow flies. Update 2020 Not sure exactly when but Zoho have made available this function in Creator: =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the product exists because it is searching with case-sensitivity enabled. It tries to insert into the product table, but returns the error "Result: Error on Execution" > "Error details: Execution Failed Due to invalid expressions insert statement is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
commas in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a pair of double-quotes. Why? Our use case is that we were trying to loop through rows of a CSV file which...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *