Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

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

by pfaut (Priest)
on Dec 14, 2007 at 15:45 UTC ( #657062=note: print w/ replies, xml ) Need Help??


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
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!

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://657062]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (3)
As of 2015-07-06 01:09 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (68 votes), past polls