超级菜,一个参数判断问题!
从上表单传来一个参数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

%>