<html>
<font size=3>Sean, if I understand what you are trying to do, you want to
pass a query variable as an "argument" to a Module and
manipulate variables in the caller's scope using the data in that query.
You want to create a new variable in the scope caller.attributes that has
the same name as the query passed into the Module, and is a copy of that
query...<br>
<br>
I can think of several easier ways to do this than the way you are trying
to doing it:<br>
<br>
1) Pass the query's NAME into the module instead of the query itself.
Then your variable names are <br>
evaluate("caller.#qname#") and
evaluate("caller.attributes.#qname#").<br>
By the way... I don't know if 'caller' gives you access to the calling
program's local variables scope or if it gives you access to ALL of the
caller's scopes, like 'attributes'. You'll have to experiment with that.
If not, you're out of luck.<br>
<br>
2) Use an include that can more easily manipulate the variables in that
scope (because an include is in the same scope as the caller)<br>
<br>
<br>
At 12:57 PM 8/10/00 +1000, Scott, Andrew wrote:<br>
<blockquote type=cite cite>The way I understand the question, if you wish
to refer to the query outside<br>
of the server (cgi variables) it would need to be passed along the url.
cgi<br>
variables are hardcoded variables that come from the server, I am not
sure<br>
what Sean you are trying to do. Maybe if you explained what it is you
are<br>
trying to achieve someone here could help you out a bit.<br>
<br>
<br>
regards<br>
<br>
Andrea Scott<br>
ANZ eCommerce Centre<br>
* Ph 9273 0693 <br>
* [EMAIL PROTECTED]<br>
<br>
<br>
-----Original Message-----<br>
From: Norman Elton
[<a href="mailto:[EMAIL PROTECTED]" eudora="autourl">mailto:[EMAIL PROTECTED]</a>]<br>
Sent: 10 August 2000 12:27<br>
To: [EMAIL PROTECTED]<br>
Subject: RE: Is there a variable for a query's name?<br>
<br>
<br>
I'm afraid I might not understand your question, but as I understand it,
you<br>
want to return the value specified as the Name="..." in a
CFQUERY?<br>
<br>
Well, in order to process something like "MyQuery.QueryName",
wouldn't you<br>
already know that the query's name is "MyQuery"? The object's
name is the<br>
anchor for all the other attributes such as RecordCount and ColumnList,
etc.<br>
If you don't already know the name, it's awfully hard to refer to
the<br>
object.<br>
<br>
Hope this helps. If not, reply!<br>
<br>
Norman Elton<br>
Information Technology<br>
College of William & Mary<br>
<br>
-----Original Message-----<br>
From: Sean Renet
[<a href="mailto:[EMAIL PROTECTED]"
eudora="autourl">mailto:[EMAIL PROTECTED]</a>]<br>
Sent: Wednesday, August 09, 2000 8:36 PM<br>
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];<br>
[EMAIL PROTECTED]<br>
Subject: Re: Is there a variable for a query's name?<br>
<br>
<br>
No that's not what I meant. What I meant was a cgi variable for the
query's<br>
name like myquery.columnlist gives you the query's column list and<br>
myquery.recordcount gives you the query's record count. I want a
cgi<br>
variable for the query's name like myquery.queryname<br>
----- Original Message -----<br>
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]><br>
To: <[EMAIL PROTECTED]><br>
Sent: Wednesday, August 09, 2000 3:14 AM<br>
Subject: RE: Is there a variable for a query's name?<br>
<br>
<br>
> > I am trying to make a tag that changes the scope of a query to
the<br>
> > attributes scope.<br>
> ><br>
> > I want to tagify...<br>
> > <cfloop index = "i"
list="#RETAILER_INFO.columnlist#"><br>
> > <CFSET temp = SetVariable("attributes.#i#",<br>
> > evaluate("RETAILER_INFO.#i#"))><br>
> > </cfloop><br>
> ><br>
> > so what I want to do is...<br>
> ><br>
> > <cfloop index = "i"
list="#caller.somequery.columnlist#"><br>
> > <CFSET SetVariable("caller.attributes.#i#",
evaluate("somequery.#i#"))><br>
> > </cfloop><br>
> ><br>
> > Is there a variable for the query's name? There has to be
one,<br>
debugging<br>
> > lists the names of the queries...<br>
><br>
> As this hasn't been answered for a couple of days (and I'm just
catching<br>
up<br>
> on emails)...<br>
><br>
> You can use a variable name and Evaluate;<br>
> <cfloop index = "i"
list="#Evaluate("#caller.somequery#.columnlist")#"><br>
> <CFSET SetVariable("caller.attributes.#i#",<br>
> evaluate("#caller.somequery#.#i#"))><br>
> </cfloop><br>
><br>
> I'm not sure about the multiple scoping on caller.attributes. but
the<br>
query<br>
> name should work<br>
><br>
> Philip Arnold<br>
> ASP Multimedia Limited<br>
> T: +44 (0)20 8680 1133<br>
><br>
> "Websites for the real world"<br>
><br>
>
**********************************************************************<br>
> This email and any files transmitted with it are confidential
and<br>
> intended solely for the use of the individual or entity to whom
they<br>
> are addressed. If you have received this email in error please
notify<br>
> the system manager.<br>
>
**********************************************************************<br>
><br>
><br>
>
--------------------------------------------------------------------------<br>
----<br>
> Archives:
<a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"
eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/</a><br>
> To Unsubscribe visit<br>
<a href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or<br>
send a message to [EMAIL PROTECTED] with 'unsubscribe' in<br>
the body.<br>
><br>
<br>
----------------------------------------------------------------------------<br>
--<br>
Archives: <a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"
eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/</a><br>
To Unsubscribe visit<br>
<a href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or<br>
send a message to [EMAIL PROTECTED] with 'unsubscribe' in<br>
the body.<br>
<br>
----------------------------------------------------------------------------<br>
--<br>
Archives: <a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"
eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/</a><br>
To Unsubscribe visit<br>
<a href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or<br>
send a message to [EMAIL PROTECTED] with 'unsubscribe' in<br>
the body.<br>
------------------------------------------------------------------------------<br>
Archives: <a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"
eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/</a><br>
To Unsubscribe visit <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body. </font></blockquote><br>
<br>
-<font
size=3>--------------------------------------------------------------------------<br>
Peter Theobald, Chief Technology Officer<br>
LiquidStreaming <a href="http://www.liquidstreaming.com/"
eudora="autourl">http://www.liquidstreaming.com</a><br>
[EMAIL PROTECTED]<br>
Phone 1.212.545.1232 Fax 1.212.679.8032<br>
</font></html>
------------------------------------------------------------------------------
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.
