"Select title,content from cont where id='" & page & "'" needs to be "Select title,content from cont where id=" & page get rid of the single quotes it is not a text data type
On Thu, 20 Jan 2005 22:49:03 -0000, sheriff <[EMAIL PROTECTED]> wrote: > > 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 the Yahoo! Terms of Service. 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/
