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

  1. How To Make Chocolate Chip Cookieshttps://www.joellipman.com/component/content/article/how-to-make-chocolate-chip-cookies.html?catid=96&Itemid=165

    - they'll spread out when they bake. Step 4: Bake Bake your cookies about 8-10 minutes, until they're golden brown, but still soft in the centers. Let them cool on the pan for a minute, and then move them to a cooling rack. This recipe makes about 4...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  2. MS Excel - Sort pivottable column headings by datehttps://www.joellipman.com/component/content/article/sort-pivottable-column-headings-by-date.html?catid=110&Itemid=165

    tell me that "10" comes before "8" and it does but just to check, let me pad the 8 with the prefixing zero: Annoyingly "10" still comes before "08" so maybe I'm barking up the wrong tree. If I padded with one more zero so that "008" is before "010":...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  3. MS Excel: Convert a text to a numberhttps://www.joellipman.com/component/content/article/ms-excel-convert-a-text-to-a-number.html?catid=110&Itemid=165

    solution Include the space (if there is one) in the substitute formula: =SUBSTITUTE(B3, " ₱", "") The resulting value will still need to be multiplied by 1 to convert to a number but what a palava!

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  4. GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/component/content/article/godaddy-apache-cpanel-install-ssl-certificate.html?catid=111&Itemid=165

    this who said it would take about 6 hours to 2 days to take effect. Not sure what was supposed to happen but 2 days later it still wasn't working. I followed the process above and it took immediate effect... Update 2024 So I've run into the issue that...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *
  5. DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://www.joellipman.com/component/content/article/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html?catid=113&Itemid=165

    masked these before painting as per youtube videos) Possibly my new facebook profile photo My old FC40 looking new(ish) Ok, still going with painting on a budget, yes those are permanent marker color-ins the chipped smaller propeller is stock Less on a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Quadcopters
    • Language: *
  6. Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/component/content/article/is-it-a-scam-gumtreecoms-warning-signs.html?catid=116&Itemid=165

    This list used to be on Gumtree's website but I can't find it anymore. This is quite a thorough list though it still needs some work. Requests to use money transfer services like Western Union or MoneyGram. These services are not meant for transactions...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  7. Zoho CRM: Update Opportunity Type as New or Existing Businesshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-update-opportunity-type-as-new-or-existing-business.html

    info r_UpdateOpp; } else { info "This is the first complete sales order so the opportunity type here is still 'New Business'."; } } else { info "This Sales Order is not considered complete so it will not update the opportunity."; } } Additional Notes:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. SELECT COUNT(DISTINCT name) FROM tablehttps://www.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

    as soon as I put a WHERE clause in the statements and check the numbers, only method 1 and 2 return the correct number. I'm still unsure as to why WHERE...GROUP BY... doesn't return the same totals and will update this article when I figure it out.

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  9. Joomla CMS: Register to Read Morehttps://www.joellipman.com/articles/cms/joomla/joomla-cms-register-to-read-more.html

    not include the search engine. I need the Joomla built-in search engine to also ignore permissions so that the article can still be indexed in global search engines such as Google. How? It's been difficult to search for the right words but heres the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  10. Does Google Chrome Frame really improve performancehttps://www.joellipman.com/component/content/article/does-google-chrome-frame-really-improve-performance.html?catid=61&Itemid=165

    The jury's still out on this one. I have noticed a slight improvement in my page loads but will have to carry out proper tests on the weekend. Instructions to a hard-coder The Google Chrome Frame (or ChromiumBrowser) is quick to enable. Simply ask your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  11. Free Translator API using Googlehttps://www.joellipman.com/component/content/article/free-translator-api-using-google.html?catid=61&Itemid=165

    to offer free services but in the small print, you will find they too charge the same price. How? The Google Translate API still actually exists. Just don't try to exceed your free quota: Visit http://translate.google.com/manager/website Sign in using...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  12. Reminder on SSRS row separatorhttps://www.joellipman.com/component/content/article/reminder-on-ssrs-row-seperator.html?catid=75&Itemid=165

    "Group1") by clicking the grey part above it Delete this column. Check that the grouping grey part (a giant parenthesis) is still there. Right-click on the grey header of the tablix row again (left-most grey part) Select "Insert Row" and I selected...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  13. Regular Expressions in SQLhttps://www.joellipman.com/articles/else/database/regular-expressions-in-sql.html

    or number -- eg. O'Brien will NOT be returned as it contains letters MySQL And my favorite. Note the circumflex as we are still excluding non-alphanumeric rows. SELECT * FROM Students WHERE studentSurname REGEXP '[^a-zA-Z0-9]'; or SELECT * FROM Students...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  14. Search and Replace in a MySQL Databasehttps://www.joellipman.com/articles/else/database/mysql/search-and-replace-in-a-mysql-database.html

    done no matter what. If you've ever sat there with phpMyAdmin or a MySQL Administration Tool (like Navicat or SQLYog), and still there at night editing each field so that it displays correctly... well that's usually me. Found it a bit boring but here's...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  15. Mootools - How to contain a menu sidebar between header and footerhttps://www.joellipman.com/articles/cms/website-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

    = '5px'; } } else { $('jdo_actions').style.position = 'relative'; $('jdo_actions').style.top = '0px'; } } }); // still to do: smoothscroll? if already overlaps then flicks up

    • Type: Article
    • Author: Joel Lipman
    • Category: MooTools Framework
    • Language: en-GB
  16. Can't play music after Firmware Update Version 3.0https://www.joellipman.com/component/content/article/cant-play-music-after-firmware-update-version-30.html?catid=116&Itemid=165

    multi-audio output then you can play music again. What a bummer you can't play music and use anything else anymore. I can still play some games and select my own music... but they're dumbass PSN games that iPhone users would have got for a pound or what...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
Results 81 - 96 of 96