level 1
高大威猛🌵
楼主
Dim Rss,GRss,JRss,SQL,GSQL,JSQL,vbsstr,Gvbsstr,Jvbsstr
vbsstr = ""
Gvbsstr = ""
Jvbsstr = ""
SQL = "SELECT url FROM [NC_trict] WHERE name like *"& m_strCity &"%* order by level asc"
GSQL = "SELECT gurl FROM [NC_trict] WHERE name like *"& m_strCity &"%* order by level asc"
JSQL = "SELECT jurl FROM [NC_trict] WHERE name like *"& m_strCity &"%* order by level asc"
Set Rss = NewAsp.Execute(SQL)
Set GRss = NewAsp.Execute(GSQL)
Set JRss = NewAsp.Execute(JSQL)
If Rss.BOF And Rss.EOF Then
Set Rss = Nothing
vbsstr = ""
Else
vbsstr = Rss("url")
End If
If vbsstr="" OR IsNull(vbsstr) Then
vbsstr = ""
Else
vbsstr = "<div class="abc1">"& vbsstr&"</div>"
End If
If GRss.BOF And GRss.EOF Then
Set GRss = Nothing
Gvbsstr = ""
Else
Gvbsstr = GRss("gurl")
End If
If Gvbsstr="" OR IsNull(Gvbsstr) Then
Gvbsstr = ""
Else
Gvbsstr = "<div class="abc1">"& Gvbsstr&"</div>"
End If
If JRss.BOF And JRss.EOF Then
Set JRss = Nothing
Jvbsstr = ""
Else
Jvbsstr = JRss("jurl")
End If
If Jvbsstr="" OR IsNull(Jvbsstr) Then
Jvbsstr = ""
Else
Jvbsstr = "<div class="abc1">"& Jvbsstr&"</div>"
End If
2014年09月17日 01点09分
1
vbsstr = ""
Gvbsstr = ""
Jvbsstr = ""
SQL = "SELECT url FROM [NC_trict] WHERE name like *"& m_strCity &"%* order by level asc"
GSQL = "SELECT gurl FROM [NC_trict] WHERE name like *"& m_strCity &"%* order by level asc"
JSQL = "SELECT jurl FROM [NC_trict] WHERE name like *"& m_strCity &"%* order by level asc"
Set Rss = NewAsp.Execute(SQL)
Set GRss = NewAsp.Execute(GSQL)
Set JRss = NewAsp.Execute(JSQL)
If Rss.BOF And Rss.EOF Then
Set Rss = Nothing
vbsstr = ""
Else
vbsstr = Rss("url")
End If
If vbsstr="" OR IsNull(vbsstr) Then
vbsstr = ""
Else
vbsstr = "<div class="abc1">"& vbsstr&"</div>"
End If
If GRss.BOF And GRss.EOF Then
Set GRss = Nothing
Gvbsstr = ""
Else
Gvbsstr = GRss("gurl")
End If
If Gvbsstr="" OR IsNull(Gvbsstr) Then
Gvbsstr = ""
Else
Gvbsstr = "<div class="abc1">"& Gvbsstr&"</div>"
End If
If JRss.BOF And JRss.EOF Then
Set JRss = Nothing
Jvbsstr = ""
Else
Jvbsstr = JRss("jurl")
End If
If Jvbsstr="" OR IsNull(Jvbsstr) Then
Jvbsstr = ""
Else
Jvbsstr = "<div class="abc1">"& Jvbsstr&"</div>"
End If