Excuse me, I don't understand the word 'scope' what it means.
---------- Original Message ----------------------------------
From: "Brose, Eric" <[EMAIL PROTECTED]>
Date: Wed, 13 Jun 2001 14:00:32 -0700
>sure there aren't any scope issues?
>
>-----Original Message-----
>From: Krung Saengpole [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, June 13, 2001 2:07 PM
>To: [EMAIL PROTECTED]
>Subject: SQL statement.
>
>
>Hi all,
>
>I have one problem that should not be. I use Access97 on NT server with
>IIS5. I couldn't use placeholder in SQL statement as below:
>
>use DBI;
>$dbh = DBI->connect("dbi:ODBC:myDSN",'','');
>$sql = "Select * From myTable Where ID_Code = ?";
>$sth = $dbh->prepare($sql);
>...
>$sth->execute($ID_code); #ID_code contains ID_Code value
>$rc = $sth->fetchrow_hashref;
>print $rc->{'FIELD_NAME'}; # no result
>
>I have to change $sql to "Select * From myTable Where ID_Code=$ID_code" and
>call $sth->execute() instead to fetch the result to $rc. What's wrong with
>my code?
>
>Any advices would be greatly appreciated.
>Krung.
>
>
