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

23 September 2009 in the browser toolbar. Displays your browsing history in the tab. Press Backspace, or Alt and the left arrow together. Goes to the previous page in your browsing history for the tab. Press Shift+Backspace, or Alt and the right arrow together. Goes to...

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

Can't play music after Firmware Update Version 3.0https://www.joellipman.com/hardware/cant-play-music-after-firmware-update-version-30.html

21 September 2009 from the BBC has come to PS3 in Europe but I'm less impressed about the multi-audio output. My setup is that the sound goes from the Playstation to the Sound System via Optical Out. I found that if you do enable the multi-audio output then you can play...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 to get the "cannot connect to MYSQL." I contacted my webhost, and the problem is the number of MYSQL database queries. It goes up to about 200,000 in the first few minutes of use and then after that every page load is a few hundred to few thousand...

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

This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://www.joellipman.com/articles/web-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

08 October 2009 big the SWF files are by your server. We changed ours to 20Mb to accommodate for 5 minute SWF videos... If the screen just goes blank when you've uploaded a file, then you'll need to debug. Put the following code at the beginning of your...

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

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

06 April 2011 00:30:00 - 2011-03-08 23:30:00 = -23.00 This is great for everything during that date as long as the "To Date" never goes past midnight into the next day... But what system doesn't do this (no Microsoft jokes please)? The Solution Eureka! Or duh! for...

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

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

15 April 2011 of his PhD degree, it's a shame he started in his last year. He used functions to mktime and simulate the dates. A function goes in with a normal calendar date and returns an academic week number and the week commencing date. Problem? The 1st of January...

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

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

01 March 2011 No! Security Check Usernames/Passwords (formats, defaults and vulnerability) Technical Review Examine all functions: what goes in, what comes out? (accepts/returns, data types specifically, test by running each function separately) Examine databases...

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

Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 Excel spreadsheet and they would then save as PDF and send to appropriate staff. Other Issues I usually felt that CHAR(13) goes hand in hand with CHAR(10) and although it displayed and printed properly, when saving as a PDF, CHAR(13) would return weird...

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

MySQL last year week month day trend periodshttps://www.joellipman.com/articles/database/mysql/mysql-last-year-week-month-day-trend.html

31 October 2011 I recently made a joomla module that displays the lastest members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count all accounts irrespective of being activated or not). It...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 more than "fun" as most of the examples on the net are either half-complete or partially documented. So here goes... Using Business Intelligence Development Studio v2008 (BIDS) SQL Server Reporting Services v2008 R2 (SSRS) Oracle SQL Developer v3 (you...

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

Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 can step in when necessary but they will not necessarily match my skillset. My associates only get involved when something goes unexpectedly wrong and I do not have the extra time to allocate. They will do the investigative work to get the service up...

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

SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 improvement to the user experience. For one thing, the accidental search for "Jane" and pressing the Enter key, no longer goes off into the interminable loop that is "loading".

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

The greatest invention in IThttps://www.joellipman.com/hardware/the-greatest-invention-in-it.html

13 September 2012 some special 'undo' command)." Source: Behavioral Issues in the Use of Interactive Systems. If you've guessed it, my vote goes for whoever invented the "Undo" button: cross-platform, multi-lingual, future-proof and as everlasting as human error. More?...

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

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 Suffix now works (was not enclosed properly) - Date Uploaded: Mon, 12th Mar 2012 1.5.4.3- Fixed Bug: Weblinks links now goes to link via Joomla component. - Date Uploaded: Fri, 25th Nov 2011 1.5.4.2- Fixed Bug: Category selects from user prefix (was...

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

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

02 February 2019 that is accessible via the web but at least stored (eg. outside your web root) where this script can access it. The same goes for the access token, store it off the web but where this script can access it (read/write). // Location of private key on your...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 of 4 hours. Then item specifics in eBay's listings don't get parsed into custom fields in Zoho Inventory... and the list goes on. So in my job, we tend to create a few custom functions which will download any item from eBay to Zoho Inventory and...

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

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 or update the estimate in ZohoBooks. You will need the returned estimate ID and I'm not 100% sure the attention/phone number goes along as my client didn't include these in her estimate template... But I'm sending them anyway. Note(s) The following code...

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

What can MAGA’s do to stop Biden from cheating again?https://www.joellipman.com/articles/_other-misc/jokes/what-can-maga’s-do-to-stop-biden-from-cheating-again.html

28 August 2024 guy goes to a bar and is served by a robot bartender. The robot says, "What'll you have?" and the guy says, "A martini." He then gets the best martini he's ever tasted. The robot says, "What's your IQ?" The guy says, "167." The robot proceeds to chat...

• Type: Article
• Author: Joel Lipman
• Category: Jokes
• 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 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 1990. I have a confirmation page and don't want the...

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

Zoho Deluge: Push a value to a datetime field in CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-push-a-value-to-a-datetime-field-in-crm.html

10 September 2021 A very quick article to show pushing the date and time to ZohoCRM or ZohoCreator. Why? You may have received an error that goes something like: datatype: datetime How? Here are some formatting examples: Creator to CRM: v_CreatorTime =...

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