asp 信息列表 发布的最新前5个信息加图标显示
<%Response.Buffer=True%><%Setconn=Server.CreateObject("ADODB.Connection")conn.Open"Dr...
<% Response.Buffer=True %><%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("56454.asa")
%><% set rs=server.createobject("adodb.recordset")
sql="select * from company"
rs.open sql,conn,1,1
r1=rs.recordcount
rs.close
set rs=nothing
set rs=server.createobject("adodb.recordset")
sql="select * from company where job<>'""' order by id desc"
rs.open sql,conn,1,1
jobnum=rs.recordcount %><tr><% do while not rs.eof %><td width="33%"><font face=webdings color='#FF6600'>4</font><a href="company.asp?uid=<%=rs("uname")%>" target="_blank" class="bbb" title=招聘职位:<%=rs("job")%>>
<%=rs("cname")%><br>招聘:
<% if len(rs("job"))>15 then%>
<%=Left(rs("job"),15)%>...
<% else%><%=rs("job")%><%end if%></a></td><% c=c+1
if c mod 3=0 then response.write "</tr><tr>"
rs.movenext
if c>=60 then exit do
loop
rs.close
set rs=nothing %></tr></table> 展开
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("56454.asa")
%><% set rs=server.createobject("adodb.recordset")
sql="select * from company"
rs.open sql,conn,1,1
r1=rs.recordcount
rs.close
set rs=nothing
set rs=server.createobject("adodb.recordset")
sql="select * from company where job<>'""' order by id desc"
rs.open sql,conn,1,1
jobnum=rs.recordcount %><tr><% do while not rs.eof %><td width="33%"><font face=webdings color='#FF6600'>4</font><a href="company.asp?uid=<%=rs("uname")%>" target="_blank" class="bbb" title=招聘职位:<%=rs("job")%>>
<%=rs("cname")%><br>招聘:
<% if len(rs("job"))>15 then%>
<%=Left(rs("job"),15)%>...
<% else%><%=rs("job")%><%end if%></a></td><% c=c+1
if c mod 3=0 then response.write "</tr><tr>"
rs.movenext
if c>=60 then exit do
loop
rs.close
set rs=nothing %></tr></table> 展开
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询