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

  1. T-SQL concatenate an incremental row numberhttps://joellipman.com/articles/else/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

    the Employee "Joel Lipman" has a degree in Computer Science BSc and some qualification in being Superman. Specification The output expected by the customer is the following: EMP -------------------------------------------------- EmpNumber...

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

  2. MySQL: Count occurrences of words in a columnhttps://joellipman.com/articles/else/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

    This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used first...

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

  3. Sort an associative array by values in Javascripthttps://joellipman.com/articles/cms/website-development/js/sort-an-associative-array-by-values-in-javascript.html

    and using the Google Chrome browser. I wanted to: Sort the array by its values my_records.sort(); Iterate through and output these in HTML for(i=0;i y ? 1 : 0; }); // use built-in JSON stringify function newSortedArrayObject =...

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

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

    CURLOPT_RETURNTRANSFER, TRUE); // TRUE to return the transfer as a string of the return value of curl_exec() instead of outputting it out directly. // store the response $ch_result = curl_exec($ch); // close connection curl_close($ch); // convert the...

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

  5. Foreign Characters create symbols in PHP and MySQLhttps://joellipman.com/articles/cms/website-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    following to my headers: This does nothing: // add these to the header: DOESNT WORK mb_internal_encoding('UTF-8'); mb_http_output('UTF-8'); mb_http_input('UTF-8'); This does nothing: // add the following to your header This does nothing: // set the...

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

  6. MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/component/content/article/ms-excel-split-workbook-into-separate-files-per-sheet.html?catid=110&Itemid=165

    no greater than 1Mb. So our script has to split a single spreadsheet into multiple worksheets of 3000 rows each, and then output each sheet to a separate file that is formatted as XLS (Not *.xlsx). How? In summary, we are going to move the Excel file to...

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

  7. SSRS Repeat Headers in PDF Reporthttps://joellipman.com/component/content/article/ssrs-repeat-headers-in-pdf-report.html?catid=75&Itemid=165

    I have a report which has been set to landscape with zero margins specified. Although BIDS acknowledges that I want this to output to A4 with the correct measurements, the report doesn't seem to have any page breaks. When I run the report in BIDS, the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  8. SSRS Change Background Color of Imagehttps://joellipman.com/component/content/article/ssrs-change-background-color-of-image.html?catid=75&Itemid=165

    want to put the image in. Insert > Rectangle Set the Rectangle Fill color (I'm using an expression based on the status) to output: Green (for Success), Red (for Fail), Orange (for Unknown). Right-click on the rectangle and select Insert > Image Edit the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  9. Php convert filesizes to bytes kb mb gbhttps://joellipman.com/articles/cms/website-development/php/php-convert-filesizes-to-bytes-kb-mb-gb.html

    Just a quick note on how to format a given filesize and to reduce the display output to a small string, eg: 196 bytes : displays as => "196 bytes" 12945 bytes : displays as => "12 Kb" 1478515 bytes : displays as => "1 Mb" 8798745455 bytes : displays as...

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