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

  1. 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

    googled this topic as much as I have, you'll note that everyone seems to be recommending using a cursor. I went through about 10 pages of google results without working out how to use these in SSRS and then resorted to my old methods of debugging. For...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  2. Windows 7 Aero Featureshttps://www.joellipman.com/component/content/article/windows-7-aero-features.html?catid=80&Itemid=165

    is powerful enough to run these effects without affecting performance. If this is happening to you, and you don’t mind about a possible slight slow down on performance you can force enable them - Go to Control Panel -> System and Security -> System...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  3. Set up Desktop SlideShow in Windows 7https://www.joellipman.com/component/content/article/set-up-desktop-slideshow-in-windows-7.html?catid=80&Itemid=165

    elevated privileges but not absolute rights to configuring our computer. And we still need to re-login for every change. About a zillion group policies control our every deviation from the standard staff image and so we spend more time on "how do you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  4. Formatting a date in an MDX queryhttps://www.joellipman.com/articles/else/database/t-sql/formatting-a-date-in-an-mdx-query.html

    Monday, June 15, 2009 =Format(Fields!myDateTime.Value, "ddd dd/MM/yyyy")... Mon 04/04/2011 European and Now: The above is about formatting dates and times but if you want a NOW timestamp in a specific format, try... =Format(now(), "ddd, dd MMMM yyyy...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  5. Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

    that these aren't our databases, we simply help support them. You say less than ideal, I say realistic. Quit complaining about processes and management and instead prove your worth. I'm good at what I do because I make do with what I have available and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  6. Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    An error has occurred during report processing. Cannot impersonate user for data source 'BUKB_Test'. For more information about this error navigate to the report server on the local server machine, or enable remote errors I fixed this by repeating...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  7. MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/else/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

    The How And here is the dilemma. The 3 below SELECT statements were derived from a post to the Stack Overflow website about the best way to check for rows in one table which don't exist in another. -- STATEMENT2 SELECT PageID, PageTitle, PageContent...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  8. Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/else/database/mysql/quickly-update-all-content-replacing-a-string.html

    LIKE CONCAT('%',@stringtoFind,'%') OR `fulltext` LIKE CONCAT('%',@stringtoFind,'%') You might get some errors talking about some empty rows but don't be deceived as the update will have happened anyway. Other Searches Search and Replace a string in a...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  9. This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://www.joellipman.com/articles/cms/website-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

    $file, $ext = true ) { return "application/x-shockwave-flash"; Of course this means that any mime types it's not sure about, it will return as shockwave files. This could be a security concern but as our MediaWiki is on our Intranet for Staff use only,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  10. Pure JS - Display Time Elapsed & Remaininghttps://www.joellipman.com/articles/cms/website-development/js/pure-js-display-time-elapsed-remaining.html

    the elapsed/remaining hours minutes and seconds in real-time. Why? I know there are a lot of articles out there that write about the same, but this is an example that I was coding and found to be one of the most reduced cut down formats I've made. I...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *
  11. Convert Past Date to Time Ago in PHPhttps://www.joellipman.com/articles/cms/website-development/php/convert-past-date-to-time-ago-in-php.html

    19:30:00'); // If (at time of print) this date is 17 minutes and 5 seconds ago // then $v_Str = "17 minutes ago" Or how about $v_Str = getTimeAgo('-1 week 2 days 4 hours 2 seconds'); // yields "1 week ago" $v_Str = getTimeAgo('last Monday'); // yields...

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

    type as content and contains no elements simpleType Defines a simple type and specifies the constraints and information about the values of attributes or text-only elements union Defines a simple type as a collection (union) of values from specified...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • 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

    and freshly ground black pepper. Fluff again with a fork and serve hot or at room temperature. Source: http://homecooking.about.com/od/pastarecipes/r/blpasta17.htm

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  14. Xero API: Send Multiple Invoiceshttps://www.joellipman.com/articles/else/fintech/xero/xero-send-multiple-invoices.html

    5 invoices in a scheduled task because Xero only allows 5 concurrent connections at one time... And Zoho was trying to send about 7 at a time (as in schedule created 7 Zoho invoices but only 5 Xero invoices). Our solution: Send all Zoho invoices in API...

    • Type: Article
    • Author: Joel Lipman
    • Category: Xero
    • Language: *
  15. Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

    properly, when saving as a PDF, CHAR(13) would return weird question mark symbols instead. Bonus All rows with this would be about 3 lines of text in height. Data with 4 lines of text would adjust their row to fit but all others were left untouched....

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  16. GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/component/content/article/godaddy-apache-cpanel-install-ssl-certificate.html?catid=111&Itemid=165

    installed it just lets you click on "Ok"). Initially I got a support agent from GoDaddy to do this who said it would take about 6 hours to 2 days to take effect. Not sure what was supposed to happen but 2 days later it still wasn't working. I followed...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *
  17. DJI Phantom FC40 - Fun at the raceshttps://www.joellipman.com/component/content/article/dji-phantom-fc40-fun-at-the-races.html?catid=113&Itemid=165

    Keep as much space as possible between our marshall. Not Near People: I could not risk flying low so I took a measure of about 3 people high and stood so I could see the height of our 1 marshall's head. To be honest, the reason I wasn't using my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Quadcopters
    • Language: *
  18. Checklist for the local computer repairshttps://www.joellipman.com/component/content/article/checklist-for-the-local-computer-repairs.html?catid=116&Itemid=165

    repair per hourly rate "I always had work order forms in duplicate. Right above the signature line was a BIG BOLD WARNING ABOUT LOSS OF DATA and “Check this box to have your data backed up for $75. Then, I’d charge them $150 for “forensic data recovery”...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  19. Mouseover Links in AutoHotkeyhttps://www.joellipman.com/component/content/article/mouseover-links-in-autohotkey.html?catid=48&Itemid=165

    this all about? Well I want the basic hover effect: when my mouse cursor hovers over a link, I want that link to turn blue and display an underline. When I move the cursor away from the link, I want the link returned to black without an underline. How?...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  20. 404: Page Not Foundhttps://www.joellipman.com/component/content/article/404.html?catid=50&Itemid=165

    We have revamped this website as of September 2015 and tidied up some of our URLs. Some sections will have been moved about but all the content that was on the old site is still to be found on our new website at www.joellipman.com. The Page you are...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
Results 81 - 100 of 106