Thanks all..........no # signs anywhere in this statement? It appears on the right side of an equals sign in a query block....
<cfquery> UPDATE .... SET column = QueryName["fieldName" & index][1] </cfquery> Also, query always returns one row....CF array start at 0 or 1? Thanks again... BG ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, October 22, 2004 9:09 AM Subject: Re: Quick syntax reminder, no Evaluate! > sorry - left an extra quote in there by accident. Should be: > QueryName["queryField_" & number][rowNum] > > ~Simon > > > > > Need a quick reminder: > > > > Looping over a list of numbers. Each number completes the name of a query > field (ie queryField_1, queryField_2, etc...). > > > > What's the best syntax for evaluating "queryField_#number#" ?? Can't i use > array syntax here in some capacity, something like QueryName > ["queryField_#number#"]? > > > > TIA, > > > > Brian > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182324 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
