Assuming within is required, the following 96 results were found.
-
that the customer wants the item/product rate taken from the item record, if a pricebook is specified and the item exists within it, then it takes the rate from the pricelist. Note that when I refer to pricebook, this is also referred to as the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
How? The key trick to use here the ability for Zoho Analytics to display different images based on a criteria or a value within a data table. As documented in an earlier article, put the URL of the image, then change it's format to show the image and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
An article on adding an accept and decline button on the estimate (aka Quote) notification template within ZohoBooks. Why? The use-case is simply that my client wants to make it easier for their customers to accept or decline a quote. Sure there's a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
An article on removing duplicate products within ZohoCRM. Why? Product duplicates are a common issue during development, especially when we have products imported via a feed or API or simply by staff and their spreadsheets. There is a deduplication...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
for an app embedded in the Shopify instance but for a third-party app, such as a Zoho Creator app, to connect to the data within Shopify. Why? At time of print, we have woken up to the news that including a username and password, or a client and secret...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to documentation and using CoPilot or OpenAI ChatGPT for parsing the return value of the function (note that I have SCRIPT within the BODY tags and not in the HEAD): Loading... Please Wait... console.clear(); ZOHO.embeddedApp.on("PageLoad",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Issue If you've ever made PHP scripts to process data within a LAMP environment (Linux, Apache, MySQL, PHP) then this happens a lot. In the following example, our HTML form will allow the user to specify a date (so excludes hours, minutes and seconds)....
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
these were all the same, we also found that this was due to a country not being specified under the Store configuration within VirtueMart.
- Type: Article
- Author: Joel Lipman
- Category: Virtuemart
- Language: *
-
User Name\AppData\Local\Google\Chrome\Application\chrome.exe" -incognito) Additional Note 201004201256: The shortcut key within Google Chrome is holding down the Control and Shift key and then pressing the letter N.
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
failed for dataset 'DataSet1'. The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored procedure. The Quick Fix Return to the Design interface of Report Builder 2.0 for the problematic...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
on the front-end of my component is controlled and not customizable. I fixed this by removing the reference to router.php within the installation XML file. (router.php). I even deleted the router.php file from my installation zip file (I checked that...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Frontpage Item Orderinghttps://joellipman.com/articles/cms/joomla/frontpage-item-ordering.html
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 menu > menu item section of your Joomla! Admin Panel. Certain Advanced Parameters in your Menu Item...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Set "FixedData" to "True" if you want the headers to scroll with the report when viewed on the Reporting Server or within your IDE. Set "RepeatOnNewPage" to "True" for the headers to repeat on every generated page.
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
In T-SQL and MySQL, this is not so much of an issue. I get this error when having to use an ORDER BY clause in a subquery within an Oracle 11g environment. How? Consider the following: SELECT ps.person_id, ps.person_name, ( select pa.person_reference as...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
Regular Expressions in SQLhttps://joellipman.com/articles/database/regular-expressions-in-sql.html
perfect. Or in my case, any practice is a start. This article serves as a quick note on how to use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called `STUDENTS`. Oracle PL/SQL...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
A quick article to remind me about this issue. Not sure whether it is specific to the Joomla Content Management System, but within the Joomla! CMS, an error 1054 comes up if you use the above statement. Why? The MySQL statement SELECT COUNT(DISTINCT...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF