On Thu, Jul 17, 2008 at 10:00 AM, Ian Skinner <[EMAIL PROTECTED]> wrote: > Don't use isDefined() here, or most places for that matter, it does the > ColdFusion Scope Search and that is what is killing your code. > > Try structKeyExists() instead. > > I.E. <cfif structKeyExists(url,'somevar')>...</cfif> > > This should not get confused by the url columns in the record set.
Actually, it does. coldfusion still checks the query scope first. <cftry> <cfset foo = queryNew("id,url","integer,varchar")> <cfset QueryAddRow(foo)> <cfset querySetCell(foo,"id",1)> <cfset querySetCell(foo,"url","http://www.houseoffusion.com")> <cfloop query="foo"> <cfif structKeyExists(url,"bar")>url.bar exists!</cfif> <cfdump var="#url.bar#"> </cfloop> <cfcatch type="any"><cfdump var="#cfcatch#"></cfcatch> </cftry> This generates the dereferencing error on the structKeyExists line ... because it's looking at url in the query, not the url scope. Rick -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309220 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4