RE: Perl & SQL not doing what's expected...

2005-06-14 Thread Thomas Bätzler
Jez <[EMAIL PROTECTED]> wrote: > My perl code looks like this; > > use DBI; > use warnings; You should probably "use strict;" aswell and declare your variables before/when you use them with "my". > #open connection to Access database > $dbh = DBI->connect('dbi:ODBC:Deliveries'); > > #construct

Perl & SQL not doing what's expected...

2005-06-14 Thread Jez
Hi, I'm new at this game, and tearing my hair out... I've successfully got some Perl that queries a database without a predicate (no WHERE statement). When I attempt to retrieve specific data, I get either no results returned or errors ; DBD::ODBC::st execute failed: [Microsoft][ODBC Microsof