页面的调用问题~~在线等,.能给看看吗?

[wangzhifeng219]

调用如下
src="displaypic.asp?user_name=<%=rs_zuce("user_name")%>

displaypic.asp
如下:<%
dim db,picuser_name
db="db/pic.mdb"
Set Connpic = Server.CreateObject("ADODB.Connection")
mypicconn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"")
Connpic.Open MypicConn
picuser_name=Request("user_name")
sql="select * from pic where user_name='"&picuser_name&"'"
Set rspic= Server.CreateObject("ADODB.Recordset")
rspic.open sql,connpic,1,1
Response.ContentType = "image/jpeg"
Response.BinaryWrite rspic("big")
rspic.close
set rspic=nothing
%>

能给看看吗?

[wangzhifeng219]

dispic.asp参数传递没有问题,我已测试成功

[jingxiaoping]

sql="select * from pic where user_name='"&picuser_name&"'"

建议不要使用select *的方法，可以更换为select big的方法进行输出。

[hy98521]

rsponse.write rs_zuce("user_name")
rsponse.end
src="displaypic.asp?user_name=<%=rs_zuce("user_name")%>
这样看的吗？

[ybfqlyq]

Response.ContentType = "image/jpeg"
-----》
Response.ContentType = "image/*"

[wangzhifeng219]

刚试了下select big 还是不行

[wangzhifeng219]

我的意思是说,我想在另外一个页面中显示

shiyan.asp中所选出的图片
<%
dim db,picuser_name
db="db/pic.mdb"
Set Connpic = Server.CreateObject("ADODB.Connection")
mypicconn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"")
Connpic.Open MypicConn
picuser_name=Request("user_name")
sql="select * from pic where user_name='"&picuser_name&"'"
Set rspic= Server.CreateObject("ADODB.Recordset")
rspic.open sql,connpic,1,1
Response.ContentType = "image/jpeg"
Response.BinaryWrite rspic("big")
rspic.close
set rspic=nothing
%>
另一页面中

相关代码为src="shiyan.asp?user_name=<%=rs_zuce("user_name")%>"
其中rs_zuce("user_name")为另一数据库中选出的记录
总的目的是,实现通过两个数据库中相同的字段user_name,一方面传递参数给shiyan.asp,
另一方面自身的记录显示