What?
A quick article on how to count within a map. I didn't have too much difficulty getting this to work and I'm not sure if there are better ways of counting so I'm documenting it to see if I can ...
... = ceil(v_MaxCount / v_PerPage);
info v_Pages;
Call with datetime criteria:
NB: You can't compare a date time value to a field that is simply of datatype: date
v_PerPage = 200;
v_CountCriteria ...
... an Integer/Long/Number datatype
As the first part of your code, enter the following as code (you'll need to speify your own App Owner and App Name):
//
// ************************************************** ...
... to integers when the datatype is an integer and not a decimal:
// syntax:
// v_Test9.round(2);
// round(v_Test9, 2);
v_Test9 = 10.0;
info v_Test9.round(2);
// yields 10.00
v_Test10 = 10;
info ...
... Map datatype.
How?
I'm not going to go into detail on how I create an access token to query the eBay Trading API as you can read this in my article: Joellipman: Zoho Creator: Push to eBay Listings. ...
... Deluge.
How?
We're going to make use of the .toLong() function applied to a datetime datatype variable which will return the Unix seconds.
// the now time
v_NowTime = zoho.currenttime;
//
// ...
What?
A very quick article to show pushing the date and time to ZohoCRM or ZohoCreator.
Why?
You may have received an error that goes something like:
datatype: datetime
How?
Here are ...
... thought of an alternative that I now use frequently in client systems.
How?
The gist is that we add a checkbox called "Processed" which will have a datatype Boolean. Our function will then loop ...
... when I create a workflow, it will ask me to run a function, the Creator workflow process will then read what datatype of a parameter I'm sending to the function.
So in "Edit this application" > go to ...
What?
This is a quick article to demonstrate how to compare two datetime values with the timezone specified.
Why?
A client's ZohoCRM had a different timezone setting than the user a script would ...
What?
A quick reminder on how I got a working snippet of code to store the entries in the lookup already selected, check against another table/form for valid options, repopulate the list with the selected ...
What?
A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache ...
... for Datatypes
Constraint Description
enumeration Defines a list of acceptable values
fractionDigits Specifies the maximum number of decimal places allowed. Must be equal to or greater ...
Applies to:
Microsoft Windows 7 Enterprise
SITS:Vision Students (v8.7.0)
What?
You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the ...
... AS XML).value('(/STAFF/GENDER="MALE")[1]','VARCHAR(10)')='TRUE' AS Gender
-- Returns records where GENDER = "Male"
More Examples (Note that Event_XML is of datatype XML in the following examples): ...
... string errorMsg1 = "Invalid datatype for . Inputs must be DT_STR or DT_WSTR";
string errorMsg2 = "Invalid usage type for . Inputs must be READWRITE";
// Check whether ...
...
Method #3
And a further enhancement which lists the different datatypes, is_nullable, maxlength and collations side-by-side:
-- all columns side by side
SELECT
t1.TABLE_CATALOG AS [DB1_Name],
t2.TABLE_CATALOG ...
...
All SQL
-- Add a column to an existing table (giving it datatype char(2) and allowing NULL)
ALTER TABLE myTable ADD myColumn CHAR(2) NULL
-- Delete a column
ALTER TABLE myTable DROP COLUMN ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.