Classic ASP Discussion

Print Page | Close Window

Recordset

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=22901
Printed Date: 29 March 2026 at 5:17am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Recordset

Posted By: dwhite02
Subject: Recordset
Date Posted: 15 March 2007 at 4:04am

Might be out of the scope of this forum but it's worth a try.

I am trying to convert the query below (generated in MS Access ) to one I can use in an ASP page to query an Oracle DB. When I use it I get the error "ORA-00933: SQL command not properly ended"

Any suggestions....

Thanks.

SELECT COR_EMPLOYEES.EMP_ID, COR_EMPLOYEES_APP.NT_USERID, COR_EMPLOYEES.DESIGNATION
FROM COR_EMPLOYEES INNER JOIN COR_EMPLOYEES_APP ON COR_EMPLOYEES.EMP_ID = COR_EMPLOYEES_APP.EMP_ID
WHERE (((COR_EMPLOYEES.DESIGNATION)="SNR MGR"))
ORDER BY COR_EMPLOYEES.EMP_ID;

Replies:

Posted By: michael
Date Posted: 15 March 2007 at 1:55pm

What version of Oracle? Joins can be different in O depending on their release.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: dwhite02
Date Posted: 15 March 2007 at 7:09pm

I think it is V8.? The query I provided above does whork in MS Access when doing a query against the Oracle DB when they are linked tables.

Posted By: michael
Date Posted: 15 March 2007 at 8:03pm

Yeah, 8 is old and I don't think it is using ANSI joins. Try using just JOIN as opposed to INNERT JOIN

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker