Forums
This topic is locked
Problem with form and processing form
Posted 08 May 2005 20:36:32
1
has voted
08 May 2005 20:36:32 Keith Shapiro posted:
I have a login script thats action is POST and it sends a customer number (ex. 0505A10001) and a password of text.on the processing page I have this code
<cfquery name="Recordset1" datasource="exoduspw">
SELECT cus_num, publication
FROM customerpw
where cus_num = '#form.cus_num#'
and password = '#form.password#'
</cfquery>
then it goes here to redirect the the user if succesfully logged in to a page thats spelled out in the users record
<cfif Recordset1.RecordCount>
<!--- if the user is found redirect to their page --->
<cfset Session.publication = #Recordset1.publication#>
<cflocation url="#Recordset1.publication#">
<cfelse>
<!--- if the user is not found redirect back to login pge --->
<cflocation url="Login.cfm">
</cfif>
Now this works locally but not on my server. However it didn't work locally until I added the form variables to the bindings panel. Once I added them, it worked locally. On the ISP server I'm getting
Element cus_num not defined in FORM
Any help would be greatly appreciated. I have to have this working by monday morning and I'm freakin out