%
Sub NewAskR()'最新回复咨询
Sql = "Select Top 7 Id,Title,Flag,AskTime From AskOnline Where CompanyId = "& CompanyId &" And Flag = 1 Order by Asktime Desc"
Arr=Data.DataToArr(Sql,False)'返回数组
If UBound(Arr,2) < 0 Then
Response.Write "
无回复问答...
" '没记录
Else
For I = 0 To UBound(Arr,2)
Response.Write "
"
If I <> UBound(Arr,2) Then '最后一条不加换行
Response.Write ""
End If
Next
End If
End Sub
Sub NewAskN()'待回复咨询
Sql = "Select Top 7 Id,Title,Flag,AskTime From AskOnline Where CompanyId = "& CompanyId &" And Flag <> 1 Order by Asktime Desc"
Arr=Data.DataToArr(Sql,False)'返回数组
If UBound(Arr,2) < 0 Then
Response.Write "
无未回复问答...
" '没记录
Else
For I = 0 To UBound(Arr,2)
Response.Write "
"
If I <> UBound(Arr,2) Then '最后一条不加换行
Response.Write ""
End If
Next
End If
End Sub
Sub NewAskT()'推荐问题
Sql = "Select Top 7 Id,Title,Flag,AskTime From AskOnline Where CompanyId = "& CompanyId &" And Ishot = 1 Order by Asktime Desc"
Arr=Data.DataToArr(Sql,False)'返回数组
If UBound(Arr,2) < 0 Then
Response.Write "
暂无推荐问答...
" '没记录
Else
For I = 0 To UBound(Arr,2)
Response.Write "