?
Solved

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

Posted on 2010-08-19
5
Medium Priority
?
505 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
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/…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

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