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(UPDATE

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 select name=course multiple option value=cc/option option value=javajava/option