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

  1. Battery Constantly Drained on iPhonehttps://www.joellipman.com/component/content/article/battery-constantly-drained-on-iphone.html?catid=60&Itemid=165

    lasting the day on a full charge and knew how to close apps running in the background (double-click "home" button and hold down app until red minus buttons appear, tap red button)... I wouldn't usually take notice but I think this is a brilliant example...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  2. MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/component/content/article/macos-transcribe-training-video-using-openai-whisper.html?catid=60&Itemid=165

    Just noted this down in case I need to do it again. This article documents how to take a 5.5 hour video (MP4) and have it transcribed by a locally installed AI on a MacOS (running Sequoia 15.1.1). Why? Needed for training videos as a follow-on from my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  3. Basic Android App using Google Maps and Current Locationhttps://www.joellipman.com/articles/else/app-dev/android-os/basic-android-app-using-google-maps-and-current-location.html

    prompted, you should see some of your code go red like in the following screenshot: Focus the cursor on the word and hold down the key and press Enter, then import each class: Your code will now include the imported classes near the beginning, so TEST...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  4. Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttps://www.joellipman.com/articles/else/app-dev/android-os/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

    return link; } public String getDate() { return date; } public String getDesc() { return desc; } } My rss_item.xml (reduced down): Sources: Android Research Blog - Creating A Simple RSS Application in Android Android Research Blog - Creating a Simple...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  5. Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/component/content/article/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html?catid=73&Itemid=165

    2007 (SharePoint 2007). The situation is that I started creating a SharePoint List (datasheet) and when I made my form dropdown read from the list, it just put elements in the order that I entered them in the datasheet. Googling this led me to browse...

    • Type: Article
    • Author: Joel Lipman
    • Category: Infopath
    • Language: *
  6. Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/component/content/article/alternate-row-background-colour-in-reporting-services.html?catid=75&Itemid=165

    grey (=#eeeeee) in row 2 (even row numbers). The first row being of all rows in the dataset and not for a particular drill-down item. It will alternate between the two for the rest of the report. [The second example is what I use most frequently]....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  7. Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/component/content/article/room-availability-calendar-in-business-intelligence-development-studio.html?catid=75&Itemid=165

    Saying that it's taken me 4 hours just to do the below... hopefully it will be quicker next time now that I noted it all down. The SQL Script: DECLARE @StartTime datetime, @EndTime datetime, @GivenDate datetime; SET DATEFORMAT dmy; SET @GivenDate =...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  8. SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    (as tablix doesn't show if resultset is empty by default anyway but still occupies a blank space which moves your textbox down...) Searches that got me nowhere ssrs display message if dataset rows is zero bids show message for an empty dataset

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  9. SSRS Querying on either of 2 Parametershttps://www.joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

    queries and joined the table containing the other parameter (@StudentADAccount) in each dataset query, which slowed it down a little but the requirement was met. If your end-users complain, do what Microsoft suggests and throw more memory at the SQL...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  10. SSRS Redirect after a report is runhttps://www.joellipman.com/component/content/article/ssrs-redirect-after-a-report-is-run.html?catid=75&Itemid=165

    ASP instead of SSRS. Method #4 Use a TimeInterval refreshing the page after a certain time. Conclusion In the end, this came down to a design decision. Time spent on trying to find a solution was not considered to be warranted. My reports use a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  11. Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    http://browsers.evolt.org - works but installing IE8 breaks it) ie6setup.exe (from Microsoft's website advising on Run > c:\\download\\ie6setup.exe /c:"ie6wzd.exe /d:1 /s:""#E") If you only want Internet Explorer versions 6 & 7 (Note that installing IE8...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  12. Run commands for Windowshttps://www.joellipman.com/component/content/article/run-commands-for-windows.html?catid=80&Itemid=165

    Scheduled Tasks control schedtasks Security Center wscui.cpl Services services.msc Shared Folders fsmgmt.msc Shuts Down Windows shutdown Sounds and Audio mmsys.cpl Spider Solitare Card Game spider SQL Client Configuration cliconfg System Configuration...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  13. T-SQL Record Separatorhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-record-separator.html

    WRAPPED SET RECSEPCHAR "-" Stage #1: Duplicate the table and create a separator marker Granted this will slow the query down a touch and only adds a check column which marks rows (identifying when a separator is needed) but this works. Inspired by...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  14. T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/else/database/t-sql/t-sql-parse-an-xml-value.html

    Event_XML.nodes('/*') AS r(c) ) AS RootParent FROM [dbo].[XML_EVENTS] -- to get name of immediate child node -- one level down SELECT ( SELECT c.value('local-name(.)', 'nvarchar(50)') FROM Event_XML.nodes('/*/*') AS r(c) ) AS RootChild FROM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  15. Basic Oracle Stored Procedure Structurehttps://www.joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-stored-procedure-structure.html

    and how to use cursors. I'm told I need to use this for SQL Server Reporting Services (SSRS) which is why I'm going down this route. For an even simpler stored procedure, I'd imagine you just get rid of the cursor. Why A standalone query is faster in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  16. Error 1065: Query was Emptyhttps://www.joellipman.com/articles/else/database/mysql/error-1065-query-was-empty.html

    In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common. Why? Bespoke systems are the usual suspects....

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  17. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/else/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

    • For versions after 6.0.7 Method #3 (Recommended): Do not use MySQL WorkBench!!! Seriously, your pride will slow you down or get you sacked! Instructions: Go to Google Search Search for "Free MySQL database manager" (preferably add the keyword...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  18. Three boxes, two roll over, one falls outhttps://www.joellipman.com/articles/cms/website-development/css/three-boxes-two-roll-over-one-falls-out.html

    nothing because you always end up needing to specify a third of the width. Our template was 900 pixels in width. I tracked down some code that was simply calculating with 33% as the third of the page width. Changing this to 990 pixels in width fixed the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  19. Pure JS - Display Time Elapsed & Remaininghttps://www.joellipman.com/articles/cms/website-development/js/pure-js-display-time-elapsed-remaining.html

    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 thought I'd make a note of it to not have to search elsewhere... This example specifically displays the...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *
  20. A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    time(s) you do this, the task is rather daunting. Having done it a few times and run through a few, I thought I'd note this down to remind me if I ever work for a company using SITS:Vision again. How? For demonstration purposes, I'm going to create a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
Results 61 - 80 of 93