Ooops, don't need the second set of []... That's just for value references, I didn't realize the ValueList was being called (my bad).
....................... Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 212.691.3477 fax www.nylontechnology.com "You know, like nunchuck skills, bowhunting skills, computer hacking skills... Girls only want boyfriends who have great skills." - Napoleon Dynamite -----Original Message----- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Thursday, May 25, 2006 10:25 AM To: CF-Talk Subject: RE: Rid Evaluate Cutter, Queries can be reference like structures: listfindnocase( valuelist( alreadyMatched["alias#arguments.field#"][ alreadyMatched.CurrentRow ] ), I ) ........................ Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 212.691.3477 fax www.nylontechnology.com "You know, like nunchuck skills, bowhunting skills, computer hacking skills... Girls only want boyfriends who have great skills." - Napoleon Dynamite -----Original Message----- From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] Sent: Thursday, May 25, 2006 10:18 AM To: CF-Talk Subject: Rid Evaluate Trying to figure out the best way to remove 'evaluate' from these expressions: <cfquery name="alreadyMatched" datasource="#application.dsn.DS2#"> select alias#arguments.field# From dbo.#arguments.field#AliasDefault Where alias#arguments.field# in (#listqualify(arraytolist(arguments.matched),"'")#) and fkCDModels = #arguments.modelID# and default#arguments.field# = '#arguments.default#' </cfquery> <cfloop list="#arraytolist(matched)#" index="i"> <cfif listfindnocase(valuelist(Evaluate("alreadyMatched.alias#arguments.field#")), i) EQ 0> <cfif listfindnocase(valuelist(Evaluate("alreadyMatchedToModel.alias#arguments.fie ld#")),i) EQ 0> ........ Cutter ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241450 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
