You can rename your field definitions in the config file to a.keyfield or use the expression clause in the config file.
> Is there any way to get the SQL executed in getFreeFormSelectQuery > to be: > > SELECT > a.keyField, > a.fieldA1 > FROM > testTable1 a, > testTable2 b > WHERE > a.keyField = b.keyField > > That would also fix the ambiguous keyField. > > Henner Kollmann wrote: > > Simple SQL problem. Must rename your keyfields the a.keyfield and > > b.keyfield. Or - better - use a view inside your database. > > > > Regards, > > Henner > > > > > >><%@ taglib uri="WEB-INF/dbforms.tld" prefix="db" %> > >><html xmlns:db="http://www.wap-force.com/dbforms";> > >> <head><db:base/></head> > >> <body> > >> <db:dbform followUp="/plan_single2.jsp" maxRows="*" > >> tableName="testTable1" tableList="testTable1 a, > testTable2 b" > >> whereClause="WHERE a.keyField = b.keyField" > > >> <db:body> > >> <db:textField size="5" fieldName="b.fieldB1"/> > >> </db:body> > >> </db:dbform> > >> </body> > >></html> > >> > >>Whenever I try this, the debug output returns the following > >>error: 464018 -------- [tcpConnection-80-2] INFO > >>org.dbforms.Table - ::getFreeFormSelectQuery -- [SELECT > >>keyField, fieldA1 FROM > >>testTable1 a, testTable2 b WHERE a.keyField = b.keyField] > >>464028 -------- [tcpConnection-80-2] ERROR > >>org.dbforms.util.SqlUtil - ::logSqlExceptionSQL - exception > >>java.sql.SQLException: General error: Column: 'keyField' in > >>field list > >>is ambiguous > >> > > > > > > > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: VM Ware > > With VMware you can run multiple operating systems on a single > > machine. WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual > > machines at the same time. Free trial click here: > > http://www.vmware.com/wl/offer/345/0 > > _______________________________________________ > > DbForms Mailing List > > > > http://www.wap-force.net/dbforms > > > > -- > David Richardson > Software Engineer > 215-895-1080 x80951 > The Math Forum @ Drexel University > ------------------------------------------------------- This SF.net email is sponsored by: VM Ware With VMware you can run multiple operating systems on a single machine. WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the same time. Free trial click here: http://www.vmware.com/wl/offer/345/0 _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
