Assuming previously is required, the following 39 results were found.
-
does not... This article is a start and adaptation of my previous article Convert to Proper Case in T-SQL which I had previously used for the migration of a HR system. This is intended to work using Zoho Deluge. How? There are a number of combinations...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
this use-case, my client has added an incredible number of price books/ price lists and then has in excess of 20k items. Previously, the function that would need to get the price book rate post saving a record in Zoho Deluge would fail because it was...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
+ 1; } info "Statement execution limit is 50000"; Additional Note(s): Observation #1: Method Chaining: Contrary to my previously held belief, method-chaining still counted as separate statements; this is not true as the following counts 3 statements...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
in the end, I can use shortcode for getting the tag. Note that on a fresh CRM instance where no tags have been used previously, I would use the code above to maintain tag colors. Here's the shortened version where the system chooses the color for the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
new code will be. The preamble to both of these is how to get the values to include in the invokeURL headers and payload. Previously on... m_Header = Map(); m_Header.put("Content-Type","application/json"); // // app specific (retrieving from a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
record is more up to date between ZohoCRM and Xero. How? The access token is generated by a function documented in my previously mentioned article Zoho Deluge - Connect to Xero API so here's the pull of the first page of invoices by most recent first...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
error: Accounts associated with Integration cannot be marked Inactive Summary In this case, the client’s bank account had previously been syncing correctly. After several weeks, however, the feed stopped updating, and the option to Refresh Feed was...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
you try adding a comment, you may get something like the following: Fatal error: Cannot redeclare_recaptcha_qsencode() ( previously declared in /public_html/plugins/system/jezReCaptcha/recaptcha-php-1.10/recaptchalib.php:47 ) in...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Note the receiving file is a PHP file and the contents were mentioned previously in this article (-> see ajax.form.php).
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
and deployed report on the same day will render fine in a webbrowser but when exported to PDF format, it will retain the previously deployed report settings (header&footer). Resolved this by clearing my web-browser's temporary files. Do we instruct all...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
parameter. How? There are various types of data sources used in SSRS so I'm going to try and cover the ones I have used previously and what we needed to get them working. Custom DataSource Upload the report to the ReportServer. Hover the mouse cursor...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
was ok to connect and my Microsoft Office apps, well it's a Windows box so no issues there either... Webcam and headset previously connected to my docking station weren't too much of an issue either as MS Windows detected these without needing software....
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
Previously For a basic Oracle function, visit my article Basic Oracle Function Structure. For a more advanced version which uses cursors to work with SSRS, see my article Oracle Stored Procedures in SSRS. What? I asked someone for a simple, easy and...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
SQL in my day job. The equivalent functions have to be written up all in the name of "seamless integration"... How? Previously I had tried to write a smart function which could determine the datatype automatically but as you may know, Oracle has a funny...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
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
-
$a3[] = $v; } return implode(' and ', array_slice($a3,0,2)).' ago'; } When could I possibly want to do this? Well I've previously used this for password change reminders but on this occasion for a listing of reviews laid out as per the following...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
to spend so much time on it again. Note that the below examples, demonstrate a script on a Non-SSL-Enabled host. How? Previously, I would have used cURL but for some reason, I couldn't get the configuration right. After several days... I tried the...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
In my example, this will produce an extra 12 worksheets in this file. Using the above module, overwrite the code you previously pasted with the below (note the file format for Excel 97-2003): Sub Splitbook() Dim xPath As String xPath =...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
H107C This model is the DJI Phantom FC40 so the first Phantom (v1.2?) with DJI's own FC40 camera It had had a bad crash previously and loosening some of the screws snapped the edges back into place. I thought why stop there? The anatomy of a DJI Phantom...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *