AS keyword in sql statement gives error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lsdelamater - 16 Dec 2005 04:40 GMT

Whenever I use the 'as' keyword in my sql statement I get this error

Response object error 'ASP 0104 : 80070057'

Operation not Allowed

/amplifiers.asp, line 0

I can't find any information anywhere on this error. Basically I have 2
tables, a products table and an amplifier table that contains additional info
for amplifier products. I'm searching the db by finding all amplifiers with a
certain wattage

SELECT prods.*, amplifier.wattage, amplifier.sku FROM prods, amplifier WHERE
((amplifier.wattage<=200) AND (amplifier.sku=prods.sku));

I want to set amplifier.sku to say 'asku'

Reply to this Message

Bob Barrows [MVP] - 16 Dec 2005 11:35 GMT

> Whenever I use the 'as' keyword in my sql statement I get this error
>
> Response object error 'ASP 0104 : 80070057'

This error says nothing about the sql statement (if there was something
wrong with the sql statement, you would be seeing a syntax error or some
other message from the OLE DB provider or database engine). It's referring
to something you are doing with the response object.>

> Operation not Allowed
>
> /amplifiers.asp, line 0

Line 0?

> I can't find any information anywhere on this error. Basically I have
> 2 tables, a products table and an amplifier table that contains
> additional info for amplifier products. I'm searching the db by

What database? Type and version please.

> finding all amplifiers with a certain wattage
>
> SELECT prods.*, amplifier.wattage, amplifier.sku FROM prods,
> amplifier WHERE ((amplifier.wattage<=200) AND
> (amplifier.sku=prods.sku));

Hmm, is it Access?
If so, use the Access Query Builder to create a query that does what you
want and compare it to this statement.

> I want to set amplifier.sku to say 'asku'

So, put As asku into the statement ...

Show us the code that generates this error.

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

paul@bullschmidt.com - 20 Dec 2005 06:50 GMT

You may want to check this out:

http://www.aspfaq.com/search.asp?q=80070057&x=7&y=11

Best regards,
J. Paul Schmidt, Freelance Web and Database Developer
http://www.Bullschmidt.com
Access Database Sample, Web Database Sample, ASP Design Tips

>Response object error 'ASP 0104 : 80070057'
>
[quoted text clipped - 3 lines]
>
>I can't find any information anywhere on this error.

Reply to this Message

Webmaster Forum / ASP / Database Access / December 2005

AS keyword in sql statement gives error