帮忙看看这个SQL语句吧？

tcy09 2004-01-02 12:18:21

sql="SELECT Deskadmi.Deskid, Deskadmi.DeskName, Deskadmi.DeskType, Usedeskinfor.UseID, Usedeskinfor.OpenDate,Usedeskinfor.SumMoney, Usedeskinfor.PayMoney FROM Deskadmi,Usedeskinfor,AREAADMI,DESKTYPE WHERE USEDESKINFOR.EndTime BETWEEN "&date1 &" AND "& date2 &" AND USEDESKINFOR.IsEnd ="&isend &" AND AREAADMI.AREANAME ="&firstdept &" AND Areaadmi.AreaNo = Deskadmi.Area AND Deskadmi.DeskID = Usedeskinfor.DeskNo AND DESKTYPE.DESKNO = DESKADMI.DESKTYPE"
ODBC 驱动程序不支持所需的属性

...全文

84 10 打赏收藏转发到动态举报

写回复

用AI写文章

10 条回复

切换为时间正序

请发表友善的回复…

发表回复

睿睿爸爸 2004-01-02

打赏
举报

<%=rs("deskid")%>没有错，肯定是确实没有数据，
在程序中将最后生成的语句打印出来，放到查询分析器里
试试逐渐增加条件，你那种连表查询必须四个表的数据完全关联上才可以

tcy09 2004-01-02

打赏
举报

可是现在，我想取出表里的数据去取不出来，<%=rs("deskid")%>,这样不对吗

tcy09 2004-01-02

打赏
举报

谢谢，终于对了

longlong1000 2004-01-02

打赏
举报

注意类型，试试逐渐增加条件语句，看看问题在哪里

ygghost 2004-01-02

打赏
举报

放到查询分析器里，看看那部分有错。
1 步步过滤知道吗？

睿睿爸爸 2004-01-02

打赏
举报

试试这个，注意"'"，还不行的话，在程序中将最后生成的语句打印出来看看
sql="SELECT Deskadmi.Deskid, Deskadmi.DeskName, Deskadmi.DeskType, Usedeskinfor.UseID, Usedeskinfor.OpenDate,Usedeskinfor.SumMoney, Usedeskinfor.PayMoney FROM Deskadmi,Usedeskinfor,AREAADMI,DESKTYPE WHERE USEDESKINFOR.EndTime BETWEEN '"&date1 &"' AND '"& date2 &"' AND USEDESKINFOR.IsEnd ='"&isend &"' AND AREAADMI.AREANAME ='"&firstdept &"' AND Areaadmi.AreaNo = Deskadmi.Area AND Deskadmi.DeskID = Usedeskinfor.DeskNo AND DESKTYPE.DESKNO = DESKADMI.DESKTYPE"

tcy09 2004-01-02

打赏
举报

我已经这样写了，还是不对
date1="2000-1-1 00:00:00"
date2="2004-1-1 00:00:00"
sql="SELECT Deskadmi.Deskid, Deskadmi.DeskName, Deskadmi.DeskType, Usedeskinfor.UseID, Usedeskinfor.OpenDate,Usedeskinfor.SumMoney, Usedeskinfor.PayMoney FROM Deskadmi,Usedeskinfor,AREAADMI,DESKTYPE WHERE USEDESKINFOR.EndTime BETWEEN '"&date1 &"' AND '"& date2 &"' AND USEDESKINFOR.IsEnd ="&isend &" AND AREAADMI.AREANAME ="&firstdept &" AND Areaadmi.AreaNo = Deskadmi.Area AND Deskadmi.DeskID = Usedeskinfor.DeskNo AND DESKTYPE.DESKNO = DESKADMI.DESKTYPE"

潜水的鱼 2004-01-02