Hi Medhi,
An interceptor will not do the trick.
What you need to use is query support (in dbforms-config).
I am not sure exactly what yours will look like, but see the usersguide.
I think it would be something like:
<dbforms-config>
...
<query name="Table1_alias" distinct="true" from="Table1" />
Then in your form:
<db:dbform tableName="Table1_alias" .... filter="Field1>10">
...
Shawn
PS Thank Henner - he put that together I believe.
> SELECT disinct Field1 FROM Table1 where Field1>10,
> But i can't tell dbforms to put a "disinct" behind the "SELECT" So how
>can i alter the request sent by dbforms to MySql to insert a "disinct"
>in it? Something like a pre or post select interceptor ?
>Mehdi
--
Shawn <[EMAIL PROTECTED]>
-------------------------------------------------------
This SF.net email is sponsored by:
The Definitive IT and Networking Event. Be There!
NetWorld+Interop Las Vegas 2003 -- Register today!
http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
