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

  1. ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

    of an item with a list price of 12345.545: ZohoCRM Line Item ZohoBooks Line Item How? Here's the immediate solution I have applied now until Zoho enable an option to round via API with a 10th of a penny/cent or less. After creating or updating the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *

  2. Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

    => just cos this value exists, don't know why you would order by this ordering => the setting it's on if you haven't made this modification. I don't like it and nor do u if you've been trawling the web for this solution. archived => is or not approved...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

  3. Could not instantiate mail functionhttps://www.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

    problem is still there then check the below: Tried both PHPmail and sendmail So if this happens irrespective of whether I have PHP mail or sendmail set as the Mailer. Notice Could not execute: /usr/sbin/sendmail Warning Registration failed: An error was...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

  4. 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

    a solution here because this is indicating that the system can't find the core framework files. Yes the bad news is you have lost your site. The good news is that it's only the core files and component files. Here are some tips when restoring the site...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB

  5. Registered Users Cannot Login - Super Users Canhttps://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

    to examine the database and a quick scan in the assets table revealed 3 assets had the parent_id = 0. Only one asset can have that and that is "root". Login to your Joomla database using your MySQL database manager (eg. phpMyAdmin, MySQL Workbench) Open...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB

  6. Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/component/content/article/google-authentication-oauth-2-0-using-php-curl.html?catid=61&Itemid=165

    the existing one as long as it hasn't expired. Update 2019 This script requires a user to authenticate the google account. I have a newer article called Google Drive API v3 - OAuth2 using Service Account in PHP/JWT documenting a script which accesses a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB

  7. Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

    This took me a whole afternoon and involved a lot of hope as I browsed the Internet and no one seemed to have done this before. Fortunately, MediaWiki extensions are easier to write than Joomla CMS ones :c) This article shows you how to get your...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB

  8. 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

    between the two for the rest of the report. [The second example is what I use most frequently]. Additional: Suppose you have lots of columns, you don't want to have to click on each cell to specify this so just do it to the first column then bring up...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  9. Before and After, Highs and Lowshttps://www.joellipman.com/component/content/article/before-and-after-highs-and-lows.html?catid=75&Itemid=165

    SQL queries to get the count of yesterday, yesterweek, yestermonth, yesteryear and do the layout in PHP. Now let's say I have one RDL or SSRS Solution. I could do a dataset per SQL query but it doesn't seem that ideal. In Theory: SELECT ItemName,...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

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

    to upload the photos. These images are provided via a website address (http) or network share (file). Before you ask, we have several MS Sharepoint sites but we didn't go down the route of uploading 10000+ images into a Sharepoint database though we are...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  11. How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/component/content/article/how-to-display-report-execution-time-in-ssrs.html?catid=75&Itemid=165

    report (which searches for results matching the submitted parameter) to run. Lifted from Dattatray Sindol's blog Other sites have this solution as well so who copied off who is not my concern as this is not the solution to our problem. This is the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  12. SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

    I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a dropdown populated by a list of all available reports. Why? I...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  13. Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    The Issue People have reported that although they have manually set the date/time on their computer, this gets changed by the windows time server (time.windows.com) when connected to the Internet and for some reason it doesn't display the right...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  14. T-SQL Record Separatorhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-record-separator.html

    have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on my computer" and me replying "why would you want to do...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  15. Split a row into multiple rows based on a column valuehttps://www.joellipman.com/articles/else/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

    is a quick article on how to split a single row into multipe rows based on the value of a column in the same table. Why? I have a table that has all the days of sickness of employees. This table contains, which employee, on what date, and for how many...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *

  16. No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return data using the student ID number found in the first query....

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  17. Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

    3509 not foun d; No message file for product=NETWORK, facility=TNS Why? We NEED several instances of Oracle installed as we have different products/services and these run off various instances of Oracle 9i, 10g, and 11g. This article was written for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  18. Error 1065: Query was Emptyhttps://www.joellipman.com/articles/else/database/mysql/error-1065-query-was-empty.html

    In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common. Why? Bespoke systems are the usual suspects....

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *

  19. Access MySQL databases using Oracle SQL Developerhttps://www.joellipman.com/articles/else/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

    use Oracle databases in my day job so the Oracle SQL developer is already a pre-approved software for our work computers. We have SQL Server Management Studio (SSMS) as well for our SQL Server instances but it wasn't practical to link this to mySQL...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  20. Country Lookup by IP address CSVhttps://www.joellipman.com/articles/else/database/mysql/country-lookup-by-ip-address.html

    to serve as documentation for one of the data sources available to download for FREE from this site. Why? It's useful to have a CSV list of all the IP ranges and their allocated country. Our use here was to create a refreshable country by IP address...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
Results 101 - 120 of 416