WERE prodID=#form["prodID_#i#"]# should be
WHERE prodID=#form["prodID_#i#"]# Regards, Adam -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Christian van der Plaat Sent: Wednesday, 8 January 2003 1:34 PM To: CFAussie Mailing List Subject: [cfaussie] RE: Multiple Updates in forms Thanks for your help, I am nearly there but I just cant seem to get the action page to work. For the display page I am using: ======================== <form name="form1" method="post" action="testprice2.cfm"> <cfloop query="gtProds"> <cfoutput> <cfset totrows = #currentrow#> #gtProds.prodID# <input type="text" name="field_#currentrow#" value="#Trim(gtProds.RetailPrice)#"> <input type="hidden" name="prodID_#currentrow#" value="#gtProds.prodID#"> <BR> </cfoutput> </cfloop> <input type="submit" name="Submit" value="Update"> <input name="totrows" type="hidden" id="totrows" value="<cfoutput>#totrows#</cfoutput>"> </form> ======================= For the Action page I am using ======================= <cfloop from=1 to=#form.totrows# index="i"> <cfquery datasource="timber"> Update Product SET RetailPrice=#form["field_#i#"]# WERE prodID=#form["prodID_#i#"]# </cfquery> </cfloop> ================== I get the error ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '4.0000 WERE prodID=142'. ================= It should work, I cant figure out why its not. Any ideas? Thank you Christian van der Plaat Advanced Web Designs - IT3 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Onnis Sent: Wednesday, 8 January 2003 12:03 PM To: CFAussie Mailing List Subject: [cfaussie] RE: Multiple Updates in forms I wouldnt do this bcause when your looking at large forms, you will end up createing more HTML for the browser to render, thus the page taking longer to display, and also giving more work to the CF server aswell to produce the HTML for the page. <cfloop query="myQuery"> <input type="text" name="field_#currentrow#" value="#price#"> <input type="hidden" name="priceID_#currentrow#" value="#priceID#"> </cfloop> Regards Steve Onnis Domain Concept Designs +61 422 337 685 +61 3 9444 7504 http://www.domainconceptdesigns.com <http://www.domainconceptdesigns.com> ("If you think it can't be done, you haven't asked me!") - Steve Onnis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adam Chapman Sent: Wednesday, January 08, 2003 11:45 AM To: CFAussie Mailing List Subject: [cfaussie] RE: Multiple Updates in forms Well i agree with you on the Evaluate() issue.. but like i said "Below is a very crude example" But i dont agree that using the "CurrentRow" like this isnt very good. Why not just <cfloop query="myQuery"> <input type="text" name="field_#currentrow#" value="#price#"> <input type="hidden" name="priceID_#currentrow#" value="#priceID#"> </cfloop> then (note the use of one query.. hopefully your chosen database supports this..) <cfquery> <cfloop from=1 to=#form.priceCount# index="i"> UPDATE Prices SET Price = #form["field_#i#"]# WHERE PriceID = #form["priceID_#i#"]#; </cfloop> </cfquery> Horses for courses.. one could argue that list processing is slow? Regards, Adam -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Onnis Sent: Wednesday, 8 January 2003 11:33 AM To: CFAussie Mailing List Subject: [cfaussie] RE: Multiple Updates in forms Firstly, apparently you shouldnt use Evaluate() cause it takes longer to process. I would use this ------------------- <cfoutput> <cfloop from=1 to=#form.priceCount# index="i"> #form["field_#i#"]#<br> </cfloop> </cfoutput> ------------------ Secondly, using the "CurrentRow" like this isnt very good. You have no way of knowing what row to update in your when you run your action.cfm script. I would suggest using a unique ID from the query and pass that list if IDs to the action form like this -------------------------------------------------------------- <cfoutput> <form name="myForm" action="action.cfm"> <input name="priceIDs" type=hidden value="#ValueList(myQuery.TableID)#"> <cfloop query="myQuery"> <input type="text" name="field_#TableID#" value="#price#"> </cfloop> </form> </cfoutput> -------------------------------------------------------------- This way when you do your update you can refernce a specif field in your query to update ------------------------------------------- <cfloop list="#form.priceIDs#" index="id"> <cfquery> UPDATE Prices SET Price = #form["field_#id#"]# WHERE PriceID = #id# </cfquery> </cfloop> Right idea though Regards Steve Onnis Domain Concept Designs +61 422 337 685 +61 3 9444 7504 http://www.domainconceptdesigns.com <http://www.domainconceptdesigns.com> ("If you think it can't be done, you haven't asked me!") - Steve Onnis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adam Chapman Sent: Wednesday, January 08, 2003 11:12 AM To: CFAussie Mailing List Subject: [cfaussie] RE: Multiple Updates in forms Hi Christian, If you dynamically name your form fields you can so this quite easily. Below is a very crude example. form page --------- <cfoutput> <form name="myForm" action="action.cfm"> <input name="priceCount" type=hidden value="#myQuery.recordcount#"> <cfloop query="myQuery"> <input type="text" name="field_#currentrwo#" value="#price#"> </cfloop> </form> </cfoutput> action.cfm ----------- <cfoutput> <cfloop from=1 to=#form.priceCount# index="i"> #Evaluate("form.field_#i#")#<br> </cfloop> </cfoutput> Regards, Adam Chapman Virtualtours.com.au mailto:[EMAIL PROTECTED] Phone: 1300 366 122 (Int: +61 3 9720 5733) Fax: +61 3 9720 6377) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Christian van der Plaat Sent: Wednesday, 8 January 2003 11:00 AM To: CFAussie Mailing List Subject: [cfaussie] Multiple Updates in forms I have a client that want to be able to update the prices in a category, the hard part is he wants all the prices listed on one page in text boxes so he can update the 20 or so prices for that category by clicking on the one submit button so the form will then update the 20 database listings rather than updating one field at a time. How can I do this? I saw it in Coldfusionjournal.com some where but I can not find it. Thank you Christian van der Plaat Advanced Web Designs - IT3 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
