Hi
I'm on Win32 connecting to Access2000 using DBI. I have no problems when I
run this query in directly in Access. I have tested my connection with other
querys and it seems to work.
My problem is if I run the query from perl I get no response - the program
runs to completion with no errors (using strict and w).
my $sql = "SELECT custID, ac_name, ac_address FROM tblAccount WHERE ac_state
= 'VICTORIA' AND ac_name = 'A*' ORDER BY ac_name";
my $statementHandle = $dbHandle->prepare($sql);
$statementHandle->execute() || die $statementHandle->errstr;
my($custID, $ac_name, $ac_address);
$statementHandle->bind_columns(\$custID, \$ac_name, \$ac_address);
while($statementHandle->fetch()){
print "$ac_name \n";
}
Help appreciated
CCJ
