Sql Not Properly Ended Error -Solved

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shall@uaex.edu - 18 Apr 2007 15:47 GMT

I was getting the error
[Oracle][ODBC][Ora]ORA-00933: SQL command not properly ended

For me, I had in my ASP page reading from an oracle table:

Select TT.myfield

>From mytable AS TT

It should have been without the "AS":

Select TT.myfield

>From mytable TT

I hope this helps someone else.
Thanks.Steve

Reply to this Message

Adrienne Boswell - 19 Apr 2007 07:44 GMT

> I was getting the error
> [Oracle][ODBC][Ora]ORA-00933: SQL command not properly ended
[quoted text clipped - 11 lines]
> I hope this helps someone else.
> Thanks.Steve

Yes, field names have "AS" aliases, eg:

SELECT a.field AS afield, b.field AS bfield FROM atable a, btable b

Signature

Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share

Reply to this Message

Bob Barrows [MVP] - 19 Apr 2007 11:42 GMT

>> I was getting the error
>> [Oracle][ODBC][Ora]ORA-00933: SQL command not properly ended
[quoted text clipped - 15 lines]
>
> SELECT a.field AS afield, b.field AS bfield FROM atable a, btable b

This restriction only seems to apply to Oracle as far as I have seen. This
would have kept me puzzled for quite a while if I had encountered it.

Signature

Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Reply to this Message

Webmaster Forum / ASP / Database Access / April 2007

Sql Not Properly Ended Error -Solved