| 代理信息 |
<% dim sql1
sql1="select top 6 a.Merchantid,a.name,a.Tel,a.address,a.logopic,b.categoryname,b.categoryid,b.parentid from Merchant a,category b where a.categoryid=b.categoryid and (a.status=3 or a.status=2) order by lastTime desc"
set rs=conn.execute(sql1)
if not rs.eof then
i=1
do while not rs.eof
Merchantid = rs("Merchantid")
name = rs("name")
logopic = rs("logopic")
Tel = rs("Tel")
Address = rs("address")
categoryid = rs("categoryid")
parentid = rs("parentid")
If len(name) >11 then
name = left(name,10)&".."
End if
If len(Tel) >16then
Tel = left(Tel,15)&".."
End if
If len(Address) >6 then
Address = left(address,7)&".."
End If
%>
|
|
 |
|
 |
|
|
|
|
|
|
|
|
|
|
|
|
云南白药安徽一级代理 |
|
