Assuming which is required, the following 325 results were found.
-
collation being case-insensitive. Furthermore, we now have the task of finding all the variations of the default values which we found we could do with the built-in SOUNDEX function. How? Lets assume the following, we have a table containing: StudentID...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
they don't get it. If you are reading this, it's likely you've paid for a commercial version of a Microsoft product which cannot possibly be cheap. MS SQL Server Management Studio (SSMS) comes included so use it... How? Well I started with the method #1...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
a column with old values, and now that I have a new list, I want a quick way to see what values are in the old column and which ones are new... Why? Consider the 3 following columns in an Excel spreadsheet: Old New Exists in Old? --------- ---------...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
databases (internal auditing) only showed how long the SQL query would take to recover the data and present it in a report, which would average about 0.4 seconds. We're obviously not interested in shaving off time from 0.4 seconds; no, we're more...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
an OUTPUT table in the SITS database. Note that this does not include steps thereafter in the Staging or Target destination which will be specific to your business requirements. Why? If you're developing in SITS, and you use the client, the first...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
for a tablet running Android and wanted to include a Google Map. The following exercise focuses solely on creating an app which opens Google Maps at your current location. How? I couldn't find any instructions using the tools I had (Android Studio)...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
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 not an excuse. I also found that examples...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
This is an article which lists the functions necessary to process Google Authentication using OAuth2.0. These functions allow a script to simply be loaded and to either create a token file, or use the existing one as long as it hasn't expired. Update...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? Zoho doesn't have a function to generate random numbers or...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
it to see if I can refine the code or find a some short codes that will do the same. Why? I'm aiming to automate a process which counts the number of products allocated to an account or in total for a purchase order. Let us assume we have the following...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
datacenter your client is using Register the App Setup the Connector How do I determine what datacenter to use? To find out which datacenter your client/customer is using in Zoho, check the domain and specifically the top-level-domain (TLD) part. For...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This is an article documenting how to send a Zoho Deluge Map request to an API which is expecting nested/2d/multi-dimensonal arrays. In the example below, we are posting to a PHP script for testing but I have since sent something similar to an API...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
of an alternative that I now use frequently in client systems. How? The gist is that we add a checkbox called "Processed" which will have a datatype Boolean. Our function will then loop through each record and do what it has to do. The workaround here...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
returns in between a pair of double-quotes. Why? Our use case is that we were trying to loop through rows of a CSV file which contained addresses which in turn contained commas. Saving this as a CSV and asking Deluge to parse the data in the appropriate...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
}, { "Currency": "USD", "id": "123456789000000006" } ], "info": { "count": 200, "more_records": true } } Which isn't what I want because it has returned the same currency several times and thinks they're unique/distinct because the IDs of each quote...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
] 2 Well that produces a lot of ID numbers delimited by a comma. However, to match my use-case, I want a list to which I can give it an SKU, and it returns the Shopify Product ID (not of the variant but of the product). In which case, I need to tweak...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
is an article to serve as a guide in terms of styling a radio group into a group of Tabs. This is only a guide or reference which was applied for one client but would need adapting to match the colors or style the next client wants. Why? The scenario is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A quick article on a snippet of code which copies one subform to other subforms in the same form. Why? I'm creating an appointment/booking system and I want the user to be able to set entries in a subform called "Mondays" then to click a button which...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
An article with a quick snippet of code which builds up the address from a Lead record to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone. Why? Our use-case is that we have a field called "Customer's...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *