Personal perference I guess... I was hoping only to break out the SQL, so that within the main code I can tell it called a CFQuery : ) At 08:10 AM 11/18/00 +0000, you wrote: >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/[email protected]/ > >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/[email protected]/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > >-=-=- >SBG-Priority: 3 (Normal) http://www.internz.com/SpamBeGone/ -- 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
