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?

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/


"annaMac" <(E-Mail Removed)> wrote in message
news:651413D9-A453-413C-8C9D-(E-Mail Removed)...
>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?

Thanks! that did it.

"Kathleen Anderson [MVP - FrontPage]" wrote:

> 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/
>
>
> "annaMac" <(E-Mail Removed)> wrote in message
> news:651413D9-A453-413C-8C9D-(E-Mail Removed)...
> >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?
>
>
>