Problems with "Bad Request (Invalid URL)" while input chinese characters into MS SQL

[wonder_gal]

I had came across an error known as "Bad Request (Invalid URL)" when i was trying to input chinese characters into MS SQL database using my asp written page. For your info, I'm currently working on Windows Server 2003 and running IIS 6 on this server. Can someone pls point out to me what triggers this error?

Thanks.

[wonder_gal]

Hereby i enclosed my asp request method tat i'm using
<%
sCategory = request.querystring("txtCategory")
....
%>

the txtCategory textbox contains chinese characters, and after that I'll insert the sCategory string value into MS SQL database.

Pls point out to me what possibly triggers this error. Thanks alot.

[durango]

With any foriegn characters, submitting them on a URL is more than likely causing the web server problems. What I suggest is don't use the GET method in your form, use POST.

[wonder_gal]

Ya, I'm already using "post" as my form method. Is there any other errors?

[JamieC]

If you're using POST, then this line: sCategory = request.querystring("txtCategory") should read sCategory = request.form("txtCategory")

- Jamie

[wonder_gal]

oh, thanks alot