Database report

[annaMac]

I must be doing something wrong (again) I need to open a database page that
filters the results ie: only shows the results of people living in
Manchester. If I set the query as follows: SELECT * FROM Results WHERE City
= '::Manchester::' I get the No records returned when I run the page even
though I know there are some records containing Manchester - (This is
selected from a drop down list when someone inputs the info into the form.)
Must be the Syntax I am using?

 

[Kathleen Anderson [MVP - FrontPage]]

From: http://support.microsoft.com/kb/306430 If you manually enter the
Value, the SQL statement looks like this:
SELECT * FROM Categories WHERE (CategoryName = 'text string')

So, try SELECT * FROM Results WHERE City = 'Manchester'

 

[annaMac]

Thanks! that did it.

From: http://support.microsoft.com/kb/306430 If you manually enter the
Value, the SQL statement looks like this:
SELECT * FROM Categories WHERE (CategoryName = 'text string')

So, try SELECT * FROM Results WHERE City = 'Manchester'

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/