I do n’t know what's wrong, there is a syntax error near i

huoyu5

Reading records 2-10, there is a grammatical error near i, please master help?
Set Dets = Conn.Execute ("select top 10 i.bid, i.id, i.title, i.pic, i.path, b.name, b.orderid from info as i, infobigsort as b where i.id not in (select top 10 i.id, b.orderid from info as i, infobidsoft as b where i.bid = b.orderid and i.Commend_index = 1 and agree = 1 order by i.addtime desc) i.bid = b.orderid and i.Commend_index = 1 and agree = 1 order by i.addtime desc ")

dydcool

You first test whether your SQL statement is successful.

huoyu5

How to test it, never used it, there is a syntax error near'i'.

kiddivl

Halo Lake.........Learning ING

Where did I come from? It looks a bit similar to the one that has not been declared but quoted first

huoyu5

info as i, right here,
Set Dets=Conn.Execute("select top 10 i.bid,i.id,i.title,i.pic,i.path, b.name,b.orderid from info as i,infobigsort as b where i.bid =b.orderid and i.Commend_index=1 and agree=1 order by i.addtime desc")
This alone is correct

windmimi

i.bid=b.orderid and i.Commend_index=1 and agree=1 order by i.addtime desc which query is the last one? There should be two queries here.

windmimi

Try to remove this: i.bid=b.orderid and i.Commend_index=1 and agree=1 order by i.addtime desc")

huoyu5

Is to go to that bracket

windmimi

the last one

hellobn

Your WHERE condition is wrong, change it to this:
Set Dets=Conn.Execute("select top 10 i.bid,i.id,i.title,i.pic,i.path, b.name,b.orderid from info as i,infobigsort as b where i.id not in(select top 10 i.id,b.orderid from info as i,infobidsoft as b where i.bid=b.orderid and i.Commend_index=1 and agree=1 order by i.addtime desc) AND i.bid =b.orderid and i.Commend_index=1 and agree=1 order by i.addtime desc")