i've been trying to solve this problem but still dont get it .i want to display record in the db with this is and i always get error report of :
Microsoft JET Database Engine error '80040e07' Data type mismatch in criteria expression. /skima/content/content.asp, line 18 this is the link to the page : http://i.1asphost.com/skima/content/content.asp?page=1 this is the script below : <% response.buffer=true Response.ExpiresAbsolute = Now() - 1 Response.AddHeader "Cache-Control", "private" page=request("page") if page<>"" then set conn=Server.CreateObject("ADODB.Connection") strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" strconn=strconn & server.mappath("/skima/content/db/content.mdb") & ";" conn.open(strconn) sql= "Select title,content from cont where id='" & page & "'" set rstemp=conn.execute (sql) If rstemp.eof then response.write "No records matched<br>" conn.close set conn=nothing response.end else title=rstemp("title") content=rstemp("content") end if %> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows- 1252"> <meta name="GENERATOR" content="Microsoft FrontPage 4.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <title>Content Management System : <% response.write title %></title> </head> <body bgcolor="#000080" text="#FFFFFF" link="#00FF00" vlink="#00FF00" alink="#00FF00"> <table border="0" width="100%" height="367" style="border: 1 dashed #00FFFF"> <tr> <td width="25%" height="36" valign="top" colspan="2"></td> </tr> <tr> <td width="25%" height="319" valign="top">NAVIGATE <p>LINK</p> <p>LINK</p> <p>LINK</td> <td width="75%" height="319" valign="top"><% response.write content %></td> </tr> </table> <% rs.close set rs=nothing conn.close set conn= nothing end if%> </body> </html> Thanx for any help render. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
