Advanced Search

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 below is required, the following 169 results were found.

  1. Windows Live Mail Error ID: 0x8DE00005https://joellipman.com/component/content/article/windows-live-mail-error-id-0x8de00005.html?catid=80&Itemid=165

    sign. Add your account and tick 'Manually configure server settings'. Configure server settings complete as per the image below (changing the log-on username to your own): The downloading of all your folders will take a while so don't panic if you find...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  2. Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    my environment, to put them in one place on a website I've bookmarked (my personal site :c) My own with Typos Note that the below only prints out the SQL query to copy and paste into your SQL administration software. You can put a distinct on it (not...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  3. Search a database with SOUNDEXhttps://joellipman.com/articles/else/database/search-a-database-with-soundex.html

    Server 2008 R2 by 4000 characters in a variable (so I couldn't store it in a local variable). So the idea here is to run the below example which outputs a huge SQL query which you then copy & paste and run against your database. Step 1 of 2 The...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  4. Search a database for a value and count matching rowshttps://joellipman.com/articles/else/database/search-a-database-for-a-value-and-count-matching-rows.html

    where the column is called "WarehouseLoadKey" and the value we want to search on is "3" (the 3rd incremental load). How? The below stored procedure can be reduced to just a script as long as you declare and set the parameters after the BEGIN and extract...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  5. T-SQL Record Separatorhttps://joellipman.com/articles/else/database/t-sql/t-sql-record-separator.html

    Monday Monday Tuesday Tuesday Wednesday Thursday Thursday Thursday Thursday Friday Friday The Official Gist Okay so the below article with the 3 stages can be a little confusing. When I wrote the support documentation which makes use of this little...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  6. Database Error: Unable to connect to the database: Could not connect to MySQLhttps://joellipman.com/articles/else/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    through forums to investigate this error. After you've checked your database connection details, I find what FisherC said below is the most probable cause for the error. FisherC says: I have the same problem, but I'm not sure for the same reasons. I...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  7. MySQL: Find records in one table that are not in another.https://joellipman.com/articles/else/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

    ---------------- ------------------ --------------------- 17 1144 2010-06-18 12:25:22 The How And here is the dilemma. The 3 below SELECT statements were derived from a post to the Stack Overflow website about the best way to check for rows in one table...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  8. MySQL last year week month day trend periodshttps://joellipman.com/articles/else/database/mysql/mysql-last-year-week-month-day-trend.html

    members to signup. It goes a little further and counts activated accounts for the past day, week, 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  9. Difference between two dates - the midnight hourhttps://joellipman.com/articles/cms/website-development/difference-between-two-dates-the-midnight-hour.html

    between two times on the same date, when one of the hours is on the other side of the midnight hour... Now bear in mind the below is in European date format Consider the following: Date Customer Time From Time To Hours ---------- ---------------...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  10. 301 Redirect using htaccess filehttps://joellipman.com/articles/cms/website-development/301-redirect-using-htaccess-file.html

    to the root folder of the old domain's website Rename it as ".htaccess" (or modify the existing one) Add the code as per below. Save the change. Different ways for different results, let's pretend I'm redirecting from myolddomain.com to mynewdomain.com:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  11. List of Font Awesomehttps://joellipman.com/articles/cms/website-development/list-of-font-awesome.html

    have only copied over some of the entire directory (the icons I want to use). Note, change the width of your browser if the below list is not displaying nicely. 4.4  fa-500px []  fa-adjust []  fa-adn []  fa-align-center...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  12. FTP on Mac: Failed to retrieve directory listinghttps://joellipman.com/articles/cms/website-development/ftp/ftp-on-mac-failed-to-retrieve-directory-listing.html

    remote directory field. Still no files or folders would show. There's a good bit of information from the source link listed below but the settings didn't solve the problem. The solution was to change the options on the mac firewall by going into...

    • Type: Article
    • Author: Joel Lipman
    • Category: File Transfer Protocol
    • Language: *
  13. Inline Labels in Form Fields using Javascripthttps://joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

    default when it is clicked on so that it auto-clears and changes to how it normally works. Example? Note the value in the below field. Now click on it and it disappears, allowing you to type normally. Clear whatever you type so the field is empty and...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
  14. Pure JS - Display Time Elapsed & Remaininghttps://joellipman.com/articles/cms/website-development/js/pure-js-display-time-elapsed-remaining.html

    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 remaining and elapsed are specified JS then...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *
  15. Preg_Replace all strings between two tagshttps://joellipman.com/articles/cms/website-development/php/preg-replace-all-strings-between-two-tags.html

    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 (apostrophes) with red styling Convert: this='a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  16. Accessing Apimo WebService APIhttps://joellipman.com/component/content/article/accessing-apimo-webservice-api.html?catid=109&Itemid=165

    somewhat vague. I thought I'd quickly write this article so I don't have to spend so much time on it again. Note that the below examples, demonstrate a script on a Non-SSL-Enabled host. How? Previously, I would have used cURL but for some reason, I...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  17. Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://joellipman.com/component/content/article/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html?catid=110&Itemid=165

    there are no extra options or dialogs to select. The export had to work from this point on. I can't take any credit for the below as it was copied from http://hosteddocs.ittoolbox.com/ST030504.pdf. A "Crystal Decisions" documentation. Blank columns...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: *
  18. GoDaddy Apache cPanel: Install SSL Certificatehttps://joellipman.com/component/content/article/godaddy-apache-cpanel-install-ssl-certificate.html?catid=111&Itemid=165

    it's expiry in a couple years time. The first time I did it, there were more steps; the second time I just did as per the below. If I ever have to do the long process again, I'll add it to this article. How? I know there are instructions on the GoDaddy...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *
  19. Zoho Books: Attach a document to a bill using Deluge / REST APIhttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-books-attach-a-document-to-a-bill-using-deluge-rest-api.html

    Order into a Bill and then attach the received invoice to the Bill). How? The key part that I was missing was step 2 in the below. Otherwise I would always get the error {"code":2,"message":"The request passed is not valid."} Note this is on the EU...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  20. Zoho Deluge - Hide Reset Button on Formhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-hide-reset-button-on-form.html

    I have a confirmation page and don't want the button to show so... How? Well edit the HTML... Now to do this, follow the below steps: Find the CSS class name of the reset button (usually "zc-live-secondary-btn") Add a notes field to your form Click on...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
Results 141 - 160 of 169