|
|
You're in the
inetserver asp general
group:Populate Dynamic dropdown box
inetserver asp general:
Simon Gare wrote: > Hi, > > have form on asp page that recalls data from the recordset and > populates all the fields except the dynamic dropdown box that > doesn't, just shows default value. How do I make it populate based on > the entry in the db? > As you write each option string to Response, compare the string you are writing as the option's value to the data in the recordset. If They are the same, write "selected" to response before closing the option's tag. Otherwise, don't write "selected". -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup.
[quoted text, click to view]
Simon Gare wrote: > Thanks Bob, > > Got it > > <select name="Access_level" id="select2"> > <option value"">Select access level</option> > <option value="1" <% response.write "selected" > %>>Driver</option> > <option value="2" <% response.write "selected" > %>>Operator / Controller</option> > <option value="3" <% response.write "selected" > %>>Administrator</option> > </select> > > Worked perfectly trying too hard again I was Dim this and Dim that > couldnt get my head around it. > > Simon > That works?? If you say so ... -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup.
[quoted text, click to view]
Simon Gare wrote: Yes, that's more like it. Have you tried it? Does it work? If not, write> Bob, > > have a problem, the way I did it hasn't worked should I be doing > something like, > > <% if ACCESS_LEVEL(0) = true then response.write "selected" %> > > ?? > the value of ACCESS_LEVEL(0) to Response and show us what it is. -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup.
Hi,
have form on asp page that recalls data from the recordset and populates all the fields except the dynamic dropdown box that doesn't, just shows default value. How do I make it populate based on the entry in the db? Regards Simon -- Simon Gare The Gare Group Limited website: www.thegaregroup.co.uk website: www.privatehiresolutions.co.uk
Thanks Bob,
Got it <select name="Access_level" id="select2"> <option value"">Select access level</option> <option value="1" <% response.write "selected" %>>Driver</option> <option value="2" <% response.write "selected" %>>Operator / Controller</option> <option value="3" <% response.write "selected" %>>Administrator</option> </select> Worked perfectly trying too hard again I was Dim this and Dim that couldnt get my head around it. Simon .. [quoted text, click to view] "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message news:OhPbG7eWHHA.192@TK2MSFTNGP04.phx.gbl... > Simon Gare wrote: > > Hi, > > > > have form on asp page that recalls data from the recordset and > > populates all the fields except the dynamic dropdown box that > > doesn't, just shows default value. How do I make it populate based on > > the entry in the db? > > > > As you write each option string to Response, compare the string you are > writing as the option's value to the data in the recordset. If They are > the same, write "selected" to response before closing the option's tag. > Otherwise, don't write "selected". > > -- > Microsoft MVP -- ASP/ASP.NET > Please reply to the newsgroup. The email account listed in my From > header is my spam trap, so I don't check it very often. You will get a > quicker response by posting to the newsgroup. > >
Bob,
have a problem, the way I did it hasn't worked should I be doing something like, <% if ACCESS_LEVEL(0) = true then response.write "selected" %> ?? Simon [quoted text, click to view] "Simon Gare" <simon@simongare.com> wrote in message news:%23pSWcAfWHHA.4964@TK2MSFTNGP06.phx.gbl... > Thanks Bob, > > Got it > > <select name="Access_level" id="select2"> > <option value"">Select access level</option> > <option value="1" <% response.write "selected" > %>>Driver</option> > <option value="2" <% response.write "selected" %>>Operator / > Controller</option> > <option value="3" <% response.write "selected" > %>>Administrator</option> > </select> > > Worked perfectly trying too hard again I was Dim this and Dim that couldnt > get my head around it. > > Simon > > . > "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message > news:OhPbG7eWHHA.192@TK2MSFTNGP04.phx.gbl... > > Simon Gare wrote: > > > Hi, > > > > > > have form on asp page that recalls data from the recordset and > > > populates all the fields except the dynamic dropdown box that > > > doesn't, just shows default value. How do I make it populate based on > > > the entry in the db? > > > > > > > As you write each option string to Response, compare the string you are > > writing as the option's value to the data in the recordset. If They are > > the same, write "selected" to response before closing the option's tag. > > Otherwise, don't write "selected". > > > > -- > > Microsoft MVP -- ASP/ASP.NET > > Please reply to the newsgroup. The email account listed in my From > > header is my spam trap, so I don't check it very often. You will get a > > quicker response by posting to the newsgroup. > > > > > >
Simon Gare wrote on 26 feb 2007 in
microsoft.public.inetserver.asp.general: [quoted text, click to view] > <select name="Access_level" id="select2"> > <option value"">Select access level</option> > <option value="1" <% response.write "selected" > %>>Driver</option> > <option value="2" <% response.write "selected" > %>>Operator / > Controller</option> > <option value="3" <% response.write "selected" > %>>Administrator</option> > </select> > I don't think this is very useful as it just places a selected in each option, so probably the top one will have an effect. <% s = ~numeric result from database~ %> <select name="Access_level" id="select2"> <option value=""> Select access level</option> <option value="1" <% if s=1 then response.write "selected" %>> Driver</option> <option value="2" <% if s=2 then response.write "selected" %>> Operator / Controller</option> <option value="3" <% if s=3 then response.write "selected" %>> Administrator</option> </select> -- Evertjan. The Netherlands.
it did Bob thanks
<option value="00:10" <% if (AirportStation.Fields.Item("LeadTime").Value) = ("00:10:00") then response.write "selected" %>>10 Mins</option> Regards Simon [quoted text, click to view] "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message news:eBJf8bfWHHA.996@TK2MSFTNGP02.phx.gbl... > Simon Gare wrote: > > Bob, > > > > have a problem, the way I did it hasn't worked should I be doing > > something like, > > > > <% if ACCESS_LEVEL(0) = true then response.write "selected" %> > > > > ?? > > > Yes, that's more like it. Have you tried it? Does it work? If not, write > the value of ACCESS_LEVEL(0) to Response and show us what it is. > -- > Microsoft MVP -- ASP/ASP.NET > Please reply to the newsgroup. The email account listed in my From > header is my spam trap, so I don't check it very often. You will get a > quicker response by posting to the newsgroup. > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |