将 asp-classic SQL 语句翻译为可识别的术语
我在一个 ASP 文件中有这个 SQL 语句需要处理，但我以前从未处理过 .asp。我主要使用 PHP 工作，我对 PHP 的 Select SQL 语句更熟悉。
我只需要一些帮助，将其简化为熟悉的术语：
SelectSQL = "SELECT * FROM BusinessInfo WHERE ((CatID = " & intBusiness_Category & ") or (CatID2 = " & intBusiness_Category & ") or (CatID3 = " & intBusiness_Category & ")) and (intStatusCodeID = 1) and (intOnWeb = 1) Order By vcBusinessName"
I have this SQL statment in an ASP file that i to deal with, and i have never dealt with .asp before. I workly mainly with PHP some im more familiar with PHP's Select SQL statements.
I just need some assistance bringing it down to familiar terms:
SelectSQL = "SELECT * FROM BusinessInfo WHERE ((CatID = " & intBusiness_Category & ") or (CatID2 = " & intBusiness_Category & ") or (CatID3 = " & intBusiness_Category & ")) and (intStatusCodeID = 1) and (intOnWeb = 1) Order By vcBusinessName"
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
该语句从 BusinessInfo 表中选择 CatID、CatID2 或 CatID3 列中的值与您的变量 (intBusiness_Category) 匹配且 intStatusCodeID 和 intOnWeb 值为 1 的所有行和列。它还按vcBusinessName 列
The statement is selecting all rows and columns from the BusinessInfo table that have a value in the CatID, CatID2, or CatID3 columns that matches your variable (intBusiness_Category) and the intStatusCodeID and intOnWeb values are 1. It is also sorted by the values in the vcBusinessName column