ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 ??? - ??? More Information: Ensure that all possible tax rates in Xero match those in Zoho; the output of this function will give you a copy&paste list ******************************************************************************* */ // init v_Output =...

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

On Gui Resize Eventhttps://www.joellipman.com/articles/automation/autohotkey/on-gui-resize-event.html

09 November 2009 resizes your program. If you search and search, you'll find that GuiClose responds to when you close the app, and GuiSize will run when you resize the app. Syntax: GuiSize: GuiControl, MoveDraw, MainRedBackground, w%A_GuiWidth% h%A_GuiHeight% Return If...

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

JComments errors in PHP 7: plgContentJComments and JCommentsACLhttps://www.joellipman.com/articles/cms/joomla/jcomments-errors-in-php-7.html

13 March 2020 to fix the errors. How? First some errors: ERROR: plgContentJComments Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; plgContentJComments has a deprecated constructor in...

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

Disclaimerhttps://www.joellipman.com/static-items/disclaimer.html

30 May 2009 the website for any purpose. Any reliance you place on such information is therefore strictly at your own risk. In no event will we be liable for any loss or damage including without limitation, indirect or consequential loss or damage, or any loss or...

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

Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

17 September 2009 environment. The Solution 1. The first thing to do is check that your HTML form is setup to do this:...... The form above will post to itself but more importantly is the enctype="multipart/form-data" without which your file upload processing won't...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• 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 { global $wgAllowTitlesInSVG;... That's all I do. This means that you are allowing all SWF files to be uploaded. You will be restricted in how big the SWF files are by your server. We changed ours to 20Mb to accommodate for 5 minute SWF videos... If...

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

Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 time server is ticked Select an option from the dropdown menu starting with the first Click on the Update now button Text will appear beneath the button If you get an error, then select a different server from the dropdown If you get the text The clock...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

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

03 February 2010 it displayed!!! I have written this article to be another one of those programmer's tweaks. This is quite a simple fix and I will hopefully be able to keep it simple for non-programmers. The tweak below will stop any of your pages submitting content...

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

Create Read-Only Database User in SQL Serverhttps://www.joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 SQL Server Management Studio 2008: Connect to your database server. Expand Security > Logins. Right-click on the user who will be set as having read-only access (in this example "adventureworksro"). Select Properties. Select User Mapping. Map the login...

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

URL passed settings in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 encountered Note there appears to be an issue with regards to rendering. An updated and deployed report on the same day will render fine in a webbrowser but when exported to PDF format, it will retain the previously deployed report settings...

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

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

29 March 2011 but boy what a mouthful, and it's not really iterating anymore. So it's "SSRS Hide results table if empty" though I will add that if you wanted to put a message instead of hiding the table then following the below will also let you do this...

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

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

15 April 2011 2012-07-09 00:00:00 Joe you're an idiot! You might say to me why not run the CMIS Facility application and add a new set, it will put these dates in automatically. Herein lies the problem The reason I'm doing this is for another system which decided to...

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

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

17 November 2011 was just confusing the end-user... Workaround #1 Although I'm convinced of a solution considering the ReportServer database will be able to tell you how many milliseconds it took for a report to execute... I decided to do a database level calculation...

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

MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 I 03:45 03:30 03:00 03:30 00:00 00:00 00:00 23:00 Method 1. Generate query to list all valid users 2. Generate query which will total hours per week per user 3. Combine in a loop to run query against each user. Post-Notes (Update 2012) The performance...

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

DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 1 mStnoh iJh 1926-01-02 2 lgreg BFdos 1969-03-14 3 onrUest ehAr 1968-05-05 4 otentre AhYe Usr 1964-08-08 Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Used to reference RAND with in a...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• 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 password, database, etc.). For obvious reasons, these cannot be hardcoded. What? Any developer installing my component will do so on a website which uses different login details for their Joomla database. The example below demonstrates how to get these...

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

Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 you to type normally. Clear whatever you type so the field is empty and click somewhere on the page (not on a link as this will take you to another page) and the field returns to displaying "Name:". Why? I've noticed a lot of solutions now use JQuery or...

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

Error 1065: Query was Emptyhttps://www.joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

13 December 2012 herring as it were when in fact the answer to this is very common. Why? Bespoke systems are the usual suspects. Developers will have told the system what to do when newline, carriage returns and tab characters are entered in the data. Those who are...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• 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 developers, a quality assurance environment 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...

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

JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 $db->setQuery($query); $my_value = $db->loadResult(); -- using the data echo $my_value; // will equal the retrieved value of "email" Single Row Result - loadRow() This type of query is for when you want any of the values from one resulting row. You will...

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