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

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

    the variations of the default values which we found we could do with the built-in SOUNDEX function. How? Lets assume the following, we have a table containing: StudentID StudentDetail Soundex ----------------- ---------------------- ----------- 1 Data...

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

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

    This is a quick article on how to use a counter added to the end of a field column of data. Eh. What? Assume the following two tables exist: TABLE: Employee -------------------------------------------------- ID FirstName Surname 1 Joel Lipman 2 Another...

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

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

    system which stores XML strings in a database and rather than a separate file, it stores these in a row. How? Assuming the following data exists in the column "Event_XML" value of the table "XML_EVENTS": 123456 Mr J JOEL LIPMAN MALE 1990-01-01 SUPER...

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

  4. Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    table style will be "Generic". > Next FINISH That's all folks! Hopefully this will save you time. I spent a whole morning following someone else's complicated connection using SQL Server Management Studio and would not recommend anyone to go through the...

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

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

    the hours is on the other side of the midnight hour... Now bear in mind the below is in European date format Consider the following: Date Customer Time From Time To Hours ---------- --------------- --------------- ---------------- --------------...

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

  6. CSS Background Without Causing Scrollbarshttps://www.joellipman.com/articles/cms/website-development/css/css-background-without-causing-scrollbars.html

    of sky and grass with a centered content section (white semi-transparent layer) of 900 pixels width as shown in the following picture: And I want the clouds as another layer ontop aligned to the top right: Tried and failed: Specifying the width of the...

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

  7. Background Gradient Disappears on Long Pageshttps://www.joellipman.com/articles/cms/website-development/css/background-disappears-on-long-pages.html

    This is a quick article on how to resolve the following issue: Overall body background color is blue. Background color of my contents is white. When I visit a small page on the site, the contents background (white) shows. When I visit a very long page...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *

  8. CSS Add Text to Breadcrumb Link with a Transitionhttps://www.joellipman.com/articles/cms/website-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

    Products / Lanterns // if I hover the mouse over the "Lanterns" link: » Home / Products / More Lanterns How? Given the following HTML: Home Products lanterns Using CSS only, I have so far achieved the following: /* Specify a blank prefix which is fully...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *

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

    instead of the foreign character. How does it happen? Have I tried the other solutions on the web? I have tried adding the following to my headers: This does nothing: // add these to the header: DOESNT WORK mb_internal_encoding('UTF-8');...

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

  10. Submit form as a server and not the client with cURLhttps://www.joellipman.com/component/content/article/submit-form-as-a-server-and-not-the-client-with-curl.html?catid=109&Itemid=165

    address. How? It's likely that you already know how to submit a HTML form to a server via your Mobile application so the following will only document the process of sending data under the server IP address. We're going to use a PHP script with the cURL...

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

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

    it solved it as only some different headers appeared on the exported report when we followed that suggestion. Consider the following report in design view, only the circled headings would appear on the exported report: The solution I found that worked...

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

  12. Excel: Find values in one column that are not in anotherhttps://www.joellipman.com/component/content/article/excel-find-values-in-one-column-that-are-not-in-another.html?catid=110&Itemid=165

    have a new list, I want a quick way to see what values are in the old column and which ones are new... Why? Consider the 3 following columns in an Excel spreadsheet: Old New Exists in Old? --------- --------- -------------- 123456 234567 234567 345678...

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

  13. Excel - Check a column for values found in another columnhttps://www.joellipman.com/component/content/article/excel-check-a-column-for-values-found-in-another-column.html?catid=110&Itemid=165

    purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively. Sheet1 contains the following: A B --------------- --------------- seize spell fence total thank fight noise terms thigh tasty light swarm shelf allow...

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

  14. Warning call_user_func: First argument is expected to be a valid callbackhttps://www.joellipman.com/articles/cms/joomla/warning-call-user-func-first-argument-is-expected-to-be-a-valid-callback.html

    What? If you get something like the following error: Warning: call_user_func() [function.call-user-func]: First argument is expected to be a valid callback in /home/.../templates/rt_affinity/rt_sectionrows.php on line 311 How? Copy & backup the file...

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

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

    Right click on the bookmarks bar of Google Chrome. Type the name to what ever you want (eg. Download YouTube). Use the following code as the URL: javascript:window.location.href = 'http://youtube.com/get_video?video_id=' + swfArgs['video_id']+ "&l=" +...

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

  16. VBScript to retrieve Windows Product Keyhttps://www.joellipman.com/component/content/article/vbscript-to-retrieve-windows-product-key.html?catid=80&Itemid=165

    email account when I purchased Windows 7 (my university one). How? I'm going to use my trusty notepad program, copy the following code to it, and run it: Create a notepad file called read_product_id.vbs Copy the following code to the file: Set wshShell...

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

  17. MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/else/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

    it beats daytime television any day. I use this quite a lot so I thought I'd put an article here somewhere. Based on the following concept: RowID column_to_return_as_string --------- -------------------------- 1 Me 2 Myself 3 I -- to be returned as...

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

  18. MySQL day of week ending on Fridayhttps://www.joellipman.com/articles/else/database/mysql/mysql-day-of-week-ending-on-friday.html

    weeks always starting on Sunday means this isn't very useful. I have another system which starts on Monday and ends on the following Sunday. The solution below is for the opposite, where the week starts on the previous Saturday and ends on the last...

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

  19. SITS: XET format for Export not availablehttps://www.joellipman.com/articles/cms/website-development/xml/sits-xet-format-for-export-not-available.html

    I had to create a Data Exchange Format first: Run the DEF from the menu Clear and create a new one based on the following: Now you can go and retrieve a student/staff (depending on what data your XET feeds off) Bring up STU File > Export... You should...

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

  20. Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/component/content/article/add-image-mouseover-effect-in-autohotkey-gui.html?catid=48&Itemid=165

    No third-party component or dll needed, just a slight modification to the mousemove tooltip in the autohotkey manual. The following code is not the whole code or a working program but should demonstrate how to include it in your own Autohotkey GUI: ;...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
Results 101 - 120 of 283