=====Select语句问题=================================================

heejun521 2004-04-23 02:40:30

sql=" Select * from BCA_Check where Nameid = "&BinaryToString(Fields("LStr_WhsID").Value) and Data=(select max(Data) from BCA_Check where NameId="&BinaryToString(Fields("LStr_WhsID").Value)))"

高手帮小弟看看，语法错在那？？SQL Server2000！在线等！

...全文

43 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

heejun521 2004-04-23

打赏
举报

谢谢！！ seeze()请接分！

Zedee 2004-04-23

打赏
举报

sorry^^

sql=" Select * from BCA_Check where Nameid = '" & BinaryToString(Fields("LStr_WhsID").Value) & "' and Data=(select max(Data) from BCA_Check where NameId='" & BinaryToString(Fields("LStr_WhsID").Value) & "')"

建议调试时在此句后加上
response.write("sql:::"&sql)

heejun521 2004-04-23

打赏
举报

TO seeze():

语句未结束

/BCA/level/CheckApply.asp，行5

sql=" Select * from BCA_Check where Nameid = '" & BinaryToString(Fields("LStr_WhsID").Value) & "' and Data=(select max(Data) from BCA_Check where NameId='" & BinaryToString(Fields("LStr_WhsID").Value))) & "'"
------------------------------------------------------^

Zedee 2004-04-23

打赏
举报

sql=" Select * from BCA_Check where Nameid = '" & BinaryToString(Fields("LStr_WhsID").Value) & "' and Data=(select max(Data) from BCA_Check where NameId='" & BinaryToString(Fields("LStr_WhsID").Value))) & "'"

heejun521 2004-04-23