Assuming fail is required, the following 22 results were found.
-
but has an ID number, then the first query returns NO ROWS and then the second query errors and the whole stored procedure fails. The same problem happens when using these as a subquery which has an empty result set. Furthermore I am using this stored...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
crmAPIRequest; // // initialize response variable m_Response = Map(); // // get xero signature v_XeroSignature = "SIGNATURE_FAIL"; if(!isnull(m_Payload.get("headers"))) { if(!isnull(m_Payload.get("headers").get("x-xero-signature"))) { v_XeroSignature =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
from Shopify webhook to a map m_Payload = crmAPIRequest.toMap(); // // get webhook signature v_ShopifySignature = "SIGNATURE_FAIL"; if(!isnull(m_Payload.get("headers"))) { if(!isnull(m_Payload.get("headers").get("x-shopify-hmac-sha256"))) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
page background color. Why? I want an image to display per row as a status marker for 3 different types of results: Success, Failure, Unknown. My images are circles with the background being transparent. I want the first column to display an image based...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
= $2000 ;// If Not set display names For shell name space items that are Not in the file system will fail. Const SHGDN_FORADDRESSBARConst = $4000 ;// For displaying in the address (drives dropdown) bar Const SHGDN_FORPARSINGConst = $8000 ;// For...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
as well :c) Question Why would I want preview screenshots of sites I link to? Answer: Apparently it's big business but I fail to see why any business specialising in website thumbnail generator services, puts all its eggs in one basket. Put simply,...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Product ID to me. You may have noted also the precarious method in retrieving the product variant SKU (this will error/fail over if a product doesn't have a variant) and also how I get Shopify to return the last ID (as it is already sorting by ID)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
incl. ZohoSign.account.ALL) Click on "Create" You now have about 3 minutes to do the following step (repeat this step if you fail) STEP 3: GENERATE A REFRESH TOKEN For the following, browse to Zoho Sign, login as the customer, click on Settings > API...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Sign
- Language: *
-
issue before; but sending a billing/shipping address included in a request to create or update an estimate in ZohoBooks will fail... Why? I have a function to push a ZohoCRM quote to a ZohoBooks estimate and a client asked that the address on the CRM...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
= v_ImageSrc.getPrefix("\""); if(!isBlank(v_ImageSrc)) { // use a try...catch as some file types may cause this to partially fail try { v_CountNew = v_CountNew + 1; f_DownloadFile = invokeurl [ url :v_ImageSrc type :GET connection:"zdesk" ];...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
of 20k items. Previously, the function that would need to get the price book rate post saving a record in Zoho Deluge would fail because it was making too many function statements. How? I have this code triggered in a workflow when the sales order is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
to build a system which monitors a Zoho App for when records were last modified and if a synchronization process starts to fail, there should be images or icons warning or advising of failures. How? The key trick to use here the ability for Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
any kind of an error with that server, it tries a second server... We now want to add a third server to try if the first 2 fail for whatever reason. How? Admittedly, perhaps this maybe wasn't possible but as of February 2024; I have been able to test...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
is a void function, similar to the sort() function; in that if you try to assign this to a new variable name, it will fail. In other words: m_NewTag = m_Tag.remove("id"); // yields null m_Tag.remove("id"); // returns m_Tag map without the ID key-value...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
-- ********************************************************************* -- METHOD #2- MAINTAINS V25 CATEGORY IDS: This will fail if you have any -- conflicting categories already in the database. If you only have the -- ones from an Out-of-the-box...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
your SSIS IDE (Visual Studio?) will give you a useless Microsoft message saying something like: Error: Data conversion failed while converting column "This_Date" (3833) to column "This_Date" (3932). The conversion returned status value 2 and status text...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
may be a million better solutions out there, this is just how I did it. This may look like a horrible report which would fail an accessibility test but visually it says straight away which is the better report; and when comparing to the previous runs...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
I just had to put something here as I have been buying and returning failed/corrupt USB pens. In the past few months I have been trying to upgrade my 16Gb USB Integral Pen from Play.Com to a 32Gb equivalent. I use my USB pen as the "My Documents"...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from, well...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
management and instead prove your worth. I'm good at what I do because I make do with what I have available and I've yet to fail in coming up with a fix/workaround. "It's a poor workman who blames his tools".
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB