如何自动跳转到指定页面？

[daqi2010]

<%
id=request.querystring("id")
Set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from product where id="&id
rs.open sql,conn,1,2
sort_name=rs("sort_name")
--------------------
If sort_name="电器" Then
response.redirect "dq/show.asp?id=id"
End if
If sort_name="手机" Then
response.redirect "sj/show.asp?id=id"
End if
--------
rs.close
set rs=nothing
%>
跟据ID得到商品的类型，然后跟据类型跳转到不同的页面？
谢谢大家

[西安风影]

你的代码不对吗？

[hookee]

<% 
id = request.querystring("id") 
Set rs = Server.CreateObject("ADODB.RecordSet") 
sql="select * from product where id=" & id 
rs.open sql,conn,1,1
If Not (rs.EOF And rs.BOF) Then
  sort_name = Trim(rs("sort_name"))
End If
rs.close 
set rs = nothing 
conn.Close
set conn = nothing 

url = ""
Select Case sort_name
  Case "电器" url = "dq/show.asp?id=" & id 
  Case "手机" url = "sj/show.asp?id=" & id 
End Select
Response.Redirect url
%> 

[owenzhang]

response.redirect
window.location.href

[yunxiang2005]

你把这两句改成下面这样就行了。response.redirect "dq/show.asp?id=id" 和response.redirect "sj/show.asp?id=id" 这两句改成下面这样：
response.redirect "dq/show.asp?id=" & id
response.redirect "sj/show.asp?id=" & id

[hgc8888]

VBSCRIPT用:response.redirect "跳转页"
JAVASCRIPT用:location href "跳转页"
也可以在网页头部的:<meta http-equiv="refresh" content="1;URL=/">