Yes, you can use the query tag in dbforms-config! Cheers, Henner
> -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von Sudeep Dsouza > Gesendet: Samstag, 17. April 2004 12:57 > An: [EMAIL PROTECTED] > Betreff: [dbforms] Displaying results of complex select > > Hi, > > I have a complex select statement that I need to execute and > display the results in a table. The select is as follows > > select taskId, activityDate, sum(effort) from TaskActivity > where userid="2" > and activityDate>="2004-04-10" > and activityDate<="2004-04-16" > group by taskId , activityDate > order by taskId asc, activityDate asc; > > As I am using mysql as the database I don't have the luxury > of having a view so is there any way using the limitations of > dbforms can I execute and display the above results. > > Thanks, > Sudeep. ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id70&alloc_id638&op=click _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
