Assuming true is required, and value is required, the following 41 results were found.
-
What? Apologies for posting yet another article on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
What? A really quick article to test when to use isNull and isBlank. Why? So I've noticed that looking at people's Zoho Deluge code, there will often be a check on a null before or after the variable: if(v_Test.isBlank()) {... } VS if(isBlank(v_Test))...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Apologies for copying and pasting this but this is information that is worth NOT losing. Tutorial on how to use COM objects in AutoHotkey. Source: Jethrow @ Autohotkey Forums Basic Webpage Controls with JavaScript / COM This tutorial requires one of the...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
Download Connectors from dev.MySQL.com MySQL Connector/Net Type: .NET Framework Class Library Usage: MySql.Data.MySqlClient.MySqlConnection Manufacturer: MySQL Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Default...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
Applies to: Joomla! CMS 2.5.x Joomla Filter: Validation OnSave INT Forces the value to be an Integer UINT Forces the value to be an absolute number (-4.2 becomes 4.2) FLOAT Forces the value to be a floating point value BOOL Forces the value to be true...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
What? This is an article detailing the client script to fix any fields which exceed their decimal places limit in ZohoCRM. Why? So we have a customer that has some decimal fields on the products module that are calculated and will sometimes return...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
What? An article on how to declare an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- What I want: Why? Outputting from SITS:Vision to our staging...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
What? This is an article to demonstrate how to handle commas in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a pair of double-quotes. Why? Our use case is that we...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? A quick article to document 2 features in deluge code: a custom related list in ZohoBooks, and a reminder on how to read a table from ZohoAnalytics. Why? My use-case here is that we have a client who uses their purchase orders and sales orders as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Previously titled Fix PHP cURL: parser error: Document labelled UTF-16 but has UTF-8 content What? This is an article with notes for me on how to convert some received XML encoded in UTF-16 to some JSON in UTF-8. If it were entirely in UTF-8, I would...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
What? A quick article on how to debug some errors in Zoho. Why? I wanted a general note to list certain errors that we get when we do certain things in Zoho but didn't want to write a separate page for each minor issue. How? So I'm going to try and list...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
What? This article serves as a best practice and reminder to myself on how to stop endless loops from happening in Creator and crashing the application. This is more for complex Creator forms which have workflows triggered from many deltas/changes. Why?...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
What? So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting Services (SSRS). Well "non-productive" more than...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
datepart) DATEADD(datepart, number, date) DATESUB(datepart, number, date) Other If-then-else IF( expression,value_if_true,value_if_false ) IIF( expression,value_if_true,value_if_false ) If Null IFNULL(column_name,value_if_null)...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Update August 2011 So I don't know how many people were just saying why don't you do the following: Bring up the "Tablix Properties" of the dataset Look for the section "No Rows" Put in a value for "NoRowsMessage". This solution hides the entire Tablix...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
What? So this is supposed to be a quick article detailing how I used a PHP function to upload a video file to Google Drive. Note that this example does not involve installing the Google Client Library for PHP. So no classes or built-in functions that...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
What? A quick article with snippets of code to hide and show certain tabs on a deal record based on the pipeline. Why? A request from a customer asked if a tab specific to the pipeline selected can be shown while others hidden. Standard tabs such as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
What? This is an article to document how to use Zoho Deluge to download a file that was uploaded into a Zoho Creator form and then to attach it to a Sales Order in Zoho Books. Why? Because it took me so long to find out how to do this even after reading...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
What? This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration purposes, I'm using a new Excel file with two...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB