Is there way without COOK to validate the values of a field by using a table with the correct values.
p.e. I have a field CURRENCY and i want to make sure the value that is entered comes form a column CODE on my table, and that column contains 'EUR','USD',YEN',...

Very easy. (since jQuery validator)


TODO :
1. Add a js validator handler in helpers/html/validator.php ex : currency
2. Concat all these values to create a long regex. (can be generated dynamically by your component, better)
3. Create the languages strings associated (same file)
4. Add a class name to the field to validate : 'validate[currency]'

Note : to add a class to a JDom input :
Hope it helps.


EDIT : After reflexion, I think here it is better to do not use a SQL call to concat the currencies. It is a call each time the validator is instancied in the component, even if the form do not need this to validate.

So I would suggest a kind of cache file regenerated when the currencies are edited. Or eventually regenerated only if the validation is asked. (Coding only in this new component).

So the previous code is valid, but the regex is read from a file. Much better.

Up, to notify the edition of the topic.

And I add that this validation is JS only.

With the coming of JForms (soon), you will be able to create a 'rule', which is a bridge between JS and PHP.