Re: Error in the postgres update

2006-02-06 Thread Chas Owens
When using the DBI it is best to either let the database handle quote the strings or use placeholders: database handle quoting: my $update = "UPDATE tab SET foo = " . $dbh->quote($foo_val) . " WHERE bar = " . $dbh->quote($bar_val); $dbh->do($update); place holders: my $sth = $dbh->prepare("

Error in the postgres update

2006-02-03 Thread Anish Kumar K.
Hi I am getting a strange error and I have no clue as how to fix this.. I am getting values from select multiple tag from the FORM and trying to update the value in the table. Say the select tag is like this c java perl And I selected "java" , "perl". then the select course will have the v