You'll need to do 3 updates. The ideal way is to know the unique identifier of the row you're trying to set. You've got one of those, right? Right?!?
Anyway, assuming that the table name is "Prices" and you've got a uid column "priceid", you'd post both prices and priceid from the form, and then do something like <cfquery name="setprice" datasource="dsn"> update prices set price = #form.price1# where priceid = #form.priceid1#; update prices set price = #form.price2# where priceid = #form.priceid2#; update prices set price = #form.price3# where priceid = #form.priceid3#; </cfquery> Does that help at all? --Ben Les Mizzell wrote: > I guess I'm going about this all wrong... > > Basically, I've got three cells in the database I need to update, and > three specific form fields to update these cells from. > > I know how to update multiple rows, but that's not exactly what I'm > trying to do here... > > You can't do the below, but that's what I *want* to do... > > <cfquery name="update" datasource="myDATABASE"> > UPDATE AOS_163 > Set > PRICE[1] = #form.Price1#, > PRICE[2] = #form.Price2#, > PRICE[3] = #form.Price3# > </cfquery> > > So, the syntax is eluding me at the moment... > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182402 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
