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

  1. Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/component/content/article/windows-10-shortcut-apps-to-settings.html?catid=80&Itemid=165

    What? This is a list of apps that if run via the run command, or used in a desktop shortcut, or that you want to include in automation software such as AutoHotkey, opens any specific Windows OS settings page. This does not make the change to the setting...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  2. DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/else/database/t-sql/data-shuffling-function.html

    2 - LEN(@RandDay))); END -- DETERMINE TIME VALUE IF TIME WAS IN GIVEN VALUE IF @TimeMatch=1 BEGIN -- SET RANDOM TIME VALUE (include Milliseconds) SELECT @RandHour = (0 - 23) * RandomValue + 23 FROM dbo.vwRandom; SELECT @RandMinute = (0 - 59) *...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  3. DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/else/database/t-sql/datascramble-randomizing-data-rows.html

    2 - LEN(@RandDay))); END -- DETERMINE TIME VALUE IF TIME WAS IN GIVEN VALUE IF @TimeMatch=1 BEGIN -- SET RANDOM TIME VALUE (include Milliseconds) SELECT @RandHour = (0 - 23) * RandomValue + 23 FROM dbo.vwRandom; SELECT @RandMinute = (0 - 59) *...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  4. CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://www.joellipman.com/articles/else/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

    "3.String4" Almost there, counting backwards and forwards it seems the index is just two characters off (as I don't want to include the period): SELECT LEN(@Haystack) - CHARINDEX(@Delimiter, REVERSE(@Haystack)) + 2 -- yields "25" SELECT...

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

    grouping/drilldown pivot tables. Have managed to get this working with SQL Server, Oracle and MySQL databases... Now how to include parameters in non Microsoft technology. Limitations of Excel 2007 PivotTables Aesthetics: Drilldown bolded items are NOT...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  6. Display Feeds to major Social Networkshttps://www.joellipman.com/articles/cms/website-development/display-feeds-to-major-social-networks.html

    Copy & Paste the code into your blog or website HTML. Pinterest Browse to Pinterest Developer Tools - Widget Builder Include the javascript file '//assets.pinterest.com/js/pinit.js' once in the page Customize your feed and Copy & Paste the code where...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  7. CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://www.joellipman.com/articles/cms/website-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

    list that indents and aligns correctly. Why? I'm finding that I need to do this quite often for some clients who want to include their terms and conditions in quote/invoice templates and want the HTML to be indented neatly. Other examples out there will...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  8. PHP & MySQL Search Enginehttps://www.joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    $terms_rx = search_rx_escape_terms($terms); $display_excerpt=search_highlight($result_Content, $terms_rx)."..."; I like to include a "Did-you-mean" section which I also use for any AJAX suggestion feature (be flexible with us as some customers have...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  9. Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/cms/website-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    symbols and how I solved it in my case. Why? My company has started using international country and region names which include foreign characters. When we copy and paste their content into our website, our webpages display a question mark inside a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  10. XML Schema Referencehttps://www.joellipman.com/articles/cms/website-development/xml/xml-schema-reference.html

    elements to be used in complex type definitions import Adds multiple schemas with different target namespace to a document include Adds multiple schemas with the same target namespace to a document key Specifies an attribute or element value as a key...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: en-GB
  11. MS Excel: Convert a text to a numberhttps://www.joellipman.com/component/content/article/ms-excel-convert-a-text-to-a-number.html?catid=110&Itemid=165

    I multiply the Philippine peso by the conversion rate, it returns #VALUE! How? The problem is that I have a column which includes the currency symbol as per the following image: I create another column with the symbol omitted using the formula:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  12. Passwords: Did-you-knowhttps://www.joellipman.com/component/content/article/passwords-did-you-know.html?catid=116&Itemid=165

    following is a list of items I use to include on password checker pages: A program called LC4 (formerly L0phtCrack) used by governments and the military boasts being able to crack 90% of user passwords in under 48 hours on a Pentium II/300....

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  13. Proposed Budget i3 PC under £200https://www.joellipman.com/component/content/article/proposed-budget-i3-pc-under-200.html?catid=116&Itemid=165

    Bulk DVDRW Internal DVD Drive £12.49 (exc. VAT) £14.99 (inc. VAT) Total £122.44 (exc. VAT) £146.93 (inc. VAT) Prices do not include the Operating System (in this case Microsoft Windows 7 Pro 32-bit) nor the chassis as we merely transferred the license...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  14. Amazon Kindle: Send PDFs to your Kindlehttps://www.joellipman.com/component/content/article/amazon-kindle-send-pdfs-to-your-kindle.html?catid=121&Itemid=165

    the list of ebooks currently assigned to your Kindle account, all of which are shown under the Content Other options shown include Devices, Preferences, and Privacy Settings. Click on the Devices heading to show the Device Summary Under Device Summary,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Kindle
    • Language: *
  15. Link to a Joomla article from within another articlehttps://www.joellipman.com/articles/cms/joomla/link-to-a-joomla-article-from-within-another-article.html

    for a Joomla article even when you have Search-engine-friendly website addresses enabled. How? Basically you have to include &view=article as opposed to Joomla v1.5.x when the option and id parameters would suffice: - SEF URL...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  16. Joomla WHERE clause with ORhttps://www.joellipman.com/articles/cms/joomla/joomla-where-clause-with-or.html

    on how to use the where clause in a joomla database query. Why? In response to a member, I use the old form where I can include the whole SQL statement: $db->query('SELECT * FROM #__myTable WHERE condition1=true or condition2=true') Method #1 - chain:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  17. Joomla CMS: Register to Read Morehttps://www.joellipman.com/articles/cms/joomla/joomla-cms-register-to-read-more.html

    to restrict read more content (full text) and just show intro texts to public but the default Joomla instructions do not include the search engine. I need the Joomla built-in search engine to also ignore permissions so that the article can still be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  18. Free Translator API using Googlehttps://www.joellipman.com/component/content/article/free-translator-api-using-google.html?catid=61&Itemid=165

    tag they give you to your index.php file (under template folder in effect or your root index.php - wherever you have jdoc:include type="head") Done!

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  19. SSIS: Add Reference Microsoft.SqlServer.TxScripthttps://www.joellipman.com/component/content/article/ssis-add-reference-microsoft-sqlserver-txscript.html?catid=74&Itemid=165

    Component" under "Extensions". No MSDN website said this... obvious to Microsoft staff so why should their documentation include it? Workaround (applies for any dll) You right-click on the "references" folder, Select "Add Reference..." Click on...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  20. SSRS Repeat Headers in PDF Reporthttps://www.joellipman.com/component/content/article/ssrs-repeat-headers-in-pdf-report.html?catid=75&Itemid=165

    tablix headers only appear once on the first page. Every subsequent page simply displays the report header (which does not include the tablix header... obviously). I right-clicked on the header row of the tablix and checked the box "Repeat header...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
Results 81 - 100 of 103