Thanks Michael. But in using FreeTDS and DBI Sybase (thank you) I haven't been able to use placeholders. My apologies for not listing the setup: Apache/Linux/Perl -> Win2K/SQL Server 7.0
Comment on Re: Re: DBI SQL statement in while loop
Ah. Well in that case you'll have to move the prepare() into the loop (or use do()) and use interpolation (with the usual caveats about NULLs, etc.)
The naive version would look like this:
while (<>) {
my $quantity = param("quantity");
my $gross_sales = param("gross_sales");
my $sql = qq/
insert into transaction_details(quantity, gross_sales)
values($quantity, $gross_sales)
/;
my $rv = $dbh->do($sql);
# check return value, etc.
}