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

  1. Call to a member function mark() on a non-object in Joomla CMShttps://www.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

    one of my clients, the error was due to an update process gone wrong. Not really the fault of Akeeba, Joomla or anyone, it's just one of those things. Check the sizes of the PHP files on your site and hope that they're not at 0 bytes. Excluding the HOME...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  2. Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

    to ensure you have a static IP (most ISPs now assign static IPs to home broadband users as well as larger corporations). But just in case you don't have one, let me do this in two stages. Move the /administrator URL Create a folder in the root of your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  3. Basic Android App using Google Maps and Current Locationhttps://www.joellipman.com/articles/else/app-dev/android-os/basic-android-app-using-google-maps-and-current-location.html

    // Creates a CameraPosition from the builder map.animateCamera(CameraUpdateFactory.newCameraPosition(cameraPosition)); Just in case: AndroidManifest.xml The example above should have populated this correctly but if you are still getting problems, I have...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  4. Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/component/content/article/alternate-row-background-colour-in-reporting-services.html?catid=75&Itemid=165

    This is just a note for me as it took a while to find on the net and even then it was confusing as to why it works but it does. Not sure whether you call this an MDX Query or part of a Transact-SQL mashup. You need to go to "Fill" (of each text box in...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  5. SSRS Querying on either of 2 Parametershttps://www.joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

    leaves both fields blank? This would return all users who don't have an AD account. Using the revisited solution below -> Just leave the "allow blank" option in the parameter properties unchecked SSRS Report Revisted: Had an issue where SSRS report...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  6. Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/component/content/article/green-red-background-colors-based-on-dataset-values.html?catid=75&Itemid=165

    totals of these. I haven't Googled this at the time of print so there may be a million better solutions out there, this is just how I did it. This may look like a horrible report which would fail an accessibility test but visually it says straight away...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  7. Problem creating SSRS report subscriptionshttps://www.joellipman.com/component/content/article/problem-creating-ssrs-report-subscriptions.html?catid=75&Itemid=165

    in the dropdown menu Select "Data Sources" in the left menu Specify a "shared data source" and browse to the one you just created and click on "OK". Click on "Apply" (just to be sure). Ensure unattended system account scheduled to run and email the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  8. Connection Strings for SQL Serverhttps://www.joellipman.com/component/content/article/connection-strings-for-sql-server.html?catid=78&Itemid=165

    Wrapper Class Library Usage: System.Data.OleDb.OleDbConnection Manufacturer: Microsoft Bridging to MySQL OLEDB This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  9. Remove write-protect from USB pen in Windowshttps://www.joellipman.com/component/content/article/remove-write-protect-from-pen-in-windows.html?catid=80&Itemid=165

    I just had to put something here as I have been buying and returning failed/corrupt USB pens. In the past few months I have been trying to upgrade my 16Gb USB Integral Pen from Play.Com to a 32Gb equivalent. I use my USB pen as the "My Documents"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  10. Search a database with SOUNDEXhttps://www.joellipman.com/articles/else/database/search-a-database-with-soundex.html

    same way in the same case. Wouldn't it be nice to search through your entire database for similar sounding values (so not just case), and in this example, find typos as well, eg. "Daat ont Ety Aviable". How? Mine's a bit of a copout as it is a two-step...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  11. Reorder Columns in a Tablehttps://www.joellipman.com/articles/else/database/reorder-columns-in-a-table.html

    Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  12. Error during processing - Converting Date/Timehttps://www.joellipman.com/articles/else/database/t-sql/error-during-processing-converting-datetime.html

    ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done this silly mistake. I'm only guessing the same error would happen in Report Builder 2.0 which I've...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  13. SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    button to enter the below expression: Delete Order Column: Ok the expression and BIDS will add the parent group we added just before. You can now right-click on the top of the [Order] column (grey square -like excel- to select the column). Select...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  14. CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://www.joellipman.com/articles/else/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

    added for demo purposes): String1.String2.String3.String4 1 5 10 15 20 25 30 -> length = 31 I'd like to end up with just the last part of this, ie "String4". So I need to delimit based on the dot/period (.) and use substring in a sort of reversed form....

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  15. MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/else/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

    and the like. I like queries against this database because it involves linking a lot of tables and outputting... just articles and their titles. I have another table holding the audit trail of content approvers on the system. Approvers can e-sign an...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  16. Convert foreign characters to English alphabethttps://www.joellipman.com/articles/else/database/mysql/convert-foreign-characters-to-english-alphabet.html

    from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the names of places in other countries. This is nice but its search engine doesn't...

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

    for and what it does. The developer had created the system to only last during one academic year, and the system itself only just about understood academic years (required tweaking twice a year). Then there were the error logs... some 20000 errors per...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  18. What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/cms/website-development/whats-the-problem-amusing-computer-reports.html

    If you're not an IT person, you may want to avoid reading the rest of this article in case you're easily offended. It's just an amusing stab at customers computer issues. Note that most of the below were remote support jobs so we weren't there in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  19. This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://www.joellipman.com/articles/cms/website-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

    file in the web root folder where your MediaWiki is installed: $wgFileExtensions[] = 'swf'; or if you already have an array, just add it to the end: $wgFileExtensions = array('png', 'gif', 'jpg', 'jpeg', 'doc', 'ppt', 'xls', 'mpp', 'pdf', 'zip', 'flv',...

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

    the color back to grey. If it isn't, then leave as is and ensure the color is still black. Additional Note that instead of just saying if this value equals "Name:" I've added some code to trim the values. If the user types two spaces, then we want the...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
Results 81 - 100 of 277