Using Query Validation

Guys, I have a Integer field which a user can edit on thier profile. I don't want that number to smaller than 1 or larger than the value of another field - been scratching my head for days on how to achieve that - anyway you can help me with some ideas?

So the fields are:

• Text field 1 - cb_totalpax (yes unfortunatley this is a text field, I guess I could change it to an integrer field not sure if CB can do that automatically?)
• Integer field 2 - cb_uktfrpaxout

So the validation whilst user is entering or updating cb_uktfrpaxout should be something like if user input in [cb_uktfrpaxout] < 1 or > [cb_totalpax]
then error message

Anyway this can be done?

I tried using Query Validation but I guess I am not familiar with the syntax etc of how to structure the query

Thanks

Cliff

Integer fields have built in minimum and maximum value parameters (under Parameters > Validation). For the minimum value you'd set it to 1 and for the maximum value leave as unlimited. Next you'll either need to use CB Code Field or CB Query Field and their validation parameters to have custom validation. For a code field it should be as simple as follows.

Code Validation: Enabled
Code: Ajax Validation: Enabled

So i did this and the result was a browser error saying:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'return ( (int) '5' <= (int) '2' )' at line 1

I'm not sure what the syntax error is - can you help? Sorry...

You're trying to use CB Code Field validation in CB Query Field. My above example is for CB Code Field validation as it's not necessary to do another database query for this.