on Fri, 17 May 2002 01:32:54 GMT, Fjohnson wrote:
> The error I am getting with this version of the code is
> the following:
> DBD::Sybase::st execute failed: Server message number=170
> severity=150 state=1 line=1 server='hostname' text=Line1: Incorrect
> syntax near ')' . at dbi.pl line 27, <STDIN> line 4.
[ Code snipped and reformatted ]
> $sth = $dbh->prepare("
> insert into Books
> (Book_title, Author, Publisher, ISBN)
> values ('$Book_title', '$Author', '$Publisher','$ISBN')
> )") || die "Couldn't prepare statement: $DBI::errstr";
>
> # execute query
> $sth->execute() || die "Can't execute the SQL statement:
> $DBI::errstr";
1) You must use 'or' instead of '||' to avoid precedence problems.
('||' has higher precedence than '=', but 'or' hasn't).
2) You have one too many ')' in your SQL statement, the last one within
the quotes. (This gives you the error message above).
3) Personally, I prefer placeholders:
$sth = $dbh->prepare("
insert into Books
(Book_title, Author, Publisher, ISBN)
values (?,?,?,?)");
and then call execute like so:
$sth->execute($Book_title, $Author, $Publisher,$ISBN);
--
felix
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
