Assuming lipman is required, the following 661 results were found.
-
What A quick post on how I managed to build a regex to extract all non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = "Credit Note - 30 Days"; // we want the 30 from the above...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? This is a quick article on different ways to get the current user ID in Zoho through code. How? I'm not a fan of method #1 but I only started developing in Zoho recently when API v1 was already being deprecated (end of life at the end of this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
What? A quick article just as a note to get the users country information from a third-party API based on the given IP address. How? Well this is just a list of free 3rd-party APIs and the below code is dependent on these being online and working... The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
What? There may be other articles out there documenting this but I can't keep trying to find these in Google so referring to my own website, this is a doddle for me to find each time. Why? I have to do this so often that it deserves an article. Though...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
What? I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone SQL scripts that can simply be used to search...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Some memory aids for me so that I don't have to keep looking them up: MySQL T-SQL Strings String Replace REPLACE(haystack,needle,replacement) REPLACE(haystack,needle,replacement) String Position INSTR(haystack, needle) LOCATE(needle, haystack [,...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
a map: m_Payload = Map(); m_Payload.put("client_id","my-unique-client-id"); m_Payload.put("redirect_uri","https://www.joellipman.com"); m_Payload.put("response_type","code"); m_Payload.put("scope","my_api_scopes"); m_Payload.put("prompt","login");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
What? This is an article on how to do a restore from backup on a database but when you get the error: "... database is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO --...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
What? Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Well I find myself again the dummie of the Internet. I basically came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Thought I'd put a note on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Thought I'd add a note as I was getting confused with the built-in function "FormatDateTime()". The example is shown as: =FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate) The other formats are: =FormatDateTime(Fields!BirthDate.Value,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
What? A very quick article to show pushing the date and time to ZohoCRM or ZohoCreator. Why? You may have received an error that goes something like: datatype: datetime How? Here are some formatting examples: Creator to CRM: v_CreatorTime =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? A super quick article on resolving this issue if it ever appears again. Why? At time of print, this error was happening to schedules in Zoho Books, Zoho Inventory, and Zoho Subscriptions. Unless you can monitor when these type of schedules are...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
What? A quick article on making an "upload file" field mandatory. Why? Because for some reason, it wouldn't appear as selectable when I tried using a layout rule. Probably everyone else has figured this out and I'm just late to the party. How? Through...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
RokStories has been overhauled to provide the spectacular display that you see on this demo. The module adapts depending on your image size, so no need to manually create rounded corners on your images, RokStories will do the rest. The custom features...
- Type: Article
- Author: Webmaster
- Category: Joomla
- Language: *
-
This is what I had to do to be able to add another template to the dropdown in the Kunena configuration panel: Download your site from your server to a copy on your local disk (hard disk, flash drive, etc) Make sure that the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
As with all Joomla articles and files, you need to check that they have been published and approved. Sometimes you don't have to and it's all automatic, but if they're not showing: Check that they're in the right section and category Check that they...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
So I find myself searching the web for a way of producing an outlook-style calendar within Business Intelligence Development Studio (BIDS). Weekdays along the top and then dates inside. Additionally we would like this linked to events in a database. I'm...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
My setup Windows XP SP3 MS SQL Server Management Studio 2008 SQL Server 2008 R2 Regional Setting: London BST (British Summer Time) Tuesday the 11th of October 2011 at 06:00am: CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0) Oct 11 2011 6:00AM CONVERT(CHAR(8),...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB