Assuming limit is required, the following 41 results were found.
-
XML calls. Why? I find myself using this more and more now that API v1 is on the way out and Zoho Deluge by itself is limited somewhat with regards to functionality and record editing when compared to API v2. How? Note that this is using Zoho Deluge and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
a HTML table without using a for each loop. Why? I have quite a big response from our CRM that hits a statement execution limit if I use a for loop. I have a map with 3 columns: first_name, last_name, and ID. What I want is a HTML table now with the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
to see if there are zeros... But I'm keen on avoiding using loops where possible so we don't breach a statement execution limit in the Zoho app function. How? If we're not going to use loops, then the next best thing I'm aware of is a regular...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
ID to your own record ID. Set the list of pages to the number of pages you want to search. Keep in mind script execution limits set by Zoho. Set the search criteria string to your specific requirements (:equals:, :starts_with:, |=|). If 1 expression...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
version for Shopify when private apps created before February 2022 won't be deprecated? Because the previous version was limited by our ability to search by product SKU. The new version, taking advantage of GraphQL, will be able to search by SKU and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
// call issuer code 05 Payment Declined Generic 55 Payment Declined Incorrect Pin 65 Payment Declined withdrawal_count_limit_exceeded 75 Pin try exceeded ******************************************************************************* */ v_BooksOrgID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
using the GUI and a "Pivot View" report but I always resort to a query when I get confused with the GUI: Query 1 Due to the limit of sub-query levels we can go down, I want to join this to the contacts data table. So I'm going to make this first query...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
in the system with that key. I can't sit there entering one customer at a time. Even a loop would hit a statement execution limit. Why? My use-case is that I need this done over a dataset of 20k+ contact records and that's only half of the production...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
This is an article detailing the client script to fix any fields which exceed their decimal places limit in ZohoCRM. Why? So we have a customer that has some decimal fields on the products module that are calculated and will sometimes return numbers...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= "select id, Contact_Name.Tag 'Tag' from Deals where Tag is null and Contact_Name.Tag is not null order by id asc limit " + v_PerPage; m_Params = {"select_query":v_CoqlQuery}; r_Coql = invokeurl [ url :"https://www.zohoapis.com/crm/v7/coql" type :POST...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
first few pages of Google, all the online tools that did the same had a pricing page. I can understand why you would need to limit users so I don't blame them. But if you can, why not make your own? How? So you will need a webserver of your own running...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
are silver bullets, but they will slow down some people. How? The below will a) change the /administrator location and b) limit access to a single IP address. Note that you will need to ensure you have a static IP (most ISPs now assign static IPs to...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
I could get working but it's a bit excessive having to send two requests (albeit in one function) especially with imposed limit requests. I can halve this so let's upgrade! Method #2: Mulitipart single request This is my recommended version. In this...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
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 complete in just under 40 seconds. and if it was told to return no more than 100 rows, it would...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
) If Null IFNULL(column_name,value_if_null) ISNULL(column_name,value_if_null) Rank/Rownum (@rownum:=@rownum+1) AS Rownum LIMIT from_index, number_of_rows ROW_NUMBER() OVER(ORDER BY column_name ASC) AS Rownum Source(s): MSDN Microsoft Library (DATEPART...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
'-01') AND CONCAT('2010', '-', MONTH(NOW()), '-', DAYOFMONTH(NOW())) GROUP BY b.user_name ORDER BY COUNT(a.VisitorID) DESC LIMIT 0,10;
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
ownership command in shell is 'chown -R apache:apache '. 3. Check that your PHP ini specifies a reasonable maximum file size limit. By default this is 2Mb. In my example, I added the hidden input type MAX_FILE_SIZE which is ignored by more recent...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
a top ten) My new method is: SELECT column1, COUNT(*) AS CountOrder FROM table1 GROUP BY column1 ORDER BY CountOrder DESC LIMIT 0,10 PHP script to loop through the results of the above query Display the value of column1 and CountOrder The old code would...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
t.PageContent, t.Source, ".$scorepartstring." AS Score FROM (".$live_sub_query.") AS t WHERE ".$parts." ORDER BY Score DESC LIMIT 0, ".$maximum_number_of_results_from_db; $terms_rx = search_rx_escape_terms($terms); $results_rows = array(); $result =...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
these on default as you experiment and become more familiar with the tool would be better as changes to your settings may limit your discovery of the variations and styles. Type /settings then enter/return twice Storing prompts as quick commands Type...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *