Name the include file something along the lines of "qryUserDupeCheck.cfm"
-----Original Message-----
From: Michael She [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 19, 2000 6:46 AM
To: CF-Talk
Subject: Re: CFincludes and SQL Queries <-SIMPLE QUESTION! (update to
last q)
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/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
>
>-=-=-
>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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
