Hey,
I have the subject to make a registration for people, who got an Invitation by Post with a Invitation-Code. So I thought, dblookup was the right Plugin.
But now I try to configure it. I show in on the registrationform, o.k. And I submitted the [value] with my invitation code, but it gave out an error: "Cannot execute Mandatory SQL query check". So perhpas I thought wrong with changeing the [value].
Please can you give me a short explanation....
greetings Mapache
I use the msql-string:
SELECT * FROM ` j17_comprofiler_fields` WHERE `code`= '[cb_invitationcode]' AND `userid` = '0'
cb_invitationcode is a textfield in the database I gave a standard value which is my Invitationcode...