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

  1. Remove write-protect from USB pen in Windowshttps://joellipman.com/component/content/article/remove-write-protect-from-pen-in-windows.html?catid=80&Itemid=165

    Kingston DataTraveler@?) and an even cheaper one on Ebay.com (Leather 64Gb@£29.99). In hindsight, the Ebay one was obviously going to fail (faking the disk size). I got badgered by my colleagues to splash out and get a worthwhile pen. Aside from some...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  2. Administrator Program Shortcut without Prompthttps://joellipman.com/component/content/article/administrator-program-shortcut-without-prompt.html?catid=80&Itemid=165

    same account as we're currently logged-in with???) instead of being able to just click on "Yes". How? The gist is that we're going to create a scheduled task (that won't be scheduled) and a shortcut to that task: Open the Task Scheduler (Start > Run......

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  3. Windows Live Mail Error ID: 0x8DE00005https://joellipman.com/component/content/article/windows-live-mail-error-id-0x8de00005.html?catid=80&Itemid=165

    How? I don't remember the time when the Microsoft website became helpful but as they already have an article on this, I'm going to do a bunch of screenshots: The error is that I can't receive/send messages on this account. The problem has something to...

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

    case-sensitive, I need to add "COLLATE Latin1_General_CS_AS" after the column this affects. More collations can be found by going to MSDN's SQL Server Collation Name page. Limitations Trailing spaces or prefixing spaces are not obvious in the results,...

    • 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

    the last row of each day -- if grouping by day -- basically insert a row that when ordered will fit where the separator is going to go) UNION ALL SELECT TOP 1 'Monday' AS Day, '10/10/2011' AS Date, NULL, '23:59', NULL, NULL FROM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  6. T-SQL concatenate an incremental row numberhttps://joellipman.com/articles/else/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

    001 00101 001 00101 Almost useful... but the qualification reference has to be unique. We're going to add the ROW_NUMBER() to the employee number to create a unique identifier. Try this: SELECT q.Employee AS EmployeeNo, RIGHT('000' + CAST(q.Employee AS...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  7. T-SQL: Parse an XML valuehttps://joellipman.com/articles/else/database/t-sql/t-sql-parse-an-xml-value.html

    JOEL LIPMAN MALE 1990-01-01 SUPER SUPPORT TEAM GENERAL DOGSBODY 2014-03-01 Y INSERT 2014-03-27 Extracting the Gender: We're going to extract the value in between the opening and closing XML tags: -- Using .query() SELECT CAST(CAST(Event_XML AS...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  8. Basic Oracle Stored Procedure Structurehttps://joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-stored-procedure-structure.html

    procedure and how to use cursors. I'm told I need to use this for SQL Server Reporting Services (SSRS) which is why I'm going down this route. For an even simpler stored procedure, I'd imagine you just get rid of the cursor. Why A standalone query is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  9. 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

    I've been looking into this for a friend and going 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  10. 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

    the queries because some scripts are noticeably slow (as observed by the customer...) and then others not. The What I'm going to run these benchmark tests against a system that is both up and running via the front-end and back-end. It's MediaWiki CMS...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  11. MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    GROUP BY s.LogID ORDER BY s.TeamID, u.Username, s.DateTimeCreated, Resource Note there is no WHERE clause because we're going to use EXCEL filters as the parameters. Bit of a cop-out but this was just a workaround and never a solution. Add in the ID of...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  12. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://joellipman.com/articles/else/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

    system to a service user account... Especially one used by the scripts to access the database-driven website. How? I'm first going to highlight 2 methods which I found on the web and can be applied if you work somewhere that doesn't care about testing,...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  13. Webdeveloper-Speakhttps://joellipman.com/articles/cms/website-development/webdeveloper-speak.html

    information technology developed or purchased by the US Federal Government is accessible by people with disabilities. I'm going to stop there but do check them out at http://www.motive.co.nz/index.php

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

    and true to form Google have removed it. Not sure why nobody believed me when I raised the alarm but hey-ho. How? I'm going to show you how to do this with a .htaccess file: Upload a text file to the root folder of the old domain's website Rename it as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  15. CSS Center an iFrame Horizontally and Verticallyhttps://joellipman.com/articles/cms/website-development/css/css-center-an-iframe-horizontally-and-vertically.html

    of the iframe but if the iframe has a height of 2000 pixels, the iframe gets aligned to the top of the parent... How? We're going to use a touch of CSS and instead of determining heights and alignment with JS. The following code will work with DIV...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  16. FTP on Mac: Failed to retrieve directory listinghttps://joellipman.com/articles/cms/website-development/ftp/ftp-on-mac-failed-to-retrieve-directory-listing.html

    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 Settings > Security & Privacy > Firewall Click the lock to make changes Firewall Options Untick "Block all incoming...

    • Type: Article
    • Author: Joel Lipman
    • Category: File Transfer Protocol
    • Language: *
  17. This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://joellipman.com/articles/cms/website-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

    not allow. By making some minor changes to the MediaWiki LocalSettings.php file, we can fix this. For demo purposes, I'm going to make our system recognize SWF files (by default these are disallowed): Firstly: Add the following line to somewhere in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  18. Inline Labels in Form Fields using Javascripthttps://joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

    have used since my fad of JavaScript 1.2 in the 90s. For broader compatibility, this is my recommended solution. How? We're going to use the onBlur and onFocus attributes which do, as the name indicates, trigger events when the cursor is either in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
  19. Slideshow div layer through a windowhttps://joellipman.com/articles/cms/website-development/mootools/slideshow-div-layer-through-a-window.html

    boundary of the parent div layer. Why? I'm making a slideshow from scratch. How? The idea is: Use two main div layers, I'm going to refer to them as "window_slide" and "inner_window". Slide divs to be added inside the "inner_window". Move the slides in...

    • Type: Article
    • Author: Joel Lipman
    • Category: MooTools Framework
    • Language: *
  20. PHP & MySQL Search Enginehttps://joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    $b){ $ax = $a["Score"]; $bx = $b["Score"]; if ($ax == $bx){ return 0; } return ($ax > $bx) ? -1 : 1; } # get the words we're going to display function search_return_keywords($str) { $search = array ( '@ @si', // Strip out javascript '@ @si', // Strip...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
Results 121 - 140 of 158