Filter Dropdown

[Leslie Taylor]

I have a filter field that is a bit field. Normally in the edit form bit fields have a dropdown of True/False. In the filter dropdown it gives me nothing. How do I get this??

Thanks

[John]

Hi Leslie,

It sounds like you're using SQL database? Well anyway, run this datatypes program and see what type of field your "bit" field is coming back as. That will help us determine if there's something different about your database that's causing the problem.

John

<%
DSNname=&#34;DSN=pubs;UID=sa;PWD=;&#34;
TableName=&#34;employee&#34;

&#39;------------------------------------------------------------
&#39;---- Fill in the above two variables and run the program ---
&#39;------------------------------------------------------------

response.write(&#34;<h3>List of the Data Field Types<BR>&#34
response.write(&#34;for Table: &#34; & TableName & &#34;<BR>&#34
Set oRs=Server.CreateObject(&#34;ADODB.Recordset&#34

oRs.open &#34;SELECT * from &#34; & TableName, DSNname, 3,1,1

response.write(&#34;RecountCount=&#34; & oRs.recordcount & &#34;<BR>&#34
response.write(&#34;</h3></center>&#34
response.write(&#34;<center><table border=3 cellspacing=3 cellpadding=3>&#34
response.write(&#34;<th>Field Name</th> <th>Field Type</th> <th>Field Length</th>&#34
for i=0 to oRs.fields.count-1
response.write(&#34;<TR>&#34
response.write(&#34;<td>&#34; & oRs.fields(i).name & &#34;</td>&#34
response.write(&#34;<td>&#34; & oRs.fields(i).type & &#34;</td>&#34
response.write(&#34;<td>&#34; & oRs(i).DefinedSize & &#34;</td>&#34
response.write(&#34;</TR>&#34
next

response.write(&#34;</table></center>&#34
oRs.close
Set oRs=nothing
%>



------------
Leslie Taylor at 10/11/01 2:15:54 PM


I have a filter field that is a bit field. Normally in the edit form bit fields have a dropdown of True/False. In the filter dropdown it gives me nothing. How do I get this??

Thanks