MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

28 November 2011 another table then using data from the same table. MySQL SELECT ( SELECT GROUP_CONCAT(column_to_return_as_string) FROM a_pretend_table WHERE a_condition=true ) AS my_field_name FROM another_pretend_table T-SQL SELECT STUFF( ( SELECT ',' +...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 said. For demonstration purposes: I am installing phpBB3 on a website at http://www.mysite.com/ and am going to pretend the server path is /home/user/var/public_html/ These are the instructions for our usual setup: A working website in Joomla CMS...

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

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 of the stored procedure, please view my article SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel EXECUTE MY_PRETEND_STORED_PROCEDURE('value1','value2','value3',:errorcode,:errormsg) Still discussing this stage... Not proceeding with this as...

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

301 Redirect using htaccess filehttps://www.joellipman.com/articles/web-development/301-redirect-using-htaccess-file.html

03 April 2014 (or modify the existing one) Add the code as per below. Save the change. Different ways for different results, let's pretend I'm redirecting from myolddomain.com to mynewdomain.com: RewriteEngine On RewriteRule ^(.*)$ http://www.mynewdomain.com/ [R=301]...

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

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 ; set up array of jokes Joke1:="I pretend to work here, work pretends to pay me." Joke2:="He sets low personal standards and then consistently fails to achieve them." Joke3:="If he were any more stupid, he'd have to be watered twice a week." Joke4:="He...

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

SSIS Multiple Lookups in onehttps://www.joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

05 August 2014 I created one lookup task that executes a SQL query which returns all the joined tables and displays the decode name. Let's pretend the info we want is rather simple: SELECT [sequenceID], [student_reference], [student_title_code], [student_name],...

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

Excel: convert degrees minutes seconds to decimalhttps://www.joellipman.com/articles/microsoft/excel/excel-convert-degrees-minutes-seconds-to-decimal.html

06 November 2014 A quick article on how to get the value of 40°4′20″N 116°35′51″E into 40.079857, 116.603112. How? Let's pretend all the names are in column A, in Column B I have the coordinates that I want to convert: A B -------------------------------------...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 127.0.0.1 this time, the website sent back unusual and incorrect credentials. This may happen when an attacker is trying to pretend to be 127.0.0.1, or a Wi-Fi sign-in screen has interrupted the connection. Your information is still secure because...

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

Zoho Creator/Deluge: Calculating with Timezone Offsethttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-calculating-with-timezone-offset.html

07 December 2021 their DST offset as well as a boolean to say whether Daylight Savings Time is in effect for this timezone or not. So let's pretend we have a creator form wth the following fields: TZ Database Name (single-line) UTC Offset (single-line) UTC DST Offset...

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