Remove write-protect from USB pen in Windowshttps://joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 found a utility that actually works on my pen!!! It said “repaired USB pen” and when I go to check the space, my 30Gb has returned!!! It’s called Urescue and it’s become my favourite program (despite the fact that I want to need to use it as little as...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 unstable...) Browser Sandbox (Need IE and install their plugin - does not reflect my customer's PC image) IETester v0.4.3 (Returned different results from my IE7 tests) ie6olas_nt (from http://browsers.evolt.org - works but installing IE8 breaks it)...

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

K2 Items disappearhttps://joellipman.com/articles/cms/joomla/k2-items-disappear.html

27 August 2010 the error is at a foreach() line where it's pulling data from the database. I asked to see the jos_k2_items table and it returned the following error: #145 - Table './jos_k2_items' is marked as crashed and should be repaired The Quick Fix I managed to...

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

Is it a scam? Gumtree.com's warning signshttps://joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 will send you a cheque worth more than the value of the items/rent/job. They’ll then ask for the surplus money to be returned to them or a third party, for example ‘to pay for shipping’. The cheque will clear into your bank account, only to be refused...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

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

30 January 2011 -- If you select the part of each expression from the SELECT and run these -- to see what results are returned, it is reading only and not making any -- changes. It will show you what data the query is planning to migrate. -- EXAMPLE: -- SET...

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

SSRS Hide results table if emptyhttps://joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 AND re.SetId=@setId Reminder: The counter = 1 means that if I call on the sum of these, I can check if zero rows were returned because Sum(Fields!Counter.Value, "Equipment") should come back as zero. MDX Expression: One final and a little confusing...

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

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

19 July 2011 it populates only the first dataset with results; the remaining datasets that need to use the ID parameter all returned zero rows. So one workaround exists where if I combined all 10 dataset queries into 1 mega dataset query, problem solved… Another...

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

Sort order a dropdown list in MS InfoPath without programminghttps://joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 page, there should be a Sort section, specify the column to sort by. Save the view by clicking the OK button. You'll be returned to your datasheet and it's possible it isn't in any different order. I re-checked out my InfoPath form, looked at the...

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

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

03 August 2011 what I wanted? Well NO. I have a table with the same report mentioned several times but just in a different week. I want a returned table structured as follows: Report Name Run Last Week Run This Week ------------------ -----------------...

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

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

04 November 2011 database table and that the request number was alphanumeric. In addition, this would be checked at the database level, and returned in a dataset for SSRS to complete the check. Instead of outputting the error code to our end-users, we decided to store...

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

SSRS AlphaNumeric Parameter Validationhttps://joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

07 November 2011 by the database Report retrieves (select) formatted parameter as a field value to use Report loads with changes based on returned value. The Gist Add database level parameter check Add IIF in SSRS to confirm Database Level AlphaNumeric Check You may...

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

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

10 November 2011 them up the error is ORA-12345. Unfortunately Oracle also returns errors of less than 10000 so ORA-00201 would actually be returned as "-201". As I wanted a link so that the user can just click on this link and it would take them to...

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

How to Display Report Execution Time in SSRS (milliseconds)https://joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 have a report that takes over an hour to process but in theory this should accommodate it. Problem #1 If zero rows are returned from the search, then there is no REPORTSTARTTIME. There are two options here: Create another dataset (would have to be the...

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

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

22 August 2012 1 for dbms_random function v_rand_param2 VARCHAR2(50) := ''; -- v_rand_param2 : parameter 2 for dbms_random function v_returnedval VARCHAR2(255) := ''; -- v_returnedval : value to be returned BEGIN IF p_original_value IS NULL THEN v_returnedval := NULL;...

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

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

10 October 2012 as having the same SOUNDEX value. Adding the COLLATE option straight after the column that needs to be case-sensitive returned the correct results: SELECT DISTINCT StudentDetail COLLATE Latin1_General_CS_AS FROM StudentTable WHERE...

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

Search a database for a value and count matching rowshttps://joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 value specified in parameter 1 (matched in database to search) ** ** - myTable: table in which the column occurs ** ** (returned as "database.schema.tablename") ** ** - myCount: the number of records matching the value in this table. ** ** **...

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

JDatabase: using the Joomla database with exampleshttps://joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 is for when you want any of the values from one resulting row. You will need to know the column order the results are returned in. $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select(array('name', 'email', 'username'))...

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

Quickly update all content in mySQL database replacing a stringhttps://joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 @stringtoReplaceWith) WHERE `introtext` LIKE CONCAT('%',@stringtoFind,'%') Run the first query again and no rows should be returned. Quick Joomla One I use this reluctantly but often necessarily. SET @stringtoFind=' '; SET @stringtoReplaceWith=' ';...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• 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 Using the example above: Sheet1$A11:AL12 Selects all data from column A, row 11 up to Column AL, row 12 (so 2 rows will be returned). Sheet1$B11:AL Selects all data from column B, row 11 up to Column AL, row unspecified - used if I don't know how many...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• 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 line feed characters to the next viable row, see my original data file here (sample data): And this is what a Data Viewer returned when executed: My columns were being pushed out of alignment (something about {CR}{LF} being displayed for the blank rows...

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