Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 UNION ALL clause. Scenario: I have a Joomla module which should take the keywords from a specified number of different but similar tables. I'm looking to query the Title and the Introductions of any valid articles from BOTH tables and return one table...

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

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 the data to a MSSQL database. Run EOR from the menu system Enter a EOR code (for everyone's sanity, name it something similar to the DOR code) Complete the form as per previous details ensuring you use the same Message Group as the DOR. In our example,...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 Project Manager? other 3rd-parties?) Contacts within Client company? Budget (see Rates for Joellipman.com below) Similar looking websites and colour schemes Will the website be the primary medium for the Client? Affiliates / Associate Websites? Any...

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

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 linked to events in a database. I'm calling this project "Reinventing the Wheel" because the request was a report that was similar to an MS Outlook calendar which will display any room bookings for that month. This is "Reinventing" because we used to...

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

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

05 July 2011 intermediate AHK user how to start using COM to control webpages. My goal is to provide methods for controlling webpages, similar to how the AHK Control Commands can control Windows Applications. This tutorial is going to be high level, but will provide...

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

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 all variations to be typed the same way in the same case. Wouldn't it be nice to search through your entire database for similar sounding values (so not just case), and in this example, find typos as well, eg. "Daat ont Ety Aviable". How? Mine's a bit...

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

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

03 April 2009 any applicable law fulfilling obligations under article 11 of the WIPO copyright treaty adopted on 20 December 1996, or similar laws prohibiting or restricting circumvention of such measures. When you convey a covered work, you waive any legal power to...

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

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

27 January 2013 Single Row Result - loadAssoc() This type of query is for when you want any of the values from one resulting row. Similar to "loadRow()" but you refer to the results using their column name: $db = JFactory::getDbo(); $query = $db->getQuery(true);...

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

Warning: Save failed. Another menu item has the same aliashttps://www.joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 page but I already have two items using the alias "about" and "about-us": Login to the Joomla Admin Panel and ensure any similar menu items are accounted for. Remove them if they are not used. Create the menu item that caused the warning but give it a...

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

Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 but the only method reliable enough I have found to work each time is using the CRM Object Query Language or Zoho's COQL. Similar to SQL but subject to similar issues of escaping special characters... 1. Setup a CRM Connection to Search Records via API...

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

GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 downloading or copying of account information for the benefit of another merchant; or Any use of data mining, robots, or similar data gathering and extraction tools. This site or any portion of this site may not be reproduced, duplicated, copied, sold,...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 are fully aware of this and seem to be committed to keeping their templates compatible with phpBB. phpBB3 installs similarly to Joomla CMS. As a personal preference, I set up a new database and a new mysql database user which will be used to store the...

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

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

13 July 2010 our SQL Server Analysis Service (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...

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

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

12 October 2010 send you the product. Payment for brokerage/importing. A seller claims that there are brokerage fees, import duties or similar fees required to get an item into the country. Don’t pay these fees. You’ll most likely never get the product and will lose...

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

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

09 March 2011 is it relevant? (when it isn't, the sound matches and then it's a typo on the sound so it matches words that are vaguely similar instead of spot on). $didyoumean_words_array=array(); foreach ($terms as $term) { $term=strtolower($term); # get closest...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 [ROOMS] rms WHERE rms.SiteId=@siteId AND rms.SetId=@setId ) You should be able to provide this statement with a result set similar to the following (if you include a tooltip with loads of info then just picture it at the end of these fields): Time Room...

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

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

29 March 2011 pasting from other sites to add content to my own. And I'm not just adding content, the way I'm doing the below is nothing similar to what I googled (probably a bad sign but time is ticking and no one has forever). Situation: I have a report which I've...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• 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 might already have something similar to this but this deserves its own article. Why? Well try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on the same date, when one of the hours is on the other...

• 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 week numbers is because these are academic week numbers. So I can't use the built-in functions. The current structure looks similar to this: ID SetID WeekNumber StartDate --------- ---------------- ---------------------- ---------------------------- 1...

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

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

24 August 2011 levels of management? Could add a WHERE clause to the query so own teams can only see own data (requires setting up a similar report for each team).

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