in reply to Re^2: Fetching data from Access using DBI
in thread Fetching data from Access using DBI

I fail to see the point of using column_info to obtain all column names then using them in the select - surely that is "select *". Try to simplify the sql and code you are using to locate the problem. Start by changing the SQL to qq/select * from $table ORDER by "REF"/ and if that does not work check the $table and quoting of $table etc. Try to find the smallest uncomplicated SQL which works and the smallest change that stops it working.

  • Comment on Re^3: Fetching data from Access using DBI

Replies are listed 'Best First'.
Re^4: Fetching data from Access using DBI
by hacheb (Novice) on Aug 11, 2009 at 10:37 UTC

    my using column_info is just experimental: I'm learning to use this interface.

    See also my reply to bart.

    H