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

  1. MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/else/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

    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) FROM a_pretend_table WHERE a_condition=true ) AS...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  2. Convert Decimal (Person Days) to Time in Excelhttps://www.joellipman.com/component/content/article/convert-decimal-person-days-to-time-in-excel.html?catid=110&Itemid=165

    the results above. The second formula is converting person days into hours and then dividing by 24 (which should return the same decimal number).

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  3. The Sandpithttps://www.joellipman.com/articles/else/graphic-design/the-sandpit.html

    to look smaller than it actually is. As an update Mar 2011, I just watched Gulliver's 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  4. Prices get rounded up in Virtuemarthttps://www.joellipman.com/articles/else/e-commerce/virtuemart/prices-get-rounded-up-in-virtuemart.html

    table (jos_vm_prodcut_price)... Don't do any of these things! After modifying tax rates and ensuring these were all the same, we also found that this was due to a country not being specified under the Store configuration within VirtueMart.

    • Type: Article
    • Author: Joel Lipman
    • Category: Virtuemart
    • Language: *
Results 181 - 184 of 184