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

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

    but for those of us who merely use SQL Server Management Studio (SSMS) and Microsoft's SQL Server 2008 R2 for development purposes, the once-in-a-blue-moon restore from backup process is quickly forgotten. How? You need to set the database to...

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

  2. DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/else/database/t-sql/data-shuffling-function.html

    for support or analysis. With inspiration from: "Obfuscating your SQL Server Data" by John Magnabosco but tweaked for our purposes. NOTE that the following has only ever been run on development environments and I would not recommend running this on a...

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

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

    D300 4 Daat oNt EYt Avialable D300 This is obviously a simplified table as it doesn't tell us much but it is just for demo purposes. Consider the following query: SELECT DISTINCT StudentDetail FROM StudentTable WHERE SOUNDEX(StudentDetail)=SOUNDEX('Data...

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

  4. CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://www.joellipman.com/articles/else/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

    instance only and not filtered by other code. Why? I have a string such as the following (column positions added for demo purposes): String1.String2.String3.String4 1 5 10 15 20 25 30 -> length = 31 I'd like to end up with just the last part of this, ie...

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

  5. Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/else/database/mysql/quickly-update-all-content-replacing-a-string.html

    I used to have a third-party plugin that would replace my HTML tags with . Not I want to switch these back. How? For demo purposes, I'm searching a column called introtext in a database table called MYTABLE_content. First let me find all the articles...

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

  6. Creating a Top 10 chart with less codehttps://www.joellipman.com/articles/cms/website-development/php/creating-a-top-10-chart-with-less-code.html

    times the column1.table1 value appears in table1 Format this count result by prefixing with leading zeros (for sorting purposes - eg. so 10 is not before 2) Store both the formatted count and the value of column1.table in the next array entry Reverse...

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

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

    I thought I'd note this down to remind me if I ever work for a company using SITS:Vision again. How? For demonstration purposes, I'm going to create a table update process (TUP) based around a change in the course application details. Some of the...

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

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

    with some slight modifications. First let's look at the XML output from SITS (this is a cut down version for demonstration purposes): 1234567 JOEL LIPMAN Two things to do really: Add the xmlns:xsi namespace in the xsl:stylesheet tag so that...

    • Type: Article
    • Author: Joel Lipman
    • Category: XML Stylesheet Language Transformations
    • Language: *

  9. Accessing Apimo WebService APIhttps://www.joellipman.com/component/content/article/accessing-apimo-webservice-api.html?catid=109&Itemid=165

    CURLOPT_URL, $apimo_url.'?'.$apimo_message_xml); // set url curl_setopt($ch, CURLOPT_VERBOSE, 1); // For debugging purposes (read CURL manual for nore info) curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 30); // Timeout options curl_setopt($ch,...

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

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

    respective column heading. Remove any ruler gridlines that don't truly serve a process (even if they're just for margin purposes)

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

  11. Newbies guide to be the local computer guyhttps://www.joellipman.com/component/content/article/newbies-guide-to-be-the-local-computer-guy.html?catid=116&Itemid=165

    I have, all your issues have been dealt with and I also did this..." "So this is what I've quickly put together for demo purposes."

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *

  12. Zoho CRM: Update Opportunity Type as New or Existing Businesshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-update-opportunity-type-as-new-or-existing-business.html

    Business" depending on whether this won opportunity is the second time for this account. Why? Mainly for reporting purposes. We want ZohoCRM to report on what is repeat business and what is new business. As part of a process, you could get your staff to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *

  13. $_SERVER['http_referer'] returns blank in Internet Explorerhttps://www.joellipman.com/component/content/article/serverhttpreferer-returns-blank-in-internet-explorer.html?catid=62&Itemid=165

    the user anyway but I was using it as an additional validation check. The only solution is to not use it for verification purposes as it will only work in every other browser except Internet Explorer (more specifically versions 6 and 7...???) For more...

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

  14. Converting SQL date in PHP to European date format and vice-versahttps://www.joellipman.com/articles/cms/website-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

    example, our HTML form will allow the user to specify a date (so excludes hours, minutes and seconds). For demonstration purposes, I'm going to be using the European date format so DD/MM/YYYY. The Solution This is what I use to convert a given SQL date...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
Results 41 - 54 of 54