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

  1. DataTumble - Randomize Data Rowshttps://www.joellipman.com/articles/else/database/t-sql/datatumble-randomize-data-rows.html

    FETCH NEXT FROM @UpdateCursor INTO @Data WHILE @@FETCH_STATUS = 0 BEGIN -- OPEN RandomID SET @random = CEILING(RAND()* CONVERT(VARCHAR(MAX),@NumberLeft) ) SELECT @ChosenID = MAX(ID ) FROM (SELECT TOP (@random) ID FROM #Scramble WHERE Chosen IS NULL ) A...

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

  2. DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/else/database/t-sql/datascramble-randomizing-data-rows.html

    2 - LEN(@RandSeconds))) + '.' + STUFF(@RandMSeconds, 1, 0, REPLICATE('0', 3 - LEN(@RandMSeconds))); SET @TimeVal = CONVERT(time, @TimeVal, 14); END -- DETERMINE WHICH DATE PARTS WERE SUBMITTED IF @TimeMatch=1 AND @DateMatch=0 SET @NewVal = @TimeVal;...

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

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

    . "\t" . $this_t . "\t" . $this_t2;...do some more here ???... } } Yields -- Note this data matches the brief as we've converted the seconds to time. -- Using MySQL to convert rather than PHP so as not to have to deal with hour changes and the magical...

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

  4. Project Plan for Freelance Websitehttps://www.joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    Corporate Logo Create initial logo and replace existing template logo with this one Discuss suitability and variances Convert, format, or create vector-based version of the logo (vector-based = can be any size without any deterioration in image...

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

  5. UTF8 Unicode PHP MySQL for International Charactershttps://www.joellipman.com/articles/cms/website-development/php/utf8-unicode-php-mysql-for-international-characters.html

    and forum solutions, and although these changes would have an effect on the module (such as take away accents and convert to ASCII), they weren't what we were looking for. The quick solution was to make the script run a MySQL command at the start: SET...

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

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

    db_name CHARACTER SET latin1 COLLATE utf8-general-ci; // set text fields to utf8 SET NAMES 'utf8'; This does nothing: // convert the foreign character using PHP to htmlentities $my_description = htmlentities($my_description); $my_description =...

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

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

    code, the entity code and then the inner SRL text which should be |, if you try to apply you should be prompted to convert to use gold characters: Test the XET export and you should get something like: 5826|England Almost! If the code and it's short...

    • 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

    null. This doesn't have much affect on point-to-point conversions and strings but what if the value is blank and I try to convert that date of birth from SQL format (yyyy-mm-dd) to European format (dd/mm/yyyy)? See the following: -- assuming value of...

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

  9. Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/component/content/article/import-excel-csv-file-as-javascript-array.html?catid=110&Itemid=165

    label1,label2 item1a,item2a item1c,"item2c,c" item1b,item2b What I want: To read the file (stored on the server) and convert to a JavaScript array of objects var my_object_array = [ { my_col1_val: 'item1a', my_col2_val: 'item2a' }, { my_col1_val:...

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

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

    CSV list from a standard MS Windows eventlog or eventviewer log and generate a chart 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *

  11. How to use download managers with Google Chromehttps://www.joellipman.com/component/content/article/how-to-use-download-managers-with-google-chrome.html?catid=61&Itemid=165

    of the video. Click on your bookmark and Google should say it's downloading the FLV file Using the bookmark feature and convert to MP4: Right click on the bookmarks bar of Google Chrome. Type the name to what ever you want (eg. Download YouTube). Use...

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

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

    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 to the standard European format: $this_date=mysql_result(mysql_query("SELECT my_date_field FROM my_table...

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

  13. PHP: First name and Initial of Surnamehttps://www.joellipman.com/articles/cms/website-development/php/php-first-name-and-initial-of-surname.html

    A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How? So different ways, the first...

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

  14. Prices get rounded up in Virtuemarthttps://www.joellipman.com/articles/else/e-commerce/virtuemart/prices-get-rounded-up-in-virtuemart.html

    Virtuemart UK Credit Card Payment Module (vm-ukcreditcard). A lot of forums were suggesting to change the number_format to convert any number to a currency or two decimal places. Another suggestion was to alter the main virtuemart database table...

    • Type: Article
    • Author: Joel Lipman
    • Category: Virtuemart
    • Language: *
Results 81 - 94 of 94