Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/component/content/article/windows-os-alt-codes-symbols-special-characters.html?catid=80&Itemid=165

03 June 2021 Question 0191 ª Feminine Ordinal 0170 º Masculine Ordinal 0186 « Left angle quote 0171 » Right angle quote 0187 Additional "Alt Codes" can also be used in HTML. For example the British Pound sign (£) can be typed by holding the ALT key and entering...

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

T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 Success! Now we can run this on a column in a table to determine if there are discrepancies in our default values. Additional Note how this also picked up typos in the 4th value which is good as I didn't want to overcomplicate things using LEVENSHTEIN...

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

Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 SampleText SampleText lowercase.text lowercase.text Examples of usage: SELECT ufn_ProperCase([Surname]) FROM employees Additional: Note how the above doesn't convert postal codes, specifically British postcodes, which isn't included in the examples...

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

Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 Or create NEW if it doesn't exist. Give it the value C:\ORACLE\product\11.2.0\client_1 OK all dialogs to close and save. Additional The affecting TNSNAMES.ORA file for the above setup is located in "C:\app\\product\11.2.0\client_1\Network\Admin". I also...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

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

05 January 2011 anyone to go through the same rubbish. I just took a step back and thought this through and this is what I came up with! Additional The above will all work if you're working on a local report within BIDS connecting to remote servers. If you want the...

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

Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/else/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 a clue. Anyway, enough faffing! Here's a script I used to generate the SELECT query. If you run it, it should return the additional 52 rows we want add. Note that the table "WeekStructure" could have been any table with more than 52 rows, I'd say...

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

Error 1065: Query was Emptyhttps://www.joellipman.com/articles/else/database/mysql/error-1065-query-was-empty.html

13 December 2012 \t A tab character. \Z ASCII 26 (Control+Z). \\ A backslash (“\”) character. \% A “%” character. \_ A “_” character. Additional An alternative in SQL to escape apostrophes is to change these to paired apostrophes, so: INSERT INTO myTable VALUES ('1',...

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

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

01 February 2013 on the plus sign in the connections tab), select the mySQL tab and complete the login details and host location... Done! Additional I wouldn't recommend using Oracle SQL Developer. You have to use mostly SQL to create tables and stuff. Recommend to your...

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

Convert foreign characters to English alphabethttps://www.joellipman.com/articles/else/database/mysql/convert-foreign-characters-to-english-alphabet.html

13 June 2016 Retrieve records with foreign characters: SELECT * FROM `myTable` WHERE `myColumn` REGEXP '[^A-Za-z0-9 -()\-.]' Joomla! Additional My Joomla website needed the following code to display the above foreign characters as entered into the Joomla...

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

MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/else/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

12 March 2020 ','content','component','applies','because','doesn''t') GROUP BY `value` ORDER BY `total` DESC LIMIT 0,50; Additional Note(s): I have added a WHERE clause which omits words less than 5 characters in length, and some other words not to count. I have...

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

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

20 November 2012 STABLE AND CONSISTENT !!! */ background-color: #f7f7f7; background-clip: padding-box; border-radius: 0 0 5px 5px; Example Additional The above issue happened when using Google Chrome v23 or MS Internet Explorer v8 (so Webkit and MSIE appear to be...

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

Embed an FLV file into a web pagehttps://www.joellipman.com/articles/cms/website-development/html/embed-an-flv-file-into-a-web-page.html

09 March 2010 of the text "http://my.video.com/myVideo.flv" with the full url of your own FLV. Save the HTML page and publish The Code: Additional: Stop AutoPlay Thank you to Anna Moors for writing in and asking "how to stop the movie from playing automatically on...

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

Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 the value back to "Name:" and the color back to grey. If it isn't, then leave as is and ensure the color is still black. Additional Note that instead of just saying if this value equals "Name:" I've added some code to trim the values. If the user types...

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

htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/cms/website-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 401 /error/?v=401 ErrorDocument 403 /error/?v=403 ErrorDocument 404 /error/?v=404 ErrorDocument 500 /error/?v=500 Additional Notes If you do apply the above to your site, bear in mind the following is also true:...

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

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

06 May 2019 ; 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 a record. If your script is trying to modify/update a record with a value...

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

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

21 August 2014 will output something like A|Applicant) Click on "Apply" Include any additional entities as sub-entities under the parent one (not used in this demo) and repeat the steps above to select the exchange fields. Check/ensure the "In Use?" is ticked....

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

Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=105&Itemid=165

07 September 2015 Admin Option: Specify border color for link. - Now checks if mb_strtolower function exists (regresses to strtolower). - Additional parameters (eg. Word Background) do not load if not enabled. - Added Joomla! Admin Option: Module width. - Corrected...

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

Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

30 September 2011 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 anyone with access to the Excel...

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

MS Excel - Sort pivottable column headings by datehttps://www.joellipman.com/component/content/article/sort-pivottable-column-headings-by-date.html?catid=110&Itemid=165

12 April 2013 and perhaps Excel will be forced to treat it as a string: Another alternative to round brackets, square brackets! Additional: I have made this work with the parentheses but only after refreshing ALL DATA in the spreadsheet and reconfiguring which fields...

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

Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/component/content/article/import-excel-csv-file-as-javascript-array.html?catid=110&Itemid=165

05 October 2015 // eg. var my_array = populate_array_from_csv('./mydata/data.csv'); // ---- End-ofFile Additional Information(s): StackOverflow: Split string by comma, but ignore commas inside quotes WhatWG.org - XMLHttpRequest Standard

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