Check value at registration

Hi,

I have a field where you have to fill in a unique code consisting of 12 digits (0-9) and I would like to test that the value isn't already in the database. Is it possible and in that case how do I do it the best way?

Yup, using CB Database Lookup fieldtype plugin you can do exactly this. It's available for download in the Professional downloads section.

Thanks, I will have a look on that plugin.

/A

wiki example here:
forge.joomlapolis.com/projects/cb-cbdblookupfield/wiki

Hi,

Long time ago

Is it possible to change the popup message from "Invalid code" to something else?

Preferably it would be a field where you specify the message in the DB Lookup field settings.

As default the DB Lookup plugin seems to fail registration when the value isn't in the database. In my case I would need to have it the way around. If the value already is in the database it will fail, like when you try to registrate the same email address twice.

I tried with "<> '[value}'" but I don't know if that's the best way to do it in sql. Any better options?

I Sweden everyone has a unique number that is mandatory in our database. I want to use the above to prevent double registrations.


BR

Andreas

andreas.hallberg wrote: Hi,

Long time ago

Is it possible to change the popup message from "Invalid code" to something else?

Preferably it would be a field where you specify the message in the DB Lookup field settings.

As default the DB Lookup plugin seems to fail registration when the value isn't in the database. In my case I would need to have it the way around. If the value already is in the database it will fail, like when you try to registrate the same email address twice.

I tried with "<> '[value}'" but I don't know if that's the best way to do it in sql. Any better options?

I Sweden everyone has a unique number that is mandatory in our database. I want to use the above to prevent double registrations.


BR

Andreas

Yes, you need to adjust your dblookup query to reflect the logic you want.