SET column = <cfqueryparam value="#QueryName['fieldName' & index][1]#" cfsqltype="cf_sql_correcttypehere">
CF starts counting at 1 > -----Original Message----- > From: G [mailto:[EMAIL PROTECTED] > Sent: 22 October 2004 16:18 > To: CF-Talk > Subject: Re: Quick syntax reminder, no Evaluate! > > 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:182330 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