Not sure if this addressed the problem, but I routinely pass queries into
modules as variables.  For example:


>From index.cfm
<!--- Basic  FuseAction list for Rezepte --->
<cfswitch expression="#attributes.fuseaction#">
      <cfcase value="KGShowHomeSite">
        <!--- Get the list of all records from Rezept table --->
        <cfmodule template="../queries/kochen/qry_RezepteList.cfm"
          as_ReturnVariableName = "qry_RezepteList">

        <!--- Display the list of Rezept records --->
        <cf_dsp_KochenHomeSite
          aqry_QueryResult = #qry_RezepteList#>
        </cfcase>

Then in dsp_KochenHomeSite.cfm, you can refer to
Attributes.aqry_QueryResult.ColumnName

I am assuming that CF just adds more pointers to the query object in the
scope of the module; the alternative is that CF copies the query structure
itself.  If your query returns a large number of results, looking into this
would be worthwhile.

Mit freundlichen Gr��en

Scott Talsma
team in medias GmbH
0241-470336-25
http://www.inmedias.de
http://e-commerce.inmedias.de
http://beratung.inmedias.de

***************************
Unsere aktuellen Projekte

mit Kurzerl�uterung:
http://www.inmedias.de/referenz

oder direkt:
http://www.misereor.de
http://www.designermode.com
http://www.debeka.de
http://www.nesseler.de
****************************


-----Original Message-----
From: Sean Renet [mailto:[EMAIL PROTECTED]]
Sent: Montag, 7. August 2000 10:12
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: 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...

----------------------------------------------------------------------------
--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

------------------------------------------------------------------------------
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to