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 ...
... by checking the datatypes for each field in the concatenation string:
LTRIM(RTRIM(rm.Name + ', ' + rm.[Zone] + ', ' + CONVERT(VARCHAR(4), rm.[Capacity]) + ', ' + rm.[Type] + ', ' + rm.[DeptId])) AS RoomDetails
/ ...
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.