Query Error

[Savas Ates]

query="select * from mytable where id="&xx
id is a numerical field..

if a user choose xx char or a string my query gives an error in asp...
i tried
if err.number <>0 then response.redirect "xx.asp"
but problem is still continueing...

how can i solve this problem?

[Bob Barrows [MVP]]

Savas Ates wrote:

query="select * from mytable where id="&xx
id is a numerical field..

if a user choose xx char or a string my query gives an error in asp...
i tried
if err.number <>0 then response.redirect "xx.asp"
but problem is still continueing...

how can i solve this problem?

Show the code. Is xx.asp the same page?

Bob Barrows

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

[Bob Barrows [MVP]]

Savas Ates wrote:

query="select * from mytable where id="&xx
id is a numerical field..

if a user choose xx char or a string my query gives an error in asp...
i tried
if err.number <>0 then response.redirect "xx.asp"
but problem is still continueing...

how can i solve this problem?

Assuming your code has an "On Error Resume Next" statement ...

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

[Mark]

Before executing your query in the database, check that the user input is
actually a number..

If Not IsNumeric(xx) Then Response.Write "Invalid entry. Entry must be a
number."

"Savas Ates" <sa***@indexinteractive.com> wrote in message
news:%2******************@TK2MSFTNGP11.phx.gbl...

query="select * from mytable where id="&xx
id is a numerical field..

if a user choose xx char or a string my query gives an error in asp...
i tried
if err.number <>0 then response.redirect "xx.asp"
but problem is still continueing...

how can i solve this problem?