Search - Joel Lipman .Com

1. MySQL Group_concat equivalent in T-SQL and Oracle: / Databases /; MySQL is just the best Unfortunately I make a living using Microsoft and Oracle products. I shouldn't say unfortunately as I don't see myself doing any other job and it beats daytime television any ...; Created on 28 November 2011
2. MySQL Oracle equivalents: / Databases /; The title of this article implies something rather odd and upcoming considering that Sun Microsystems bought MySQL and Oracle bought Sun. But in fact, this is just a quick list of some regular commands ...; Created on 27 September 2010
3. Zoho Deluge: Convert Hex to RGB: / Zoho /; ... we take each character from the given string and convert it to its RGB value. Replace letters A to F with their numeric equivalents. Made up of 2 characters to convert to an RGB subset, the 1st value ...; Created on 11 October 2024
4. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... HTML entity equivalent and enclosing the ID in double-quotes in case I open it in MS Excel or another system that likes rounding 64-bit signed integers (long numbers): // // Generate a CSV of a ...; Created on 25 March 2024
5. Zoho CRM: Schedule a Call using Deluge: / Zoho /; ... it just wants the dropdown option equivalent (eg. "10 mins", "1 hrs") Just as a refresher if this was a task and not a call: v_ReminderDate = v_SystemAppointmentDateTime.subMinutes(15); v_ReminderStr ...; Created on 18 November 2021
6. Zoho CRM REST API: Stop Workflow from Triggering: / Zoho /; ... equivalent Creator record). There was also a workflow that ran when the Creator record was updated to update its changes to CRM. It was actually causing a loop which used up all the API calls. How? ...; Created on 16 June 2021
7. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... data. And yes, the part that took me about 8 hours and the key point above is to replace the ampersand with its unicode equivalent. I consider myself familiar with Transact-SQL, Oracle PL/SQL and ...; Created on 28 August 2020
8. MySQL: Count occurrences of words in a column: / MySQL /; What? This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count ...; Created on 12 March 2020
9. Convert foreign characters to English alphabet: / MySQL /; What? 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' ...; Created on 13 June 2016
10. MS-DOS: Copy folders without overwriting files: / MS-DOS /; ... COPY Directory Timestamps. /SEC :: copy files with SECurity (equivalent to /COPY:DATS). /COPYALL :: COPY ALL file info (equivalent to /COPY:DATSOU). /NOCOPY :: ...; Created on 23 February 2014
11. Regular Expression Basic Usage Examples: / Web-Development /; ... Class Use the POSIX character equivalence class operator to search for characters in the current locale that are equivalent. For example, to find the Spanish character 'ñ' as well as 'n'. To use this ...; Created on 28 October 2013
12. Trim in T-SQL and SSIS: / SQL Server Integration Services /; ... @EmployeeStr = 'JOE ' + CHAR(9) + CHAR(10) + CHAR(13) -- Before SELECT COUNT(*) FROM Employees WHERE Employee.ForeName = 'JOE' -- yields 1 -- What we want (equivalent?) SELECT COUNT(*) FROM ...; Created on 14 May 2013
13. Country Lookup by IP address CSV: / MySQL /; ... in the folder you have downloaded are to create a lookup function using a MySQL database and a PHP script. As well as a CSV file equivalent. How to use: Download from my site: «Download» ...; Created on 17 March 2013
14. Preg_Replace all strings between two tags: / Personal Home Page /; ... = preg_replace( '/@[a-z]+/i','$0', $string_original); -- METHOD #2: equivalent using preg_match_all $matches = null; preg_match_all('/(?!\b)(@\w+\b)/',$string_original,$matches); foreach ($matches ...; Created on 07 February 2013
15. JDatabase: using the Joomla database with examples: / Joomla /; ... 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'))); $query->from($db->quoteName('#__users')); $query->where($db->quoteName('user_id') ...; Created on 27 January 2013
16. Data Randomization Function in Oracle PL/SQL: / Oracle PL/SQL /; ... 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 ...; Created on 22 August 2012
17. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... v2008 (BIDS) SQL Server Reporting Services v2008 R2 (SSRS) Oracle SQL Developer v3 (you can use any equivalent, eg. SQL*Plus) Why? I think this is one of those very rare occasions that Microsoft ...; Created on 19 January 2012
18. T-SQL Record Separator: / Transact-SQL /; I have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on ...; Created on 11 October 2011
19. Joes FREE Website Thumbnailer (JWT): / Product Documentation /; ... Use equivalent COM for screen capture so that program can run in background. ---> create a drag-n-drop website browser supporting SMS and email for administering a Joomla! CMS website :D v0.6 ...; Created on 28 June 2011
20. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; Update June 2013 - How to use this migration script: Make a backup copy of your old Joomla website (1.5.x) Download and install the latest Joomla CMS Go through the Joomla Web-based Installation ...; Created on 30 January 2011