GetUser.AuthLevel Question

[andy570]

I have uploaded my database and have entered AccountExec in the AuthLevel Field. When I attempt to login I get the following error:
Element AUTHLEVEL is undefined in GETUSER.
The error occurred in line 33

31 : Name="#GetUser.LoginID#, #GetUser.FName#,#GetUser.LName#, #GetUser.Company#"
32 : Password="#Form.UserPassword#"
33 : Roles="#GetUser.AuthLevel#">

Any ideas?

Thanks!

 

[NorthStarDA]

looks like you have a query called GETUSER, in that SELECT statement- are you including the AUTHLEVEL field? maybe you could post your code so we can better tell what is going on.

 

[andy570]

Here is the query code:
<cfquery name="GetUser" datasource="#DataSource#">
SELECT *
FROM ZSLogin
WHERE UserName = '#FORM.UserLogin#'
AND Password = '#FORM.UserPassword#'
</cfquery>

What is strange is when I enter the fields (LoginID, UserName, Password, Company, FName, LName, and AuthLevel) I get a message saying there is an error in the select statement at the "AND Password = '#FORM.UserPassword#' and when I use the * I get the original error message posted above.

Thanks for the help!

 

[NorthStarDA]

hmm, that definitely is strange..

I would put the field names in so it got past that error, and to see if it works i would take out the "AND password=" part of the query and then troubleshoot that separately. Other than that I would check for the normal things like if you have different copies of that database for any reason that your datasource is pointing to the right one..

out of curiosity, what database is this? and are you using the built-in jdbc drivers in MX or are you using an ODBC socket (if odbc at all)

whenever i have qwerky problems now with the built-in drivers, i switch to using an ODBC socket and a local(to the server) datasource and it sometimes solves my problems.

 

[andy570]

Thanks I will try that and then troubleshoot that separately. I am using an ODBC socket.

Thanks again for the help!

 

[webmigit]

For the sake of it.. try:

<cfoutput>#getUser.columnList#</cfoutput>

Also, I'm about to ask a stupid question.. but when you try field by field.. do you try:

LoginID, UserName, Password, Company, FName, LName, AuthLevel

or

LoginID, UserName, Password, Company, FName, LName, [b]and[/b] AuthLevel

In case the latter is the case, you do not want the and in there.

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.