Assuming order is required, the following 128 results were found.
-
click on the filter, a dropdown appears with all available values listed. The Problem The values are listed in alphabetical order at first. If any new values come along then they get added to the bottom of the list... This is the problem. For example,...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
on setting up an integration from Zoho Creator to Shopify API. Why? In this example, we want a webhook that whenever an order is made in Shopify, it tells our Zoho Creator app. Note that at the time of this article, API v1 is deprecated (so no...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
I'd like to document for future use. The use-case is the client has their own delivery drivers and want them to mark a sales order & package as shipped and delivered. How? Here's a code snippet that works for me. It is triggered when a user ticks a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
a.VisitorIP IP, a.DateTimeStamp Date FROM custombu_stats_visits a WHERE YEAR(a.DateTimeStamp)='2010' GROUP BY a.VisitorIP ORDER BY MAX(a.VisitorID) DESC ) t1 LEFT OUTER JOIN wikimedia_user b ON t1.ID=b.user_id GROUP BY t1.IP ORDER BY b.user_name ) t2...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Time] , e.[TimeRendering] AS [Render Time] , DATEDIFF(MILLISECOND, e.TimeStart, e.TimeEnd) [Total Time] ,RANK() OVER (ORDER BY e.[TimeStart] DESC) [Rank] FROM [ReportServer].[dbo].[ExecutionLogStorage] e INNER JOIN [ReportServer].[dbo].[Catalog] c ON...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
calendar WHERE calendar.SetID=( 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...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Creator. Why? I do this a lot but in the following example, I want to sort a list of records by their date in descending order. Yes this functionality exists in reports but I want to do it in code so as to display it in a HTML table. What I have: id...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
'' post_content_filtered, '0' post_parent, CONCAT('http://demo.joellipman.com/wordpress/', '?p=', id) AS guid, '0' menu_order, 'post' AS 'post_type', '' post_mime_type, 0 comment_count FROM my_joomla_db.jos_content ORDER BY id Importing the joomla...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used first (replace 'mydbprefix_content' with the name of your database table AND `introtext` with the name of your...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance of Zoho Inventory. In this task, we are simply getting a CSV...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= List(); l_PaginationParams.add("page=1"); l_PaginationParams.add("per_page=100"); l_PaginationParams.add("order_by=id"); // // we have no more than 100 categories so let's start counting r_Categories = invokeurl [ url: v_EndpointCategories + "?" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Frontpage Item Orderinghttps://www.joellipman.com/articles/cms/joomla/frontpage-item-ordering.html
Having trouble ordering your frontpage articles? After re-ordering articles wondering where it was taking the order it puts the articles in the front page (or landing page) was confusing me. The quick answer is that it is within the menu manager > main...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
. ')') $query->where($db->quoteName('u.real_name') . ' LIKE '. $db->quote('\'%smith%\'')); $query->order('u.real_name ASC'); // Reset the query using our new query object $db->setQuery($query); // Load the results as a list of stdClass objects (see...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
id, Deal_Name from Deals where ((Amount=0) and (Stage != 'Cancelled')) limit " + v_PerPage + " offset " + v_PageOffset; Sort Order: ORDER BY column_name ASC/DESC: v_CoqlQuery = "select id, Deal_Name from Deals where ((Amount=0) and (Stage !=...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
generate maps of a currency or a tax from a client's Zoho Books. Why? The use-case here is that we are creating a Sales Order in Zoho Books from Zoho CRM and want to map the correct currency and tax by their ID numbers. How? Using the REST API and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
API and check on a package given a tracking number. Why? In our megafunction to generate a customer, a product/item, a sales order, an invoice, a package slip/delivery note, a shipment order; as well as record any payments, inventory adjustments, status...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
for Joomla! FTP upload. - 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:...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
'(' + CAST(CHARACTER_MAXIMUM_LENGTH AS VARCHAR(10)) + ')' END FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @TableName ORDER BY ORDINAL_POSITION FOR XML PATH ('') ),1,1,'' ) + ';'; EXEC(@TableDeclaration); -- Get First Column Name SET @ColName=(...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
{ $('log').set('html', response); } }); // Send the form. this.send(); }); }); .aCoupleOfDivs { background-color:#efefef; border:2px solid #ccc; width:300px; float:left; } Basic Mootools Form in Joomla 2.5 Basic Mootools Form in Joomla 2.5 Name:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
is not easily recognized from the results ** ** ** ** Only finds the first table_name.column_name where the match occurred (ordered alphabetically). ** ** -> Example: if a table has two rows, both with the typo: ** ** Row1: EthnicCode DnYa ** ** Row2:...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF