Assuming statement is required, the following 43 results were found.
-
already records 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
templates in ZohoSign // NB: if your document is NOT in ZohoSign but is a mail merge template in CRM, then skip this if statement if(v_ZohoSign_DocumentType == "CreditApplication") { v_RequestID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
What? A really quick article on demonstrating a nested try...catch()... statement working in Zoho CRM. Why? To prove a point to ChatGPT who said this was not possible... and to deal with a scenario which exists for a client of mine. The use-case for my...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
in the top right of this page (not the one next to your profile as that's global settings but the one next to the "Import Statement" button). Reconnect Token There are a couple of options here depending on what you can see If you can see "Refresh Feeds"...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
= $row->username; $this_user_realname = $row->real_name; } Chaining A quick note on how to chain, the following two statements are equivalent: -- note the semi-colons at the end of each line $query->select($db->quoteName(array('user_id', 'user_name')));...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
« Show Me » [Same file again] \plugins\search\content\content.php: Add the option to select by relevance to the CASE order statement: switch ($ordering) { // BEGIN: joes new ordering option case 'relevance': $order = 'relevance DESC'; break; // END:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
personal website: www.joellipman.com. This article assumes you are familiar with upgrading a Joomla! CMS and running MySQL statements against your database. For the purposes of this article, we will refer to the live/current/production website running...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
no matching rows (so zero results), BIDS doesn't seem to know what to do with this. We could add a row with a SELECT UNION statement but I found this can be resolved by adding a counter, so the above becomes: SELECT DISTINCT re.[RoomId] ,re.[SiteId]...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
references (eg. T-SQL is @localvariable, Oracle is :localvariable). I need to change it to a conditional query with the OR statement below: Lets take the following query as an example: SELECT table1.studentID , table2.studentUsername FROM table1, table2...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
If like us, you've made a report containing a link dependent on parameters submitted, we had to apply a similar IIF statement block to the Font color and the Action target as well within SSRS.
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
I initially used but my end-users were asking why is it always 0 seconds. This was because we were using the following MDX statement which had seconds as its smallest denominator: ="Execution Time: " +...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
[carriage return] but to do this in the name of the column heading, the answer is a much simpler one, in your SQL statement, simply place your cursor where you want the carriage return and press Return/Enter. This has to be a label to the name of the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
working for you with your query and then for every column of data that you are extracting, you will need to use the case statement to either put the value or your empty row. Here's an example of the query for a timetabling solution with spacing rows...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
and more employees. PARTITION BY So a sort of "group" action will allow this if we add "PARTITION BY" to the ROW_NUMBER() statement: SELECT q.Employee AS EmployeeNo, RIGHT('000' + CAST(q.Employee AS VARCHAR), 3) + RIGHT( '00' + CAST( ( ROW_NUMBER() OVER...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
003 2.00 1999-02-25 1.00 If you have more than 999 items in the column, then you may need to increment the 3 in the above statement "LEFT(..., 3)". Almost there, but in the above example, the dates are wrong for subsequent days off sick: SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when converted to a number only retrieves the first value...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
So this is a quick article on how to delete from multiple tables in a mySQL database where we use some JOIN statements. Why? It is never recommended to delete from multiple tables and instead to use the system you were given. Given a Relational Database...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
site: «Download» Run the SQL script against a test database, Modify the table name to use if necessary. Uncomment the drop statement if running for the second time. Modify the PHP file to use database login credentials, $db_host = "localhost"; //...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
A quick article showing my MySQL statement when I want to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
enclosed by double chevrons Enter the same field to monitor under "New field/Value" enclosed by double chevrons The final statement will be something like != Use the Operand "OR" or "AND" to add further fields, in our demo we want all the key fields:...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *