asp如何判断表名
ASP在查询SQL数据库时，如果查询的表名在SQL中没有，应该如何弹出错误？

[解决办法]

VBScript code

<%sConn = "Provider=SQLOLEDB;Data source=127.0.0.1;Initial Catalog=DB;User ID=sa;Password=sa;"sTable = "table_name"Set conn = CreateObject("ADODB.Connection")conn.Open sConnSet oCat = CreateObject("ADOX.Catalog")Set oCat.ActiveConnection = connSet colTables = oCat.Tablesb = FalseFor Each t In colTables    If t.Name = sTable Then        b = True        Exit For    End IfNextconn.CloseSet conn = NothingSet oCat = NothingSet colTables = NothingIf b Then    Response.Write "存在" & sTableElse    Response.Write "不存在" & sTableEnd If%>