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

08 October 2012 INTO temp_details VALUES(db,tbl,clmn); END IF; IF done=1 THEN LEAVE table_loop; END IF; END LOOP; CLOSE table_cur; #Finally Show Results SELECT concat("SELECT * FROM ",t_table, " WHERE ", t_field, " REGEXP '", in_search, "';") FROM temp_details; END $$...

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

Sync Outlook 2007 Shared Calendar with SharePoint 2007https://joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 2007 would be completely shared with everyone who had access to the SharePoint site... It doesn't. The following steps show you how SharePoint will open a shared calendar if you don't already have it in your Outlook 2007. Similar to you opening a shared...

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

Background Gradient Disappears on Long Pageshttps://joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 is blue. Background color of my contents is white. When I visit a small page on the site, the contents background (white) shows. When I visit a very long page on the site, the contents background disappears and reveals the overall background (blue)...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

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

03 April 2009 the same freedoms that you received. You must make sure that they, too, receive or can get the source code. And you must show them these terms so they know their rights. Developers that use the GNU GPL protect your rights with two steps: (1) assert...

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

Delete related records from multiple tableshttps://joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

11 January 2013 148800 148800 148686 148686 (null) -> The select here returns 5 rows -> A delete here would affect 13 rows. This should show all records to be deleted.

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 the GAC, right-click on the File System on Target Machine -> Add Special Folder -> Global Assembly Cache folder. It will now show up as an additional folder, and you can add project output to it. Exclude all dependencies by highlighting all of the files...

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

MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 copy, timestamp or delete any files. /X :: report all eXtra files, not just those selected. /V :: produce Verbose output, showing skipped files. /TS :: include source file Time Stamps in the output. /FP :: include Full Pathname of files in the output....

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

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

28 March 2014 in this case Users > Guest Enter NTUSER.DAT in the File name box. (This file is a system-hidden file, so it won't show up in the file selection window. You have to type it in. Be sure not to select ntuser.dat.log by accident.) Click ok, then enter a...

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

301 Redirect using htaccess filehttps://joellipman.com/articles/web-development/301-redirect-using-htaccess-file.html

03 April 2014 true to form Google have removed it. Not sure why nobody believed me when I raised the alarm but hey-ho. How? I'm going to show you how to do this with a .htaccess file: Upload a text file to the root folder of the old domain's website Rename it as...

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

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

10 October 2014 // Create a LatLng object for the current location LatLng latLng = new LatLng(latitude, longitude); // Show the current location in Google Map mMap.moveCamera(CameraUpdateFactory.newLatLng(latLng)); // Zoom in the Google Map...

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

MessageBox or AlertDialog in Android Javahttps://joellipman.com/articles/google/androidos/messagebox-or-alertdialog-in-android-java.html

20 October 2014 { public void onClick(DialogInterface arg0, int arg1) { // Some stuff to do when cancel got clicked } }) .show(); Additional: Pre-populating default value and returning input Lots of confusing answers out there on the web but here's an all-in-one where...

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

Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 app in a nutshell displays flight restrictions in a given area Description As a quadcopter flier myself, I wanted an app to show me a map of the area I was going to film or fly. I wanted it to display the flight restrictions of the area and any other...

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

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

07 September 2015 / commenting - Release: for BETA testers. - Date Uploaded: Sun, 11th Sep 2011 2.0.6 beta- Enhancement: Combined Grid and Showcase for pagination and auto-scroll - Date Uploaded: Sat, 3rd Sep 2011 2.0.5 beta- Parameters: Grid Mode - sortable, column...

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

Joes Youtube Plugin (JYP) Downloadshttps://joellipman.com/component/content/article/joes-youtube-plugin-jyp-downloads.html?catid=92

07 September 2015 Border Color - Added Joomla Admin Panel option: Border Style - Fixed parameters to display as saved (Was saving but not showing). - Date Uploaded: Thu, 17th Feb 2011 1.0.2- Added Joomla Admin Panel option: Border Width - Added Joomla Admin Panel option:...

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

Accessing Apimo WebService APIhttps://joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 these during testing - malformed XML but more info) curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1 ); // curl_exec function will show the response directly on the page (if set to 0 curl_exec function will return the result) curl_setopt($ch, CURLOPT_PORT,...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

AutoHotkey: Check Windows Folder Sizeshttps://joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 Browse... Gui, Add, TreeView, x2 y25 w496 h310 vMyFolderTree ImageList%ImageListID% Gui, Add, StatusBar, v_StatusBar Gui, Show, w%Width% h%Height% xCenter yCenter SB_SetText("Ready.") Return ;...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 put the email of the user the service account will be impersonating. Browse to https://admin.google.com Go to Security > Show More > Advanced Settings > Manage API Client Access Enter the Client ID in the field Client Name (eg. 1000389324798977991)...

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

URL Alias uniqueness with PHP & MySQLhttps://joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 url_counter); set url_counter = url_counter + 1; end while; END; | DELIMITER ; Note that running this in PhpMyAdmin might show as an error, possibly due to the delimiters, but you can run it anyway. Additional Note(s): The trigger only runs if inserting...

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

Autohotkey - Chrome Profiles in Alphabetical Orderhttps://joellipman.com/articles/automation/autohotkey/autohotkey-chrome-profiles-in-alphabetical-order.html

07 January 2020 LV_ModifyCol(2, "Sort") ; sort the second column (profile names) Gui, Font, s8, Verdana Gui, Add, StatusBar,, Ready. Gui, Show, w%Width% h%Height% x10 y10 Return ; -------------------------------------------------------------------------------------- ;...

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

AutoHotkey: App GUI Listview to Rename Fileshttps://joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 Gui, Add, ListView, w600 h528 +Hdr +Grid x0 y50, Old Name|New Name Gui, Font, s7, Verdana Gui, Add, StatusBar,, Ready. Gui, Show, w%Width% h%Height% x10 y10 Return ; --------------------------------------------------------------------------------------...

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