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

  1. Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    ' union all ' + @SqlToExecute; FETCH NEXT FROM MyCursor INTO @SqlToExecute END CLOSE MyCursor DEALLOCATE MyCursor T-SQL Source: http://gallery.technet.microsoft.com/scriptcenter/c0c57332-8624-48c0-b4c3-5b31fe641c58 - Sorna Kumar IF...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  2. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    to open... Excel 2007 SP2...with ODBC to... MySQL v5+...hosting database... ActivityLog...contains activity, staffID, resourceID, start time, end time... Report Specification PivotTable Report...resources in row (along the side)......staff in...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  3. Project Plan for Freelance Websitehttps://www.joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    For you to discuss: Aims / Objectives Deadlines / Milestones Target Audience (Internally Centered? / Customer Focused?) Outsources? (Is JoelLipman.Com Project Manager? other 3rd-parties?) Contacts within Client company? Budget (see Rates for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  4. Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/cms/website-development/regular-expression-basic-usage-examples.html

    preceding character or subexpression. You can think of this operator as specifying an expression that is optional in the source text. For example, to find--'a', optionally followed by 'b', then followed by 'c'--you use the following regular expression:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  5. Counting the occurence of a word within a string: Benchmarkhttps://www.joellipman.com/articles/cms/website-development/php/counting-the-occurence-of-a-word-within-a-string-benchmark.html

    out a benchmark test on the most popular ways of counting the occurrence of a specific word within a string of text. Source: http://hasin.wordpress.com/2007/04/30/c … functions And the result is First Run Count by Split+Count took : 0.44112181663513...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  6. Making a CD copy with only one drivehttps://www.joellipman.com/component/content/article/making-a-cd-copy-with-only-one-drive.html?catid=80&Itemid=165

    the drive Open Easy CD Creator From the dialog box, select CD COPIER Read the copyright notice and click on OK Select the SOURCE AND DESTINATION tab Verify that both COPY FROM and RECORD are the same drives Select the ADVANCED tab Check that COPY SOURCE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  7. Php convert filesizes to bytes kb mb gbhttps://www.joellipman.com/articles/cms/website-development/php/php-convert-filesizes-to-bytes-kb-mb-gb.html

    12945 bytes : displays as => "12 Kb" 1478515 bytes : displays as => "1 Mb" 8798745455 bytes : displays as => "8 Gb" How? Source: PHP Share: http://www.phpshare.org function formatSizeUnits($bytes) { if ($bytes >= 1073741824) { $bytes =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  8. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/component/content/article/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html?catid=45&Itemid=165

    too much, they would go right through the gaps resulting in the fans falling... But the crystal looks nice. Link(s) / Source(s): Microsoft Store: Intel® Graphics Command Center YouTube - JayzTwoCents - This might be the best small ATX case... PERIOD!...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  9. AHK Countdown Tooltiphttps://www.joellipman.com/component/content/article/ahk-countdown-tooltip.html?catid=48&Itemid=165

    version 0.4 Beta (unofficial app). Why? Something to do... How? The following code is using AutoHotkey (AutoIt) and is the source code as compiling it wouldn't be much use to anyone else unless they work for the same company and they're leaving on the...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  10. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/component/content/article/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html?catid=48&Itemid=165

    "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe" --profile-directory="Profile 11" "https://duckduckgo.com" Source(s): How to make Mail app open automatically upon windows start How To Create A Windows Shortcut To Open A Specific Chrome...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  11. AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/component/content/article/autohotkey-get-media-information-and-display.html?catid=48&Itemid=165

    Usage ------------- v_My100NsUnits := 9858250000 v_DisplayHMS := Convert100nsToHMS( v_My100NsUnits ) ; yields 00:16:25 Source(s): Microsoft - Windows Properties - Win32 Apps AutoHotkey - Filexpro() Google - Convert 100ns to Milliseconds

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  12. Copyrighthttps://www.joellipman.com/component/content/article/copyright.html?catid=50&Itemid=165

    you may copy the content to individual third parties for their personal use, but only if you acknowledge the website as the source of the material You may not, except with our express written permission, distribute or commercially exploit the content....

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  13. Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=53&Itemid=165

    file (AHK) if you have AutoHotkey installed on your computer. It was created in AutoHotkey and the download includes the source file if you want to check it doesn't have any malicious code. INSTALLATION: As with all my standalone programs, these are...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  14. Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=53&Itemid=165

    NOTES: This program does not install other files nor is a setup. It was created in AutoHotkey and the download includes the source file if you want to check it doesn't have any malicious code. INSTALLATION: Download the csvchartgenerator.zip from...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  15. Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=53&Itemid=165

    --- Bug/Issue/Development Request category type (see dropdown options) --- Assigned to developer Name --- Originator/Source (Self, Email, Phone, System) --- Customer Name --- Customer Ref/JUser ID (Joomla! registered user or email address?) --- Priority...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  16. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    Zones: Worldwide airports as listed by IATA.org Worldwide airfields for private/commercial use (treated as airports - source: Wikipedia) Known UK military bases (Royal Marines, Royal Navy Air Service, Royal Air Force, Remote Radar Heads) Some "disused"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  17. Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=53&Itemid=165

    under the "Search Only:" heading and then a list of components. Find the value of the checkbox by viewing the HTML source and you should see something like the following: // take the value of the checkbox (eg. doc_indexer) I have set the module by...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  18. Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-5-letter-booking-retrieval-code.html

    ) >= 0) { b_BadWordFound = true; } } // if not found if(!b_BadWordFound) { break; } } // output return v_Output; } Source(s): Zoho Creator - Community Forum - Random Sort/Shuffle a List Zoho CRM - Community Forum - Random number generator (Lead Module)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  19. Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-refresh-access-token.html

    calls/day [Maximum 1,000,000] Ultimate Edition: 15000 + (Number of User licenses x 2000) API calls/day [Maximum 2,000,000] Source(s): Zoho Books API v3 Documentation Zoho Accounts - Setup OAuth Zoho CRM API v2 Documentation

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  20. Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-retrieve-record-with-case-insensitive.html

    used in fuzzy logic searches to broaden the resultset containKey Applies to maps only containValue Applies to maps only Source(s): Zoho Deluge - Functions which return a boolean value Community » Zoho Creator » CASE INSENSITIVE EXAMPLE PLEASE

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
Results 41 - 60 of 192