[SOLVED] How to refer to a registration field in a Dblookup query

I whish to allow a user to register on my site only if his/her firstname, lastname and a predefined code ALL match those stored in a table.
I have defined a Dblookup field with the following SQL query: That doesn't work, I suppose, because the reference to the "LASTNAME" and "FISRTNAME" fields' value of the registration form is in the wrong syntax, but I can't figure out how to fix it.
If I take out the reference to firstname and lastname, the query does work and the registration completes successfully.

Could someone help me?

You've the wrong quotes around fist name and last name. You're declaring the text as columns instead of as values. The below should work.

Thank you Krileon for your help.
Now the SQL error is gone, but the query fails (returns the message: "invalid code") even if the value entered in the three fields on the registration form all exactly matches the values stored in the table.

Some suggestions?

Thank you.

Sorry to bother you again but I'm still unable to get the query working with variables pointing to registration form's field (such as "lastname" and "firstname").


I need to verify that all three fields (uslcode, lastname and firstname) in the registration form do match with the corresponding fields in the table I'm checking.
Changing the quotes from ` ` to ' ' around the field name in the query has corrected the syntax but the it retrieves no rows, so raising the "invalid code" error.

The query does work (and the registration process ends successfully) if I hard type the absolute values of fields "lastname" and "firstname" but not if I refer to them with a variable (like '[lastname]').

Could you show me how to correctly refer to the registration form's fields in order to get their value in the query?

Any help would be much appreciated.

Could you show me how to correctly refer to the registration form's fields in order to get their value in the query?

I already have in my previous post, but you need to have the first and lastname fields available on registration.

To have a working query you need to build it and test it directly on your database then add your substitutions in. You can find more information on substitutions in the below tutorial.

www.joomlapolis.com/support/tutorials/107-use-cases/18353-using-substitutions-throughout-cb

Obviously I had already checked in phpMyAdmin the query's validity before bothering you with a dumb question...
The query DOES work as expected with values hard-typed in it:

and, as previously said, the registration process ends successfully in that case, but it fails when using substitutions.
You say

you need to have the first and lastname fields available on registration

The registration form does show those fields: beyond that what does it mean "having them available on registration"?


Could you show me exactly how you'd rewrite the query in the "SQL query check" box in the DB lookup field definition form?

Thank you for your patience and support.