Android: Replace return key with done, go, send...https://joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 soft keyboard (software based) on a touch-device. Why? I have an editText where a user can enter any text value but if they typed a return character, the app would crash because it didn't understand the data. I tried replacing the new lines but just...

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

404: Page Not Foundhttps://joellipman.com/static-items/404.html

11 February 2015 but the content you requested could not be found. It is possible that you have followed an out-of-date link or incorrectly typed an address. We have revamped this website as of September 2015 and tidied up some of our URLs. Some sections will have been...

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

Setting up your store to use SSLhttps://joellipman.com/articles/ecommerce/setting-up-your-store-to-use-ssl.html

11 September 2009 using your browser. http://www.example.com/store You should now be presented with your store. If not, you have either typed the wrong URL or it has not been installed properly. To test if your dedicated SSL certificate is working change the protocol in...

• Type: Article
• Author: Joel Lipman
• Category: eCommerce Systems
• Language: *

Anti-Spam override for all submitted datahttps://joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

03 February 2010 but if you did the sound version, it didn't work properly. I found that sometimes the captcha wouldn't even match what you typed and what it displayed!!! I have written this article to be another one of those programmer's tweaks. This is quite a simple...

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

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

11 October 2012 not yet available". These are obviously the same values, so I should go through the database and change 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...

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

T-SQL: Parse an XML valuehttps://joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 node exists or not respectively SELECT Event_XML.exist('/STAFF/EMPLOYEE_NUMBER') FROM [dbo].[XML_EVENTS] -- query() returns typed XML SELECT Event_XML.query('/STAFF/EMPLOYEE_NUMBER') FROM [dbo].[XML_EVENTS] -- value() returns single value, specify data...

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

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

13 June 2016 is different to "rivière". We need to ensure that a search for any of these kind of words will return results of similarly typed/sounding words. How? Here's just a splurge of SQL but I use this often enough: UPDATE `myTable` t SET...

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

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

03 June 2021 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 0163. In HTML, the numeric entity that will display a British Pound sign is £

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

Add default to a picture buttonhttps://joellipman.com/articles/automation/autohotkey/add-default-to-a-picture-button.html

10 November 2009 then anything else. My solution is to set up the default button and the image to respond to the ENTER key after you typed something (this is for a search feature) in addition to having a button if the user would rather click then press the ENTER key....

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