ASP代码问题,

来源:百度知道 编辑:UC知道 时间:2024/06/20 11:14:03
<%
title=request.Cookies("user")
%>
<title>欢迎:<%=title%></title>

<%
if request.Cookies("user")="" then
response.Redirect("default.asp")
response.End()
end if
username=request.Cookies("user")
%>

<%
exec="select * from hzyl where hosp='范县人民医院' order by id desc"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>

我想把第三行:<%=title%>的值,赋值到‘范县人民医院’这个地方。
先谢谢你了。

where hosp='范县人民医院' order by id desc

where hosp="&title&" order by id desc

request.Cookies("user") = rs["hosp"]

<%
title=request.Cookies("user")
%>
<title>欢迎:<%=title%></title>

<%
if request.Cookies("user")="" then
response.Redirect("default.asp")
response.End()
end if
username=request.Cookies("user")
%>

<%
exec="select * from hzyl where hosp='"title"' order by id desc"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>

exec="select * from hzyl where hosp="&title&"order by id desc"

exec="select * from hzyl where hosp='范县人民医院' order by id desc"

改为

exec="select * from hzyl where hosp='" & title & &