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 +, 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
RE: CFincludes and SQL Queries -SIMPLE QUESTION! (update to last q)
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 +, 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
Re: CFincludes and SQL Queries -SIMPLE QUESTION! (update to last q)
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
CFincludes and SQL Queries -SIMPLE QUESTION! (update to last q)
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