Sorry as I havent been reading into this topic of the list, With that in 
mind why cant you just put the entire query inside the cfinclude file???


>From: Michael She <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: CFincludes and SQL Queries <-SIMPLE QUESTION! (update to last  q)
>Date: Fri, 17 Nov 2000 08:30:03 -0500
>
>If I embed a SQL query inside a CFQUERY my variables don't get processed:
>
>    <cfquery name="UserDupeCheck" datasource="#Application.Datasource#"
>dbtype="ODBC">
>      <cfinclude 
>template="/Includes/SQL/Registration/SelectUserDupeCheck.cfm">
>    </cfquery>
>
>
>The query is:
>
>Select Username
>  From Users
>Where Username = '#form.username#'
>
>
>The variable #form.username# is not being processed.  Is this normal, or am
>I doing something wrong?
>
>If I put the whole query inside the CFQuery tag (no include) it works fine.
>--
>Michael She
>I m a g i n e   C o m m u n i c a t i o n s
>Company E-mail: [EMAIL PROTECTED]
>Personal E-mail: [EMAIL PROTECTED]
>ICQ UIN: #243466
>Personal Homepage: http://www.michaelshe.com (Under Construction)
>Imagine Communications: http://www.imagineer.net
>PGP Fingerprint: 9A24 1DA9 39B8 0A0C C5ED 6E5D 45E9 075A 51CD 66A1
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Structure your ColdFusion code with Fusebox. Get the official book at 
>http://www.fusionauthority.com/bkinfo.cfm
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to