Thanks for all the help everyone, Marc in particular. Arun.
-----Original Message----- From: Marc Campeau [mailto:[EMAIL PROTECTED]] Sent: April 11, 2002 4:59 PM To: [EMAIL PROTECTED] Subject: RE: [CFTALKTor] Update FAQ: data type problem Do this: 1) Leave OrderNum as an int. 2) Change update to: <CFLOOP index="id" list="#faqID#"> <CFQUERY NAME="updateOrder" DATASOURCE="db"> UPDATE faq SET orderNum = #evaluate( "orderNum#ID#" )# WHERE faqID = '#ID#' </CFQUERY> </CFLOOP> 3) Change Form to: <cfoutput> <form name="form#faqID#" action="updateFaq.cfm" method="post"> </cfoutput> <cfoutput query="orderCount"> <input type="hidden" name="faqID" value="#faqID#"> <input type="text" name="orderNum#faqID#" size="5" maxlength="30" value="#orderNum#"> </cfoutput> <cfoutput> <input type="submit" value="Change Order"> </form> </cfoutput> You'll be able to change all them at once this way. Hope this helps... Marc - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Marc Campeau" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Arun Persaud" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
