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

  1. ZohoBooks: Broken UK Banking Feedhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-broken-uk-banking-feed.html

    of the transactions for a particular account and then to reconcile these. This particular case covers where the Cx had a working automatic bank feed for a while but at some point simply stopped working. How? First let's go through a resolution and get...

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

  2. Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

    file: -- reminder: check for conflicts Additional Notes You have no idea how long it has taken me to get this code in working order and as easy as it may be to others, this has been quite a challenge. I have tried so many examples, testing different...

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

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

    in our case and could be left as they were. Our last file backup was over a year old but we only needed the core files, a working system, and then we could proceed with a standard Joomla update. I suspected that part of an auto-update process had...

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

  4. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/component/content/article/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html?catid=61&Itemid=165

    your OAuth 2.0 access/refresh tokens and specified the appropriate scopes. The scopes I chose were to do with getting a working example rather than the recommended scope, though you may only need the first (untested):...

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

  5. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    this script doesn't need the client libraries, composer, vendor, etc. Why? This took me the best part of a month to get working. It is taken from Google's documentation as well as other forums and websites that try to explain it. Do not waste your time...

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

  6. Setting up your store to use SSLhttps://www.joellipman.com/articles/else/e-commerce/setting-up-your-store-to-use-ssl.html

    people prefer to use dedicated SSL as it looks more professional and can improve customer confidence. How do I test SSL is working? Before we do anything we need to test that the SSL domain has been configured correctly. In this example we will assume...

    • Type: Article
    • Author: Joel Lipman
    • Category: eCommerce Systems
    • Language: *

  7. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    SSIS/BIDS only supporting assemblies compiled with .Net 3.5 Take it to the GAC Run a command prompt as Administrator Change working directory to location of GACUtil CD C:\Program Files\Microsoft SDKs\Windows\v7.0A\bin Run the GAC and add the DLL gacutil...

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

  8. Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/component/content/article/room-availability-calendar-in-business-intelligence-development-studio.html?catid=75&Itemid=165

    and undefined number of rooms in the rows. No all I was looking for was a calendar showing 1 day with the hours on the top. Working hours only as well... Ok I admit I only googled for about 1 hour before I gave up and just wrote my own. Saying that it's...

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

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

    you'll note that everyone seems to be recommending using a cursor. 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...

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

  10. Formatting a date in an MDX queryhttps://www.joellipman.com/articles/else/database/t-sql/formatting-a-date-in-an-mdx-query.html

    01/01/2011 01:00:00] with "=Today()" [yields: 01/01/2011] and this did the trick. English Ordinal Suffix in T-SQL for MDX Working in the UK my bosses like the English Ordinal Suffix. I haven't seen this anywhere in Google, I thought I could use SWITCH...

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

  11. Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/data-randomization-function-in-oracle-plsql.html

    data that is absolutely irrelevant to the original data but the same length and the same type of data. Why? The joy of working with the plethora of applications out there result in me using MySQL, Oracle PL/SQL and Transact SQL in my day job. The...

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

  12. Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    click on "Test Connection" Expand the data connection you just made and expand "Tables" just to see if the connection is working properly. Create the Data Source Still within Business Intelligence Development Studio (BIDS) Right-click on "Shared Data...

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

  13. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    query returns individual items while Excel allows drag and drop grouping/drilldown pivot tables. Have managed to get this working with SQL Server, Oracle and MySQL databases... Now how to include parameters in non Microsoft technology. Limitations of...

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

  14. Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=105&Itemid=165

    Uploaded: Wed, 3rd Aug 2011 1.5.1 - Removed the word "Hits" from popup and inline - Re-uploaded because RokDownloads isn't working properly (again...) - Date Uploaded: Mon, 1st Aug 2011 1.5 - Upgraded v1.4.3 for use with Joomla 1.6.x+ websites -...

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

  15. Joes WebGL Experimenthttps://www.joellipman.com/component/content/article/joes-webgl-experiment.html?catid=53&Itemid=165

    Limitations Does not work in MS Internet Explorer Is not working on iOS and certain smartphones Advantages No copyright, watermarks and as configurable as revolvermaps Can feed any list of latitude/longitude. Working on... Image Switch and color...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *

  16. MySQL day of week ending on Fridayhttps://www.joellipman.com/articles/else/database/mysql/mysql-day-of-week-ending-on-friday.html

    Sunday. The solution below is for the opposite, where the week starts on the previous Saturday and ends on the last working day of the week. The Solution Where "givenDate" is the given date you have to calculate the last working day of: -- SAMPLE DATES...

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

  17. Thank You for your donation!https://www.joellipman.com/component/content/article/thank-you-for-your-donation.html?catid=45&Itemid=165

    any Joomla! material but has many Content Management Systems (CMS) commercial equivalents. I use any donations to justify working on Joomla! specifically; but like to add things I learn along the way :c) Kind Regards, Joel Lipman

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

  18. Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/component/content/article/add-image-mouseover-effect-in-autohotkey-gui.html?catid=48&Itemid=165

    just a slight modification to the mousemove tooltip in the autohotkey manual. The following code is not the whole code or a working program but should demonstrate how to include it in your own Autohotkey GUI: ; SET TOOLTIP TEXT SearchButton_TT:="Search"...

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

  19. Licence GNU/GPLhttps://www.joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    or, in the case of interfaces specified for a particular programming language, one that is widely used among developers working in that language. The “System Libraries” of an executable work include anything, other than the work as a whole, that (a) is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *

  20. Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=53&Itemid=165

    any of your details with other members (in fact do the opposite of a social network - joellipman.com is not a social networking site). I don't have a newsletter so it's unlikely you'll ever hear from my site. I never email for personal details,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
Results 21 - 40 of 120