Hi guys,

Having problems filtering in Oracle whenever you have a join. It seems the joined fields will not filter due to incorrect SQL generation.

Look at this simple demo database example. Even though I specify the alias in the SQL statement and the filter fields, the DLL ignores and generates an ambiguous column name filter SQL statement - "WHERE (DEPTNO > 1)" instead of WHERE (EMP.DEPTNO > 1)

Please let me know the fix.

Nick Matteucci

<%Response.Buffer=True
Set MyDb = Server.CreateObject(&#34;AspDB.EP&#34
MyDb.dbDSN=&#34;DSN=local; UID=scott; PWD=tiger;&#34;
MyDb.dbUnit = 1
Mydb.dbDebug=2
MyDb.dbSQL = &#34;SELECT EMP.EMPNO, EMP.ENAME, EMP.JOB, EMP.DEPTNO, DEPT.DNAME, DEPT.LOC FROM SCOTT.EMP EMP, SCOTT.DEPT DEPT WHERE DEPT.DEPTNO = EMP.DEPTNO&#34;
Mydb.dbDbType=&#34;Oracle&#34;
Mydb.dbFilterFlds=&#34;EMP.EMPNO, EMP.ENAME, EMP.JOB, EMP.DEPTNO, DEPT.DNAME, DEPT.LOC &#34;
MyDb.dbNavigationItem=&#34;top, bottom, next, prev, gridrow, color, filter, resetfilter&#34;
MyDb.aspDBEP
%>