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

  1. SSRS Report Builder 2.0 - Error during processinghttps://joellipman.com/component/content/article/ssrs-report-builder-20-error-during-processing.html?catid=75&Itemid=165

    The Issue After modifying a report and on running it, Report Builder 2.0 returns the following error: An error occurred during local report processing. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. The...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  2. SSRS Use T-SQL Like with a Parameterhttps://joellipman.com/component/content/article/ssrs-use-t-sql-like-with-a-parameter.html?catid=75&Itemid=165

    -- WARNING: 0 matching rows This returns nothing. Took me a while to figure why but it's the parameter that's the issue. You don't enclose it with apostrophes for one thing. So let me rewrite this: SELECT rb.[GivenDate] , rb.[DateStart] ,...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  3. SSRS Change Background Color of Imagehttps://joellipman.com/component/content/article/ssrs-change-background-color-of-image.html?catid=75&Itemid=165

    based on the status result. If I simply insert an image, the report would use the background color of the report. How? The issue exists if your image has transparent areas but displays the report background color instead: Right-click on the cell you...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  4. Oracle: order by subquery missing right parenthesishttps://joellipman.com/articles/else/database/oracle-pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

    and often enough we get the latest by ordering the dataset of the subquery. In T-SQL and MySQL, this is not so much of an issue. I get this error when having to use an ORDER BY clause in a subquery within an Oracle 11g environment. How? Consider the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *
  5. MySQL Transactions in PHPhttps://joellipman.com/articles/else/database/mysql/mysql-transactions-in-php.html

    $mysqli->rollback(); } $mysqli->close(); mysqli->begin_transaction() requires PHP 5.6 and above. For lower versions you can issue the MySQL commands directly like: mysqli->query("START TRANSACTION") mysqli->query("COMMIT") mysqli->query("ROLLBACK")...

    • Type: Article
    • Author: Ike Francis
    • Category: MySQL
    • Language: en-GB
  6. Code Troubleshooting Checklisthttps://joellipman.com/articles/cms/website-development/code-troubleshooting-checklist.html

    Can you access the service? Can you open other similar files in the same environment? Is a colleague experiencing the same issue? Can you access the service using a different workstation? Was the last time you used the service recent? Has anything been...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  7. How to make a HTML form post its variables to itselfhttps://joellipman.com/articles/cms/website-development/html/how-to-make-a-html-form-post-its-variables-to-itself.html

    The Issue You have a PHP page which generates a HTML form. When the user submits the form, you want the same PHP page to process the data. Solution I've seen a lot of people write CGI requests but if you left the action attribute blank, this would do...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  8. Converting SQL date in PHP to European date format and vice-versahttps://joellipman.com/articles/cms/website-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

    Issue If you've ever made PHP scripts to process data within a LAMP environment (Linux, Apache, MySQL, PHP) then this happens a lot. In the following example, our HTML form will allow the user to specify a date (so excludes hours, minutes and seconds)....

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  9. Prices get rounded up in Virtuemarthttps://joellipman.com/articles/else/e-commerce/virtuemart/prices-get-rounded-up-in-virtuemart.html

    This happened to a m8s website in VirtueMart 1.1.3. The issue here was that although all the prices lost their float/decimal and were rounded up to the nearest integer... At first we thought this was due to installing a Virtuemart UK Credit Card...

    • Type: Article
    • Author: Joel Lipman
    • Category: Virtuemart
    • Language: *
Results 81 - 89 of 89