db lookup

Hi I get the following error
Cannot execute Mandatory SQL query check
when the registration form is submitted.
I can't find any documentation on how to configure db lookup (other then the wiki).
Any suggestions/guidance would be appreciated.
Peter

Peterx wrote: Hi I get the following error
Cannot execute Mandatory SQL query check
when the registration form is submitted.
I can't find any documentation on how to configure db lookup (other then the wiki).
Any suggestions/guidance would be appreciated.
Peter

and what is the sql code you are trying to execute?

SQL query check:
SELECT * FROM `testcodes` WHERE `code`= '[value]' AND `userid` = '0'

I replace [value] with my own value.

That's what is in Community Builder Field: Edit [ Registration Access ]

I am am confused (obviously lol) as to how this all works.
My SQL and programming is poor as I rarely need it .

What I am trying to achieve is this:
I have a site (sentryhealthservices.com) that I just published and it has an employee section that requires registration which is moderated.
I realized that I only want the employess to register and not random individuals out on the internet.
I thought I could provide all 400 employees a single access code that is required to complete the registration form.

Will db_accesscode do this or do i need some customizing?

Thank you
Peter

Peterx wrote: SQL query check:
SELECT * FROM `testcodes` WHERE `code`= '[value]' AND `userid` = '0'

I replace [value] with my own value.

Nope - you should not touch the [value] part.
It will automatically be substituted by the value that the user inputs in the field.

That's what is in Community Builder Field: Edit [ Registration Access ]

I am am confused (obviously lol) as to how this all works.
My SQL and programming is poor as I rarely need it .

What I am trying to achieve is this:
I have a site (sentryhealthservices.com) that I just published and it has an employee section that requires registration which is moderated.
I realized that I only want the employess to register and not random individuals out on the internet.
I thought I could provide all 400 employees a single access code that is required to complete the registration form.

Will db_accesscode do this or do i need some customizing?

Thank you
Peter

You can accomplish this with a just a CB text field that you have configured to only validate for the single access code you want.

How do I do that? I don't see where I enter the unique code.
IS there any documentation/ tutorials /step by step instructions somewhere?. The CB site is lacking documentation as far as I can see.

Thanks for your help
Peter

Create a text field for them to provide the access code. Then adjust the below parameters on that text field so it only validates for a single value (your access code).

Authorized input: Custom PERL regular expression
Perl Regular Expression: /ACCESS_CODE_HERE/

This will cause the field to only validate for the string you place in "ACCESS_CODE_HERE". This uses REGEX so try to keep the code alphanumeric (e.g. ABC123) to avoid having to escape any characters.

Usage of field validation parameters are outlined in your CB documentation which you can download from the Advanced downloads section.