The way I understand the question, if you wish to refer to the query outside
of the server (cgi variables) it would need to be passed along the url. cgi
variables are hardcoded variables that come from the server, I am not sure
what Sean you are trying to do. Maybe if you explained what it is you are
trying to achieve someone here could help you out a bit.
regards
Andrea Scott
ANZ eCommerce Centre
* Ph 9273 0693
* [EMAIL PROTECTED]
-----Original Message-----
From: Norman Elton [mailto:[EMAIL PROTECTED]]
Sent: 10 August 2000 12:27
To: [EMAIL PROTECTED]
Subject: RE: Is there a variable for a query's name?
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/[email protected]/
> 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/[email protected]/
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/[email protected]/
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/[email protected]/
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.
