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:260498
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
