Dynamic Lists

[c510_biz]

Hiya,

Apologies is this is in the wrong place and apologies if this seems like a daft question!

I'm building a website that looks at a particular aircraft type. The major part of it is a database, which has the current record for each individual aircraft, as well as past history for each different owner etc.

One of the fields in the database is for the airport where the aircraft was based, as this is one part of the database I want to search on.

What I wanted to do was have a drop down list auto populated with all of the Bases from the database, that once selected goes off to a results page that brings back all the aircraft based at that airport.

But for some reason I can't seem to do this.

I've been using the List/Menu fuction, and making it Dynamic, but it nevers seems to work.

I've searched around for some idiot proof instructions, but couldn't find any.

I'm using CS3, ASP JavaScript

Thanks

[Newsgroup_User]

I don't know is this any good to you.

http://www.dwzone-it.com/Extension/AdvFormControls/How_DependentCombo.asp

the above is a commercial extension, simple to use. ok support

I have used the master detail from Nitobi over the last 2 months

http://www.nitobi.com/products/completeui/demos/explorer/index.html

It is very good if u have a large db, it takes a little concentration but v
good code. ok support.

k

[c510_biz]

Hey there,

Thanks for the suggestion on the extension. It's just a home project so I don't really want to spend more money. Many thanks for taking the time for the suggestion though.

[Newsgroup_User]

What part is not working?

The drop down of airports?
Redirection to list of aircraft?

c510.biz wrote:

> Hiya,
>
> Apologies is this is in the wrong place and apologies if this seems
> like a daft question!
>
> I'm building a website that looks at a particular aircraft type. The
> major part of it is a database, which has the current record for each
> individual aircraft, as well as past history for each different owner
> etc.
>
> One of the fields in the database is for the airport where the
> aircraft was based, as this is one part of the database I want to
> search on.
>
> What I wanted to do was have a drop down list auto populated with
> all of the Bases from the database, that once selected goes off to a
> results page that brings back all the aircraft based at that airport.
>
> But for some reason I can't seem to do this.
>
> I've been using the List/Menu fuction, and making it Dynamic, but it
> nevers seems to work.
>
> I've searched around for some idiot proof instructions, but couldn't
> find any.
>
> I'm using CS3, ASP JavaScript
>
> Thanks



--

[c510_biz]

quote:

---

Originally posted by: Newsgroup User
What part is not working?

The drop down of airports?
Redirection to list of aircraft?

---

Hi There,

It's the drop down list of airports that's not working. I'm probably just missing a step or something, but for some reason I'm completely vexed.

Thanks

[Newsgroup_User]

> It's the drop down list of airports that's not working. I'm probably just
> missing a step or something, but for some reason I'm completely vexed.


1. Create a recordset - Give it a name, select your Connection, switch to
Advanced View, in the SQL box, type "Select distinct airport_columnname from
table order by airport_columname"

2. Put a List/Menu in a form tag on your page. From the Properties window,
click the Dynamic button, then select Options from recordset and choose the
recordset you created in step 1.

3. Save the page and push F12 to preview.

[c510_biz]

Hi there,

Thanks for coming back to me, it's appreciated.

I've got that far, but still have problems, I guess I must be setting something in the Dynamic List / Menu options:

I have the Values, Labels and Select Value equal to, all set to the col in the db where the airport codes are. Which I guess must be wrong?

When I try to view, there list is empty, and when I go back to try and change in Dreamweaver, it say that the col "" can't be found and to please select a new col.

Thanks!

[Newsgroup_User]

> I have the Values, Labels and Select Value equal to, all set to the col in
> the
> db where the airport codes are. Which I guess must be wrong?
>
> When I try to view, there list is empty, and when I go back to try and
> change
> in Dreamweaver, it say that the col "" can't be found and to please select
> a
> new col.

What database? If Access, did you give IUSR the permission to modify the db
folder?

[c510_biz]

It is indeed an Access db. All of the other database bits are working, but this part. would IUSR make a difference in this specific case and not the others?

Many thanks for taking the time to answer

[Newsgroup_User]

> It is indeed an Access db. All of the other database bits are working, but
> this
> part. would IUSR make a difference in this specific case and not the
> others?


This story keeps growing. What others?

[c510_biz]

Sorry, there are other search pages on the website. Although the actual pages aren't visible, these are just used as dummy pages so that I can copy and paste the reults url directly into a link that users can press on directly.

There are about 6 of these, looking for various things such as only Current records, records that relate to aircraft in production etc.

The site is at http://www.c510.biz if you have time to look.

thanks

[Newsgroup_User]

>>>>It is indeed an Access db. All of the other database bits are working,
>>>>but this
>>>>part. would IUSR make a difference in this specific case and not the
>>>>others?


No. You have other issues.

[c510_biz]

quote:

---

No. You have other issues.

---

Wow, thanks for your help!