Assuming limit is required, the following 41 results were found.
-
'.', -1)*1) AS lastcatid FROM `my_new_database`.my_prefix_assets WHERE `name` LIKE '%.category.%' ORDER BY `lastcatid` DESC LIMIT 0,1); SET @new_jos_assets_last_inc=( SELECT IFNULL(@new_jos_assets_last_inc, 0)); SET @new_jos_assets_id_last_lft=( SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
A very quick article on how to check what the statement execution limit is on the Zoho application you are working in. Why? Our use-case is that an application we built in Zoho Creator was hitting statement execution limits and rather than proposing an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
https://www.zohoapis.com/crm/v7/coql). where can contain up to 25 criteria. Use parenthesis for precedence. Pagination: LIMIT offset, limit: v_CoqlQuery = "select id, Deal_Name from Deals where ((Amount=0) and (Stage != 'Cancelled')) limit 400,2"; //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
in l_Pages { v_Endpoint = v_ShopifyURL + "/admin/api/" + v_ShopifyApiVersion.toString() + "/products.json?status=active&limit=250&fields=id&order=id+asc&since_id=" + v_LastID; r_GetProducts = invokeurl [ url :v_Endpoint type :GET headers:m_Header ]; for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
no parameters specified) v_Endpoint = "https://cliq.zoho.eu/api/v2/chats/"+v_ChatID + "/messages?fromtime=" + v_FromTime + "&limit=50"; r_ChatDetails = invokeurl [ url: v_Endpoint type: GET connection: "ab_cliq" ]; // // let's build up the conversation...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
stutalk usr_code=«your_user_code» smg_code=CAPCHG xpt_code=7day tracemess=3 limit=600 dot The EOT Monitor should have a shortcut similar to the following:D:\Applications\siapp\vision\dev\uniface\bin\uniface.exe...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
copyright on the Program, and are irrevocable provided the stated conditions are met. This License explicitly affirms your unlimited permission to run the unmodified Program. The output from running a covered work is covered by this License only if the...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
Product_Name, COUNT(id) 'Frequency' from Products where Product_Name is not null group by Product_Name limit " + v_PerPage + " offset " + v_Offset}; r_CoqlUniqueProducts = invokeurl [ url :"https://www.zohoapis.eu/crm/v7/coql" type :POST...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
some core files in Joomla. As a precaution, you may want to back up all your website files and its database. Or, if space is limited, you can backup the files I have listed here (the ones we will be modifying): \plugins\search\content\content.php...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
= (SELECT `id` FROM `v34_db`.`v34_assets` WHERE `name` LIKE 'com_content.category.%' AND `title` = 'Uncategorised' LIMIT 0,1); INSERT INTO `v34_db`.`v34_assets` ( `parent_id`, `lft`, `rgt`, `level`, `name`, `title`, `rules`) SELECT @assetParentID,...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
SELECT acyear.SetID FROM joes_weekstructure acyear WHERE NOW() >= acyear.StartDate ORDER BY acyear.StartDate DESC LIMIT 0,1 ) ORDER BY calendar.weekNumber Same Query but without using % (avoids MySQL Error 1065: Works within PHP scripts) SELECT...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
NOT IN ('Article','This',' ','content','component','applies','because','doesn''t') GROUP BY `value` ORDER BY `total` DESC LIMIT 0,50; Additional Note(s): I have added a WHERE clause which omits words less than 5 characters in length, and some other...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
a list of free 3rd-party APIs and the below code is dependent on these being online and working... The quickest I found [limit 1000 per day | Incorrect Location]: v_Url = "http://api.db-ip.com/v2/free/"+ zoho.ipaddress; v_Response = getUrl( v_Url );...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
no parameters specified) v_Endpoint = "https://cliq.zoho.eu/api/v2/chats/"+v_ChatID + "/messages?fromtime=" + v_FromTime + "&limit=50"; r_ChatDetails = invokeurl [ url: v_Endpoint type: GET connection: "ab_cliq" ]; // // let's build up the conversation...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165
the people, not harm them. You may only use your powers for the purposes that they have been given to you for. There is no limit on how much you may be punished for this severe offense as this must be stopped at all costs to protect the people. This...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
websites and you need screenshots of these. Whatever the reason, I needed a FREE option and everything available had a limit to its "FREE" services. There are websites that do this for me? Yay! for free as well, as long as my page isn't loaded more than...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
the authorized "service group" has access to (Special?). Free Website Thumbnail Services Thumbnail Services will give you a limited number of free thumbnail generations. About 100,000 on average which is more than enough for our Joomla! website (unless...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
- File Download: Payment Options --- merchant ID, --- amount --- currency, --- paypal, google, --- order ref, --- download limit, --- download period, --- thank you message v0.1 (06/07/2011) - Added Admin Section: Settings/Configuration --- Component...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Administration (FAA), UK Civil Aviation Authority (CAA) and European Air Transport Command (EATC). These are: 400ft altitude limit Line-of-Sight (LoS) required Stay away from built-up areas Note: There are slightly different regulations for a small...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Joomla 3.3.1. It simply displays a search module form (same as the default install) only with the additional hidden fields: limit, search phrase (all, any, exact), ordering, and areas (set to doc_indexer by default as per the component). The parameters...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *