Can anybody see any problems with the select statement below. I'm getting the following error when trying to run this statement against an Oracle Table. I'm using .asp. I've used a similar select statement on other pages and it works fine.
Err: ORA-00933: SQL command not properly ended strSql_ab = "SELECT a.abmonth, a.ablist, c.curr_stat, c.changes, c.link FROM tblablist a LEFT JOIN tblcomments c ON (c.esnum = a.esnum) where a.esnum = '8099'" Thanks in advance Robert ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ____ • The WDVL Discussion List from WDVL.COM • ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
