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

  1. Zoho Deluge: Determine if Daylight Savings are in effecthttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

    that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait about 4 months until I can confirm this works. Why? I've covered this before in a fair few articles on this website but for clients in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    r2."End Date" AS "Response Date", CASE p."Title" WHEN 'DEMOGRAPHICS' THEN 2 WHEN 'AWARENESS' THEN 3 WHEN 'ENGAGEMENT' THEN 4 WHEN 'SATISFACTION & FEEDBACK' THEN 5 WHEN 'USABILITY' THEN 6 WHEN 'FEATURES' THEN 7 WHEN 'PRICING' THEN 8 WHEN 'SUPPORT'...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  3. Uninstalling AEC Central and installing Community Builderhttps://www.joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

    Go to your admin panel (back-end) 2. Extensions > Plugin Manager 3. Go to the bottom and change the display # dropdown to ALL 4. Disable Authentication - AEC Access 5. Enable Authentication - Joomla 6. Re-enable any other authentication plugin you used...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  4. ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

    note the Publisher's key (eg. "c518c95f01312c9ac97ace9ace199ace0c38d9d") On the dashboard, note the Scoring key (eg. "64d6d442b7e846acfaacef642e1ad173b35503") On the dashboard, check the site URL matches the domain you are trying this on (eg. if you are...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  5. ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

    note the Publisher's key (eg. "c518c95f01312c9ac97ace9ace199ace0c38d9d") On the dashboard, note the Scoring key (eg. "64d6d442b7e846acfaacef642e1ad173b35503") On the dashboard, check the site URL matches the domain you are trying this on (eg. if you are...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  6. Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/component/content/article/green-red-background-colors-based-on-dataset-values.html?catid=75&Itemid=165

    I've recently written a report for SQL Server Reporting Services 2008 R2 (SSRS) which will compare up to 4 reports and will compare the time taken for each one. The breakdown or what I was able to measure with the default installation are the times...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  7. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    as you would for any usual SSRS report. (Ignore my 2nd and 3rd SSRS parameters in my example as I didn't end up using them) 4. Add a dataset Follow these steps carefully. I've added some screenshot images to help and highlighted areas which you should...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  8. Hide a Drive per User in Windows 7https://www.joellipman.com/component/content/article/hide-a-drive-per-user-in-windows-7.html?catid=80&Itemid=165

    To Restrict B & C, enter 6 decimal -- " " E & G, enter 80 decimal or 50 hexadecimal Drive Letter Decimal Hex A 1 1 B 2 2 C 4 4 D 8 8 E 16 10 F 32 20 G 64 40 H 128 80 I 256 100 J 512 200 K 1024 400 L 2048 800 M 4096 1000 N 8192 2000 O 16384 4000 P 32768...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  9. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    in row (along the side)......staff in columns (along the top)......persondays in values (the number my bosses want - 7h 24m or 26640s is 1 person day)... With date range as parameters...ouch......and it was so easy up to here... Tables of interest...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  10. MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/else/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

    --------- Me 09:00 07:30 08:00 07:00 06:00 00:00 02:00 36:00 Myself 07:30 07:30 07:30 07:30 07:00 00:00 00:00 37:00 I 03:45 03:30 03:00 03:30 00:00 00:00 00:00 23:00 Method 1. Generate query to list all valid users 2. Generate query which will total...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  11. MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/else/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

    ( SELECT a.N + b.N * 10 + 1 n FROM (SELECT 0 AS N UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) a ,(SELECT 0 AS N UNION ALL...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  12. Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/cms/website-development/php/using-a-html-form-and-php-to-upload-a-file.html

    input type MAX_FILE_SIZE which is ignored by more recent browsers. If you need more, you need to edit your PHP.ini file. 4. Test your PHP file can process the data Add the following code to the receiving PHP file: echo "Upload: "....

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  13. Sun-Dried Tomato Basil Couscous Recipehttps://www.joellipman.com/component/content/article/sun-dried-tomato-basil-couscous-recipe.html?catid=96&Itemid=165

    at room temperature. Use store-bought vinaigrette or make your own. Prep Time: 10 minutes Cook Time: 5 minutes Ingredients: 1/4 teaspoon dried garlic powder 1 package (10 ounces) plain couscous 1/2 cup sun-dried tomatoes (preferably oil-packed), drained...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  14. How To Make Chocolate Chip Cookieshttps://www.joellipman.com/component/content/article/how-to-make-chocolate-chip-cookies.html?catid=96&Itemid=165

    onto an parchment paper-lined cookie sheet. Leave about 2 inches between cookies - 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  15. Security Checklistshttps://www.joellipman.com/articles/cms/joomla/security-checklists.html

    the gist of http://docs.joomla.org/Security_Checkli … omla_Setup is as follows: Security Checklist 4 - Joomla Setup 1. Install official versions of Joomla 2. Change the default administrator username 3. Protect directories and files 4. Adjust file and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  16. Cranberry flapjackhttps://www.joellipman.com/component/content/article/cranberry-flapjack.html?catid=96&Itemid=165

    Ingredients 100g/3½oz oats 3 tbsp honey 50g/1¾oz self-raising flour 1 free-range egg 4 tbsp dried cranberries 5 tbsp butter For the caramel sauce 50g/1¾oz butter 50g/1¾oz caster sugar 50ml/1¾fl oz double cream 1 orange, peeled and segmented Method 1....

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  17. COVID-19: Working from Homehttps://www.joellipman.com/component/content/article/covid-19-work-from-home.html?catid=45&Itemid=165

    during 2020 but then a virus capable of locking down the world manifested itself. I thought this would be temporary but after 4 months of slouching over the coffee table, my back is suffering terribly. I figured on a personal DSE assessment and setup my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  18. Autohotkey Count Number of Files/Folders in a Directoryhttps://www.joellipman.com/component/content/article/autohotkey-count-number-of-files-folders-in-a-directory.html?catid=48&Itemid=165

    usage: SC_Load("C:\*.*", 1) MsgBox, TotalFiles %SC_TotalFiles% -- yields number of files in a directory recursively. Method #4: FileSystemObject ComObjCreate -- usage (see functions below) TotalFileCount := CountFilesRecursive( "C:\" ) MsgBox,...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  19. AutoHotkey: Check Windows Folder Sizeshttps://www.joellipman.com/component/content/article/autohotkey-check-windows-folder-sizes.html?catid=48&Itemid=165

    ; Create GUI Gui, New, %Options%, %Title% Gui, Color, %BgColor% Gui, Margin, %MarginX%, %MarginY% Gui, Add, Edit, x2 y2 w406 vMyBaseDir +Disabled, %BaseDir% Gui, Add, Button, x408 y1 w90 h23 vMyButtonBrowse gButtonBrowse, Browse... Gui, Add, TreeView,...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  20. AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/component/content/article/autohotkey-app-gui-listview-to-rename-files.html?catid=48&Itemid=165

    file name if a file with the same name exists." Version := "1.1" Width := 600 Height := 600 BgColor := "EEEEEE" FgColor := "34495E" Options := "+Caption +Border +OwnDialogs" DefltDir:= A_ScriptDir ;...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
Results 41 - 60 of 113