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

  1. Free Translator API using Googlehttps://www.joellipman.com/component/content/article/free-translator-api-using-google.html?catid=61&Itemid=165

    month. Microsoft's Bing has added itself to the fray pretending to offer free services but in the small print, you will find they too charge the same price. How? The Google Translate API still actually exists. Just don't try to exceed your free quota:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  2. If Then Else in Report Builder 2.0 Expressionshttps://www.joellipman.com/component/content/article/if-then-else-in-report-builder-20-expressions.html?catid=75&Itemid=165

    Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0 I'm looking at the following if statement: If (MyFieldName = 0)...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  3. Border settings not saving in SSRShttps://www.joellipman.com/component/content/article/border-settings-not-saving-in-ssrs.html?catid=75&Itemid=165

    may sound silly to some but I've written a note because I spent time googling and still didn't find an answer. My situation is that I wanted to put an expression to format the border (empty cells have a border and non-empty don't). This was so that a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  4. 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

    on the “People and Groups” link at the bottom of the left menu Click on the “All People” link at the top of the left menu Find yourself in the list by using the iccle arrow next to the 0-100 (top right) Click on your own name or picture to see your...

    • Type: Article
    • Author: Joel Lipman
    • Category: SharePoint
    • Language: *
  5. VBScript to retrieve Windows Product Keyhttps://www.joellipman.com/component/content/article/vbscript-to-retrieve-windows-product-key.html?catid=80&Itemid=165

    number / product key from my Windows 7 Professional 32-bit operating system. I didn't want to dig through my CD/DVDs to find my original windows 7 disc and no longer have access to the email account when I purchased Windows 7 (my university one). How?...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  6. MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/else/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

    --------- -------------------------- 1 Me,Myself,I Note that the following queries include the nested version because I find myself needing to group concatenate more often from another table then using data from the same table. MySQL SELECT ( SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  7. MySQL Commands to display all columnshttps://www.joellipman.com/articles/else/database/mysql/mysql-commands-to-display-all-columns.html

    scenario is that I wanted a PHP/MySQL extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. The following is a MYSQL query that displays the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  8. SQL: Use CASE for Relevance columnhttps://www.joellipman.com/articles/else/database/mysql/sql-use-case-for-relevance-column.html

    of relevance and sorts the rows accordingly. How? This has to be a real quick one for a dropdown search field which has to find relevant terms to autofill/autocomplete a search form: -- where @ThisSearch is a posted (and sanitized) variable SET...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  9. Code Troubleshooting Checklisthttps://www.joellipman.com/articles/cms/website-development/code-troubleshooting-checklist.html

    worked? Suggestions by Wikipedia If you are having difficulty understanding a problem, try drawing a picture. If you can't find a solution, try assuming that you have a solution and seeing what you can derive from that ("working backward") If the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
Results 161 - 169 of 169