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

  1. SSRS Border Problemhttps://www.joellipman.com/component/content/article/ssrs-border-problem.html?catid=75&Itemid=165

    the word "None" next to it (as its value). Press the "Enter" key if you need to. You are now free to apply normal borders to each specific cell.

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  2. SSRS No Delay for First Report of the Dayhttps://www.joellipman.com/component/content/article/ssrs-no-delay-for-first-report-of-the-day.html?catid=75&Itemid=165

    but this one made a noticeable difference. Applicable to the server, it will affect all reports on that server. Apply to each server that requires it. Let your report server administrators do this: On the server, open the XML file: C:\Program...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  3. SharePoint 2007: Change profile picture with minimal permissionshttps://www.joellipman.com/component/content/article/sharepoint-2007-change-profile-picture-with-minimal-permissions.html?catid=77&Itemid=165

    in your company's sharepoint site. Sounds straightforward but without being allowed to upload images or edit other profiles, each user has to do this with the permissions they've been given. Why? Because I can How? Setup an account with gravatar.com and...

    • Type: Article
    • Author: Joel Lipman
    • Category: SharePoint
    • Language: *
  4. Search and Replace in a MySQL Databasehttps://www.joellipman.com/articles/else/database/mysql/search-and-replace-in-a-mysql-database.html

    ever sat there with phpMyAdmin or a MySQL Administration Tool (like Navicat or SQLYog), and still there at night editing each field so that it displays correctly... well that's usually me. Found it a bit boring but here's a short bit of code to speed it...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  5. MySQL Transactions in PHPhttps://www.joellipman.com/articles/else/database/mysql/mysql-transactions-in-php.html

    SET 'balance' = 'balance'+1000000 WHERE 'user' = 'Fred'"); $a2=$mysqli->affected_rows(); //Check 1 row affected by each query if ($a1==1 && $a2==1) { //Everything looks OK, commit changes $mysqli->commit(); } else //Something went wrong. Roll back to...

    • Type: Article
    • Author: Ike Francis
    • Category: MySQL
    • Language: en-GB
  6. First and Last Entry on a Page using Modulus Remainderhttps://www.joellipman.com/articles/cms/website-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

    at the start of the loop (and at every first entry of a page). I want the script to close the DIV layer at the last entry of each page. So I have a loop Rather crude but it's a FOR loop for those old CMS's running PHP4: for ($this_link_index=1;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  7. Cranberry flapjackhttps://www.joellipman.com/component/content/article/cranberry-flapjack.html?catid=96&Itemid=165

    2. Melt the butter in a thick based non-stick frying pan. Spoon the mixture into small rounds. 3. Fry for 2-3 minutes on each side until golden. 4. For the caramel sauce, in a hot pan, add the butter and sugar and cook for 3-4 minutes. Then add the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  8. Excel: Extract hyperlink from linkhttps://www.joellipman.com/component/content/article/excel-extract-hyperlink-from-link.html?catid=110&Itemid=165

    a new module (Insert > Module) Copy and Paste the Excel user defined function below Sub ExtractHL() Dim HL As Hyperlink For Each HL In ActiveSheet.Hyperlinks HL.Range.Offset(0, 1).Value = HL.Address Next End Sub Press F5 and click “Run” Get out of VBA...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  9. MS Excel - Open CSV with Long Numbershttps://www.joellipman.com/component/content/article/ms-excel-open-csv-with-long-numbers.html?catid=110&Itemid=165

    knew what to do with it. It doesn't. Saving the data source as a text file means that Excel will prompt you what to do with each column: 1. Specify that the data is delimited 2. Specify the data is delimited by commas 3. Specify which columns should be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 201 - 209 of 209