Re: update query

2002-05-23 Thread Sven Bentlage
thx for the tip, but I don't have access to the error log (my ISP doesn't allow it) just found the problem... there was a typo some 75 lines above... sorry for bothering you all On Thursday, May 23, 2002, at 04:58 PM, Pablo A. Castrillo wrote: > Sven: > Have you checked your error log? > I'm w

Re: update query

2002-05-23 Thread Pablo A. Castrillo
Sven: Have you checked your error log? I'm working with PostgreSQL but when I get no errors and no rows updated I always find an error message in the log file (/var/log/httpd/error_log in my RH 7.1 box). Messages look like: DBD::Pg::db do failed: ERROR: Bad boolean external

Re: update query

2002-05-23 Thread Felix Geerinckx
on Thu, 23 May 2002 11:33:37 GMT, [EMAIL PROTECTED] (Sven Bentlage) wrote: >> Secondly: Have you tried to "print" out the actually query to see >> what it contains? > > not sure how to do that... Instead of $dbh->do("the sql-query"); write $sql = "the sql-query";

Re: update query

2002-05-23 Thread Sven Bentlage
On Thursday, May 23, 2002, at 01:22 PM, Svensson, B.A.T. (HKG) wrote: > First of all: which error do you get? > Don't get any error at all. the next sub (see below) prints out the correct values fetched from the form. > If you don't get any error, are you sure that the target row as >