Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 Finish Data Source Name (should be system name followed by Live/Test/Dev for reference) Description can be some long winded text that very few will ever use TCP/IP Server is the server name (without the DNS suffix) or the IP address of the server Port...

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

Parameters not being used in report processinghttps://www.joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 in its query). Problems: Given a date, the date format was reverting to US format as opposed to European Given a Campus as a text value, the SQL query was ignoring this completely Hardcoding the scalar local variables worked I have two parameters that...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 NOT CONFUSE THE FOLLOWING DATABASE NAMES OR YOU WILL END UP WITH NEITHER SITE WORKING!!!) Open the SQL file in your favorite text-editor Rename any instance of "my_old_database.jos_" to the name of your old Joomla 1.5 database or a copy of (note the...

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

Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 but it does. Not sure whether you call this an MDX Query or part of a Transact-SQL mashup. You need to go to "Fill" (of each text box in the row - unless there's a faster way) and instead of color, click on the expression button (fx) and use the...

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

Fun with DllCall in AutoHotkeyhttps://www.joellipman.com/articles/automation/autohotkey/fun-with-dllcall-in-autohotkey.html

27 September 2011 there. If you're the type of AutoHotkey programmer that doesn't like having to use the command prompt to write to an extra text file which your program has to read, then this is for you. DllCall will usually run contained in the program and can be...

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

Joes Network Transmission Detector (JTD)https://www.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 and forth to network shares, user profiles, browsing data, etc. What does it look like? It's kinda transparent with it's text as white and sits behind other windows much like a gadget or widget. If you know your AutoHotkey, the download includes the AHK...

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

SSRS Zero Paddinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html

10 November 2011 a forum so thought I'd better make a note: Right("00000" & Fields!ERROR_CODE.Value.ToString, 5) -- "Right()" to say extract text from the right -- ".ToString" because it's likely you're doing this to a number and numbers just get rounded up without the...

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

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 can send each new info to the next slide and use only two slides in total (that's the aim at least). Other objects (mostly text over image) will need to be free flowing and slide in emulating a dynamic showcase slideshow. Using MooTools it's also proven...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

Background Gradient Disappears on Long Pageshttps://www.joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 visit a very long page on the site, the contents background disappears and reveals the overall background (blue) making the text very hard to read. Why? Took me a while to figure out what was the problem, I'd visit some pages and they'd be fine, but...

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

Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 ) ColIndex++ } } Snippets Assume that "Haystack" is the string of code you want to parse (all content). Function ExtractText extracts text given a unique string to mark the start of the extract (1a), a second string (1b) to refine the starting position...

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

SSIS Skip Rows in Excel Source filehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then the options in the connection manager will let you skip rows and specify column datatypes. You...

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

Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 quotes and tick the “Constant” radio box and click on the “Search” button. What displays in the search results should be the text that the system emails out on password change. The default if you’ve lost it is as below (exclude the double-quotes):...

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

Reorder Columns in a Tablehttps://www.joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 COMMENT 'A Comment' AFTER other_column; Alternatively Export the file as a SQL file (data & structure), Open it using a text editor Modify the order of the columns, for example: -- From CREATE TABLE IF NOT EXISTS `Table1` ( `Column1` int(11) NOT NULL...

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

Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 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: ab?c This...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Export Joomla Users scripthttps://www.joellipman.com/articles/cms/joomla/export-joomla-users-script.html

28 February 2014 CMS. How? I could just type a query on the database and get the same result, but this script was more fun. Simply create a text file with the following code and upload it to the root of your Joomla website. Access the page from a browser and you should...

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

301 Redirect using htaccess filehttps://www.joellipman.com/articles/web-development/301-redirect-using-htaccess-file.html

03 April 2014 believed me when I raised the alarm but hey-ho. How? I'm going to show you how to do this with a .htaccess file: Upload a text file to the root folder of the old domain's website Rename it as ".htaccess" (or modify the existing one) Add the code as per...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

SITS: Export field code and namehttps://www.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 on the chevrons ("»") next to the field to apply this to Enter the dictionary code, the entity code and then the inner SRL text which should be |, if you try to apply you should be prompted to convert to use gold characters: Test the XET export and you...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

XML Schema Referencehttps://www.joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 a complex type that contains mixed content or elements only complexType Defines a complex type element documentation Defines text comments in a schema (must go inside annotation) element Defines an element extension Extends an existing simpleType or...

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 interactive quick reference image - [1.7.0] Hangar: offline can view aircraft #1 - [1.7.0] Hangar: tap on specification text to edit - [1.7.0] Pilot: login, register, authenticate - [1.7.0] Pilot: map preferences/settings - [1.7.0] Help: details on what...

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

Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 to only search one area, but you can include multiple components by separating these with a comma. This parameter is a text field which uses the alias of the component (eg. "doc_indexer"), you would need to modify this to the component you want it to...

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