数据读取问题
<!--#include file= "top.asp "-->
<%
dim conn
dim connstr
dim db
db= "database/sjrx.asp "
Set conn = Server.CreateObject( "ADODB.Connection ")
connstr= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & Server.MapPath( " "&db& " ")
conn.Open connstr
id=request( "id ")
code=request( "code ")
SQL= "Select * from news where id= ' "&id& " ' and code= ' "&code& " ' "
Set ss=Server.CreateObject( "Adodb.Recordset ")
ss.Open sql, Conn,1,3 '第 14 行
title=ss( "title ")
content=( "content ")
addtime=( "addtime ")
%>
出现问题:标准表达式中数据类型不匹配。
/meiti/skin/rencai/news.asp, 第 14 行
[解决办法]
SQL= "Select * from news where id= ' "&id& " ' and code= ' "&code& " ' "
改为
SQL= "Select * from news where code= ' "&code& " ' and id= "&id
[解决办法]
用樓上的試下吧,感覺你的沒錯.至少在SQLSERVER裏可用.
[解决办法]
access中如果id是数字型的话就不能加 '
[解决办法]
SQL= "Select * from [news] where [id]= "&id& " and [code]= ' "&code& " ' "
