Updating 2 fields in a record?

[Anon]

I have a table with manyfields. I want to update a record by modifying multiple fields with one sql statement. Mine is:

$row = @("UPDATE books SET isbn=$isbn, title=$title WHERE id = $id");

This is not working. Although, if I remove the "title=$title" it would work and update the isbn field.

Any idea?

Thanks.

[van__]

Dunno, try quoting the varchars...
$row = @("UPDATE books SET isbn='$isbn', title='$title' WHERE id = '$id'");

Should work ok.

[Anon]

Thanks, that was it.