ReneMiller
Tue Jun 20 08:44:02 CDT 2006
Kathleen,
Thanks for the kind offer of troubleshooting the problem. I did finally get
it to work late yesterday. I used the Custom Query feature of the DBRW. Then
the dropdown menus were populated with data. The SQL statements didn't have
the WHERE statement. This project was actually a test run before I get the
real database so we will see what happens when I get the real data. Hopefully
I can still get it to work then. Thanks for your wonderful website. It is a
great resource for a newbie like me. Thanks also for your willingness to help
help with my problem.
Rene Miller
"Kathleen Anderson [MVP - FrontPage]" wrote:
> Hi Rene:
> If you got it to work with the demo database, then I would suspect something
> is going on with your database. How big is it? If it doesn't contain any
> sensitive data, could you send it to me? The email address I post with is
> valid.
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web:
http://www.spiderwebwoman.com/resources/
>
>
> "Rene Miller" <ReneMiller@discussions.microsoft.com> wrote in message
> news:D9EA6CD8-ACED-43AB-A319-164C8F710C68@microsoft.com...
> > Kathleen,
> >
> > The data type for Grade is Text. The Database is a test database and
> > contains some valid data, but it also had data that needs to be cleaned
> > up.
> > For example in the Grade field it contains 01, 02, 03, etc, but it also
> > contains K, Level1, Level2, etc. These items display correctly on my first
> > page, so I am assuming that is not the problem. I think it must be SQL
> > statement, but can't find the problem. I have left off the Where statement
> > and I get data in the dropdown fields, but when I add Where
> > (grade='::grade::') I get blanks. I did try taking the quote marks out,
> > but
> > still no results.
> >
> > Thanks in advance for your help.
> >
> > "Kathleen Anderson [MVP - FrontPage]" wrote:
> >
> >> Hi Rene:
> >> Is grade a numeric field? If so, try changing (grade='::grade::') to
> >> (grade=::grade::) See: Description of the SQL syntax that is generated
> >> by
> >> the FrontPage Database Results Wizard
> >>
http://support.microsoft.com/kb/306430
> >>
> >>
> >> --
> >>
> >> ~ Kathleen Anderson
> >> Microsoft MVP - FrontPage
> >> Spider Web Woman Designs
> >> web:
http://www.spiderwebwoman.com/resources/
> >>
> >>
> >> "Rene Miller" <ReneMiller@discussions.microsoft.com> wrote in message
> >> news:180B5548-B4DA-4BDC-90EB-0C348BF56D17@microsoft.com...
> >> >I am trying to create a webpage that will allow users to specifiy what
> >> >data
> >> > they would like to look at in a database by using two dropdown menus. I
> >> > have
> >> > followed the wonderful instructions at
> >> >
http://spiderwebwoman.com/tutorials/doubledropdown.htm. I can get it to
> >> > work
> >> > on the demo database, but not with my data base.
> >> >
> >> > The first page is grade. The users selects a grade level and the
> >> > results
> >> > are
> >> > suppose to go to subject page. The page displays but the dropdowns are
> >> > blank.
> >> >
> >> >
> >> > Below are the SQL statements for each dropdown:
> >> >
> >> > "SELECT DISTINCT grade FROM StateAchievementStandards WHERE
> >> > (grade='::grade::')"
> >> >
> >> > "SELECT DISTINCT subject FROM StateAchievementStandards WHERE
> >> > (grade='::grade::')"
> >> >
> >> > I have gone over steps many times and I can't see why it isn't working.
> >> > Hopefully somebody else can see my error.
> >> >
> >> > Thanks in advance the help.
> >>
> >>
> >>
>
>
>