Advanced Search

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

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

    data from my CTE in its post-formatted form. I perform all the formatting within the CTE and when it comes to the CASE events comparing to the previous row, all I do is say display this value or display a blank value based on if this is a marked row...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  2. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    '/', SUBSTRING(YEARWEEK(s.DateTimeCreated,1), 1, 4)) AS ActivityWeek, CASE COUNT(*) WHEN 1 THEN '(1 Event)' ELSE '(Multiple Events)' END AS DataAccuracy FROM StaffActivities s INNER JOIN Users u ON u.UserID=s.StaffUserID INNER JOIN Resources r ON...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  3. Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

    my recommended solution. How? We're going to use the onBlur and onFocus attributes which do, as the name indicates, trigger events when the cursor is either in the field or not. The above field was created with the following code: Explanation...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
  4. Add default to a picture buttonhttps://www.joellipman.com/component/content/article/add-default-to-a-picture-button.html?catid=48&Itemid=165

    Well there's a lot of autohotkey sites saying that you can apply a transparency and then capture special mouse events to emulate the mouseover and mouseout effects of a button with an image as a background. I couldn't get any of these working and they...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
Results 21 - 24 of 24