no #. in setting a variable, literal strings go in quotes. if the value isn't in quotes, CF reads/evaluates it as a variable.
CF arrays start at 1. On Fri, 22 Oct 2004 09:18:28 -0500, G <[EMAIL PROTECTED]> wrote: > 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 > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182326 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
