Re^3: MSSQL Select to an array: error with selectcol

in reply to Re^2: MSSQL Select to an array: error with selectcol_arrayref
in thread MSSQL Select to an array: error with selectcol_arrayref

It looks like your select statement didn't work. The only thing being used as an array reference in that statement is the result from selectcol_arrayref. I would check what you are using for an SQL statement and make sure it is valid.

90% of every Perl application is already written. ⇒

dragonchild

Comment on Re^3: MSSQL Select to an array: error with selectcol_arrayref

Replies are listed 'Best First'.
Re^4: MSSQL Select to an array: error with selectcol_arrayref by Olaf (Acolyte) on Dec 17, 2007 at 15:28 UTC
Hmmm...I suspect you are correct. When I turn off Strict, the script runs and shows 0 results (in code I did not include). BUT BUT BUT...When I run this SQL in Query Analyzer, it does return values. Does anyone know if querying System Views (in this case INFORMATION_SCHEMA.TABLES) is handled strangely? Do you believe in miracles? Yes!	[reply]

In Section Seekers of Perl Wisdom