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

  1. Zoho Deluge: Check Time Booking Slotshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-check-time-booking-slots.html

    a double-booking (as in, the time slot doesn't overlap a previous booking. How? Given a date/time and a duration, we will work out the requested start and end time: req_StartTime = input.Date_Field; req_Duration = 90; bool_doubleBooked=false; for each...

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

  2. Disable User Registration in Joomla 1.5 - Configuration Filehttps://joellipman.com/articles/cms/joomla/disable-user-registration-in-joomla-1-5-configuration-file.html

    having some corruption issues and simply using the Joomla! administrator panel to navigate to global configuration, does not work! How? It isn't in the configuration.php file prior to Joomla! v1.6.x but in the database. Open the database to the Joomla...

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

  3. SELECT COUNT(DISTINCT name) FROM tablehttps://joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

    my_table) T1; -- Performance Improvement SELECT COUNT(1) 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...

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

  4. $_SERVER['http_referer'] returns blank in Internet Explorerhttps://joellipman.com/component/content/article/serverhttpreferer-returns-blank-in-internet-explorer.html?catid=62&Itemid=165

    was using it as an additional validation check. The only solution is to not use it for verification purposes as it will only work in every other browser except Internet Explorer (more specifically versions 6 and 7...???) For more details:...

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

  5. SSRS Subscriptions cannot be createdhttps://joellipman.com/component/content/article/ssrs-subscriptions-cannot-be-created.html?catid=75&Itemid=165

    (setup in the subscription section). The report being subscribed to is hidden in tile view. Cases where this would NOT work Reports where the connection string to the data source is held in the parameters (though, with more time, we could have tried...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  6. About 5 seconds worth of funhttps://joellipman.com/component/content/article/about-5-seconds-worth-of-fun.html?catid=77&Itemid=165

    Really not work related but if you know your sharepoint site: Custom Error http:///_layouts/MySite.aspx?Error=You%20are%20a%20jerk%20and%20SharePoint%20does%20not%20share%20with%20jerks. Installer? http:///userdisp.aspx=ID=1 Paying attention to the URL...

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

  7. Add "Command prompt from here" to right-click context menuhttps://joellipman.com/component/content/article/add-command-prompt-from-here-to-right-click-context-menu.html?catid=80&Itemid=165

    all my machines (=restore to sorta factory settings), so instead of googling it and going through other websites that work and don't; I thought I might as well post the way I do it: Open up windows explorer Go to Tools -> Folder Options Click on the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  8. MySQL Updating a database table from another tablehttps://joellipman.com/articles/else/database/mysql/mysql-updating-a-database-table-from-another-table.html

    names and I would rather they all use the ccTLD two letter code. This article was written because it took me so long to work it out. How? UPDATE `table_to_update` a INNER JOIN `table_to_read` b ON a.`CountryName` COLLATE utf8_general_ci LIKE...

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

  9. List last modified files using FTP Command-linehttps://joellipman.com/articles/cms/website-development/ftp/list-last-modified-files-using-ftp-command-line.html

    hostname or IP of the server holding my site) Enter login credentials Type dir (lists files & folders in the current remote working directory) Type cd /path/to/my/website to change directory to the root folder containing your website. Type pwd to...

    • Type: Article
    • Author: Joel Lipman
    • Category: File Transfer Protocol
    • Language: *

  10. Mootools - How to contain a menu sidebar between header and footerhttps://joellipman.com/articles/cms/website-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

    lose this note again. The only website that was titled similarly kept slowing down my computer too much so I decided to work out my own. The complexity is due to content also being dynamically resized in height. What? Basically I have a menu in a...

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

  11. Select unique values in Microsoft Excel columnhttps://joellipman.com/component/content/article/select-distinct-values-in-microsoft-excel-column.html?catid=110&Itemid=165

    I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range A3 to...

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

  12. Leap Motion and AR Dronehttps://joellipman.com/component/content/article/leap-motion-and-ar-drone.html?catid=113&Itemid=165

    to finger gestures and it's compatibility with major platforms. The following 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...

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

  13. Calculate Aspect Ratiohttps://joellipman.com/component/content/article/calculate-aspect-ratio.html?catid=115&Itemid=165

    So this is a quick article on how to maintain an aspect ratio when resizing an image. How? These are the calculations to work out the new height given the width or the new width given the height: (original height / original width) x new width = new...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *

  14. The greatest invention in IThttps://joellipman.com/component/content/article/the-greatest-invention-in-it.html?catid=116&Itemid=165

    multi-lingual, future-proof and as everlasting as human error. More? "By [undoing] repeatedly, you can gradually work your way back to a point before your mistake. This is convenient if you've made a mistake four or five commands back. It is marginally...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
Results 161 - 174 of 174