need to have a way for my database to show the records if in one of the fields i have a true /false statement

i want people to enter info in to the database

when a vistor searches the database he can only see the records that has the true statment in the field X which i will put in manually

can some body point me in the right direction

i have a sample below what i am using i dont know which way to go
can it be put in the sql?



VBScript




<!--#include file="../Connections/client.asp" -->
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
If (Request.QueryString("ProdID" <> "" Then
Recordset1__MMColParam = Request.QueryString("ProdID"
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset"
Recordset1.ActiveConnection = MM_client_STRING
Recordset1.Source = "SELECT * FROM cdinfo WHERE ProdID = " + Replace(Recordset1__MMColParam, "'", "''" + ""
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%>
<%




Edited by - cerami2 on 15 Oct 2003 14:39:59

I dont see you using the field called X in you query. like where X = 'true'.. if that doesnt help then you'll have to reword for me to understand what you want.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I dont see you using the field called X in you query. like where X = 'true'.. if that doesnt help then you'll have to reword for me to understand what you want.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

well its the 18th ,it took me a few days
but i figured it out...
i saw the light -Ha Ha
thanks for a lease looking at it for me