CF tags are not case sensitive and common practice is to have them all lower case.
1) <cfset SESSION.LocationName = #ckCreds.LocationName#> For purposes of style and assumed functionality: <cfset SESSION.LocationName = ckCreds.LocationName> 2) You are missing a # symbol by the word application: <cfquery name="ckCreds" datasource="Application.dsn#"> should be <cfquery name="ckCreds" datasource="#application.dsn#"> 3) For: WHERE LocationID = <Cfqueryparam cfsqltype="cf_sql_varchar"value="#form.user#"> Is the locationID column an integer in your database or a varchar? If it is an integer: WHERE LocationID = <Cfqueryparam cfsqltype="cf_sql_integer"value="#form.user#"> Teddy On 11/15/06, Jason T. Slack <[EMAIL PROTECTED]> wrote: > > Hi Rick, > > Yeah that put me further along in the process. > > Now I get: > > The tag CFQUERY had no corresponding ending tag > Source > > 20: <cfelse> > 21: <!--- login failed ---> > 22: <cflocation url="index.cfm" /> > 23: </cfif> > > ^ Snippet from underlying CFML source > > Here is the full code: > > <!--- Check Locations table first to see if the location id and > password is right---> > <cfquery name="ckCreds" datasource="Application.dsn#"> > SELECT LocationID, LocationName FROM Locations > WHERE LocationID = <Cfqueryparam cfsqltype="cf_sql_varchar" > value="#form.user#"> > AND LocationPassword = <cfqueryparam cfsqltype="cf_sql_varchar" > value="#form.password#">; > </cfquery> > > <cfif ckCreds.recordCount EQ 1> > <!--- successful login ---> > > <cfset SESSION.LocationID = #ckCreds.LocationID#> > <cfset SESSION.LocationName = #ckCreds.LocationName#> > > <cfset SESSION.CurrentUser=""> > > <cflocation url="main.cfm" /> > <cfelse> > <!--- login failed ---> > <cflocation url="index.cfm" /> > </cfif> > > Do my CF tags need to have proper capitalization? I thought I could > do it all lowercase as described in CF WACK. > > -Jason > > > On Nov 15, 2006, at 9:12 AM, Rick Root wrote: > > > Check the case of the FILENAME for Application.cfm - make sure it > > has a > > capital "A" - it apparently makes a difference on unix type machines. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260499 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
