Turn on your error checking. RaiseError and possibly use trace() at level 2
if RaiseError does not provide enough insight. See perldoc DBI if you are
not familiar with the above.
Ilya
> -----Original Message-----
> From: Clinton [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 17, 2001 1:11 AM
> To: [EMAIL PROTECTED]
> Subject: Wildcards
>
>
> 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
