Weird SQL Problem
От | |
---|---|
Тема | Weird SQL Problem |
Дата | |
Msg-id | 20050907234836.1433.qmail@web33315.mail.mud.yahoo.com обсуждение исходный текст |
Ответы |
Re: Weird SQL Problem
Re: Weird SQL Problem Re: Weird SQL Problem Re: Weird SQL Problem |
Список | 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
В списке pgsql-novice по дате отправления: