超级菜,一个参数判断问题!从上表单传来一个参数ID%idTrim(request( id ))ifid thenrs.openselect
超级菜,一个参数判断问题!
从上表单传来一个参数ID
<%
id=Trim(request( "id "))
if id= " " then
rs.open "select * from test where id =1 "
else
rs.open "select * from test where id = ' "&id& " ' "
end if
%>
然后循环把所的结果放列表中,我想把两句合 我一句,请问该怎么写?
[解决办法]
<%
id=Trim(request( "id "))
if id= " " then
strSQL = "select * from test where id =1 "
else
strSQL = "select * from test where id = ' "&id& " ' "
end if
rs.open strSQL
%>
