CFMODULE DELIMA

[Tom Schreck]

I’ve tried using cfmodule to call a query from a centralized location, but my query was picking up Attribute values that are present at the time of the call to the cfmodule, but were not passed into the cfmodule.  Here’s a snippet on how I structure my queries:     <cfparam name=”Attribute.numVariableID” default=”0”>     <cfquery>             SELECT * from TableName             WHERE 0=0             <cfif Attribute.numVariableID GT 0>                         AND TableName.numVariableID = # Attribute.numVariableID # </cfif>   </cfquery>   So, I’m CFMODULE-ing a call for this query and not passing numVariableID to the query call.  The variable is present at the time of the cfmodule call, but not being passed.  Somehow the cfmodule recognizes the variable and includes it in the query execution.  The query is stored in a different circuit all together.  To get around this, I have to place the query in each circuit.  The kicker is I can still use cfmodule to call the query, but since it’s in the same circuit there’s no problem.  I run into problems when I cfmodule to a different circuit.  Any help/suggestions on this would be appreciated.    Does anyone have any FuseQ examples?  I’m looking at how to best manage have my query files in 1 location versus copying them into each circuit.     Thanks -   Tom Schreck 817-252-4900 [EMAIL PROTECTED]   I have not failed.  I've found 10,000 ways that won't work.   - Thomas Edison   ==^================================================================ This email was sent to: archive@jab.org EASY UNSUBSCRIBE click here: http://topica.com/u/?bUrFMa.bV0Kx9 Or send an email to: [EMAIL PROTECTED] T O P I C A -- Register now to manage your mail! http://www.topica.com/partner/tag02/register ==^================================================================