Assuming found is required, the following 132 results were found.
-
So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting Services (SSRS). Well "non-productive" more than "fun"...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Intelligence Development Studio (BIDS / VS2008), the IDE would crash and close without warnings or notifications. We found that if the query only returned 1000 rows, it completed and displayed in just under 1 minute. If limited to 500 rows, it would...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Table of two columns: ** ** - Value: Your search term and matching variations ** ** - Source: The table_name.column_name it found this value (Maximum) ** ** ** ** Additional: ** ** - For performance, restrict this by schema otherwise occurrences in...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
and can connect using sqlplus. But if I tnsping any oracle database, I get something along the lines of: Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage 3512 not found; No message file for product=NETWORK,...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
connection. Support: Apologies for not having a discussion forum available but this has not helped me in the past and I have found it easier to answer comments on the website (rather than managing moderators, posts/topics, and opening any other can of...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
hours). How? The plan is to iterate through a 24-hour clock, enable adding to the picklist when the starting hour is found and stop adding when the closing hour is found. The picklist field is called "Time_Field". The following reads from a form...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
away classes and ID fields that might have been reserved for Zoho rendering (which did nothing to fix this problem), I found the cause of all the pain. I was setting a cover page (as per the client's requirements) with a background image and the logo...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
type: POST headers: m_Header parameters: m_CreateRecord ]; {"code":"MANDATORY_NOT_FOUND","details":{"api_name":"data"},"message":"required field not found","status":"error"}: Happens if you put "JSONstring" instead of "data". Depending on the context of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
your masterpiece! The following screenshot shows what happens when I change the parameter: Additional Note(s): I have found that adapting Widgets created for Zoho Creator to work in Zoho CRM is pretty easy to do. The only differences are the step where...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
This is an article to show you how to use triggers but also how to stop them. We only found this an issue when using REST API v2.1 but also to show you how to configure triggers when using createRecord or updateRecord. Why? We had a Creator app updating...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
{ v_CustomerTimeZone = r_TimeZone.get("display_value"); break; } } } } } } // // if not blank then we found the correct timezone picklist option if(v_CustomerTimeZone != "") { m_UpdateLead.put("Customer_s_Timezone",v_CustomerTimeZone); } // // if not...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
your recently created API Integration form (tip: keep this open while you get the information from Shopify and your scripts found further below in this article): Give it a Connection Name (eg. "Shopify API Oauth") Enter the Shop ID (eg....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
to create and declare the subform before having specified any record to insert it into. Expecting ZC_SUBFORM_109 expression found COLLECTION expression: I may have tried to make a subform equal the collection rather than inserting the collection into...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
> 0) { // // A quick CSV line f_TestFile = "Test 1,Test 2,Test 3".toFile("test.csv"); f_TestFile.setParamName("file"); // // found if you open the report properties and select rename from the vertical ellipsis icon in the top right v_ReportLinkName =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
applied for my client, but I'm awaiting feedback (UAT = User Acceptance Testing) to ensure this behaves as expected. So I found another function was being run when a contact record is created and I appended this snippet of code to the end of it. Note...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the invokeUrl wants its parameters changed using .toString()... sometimes it doesn't, as it did in this case. EXTRA_KEY_FOUND_IN_JSON {"errorCode":8542,"errorMessage":"Unknown JSON attribute(s) found in the parameter CONFIG."}: This was because I was...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
brief (whether it's the right tool for the job is a different issue), let us synchronize Zoho Surveys into Zoho Analytics. I found I need to edit the setup of the sync every time a new survey is added... but at least it lets me synchronize every hour....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
cancelled nor expired if (a_QuotedSalesOrders[i].Status !== "Cancelled" && a_QuotedSalesOrders[i].Status !== "Expired") { // found one so let's bail v_FirstSalesOrderID = a_QuotedSalesOrders[i].id; break; } } // if not null (was found) then let's assign...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
*/ // // init v_OutputMessage = "ERROR: No Access Token or Tenant Connection specified."; v_Count_FoundInXero = 0; v_Count_Created = 0; v_Count_Updated = 0; v_AccessToken = ""; l_Pages = {1}; v_PageSize = 20; b_Debug = false; // // Xero Invoice Statuses...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
*/ // // init v_OutputMessage = "ERROR: No Access Token or Tenant Connection specified."; v_Count_FoundInXero = 0; v_Count_Created = 0; v_Count_Updated = 0; v_AccessToken = ""; l_Pages = {1}; v_PageSize = 1; b_Debug = false; // // Login to Xero >...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *