Database with FrontPage

[Kate]

I am trying to select records to display from a database -
i.e. all products beginning with A. I have created 2
pages - PRODSELECT contains letters A B C etc with a
hyperlink to the other page - ENQUIRY.ASP. The hyperlink
contains the following: enquiry.asp?PROD=A% and so on for
each letter. The enquiry page has an insert page component
to use the PRODSELECT page, and a database results area.
All works fine except that the ENQUIRY form contains all
records - not the ones selected.

Any thoughts before I lose all my hair?

 

[Kathleen Anderson [MVP - FP]]

Your SQL should look something like this:
SELECT * FROM Categories WHERE (CategoryName LIKE 'text string%')

from: http://support.microsoft.com/default.aspx?scid=kb;[LN];306430