authenticate against a MySQL view
the view populates in the wizard as an available choice of tables to authenticate against, but it does not work.
I have confirmed the view works in MySQL and by displaying the results of the recordset for (SELECT * FROM v_users) on the page.
if I change the table back to the real users table, it works fine.
This works: $Authenticate->Table = "users";
This doesn't: $Authenticate->Table = "v_users";
Is there a syntax to authenticate against a query instead of a Table?
Any ideas?