ASP变量不能从其标记中输出

Question

我得到了这个code..which是整体代码的一部分。

    <%
dim rsFav
sSQL = "(SELECT shorthand, display, larry_ranking, site_url FROM larrydb_site_list lsl JOIN larrydb_review lr on lsl.sid = lr.sid WHERE display=true AND niche='regular' ORDER BY larry_ranking DESC Limit 2) UNION (SELECT shorthand, display, larry_ranking, site_url FROM larrydb_site_list lsl JOIN larrydb_review lr on lsl.sid = lr.sid WHERE display=true AND niche='regular' AND shorthand='sexier')"
Set rsFav = objConn.Execute(sSQL)
While NOT rsFav.EOF
%>
        <tr><td>

                    <div style="background-image:url('images/<%=LCase(rsFav("shorthand"))%>_icon.png')" border="0" class="fav_site_icon">
                    <a href="http://livecamdeals.com/review.asp?sitename=<%=LCase(rsFav("shorthand"))%>"></a>
                    </div>
                    </td><td>
                    <a href='<%=LCase(rsFav("site_url"))%>' title="Visit <%=LCase(rsFav("shorthand"))%>.com" target="_blank" class="visit_site_icon <%=LCase(rsFav("shorthand"))%> special_<%=LCase(rsFav("shorthand"))%>"></a>
                    </td>
                    </tr></td>
<%
rsFav.MoveNext
wEnd
%>

一切工作fine..apart此行..

\我获取的站点名称为空：

为什么会这样呢？我对asp一无所知..我知道php和asp.net .only

更新:这是我得到的：

HTML输出。一条链路的示例：

<div style="background-image:url('images/.png')" border="0" class="fav_site_icon">



                </div>

请注意，打印above..the速记是为了解决图像..but而不是link..seems的html问题

Answer 1

将一个变量设置为rsFav(“速记”)返回的值，并在整个代码中引用该变量。

Dim shortHandId
While NOT rsFav.EOF 
shortHandId = rsFav("shorthand")
%>         
<tr><td>                      
<div style="background-image:url('images/<%=LCase(shortHandId)%>_icon.png')" border="0" class="fav_site_icon">                     
<a href="http://livecamdeals.com/review.asp?sitename=<%=LCase(shortHandId)%>"></a>                     
</div>                     
</td>
<td>                     
<a href='<%=LCase(rsFav("site_url"))%>' title="Visit <%=LCase(shortHandId)%>.com" target="_blank" class="visit_site_icon <%=LCase(shortHandId)%> special_<%=LCase(shortHandId)%>"></a>                     
</td>                     
</tr>

Answer 2

试着改变

<a href="http://example.com/review.asp?sitename=<%=LCase(rsFav("shorthand"))%>">

转到

<a href='http://example.com/review.asp?sitename=<%=LCase(rsFav("shorthand"))%>'>

让您的href使用单引号。