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

08 October 2012 PREPARE search_string FROM @search_string; EXECUTE search_string; SET COUNTER = @CNT_VALUE; #SELECT COUNTER; IF COUNTER>0 THEN # Inserting required results from search to table INSERT INTO temp_details VALUES(db,tbl,clmn); END IF; IF done=1 THEN LEAVE...

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

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

09 November 2012 another calendar alongside and now copy events over by dragging and dropping (TIP: I right-click and hold and drag and this then gives you other options as well as the "copy"). Where's the automation? All-Day Events We use this for leave and this is...

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

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

20 November 2012 the problem, I'd visit some pages and they'd be fine, but when visiting a long page, it would initially display properly but then the white background would disappear when the page finally loaded. How? The root cause was because the template I was using...

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

DataScramble - Randomizing data rowshttp://www.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 IF THIS FIELD CONTAINS A DATE VALUE SET @DateMatch = CASE WHEN CAST(CAST(@OrigVal AS date) AS VARCHAR(10))'1900-01-01' THEN 1 ELSE 0 END; -- DETERMINE IF THIS FIELD CONTAINS A TIME VALUE SET @TimeMatch = CASE WHEN CAST(CAST(@OrigVal AS time) AS...

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

Access MySQL databases using Oracle SQL Developerhttp://www.joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 tools to manage mySQL databases over the years, all freeware until someone expresses an interest in using it and then the supplier will implement restrictions and trial based versions. Oracle SQL Developer is currently free at time of print...

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

Export/Import Database using MySQL Workbenchhttp://www.joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? If you're confined to use this product then this is how to do it. Personally, even a...

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

Restore MSSQL Error: Database is in usehttp://www.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 You need to set the database to single-user mode. In SSMS, connect to an instance of the SQL Server Database Engine, and then expand that instance. Right-click the database to change, and then click Properties. In the Database Properties dialog box,...

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

SSIS Skip Rows in Excel Source filehttp://www.joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then the options in the connection manager will let you skip rows and specify column datatypes. You don't get that with Excel but...

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

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

07 May 2013 of the query $query->from('#__content AS a'); // Add "Relevance" column // + 1000 pts if in title x1 (eg. if word is twice then 2000pts) // + 60 pts if in introtext // + 40 pts if in fulltext $sql_keyword = strtolower(trim($db->Quote($db->escape($text,...

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

Regular Expression Basic Usage Exampleshttp://www.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 as specifying an expression that is optional in the source text. For example, to find--'a', optionally followed by 'b', then followed by 'c'--you use the following regular expression: ab?c This expression matches: abc ac The expression does not match:...

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

SITS: Export field code and namehttp://www.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 tab and click on the chevrons ("»") next to the field to apply this to Enter the dictionary code, the entity code and then the inner SRL text which should be |, if you try to apply you should be prompted to convert to use gold characters: Test the XET...

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

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

21 August 2014 the menu system and you should be presented with a cleared/new record Complete the form noting the name of your XET Code and then selecting the appropriate dictionary and entity; here we are using SRS as the dictionary and CAP as the entity. (If your...

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

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

17 September 2014 at the car. I treat it like a First-Person-Shooter game where I strafe right moving forwards in an arc to go round corners. Then I learnt there were so many different angles and routes I could have taken (NTS: Take picture of whole track beforehand and...

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

Android: Keytool and Google Maps displaying greyhttp://www.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 * In the above, if you have specified the correct bin folder in your PATH environment variable, then you can use the keytool from any folder, skipping the initial steps of navigating to the JDK folder. Changing a keystore password keytool -storepasswd...

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

Windows Live Mail Error ID: 0x8DE00005http://www.joellipman.com/articles/microsoft/windows-os/windows-live-mail-error-id-0x8de00005.html

14 December 2016 Windows Live Mail. Well how to deactivate an account and set up a new one in Windows Live Mail. If you used IMAP all along then the new account will have all your mail. The error Unable to send or receive messages for the Hotmail (someone) account....

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

Pure JS - Display Time Elapsed & Remaininghttp://www.joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

30 October 2018 was the last token created. How? So almost pure JS. I'm working out the seconds remaining and seconds elapsed in PHP first then passing these as two variables to the below code but you could get your values from anywhere: On page load, the seconds...

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

Zoho Deluge: Get Image Uploaded in Creator Formhttp://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-image-uploaded-in-creator-form.html

14 July 2020 cover this but it takes me so long to find the solution with the right syntax. How? So I'm going to start with 1 method and then update this article with other methods. Method #1: Display and access without login So the quickest is to have a form that...

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

Windows 10: Shortcut Apps to Settingshttp://www.joellipman.com/articles/microsoft/windows-os/windows-10-shortcut-apps-to-settings.html

30 July 2020 that page or save myself a click... How? To test any of the following, type the windows key and select "Run..." ( + R). Then type the value in the 2nd column "App to Run" then OK to run it: Settings Page App to Run Settings Homepage ms-settings:...

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

Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)http://www.joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

02 February 2021 I have a client with ZohoCRM who upload a PDF (can be any file but is usually a PDF) to a custom module in their CRM; I then need the customer from the customer portal in a ZohoCreator app to be able to download this file. How? The trick to doing this...

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

Windows OS: Alt Codes / Symbols / Special Charactershttp://www.joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

03 June 2021 the ALT key (preferably the one on the left of the spacebar and not the Alt Gr often found on the right of the spacebar) then press the numbers in the numeric pad (while still holding down the ALT key), then let go of the ALT key. Remember: This will...

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