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)
