datatype mismatch error

[chirag1989]

I m havin an error of datatype mismatch
actual here i m askin user to input the code in text box and then searchin the
record havin that code in database
the problem is the code field Bnum is of number datatype
so its showin me this error
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/library/12updbook1.asp, line 128


<%


bc=request.form("txtbc")
response.Cookies("bn")=bc

set con=server.CreateObject("ADODB.connection")
con.open "File Name=C:\Inetpub\wwwroot\library\mylink.udl"


set rsa=server.CreateObject("ADODB.recordset")
rsa.open "select * from Book where Bnum='"&bc&"'",con

if rsa.eof then response.Redirect("12updbook3.asp")


%>

[DrBunchman]

Hi chirag,

Does it work if you put an integer into the input? Are you validating the input field at all?

Dr B

[chirag1989]

Hi chirag,

Does it work if you put an integer into the input? Are you validating the input field at all?

Dr B

no,its not workin
but i got the solution
it was just the matter of qoutes

<%


bc=request.form("txtbc")
response.Cookies("bn")=bc

set con=server.CreateObject("ADODB.connection")
con.open "File Name=C:\Inetpub\wwwroot\library\mylink.udl"


set rsa=server.CreateObject("ADODB.recordset")
rsa.open "select * from Book where Bnum="&bc&" ",con

'before it was ' " &bc& " '

if rsa.eof then response.Redirect("12updbook3.asp")


%>