Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming well is required, the following 158 results were found.

  1. 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

    and can apply a function lock (fn) and the numbers on the right of your keyboard are enabled. Which numbers you might ask? Well every character is built of a collection of digits that are to be entered in their specific order. Search for "Alt Codes" or...

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

  2. Apple Magic Trackpad with Windows 11 Intelhttps://www.joellipman.com/component/content/article/apple-magic-trackpad-with-windows-11-intel.html?catid=80&Itemid=165

    but reverted for the biscuit box). Running MS Windows 11 pro already. Wifi was ok to connect and my Microsoft Office apps, well it's a Windows box so no issues there either... Webcam and headset previously connected to my docking station weren't too...

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

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

    SQL scripts that can simply be used to search an entire database for a particular string of word(s). I've posted my own as well as some others I've lifted from elsewhere, as they worked with my environment, to put them in one place on a website I've...

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

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

    in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO -- Run as database owner to see ALL connected processes as well. Why? For every DBA this is a doddle and doesn't warrant its own article but for those of us who merely use SQL Server...

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

  5. Error during processing - Converting Date/Timehttps://www.joellipman.com/articles/else/database/t-sql/error-during-processing-converting-datetime.html

    Well I find myself again the dummie of the Internet. I basically came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done...

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

  6. Compare two databases using T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/compare-two-databases-using-t-sql.html

    a Microsoft product which cannot possibly be cheap. MS SQL Server Management Studio (SSMS) comes included so use it... How? Well I started with the method #1 listed here and then just built on this. Method #1 I got this first query from the awesome site...

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

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

    feed so it won't be converting long paragraphs of English text. Instead it will be applied to names and addresses as well as job titles and departments. Why? We wanted a T-SQL version despite having successfully built a custom script component for SSIS....

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

  8. Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/else/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    should not be able to send a 1000 queries a minute or why a developer has to refresh the page, make a change, upload, etc. well it's beyond a joke and no one should waste their time with such companies.

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

  9. MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/else/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

    880 rows 0.187s STATEMENT2 741 rows 49.933s STATEMENT3 741 rows 48.844s STATEMENT4 741 rows 49.603s And Vice-Versa? Well actually I wanted all the articles that have NOT been approved yet... So would this work if I switched MyTable1 with MyTable2? Um...

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

  10. MySQL last year week month day trend periodshttps://www.joellipman.com/articles/else/database/mysql/mysql-last-year-week-month-day-trend.html

    month and year (the below examples count all accounts irrespective of being activated or not). It needs to pick up trends as well and compare for example todays, with yesterdays up to the same hour. How? I used to use a lot more PHP but since becoming...

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

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

    cause errors because the existence of those rows is stored in another table, how do we delete from all the related tables as well? How? You need to refer to the tables just after the DELETE clause (so instead of DELETE FROM myTable WHERE...

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

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

    SQL developer is already a pre-approved software for our work computers. We have SQL Server Management Studio (SSMS) as well for our SQL Server instances but it wasn't practical to link this to mySQL databases. How? So this is how I did it, I found the...

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

  13. Country Lookup by IP address CSVhttps://www.joellipman.com/articles/else/database/mysql/country-lookup-by-ip-address.html

    The scripts in the folder you have downloaded are to create a lookup function using a MySQL database and a PHP script. As well as a CSV file equivalent. How to use: Download from my site: «Download» Run the SQL script against a test database, Modify the...

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

  14. Project Plan for Freelance Websitehttps://www.joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    Domain Registration Services (for .com, .net, .org, etc) - Note you can use the above UK ones for .com domains as well. http://www.networksolutions.com/ http://www.register.com/ http://www.godaddy.com/ http://www.cleverdot.com/ Domain Registrars for...

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

  15. Difference between two dates - the midnight hourhttps://www.joellipman.com/articles/cms/website-development/difference-between-two-dates-the-midnight-hour.html

    might already have something similar to this but this deserves its own article. Why? Well try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on the same date, when one of the hours is on the other...

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

  16. Preg_Replace all strings between two tagshttps://www.joellipman.com/articles/cms/website-development/php/preg-replace-all-strings-between-two-tags.html

    expressions is shady and varies from language to language, I've written this article as a quick reference point. How? Well you use this in your PHP scripts, the examples below are meant to help but feel free to comment if they do not: Surround string...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *

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

    then reading from it. Helpful Links XML parsing in PHP convert xml to json php curl utf16_decode PHP Manual: curl-setopt Well this is my stop. It's being several hours that for others could have taken a several minutes if you knew where to look. My aim...

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

  18. Convert Past Date to Time Ago in PHPhttps://www.joellipman.com/articles/cms/website-development/php/convert-past-date-to-time-ago-in-php.html

    ''; if($v!='') $a3[] = $v; } return implode(' and ', array_slice($a3,0,2)).' ago'; } When could I possibly want to do this? Well I've previously used this for password change reminders but on this occasion for a listing of reviews laid out as per the...

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

  19. 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

    Create the XML Exchange Template (XET) The XET will give me an idea of what the output will be for my staging process as well as seeing what fields I will be bringing through. Run XET from the menu system and you should be presented with a cleared/new...

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

  20. Add attribute xsl:nil=true on empty elements using XSLThttps://www.joellipman.com/articles/cms/website-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

    is blank or null yields // -- errors How? I could correct this using SSIS but with all the data in XML, we might as well stick with the technology and we're going to keep our XSLT with some slight modifications. First let's look at the XML output from...

    • Type: Article
    • Author: Joel Lipman
    • Category: XML Stylesheet Language Transformations
    • Language: *
Results 121 - 140 of 158