close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Dynamic Data for Menu

Thread began 3/27/2010 7:25 am by anonymous | Last modified 5/17/2010 12:41 pm by anonymous | 1525 views | 9 replies

Kev Hegan

filtering dynamically populated menus to remove duplicates

Hi Jason,

Thanks for your offer of help. I have attached the search file. Is that all you need?

I did try using SELECT DISTINCT, which only seemed to work when I had one column in the recordset, although I Googled it and, from my limited understanding, it should have worked. As soon as I put the other columns in it stopped working.

Just to give a bit more info: my database has a list of publications that are classified into different study types, for example. Many of them fall into the same study type, but I want the user to be able to select from a list of the study types, not every single entry in the column which has many multiples of the same one.

I don't know if this makes it more complicated, but there are more menus on the page that need filtering in the same way.

Thanks for any help you can give. I'm sure its a common problem, but as a beginner at this a bit of guidance would be wonderful.

Attached Files
journals_Search.zip

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...