Show records where field=YES

[tyleri]

I am new to ASP & MDB files through ADO connections...and I need to write a query that only displays records with a certain field that equals "yes". Here is the general code I am using:

<%

Dim cnnSimple
Dim rstSimple
Dim strDBPath

strDBPath = Server.MapPath(&quot;database.mdb&quot

Set cnnSimple = Server.CreateObject(&quot;ADODB.Connection&quot

cnnSimple.Open &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&quot; & strDBPath & &quot;;&quot;

Set rstSimple = cnnSimple.Execute(&quot;SELECT * FROM rent&quot

%>

 

[AWithers]

This should work if the field is a text field

SELECT * FROM rent
where yourfield ='yes'

if the field is a boolean then try

SELECT * FROM rent
where yourfield = -1

Hope this helps

Andy

 

[tyleri]

Thanks! now I just need to figure out where to place that in my code... (haha - laugh at me)

 

[ToddWW]

Here you go.

<%
Dim cnnSimple 
Dim rstSimple  
Dim strDBPath  
Dim strQuery

strDBPath = Server.MapPath(&quot;database.mdb&quot;)

Set cnnSimple = Server.CreateObject(&quot;ADODB.Connection&quot;)

cnnSimple.Open &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&quot; & strDBPath & &quot;;&quot;

strQuery = &quot;SELECT * FROM rent WHERE

fieldname

 = 'yes'"

Set rstSimple = cnnSimple.Execute(strQuery)

WHILE NOT rstSimple.EOF
  Response.Write rstSimple("

fieldname

&quot;) & &quot;<br>&quot;
  rstSimple.MoveNext
WEND
%>

ToddWW