Search - Joel Lipman .Com

1. Transact-SQL Date Format Conversions: / Transact-SQL /; Source: http://www.kodyaz.com/articles/sql-format-date-format-datetime-t-sql-convert-function.aspx; Created on 19 November 2010
2. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... Previous Models/Versions Based on the documentation: In the above code, you would change the model value to one of the following code-davinci-002 (optimized for code-completion tasks) text-davinci-002 text-davinci-003 gpt-3.5-turbo ...; Created on 06 March 2023
3. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... browsing to https://platform.openai.com/account/billing/overview. At time of print, the paid plan is a pay as you go or pay as you use. Previous Models/Versions Based on the documentation: In ...; Created on 13 February 2023
4. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... site that had embedded it. Source(s): Zoho Creator - Understand Widgets Bootstrap - Getting Started jQuery - Latest Stable Versions OpenJS Foundation - NodeJS Zoho - Widgets in Zoho CRM ...; Created on 24 October 2020
5. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktops: / AutoHotkey /; ... another screen of app icons. The same can be done to the desktop versions with open applications instead of just their icons. Why? MS Windows 10 has made a major step but when you close down your ...; Created on 18 July 2019
6. MySQL Transactions in PHP: / MySQL /; ... requires PHP 5.6 and above. For lower versions you can issue the MySQL commands directly like: mysqli->query("START TRANSACTION") mysqli->query("COMMIT") mysqli->query("ROLLBACK") Important note: ...; Created on 14 December 2016
7. Foreign Characters create symbols in PHP and MySQL: / Personal Home Page /; ... in this article. How? The fix is a PHP one and has to do with versions of PHP and MySQL. As quoted by the PHP htmlspecialchars: "As of PHP 5.4 they changed default encoding from "ISO-8859-1" to ...; Created on 25 January 2016
8. Protecting your Joomla Administrator Section: / Joomla /; What? This is a quick article to remind me how to move a Joomla administration section and to lock it down to a specific IP address. The below does not involve installing any third-party extensions ...; Created on 23 October 2015
9. Joes Quicklist Weblinks (JQW) Downloads: / Downloads /; ... 1.3.1 - Modified code to work with Joomla! CMS versions 1.5.x - Removed parameter: Use Access Levels (does not exist in J15)- Date Uploaded: Sun, 3rd Jul 2011 1.3.0 - Restructured to MVC model for ...; Created on 07 September 2015
10. Joes Word Cloud (JWC) Download: / Downloads /; ... Date Uploaded: Thu, 28th Oct 2010 1.2.2 - Corrected PHP code to work in earlier PHP versions. - Fixed bug: could not see Hebrew text. - Fixed bug: refer to $fulltext variable which is now obsolete.- ...; Created on 07 September 2015
11. Joes Google Map for Joomla (JGM): / Product Documentation /; What? This article serves as documentation for a module extension I made for the Joomla Content Management System versions 2.5 or later. Why? Could have probably used someone else's. I think there' ...; Created on 13 April 2015
12. Add attribute xsl:nil=true on empty elements using XSLT: / XML Stylesheet Language Transformations /; ... but not This doesn't tell us if the element is just an empty string or null. This doesn't have much affect on point-to-point conversions and strings but what if the value is blank and I try to convert ...; Created on 18 August 2014
13. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connec: / MySQL /; ... #2 (useless fix - unlikely to change anything): Another solution has been advised that you have to tell MySQL WorkBench 6.0 to "use the old authentication protocol": • For versions before 6.0.7 ...; Created on 28 July 2014
14. Convert to Proper Case in T-SQL: / Transact-SQL /; What? So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...; Created on 04 June 2014
15. SSIS Convert a string into a date: / SQL Server Integration Services /; What? Please note: the following article is not a solution but a page of various methods and date conversions which I try and use depending on the situation. This is a quick article on how I got time ...; Created on 14 March 2013
16. Access MySQL databases using Oracle SQL Developer: / MySQL /; ... all freeware until someone expresses an interest in using it and then the supplier will implement restrictions and trial based versions. Oracle SQL Developer is currently free at time of print (01-FEB-2013). ...; Created on 01 February 2013
17. Link to a Joomla article from within another article: / Joomla /; What? Quick article here as googling/binging for how to refer to Joomla articles after versions 1.5.x wasn't obvious. This article is to demonstrate how to write the webaddress for a Joomla article even ...; Created on 04 December 2012
18. Basic Joomla 2.5 Mootools Form: / Joomla /; ... to use the files that Joomla versions 1.6 to 2.5 included in their basic install (vanilla/out-of-the-box). Will not work with Joomla 1.5 or less - Not 100% sure about this but I tried the example in ...; Created on 20 August 2012
19. Connect to Joomla database in standalone script: / Joomla /; APPLIES TO Joomla 2.5.x Why? I'm building a Joomla component which is to be compatible with Joomla versions 1.6.x to 2.5.x. Because I use dynamic scripts running in the background (mootools), some ...; Created on 17 August 2012
20. Migrate JComments from Joomla 1.5.x to Joomla 2.5.x: / Joomla /; ... Check all JComments settings are what you want using the Joomla Admin interface. If the article IDs match then the comments will also match. If however your article IDs don't match in both versions ...; Created on 07 June 2012