[SOLVED] Check if field value exists in comprofiler table

1 month 2 days ago - 1 month 1 day ago #326841 by ontarget
Hi
I have a field called "Membership number".
If a user enters a Membership number that is already in the comprofiler table I want to block their registration (much in the same way that email values cant be registered twice)
Is the possible with CB?
Do i need a special plugin?

Please Log in to join the conversation.

1 month 2 days ago - 1 month 2 days ago #326842 by ontarget
I used the CB Query add on
SELECT * FROM `jos_comprofiler` WHERE `cb_membernumber` = '[value]'
Validate on empty result
Works great!

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.292 seconds

Facebook Twitter LinkedIn