Re: [dbforms] filter using fields of the same table

[Matthew Stein]

I ran into that problem once, and it was caused by the presence of spaces in the filter attribute. I'd try to re-run that code without the spaces (e.g. filter="categoryId<>pcategoryId").

Hope this helps.

-- Matt

At 12:58 PM 3/2/2003 -0600, Lazaro Fung wrote:

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