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

07 September 2015 Using div layers instead of tables. - Fixed Bug: Switched CSS ID tag to CLASS for W3C Validation. - Fixed Bug: Now allows description inline with popup (strips HTML). - Fixed Bug: Removed duplicate slash in weblink href. - Date Uploaded: Wed, 3rd Aug...

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

Zoho Creator: Embed Forms/Reports on a Pagehttps://www.joellipman.com/articles/crm/zoho/zoho-creator-embed-forms-reports-on-a-page.html

05 May 2022 for a Zoho Creator page. We set the parameters of the form/report. Then this shows how to embed using a DIV layer which allows for CSS styling. The last part shows how to embed using an IFRAME tag which isn't great for CSS styling as you can't do...

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

ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 - Label: Products - Correct Decimals Trigger: On Products Edit Page (Standard) > Page Event OnLoad Purpose: ZohoCRM only allows up to 6 decimals but some calculations are resulting in more than this which blocks users from saving a record without...

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

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 Hash/Sum and numerical post/get data (anti-SQL-injection?). Minimal typing (for click-happy people like me). Currently only allows for back-end Joomla! administration. Automatic version control Automatic changelogs based on support tickets/development...

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

Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 for our clients to test these, and then a live/production environment that will be released for public use. This allows for a good test bed and stable releases, error and hopefully risk-free. How? Here's one method I used based on the services available...

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

SSRS Stop Scrolling Behindhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 I could have ended up in such a situation, here's the design mode of the report (apologies for the red censoring but this allows the images to be used in further demonstrations): Note that a footer exists (contains page number) because if printed, the...

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 into the new table `#_categories` where `id` > 7 Add column in #_content just before note called `xreference` VARCHAR(50) allows NULL. Import Content (articles): export SQL file and amend the insert(s) into the new table `#_content` Import Users: export...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 set up websites with NO 3rd-party items whatsoever... For those of you with this issue, I'd double-check your website host allows Joomla and if they don't, look for either an upgrade or a different host. If your website has been LIVE for a while and...

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

Some milestones for a website projecthttps://www.joellipman.com/articles/web-development/some-milestones-for-a-website-project.html

14 April 2010 Vertical slice – normally a few sections of the website are produced with many of the website features in and working, this allows reviewers to get a feel for the site, the level of usability, the saleability of the product and technical risk involved...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 database will do). Special care has been made to avoid the use of functions, stored procedures, temporary tables, etc. This allows broader compatibility and customers who do not have DBAs to run this themselves. Personally I grant the user who will be...

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

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

28 June 2011 image editors out there that will batch convert your images: 150x100, 200x150, 300x200, and 1:1 Output Thumbnail Quality: allows you to specify smaller/bigger files (haven't noticed much difference in how they display, only in the actual size the image...

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

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

03 July 2011 prints with linkback - not Chrome compatible) Thumboo.com (Signup required - NO GO) WebShotsPro.com (Not FREE but website allows 1 thumbnail free - :c) ThumbShots.org (unknown number of FREE prints - Tested: Add...

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 far. Fast, quick to setup and a big fat refresh button for the executives. SQL query returns individual items while Excel allows drag and drop grouping/drilldown pivot tables. Have managed to get this working with SQL Server, Oracle and MySQL...

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

Joes Network Transmission Detector (JTD)https://www.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 signups, etc required, have fun! What's it detecting? Currently it just reads the size of packets sent and received. This allows me to test websites for example and compare page loads. It's more fun on a networked computer which is constantly writing...

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

Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 to this script you have to use the $_GET, $_POST or $_SESSION methods. Or redeclare it after the above. MYSQLI_USE_RESULT allows these results to be used once, remove it if you need counts or to use the data later on. Further Post-Joomla 2.5 aides...

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

Search a database for a value and count matching rowshttps://www.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 procedure by ** ** declaring @p_Value and @p_Column and using only the code ** ** from the BEGIN to the END (exclusive) - allows you to run ** ** this against any table only changing the parameter column. ** ** ** ** Usage: ** ** EXEC...

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

Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 enhance the relevance factor: Soundex: Built-in function to list matches that sound like the search term. Levenshtein: Allows for typos and matches to words that are 1 or 2 letters mistyped. Grammar: Account for singular/plural, past/present, and...

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

Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 same error, change the site template to a default one and see if that works. Check your cookie policy: Open a browser which allows cookies, and one that does not. Visit your site with both and attempt the password change.

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

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

15 November 2013 plan the same again). My 15 years of web-development experience allow me to reduce the risk of nasty surprises and also allows me not have to Google search every solution. As an IT developer, I often get told I may win the lottery or get run over by a...

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

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 while copying. /F Displays full source and destination file names while copying. /L Displays files that would be copied. /G Allows the copying of encrypted files to destination that does not support encryption. /H Copies hidden and system files also. /R...

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