>


<%header("Дистанционные курсы")%>
<% set connsql = server.createobject("adodb.connection") connsql.open application("cnconnstr") set rs=server.createobject("adodb.recordset") strsql="SELECT price_usd,page,coursename,hours,weeks,required,price,groupname FROM courses,coursegroups WHERE courses.groupid=coursegroups.groupid AND price<>NULL AND price<>0 AND test<>'Y' ORDER BY groupname,coursename" rs.open strsql,connsql oldname="" do while not rs.eof newname=trim(rs("groupname")) if oldname<>newname then%><% end if oldname=newname %> <%rs.movenext loop rs.close set rs=nothing connsql.close set connsql=nothing %>

Курс

Часы  

Длит. (нед)

Требования к образованию слушателей

<%=newname%>

><%=trim(rs("coursename"))%>

<%=trim(rs("hours"))%>

<%=trim(rs("weeks"))%>

<%=trim(rs("required"))%>