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

  1. ZohoCRM & Xero: Function to pull most recent quoteshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    unsigned 19 digit integer) but that's more use when writing to Zoho Books. Within ZohoCRM, we only need the name and in this case the percentage rate: string standalone.fn_Xero_MapTaxRates() { /*...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Installing phpBB3 for Joomla with a RocketTheme templatehttps://joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    here so that I can I do this on other websites: Important Note: On Linux (Apache), all file names and folder names are case-sensitive, so phpbb3 is NOT the same as phpBB3. Bear this in mind during the installation process. Before we begin: I have to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  3. Change default order of weblinkshttps://joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

    the following comment and text. As always, I would recommend you make a copy of the file before making the change just in case you need to revert the change: // We need to get a list of all weblinks in the given category $query = 'SELECT *' . ' FROM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  4. Creating a Profile Plugin for Joomla 1.6https://joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

    ./profile5 ./profile5/profiles Also copy one of those handy blank "index.html" files into each of these folders in case "directory listing" gets enabled on your server.I'm going to refer to the files to create as being in this folder....

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. Could not instantiate mail functionhttps://joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

    770 username:mail /var/spool/virtual/domain.com/* 660 username:mail 8) Ensure your hostname does not contain any upper case letters. 9) Make sure that your main server IP has a reverse lookup on it.

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

    date, isgood, ispoor, published, subscribe, source, source_id, checked_out, checked_out_time, editor ) SELECT id, parent, CASE WHEN SUBSTRING(path, LOCATE(',', path)+1, LOCATE(',', path, 2))='' THEN 0 ELSE SUBSTRING(path, LOCATE(',', path)+1,...

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

    is more AJ than AJAX as I don't even use an XML file. You'll need to create a receiving file that sends back the data, in my case, I've called it ajax.form.php and the contents of which are: This just prints back an array of data that was sent to it;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  8. ReCaptcha disappears from Joomla 2.5 Registrationhttps://joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

    your public key return ' window.onload = function() { Recaptcha.focus_response_field(); } '; } Additional This applies to a case where the code WAS working and without any changes to the server (no updates), and the recaptcha simply stopped displaying....

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  9. Registered Users Cannot Login - Super Users Canhttps://joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

    able to login. Was the problem authentication? Restricted access to a component? A load of blab on ACL managers? How? In our case, the website had recently been migrated from Joomla 1.5.x to 2.5.x. I asked to examine the database and a quick scan in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  10. Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    refer to how the weblinks categories are added. Copy over Content: We want to maintain the same IDs for articles in case SEO settings will be enabled and the ID is in the URL. We will insert assets as new ones but associate these to the v25 assets....

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  11. Protecting your Joomla Administrator Sectionhttps://joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

    you have a static IP (most ISPs now assign static IPs to home broadband users as well as larger corporations). But just in case you don't have one, let me do this in two stages. Move the /administrator URL Create a folder in the root of your joomla...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  12. Importing Joomla articles to WordPress postshttps://joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

    created 'post_date_gmt', CONCAT(introtext, ' ', `fulltext`) 'post_content', title 'post_title', '' post_excerpt, CASE state WHEN '1' THEN 'publish' ELSE 'draft' END 'post_status', 'open' comment_status, 'open' ping_status, '' post_password, alias...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  13. Migrate Joomla Users to WordPresshttps://joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

    a.email AS 'user_email', ' ' AS 'user_url', a.registerDate AS 'user_registered', ' ' AS 'user_activation_key', CASE a.block WHEN 0 THEN 2 ELSE 0 END AS 'user_status', -- NOTE THAT THIS IS DEPRECATED IN WORDPRESS 3.X a.name AS 'display_name' FROM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  14. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    hour'); $api['jwt']['claim_set']['iat'] = strtotime('now'); And finally the JWT signature (or assertion in this case resulting as a combination of the header, data and signature): Using the JWT header, and claim set above, along with the private key,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  15. Setting up your store to use SSLhttps://joellipman.com/articles/else/e-commerce/setting-up-your-store-to-use-ssl.html

    to resolve the issue. If you have shared SSL your hosting company should have given you your secure URL which in most cases will be a domain with folder allocated to you. e.g. https://secure.example.com/username By going to the address given by your...

    • Type: Article
    • Author: Joel Lipman
    • Category: eCommerce Systems
    • Language: *
  16. Basic Android App using Google Maps and Current Locationhttps://joellipman.com/articles/else/app-dev/android-os/basic-android-app-using-google-maps-and-current-location.html

    Creates a CameraPosition from the builder map.animateCamera(CameraUpdateFactory.newCameraPosition(cameraPosition)); Just in case: AndroidManifest.xml The example above should have populated this correctly but if you are still getting problems, I have...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  17. Android: Function to let user take photo or choose existinghttps://joellipman.com/articles/else/app-dev/android-os/android-function-to-let-user-take-photo-or-choose-existing.html

    findViewById(R.id.hangar_aircraft_photo); myPhotoImage.setImageBitmap(BitmapFactory.decodeFile(picturePath)); } } Just in case The ImageView I have (minus the width, height, margins, etc): Additional To check if the user has a camera beforehand,...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  18. Android OS: Add GoogleMap as fragmenthttps://joellipman.com/articles/else/app-dev/android-os/android-os-add-googlemap-as-fragment.html

    change my previous example so that the homepage of the app (the starting page) will simply display a button to the map (in case of offline mode or incompatibility with the device). How? In this example, I'm going to add the map as a fragment. This is...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  19. SSIS Skip Blank Rows in Flat File Sourcehttps://joellipman.com/component/content/article/ssis-skip-blank-rows-in-flat-file-source.html?catid=74&Itemid=165

    rows amongst the data. The easy fix is by dealing with any empty rows. The best way I've seen that has worked in nearly all cases, is to use the "conditional split" task and test one of the columns for a length of greater than 1: Almost! A problem not...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  20. SSIS Multiple Lookups in onehttps://joellipman.com/component/content/article/ssis-multiple-lookups-in-one.html?catid=74&Itemid=165

    Changing the lookup to "use results of an SQL query": Which would code with the joined tables as follows (note that in our case we needed the lookups on the source database which was not the same as our staging one which this package gets as its...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
Results 81 - 100 of 143