Solved

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

Posted on 2010-08-19
5
497 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
ID: 33482045
Post ur code . please !
0
 
LVL 22

Expert Comment

by:Om Prakash
ID: 33482283
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
ID: 33486649
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
ID: 33486673
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
ID: 33491550
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

863 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

21 Experts available now in Live!

Get 1:1 Help Now