rs1.Source="select top 10 * from house order by ID DESC"
是没问题的,如果加上 where mytype="出售"
成为
rs1.Source="select top 10 * from house where mytype="出售" order by ID DESC"
就出错:
Microsoft VBScript 编译器错误 错误 800a03f6
缺少 End
/iisHelp/common/500-100.asp,行242
Microsoft VBScript 编译器错误 错误 800a0408
无效字符
/house/house.asp,行80
rs1.Source="select top 10 * from house where mytype="出售" order by ID DESC"
---------------------------------------------------^
错在那?
双引号问题,改为
rs1.Source="select top 10 * from house where mytype=出售 order by ID DESC"
正解!
rs1.Source="select top 10 * from [house] where mytype=出售 order by ID DESC"