hi all
i'm currently developping a application using dbforms, and it really helped me out to create a great interface for my database in a few days. My problem is that i need dbforms to do something like
SELECT disinct Field1 FROM Table1 where Field1>10,
To achieve that my dbform tag looks like:
<db:dbform tableName="Table1" .... filter="Field1>10">
<db:header/>
<db:body>
<db:textField size="10" fieldName="Field1"/>
</db:body>
<db:footer/>
</db:dbform>
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
------------------------------------------------------- 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
