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

03 June 2011 quickly suggest ways of pinpointing the source of the problem: In a database/web environment, have you? Commented out lines that you suspect might be the problem? Able to run the SQL queries directly against the database? Matched the datatypes...

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

Oracle SQL - Convert given list (CSV) into Rowshttps://joellipman.com/articles/database/pl-sql/oracle-sql-convert-given-list-csv-into-rows.html

30 August 2011 a quick note as to something that worked for me. Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've suffixed a comma to but I want to display this as a rows in a...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

MediaWiki: MySQL to extract path to imageshttps://joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

06 December 2011 after another change freeze, I had sent all Wiki articles modified since the last export but then needed to send all images that had also been either added/modified since. How? Using MySQL, the following query lists the image name, size, user who...

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

SSRS No Delay for First Report of the Dayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-no-delay-for-first-report-of-the-day.html

11 April 2014 to cut the loading time of the first report of the day. Why? Take any SSRS report, if one of us was the first to run it on that day, it would take an additional 60 seconds to get with it and display the report. Any subsequent running of the report...

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

Zoho Projects: Deluge to Submit Custom Fieldshttps://joellipman.com/articles/crm/zoho/zoho-projects-deluge-to-submit-custom-fields.html

17 June 2021 At time of print, the documentation on the Projects API would only show responses rather than requests. Sure it lists fields that are required in the request but not a sample request packaged to be sent. How? Let's assume that my custom fields have as...

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

Add the website name to the page title in Joomla!https://joellipman.com/articles/cms/joomla/add-the-website-name-to-the-page-title.html

06 September 2009 this particular website (my personal one) in every version of Joomla it's been upgraded to, I've noticed some differences that I've noted down below. Specific Joomla Template Providers Everytime I update this article, Joomla seems to come out with a new...

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

Applying a button and centering it in the RocketTheme Affinity templatehttps://joellipman.com/articles/cms/joomla/applying-a-button-and-centering-it-in-the-rockettheme-affinity-template.html

15 September 2009 setting link at the bottom of this page in the footer? I wanted to put one of the styled buttons behind it but then found that there's a lot more to do than just that. Instructions Open the templates/rt_affinity_j15/index.php Look at the last few lines...

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

Keyboard and mouse shortcuts in Google Chromehttps://joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 Keyboard and mouse shortcuts are combinations of keyboard strokes and mouse clicks that you can use to perform specific actions. Knowing some of the Google Chrome shortcuts listed below can help save you time. Window and tab shortcuts Ctrl+N Opens a...

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

Anti-Spam override for all submitted datahttps://joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

03 February 2010 messages sent via your Joomla site? I know certain components of Joomla let you put banned words but I know of even more that don't. If you find all your forms need extra plugins and captchas (such as JezRecaptcha), then the website security isn't...

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

MySQL Data Type Reference Tablehttps://joellipman.com/articles/database/mysql/mysql-data-type-reference-table.html

15 February 2010 Max length 4294967295 characters (4GB of text) Length of string + 4 bytes String Enum ('value','value2',...) String object that can have only one set of allowed values 1 or 2 bytes String Set ('value','value2',...) String object that can have one or...

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

Creating a Top 10 chart with less codehttps://joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 is to do the following: retrieve data from a table, count the number of times each data exists, sort it in reverse order so that the most frequent is at the top of the list print out each row with the number of times that particular data appeared in a...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Joe's Unduplicater (JUD)https://joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 everything in the original folder? Well what if I don't? Then I have to go through a few hundred files manually checking that I have the converted version and deleting the original. SAMPLE USAGE: If you have a portable media player that needs to convert...

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

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 Following up on my article on correcting disappearing headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue could not be replicated on the client machine (ie....

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

Error during processing - Converting Date/Timehttps://joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done this silly mistake. I'm only guessing the same error would happen...

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

Passwords: Did-you-knowhttps://joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 the military boasts being able to crack 90% of user passwords in under 48 hours on a Pentium II/300. Additionally, it claims that it can crack 18% of the passwords in under 10 minutes (source: SpiesOnline.net 09/2006) In the UK a worrying 3.7% use the...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Merge the content of two similar tables in MySQLhttps://joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 I don't use the `id` columns of the tables as I'm quite content with just the two columns I requested. And for those of you that don't know, the alias "AS" is optional in MySQL (think it's optional for most SQL forms). I found that to add further...

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

Room with a view E.M. Forsterhttps://joellipman.com/articles/_other-misc/room-with-a-view-em-forster.html

04 February 2011 place where you won't do very much harm, and stand in it for all you are worth, facing the sunshine."... "...she reflected that it is impossible to foretell the future with any degree of accuracy, that it is impossible to rehearse life. A fault in the...

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

Difference between two dates - the midnight hourhttps://joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

06 April 2011 This is because the script is not changing the date at the stroke of midnight. Take the last row as an example, the equation that's happening is: $thisDateSQL=date("Y-m-d", strtotime($sub_row['DateSession'])); $this_time_from1 = date("H:i",...

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

CSS Background Without Causing Scrollbarshttps://joellipman.com/articles/web-development/css/css-background-without-causing-scrollbars.html

23 April 2011 webpage with background (where left is 0 [zero] because your width is 100%). Position the background image bearing in mind that your layer is 100% of the viewable browser page. .templateclouds { position: absolute; top:60px; left:0; background:...

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

Creating a Profile Plugin for Joomla 1.6https://joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 on the official Joomla 1.6 documentation: http://docs.joomla.org/Creating_a_profile_plugin and I want to use an example that worked for me. Important: This is for Joomla version 1.6.x+. Aim / Objective Add a field with a dropdown list. Add a button to...

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