Today is my first day with CF.
I am trying to create a login procedure. I have MySQL setup and
created a DSN.
I am trying to run:
<cfquery name="ckCreds" datasource="#MyDSN#">
SELECT LocationName FROM
WHERE LocationID = '#form.user#'
AND LocationPassword = '#form.password#';
</cfquery>
<cfif ckCreds.recordCount EQ 1>
<!--- successful login -->
<CFAPPLICATION NAME="mysession" SESSIONMANAGEMENT="Yes"
SESSIONTIMEOUT="#CreateTimeSpan(0, 0, 20, 0)#">
]
<cflocation url="main.cfm" />
<cfelse>
<!--- login failed -->
<cflocation url="index.cfm" />
</cfif>
and I am getting an error that states:
Invalid token '>' found on line 18 at column 8.
But that specific place is a blank space.
I dont see what I am doing wrong so far.
I just bought Ben Forta's book yesterday, good read so far.
-Jason
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:259981
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4