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

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

    variations of our default values. End-users were complaining that some default values get listed twice because their system was case-sensitive despite the collation of the SQL Server being case-insensitive. What? End-users said that they could see the...

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

  2. T-SQL Record Separatorhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-record-separator.html

    I can't use normal dates because the database wasn't designed with timestamps (despite being a timetabling and room booking system). But I do get given a weekday and the start date of the week... WITH tblDifference AS ( SELECT t1.*, ROW_NUMBER() OVER...

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

  3. Drop If Object Existshttps://www.joellipman.com/articles/else/database/t-sql/drop-if-object-exists.html

    PG = Plan guide PK = PRIMARY KEY constraint R = Rule (old-style, stand-alone) RF = Replication-filter-procedure S = System base table SN = Synonym SQ = Service queue TA = Assembly (CLR) DML trigger TF = SQL table-valued-function TR = SQL DML trigger TT...

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

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

    these default values sometimes list twice, especially when the case is different, eg. "Data not yet available". The final system (qlikview) was case-sensitive despite our server collation being case-insensitive. Furthermore, we now have the task of...

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

  5. T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    converting the varchar value 'B110' to data type int. I'm not using any of the non-numeric values to map to... Well the system thinks I might so it fails. I realised then the equals sign ("=") could be changed to a "LIKE" which will mean both values are...

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

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

    posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings in a database and rather than a separate file, it stores these in a row. How? Assuming the...

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

  7. SQL Queries for Statisticshttps://www.joellipman.com/articles/else/database/mysql/sql-queries-for-statistics.html

    in our new Business Intelligence projects that I've been revising all my scripts to see what SQL I can optimize. One of my systems is a MediaWiki CMS which is used for the official Bournemouth University Knowledge Base. The skin itself is the index page...

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

  8. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    you may want to drill-down). Setup ODBC: Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC) > System DSN (get technical help if you don't know how to do this)... Open Excel 2007 > New > "Blank" Connect to data source: > Data...

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

  9. MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/else/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

    if you want to list users who have no associated activities (outer join but all-in-one query). The DBA responsible for the system asked me to look at ways of reducing the load on the server and the solution was to separate both tables (activities and...

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

  10. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.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

    backup. I have to raise and log a formal change request and follow a workflow process in order to make a change on a live system to a service user account... Especially one used by the scripts to access the database-driven website. How? I'm first going...

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

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

    when I want to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the names of places in other countries. This is...

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

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

    is great for everything during that date as long as the "To Date" never goes past midnight into the next day... But what system doesn't do this (no Microsoft jokes please)? The Solution Eureka! Or duh! for those that it's obvious to... Compare the two...

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

  13. What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/cms/website-development/whats-the-problem-amusing-computer-reports.html

    thing as restart and reminded on both IT and environmental policies. Tech Notes: For PCs: Run a command prompt and type systeminfo: Look for "System Up Time". A staff member in a partner institution: "By the way my printer has stopped working, in fact...

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

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

    This is if you have an FLV file and you don't want any fancy management system, you just want your FLV to play on your webpage. The following example is a demonstration of how to do this without installing anything on your webserver. I like to use...

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

  15. Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/cms/website-development/php/using-a-html-form-and-php-to-upload-a-file.html

    in your HTML form. If the above yields NO empty data (and size is not 0) then it was successful. If not, then either your system isn't accepting the file type you are trying to upload, or the file is too big, or this feature just isn't available to you....

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

  16. SITS: Export field code and namehttps://www.joellipman.com/articles/cms/website-development/xml/sits-export-field-code-and-name.html

    have no way of telling whether the lookup failed or if this student does not have this field populated. What if we want the system to say if the field was populated but that the lookup failed? -- If CODE=0000 and 0000 does not exist in table to lookup...

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

  17. TravelPort Universal API - Ping Request with PHP-cURLhttps://www.joellipman.com/component/content/article/travelport-universal-api-ping-request-with-php-curl.html?catid=109&Itemid=165

    a standard ping request. Before you say it doesn't work, it has to be updated every time a new schema is introduced to the system. See my errors section for how you can resolve this.

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *

  18. Crystal Reports: Exporting to Excel omits column headershttps://www.joellipman.com/component/content/article/crystal-reports-exporting-to-excel-omits-column-headers.html?catid=110&Itemid=165

    page headers" on the Excel Format Options when you export the report. Because our report is exported via a web-based system, this extra dialog doesn't appear when our users export their reports. Not that it solved it as only some different headers...

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

  19. DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://www.joellipman.com/component/content/article/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html?catid=113&Itemid=165

    propeller is stock Less on a budget, let's replace the FC40 gimbal...with an AerialFreaks Cyclops 2-Axis Brushless Gimbal System designed for the DJI FC40 camera Gimbal frame first, 3 screws to fasten it to the carbon fiber plate Electronics mount...

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

  20. CSV Chart Generatorhttps://www.joellipman.com/component/content/article/csv-chart-generator.html?catid=53&Itemid=165

    from the data. What my program does is convert all the data into a settings and data file that can be used by the charting system AMCharts.com. AMCharts.com provide a flash-based interactive chart which you can zoom in and out of, includes almost every...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
Results 141 - 160 of 170