Solved

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

Posted on 2010-08-19
5
498 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
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/…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

803 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