You can use query instead of table in your dbforms-config. Query knows about an distinct attribute! Regards, Henner
> -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von ouahab > Gesendet: Freitag, 28. M�rz 2003 11:32 > An: [EMAIL PROTECTED] > Betreff: [dbforms] how to make a "distinct" sql request ? > > > > 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 ------------------------------------------------------- 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
