服务范围

<% dim rs8,sql8,q8 q8=0 Set rs8=Server.CreateObject("Adodb.Recordset") sql8="select * from ProClass where classid=1 or classid=2 or classid=3 or classid=4 or classid=5 or classid=6 or classid=7 or classid=8 or classid=9 or classid=10 or classid=11 or classid=12 order by classorder asc,classid asc" If rs8.State=1 Then rs8.Close rs8.Open sql8,Conn ,1,1 if rs8.eof and rs8.bof then%> <%else%> <%do while not rs8.eof q8= q8+1%> <% rs8.movenext if q8 mod 3 = 0 then response.Write("") end if loop end if rs8.close set rs8 = nothing %>
广州演出经纪公司
<% dim rs3,sql3,q3 q3=0 Set rs3=Server.CreateObject("Adodb.Recordset") sql3="select * from ProClass where classid=13 or classid=14 or classid=15 or classid=16 or classid=17 or classid=18 or classid=19 or classid=20 or classid=21 or classid=22 or classid=23 or classid=24 order by classorder asc,classid asc" If rs3.State=1 Then rs12.Close rs3.Open sql3,Conn ,1,1 if rs3.eof and rs3.bof then%> <%else%> <%do while not rs3.eof q3= q3+1%> <% rs3.movenext if q13 mod 3 = 0 then response.Write("") end if loop end if rs3.close set rs3 = nothing %>
广州灯光音响租赁公司
<% dim rs2,sql2,q2 q2=0 Set rs2=Server.CreateObject("Adodb.Recordset") sql2="select * from ProClass where classid=25 or classid=26 or classid=27 or classid=28 or classid=29 or classid=30 order by classorder asc,classid asc" If rs2.State=1 Then rs2.Close rs2.Open sql2,Conn ,1,1 if rs2.eof and rs2.bof then%> <%else%> <%do while not rs2.eof q2= q2+1%> <% rs2.movenext if q2 mod 3 = 0 then response.Write("") end if loop end if rs2.close set rs2 = nothing %>
广州品牌策划公司
<% dim rs4,sql4,q4 q4=0 Set rs4=Server.CreateObject("Adodb.Recordset") sql4="select * from ProClass where classid=31 or classid=32 or classid=33 or classid=34 or classid=35 or classid=36 order by classorder asc,classid asc" If rs4.State=1 Then rs4.Close rs4.Open sql4,Conn ,1,1 if rs4.eof and rs4.bof then%> <%else%> <%do while not rs4.eof q4= q4+1%> <% rs4.movenext if q4 mod 3 = 0 then response.Write("") end if loop end if rs4.close set rs4 = nothing %>
广州影视广告公司
<% dim rs5,sql5,q5 q5=0 Set rs5=Server.CreateObject("Adodb.Recordset") sql5="select * from ProClass where classid=37 or classid=38 or classid=39 or classid=40 or classid=41 or classid=42 order by classorder asc,classid asc" If rs5.State=1 Then rs5.Close rs5.Open sql5,Conn ,1,1 if rs5.eof and rs5.bof then%> <%else%> <%do while not rs5.eof q5= q5+1%> <% rs5.movenext if q5 mod 3 = 0 then response.Write("") end if loop end if rs5.close set rs5 = nothing %>

经典案例

<%dim b b = 0 Set rs=Server.CreateObject("ADODB.RecordSet") sql="select top 100 * from products where CaseYes=1 and IndexYes=1 order by proorder ,addtime desc,proid desc" If Rs.State=1 Then Rs.Close Rs.Open Sql,Conn ,1,1 if rs.eof and rs.bof then%> <%else%> <%do while not rs.eof b= b+1%> <% rs.movenext if b mod 5 = 0 then response.Write("") end if loop end if rs.close set rs = nothing %>

策划知识

<% Set rs=Server.CreateObject("ADODB.RecordSet") sql="select top 8 * from products where newsyes=1 order by addtime desc,ProId desc" If Rs.State=1 Then Rs.Close Rs.Open Sql,Conn ,1,1 if rs.eof and rs.bof then%> <% Else%> <% do while not rs.eof%><% rs.movenext loop rs.close set rs = nothing%> <% end if %> <% Set rs=Server.CreateObject("ADODB.RecordSet") sql="select top 12 * from news order by addtime desc,ProId desc" If Rs.State=1 Then Rs.Close Rs.Open Sql,Conn ,1,1 if rs.eof and rs.bof then%> <% Else%> <% do while not rs.eof%><% rs.movenext loop rs.close set rs = nothing%> <% end if %>
<% dim rs7,sql7 Set rs7=Server.CreateObject("Adodb.Recordset") sql7="select * from ProClass where Classyes=1 order by classorder asc,classid asc" If rs7.State=1 Then rs7.Close rs7.Open sql7,Conn ,1,1 if not (rs7.eof and rs7.bof) then do while not rs7.eof%>
<%if rs7("classid")=int(request.QueryString("classid")) then %><%=rs7("classname")%><% Else %><%=rs7("classname")%><% End If %>
<% Set rs=Server.CreateObject("ADODB.RecordSet") sql="select top 7 * from Products where classid="&rs7("classid")&" order by ProOrder,addtime desc,ProId desc" If Rs.State=1 Then Rs.Close Rs.Open Sql,Conn ,1,1 if rs.eof and rs.bof then%> <% Else%> <% do while not rs.eof%> <% rs.movenext loop rs.close set rs = nothing%> <% end if %>
<% Set rs=Server.CreateObject("ADODB.RecordSet") sql="select top 4 * from Products where classid="&rs7("classid")&" and IndexServiseYes=1 order by ProOrder,addtime desc,ProId desc" If Rs.State=1 Then Rs.Close Rs.Open Sql,Conn ,1,1 if rs.eof and rs.bof then%> <% Else%> <% do while not rs.eof%><% rs.movenext loop rs.close set rs = nothing%> <% end if %> <%rs7.movenext loop end if rs7.close set rs7 = nothing%>
70aca833