[dbforms] filter using fields of the same table

[Lazaro Fung]

Hi   Any one knows how to setup a filter in  dbform tag using another field of the same table   for example:   categoryId pcategoryId category 1 1 Water 2 1 Ozone 3 1 Ultra Pure 4 4 Cleaning 5 4 Kitchen 6 4 Bathroom   something like :   .. filter="categoryId <> pcategoryId"   I try this but is not working this error is returned:   java.sql.SQLException: Field type seems to be incorrect - java.lang.NumberFormat Exception: pcategoryId   TIA   LFung