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

  1. Zoho Deluge - Get User Timezone, Country and Locationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-user-timezone-country-and-location.html

    "Europe", "countryCode": "GB", "countryName": "United Kingdom", "stateProv": "England", "city": "Birmingham (Edgbaston)" } A more comprehensive alternative [Limit 150 per minute | not for commercial use]: v_Url = "http://ip-api.com/json/"+...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  2. Hide Menu Item from Registered and Special https://www.joellipman.com/articles/cms/joomla/hide-menu-item-from-registered-and-special.html

    show when the visitor is not logged in e.g. Code: Joomla extension disable menu link for registered users but not for public More Information: not so great, lot of text: http://help.joomla.org/content/view/476/146/

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

    FROM (SELECT DISTINCT my_field FROM my_table) T1; Ones that didn't work for me: Method #3: By grouping (NOT recommended for more complex queries): SELECT COUNT(my_field) FROM my_table GROUP BY my_field; Additional: Not sure why method 3 is an accepted...

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

    Click on 'Edit HTML' Look for the beginning tag Insert the code above just after the tag Click on 'Save' and you're done More Information: http://code.google.com/chrome/chromeframe/

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  5. Migrate MediaWiki to another serverhttps://www.joellipman.com/articles/cms/mediawiki/migrate-mediawiki-to-another-server.html

    copy all the new files to wiki folder and then run php update.php from maintenance folder after updating AdminSettings.php More Information http://www.mediawiki.org/wiki/Manual:Moving_a_wiki

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  6. Two icons created on Androidhttps://www.joellipman.com/articles/else/app-dev/android-os/two-icons-created-on-android.html

    until I found it on the a forum: Stack Overflow: Android App Development. How? Basically don't have the following declared more than once in the AndroidManifest.xml

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  7. MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/else/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

    1 Me,Myself,I Note that the following queries include the nested version because I find myself needing to group concatenate more often from another table then using data from the same table. MySQL SELECT ( SELECT GROUP_CONCAT(column_to_return_as_string)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  8. MySQL day of week ending on Fridayhttps://www.joellipman.com/articles/else/database/mysql/mysql-day-of-week-ending-on-friday.html

    Week Ending Date has been requested a lot more frequently now. It's an odd one but the example below shows how to do this for when the week ends on Friday. Assuming it starts on the previous Saturday. Why? Problems with MySQL weeks always starting on...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  9. Code Troubleshooting Checklisthttps://www.joellipman.com/articles/cms/website-development/code-troubleshooting-checklist.html

    I've started this list to make sure I don't spend so long anymore on debugging code. The aim of this article is to quickly suggest ways of pinpointing the source of the problem: In a database/web environment, have you? Commented out lines that you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  10. Ordered List of over 1000 Itemshttps://www.joellipman.com/articles/cms/website-development/css/ordered-list-of-over-1000-items.html

    What? So many people asking this when the solution is a bit of aesthetic styling. ol{margin:4px} -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item Ordered List Maximum

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  11. PHP: First name and Initial of Surnamehttps://www.joellipman.com/articles/cms/website-development/php/php-first-name-and-initial-of-surname.html

    '.strtoupper($author_names[1][0]).'.'; } } // output echo $author_name_disp; And a little more: // default $author_name_disp=$author_name; // check and transform foreach(array(' ', '.') as $delimiter) { if (strpos($author_name, $delimiter)!==false) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  12. Peanut Butter Milkshake Recipehttps://www.joellipman.com/component/content/article/peanut-butter-milkshake-recipe.html?catid=96&Itemid=165

    pour into blender, and add the vanilla and peanut butter. Whirl for 1 minute; add 2 scoops ice cream, then whirl 1 minute more. Servings: 1 Source: http://www.recipes-4u.co.uk/drink/Peanut-Butter-Milkshake.html

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  13. Select unique values in Microsoft Excel columnhttps://www.joellipman.com/component/content/article/select-distinct-values-in-microsoft-excel-column.html?catid=110&Itemid=165

    to do this to. Click on the "Data" tab. Click on "Advanced" (Advanced Filter). Tick the "Unique records only" box. A few more from Microsoft Office Help /* Count the number of unique number values in cells A2:A10, but do not count blank cells or text...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  14. Leap Motion and AR Dronehttps://www.joellipman.com/component/content/article/leap-motion-and-ar-drone.html?catid=113&Itemid=165

    videos were shown to me by a colleague at work. I was so impressed I just had to post them. So here's a screenshot, read more if you want the videos: So Leap in Motion AR Drone: {youtube}ZOdxlrQj_ZU{/youtube} Just as amazing but old news:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Quadcopters
    • Language: *
  15. The Sandpithttps://www.joellipman.com/component/content/article/the-sandpit.html?catid=115&Itemid=165

    Travels (2010) and it looks like the same effect for the intro credits :c) This is "a day in the life of New York City". More Information can be found at http://aerofilm.blogspot.com/2010/02/sandpit-short-film-by-aero-director-sam.html Personally I can...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
Results 201 - 215 of 215