Asad.Safari
جمعه 11 آذر 1384, 20:15 عصر
با سلام
من وقتی تکه کد زیر رو اجرا میکنم خطا میده:
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/My ASP Site/default1.asp, line 36
mypic=round(rnd*20)
db_connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & SERVER.MAPPATH("Takgam_picture_gallery/DATABASE.mdb")
Set Myconn = Server.CreateObject("ADODB.Connection")
Myconn.Open db_connectionstring
SET MYTABLE= SERVER.CREATEOBJECT("ADODB.RECORDSET")
mySQL = "select * from Pictures WHERE ID = '" &mypic&"'"
MYTABLE.open mySQL,Myconn,3,3
من وقتی تکه کد زیر رو اجرا میکنم خطا میده:
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/My ASP Site/default1.asp, line 36
mypic=round(rnd*20)
db_connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & SERVER.MAPPATH("Takgam_picture_gallery/DATABASE.mdb")
Set Myconn = Server.CreateObject("ADODB.Connection")
Myconn.Open db_connectionstring
SET MYTABLE= SERVER.CREATEOBJECT("ADODB.RECORDSET")
mySQL = "select * from Pictures WHERE ID = '" &mypic&"'"
MYTABLE.open mySQL,Myconn,3,3