|
价格行情 |
 |
<%
'通知调用
set rs=server.createobject("adodb.recordset")
sql="select substring(name,1,4),price,units,substring(lxfs,1,5),substring(dates,6,5) from SCXX_price where cityid='29' and types='农副产品'and lxfs like '%齐河%' order by dates desc"
rs.open sql,conn,1,1
howmanyfields=rs.fields.count -1
%>
<% do while not rs.eof %>
<% for i = 0 to howmanyfields
thisvalue=rs(i)
If isnull(thisvalue) then
thisvalue=""
end if
%>
<%=thisvalue%>
<%next%>
<%rs.movenext
loop
%>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
|
|
供求热线 |
 |
<%do while not rstemp1.eof%>
<% for i = 0 to 1
thisvalue=trim(rstemp1(i))
If isnull(thisvalue) then
thisvalue=""
end if
if thisvalue="供" then
thisvalue="供"
end if
if thisvalue="求" then
thisvalue="求"
end if
%>
"><%=thisvalue%> |
<%next%>
<%rstemp1.movenext
loop
%>
<%
rstemp1.close
set rstemp1=nothing
conn1.close
set conn1=nothing
end sub
%>
<%call query3table("select top 3 substring(titel,1,18),typeid,id from SCXX_sale order by dates desc,id desc")
%>
|
>>更多 |
|
|
|
|
|
|
 |
会员链接
|
|