日期:2014-05-16  浏览次数:20995 次

网页生成html,显示空白
我在数据库里面看了有数据存在
可是打开网页的时候是空白
可能是没有调用到数据库
代码贴出来,你们看下有没有错误
Sub ContentIDHtml(Pattern,selID)
Dim SQLID, AllID
Dim totalnum, FileUrl, FolderPath, FileName, FilePath
On Error Resume Next
selID = Request("selID")
AllID = Split(selID, ",")
If selID = "" Then
Response.Write "<script>alert('请选择后操作');history.back()</script>"
End If
totalnum = tee5.Execute("SELECT COUNT(*) FROM [Gq_Article] WHERE ID in (" & selID & ")")(0)
SQL = "SELECT * FROM Gq_Article WHERE ID in (" & selID & ")"
Set rs = tee5.Execute(SQL)
SQL=Rs.GetRows(totalnum)
Set Rs = Nothing
If Pattern = 1 then SQLID= UBound(AllID): Else SQLID= UBound(SQL,2)
If Pattern = 1 then Response.Write "<ol>"
If Pattern = 1 then Response.Write "<b>生成文章内容(HTML)开始......</b><br><br>"
For i = 0 To SQLID
FolderPath = tee5.ServerDir & "Html" & tee5.ServerDir & "Article/" & SQL(1,i) & tee5.ServerDir & year(SQL(7,i)) & month(SQL(7,i)) & day(SQL(7,i)) & tee5.ServerDir
tee5.CreatPathEx (FolderPath)
FileUrl = tee5.WebUrl & "/Temp/8.asp?ID=" & Clng(SQL(0,i))
FileName = "News_" & SQL(0,i)
FilePath = FolderPath & FileName & ".html"
Call GetRemoteFiels(FileUrl, FolderPath, FileName)
If Pattern = 1 then Response.Write "<li style=""font-size: 12px;"">生成文章内容HTML页完成... <a href=" & FilePath & " target=_blank>" & Server.MapPath(FilePath) & "</a></li>" & vbNewLine
Response.Flush
Next
If Pattern = 1 then Response.Write "<br><br><b>恭喜您!文章内容HTML全部生成完毕!</b>"
If Pattern = 1 then Response.Write "</ol>"
End Sub

下面的是数据库裁图


------解决方案--------------------
引用不懂版主的意思?
我是搞接触这东西
是sql语句有错误吗?