Re: ColdFusion query question

2008-04-25 Thread erik tom
Sorry about that I have updated version of the code. What it does is updating all records rathere than updating only changed records. select * from questionOptions where id in (#option2#) and

Re: ColdFusion query question

2008-04-25 Thread erik tom
The data is the follow : id idoptionsquestionID SurveyID 160test 82 1 161test2 82 1 162test3 82 1 >Erik, > >This is pretty difficult to troubleshoot with

Re: ColdFusion query question

2008-04-25 Thread Brian Kotek
Did you read my response to this same question in the other thread before you decided to post it yet again as a duplicate thread? On Fri, Apr 25, 2008 at 12:37 PM, erik tom <[EMAIL PROTECTED]> wrote: > I have problem updating the DB table. > I have 3 text boxes which has specific id. if the valu

RE: ColdFusion query question

2008-04-25 Thread Mark Kruger
Erik, This is pretty difficult to troubleshoot without looking at the data. I suspect it is your loop and initial query and not your insert code. -mk Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: erik