高校问答关于足球的励志电影:求教一个SQL查询的问题
来源：百度文库 编辑：高校问答 时间：2024/04/29 12:16:48
原SQL:
sqlmi="SELECT articleid,topic1,topic2,orders as order1,articleid as order2,0 as order3 FROM article WHERE bookid = "&x&" AND upid = 0 UNION SELECT ar2.articleid, "
sqlmi= sqlmi&"ar2.topic1,ar2.topic2,ar1.orders as order1,ar2.upid as order2,ar2.orders AS order3 FROM article as ar1, article as ar2 "
sqlmi= sqlmi&"WHERE ar2.bookid = "&x&" AND ar2.upid <> 0 AND ar2.upid = ar1.articleid order by order1 asc, order2 asc, order3 asc OPTION (HASH UNION) "
现在在article表增加 vip表段.
现在想直接在以下语句显示出来,请问上述语法怎么修改.谢谢
do while not mi.eof
response.write mi("vip") 显示出来.
以下答案提示错误
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
sqlmi="SELECT articleid,topic1,topic2,orders as order1,articleid as order2,0 as order3 FROM article WHERE bookid = "&x&" AND upid = 0 UNION SELECT ar2.articleid, "
sqlmi= sqlmi&"ar2.topic1,ar2.topic2,ar1.orders as order1,ar2.upid as order2,ar2.orders AS order3 FROM article as ar1, article as ar2 "
sqlmi= sqlmi&"WHERE ar2.bookid = "&x&" AND ar2.upid <> 0 AND ar2.upid = ar1.articleid order by order1 asc, order2 asc, order3 asc OPTION (HASH UNION) "
现在在article表增加 vip表段.
现在想直接在以下语句显示出来,请问上述语法怎么修改.谢谢
do while not mi.eof
response.write mi("vip") 显示出来.
以下答案提示错误
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
sqlmi="SELECT articleid,topic1,topic2,orders as order1,articleid as order2,0 as order3,vip FROM article WHERE bookid = "&x&" AND upid = 0 UNION SELECT ar2.articleid, "
sqlmi= sqlmi&"ar2.topic1,ar2.topic2,ar1.orders as order1,ar2.upid as order2,ar2.orders AS order3,ar2.vip as vip FROM article as ar1, article as ar2 "
sqlmi= sqlmi&"WHERE ar2.bookid = "&x&" AND ar2.upid <> 0 AND ar2.upid = ar1.articleid order by order1 asc, order2 asc, order3 asc OPTION (HASH UNION) "