Dreamweaver MX Dynamic Drop downs

[IVisualise]

Hi,

I'm using DW MX and I was trying to have a drop down list populate a second dropdown list dynamically. Both these lists are gonna be taken from the database (SQL Server 2000) and are in the same table.

I rather have the second list populate without refreshing the page.

Any help would be appreciated.

NOTE: I can't modify the table or create a new table in the database.

 

[TonyU]

[tt]This should get you in the right path...

faq333-1507

<%=Tony%>
€ € € € € € € € € €
​

 

[IVisualise]

Thanks TonyU,

But it really doesn't answer my quesiton:

1. I need to find a feature in Dreamweaver MX that does it for me.
2. If that doesn't help, then I need to find a code that does it.


I hope this helps you in finding a solution to this.

Thanks.

 

[TonyU]

[tt]
I doubt you're going to find an extension from macromedia (if you do let me know) to do this because the more productive way of doing this is with javascript. But I've been wrong before

The link I gave you has links with samples and code. did you read it?

<%=Tony%>
€ € € € € € € € € €
​

 

[IVisualise]

Yes I did.

But it's all javascript. I wanted something in ASP.

 

[TonyU]

[tt][
keep in mind (as you may know)

Javascript = client side (which is what one would want)


ASP = server side (making trips to the server everytime is not my thing)

<%=Tony%>
€ € € € € € € € € €
​

 

[IVisualise]

I'll keep that in mind.

Thanks so much.

 

[mxjunkie]

Http://www.kermy.com/Extensions

Dynamic Dependent Drop Down List is what you are looking for

 

[TonyU]

[tt]
There you go, but again javascript

<%=Tony%>
€ € € € € € € € € €
​

 

[IVisualise]

This Extention is amazing. I found something similar to this yesterday.

BUT....

Again, this doens't solve my problem. Both my drop down lists are going to be connected to the same table.

This is how my database is structured. I have one table, where my main fields are Company and Contact. I can have multiple records with the same company name but different contact names. I just want the company name to be included in the drop down list once. And then have all the contact names for that particular company chosen to be displayed in the second drop down list.

I hope this will further explain my situation.

 

[schase]

wont work then.

not off the same table anyhow.

make a query in your access for companies.

then run the contact off of the linked value of companies.

&quot;Never underestimate the power of determination&quot;

Stuart

 

[IVisualise]

I don't understand what you're saying schase.

I'm sorry, I've been working on this for too long and my head is not in the right place anymore.

 

[TonyU]

[tt]

How about this:

Table1
ID-------- C_ID--------Company------Contact
1 1 ABC inc John Smith
2 1 ABC inc Jose Vargas
3 1 ABC inc Joe Millionare

Create a C_ID (Child ID) on this table populating the new field with the Primary ID corresponding to the company.

Then use your SQL to pull similar ID's...

Just a thought

<%=Tony%>
€ € € € € € € € € €
​

 

[OnAFan]

THis is way too late to help the author, but here is a link to help people in the future (from Macromedia... cut and paste text!)

 

[OnAFan]

THis is way too late to help the author, but here is a link to help people in the future (from Macromedia... cut and paste text!)

http://www.macromedia.com/bin/tech_...radev/ts/documents/client_dynamic_listbox.htm

 

[lebisol]

http://ultradev.buzzinet.co.uk/asp/tutorials/child_dropdown/index.asp

> need more info?
:: don't click HERE ::