Solved

Remove duplicate from dropdown list when it is the current data field.

Posted on 2010-08-19
5
494 Views
Last Modified: 2012-05-10
I have a dropdown box with 3 selections in it. I placed some code to dynamically show from the database the current field it is set to however it is duplicated with my static choices. is there a way to keep the static selection but not have duplication?

Thanks in advance.
0
Comment
Question by:colonelblue
  • 2
  • 2
5 Comments
 
LVL 18

Expert Comment

by:Rajar Ahmed
Comment Utility
Post ur code . please !
0
 
LVL 22

Expert Comment

by:Om Prakash
Comment Utility
If you are using classic asp then you can compare static values in database if they do not match then display the data...


<select>

<%

set rs = Server.CreateObject("ADODB.recordset")

rs.Open "Select * from Customers", conn

do until rs.EOF

    if not rs("fieldname") = "staticfield" then  

       'add the option in select box..

    end if

    rs.MoveNext

loop

%>

--you can add static option here..

</Select>

Open in new window

0
 

Author Comment

by:colonelblue
Comment Utility
Hello and thank you. I am not certain how to incorporate that code, especially, the ", conn" part.

Here is my code.

Thank s in advance experts.

<select  name="Header" id="Header">
          <option value="<%=((Recordset1.Fields.Item("Page_Header").Value))%>" selected="selected"><%=((Recordset1.Fields.Item("Page_Header").Value))%></option>
          <option value="Maintenance Notice">Maintenance Notice</option>
          <option value="Systems Down">Systems Down</option>
          <option value="All Systems Go">All Systems Go</option>
        </select>

Open in new window

0
 

Author Comment

by:colonelblue
Comment Utility
And to add what I would get as a result shown in dropbox from the above is:

All Systems Go
Maintenance Notice
Systems Down
All Systems Go

The currently selected stuts from the database is "All Systems Go"
But it is repeated.
0
 
LVL 18

Accepted Solution

by:
Rajar Ahmed earned 500 total points
Comment Utility
try this .
<%

static_value = split("Maintenance Notice,System Down,All Systems Go",",")

sql = "select Page_Header from tbl"  ' Adjust ur query 

set dr = con.execute(sql)

dim chk_duplicate

chk_duplicate = false

%>



<select distinct name="Header" id="Header">

         

           <% for each static_ind in static_value%>

          <option value="<%=static_ind%>"><%=static_ind%></option>

           <%next%>

          <%

		  while not dr.eof 

		     for each static_ind in static_value

			     if  trim(static_ind) = trim(dr(0)) then 

				    chk_duplicate = true

				 end if 	

			next

			 if chk_duplicate = false then %>

			  <option value="<%=dr(0)%>"><%=dr(0)%></option>

			<% end if 

			 dr.movenext 

			 chk_duplicate = false   'Again setting the status

		  wend 	 

		  %>

          

</select>

Open in new window

0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now