|
价格行情 |
 |
|
|
供求热线 |
 |
<%sub query3table(inputquery)
set conn1=server.createobject("ADODB.connection")
conn1.open("Provider=SQLOLEDB.1;Server=80.0.0.17;Database=sdxnw;UID=read;pwd=DSread17@8408;")
set rstemp1=conn1.execute(inputquery)
%>
<%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")
%>
|
>>更多 |
|
|
|
|
信息发布 |
|
 |
会员链接
|
|