SQL UPDATE question (was Update Query/Output question from a newbie)

Hi again to everyone, I would like to thank Stephen and Bret for their help earlier. I managed to get things working on the update form, although I haven't moved to the state_id rather than the state_name system yet. I still receive errors (ColdFusion was unable to determine the value of the para

RE: SQL UPDATE question (was Update Query/Output question from a newbie)

lease notify us on +44 (0)207 387 8890. -Original Message- From: Michael Wilson [mailto:[EMAIL PROTECTED]] Sent: 23 October 2000 17:45 To: CF-Talk Subject: SQL UPDATE question (was Update Query/Output question from a newbie) Hi again to everyone, I would like to thank Stephen and Bre

Re: SQL UPDATE question (was Update Query/Output question from a newbie)

Mike, You need to remove the quotes from your ID field (which is a number, I assume...) UPDATE tbldistrib SET distrib_name='#Form.distrib_name#', distrib_city='#Form.distrib_city#', distrib_state='#Form.distrib_state#', distrib_phone='#Form.distrib_phone#' WHERE distrib_