$_SERVER['http_referer'] returns blank in Internet Explorerhttps://joellipman.com/articles/microsoft/serverhttpreferer-returns-blank-in-internet-explorer.html

19 October 2009 about this as I spent ages rewriting an entire system. The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check. The only solution is to not use it for verification purposes as it will...

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

UTF8 Unicode PHP MySQL for International Charactershttps://joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 Hebrew, Russian, and Slovak. Fingers crossed this should work for all characters that Joomla! can handle by default anyway. Cause: Q. Why does this work for Joomla! articles and not for this module? A. Think this is because that module is loaded...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 and the time along the top. We select a matrix because this will automatically group the rows by room (you need to do this anyway otherwise it will look a bit like a staircase of bricks). 4. Design the Matrix: In other words, put where all the values...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

SSRS Hide results table if emptyhttps://joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 or the tablix has to be applied to both the textbox and tablix (as tablix doesn't show if resultset is empty by default anyway but still occupies a blank space which moves your textbox down...) Searches that got me nowhere ssrs display message if...

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

Inserting incremental weeks in MySQLhttps://joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 of the Academic year 2011/2012... It tells you 2012-07-10. Ask it what date it is on 2012-07-10 and it doesn't have a clue. Anyway, enough faffing! Here's a script I used to generate the SELECT query. If you run it, it should return the additional 52...

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

Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 Requirements (in case you need to transfer/move to another server) Critical functions used in the system? (do this yourself anyway and use theirs as a guide only) Site Authentication Method(s) (will this need to be rewritten? eg. clear-text passwords)...

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

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 Explorer on the computer it's run. If you think you don't have MSIE but you have Windows XP, it's likely you have it anyway. Open Source: Open to view/modify the source code as long as you attribute credit where it's due. License is GNU General Public...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 Bellends. It's a bit like asking me "Why can't I turn on my computer" and me replying "why would you want to do that?". Anyway, I was looking for something like the record separator in Oracle SQL*Plus where a row of data (blank or made of symbols)...

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

How to Display Report Execution Time in SSRS (milliseconds)https://joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 the time recorded that it took for the query which is somewhat the same thing for us as SSRS performance is always rubbish anyway. Here's a breakdown of the MDX expressions and how I tweaked each one to return the final result: -- to get just the time...

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

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 to be associated to articles from your Joomla 2.5 site (no changes to article IDs but backup your original database (J1.5) anyway before running the following): UPDATE my_joomla_1_5_db.my_1_5_db_prefix_content j1a, -- Joomla 1.5.x Content...

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

Slideshow div layer through a windowhttps://joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 Using AJAX (which will have to be Asynchronous JavaScript and xHTML. I'm not using XML, or is that AJAHtml? AJAH?), anyway, we can send each new info to the next slide and use only two slides in total (that's the aim at least). Other objects (mostly...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

Access MySQL databases using Oracle SQL Developerhttps://joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 wasn't practical to link this to mySQL databases. How? So this is how I did it, I found the process rather straightforward anyway so let's begin: Download the JDBC Driver for MySQL (Connector/J) connector from http://www.mysql.com/products/connector/...

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

Quickly update all content in mySQL database replacing a stringhttps://joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 You might get some errors talking about some empty rows but don't be deceived as the update will have happened anyway. Other Searches Search and Replace a string in a mySQL database.

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

Convert to Proper Case in T-SQLhttps://joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 examples above because the function was only going to be applied to names and titles rather than addresses, but here it is anyway, add this after the "loop through exception cases" while clause: -- Now for some UK (British) PostCode recognition SELECT...

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

Android: Keytool and Google Maps displaying greyhttps://joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 By default this is the SHA1 of your computer but add it anyway to the Google APIs console for testing purposes. To get it again: Finding your computer's Certificate Fingerprint SHA1 Open a command prompt Type CD C:\Program Files\Java Determine your JDK...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 if you go get your public key, paste both keys into jwt.io (these don't change), then paste the encoded assertion. Anyway, this is how you generate the JWT header // Build token header. Specify algorithm $api['jwt']['header']['alg'] = 'RS256';...

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

If Then Else in Report Builder 2.0 Expressionshttps://joellipman.com/articles/microsoft/ssrs/if-then-else-in-report-builder-20-expressions.html

06 May 2010 Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0 I'm looking at the following if statement: If (MyFieldName = 0)...

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

URL Alias uniqueness with PHP & MySQLhttps://joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 DELIMITER ; Note that running this in PhpMyAdmin might show as an error, possibly due to the delimiters, but you can run it anyway. Additional Note(s): The trigger only runs if inserting a record. If your script is trying to modify/update a record with...

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

Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttps://joellipman.com/articles/crm/zoho/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

04 May 2020 So this is a super quick note that I'll probably remember anyway but just in case, I'm writing this article so I don't spend time researching it later. Why? I'm synchronizing Xero Invoices with Zoho CRM Invoices and noticed that Xero stores its dates in...

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

Zoho Deluge: Setup an API Connection for InvokeURLhttps://joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 name Connection LinkName: Put the link name that we will use in code later (preferably in lowercase as it will lowercase it anyway) Scope: Enter each scope you need and click on the plus icon to add each one. Keep "Use credentials of login user" ticked....

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