How to redirect the visitor after the contact pagehttps://www.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

06 September 2009 How to redirect the visitor after the contact page: Open Contact.php and go to line 473 - 475 and change the line: $link = ‘index.php?option=com_contact&task=view&contact_id=’. $contact[0]->id .’&Itemid=’. $Itemid; mosRedirect( $link, _THANK_MESSAGE )...

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

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 NTP client to update more often. Note: The following process requires administrator (installation) rights on your computer. Open regedit.exe through the start menu search box, and then find this registry key:...

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

Windows 7 Aero Featureshttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 are these Aero effects? Aero Peek: Aero Peek What this is it gives you a preview of windows in a thumbnail without actually opening them by simply hovering over the icon in the taskbar. Click on one of them and you will be taken to that window, this...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 User is the mysql username Database is your selection and should auto-populate if the connection is successful TEST > OK Open the data connection Open Business Intelligence Development Studio (BIDS) Click on "View" > "Server Explorer" Right-click on...

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

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 and table names used (DO NOT CONFUSE THE FOLLOWING DATABASE NAMES OR YOU WILL END UP WITH NEITHER SITE WORKING!!!) Open the SQL file in your favorite text-editor Rename any instance of "my_old_database.jos_" to the name of your old Joomla 1.5...

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

Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 other instructions out there on the web but I thought I'd put what I did so that when I did the above it would all work: Open your form in InfoPath Go into Design mode Go to "Controls" and add a Drop-down List Box to your form Right-click it and select...

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

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

24 August 2011 this. Hopefully this article will help you more than my search engine skills do. My Setup Windows XP Workstation...needs to open... Excel 2007 SP2...with ODBC to... MySQL v5+...hosting database... ActivityLog...contains activity, staffID,...

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

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

19 January 2012 INTO p_STUDENT_REF FROM student_accounts WHERE student_accounts.student_username = p_STUDENT_ADNAME; -- opening cursor for the select query that I want to display in SSRS OPEN l_CURSOR FOR SELECT INITCAP(b.p_title) || ' ' || INITCAP(b.p_forenames) || '...

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

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 simple_replacement_html, simple_replacement_text, pattern, -- replacement_html, replacement_text, button_acl, button_open_tag, button_close_tag, -- button_title, button_prompt, button_image, button_css, button_enabled, ordering, -- published -- ) --...

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

Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 'nchar', 'varchar', 'nvarchar', 'text', 'ntext') AND TABLE_SCHEMA='dbo' ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME; OPEN MyCursor FETCH NEXT FROM MyCursor INTO @SqlToExecute WHILE @@FETCH_STATUS = 0 BEGIN PRINT ' union all ' + @SqlToExecute; FETCH...

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

DataTumble - Randomize Data Rowshttps://www.joellipman.com/articles/database/t-sql/datatumble-randomize-data-rows.html

07 December 2012 = ' SET @UpdateCursor = CURSOR FOR SELECT ' + @ColumnName + ' FROM ' + @TableName + ' WHERE ' + @WhereClause + ' FOR UPDATE OPEN @UpdateCursor' EXECUTE sp_executesql @UpdateSqlStatement, N'@UpdateCursor CURSOR OUTPUT', @UpdateCursor OUTPUT SELECT...

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

ReCaptcha disappears from Joomla 2.5 Registrationhttps://www.joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

24 November 2013 the problem: Method #1 I prefer this method as it changes less code and is more likely to be supported in a Joomla update. Open the file /plugins/captcha/recaptcha/recaptcha.php and find the following 3 lines of code : const RECAPTCHA_API_SERVER =...

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

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 Vista and Windows 2008 without XCOPY, try ROBOCOPY. How? We're going to use MS-DOS because I'm that old. Robust File Copy: Open a command prompt (Start > Run... > CMD > ok) Type the following: ROBOCOPY c:\Sourcepath c:\Destpath /E /XC /XN /XO -- /E...

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

Registered Users Cannot Login - Super Users Canhttps://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 that and that is "root". Login to your Joomla database using your MySQL database manager (eg. phpMyAdmin, MySQL Workbench) Open the #__assets table where #_ is the Database Tables Prefix value found by logging into your Joomla admin panel Browse to Site...

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

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

24 March 2014 STEP #3: Enable admin option dropdown This is a code change to allow the admin to select PlayThru. Open the file \administrator\components\com_jcomments\admin.jcomments.php (line 1066) Replace the line $captcha[] = JCommentsHTML::makeOption('kcaptcha',...

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

Hide a Drive per User in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 Note that this section applies to the currently logged-in user. To restrict other users, see the example after this one: Open the Start Menu, then type regedit in the search box and press Enter. In regedit, expand to the following key...

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

ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 STEP #3: Enable admin option dropdown This is a code change to allow the admin to select PlayThru. Open the file \administrator\components\com_jcomments\models\forms\settings.xml (line 398) Replace the line KCAPTCHA With this KCAPTCHA PLAYTHRU STEP #4:...

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

Basic Android App using Google Maps and Current Locationhttps://www.joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 a tablet running Android and wanted to include a Google Map. The following exercise focuses solely on creating an app which opens Google Maps at your current location. How? I couldn't find any instructions using the tools I had (Android Studio) which is...

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

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 header('Access-Control-Max-Age: 3628800'); header('Access-Control-Allow-Methods: GET, POST, PUT, DELETE'); // open connection $ch = curl_init(); // set the cURL options curl_setopt($ch, CURLOPT_URL, $api_url); // where to send the variables to...

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

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

07 September 2015 Parameter: Added Service: freewebsitethumbnails - Modify Parameter: Added Service: thumbshots - Modify Parameter: Added Opens In: Rokbox (only works if installed) - Modify Parameter: Category: List Only weblink categories - Removed Parameter: Cache...

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