在ADODB在WHERE子句使用多值查阅字段 [英] using a multi-value Lookup field in a WHERE clause under ADODB
本文介绍了在ADODB在WHERE子句使用多值查阅字段的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
你如何在Access数据库中选择一个基于多值查阅字段行?
下面的ASP code。使用多数据列时没有返回值:
<%
昏暗的承包商
昏暗Contractors_cmd
昏暗Contractors_numRows设置Contractors_cmd =的Server.CreateObject(ADODB.Command)
Contractors_cmd.ActiveConnection = MM_Listings_STRING
Contractors_cmd.CommandText =SELECT * FROM WHERE承包商= UserStatus有效和AGENTID =&放大器;会议(AGENTID)
Contractors_cmd。prepared = TRUE集承包商= Contractors_cmd.Execute
Contractors_numRows = 0
%GT;
解决方案
如果 UserStatus
是一个多值查找字段,该字段的个人价值(S)的通过 UserStatus.Value
访问,所以你需要使用
... WHERE UserStatus.Value =活动...
How do you select rows based on a multi-value Lookup field in an Access database?
The below ASP code returns no value when using multi-data column:
<%
Dim Contractors
Dim Contractors_cmd
Dim Contractors_numRows
Set Contractors_cmd = Server.CreateObject ("ADODB.Command")
Contractors_cmd.ActiveConnection = MM_Listings_STRING
Contractors_cmd.CommandText = "SELECT * FROM Contractor WHERE UserStatus = 'Active' AND AgentID= "& Session("AgentID")
Contractors_cmd.Prepared = true
Set Contractors = Contractors_cmd.Execute
Contractors_numRows = 0
%>
解决方案
If UserStatus
is a multi-value Lookup field then the individual value(s) of that field are accessed via UserStatus.Value
so you'll need to use
... WHERE UserStatus.Value = 'Active' ...
这篇关于在ADODB在WHERE子句使用多值查阅字段的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文