Re: Too Few Parameters, expected 1
Nick, you seem to be ignoring the vast majority of the comments, and then changing your query every time you respond. We can't help if you don't follow the thread. Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Too Few Parameters, expected 1
ENTERED AN EARLIER POST ON THIS SAME QUERY PROBLEM. ORIGINALLY IT WAS A SYNTAX PROBLEM. HOWEVER, NOW I AM GETTING THE FOLLOWING ERROR. THIS IS A SIMPLE LOGIN APPLICATION. Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. The error occurred in C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginCheck.cfm: line 19 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm.cfm: line 206 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\PrivateAccess\Application.cfm: line 17 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginCheck.cfm: line 19 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm.cfm: line 206 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\PrivateAccess\Application.cfm: line 17 17 :SELECT * 18 : FROM Users 19 : WHERE UserLogin = '#Form.UserLogin#' AND Password = '#Form.Password#' 20 : /cfquery 21 : SQLSELECT * FROM Users WHERE UserLogin = 'paulw' AND Password = 'PPMILL' DATASOURCERickRossiter VENDORERRORCODE -3010 SQLSTATE 07002 Resources: * Check the ColdFusion documentation to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.11) Gecko/20071127 Firefox/2.0.0.11 CODE SOURCE: PROCESS BEGINS IN (application.cfm) WHEN USER ENTERS SECTION OF SITE REQUIRING A LOGIN: (application.cfm) !---If user is not logged in force them to log in--- cfif NOT isDefined(SESSION.Auth.IsLoggedIn) !---If the user is now submitting login action via login form--- !---Include Login Check code to validate the user attempting to log in.--- cfinclude template=../Templates/loginForm.cfm cfabort /cfif NEXT THE USER IS PROMPTED TO THE LOGIN PAGE: cfif isDefined(form.UserLogin) cfinclude template=loginCheck.cfm /cfif span class=HeaderEnter Access Code/span br cfform action=../PrivateAccess/showAR.cfm Name=LoginForm method=post input type=hidden name=UserLogin_required input type=hidden name=Password_required !---userLogin Field is required--- User Name: cfinput type=text name=UserLogin size=20 value= maxlength=24 required=yes message=Please enter your user name. Thank you. style=height:14px; width:125px; font-size:12px; font-weight:bold; color: maroon; letter-spacing:0.2em; text-align:left; pnbsp;/ppnbsp;/p Password: cfinput type=password name=Password size=24 value= maxlength=24 required=yes message=Please enter your assigned password to access this part of the site. Thank you. style=height:14px; width:125px; font-size:12px; font-weight:bold; color: maroon; letter-spacing:0.2em; text-align:left cfinput type=submit name=Enter /cfform WHICH IS CHECKED BY THE FOLLOWING CODE: !---The following code queries the database to find the record of the user's password.--- cfparam name=Form.UserLogin type=string cfparam name=Form.Password type=string cfquery name=getUser datasource=#dsn# SELECT * FROM Users WHERE UserLogin = '#Form.UserLogin#' AND Password = '#Form.Password#' /cfquery !--- If the user's password is correct the following code verifies it and obtains the information then creates a distinct session for each user that logs in. --- cfif getUser.RecordCount EQ 1 cflocation url=../PrivateAccess/showAR.cfm !--- The following code remembers the user's logged-in status their user type and their first name in the session structure. --- cfset SESSION.Auth = StructNew() cfset SESSION.Auth.IsLoggedIn = yes cfset SESSION.Auth.userID = getUser.userID cfset SESSION.Auth.FirstName = getUser.FirstName !--- Now that user is logged in, the following code sends them to PrivateAccess/showAR.cfm page and menu links. --- cflocation url=#CGI.SCRIPT_NAME# /cfif AS YOU CAN SEE THE QUERY IS PULLING THE DATA FROM THE DATABASE, BUT THROWING THIS ERROR MESSAGE. I TURNED ON DEBUGGING BUT THIS DID NOT REVEAL ANYTHING MORE THAN THE ORIGINAL ERROR MESSAGE. USING DREAMWEAVER 8 AND CFMX SERVERS. IF ANYONE CAN EXPLAIN THIS I SURE WOULD APPRECIATE IT. NICK [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297154 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user
Re: Too Few Parameters, expected 1
Too few parameters. Expected 1 This usually means that one of the column names is erroneous. Password might also be a reserved word. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297196 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Too Few Parameters, expected 1
On Jan 23, 2008 9:47 AM, Nick Ross [EMAIL PROTECTED] wrote: ENTERED AN EARLIER POST ON THIS SAME QUERY PROBLEM. ORIGINALLY IT WAS A SYNTAX PROBLEM. HOWEVER, NOW I AM GETTING THE FOLLOWING ERROR. THIS IS A SIMPLE LOGIN APPLICATION. 1) no need to shout 2) i already responded to the other thread 3) really no need to maintain 2 separate threads for the same problem, right? -- Scientists tell us that the fastest animal on earth, with a top speed of 120 feet per second, is a cow that has been dropped out of a helicopter. - Dave Barry ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297208 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Too Few Parameters, expected 1
Yes I did and thank you very much. However, it did not work. See my latest
post. I decided to try something real simple and got a different error message:
Element ACCESSCODE is undefined in FORM.
The error occurred in
C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm.cfm: line 215
213 : SELECT Password, FirstName, userID
214 : FROM Users
215 : WHERE (#form.accessCode# = password)
216 : /cfquery
217 :
the form generating this is:
cfquery name=getUser datasource=#dsn#
SELECT Password, FirstName, userID
FROM Users
WHERE (#form.accessCode# = password)
/cfquery
cfform name=siteAccess action=siteAccessLogin.cfm?userIP=#REMOTE_ADDR#
method=post
input type=hidden name=accessCode
cfinput type=password maxlength=25 name=accessCode value=
style={height:24px; font-size:10px; font-weight:bold; color: blue;
letter-spacing:0.2em; padding-top:5px; padding-left:2px}
cfinput type=submit name=accessCode label=Enter Access Code---
/cfform
I made all the necessary changes in the database and used non-app specific
labels so as not to confuse Access. Any ideas. Just a note: my caps lock was
stuck on and I didn't realize it. I was not angry or frustrated :)
Nick
Did you try what I said? Here it is again in case it didn't send.
Try using this query (add square brackets around the database object names
and use CFQUERYPARAM!):
SELECT *
FROM [Users]
WHERE [UserLogin] = cfqueryparam cfsqltype=cf_sql_varchar
value=#Form.UserLogin#
AND [Password] = cfqueryparam cfsqltype=cf_sql_varchar
value=#Form.Password#
If that works then the reason is that one of the database object names
(column names, table names, etc) was the same as an Access function
name/reserved word or some-such.
Let me know how it goes.
Dominic
p.s. please don't use caps all the time, you may be in a foul mood (we've
all been there) - but don't take it out on us!
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297216
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Too Few Parameters, expected 1
You probably only need the square brackets around the reserved word. Of course it would be better not to use it at all. I notice from the posts on the other thread that you changed the table column names Nick, and still got an error, albeit slightly different. In my experience the error you got indicates the fields can't exist in the db, or that they are numeric - have you tried removing the '' from the query and or double checking the datatypes in the database: SELECT * 18 : FROM Users 19 : WHERE UserLogin = #Form.UserLogin# AND UserPwd = #Form.UserPwd# Also, I know it sounds funny, but check the database you are editing is the correct one for the datasource you are using. I beat my head against a wall for ages with a similar problem years ago, and it turned out I was looking at the wrong database. I never made that mistake again. Cheers Will -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: 23 January 2008 21:14 To: CF-Talk Subject: Re: Too Few Parameters, expected 1 Did you try what I said? Here it is again in case it didn't send. Try using this query (add square brackets around the database object names and use CFQUERYPARAM!): SELECT * FROM [Users] WHERE [UserLogin] = cfqueryparam cfsqltype=cf_sql_varchar value=#Form.UserLogin# AND [Password] = cfqueryparam cfsqltype=cf_sql_varchar value=#Form.Password# If that works then the reason is that one of the database object names (column names, table names, etc) was the same as an Access function name/reserved word or some-such. Let me know how it goes. Dominic p.s. please don't use caps all the time, you may be in a foul mood (we've all been there) - but don't take it out on us! On 23/01/2008, Nick Ross [EMAIL PROTECTED] wrote: ENTERED AN EARLIER POST ON THIS SAME QUERY PROBLEM. ORIGINALLY IT WAS A SYNTAX PROBLEM. HOWEVER, NOW I AM GETTING THE FOLLOWING ERROR. THIS IS A SIMPLE LOGIN APPLICATION. Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. The error occurred in C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginCheck.cfm: line 19 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm.cfm: line 206 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\PrivateAccess\Application.cfm: line 17 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginCheck.cfm: line 19 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm.cfm: line 206 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\PrivateAccess\Application.cfm: line 17 17 :SELECT * 18 : FROM Users 19 : WHERE UserLogin = '#Form.UserLogin#' AND Password = '#Form.Password#' 20 : /cfquery 21 : SQLSELECT * FROM Users WHERE UserLogin = 'paulw' AND Password = 'PPMILL' DATASOURCERickRossiter VENDORERRORCODE -3010 SQLSTATE 07002 Resources: * Check the ColdFusion documentation to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv: 1.8.1.11) Gecko/20071127 Firefox/2.0.0.11 CODE SOURCE: PROCESS BEGINS IN (application.cfm) WHEN USER ENTERS SECTION OF SITE REQUIRING A LOGIN: (application.cfm) !---If user is not logged in force them to log in--- cfif NOT isDefined(SESSION.Auth.IsLoggedIn) !---If the user is now submitting login action via login form--- !---Include Login Check code to validate the user attempting to log in.--- cfinclude template=../Templates/loginForm.cfm cfabort /cfif NEXT THE USER IS PROMPTED TO THE LOGIN PAGE: cfif isDefined(form.UserLogin) cfinclude template=loginCheck.cfm /cfif span class=HeaderEnter Access Code/span br cfform action=../PrivateAccess/showAR.cfm Name=LoginForm method=post input type=hidden name=UserLogin_required input type=hidden name=Password_required !---userLogin Field is required--- User Name: cfinput type=text name=UserLogin size=20 value= maxlength=24 required=yes message=Please enter your user name. Thank you. style=height:14px; width:125px; font-size:12px; font-weight:bold; color: maroon; letter-spacing:0.2em; text-align:left; pnbsp;/ppnbsp;/p Password: cfinput type=password name=Password size=24 value= maxlength=24 required=yes message=Please enter your assigned password to access this part of the site. Thank you. style=height:14px; width:125px; font-size:12px; font-weight:bold; color: maroon; letter-spacing:0.2em; text-align:left cfinput type=submit name=Enter /cfform WHICH IS CHECKED BY THE FOLLOWING CODE: !---The following code queries the database to find the record of the user's password.--- cfparam name=Form.UserLogin type=string cfparam name
Re: Too Few Parameters, expected 1
Did you try what I said? Here it is again in case it didn't send. Try using this query (add square brackets around the database object names and use CFQUERYPARAM!): SELECT * FROM [Users] WHERE [UserLogin] = cfqueryparam cfsqltype=cf_sql_varchar value=#Form.UserLogin# AND [Password] = cfqueryparam cfsqltype=cf_sql_varchar value=#Form.Password# If that works then the reason is that one of the database object names (column names, table names, etc) was the same as an Access function name/reserved word or some-such. Let me know how it goes. Dominic p.s. please don't use caps all the time, you may be in a foul mood (we've all been there) - but don't take it out on us! On 23/01/2008, Nick Ross [EMAIL PROTECTED] wrote: ENTERED AN EARLIER POST ON THIS SAME QUERY PROBLEM. ORIGINALLY IT WAS A SYNTAX PROBLEM. HOWEVER, NOW I AM GETTING THE FOLLOWING ERROR. THIS IS A SIMPLE LOGIN APPLICATION. Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. The error occurred in C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginCheck.cfm: line 19 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm.cfm: line 206 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\PrivateAccess\Application.cfm: line 17 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginCheck.cfm: line 19 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm.cfm: line 206 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\PrivateAccess\Application.cfm: line 17 17 :SELECT * 18 : FROM Users 19 : WHERE UserLogin = '#Form.UserLogin#' AND Password = '#Form.Password#' 20 : /cfquery 21 : SQLSELECT * FROM Users WHERE UserLogin = 'paulw' AND Password = 'PPMILL' DATASOURCERickRossiter VENDORERRORCODE -3010 SQLSTATE 07002 Resources: * Check the ColdFusion documentation to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv: 1.8.1.11) Gecko/20071127 Firefox/2.0.0.11 CODE SOURCE: PROCESS BEGINS IN (application.cfm) WHEN USER ENTERS SECTION OF SITE REQUIRING A LOGIN: (application.cfm) !---If user is not logged in force them to log in--- cfif NOT isDefined(SESSION.Auth.IsLoggedIn) !---If the user is now submitting login action via login form--- !---Include Login Check code to validate the user attempting to log in.--- cfinclude template=../Templates/loginForm.cfm cfabort /cfif NEXT THE USER IS PROMPTED TO THE LOGIN PAGE: cfif isDefined(form.UserLogin) cfinclude template=loginCheck.cfm /cfif span class=HeaderEnter Access Code/span br cfform action=../PrivateAccess/showAR.cfm Name=LoginForm method=post input type=hidden name=UserLogin_required input type=hidden name=Password_required !---userLogin Field is required--- User Name: cfinput type=text name=UserLogin size=20 value= maxlength=24 required=yes message=Please enter your user name. Thank you. style=height:14px; width:125px; font-size:12px; font-weight:bold; color: maroon; letter-spacing:0.2em; text-align:left; pnbsp;/ppnbsp;/p Password: cfinput type=password name=Password size=24 value= maxlength=24 required=yes message=Please enter your assigned password to access this part of the site. Thank you. style=height:14px; width:125px; font-size:12px; font-weight:bold; color: maroon; letter-spacing:0.2em; text-align:left cfinput type=submit name=Enter /cfform WHICH IS CHECKED BY THE FOLLOWING CODE: !---The following code queries the database to find the record of the user's password.--- cfparam name=Form.UserLogin type=string cfparam name=Form.Password type=string cfquery name=getUser datasource=#dsn# SELECT * FROM Users WHERE UserLogin = '#Form.UserLogin#' AND Password = '#Form.Password#' /cfquery !--- If the user's password is correct the following code verifies it and obtains the information then creates a distinct session for each user that logs in. --- cfif getUser.RecordCount EQ 1 cflocation url=../PrivateAccess/showAR.cfm !--- The following code remembers the user's logged-in status their user type and their first name in the session structure. --- cfset SESSION.Auth = StructNew() cfset SESSION.Auth.IsLoggedIn = yes cfset SESSION.Auth.userID = getUser.userID cfset SESSION.Auth.FirstName = getUser.FirstName !--- Now that user is logged in, the following code sends them to PrivateAccess/showAR.cfm page and menu links. --- cflocation url=#CGI.SCRIPT_NAME# /cfif AS YOU CAN SEE
Re: Too Few Parameters, expected 1
Element ACCESSCODE is undefined in FORM. Perhaps the fact that the form has 3 elements all named accessCode might cause that problem? Just a note: my caps lock was stuck on and I didn't realize it. I was not angry or frustrated :) Good to hear! As for the too few paramters thing this is odd indeed. There is clearly nothing wrong with the syntax of the SQL you are sending. Looking around it seems that using the wrong table and column names can cause this problem. Other causes are to do with explicitly typing the parameters. If the column and table names are definately correct, try using qcfqueryparam and find the appropriate cfsqltype for the access field being referenced as cf_sql_varchar clearly does not work. HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297232 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Too Few Parameters, expected 1
Whenever I see this error message in database queries to an MS Access DB, and it appears that everything is correct with the query, it is most likely due to using reserved words or functions in Microsoft's implementation of SQL. If you don't want to make changes to the database, then surround every instance of a column name and table name with square brackets like so. Also, use cfqueryparam on all queries where user supplied input is used for query parameters. SELECT * FROM [Users] WHERE [UserLogin] = cfqueryparam value=#Form.UserLogin# cfsqltype=cf_sql_varchar/ AND [Password] = cfqueryparam value=#Form.Password# cfsqltype=cf_sql_varchar/ ENTERED AN EARLIER POST ON THIS SAME QUERY PROBLEM. ORIGINALLY IT WAS A SYNTAX PROBLEM. HOWEVER, NOW I AM GETTING THE FOLLOWING ERROR. THIS IS A SIMPLE LOGIN APPLICATION. Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. The error occurred in C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginCheck.cfm: line 19 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm.cfm: line 206 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\PrivateAccess\Application.cfm: line 17 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginCheck.cfm: line 19 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm.cfm: line 206 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\PrivateAccess\Application.cfm: line 17 17 : SELECT * 18 : FROM Users 19 : WHERE UserLogin = '#Form.UserLogin#' AND Password = '#Form.Password#' 20 : /cfquery 21 : SQLSELECT * FROM Users WHERE UserLogin = 'paulw' AND Password = 'PPMILL' DATASOURCE RickRossiter VENDORERRORCODE -3010 SQLSTATE 07002 Resources: * Check the ColdFusion documentation to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.11) Gecko/20071127 Firefox/2.0.0.11 CODE SOURCE: PROCESS BEGINS IN (application.cfm) WHEN USER ENTERS SECTION OF SITE REQUIRING A LOGIN: (application.cfm) !---If user is not logged in force them to log in--- cfif NOT isDefined(SESSION.Auth.IsLoggedIn) !---If the user is now submitting login action via login form--- !---Include Login Check code to validate the user attempting to log in.--- cfinclude template=../Templates/loginForm.cfm cfabort /cfif NEXT THE USER IS PROMPTED TO THE LOGIN PAGE: cfif isDefined(form.UserLogin) cfinclude template=loginCheck.cfm /cfif span class=HeaderEnter Access Code/span br cfform action=../PrivateAccess/showAR.cfm Name=LoginForm method=post input type=hidden name=UserLogin_required input type=hidden name=Password_required !---userLogin Field is required--- User Name: cfinput type=text name=UserLogin size=20 value= maxlength=24 required=yes message=Please enter your user name. Thank you. style=height:14px; width:125px; font-size:12px; font-weight:bold; color: maroon; letter-spacing:0.2em; text-align:left; pnbsp;/ppnbsp;/p Password: cfinput type=password name=Password size=24 value= maxlength=24 required=yes message=Please enter your assigned password to access this part of the site. Thank you. style=height:14px; width:125px; font-size:12px; font-weight:bold; color: maroon; letter-spacing:0.2em; text-align:left cfinput type=submit name=Enter /cfform WHICH IS CHECKED BY THE FOLLOWING CODE: !---The following code queries the database to find the record of the user's password.--- cfparam name=Form.UserLogin type=string cfparam name=Form.Password type=string cfquery name=getUser datasource=#dsn# SELECT * FROM Users WHERE UserLogin = '#Form.UserLogin#' AND Password = '#Form.Password#' /cfquery !--- If the user's password is correct the following code verifies it and obtains the information then creates a distinct session for each user that logs in. --- cfif getUser.RecordCount EQ 1 cflocation url=../PrivateAccess/showAR.cfm !--- The following code remembers the user's logged-in status their user type and their first name in the session structure. --- cfset SESSION.Auth = StructNew() cfset SESSION.Auth.IsLoggedIn = yes cfset SESSION.Auth.userID = getUser.userID cfset SESSION.Auth.FirstName = getUser.FirstName !--- Now that user is logged in, the following code sends them to PrivateAccess/showAR.cfm page and menu links. --- cflocation url=#CGI.SCRIPT_NAME# /cfif AS YOU CAN SEE THE QUERY IS PULLING THE DATA FROM THE DATABASE, BUT THROWING THIS ERROR MESSAGE. I TURNED ON DEBUGGING BUT THIS DID NOT REVEAL ANYTHING MORE THAN THE ORIGINAL ERROR
