[SOLVED] CB Query Field

Buby-it
OFFLINE
Posts: 8
Thanks: 1
Karma: 0

7 years 11 months ago - 7 years 11 months ago #288213 by Buby-it

[SOLVED] CB Query Field was created by Buby-it

Hi
I need help with CB Query field. I've followed the CB Query Tutorials - 01 - Getting Started with CB Query field and Validations video but it doesn't work at my site :-(

I need to validate a unique members No at registration and have already created a couple of members with unique numbers.

This is the string that I use: SELECT 'id' FROM `#__comprofiler` WHERE `cb_fbo_id` = '[value]'

Can anyone please help me out ;-)

Regards,
Buby

PS - The above is by mistake also posted in "Single Add-on Support" - seems like I'm not able to delete my question in that forum

Last edit: 7 years 11 months ago by krileon. Reason: Added [SOLVED] tag to subject

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 48454
Thanks: 8280
Karma: 1443

7 years 11 months ago #288248 by krileon

Replied by krileon on topic CB Query Field

The below usage should work fine.

Query:

Code:

SELECT COUNT(*) FROM `#__comprofiler` WHERE `cb_fbo_id` = '[value]'

Mode: Internal
Validate On: Empty Results

If you want it to also use ajax you need to be sure to set the following as well.

Ajax Validation: Enabled

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

Buby-it
OFFLINE
Posts: 8
Thanks: 1
Karma: 0

7 years 11 months ago #288267 by Buby-it

Replied by Buby-it on topic CB Query Field

Hi Kyle

Thx for your answer - but it didn't work at my site :-(

Please advise what to do as it is crucial for me to get the site in produktion ?

Kind regards,
Buby

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 48454
Thanks: 8280
Karma: 1443

7 years 11 months ago #288269 by krileon

Replied by krileon on topic CB Query Field

Ensure CB Query Field is published and public in CB > Plugin Management. It will not function if the plugin can not be loaded or accessed.

Please Log in or Create an account to join the conversation.

Buby-it
OFFLINE
Posts: 8
Thanks: 1
Karma: 0

7 years 11 months ago #288274 by Buby-it

Replied by Buby-it on topic CB Query Field

It is published and public

Attachments:

Please Log in or Create an account to join the conversation.

Buby-it
OFFLINE
Posts: 8
Thanks: 1
Karma: 0

7 years 11 months ago #288279 by Buby-it

Replied by Buby-it on topic CB Query Field

CB Query field is of course published and public ;-)

Attachments:

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon