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

  1. Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-receive-ebay-order-notifications-via-webhook.html

    these 2 functions beforehand, as there isn't much time between getting the Session ID, logging in, agreeing, and then running the second function to get the FetchToken. So first, I need a function to get me a Session ID. Once I've used this and signed...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  2. Zoho CRM: Upload a Product Photo using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-upload-a-product-photo-using-deluge.html

    to file (this is important) r_CreatorPhoto.setParamName("file"); // // upload the photo to CRM (and prevent workflows from running) v_Endpoint2 = "https://www.zohoapis.com/crm/v2/Products/" + v_CrmProductID + "/photo?restrict_triggers=workflow";...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

    Another article on something I learned today despite never running into this issue before; but sending a billing/shipping address included in a request to create or update an estimate in ZohoBooks will fail... Why? I have a function to push a ZohoCRM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  4. PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/cms/website-development/php/php-script-make-your-own-thumbnail-generator-via-api.html

    to limit users so I don't blame them. But if you can, why not make your own? How? So you will need a webserver of your own running PHP 8. The following PHP script was only tested using PHP version 8.x so I can't say whether it will work for previous...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  5. Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

    to articles from your Joomla 2.5 site (no changes to article IDs but backup your original database (J1.5) anyway before running the following): UPDATE my_joomla_1_5_db.my_1_5_db_prefix_content j1a, -- Joomla 1.5.x Content...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  6. Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

    building a Joomla component which is to be compatible with Joomla versions 1.6.x to 2.5.x. Because I use dynamic scripts running in the background (mootools), some of these need to connect to the database but as they sit outside of the MVC structure, we...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  7. Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

    most people's examples across the web. All I wanted was a basic example to show me how to send a form asynchronously (ie. running in the background without loading a new page). How? This form is more AJ than AJAX as I don't even use an XML file. You'll...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  8. Battery Constantly Drained on iPhonehttps://www.joellipman.com/component/content/article/battery-constantly-drained-on-iphone.html?catid=60&Itemid=165

    friend reported her phone was constantly being drained, wasn't lasting the day on a full charge and knew how to close apps running in the background (double-click "home" button and hold down app until red minus buttons appear, tap red button)... I...

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

    to: Android Studio (Beta) 0.8.6 Google Android Maps API What? I am writing an app for a tablet running Android and wanted to include a Google Map. The following exercise focuses solely on creating an app which opens Google Maps at your current location....

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  10. SSIS Convert a string into a datehttps://www.joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. -- often when processing a datasource, the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  11. SSRS External Images don't displayhttps://www.joellipman.com/component/content/article/ssrs-external-images-dont-display.html?catid=75&Itemid=165

    Windows XP Workstation Business Intelligence Development Studio 2008 (BIDS) SQL Server 2008 R2 Reporting Server (SSRS) running on Windows Server 2003 Team Foundation Server 2010 (TFS) Problem #1: Image does not appear within SSRS When previewing the...

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

    the connection string (which the system account can use). Set "Connect Using" to "Credentials supplied by the user running the report". Browse to your report or upload it if it does not exist. Hover the mouse cursor over it and click on the dropdown...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  13. Hide a Drive per User in Windows 7https://www.joellipman.com/component/content/article/hide-a-drive-per-user-in-windows-7.html?catid=80&Itemid=165

    3ffffff Log off and log on, or restart the computer to apply changes. Important! The above only applies to the user you are running Regedit as! (So if logged in as Admin, this hides it from the Admin, but not from the Guest account) To only restrict...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  14. Apple Magic Trackpad with Windows 11 Intelhttps://www.joellipman.com/component/content/article/apple-magic-trackpad-with-windows-11-intel.html?catid=80&Itemid=165

    for my keyboard (which was a Logitech keyboard for Windows - keys switched for the Mac but reverted for the biscuit box). Running MS Windows 11 pro already. Wifi was ok to connect and my Microsoft Office apps, well it's a Windows box so no issues there...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  15. Search a database for a value and count matching rowshttps://www.joellipman.com/articles/else/database/search-a-database-for-a-value-and-count-matching-rows.html

    END Issues Consider adding a drop of the temporary table to the start of this script if you plan on running this successively against several databases: DROP TABLE #CountRecordsPerTablePerCol or equally IF...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  16. DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/else/database/t-sql/data-shuffling-function.html

    for our purposes. NOTE that the following has only ever been run on development environments and I would not recommend running this on a production system as I have not tested the performance and database load. Before: StudentID StudentName DateOfBirth...

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

    2000-02-18 002 1.00 2000-02-19 002 1.00 2000-02-20 003 1.00 1999-02-25 003 1.00 1999-02-26 Some thing(s) to consider: User running the SQL query needs permission to read the master database. If run by a service account, ask a DBA to emulate the user for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  18. 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

    the customer...) and then others not. The What I'm going to run these benchmark tests against a system that is both up and running via the front-end and back-end. It's MediaWiki CMS used by Wikipedia.org and the like. I like queries against this...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  19. Delete related records from multiple tableshttps://www.joellipman.com/articles/else/database/mysql/delete-related-records-from-multiple-tables.html

    >= '2013-02-01 00:00:00' Testing first I should put this at the beginning of the article as it is what you should do before running a DELETE FROM statement but I've added it here as I use it quite often: SELECT s.sessionId, ssf.sessionId, sst.sessionId...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  20. Country Lookup by IP address CSVhttps://www.joellipman.com/articles/else/database/mysql/country-lookup-by-ip-address.html

    Run the SQL script against a test database, Modify the table name to use if necessary. Uncomment the drop statement if running for the second time. Modify the PHP file to use database login credentials, $db_host = "localhost"; // Database host name...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
Results 21 - 40 of 53