in reply to Simple sql query problem

I think there's something you're not showing us. That error message looks to me as if you tried to interpolate a reference into your query string. For example:

my $stuff = [ 'things', 'items', 'etc.' ]; my $query = "SELECT $stuff FROM foo"; print $query, "\n"; __END__ SELECT ARRAY(0x504290) FROM foo

Is this possible? It would probably be useful, from a debugging standpoint, to print out your query before you send it to the database.

Replies are listed 'Best First'.
Re^2: Simple sql query problem
by Anonymous Monk on Dec 01, 2007 at 15:50 UTC
    Thanks for response. I think I'm not hiding anything, cause SQL query is sent as string to subroutine.... So string is used as it is declared in code. I just wanted to check if there is any obvious error in this code..

    Regards,
    Rob.