Prev   Next

Back to the top of the FAQ

Q. Inner Joins
A. When you use the custom select statement and the custom select statement is an inner join, make sure that the Password field that you specify does not contain a table qualifier.

For example:
select password text: Users.Password
custom select text: FROM ProjectUsers INNER JOIN Users ON ProjectUsers.UserName = Users.UserName Where ProjectUsers.Project = 'Project1' AND
Username text: Users.UserName

will succeed using the Test button, but will fail when trying to Authenticate actual web pages. Instead make sure you have
select password text: Password
without the Users. part.

This is because the test button merely executes the statement and returns the number of rows. However when authenticating, AuthentiX binds to the columns of the ODBC result, according to the names of the fields returned by the ODBC calls. These only return the field name, and not the table-qualified name.

Back to the top of the FAQ

Prev   Next