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

  1. SSRS External Images don't displayhttps://www.joellipman.com/component/content/article/ssrs-external-images-dont-display.html?catid=75&Itemid=165

    a solution, I would definitely recommend seeing if you can't check at the database level first. I will in future. Debug Method Fallback to debug methods; create a textbox that will be visible on the executed report (obviously replace the field name with...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  2. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    I went through about 10 pages of google results without working out how to use these in SSRS and then resorted to my old methods of debugging. For those of you who don't know what a cursor is, you can find this info on another site as this article...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  3. SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

    This article details a method we used on a search form in a SQL Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. Analyzing the report through the ReportServer databases...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  4. Print Directory Contents to a Filehttps://www.joellipman.com/component/content/article/print-directory-contents-to-a-file.html?catid=80&Itemid=165

    What? We can do this by adding an entry to the context menu (when you right-click on an object). The following is a method of adding this as a single command similar to how we add the "Command prompt from here" option (now built-in to Windows 7). I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  5. Set up Desktop SlideShow in Windows 7https://www.joellipman.com/component/content/article/set-up-desktop-slideshow-in-windows-7.html?catid=80&Itemid=165

    to Windows 7. Requires a Vogonian environment of red tape and bureaucracy. This is an article to describe an alternative method then "right-clicking on the desktop", "selecting Personalize", "clicking on Desktop Background", "browsing to the Picture...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  6. Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/convert-to-proper-case-in-t-sql.html

    in VB or C#. This version is entirely using T-SQL and we're going to use a function so no dynamic SQL (execute, evaluate). Method #1: First version This was my first attempt based on snippets around the web. This one has two sections, the first part...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  7. MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/else/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

    00:00 02:00 36:00 Myself 07:30 07:30 07:30 07:30 07:00 00:00 00:00 37:00 I 03:45 03:30 03:00 03:30 00:00 00:00 00:00 23:00 Method 1. Generate query to list all valid users 2. Generate query which will total hours per week per user 3. Combine in a loop...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  8. Webdeveloper-Speakhttps://www.joellipman.com/articles/cms/website-development/webdeveloper-speak.html

    ‘Belt-and-suspenders’ describes an approach to web design where provision has been made for more than one method of achieving a satisfactory outcome. typosquatter A typosquatter is a company/individual that registers the misspelling of a popular website...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  9. Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    server) Critical functions used in the system? (do this yourself anyway and use theirs as a guide only) Site Authentication Method(s) (will this need to be rewritten? eg. clear-text passwords) Level of Security Testing (XSS and SQL-Injection at least?)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  10. Display Feeds to major Social Networkshttps://www.joellipman.com/articles/cms/website-development/display-feeds-to-major-social-networks.html

    Instagram Not sure on this one as I could only embed a specific video manually. Will update this if ever a free method for embedding the page comes up. Go to Instagram and open the video/picture to embed Click the 3 dots (ellipsis) at the bottom right...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  11. Three boxes, two roll over, one falls outhttps://www.joellipman.com/articles/cms/website-development/css/three-boxes-two-roll-over-one-falls-out.html

    I was working with a Yootheme template called "yoo_sync". Some clever scripts (both mootools and jquery) using the equalize method to make div layers the same height, and in this case, the same width. It isn't so much a miscalculation of 100% divided by...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  12. Sort an associative array by values in Javascripthttps://www.joellipman.com/articles/cms/website-development/js/sort-an-associative-array-by-values-in-javascript.html

    What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *
  13. Preg_Replace all strings between two tagshttps://www.joellipman.com/articles/cms/website-development/php/preg-replace-all-strings-between-two-tags.html

    all @words Convert: Hello @World » Hello @World $string_formatted = preg_replace( '/@[a-z]+/i','$0', $string_original); -- METHOD #2: equivalent using preg_match_all $matches = null; preg_match_all('/(?!\b)(@\w+\b)/',$string_original,$matches); foreach...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  14. Pancakeshttps://www.joellipman.com/component/content/article/pancakes.html?catid=96&Itemid=165

    salt 2 eggs 200ml/7fl oz milk mixed with 75ml/3fl oz water 50g/2oz butter To serve: caster sugar lemon juice lemon wedges Method Sift the flour and salt into a large mixing bowl with a sieve held high above the bowl so the flour gets a airing. Now make...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  15. Tagliatelle alla Carbonarahttps://www.joellipman.com/component/content/article/tagliatelle-alla-carbonara.html?catid=96&Itemid=165

    plus extra for serving 50g/2oz aged pecorino, freshly grated salt and freshly ground black pepper 350g/12oz egg tagliatelle Method 1. Heat the olive oil in a thick-bottomed saucepan. Add two-thirds of the prosciutto and fry for one minute. 2. Add...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  16. Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=105&Itemid=165

    Version Platform ChangeLog Options 3.2.4 - Fixed Bug: Some systems report "Strict Standards: Non-static method called" - Note: not included in auto-update as it only applies to certain environments. - Note: this version is also backwards compatible...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  17. 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

    for blank excel lines) if(column_values[0] != ''){ // remove any/all double-quotes in this column value // found this method more reliable than using regex removed_quotes = column_values[1].split('"').join(''); // populate my array with an object...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  18. Minimal Privileges for MySQL Database Backup Cron Jobhttps://www.joellipman.com/component/content/article/minimal-privileges-for-mysql-database-backup-cron-job.html?catid=111&Itemid=165

    and copying data from a LIVE database) to a copy of the database (inaccessible via other users). How? I want to list 2 methods here. One to create a .sql file of the backup but another to copy the contents to a copy of the database accessible only by...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *
  19. Joomla CMS: Register to Read Morehttps://www.joellipman.com/articles/cms/joomla/joomla-cms-register-to-read-more.html

    be indexed in global search engines such as Google. How? It's been difficult to search for the right words but heres the method to restrict the introtext to the public and fulltext (read more) to the registered users: Login to the Joomla Administrator...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  20. Ubuntu as a media serverhttps://www.joellipman.com/component/content/article/ubuntu-as-a-media-server.html?catid=63&Itemid=165

    tv's crop off the border around the image. How does Ubuntu intend to officially solve this? Right now LinuxMCE has it's own method for doing this so the LMCE UI is never cropped off, but when the user switches back to Ubuntu's gnome desktop, the top nav...

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
Results 81 - 100 of 101