Limit Data View with Parameter in URL

[bizproducer]

I have a simple Access database and I am using FrontPage(which may be the problem) to create ASP pages. I want the ASP pages to do the following, one, I want a views page, viewall.asp where I can put this as the URL for example to limit the Species field:

viewall.asp?Species=Cherry

I also am looking for a boiler plate, simple ASP page(s) that will allow the end user to update records, add records, etc. Are there any good template places out there that have what I need? Help please!

 

[DotNetGnat]

i think you are looking for a ASp data grid...try these links:

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=9083&lngWId=4

http://www.asptoday.com/Content.aspx?id=1485

-DNG

 

[FesterSXS]

viewall.asp

<%
strSQL = "SELECT x, y, z from myTable WHERE Species='" & Request.QueryString("Species") & "'"
%>

Tony

Spirax-Sarco - steam traps control valves heat exchangers
Sun Villa - Luxury Florida accommodation

 

[DotNetGnat]

please elaborate your problem so that you can get correct solutions...

-DNG