HighDots Forums  

Sorting Dropdown list

Macromedia Dreamweaver Macromedia Dreamweaver Discussions (macromedia.dreamweaver)


Discuss Sorting Dropdown list in the Macromedia Dreamweaver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
MasterAllan
 
Posts: n/a

Default Sorting Dropdown list - 11-04-2005 , 03:08 AM






Hi All,
I know there are topics about what Im goint to ask, but I really dont
understand nything off it.

All the data is in a table.
The names of the colums are:
WPaperNaam | WPaperCat | WPaperRoot

when you add a new row in the table you have to fill in also a catergorie.
What I want is a dropdown list what wil show the categories.

When I use the Dynamic List then it will show all the content from the colum
WPaperCat .
If there are 3 rows with the WPaperCat like Celebs and 5 rows with Cars I
want the list to show only once Celebs and only once Cars.
Could someone help me out?

This is the code DW has made:
<select name="select">
<%
While (NOT rsMenu.EOF)
%>
<option value="<%=(rsMenu.Fields.Item("WPaperCat").Value)% >" <%If (Not
isNull((rsMenu.Fields.Item("WPaperCat").Value))) Then If
(CStr(rsMenu.Fields.Item("WPaperID").Value) =
CStr((rsMenu.Fields.Item("WPaperCat").Value))) Then
Response.Write("selected=""selected""") : Response.Write("")%>
Quote:
%=(rsMenu.Fields.Item("WPaperCat").Value)%></option
%
rsMenu.MoveNext()
Wend
If (rsMenu.CursorType > 0) Then
rsMenu.MoveFirst
Else
rsMenu.Requery
End If
%>
</select>



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.