Converting SQL date in PHP to European date format and vice-versahttps://www.joellipman.com/articles/web-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

17 September 2009 and the SQL column and table names as per your setup. Converts 2001-06-25 09:41:00 to 25/06/2001 09:41:00 And Vice-Versa: $posted_datetime=$_POST['this_datetime']; $posted_datetime_array=explode(" ", trim($posted_datetime));...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 JoelLipman.com reserves the right (but not the obligation) to remove or edit such content, but does not regularly review posted content. If you do post content or submit material, and unless we indicate otherwise, you grant JoelLipman.com and its...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. All this blab actually means is that there is a chance one of your date...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Remove write-protect from USB pen in Windowshttps://www.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 on the Internet who doesn’t use the “remove device safely” blab and he got the same error. He (unless Andy is a girls name) posted to a forum which was even more useless asking him about a write-protect switch (physical). The user then said nevermind...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

SQL Queries for Statisticshttps://www.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 ) t2 GROUP BY MONTH(t2.Date); Notes: I use this in a PHP script so where year is specified (2010), I have a variable posted from a HTML form in my PHP. Also note: The association to a user can change because anonymous guests count as guests until they...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

List MediaWiki Articleshttps://www.joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

22 September 2011 one that was customized for my day job). Thought I already had this somewhere on my site, so it took a while again but I've posted my finished query here: The base query to list mediawiki articles Page ID, Title, Content, Category SELECT p.page_id AS...

• Type: Article
• Author: Joel Lipman
• Category: MediaWiki
• Language: en-GB

Joomla article modal with clear buttonhttps://www.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 (at time of print version 2.5.6) of your component including the all important clear button. What I found was that no one posted this solution which I found is compatible with almost any site and with all my components without having to modify the below...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 I need standalone SQL scripts that can simply be used to search an entire database for a particular string of word(s). I've posted my own as well as some others I've lifted from elsewhere, as they worked with my environment, to put them in one place on...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. Why? So the solution must be obvious to you by now. At least that's what...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings in a database and rather than a separate file, it stores...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 away. I have now equipped it with 9" carbon fibre but notice some jello instances so will spend time balancing the props: I posted this for a friend on facebook to explain what a gimbal was for: {youtube}B_24vcZ7nTA{/youtube} Oh and a really helpful...

• Type: Article
• Author: Joel Lipman
• Category: Quadcopters
• Language: *

Submit form as a server and not the client with cURLhttps://www.joellipman.com/articles/automation/api-misc/submit-form-as-a-server-and-not-the-client-with-curl.html

20 February 2015 the format they accept) Note that in the following example, the XML is sent as a url encoded value paired with a key (posted variables must be key1=value1&key2=value2...) Script #3: process returned data

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 execute post $result = curl_exec($ch); // close connection curl_close($ch); Things I stumbled upon regarding SSL and cURL Posted data for third-party apps is often required via SSL so this may come in handy curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Joes Revolver Map (JRM) Downloadshttps://www.joellipman.com/component/content/article/joes-revolver-map-jrm-downloads.html?catid=92

07 September 2015 to its container. - Added div and parameter "module class" so that class name actually works... - Trimmed any spaces from posted data and html code. - Used revolvermaps.com selection of "width x height" values. - Date Uploaded: Fri, 30th Jul 2010 1.1-...

• Type: Article
• Author: Joel Lipman
• Category: Downloads
• Language: *

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 A quick article on my adaptation of some code posted by Poorvik Palanikumar on the Zoho Community Forums to connect a ZohoCliq to the OpenAI API and ChatGPT... Note that I have another article for those who want to integrate ChatGPT with ZohoZIA. Why?...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Code Troubleshooting Checklisthttps://www.joellipman.com/articles/web-development/code-troubleshooting-checklist.html

03 June 2011 received/returned by functions, classes and procedures? Confirmed any ACL/permissions on the files? Ensured all global, posted and session variables are present when they should be and behave properly? Broken down the error in understandable and...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

SQL: Use CASE for Relevance columnhttps://www.joellipman.com/articles/database/mysql/sql-use-case-for-relevance-column.html

03 August 2013 a dropdown search field which has to find relevant terms to autofill/autocomplete a search form: -- where @ThisSearch is a posted (and sanitized) variable SET @ThisSearch:="Brains"; SELECT columnID, columnFullName, CASE WHEN columnFirstName LIKE...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Zoho Deluge - Hide Reset Button on Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-hide-reset-button-on-form.html

15 November 2018 as I couldn't find a solution on the forums. This is to hide the reset button on a non-stateless form (state form?). I have posted this on the Zoho forums as well but here goes: Why? Because I can. And because as someone said, a "reset" button is so...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

COVID-19: Working from Homehttps://www.joellipman.com/covid-19-work-from-home.html

05 July 2020 I figured on a personal DSE assessment and setup my workstation as a more permanent solution. For fun, our office have posted what taking your work home, including the work computer, looks like... I made mine into a meme:

• Type: Article
• Author: Joel Lipman
• Category: Articles
• Language: *