首頁(yè) 猿問(wèn) 你好，請(qǐng)問(wèn)在asp中respons...

你好，請(qǐng)問(wèn)在asp中response.write " "內(nèi)部如何寫才算正確？

.NET 源碼

明月笑刀無(wú)情 2022-04-08 11:07:37

<%set rs1=server.createobject("adodb.recordset")sql1 = "SELECT * from BigClass"rs1.open sql1,conn,1,1do while not rs1.EOF '大類未結(jié)束時(shí)循環(huán)bcid = rs1("BigClassID")bcname = rs1("BigClassName")Response.Write "<li> <h3 class='mcate-item-hd'>"Response.Write "<span> "Response.Write "<a href=../product.asp?bcid='"&bcid&"' title='"&bcname&"' > '"&bcname&"' </a> "Response.Write "</span></h3> "rs1.MoveNextset rs2=server.createobject("adodb.recordset")sql2 = "SELECT * from SmallClass where BigClassID="&bcid&" and SmallClassID<>"" "rs2.open sql2,conn,1,1do while not rs2.EOF '小類未結(jié)束時(shí)循環(huán)scid = rs2("SmallClassID")scname = rs2("SmallClassName")Response.Write "<p class='mcate-item-bd'> "Response.Write "<a href=../product.asp?bcid='"&bcid&"'&scid='"&scid&"' title='"&scname& "'>'"&scname&"'</a> "rs2.MoveNextloopResponse.Write "</p>"rs2.closeset rs2=nothingrs1.MoveNextloopreponse.write "</li>"rs1.closeset rs1=nothing%>問(wèn)題：不能讀出數(shù)據(jù)庫(kù)中的內(nèi)容并顯示！請(qǐng)大家?guī)椭膶?，特別是response.write中的內(nèi)容，多謝！

查看完整描述

3 回答

UYOU

TA貢獻(xiàn)1878條經(jīng)驗(yàn) 獲得超4個(gè)贊

Response.Write "<a href=../product.asp?bcid="& bcid &"&title="& bcname &">"& bcname &"</a> "
下面這句我看不清你的引號(hào)，
SELECT * from SmallClass where BigClassID="&bcid&" and SmallClassID<>''"
但我覺得你可以這樣寫
SELECT * from SmallClass where BigClassID="&bcid&" and isNull(SmallClassID)"

反對(duì) 回復(fù) 2022-04-11

互換的青春

TA貢獻(xiàn)1797條經(jīng)驗(yàn) 獲得超6個(gè)贊

<%
set rs1=server.createobject("adodb.recordset")
sql1 = "SELECT * from BigClass"
rs1.open sql1,conn,1,1
do while not rs1.EOF '大類未結(jié)束時(shí)循環(huán)

bcid = rs1("BigClassID")
bcname = rs1("BigClassName")
Response.Write "<li> <h3 class='mcate-item-hd'>"
Response.Write "<span> "
Response.Write "<a href=../product.asp?bcid='"&bcid&"' title='"&bcname&"' > '"&bcname&"' </a> "
Response.Write "</span></h3></li>"
set rs2=server.createobject("adodb.recordset")
sql2 = "SELECT * from SmallClass where BigClassID="&bcid&" and SmallClassID<>"" "
rs2.open sql2,conn,1,1
do while not rs2.EOF '小類未結(jié)束時(shí)循環(huán)

scid = rs2("SmallClassID")
scname = rs2("SmallClassName")
Response.Write "<p class='mcate-item-bd'> "
Response.Write "<a href=../product.asp?bcid='"&bcid&"'&scid='"&scid&"' title='"&scname& "'>'"&scname&"'</a> </p>"
rs2.MoveNext
loop
rs2.close
set rs2=nothing
rs1.MoveNext
loop
rs1.close
set rs1=nothing
%>