Assuming stuff is required, the following 29 results were found.
-
FROM dbo.vwRandom; -- prevent invalid dates (specifically 31 days in feb) SET @DateVal = CAST(@RandYear AS CHAR(4)) + '-' + STUFF(@RandMonth, 1, 0, REPLICATE('0', 2 - LEN(@RandMonth))) + '-' + STUFF(@RandDay, 1, 0, REPLICATE('0', 2 - LEN(@RandDay)));...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
FROM dbo.vwRandom; -- prevent invalid dates (specifically 31 days in feb) SET @DateVal = CAST(@RandYear AS CHAR(4)) + '-' + STUFF(@RandMonth, 1, 0, REPLICATE('0', 2 - LEN(@RandMonth))) + '-' + STUFF(@RandDay, 1, 0, REPLICATE('0', 2 - LEN(@RandDay)));...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
checks curl_setopt($ch1, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch1, CURLOPT_SSL_VERIFYHOST, false); // do other curl stuff curl_setopt($ch1, CURLOPT_URL, $GAPIS . 'upload/drive/v3/files?uploadType=media'); curl_setopt($ch1,...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
cumbersome when there are a lot of fields. if(zoho.currenttime > input.DateTime_form_was_loaded.addSeconds(10)) { // do my stuff here } Method #2: Boolean checkbox to switch on/off workflow Another method I tried was adding a checkbox/decision box...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
need REST API url as we're calling it from within CRM) v_AccessToken = standalone.fn_API_GetXeroAccessToken(); // // do Xero stuff if(v_AccessToken != "" && v_TenantID != "") { // set header m_Header = Map(); m_Header.put("Authorization","Bearer " +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
} } info m_ZohoTaxRatesByName; info m_ZohoTaxRatesByRate; // // do Xero stuff if(v_AccessToken != "") { m_Header = Map(); m_Header.put("Authorization","Bearer " + v_AccessToken); m_Header.put("Accept","application/json");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
new DialogInterface.OnClickListener() { public void onClick(DialogInterface arg0, int arg1) { // Some stuff to do when ok got clicked } }) .setNegativeButton("cancel", new DialogInterface.OnClickListener() { public void onClick(DialogInterface arg0, int...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
INT); -- Alter temporary table structure to match given table SET @TableDeclaration='ALTER TABLE #myScrambledTable ADD ' + STUFF( ( -- Code to concatenate column names and data types into one string SELECT CASE WHEN CHARACTER_MAXIMUM_LENGTH IS NULL THEN...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
:= 0x57 DllCall( "SystemParametersInfo", UInt,SPI_SETCURSORS, UInt,0, UInt,0, UInt,0 ) } In this code, the IDC stuff commented out at the beginning is for your reference. You need to include the setsystemcursor() and restoreCursors() functions somewhere...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
prefix corresponds to the COM_ConnectObject() function above Global loading = 0 ; Break the While-Loop } What if all this stuff is too confusing for me? Try this Tutorial written by Mickers which is designed to help non-coders (n00bz) grasp the basic...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
added - [1.6.1] Map: display local governing body - [1.6.1] Map: tooltip for nearby places details - [1.6.1] Help: boring stuff moved - [1.6.0] News: expand for descriptions - [1.6.0] Map: tweaks (tap on icons for details) - [1.6.0] Hangar: section...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
// a,c,e // compared to: for each v_FieldName in l_FieldApiNames { if(!l_ExcludeFields.contains(v_FieldName)) {... do stuff here... } } // notes: // no need to check if element exists on "removeElement" Zoho OAuth Connector Just in case you don't know...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
v_CountFound = v_CountFound + 1; // // other field update if(!isnull(r_Record.get("Account_Name"))) { // do other stuff v_CountUpdated = v_CountUpdated + 1; } // // update the record irrespectively m_Update.put("Processed",true); r_Update =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
// check that there is an ID on this record to avoid looping through error messages if(!isNull(r_Result.get("id"))) { // do stuff to each record... info r_Result.get("id"); } } // // stop looping if less than 200 records on this page...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
!= 0) { r_DealDetails = zoho.crm.getRecordById("Deals",v_DealID,{"converted":"both","approved":"both"}); // // do stuff here such as updating the deal if required m_UpdateDeal = Map(); r_UpdateDeal = zoho.crm.updateRecord("Deals", v_DealID,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Sign
- Language: *
-
staff l_ApplicableStaff = Staff[ID != 0]; for each c_Employee in l_ApplicableStaff { info c_Employee.Name; // // reset the stuff they already have in their subform "Usual Shift" c_Employee.Usual_Shift.clear(); // // great now let's build a ZohoCreator...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
All Rights Reserved the JavaScript These are the contents of main.js and is working at time of print: // Start with Zoho SDK stuff ZOHO.CREATOR.init() .then(function(data) { // Initialize var v_ShopifyID = ""; var v_ShopifyEmail = ""; var v_GreetingName...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
+ " " + v_ThisDateEvent_Hour + ":" + v_ThisDateEvent_Minute + ":00"; // // date and time obtained... do your other stuff here } } } } // // get all future events // NB: status=open are upcoming events; status=closed are events in the past; status is a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
[ url :v_Endpoint_Events type :GET headers:m_Header ]; for each m_Event in r_Events { if(m_Event.get("id") != null) {... do stuff } } Source(s): Zoho Deluge: Difference between isBlank(), isNull() and isEmpty() functions
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
all the rows." Need to include the criteria along with the columns and the "addIfNotExist" attribute Additional / Optional stuff to do but please don't waste your time. Out of sheer boredom: fn_GetMetaData_FormsFields v_NewLine = hexToText("0A");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *