Assuming where is required, the following 228 results were found.
-
= r_ShopifyAPI.API_Version; // // url with client id and client secret (now to be deprecated July 25, 2025 by Zoho) // where p_OrderID is the shopify order ID v_Endpoint = v_ShopifyURL + "/admin/api/" + v_ShopifyApiVersion + "/orders/" + p_OrderID +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
at the bottom of this article), the simplest way was right in front of us. We're going to use the interface to find the form where staff have been entering employees goals, then we're going to query it and push it to Zoho Analytics. Find the form link...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
Date%20DESC m_Params.put("order","UpdatedDateUTC DESC"); // // get the first page of Xero invoices v_FilterReceivables = "?where=" + zoho.encryption.urlEncode("Type=\"ACCREC\""); r_AllXeroInvoices = invokeurl [ url :v_DataEndpoint + "/Invoices" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
a manual import (CSV) of the transactions for a particular account and then to reconcile these. This particular case covers where the Cx had a working automatic bank feed for a while but at some point simply stopped working. How? First let's go through...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
info l_Items.get(3); // yields "d" This approach works well for reference lists, configuration values, or ordered datasets where readability during development is helpful. 3) Method chaining across multiple lines Method chaining can be split across...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
these lines: body.bgstyle1 #main-background {background: url(../images/backgrounds/bgstyle1/bgimage.jpg) 50% 0 no-repeat;} where 1 is the number of the style of the template I am setting the background for and I add the "fixed" attribute to this id....
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Joomla 2.5.x Content my_joomla_2_5_db.my_2_5_db_prefix_jcomments j2b -- Joomla 2.5.x JComments SET j2b.`object_id`=j2a.`id` WHERE j1a.`alias`=j2a.`alias` AND j1a.`id`=j1b.`object_id` AND j2b.`comment`=j1b.`comment`
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
a SQL query as per usual if (!mysqli_connect_errno()) { $query='SELECT COUNT(*) as ArticleCount FROM `'.$db_prefix.'content` WHERE id='.mysqli_real_escape_string($db_connect, $_GET['id']); if ($result = mysqli_query($db_connect, $query,...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
and \libraries\joomla\form\fields\media.php. You then refer to it in your XML file where instead of type="sql" use type="modal_article". A usage example is: Just copy & paste the below into a PHP file and include it in your component, the solution is...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
A quick article on a frequent question I get asked. This refers to an issue within the Joomla CMS (version 2.5.x) where it fails to email users who reset their password. How? A few things to check: Check the email message even exists: Login to your...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
ORDER BY name -- yields all projects irrespective of which user is logged in What I want: SELECT * FROM #__projects WHERE user_id= ORDER BY name Please Note: This article focuses on a front-end form dropdown. If you would like to see how to do modals...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
these by ISPs so that they can identify their service users). The below also only allows 1 IP address (ie. one location from where an admin user can log in). Create a .htaccess file in your /administrator folder with the following content: # ALLOW USER...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
'category' AS 'taxonomy', a.description 'description', 0 'parent', (SELECT COUNT(c.id) FROM my_joomla_db.jos_content c WHERE c.catid=a.id) 'count' FROM my_joomla_db.jos_categories a ORDER BY a.id; INSERT INTO my_wordpress_db.wp_term_relationships SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
until red minus buttons appear, tap red button)... I wouldn't usually take notice but I think this is a brilliant example where trying to fix the problem is the very cause of the problem in the first place: The empty arrow next to the battery indicator...
- Type: Article
- Author: Joel Lipman
- Category: Apple
- Language: *
-
my solution as after 2 hours, realised that the customer had been looking at the wrong server. But this script showed me where the cron job we intended was located. #!/bin/bash # System-wide crontab file and cron job directory. Change these for your...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
of the video unless it was an AVI file that we converted to FLV. The quality was horrible. Then we moved to Camtasia Studio where their videos were displaying in good quality but as SWF files. This extension includes the default settings for...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
Pre-populating default value and returning input Lots of confusing answers out there on the web but here's an all-in-one where I Open an AlertDialog designed with a custom XML layout Set the hint text of a specific user input field (EditText) Store the...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
article on how to replace the return key on a soft keyboard (software based) on a touch-device. Why? I have an editText where a user can enter any text value but if they typed a return character, the app would crash because it didn't understand the...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
Error: Description: "Invalid character value for cast specification". Exceptions for text file where I needed two derived column tasks, the first checks if the Date was blank and puts a NULL string. The second takes this string and converts it to a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
You don't get that with Excel but you can still control the data range. How? My example is that I have an excel sheet where the first 10 rows are descriptions to the column, and then I have 38 columns ("A" to "AL"): In the data flow, click on the Excel...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB