You can use <db:search> or <db:searchCombo> to let the user select values. If you want to pass in fields wich calculated then you can use scripting with the searchFieldNames_tableName variables.
Regards, Henner > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von Sunil Mishra > Gesendet: Samstag, 25. Oktober 2003 17:01 > Cc: '[EMAIL PROTECTED]' > Betreff: [dbforms] Dynamic Query > > > Hi, > > I need to do a query "Select x,y,z from T where UserId=? And > StartDate=? And EndDate=?". I want to pass the logged in > UserId or some other field as selected by the user. > > Basically, I have a screen, where I'll show from date & to > date fields. Then a Retrieve button. After the user hits > retrieve, I need to show the report. > > How should I proceed? > > Thanks > ______________________________________________ > Sunil Mishra, Manager, ADP Wilco (India) Private Limited > * +91-40-2340 8600 x-8202 ---- * +91-98490-61241 > > > This message is confidential and may also be legally > privileged. If you are not the intended recipient, please > notify [EMAIL PROTECTED] immediately. You should not > copy it or use it for any purpose, nor disclose its contents > to any other person. The views and opinions expressed in this > e-mail message are the author's own and may not reflect the > views and opinions of ADP Wilco. > > > > ------------------------------------------------------- > This SF.net email is sponsored by: The SF.net Donation > Program. Do you like what SourceForge.net is doing for the > Open Source Community? Make a contribution, and help us add > new features and functionality. Click here: > http://sourceforge.net/donate/ > _______________________________________________ > DbForms Mailing List > http://www.wap-force.net/dbforms ------------------------------------------------------- This SF.net email is sponsored by: The SF.net Donation Program. Do you like what SourceForge.net is doing for the Open Source Community? Make a contribution, and help us add new features and functionality. Click here: http://sourceforge.net/donate/ _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
