CSS keeping the footer at the bottomhttps://joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 layer that overlapped it half-way. I managed to fix this by including a div push layer which clears both (even though i had clear:both on the css for my #right div layer). For some reason, it has a more forceful effect in its own separate layer. In a...

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

PHP & MySQL Search Enginehttps://joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 AddSlashes($search_term); $sql = "SELECT * FROM Content WHERE content_body LIKE '%$search_term_esc%'"; Great! Few problems though, multiple terms are not supported; quotation marks and apostrophes may be an issue; Full PHP:...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 how I got a client's eBay to notify the seller every time a buyer bought a fixed price item. This uses the Trading API even though I'm aiming for the Platform Notifications API... Why? A follow on from my article Zoho Creator: Push to eBay Listings. I...

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

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

25 September 2009 Obviously something is not right. I am searching the forums for an answer and if I don't find one I'll repost. I just thought I'd share this with you in case this your problem too. Source: Joomla Forum:...

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

Write a Calendar in Autohotkeyhttps://joellipman.com/articles/automation/autohotkey/write-a-calendar-in-autohotkey.html

27 January 2010 can't download the calendar, it had to display an offline version in the GUI. To display the following code in this website though, I've had to omit a lot of the HTML part. This is the code in full; apologies for the mess coding but it's a mix between...

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

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

28 January 2010 The Issue People have reported that although they have manually set the date/time on their computer, this gets changed by the windows time server (time.windows.com) when connected to the Internet and for some reason it doesn't display the right...

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

Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparisonhttps://joellipman.com/articles/cms/joomla/lazy-stats-yootheme-and-gavick-pro.html

08 April 2010 subscriber. There were issues with some modules but the forum is frequently administered and the response was quick. Though the problem was not resolved. RocketTheme Great graphics and their templates come across as commercial flashy sites. Their own...

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

Joe's CSV Chart Generator (JCG)https://joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 a flash-based interactive chart which you can zoom in and out of, includes almost every type of chart you can think of (though this program only uses chart types: Area, Bar, Column, Line and Pie). Note that AMCharts.com is free as long as you leave the...

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

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

13 July 2010 (SSAS) and Reporting Service (SSRS) projects/solutions. The features and interface are very similar when developing reports though. The error I'd get was An error occurred during local report processing. An error has occurred during report processing....

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

Is it a scam? Gumtree.com's warning signshttps://joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 This list used to be on Gumtree's website but I can't find it anymore. This is quite a thorough list though it still needs some work. Requests to use money transfer services like Western Union or MoneyGram. These services are not meant for transactions...

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

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

29 March 2011 MDX expressions" 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...

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

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

07 July 2011 be incorrectly designed. Interestingly enough there is a Bug Tracker for Remository that they use (not Joomla! integrated though?). Joes Bug Tracker (JBT) is a Joomla! CMS component created by JoelLipman.Com as a download manager and bug tracker all in...

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

SSRS External Images don't displayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 we have several MS Sharepoint sites but we didn't go down the route of uploading 10000+ images into a Sharepoint database though we are still considering it; so this article is more about just getting external images to display when they are provided...

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

Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 versions. Some devices are designed to deny users access to install or run modified versions of the software inside them, although the manufacturer can do so. This is fundamentally incompatible with the aim of protecting users' freedom to change the...

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

Reorder Columns in a Tablehttps://joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 interface, apparently, you can drag the columns by clicking and holding on the headers when viewing a table structure... Though maybe this is derived from a template and depending on if you are using MS Internet Explorer... Can't get it working? I use...

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

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 the appropriate scopes. The scopes I chose were to do with getting a working example rather than the recommended scope, though you may only need the first (untested): https://www.googleapis.com/auth/drive.file...

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

Zoho Creator: Retrieve record with case-insensitive queryhttps://joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 Thought I'd put an article here to remind me how to make the retrieval of a record case-insensitive. Why? Consider that I have the following creator table: Product_Name Product_SKU -------------- ------------- MyProduct1 TEST01 Myproduct2 TEST02...

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

AutoHotkey: Get Media Information and Displayhttps://joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 explorer in the Microsoft Windows OS. Why? I had an app for use in MS Windows 7 to display the properties of sound files though this is also applicable to media files in general. How? So first I'm going to list a function I use called "Filexpro()", then...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 any of your code. How? As someone who's been using Zoho services and programming in Zoho Deluge for a few years now, even I thought of Zoho Widgets as a daunting task. But after doing some, I realize this is actually very quick to do and much easier...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 .joellipman.com and www..joellipman.com (for the subdomain). I have had this working with the 2 CNAME records though. Some providers say this will take between 24-48 hours but I have often found that after a few hours, the effects have been propagated....

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