From: | <operationsengineer1(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Weird SQL Problem |
Date: | 2005-09-07 23:48:36 |
Message-ID: | 20050907234836.1433.qmail@web33315.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
hi all,
i'm baffled by a sql issue.
i use adodb and the code is as follows (the sql should
be pretty evident - even if you don't follow adodb).
$result_update = $db->Execute('UPDATE t_defect SET
reworker_id = ' . $reworker_id . ', rework_completed =
\'t\', rework_notes = ' . $rework_notes . ',
rework_date = '. $db->DBDate(time()) . 'WHERE
t_defect.defect_id = ' . $defect_id );
my problem is this... the text input for
$rework_notes kicks out a pgsql error as follows...
'ERROR: column "aaaaaaaaaaaaaa" does not exist'
where "aaaaaaaaaaaaaa" is what i entered in the
$rework _notes text area.
what am i missing here? why is pgsql trying to find
the column? rework_notes is varchar and i've done
inserts for similarnote setups right and left with no
problem.
tia...
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2005-09-08 00:22:01 | Re: Weird SQL Problem |
Previous Message | Josh Berkus | 2005-09-07 23:41:50 | Re: Get a list of columns for a table |