What?
A quick article on how to debug some errors in Zoho.
Why?
I wanted a general note to list certain errors that we get when we do certain things in Zoho but didn't want to write a separate ...
... to work using Zoho Deluge.
How?
There are a number of combinations that I won't have thought of but the below code sufficed for my current task, common English and some European names:
//
// ...
... r_InvoiceDetails;
Common Error(s):
,"message":"required field not found","status":"error"} is because you did this:
r_CreateCrmQuote = invokeurl
[
url :"https://www.zohoapis.eu/crm/v2.1/Quotes"
typ ...
What?
So this is an article documenting how to create an on/off toggle switch that hides and displays between 2 div layers in a Zoho Creator Page (so not a form or report but a page).
Why?
This ...
... to do this so often that it deserves an article. Though writing a whole page for this is probably unwarranted so I may rename this article later to common things I need to do in Zoho Deluge.
How? ...
What?
So this is an article with some common snippets of code that use the InvokeConnector and do things we can't do in shortcode.
List CRM Users (ActiveUsers)
Note that this is somewhat superseded ...
...
Common Error(s):
: 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 any new one expires any previously generated ones. A code ...
... and compatibility with future AutoHotkey releases.
#Warn ; Enable warnings to assist with detecting common errors.
SendMode Input ; Recommended for new scripts due to its superior speed and reliability.
SetWorkingDir ...
Applies to:
TravelPort Universal API
PHP 4 or 5
cURL
What?
An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using ...
...
And one more time for a more common purpose where it converts a string of words delimited by commas to a table:
CREATE FUNCTION [dbo].[ufn_CommaStringToTable]
(
@CommaSeparatedValues ...
What?
So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...
... Visual Studio 10.0\Common7\IDE\devenv.exe"
for Start In..., I leave this blank but you could specify a working directory.
OK the dialogs and close the Task Scheduler
Right-click on an empty ...
What?
In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common. ...
... and the data types will be correct and maybe they'll resolve issues faster than if they were given scrambled data (see my articles on DataJumble and DataScramble).
How?
CREATE PROCEDURE [Common].[usp_ScrambleMultivalue]
(
@TableName ...
... of this page.
Go go go
Note that in the following examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one.
-- drop a stored procedure if it exists
IF ...
This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed ...
... rest of my colleagues installed it however, they decided to use a common local directory for all workstations so configuration files would not need to be modified.
So?
Once installed, my BIDS install ...
... which marks rows (identifying when a separator is needed) but this works. Inspired by Namwar Rizvi's blog, I wrapped my SQL query within a common table expression:
--Create CTE
WITH tblDifference AS
(
SELECT ...
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.