inetserver asp db: 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));

[quoted text, click to view]
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.>

[quoted text, click to view]

Line 0?

[quoted text, click to view]

What database? Type and version please.

[quoted text, click to view]

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.

[quoted text, click to view]

So, put As asku into the statement ...

Show us the code that generates this error.


--
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"

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


[quoted text, click to view]