No Values in FP2003 Dropdown

  • Thread starter Thread starter wecmail
  • Start date Start date
W

wecmail

I'm putting together a FrontPage 2003 website and I have an Access
table with a text field called SIZE containing a couple hundred values
that look like:

3/4 - 16
3/4 - 16
3/4 - 16
1 inch
1 inch
1-8
1-8
.....

I use the FrontPage DBRW to create a drop down and it seems to work (it
returns all of the values repeated in the dropdown as you would
expect). Obviously, I only want one of each, so I create a custom query
in DBRW that looks lise:

SELECT DISTINCT size FROM inventory

Now the dropdown contains nothing at all, but I cannot for the life of
me figure out how to fix it. All the other text fields that I've done
so far work perfectly. I suspect it has something to do with the
numeric looking values (that may even look like expressions somewhere
down the line), but I'm just grasping for straws at this point.

Any help would be greatly, greatly appreciated. Thanks for your time!
 
I just created a table in access, put in your sample values, created the
same query you listed (SELECT DISTINCT size FROM inventory) and it returned
perfectly from me.

Here's a suggestion, try running the Query from Access itself first (in the
query builder switch to SQL view and paste in your SELECT statement). if it
works in Access then the problem is in some other part of your code.
 
David-

Thanks...good suggestion and it works fine in Access as you suggested,
which means it's something with FrontPage.

Now I'm even more stumped. Simply changing "Select * ..." to "Select
DISTINCT ..." breaks the thing. Thanks for the thought...

-Bill
 
Bill. If you're using the Database Region Wizard, take a look at
http://support.microsoft.com/default.aspx?scid=kb;en-us;278613 the last part
of the article on "Eliminating Duplicate Entries" talks about how to use
SELECT DISTINCT with the wizard. On a normal ASP page your query would work
fine but the DRW may do something different to it.

Also, look at the code in HTML view and make sure it's the way you expect.
 
David-

I figured it out (apparently). I think that the field name "size" was
being interpreted as a keyword of some sort in the SQL/HTML code. I
changed the field name to "size1" and it works. Thanks for the tips
above...for the record, that's how I was working it, both through DRW
and just trying to code it myself. In any case...

I really appreciate your input and only wish I knew enough to pass on
the favor. Have a good one!

-Bill
 
Back
Top