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
