Joes Quicklist Weblinks (JQW)http://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 is set to upgrade on install or something like that. I have not got the upgrade server for J16 working yet but soon. Also there's no need to delete a previous version of this module, just download the updated one, and install as per usual. IMPORTANT...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Basic Webpage Controls with JavaScript / COMhttp://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 the page: Code: text := pwb.document.documentElement.innerText text := COM_Invoke(pwb, "document.documentElement.innerText") There you have it! These techniques should help get you started. Next, I would recommend the following: Try these Controls out...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

SSRS Querying on either of 2 Parametershttp://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 the second solution will mean each dataset must at least join both tables that you are using the OR clause against. There must be a solution that executes a query at report execution time and populates/assigns the local variable ID (@StudentReference)...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Before and After, Highs and Lowshttp://www.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 Report 001 5 2 Report 002 11 47 Report 003 7 61 Multiple Datasets? Again NO that's what I have at the moment. There must be a way. Or is time always on that dimension? HAVING is pointless, WITH ROLLUP is interesting, think I'm looking in the wrong...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

The ReportServer Databasehttp://www.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 on Microsoft websites to determine what number is the TimeDataRetrieval column displaying. Thank you I know it's an INT. There is just a serious lack of documentation as to what this database is and how it populates its data. View: ExecutionLog...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

MySQL parameters in Excel 2007 PivotTableshttp://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 INNER JOIN Teams t ON t.TeamID=s.TeamID GROUP BY s.LogID ORDER BY s.TeamID, u.Username, s.DateTimeCreated, Resource Note there is no WHERE clause because we're going to use EXCEL filters as the parameters. Bit of a cop-out but this was just a workaround...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

SSRS External Images don't displayhttp://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 have photos for all ~20000 students at all times and these get updated/uploaded/added to about once a week. In cases where there are no photos, SSRS displays a mini ugly red cross. On the system that used to do this, we could use the HTML attribute...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttp://www.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is that there appears a link that will run a stored procedure which Updates a timestamp in an existing table Inserts a row into an audit...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Joes DNS Correction (JDC)http://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 run the above commands and check the error levels. Installation: 1) Decompress to a folder of your choosing 2) Run the EXE (there is no install process, it should just start) 3) Done! ChangeLog: v1.0 (22/11/2011) - Display internal and external IP...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

No rows returned in Oracle causes SP to failhttp://www.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 I am using this stored procedure in a SQL Server Reporting Services (SSRS) environment and don't want to return any rows if there are no matches (not a blank row either) as one of my reports uses a row counter to display a "No data found" message when...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

The Mermaidhttp://www.joellipman.com/articles/_other-misc/the-mermaid.html

24 July 2012 a Friday morn when we set sail And our ship not far from land, We there did espy a fair pretty maid, With a comb and a glass in her hand, Her hand, her hand, With a comb and a glass in her hand. While the raging seas do roar, And the stormy winds do...

• Type: Article
• Author: Joel Lipman
• Category: Hobbies
• Language: *

Connect to Joomla database in standalone scripthttp://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 need all the require files and my solution may be crude, but this script works perfectly for what I had in mind. Important! There are a few concealed features of this script that I haven't made a song and dance about but are noteworthy: The only...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Data Randomization Function in Oracle PL/SQLhttp://www.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 original data but the same length and the same type of data. Why? The joy of working with the plethora of applications out there result in me using MySQL, Oracle PL/SQL and Transact SQL in my day job. The equivalent functions have to be written up all...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

T-SQL example of Case-Sensitive Soundexhttp://www.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 Available data not yet available Daat oNt EYt Avialable Success! Now we can run this on a column in a table to determine if there are discrepancies in our default values. Additional Note how this also picked up typos in the 4th value which is good as I...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Upgrading a Joomla 1.5 module to Joomla 2.5http://www.joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

11 February 2011 make these compatible with Joomla 2.5.x websites. In the past, I have only ever changed the words to but for more stability, there are a few more tweaks to do. How? For demo purposes we will be referring to a Joomla module called "mod_moduletoupgrade"...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Three boxes, two roll over, one falls outhttp://www.joellipman.com/articles/web-development/css/three-boxes-two-roll-over-one-falls-out.html

21 January 2013 using Chrome and tolerable using MS Internet Explorer. If we maximized the Google Chrome browser, the row would split and there would be 2 boxes on the top row and the third would pop under these. As for MSIE, that was ok when maximized. How? You could...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Set up Desktop SlideShow in Windows 7http://www.joellipman.com/articles/microsoft/windows-os/set-up-desktop-slideshow-in-windows-7.html

22 January 2013 and click on “Select All” Click on “Save Changes” Additional: Further group policies can completely disable this feature so there is a chance that this won't work for you.

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

CharIndex Reverse - find occurrence starting from end of string in TSQLhttp://www.joellipman.com/articles/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

28 January 2013 LEN(@Haystack) - CHARINDEX(@Delimiter, REVERSE(@Haystack)), LEN(@Haystack)) -- yields "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)...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Fix Oracle Tnsping 3511 without Windows Registryhttp://www.joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 that need to support these kind of systems and not as an invite for suggestions on how my business should be run. How? So there are a variety of solutions that will fix this. However we have certain restrictions in my work environment thanks partly to...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

AwStats Data Parser (ADP)http://www.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 and USB portable. Currently runs using either Windows XP or Windows 7. How to use: Save a frame of your Awstats page (so there isn't the menu on the left) Run "Generate_AwStatsParsedData.exe" Select the file you saved in step 1 Click on "Go". What data...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *