sql = "Select room.rtype,count(*) from room,cusorder where (room.roomno<>cusorder.roomno and cusorder.arrDate=to_date('12-12-2002','yyyy-mm-dd') group by room.rtype"如果cusorder.arrDate是日期类型,在oracle中也是通不过的。
thank you for your reply, we type the same SQL as you stated above in oracle ,it's ok but STILL not in ASPwhy????thank you very much
我说了,如果cusorder.arrDate是日期型,以下在oracle应当是通不过的。 这是access的写法。 Select room.rtype,count(*) from room,cusorder where (room.roomno<>cusorder.roomno and cusorder.arrDate='#12-12-2002#') group by room.rtype oracle对日期类型,必须要求日期型=日期型
Thank you very much but sorry oracle is really ok, but just the same SQL in ASP will generate empty record in rs. sorry for asking so many times what is the problem?
we type the same SQL as you stated above in oracle ,it's ok
but STILL not in ASPwhy????thank you very much
这是access的写法。
Select room.rtype,count(*) from room,cusorder where (room.roomno<>cusorder.roomno and cusorder.arrDate='#12-12-2002#') group by room.rtype
oracle对日期类型,必须要求日期型=日期型
but sorry
oracle is really ok, but just the same SQL in ASP will generate empty record in rs.
sorry for asking so many times
what is the problem?