Something like
update table set row = 1 where id in (1,2,3) ???
On Aug 3, 2004, at 11:28 AM, Paul Swingewood wrote:
<cfloop index = "ListElement" list = "#form.modifiedsize#"> <cfquery name="updateitemsizes" datasource="#application.DSN#"> UPDATE tblItemSizes SET FKSizeID = '#trim(ListElement)#' WHERE FKItemID = '#trim(form.ItemID)#' </cfquery> </cfloop>
Looking at the above code I think you'll see what I am trying to do. (update the size given from a drop down multiple select where the itemID's match)
However it doesn't work. I can see that the list loop goes around n times for the size and then the query goes around n times becuase of the WHERE.
So how do I update the table for each size in the list where the itemid's match ...?
Regards - Paul
--
These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
-- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*To unsubscribe, e-mail: [EMAIL PROTECTED]
