I'm afraid I might not understand your question, but as I understand it, you
want to return the value specified as the Name="..." in a CFQUERY?
Well, in order to process something like "MyQuery.QueryName", wouldn't you
already know that the query's name is "MyQuery"? The object's name is the
anchor for all the other attributes such as RecordCount and ColumnList, etc.
If you don't already know the name, it's awfully hard to refer to the
object.
Hope this helps. If not, reply!
Norman Elton
Information Technology
College of William & Mary
-----Original Message-----
From: Sean Renet [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 09, 2000 8:36 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: Is there a variable for a query's name?
No that's not what I meant. What I meant was a cgi variable for the query's
name like myquery.columnlist gives you the query's column list and
myquery.recordcount gives you the query's record count. I want a cgi
variable for the query's name like myquery.queryname
----- Original Message -----
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 09, 2000 3:14 AM
Subject: RE: Is there a variable for a query's name?
> > I am trying to make a tag that changes the scope of a query to the
> > attributes scope.
> >
> > I want to tagify...
> > <cfloop index = "i" list="#RETAILER_INFO.columnlist#">
> > <CFSET temp = SetVariable("attributes.#i#",
> > evaluate("RETAILER_INFO.#i#"))>
> > </cfloop>
> >
> > so what I want to do is...
> >
> > <cfloop index = "i" list="#caller.somequery.columnlist#">
> > <CFSET SetVariable("caller.attributes.#i#", evaluate("somequery.#i#"))>
> > </cfloop>
> >
> > Is there a variable for the query's name? There has to be one,
debugging
> > lists the names of the queries...
>
> As this hasn't been answered for a couple of days (and I'm just catching
up
> on emails)...
>
> You can use a variable name and Evaluate;
> <cfloop index = "i" list="#Evaluate("#caller.somequery#.columnlist")#">
> <CFSET SetVariable("caller.attributes.#i#",
> evaluate("#caller.somequery#.#i#"))>
> </cfloop>
>
> I'm not sure about the multiple scoping on caller.attributes. but the
query
> name should work
>
> Philip Arnold
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **********************************************************************
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
