Hi, Nothing can be used with whereClause! It's just free and no other feature works!
Regards, Henner > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von Chow Kwan Yu > Gesendet: Mittwoch, 8. Oktober 2003 08:11 > An: Shawn > Cc: dbf interest > Betreff: Re: [dbforms] Re: [Jdbforms-developers] Join tables support > > > Hi, > > Let me try query and tells the result later. > > BTW, can whereClause be used together with searches (1.1.3) > (not using > attribute but by HTML inputs)? I've tried the following > thing but seems > clicking on "Applica!" gives no effect on the SQL prepared statement > generated by dbforms: > <db:dbform autoUpdate="false" followUp="/customer2.jsp" maxRows="5" > tableName="cos" tableList="customer,orders,service" > whereClause="WHERE customer.id=orders.customer_id AND > orders.service_id=service.id"> > <INPUT type="text" name="<%= > searchFieldNames_cos.get("orders.order_id") > %>"> > <input type="button" value="Applica!" > onClick="javascript:document.dbform.submit()"> > > THX! > --bee > > > Shawn wrote: > > >> Am I doing a correct way to put the "join relationship" in the > >> whereClause? Or shall I put it elsewhere? > >> Or should I use "query" instead of "table"? > > > > > > > > Um I think you should use a query for this: > > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > DbForms Mailing List > http://www.wap-force.net/dbforms ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
