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

  1. Outputting PHP files into different file formatshttps://joellipman.com/articles/web-development/php/outputting-php-files-into-different-file-formats.html

    I'm beginning a list as I've just spent an age trying to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to do that instead. PHP to TXT header('Content-Type:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

  2. Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

    Cause 1: Fields in the same column are not aligned with guidelines or snap-togrid To prevent fields from appearing in different rows, horizontally align fields with guidelines: In Design view, click the vertical ruler to create a vertical guideline....

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

  3. Merge the content of two similar tables in MySQLhttps://joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

    this with a UNION ALL clause. Scenario: I have a Joomla module which should take the keywords from a specified number of different but similar tables. I'm looking to query the Title and the Introductions of any valid articles from BOTH tables and return...

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

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

    of data (blank or made of symbols) separates two sets of data from within the same select query based on a column that's different. So for example, I have data like the following: SELECT DATENAME(dw, StartDate) AS 'Day' FROM Timetable ORDER BY StartDate...

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

  5. Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

    along with the object code. If the place to copy the object code is a network server, the Corresponding Source may be on a different server (operated by you or a third party) that supports equivalent copying facilities, provided you maintain clear...

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

  6. Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=40

    These are: 400ft altitude limit Line-of-Sight (LoS) required Stay away from built-up areas Note: There are slightly different regulations for a small unmanned aerial system (less than 20kg) and a small unmanned aerial surveillance system (less than 20kg...

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

  7. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttps://joellipman.com/articles/crm/zoho/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

    What? This is an article to document how to have two submit buttons on a non-stateless form which both submit the form but one leaves the current record open while the other redirects to the reports view. Why? A client wanted a "Save" button on their...

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

  8. Database Error: Unable to connect to the database: Could not connect to MySQLhttps://joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    you with this issue, I'd double-check your website host allows Joomla and if they don't, look for either an upgrade or a different host. If your website has been LIVE for a while and it's returning this error despite having little installed, then check...

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

  9. Windows 7 Aero Featureshttps://joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

    the windows key () and tab () at the same time. It will give you a 3D effect that will allow you to “Flip” between the different windows. Keep holding the Microsoft Logo key and pressing the Tab key to rotate between the different windows. As with...

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

  10. Crystal Reports: Exporting to Excel omits column headershttps://joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

    exporting a report to Excel, and only some of the column headers appear, then try this: I googled this for ages and found different suggestions here and there but none of them produced consistent results. One solution was to untick "Simplify page...

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

  11. Sort order a dropdown list in MS InfoPath without programminghttps://joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

    sort by. Save the view by clicking the OK button. You'll be returned to your datasheet and it's possible it isn't in any different order. I re-checked out my InfoPath form, looked at the dropdown that was already configured to read off the sharepoint...

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

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

    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 mootools libraries to see why the Joomla ones weren't working. It may not be right, it may not be the best or optimized...

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

  13. 301 Redirect using htaccess filehttps://joellipman.com/articles/web-development/301-redirect-using-htaccess-file.html

    the old domain's website Rename it as ".htaccess" (or modify the existing one) Add the code as per below. Save the change. Different ways for different results, let's pretend I'm redirecting from myolddomain.com to mynewdomain.com: RewriteEngine On...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  14. Joes Word Cloud (JWC) Downloadhttps://joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

    Fri, 7th Dec 2012 1.6.8- Enhancement: Integration: Include jEvents. - Bug Fix: Inclusion List now displays words in different sizes. - Date Uploaded: Thu, 27th Oct 2011 1.6.7.1- Minor fixes for previous release - Date Uploaded: Mon, 8th Aug 2011 1.6.7-...

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

  15. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

    generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is very different to my code for OAuth when attended: Google Authentication - OAuth 2.0 using PHP/cURL... In that this one doesn't prompt...

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

  16. CSS Add Text to Breadcrumb Link with a Transitionhttps://joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

    a word which is fully opaque */ ul.breadcrumb a:hover span:before { opacity:1; content: 'More '; } /* Same as above but different prefix for this particular link */ ul.breadcrumb a.home:hover span:before { opacity:1; content: 'Return to '; } /* Add the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *

  17. Zoho Deluge: Setup an API Connection for InvokeURLhttps://joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

    This is slightly different to my article Zoho Deluge: Get Refresh/Access Token API v2 (Zoho to Zoho service) and different to my Zoho CRM: APIv2 using PHP & cURL (3rd-Party to Zoho), in that this details how to setup a connection to use in an invoke URL...

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

  18. Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

    of the record that I want to monitor. An eTag for me is simply an MD5 or hash of a bunch of data. If your MD5 value is different, then it means there was a change. If not then it is unlikely that any change was made. Instead, I need to add an additional...

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

  19. Zoho Books: Display Sales Order Shipping Address on Package Sliphttps://joellipman.com/articles/crm/zoho/zoho-books-display-sales-order-shipping-address-on-package-slip.html

    Order: BILLING ADDRESS SHIPPING ADDRESS ------------------- ------------------- Test Company Joels PO Box 1 Test Street 1 Different Street Test City Another City Test State Test Zip Another State Another PostCode Test Country A different Country But the...

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

  20. ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

    // // get the xero ID of the record (hexadecimal) v_Xero_ResourceID = r_Event.get("resourceId"); // // do different things based on the category of the update if(r_Event.get("eventCategory").containsIgnoreCase("CONTACT")) { // get contact record from...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 1 - 20 of 94

Joes Word Cloud

Please publish modules in offcanvas position.