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

20 November 2012 STABLE AND CONSISTENT !!! */ background-color: #f7f7f7; background-clip: padding-box; border-radius: 0 0 5px 5px; Example Additional The above issue happened when using Google Chrome v23 or MS Internet Explorer v8 (so Webkit and MSIE appear to be...

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

Error 1065: Query was Emptyhttps://joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

13 December 2012 \t A tab character. \Z ASCII 26 (Control+Z). \\ A backslash (“\”) character. \% A “%” character. \_ A “_” character. Additional An alternative in SQL to escape apostrophes is to change these to paired apostrophes, so: INSERT INTO myTable VALUES ('1',...

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

Setup a copy of your Joomla websitehttps://joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 (Operations > Copy to... > untick "Create Database") Done! and you have all the necessary backups for a restore point. Additional Notes Don't forget the .htaccess file for Search-Engine Friendly (SEF) website addresses as a lot of web-based file...

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

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

22 January 2013 at the bottom) Check the Picture location is using your image folder 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

Access MySQL databases using Oracle SQL Developerhttps://joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 on the plus sign in the connections tab), select the mySQL tab and complete the login details and host location... Done! Additional I wouldn't recommend using Oracle SQL Developer. You have to use mostly SQL to create tables and stuff. Recommend to your...

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

Administrator Program Shortcut without Prompthttps://joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 click on Next Give the shortcut a name to display as (eg. "Visual Studio 2010") Click on OK to complete your shortcut. Additional: You can change the icon for the shortcut using the shortcut properties and browsing to the program it was created to run....

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

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

04 March 2013 Or create NEW if it doesn't exist. Give it the value C:\ORACLE\product\11.2.0\client_1 OK all dialogs to close and save. Additional The affecting TNSNAMES.ORA file for the above setup is located in "C:\app\\product\11.2.0\client_1\Network\Admin". I also...

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

SSIS Convert a string into a datehttps://joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 (,) and therefore the parsing (to extract year for example) will fail and stop the task (based on default settings). Additional -- Take a "dd/mm/yyyy" string and convert to date (when (DT_DATE)ThisDate by itself doesn't work)...

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

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

04 April 2013 column headings, F1 is the first column of the data range and NOT the first column of the data sheet (eg. F1 = B11) !!! Additional We add a conditional split task to the data flow which only passes through rows from the Excel sheet which are not...

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

MS Excel - Sort pivottable column headings by datehttps://joellipman.com/articles/microsoft/excel/sort-pivottable-column-headings-by-date.html

12 April 2013 and perhaps Excel will be forced to treat it as a string: Another alternative to round brackets, square brackets! Additional: I have made this work with the parentheses but only after refreshing ALL DATA in the spreadsheet and reconfiguring which fields...

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

SSIS Skip Blank Rows in Flat File Sourcehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 Task: Format keycolumn as per your requirements and use substring on trimmed DataColumn to retrieve each data column. Additional The TRIM in SSIS does not appear to get rid of new line and carriage return symbols!!! Use the Replace(String, "\r", "") and...

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

htaccess Rewrites SEF URL and submits to PHPhttps://joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 401 /error/?v=401 ErrorDocument 403 /error/?v=403 ErrorDocument 404 /error/?v=404 ErrorDocument 500 /error/?v=500 Additional Notes If you do apply the above to your site, bear in mind the following is also true:...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Joomla Component: Set default params on installationhttps://joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

24 October 2013 $query->where($db->quoteName('name') . ' = ' . $db->quote('com_XXX')); $db->setQuery($query); $db->query(); } } } Additional: ACL during install My component is editable by registered users only. This meant that everytime someone installs the component,...

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

Client Services: Website Development Agreementhttps://joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 from the server, this is also 10am GMT – e-mails from people will use the timezone they are accessing the service from). Additional I am a one-man band, a solopreneur, freelancer but I specialise in automation which lets me do the work of many more. I...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

ReCaptcha disappears from Joomla 2.5 Registrationhttps://joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

24 November 2013 // Replace YOUR_KEY with your public key return ' window.onload = function() { Recaptcha.focus_response_field(); } '; } Additional This applies to a case where the code WAS working and without any changes to the server (no updates), and the recaptcha...

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

Convert to Proper Case in T-SQLhttps://joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 SampleText SampleText lowercase.text lowercase.text Examples of usage: SELECT ufn_ProperCase([Surname]) FROM employees Additional: Note how the above doesn't convert postal codes, specifically British postcodes, which isn't included in the examples...

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

Include a carriage return in a column headinghttps://joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 difference the above does, is that when you refresh the data, it will retain the carriage return in the column headings. Additional: Only appears obvious in SQL Server Management Studio resultset. Remember to format the cells (column headings) in the...

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

A quick run through of setting up an export process in SITShttps://joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 will output something like A|Applicant) Click on "Apply" Include any additional entities as sub-entities under the parent one (not used in this demo) and repeat the steps above to select the exchange fields. Check/ensure the "In Use?" is ticked....

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

MessageBox or AlertDialog in Android Javahttps://joellipman.com/articles/google/androidos/messagebox-or-alertdialog-in-android-java.html

20 October 2014 { public void onClick(DialogInterface arg0, int arg1) { // Some stuff to do when cancel got clicked } }) .show(); Additional: Pre-populating default value and returning input Lots of confusing answers out there on the web but here's an all-in-one where...

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

Android: Keytool and Google Maps displaying greyhttps://joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 I'm not saying it won't fix a problem for you, just that downloading from the Play store was unrelated to the above. Additional: If you forget your key (like I did) and which keystore file you used, then you'll have probably tried this: Upload the APK...

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