-
Problems with Filter with Oracle
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("AspDB.EP"
MyDb.dbDSN="DSN=local; UID=scott; PWD=tiger;"
MyDb.dbUnit = 1
Mydb.dbDebug=2
MyDb.dbSQL = "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"
Mydb.dbDbType="Oracle"
Mydb.dbFilterFlds="EMP.EMPNO, EMP.ENAME, EMP.JOB, EMP.DEPTNO, DEPT.DNAME, DEPT.LOC "
MyDb.dbNavigationItem="top, bottom, next, prev, gridrow, color, filter, resetfilter"
MyDb.aspDBEP
%>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|