Get ready for BLACK FRIDAY shopping starting in

Forums

This topic is locked

list/menu

Posted 28 Mar 2002 15:04:58
1
has voted
28 Mar 2002 15:04:58 Robert B. posted:
Can this be done in ultradev?
I want to have 3 list/menu on the same
page in submition form but each menu to have the value
of what ever you pick in the menu before. I have the menu value in a databade table.

example: table1-column1/carid column2/carmake
table2-column1/modelid. column2/model column3/carid
table2-column1/bodyid column2/body column3/modelid

Hope I explain this correctly My english sux
If this is posible can someone tellme about a
tutorial.

Thanks to all in advanced.<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Replies

Replied 28 Mar 2002 15:53:54
28 Mar 2002 15:53:54 Robert B. replied:
this exacly what I want to do in ultradev
www.aspfree.com/authors/salimn/optionex.asp

Thanks again
Replied 28 Mar 2002 16:04:10
28 Mar 2002 16:04:10 Andrew Watson replied:
Do you mean that you will have three lists, if you pick 'Ford' form list one then the contents of list two would be specific to 'Ford' ie 'sierra', 'two tone brown escort MKI', 'KA', but had you selected 'BMW' from list one then list two would contain '318i', '525', 'M3' etc (and so on for the third list box) ??

If this is the case then some thought is necessary as the listbox contents are created at runtime (as page loads) <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

You want to change these content as a selection is made from a previous field.

You could (and i stress could) make the page refresh after a field is updated using javascript and by firing a few variables about create the list box contents to suit.

Hope this helps you out.

Leed
Replied 28 Mar 2002 20:12:22
28 Mar 2002 20:12:22 Robert B. replied:
Leed Thank you But I'm a step below a newbie
and you just speak chinise to me.
I Know if I start cutting and pasting asp
codes I will get it done. But I needs some
cain of visual tutorial the I can follow.

Thank you again
Replied 28 Mar 2002 23:43:58
28 Mar 2002 23:43:58 Dennis van Galen replied:
I know of such a tutorial, but i must warn you that it is not for the fainthearted...
www.macromedia.com/support/ultradev/ts/documents/client_dynamic_listbox.htm

Let me know when i can browse your site for my current car, Ford, Fiesta, RS-16V Melina Blue.

With kind regards,

Dennis van Galen
Webmaster KPN Services
Financial and Information Services
Replied 29 Mar 2002 00:25:38
29 Mar 2002 00:25:38 Jeremy Conn replied:
If am understanding correctly, I think this free UD Extension from <b>Kaosweaver's</b> website should do the trick...

<b>www.kaosweaver.com/Extensions/Dropdown_Rewrite/</b>

Hope that helps...

(UD4|IIS5|WXP|ASP)
*Connman21*
www.conncreativemedia.com
Replied 29 Mar 2002 00:39:29
29 Mar 2002 00:39:29 Dennis van Galen replied:
Yes that's a pretty cool extension, but it is restricted to a STATIC parent list and a dynamic child list. The result is one table with set car models, Ford - VW - Mercedes - Renault - Ferrari, and a child list that if i select the pre-entered Ford option it displays the related Dbase items.

What we want is 3 lists and all 3 have the settings in the Dbase, so if he adds for instance Porsche to the models table then the page would automatically generate a new list item for it, with this extension you cannot do that. It has to be done in the code. But it's still a great extension if you are in need for what it can do.

It does say this in it's faq, so if you want to give it a try...

Question: Why does the function have a fn argument that isn't used?
Answer: This is a way to have the script cascade down to a third drop down, however, the interface for entering this information was cumbersome, so I didn't write it, however, you can go to the scripts section to see an example of this and download the file to model your application of the script with. This can also be used to call any other function you want to call as well.

With kind regards,

Dennis van Galen
Webmaster KPN Services
Financial and Information Services
Replied 29 Mar 2002 15:52:41
29 Mar 2002 15:52:41 Robert B. replied:
Thank you all for the help. connman21 I did
know about that extension but that one does
not work with db "I think" and I'm trying
to do this as dynamic as posible. On the
other hand djvgalen that tutorial is awesome
but Im little stuk with It. I'll let you know how it turns out.
If(NewExtension) = "Good"
else KeepTrying
Thank You All Very Again.<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Replied 30 Mar 2002 13:55:21
30 Mar 2002 13:55:21 Robert B. replied:
Hello again.
I'm working on this tutorial and when I try
to run it say that is expecting an estaiment
on the line that says Wend <img src=../images/dmxzone/forum/icon_smile_dissapprove.gif border=0 align=middle>
Thanks

If (len(oDynaListRS.Fields.Item(txtDynaListLabel).Value) &gt; len(varMaxWidth)) Then
varMaxWidth = oDynaListRS.Fields.Item(txtDynaListLabel).Value
End If
varCheckLength = varCheckLength + 1
varDynaList = varDynaList + 3
oDynaListRS.MoveNext()
Wend

If (varCheckLength &gt; varMaxLength) Then
varMaxLength = varCheckLength
End If
<b></b>
Replied 30 Mar 2002 17:28:03
30 Mar 2002 17:28:03 Viktor Farcic replied:
You're missing WHILE statement. Try something like:

While (Not oDynaListRS.EOF)
If (len(oDynaListRS.Fields.Item(txtDynaListLabel).Value) &gt; len(varMaxWidth)) Then
varMaxWidth = oDynaListRS.Fields.Item(txtDynaListLabel).Value
End If
varCheckLength = varCheckLength + 1
varDynaList = varDynaList + 3
oDynaListRS.MoveNext()
Wend

If (varCheckLength &gt; varMaxLength) Then
varMaxLength = varCheckLength
End If
<b></b>


Viktor Farcic

TalkZone Manager

Reply to this topic