http://www.webtricks.com/sourcecode/code.cfm?CodeID=6
She uses Evaluate in the query. Is there a way to do this without using
the dreaded function?
<!--- Loop through the form fields and update the table. --->
<cfloop from="1" to="#NumRecords#" index="ThisRow">
<cfquery datasource="#Request.App.DS#">
UPDATE MultiUpdate
SET Name='#Evaluate("Name" & ThisRow)#',
Nickname='#Evaluate("Nickname" & ThisRow)#'
WHERE ID=#Evaluate("ID" & ThisRow)#
</cfquery>
</cfloop>
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
[EMAIL PROTECTED]
"There is no right price for the wrong product, even if it is
inexpensive and delivered on time."
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
