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