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

09 March 2011 the purpose of cramming information endlessly in cyberspace. So we want to give a search engine to our users. This sounds really simple, we could try: $search_term_esc = AddSlashes($search_term); $sql = "SELECT * FROM Content WHERE content_body LIKE...

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

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

29 March 2011 Studio (BIDS) version 2008 through combining Transact-SQL and 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...

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

What's the problem? Amusing computer issueshttps://joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 "My computer has swallowed my CD-Rom, I put in the disk but when I eject the CD there's nothing in there!". I can't really have a go at customers as it took 4 IT technicians deliberating over 30 minutes (remote support so we weren't there in person):...

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

List all cron jobs for all usershttps://joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

04 May 2011 little script I found on Stack Overflow. Wasn't really my solution as after 2 hours, realised that the customer had been looking at the wrong server. But this script showed me where the cron job we intended was located. #!/bin/bash # System-wide crontab...

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

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

28 June 2011 their site and with extreme squinting, you can distinguish between the two, then this may not be your solution. Otherwise really? Are you Alexa.com? Preview accuracy is accurate to the time you ran the program and generated the thumbnail... Do more? If...

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

Basic Webpage Controls with JavaScript / COMhttps://joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 learn some basic JavaScript, and then "translate" that code to use with COM in AHK. COM - (Component Object Model) All you really need to know about COM for this tutorial is that Internet Explorer is a COM object - which means we can use COM to...

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

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

07 July 2011 space allocated on your website and RocketTheme templates would create a style that was hard to customize. Remository Really liked this and used for the best of 2 years. But 1000 downloads in 10 days caused it to crash my Joomla! website. It was very...

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

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

24 August 2011 source: > Data tab > From Other Sources > From Microsoft Query > select Data Source Specify SQL Query: > Add Tables (not really just "close" this) > click on SQL button > Type/Paste your SQL Query > OK > Click on "Return Data" button Report Type: Select...

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

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

30 September 2011 Training these people in adjusting row height would be like a magician revealing the secrets to his tricks... no it wasn't really, time was the issue. Additional conditions Direct access to our databases, both development and production, means that...

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

Migrate Joomla Users to WordPresshttps://joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

03 October 2011 categories like Wordpress. There are lots of commercial migrators out there and they all seem to have this problem. I'm really keen not to ask all my users to have to change their passwords but that is what the commercial applications are doing. The...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 do the select to check that the update happened. Unfortunately this means that when the report was executed, it could only really display a message saying "executed stored procedure", "please click on the link to continue" and then the user would be...

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

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

19 January 2012 how much delay this minor detail caused!!! No data displays in SSRS but procedure compiled without warnings - My fault really, the field name aliases specified in my second select query (the one preceded with "open cursor for") didn't match my SSRS...

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

Joomla article modal with clear buttonhttps://joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 A usage example is: Just copy & paste the below into a PHP file and include it in your component, the solution is really that straightforward. Feel free to check for any dodgy code but I've simply added the clear button to the existing article modal...

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

Preg_Replace all strings between two tagshttps://joellipman.com/articles/web-development/php/preg-replace-all-strings-between-two-tags.html

07 February 2013 string' $string_formatted = preg_replace ( '/\'([^\']+)\'/e', 'stripslashes(strip_tags("$0"))', $string_formatted ); // really important to suffix the expression with 'e' $string_formatted = preg_replace ( '/\'([^\']+)\'/', '$0', $string_formatted );...

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

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

07 May 2013 files are enough to start adding your own code to make the "relevance" ordering more relevant.... ok still to come as I'm really happy with what the above already improves! Download the above modified files. The following ZIP file contains the default...

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

Include a carriage return in a column headinghttps://joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 To: MS SQL Server 2008 R2 MS Windows 7 Enterprise (Client) MS Excel 2010 What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at...

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

Add attribute xsl:nil=true on empty elements using XSLThttps://joellipman.com/articles/web-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

18 August 2014 at the XML output from SITS (this is a cut down version for demonstration purposes): 1234567 JOEL LIPMAN Two things to do really: Add the xmlns:xsi namespace in the xsl:stylesheet tag so that "xsi:nil=true" is valid. Test for a string length of greater...

• Type: Article
• Author: Joel Lipman
• Category: XML Stylesheet Language Transformations
• Language: *

DJI Phantom FC40 - Fun at the raceshttps://joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-fun-at-the-races.html

17 September 2014 the reason I wasn't using my propeller guards was that I clean forgot which was rather reckless of me, but the winds were really strong, I'd doubled the cost of the quadcopter and that's my mate's girlfriend. I'll use the guards next time if the wind...

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

Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

09 May 2019 are workarounds however. How? The first note is that there is something that can emulate a random number... well it's not really random, it involves getting the milliseconds from a time object. v_Uid = zoho.currenttime.toLong(); // returns something...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 2020, this is how I do it. How? So the trick is, go over the official documentation, but don't take it as gospel. You only really need the syntax for attaching a document to a Sales Order in Books and the documentation leaves certain bits out. Just...

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