| Groups | Blog | Home |
inetserver asp db : Still Not Resolved
I want to display two fiels from a query in a combo box. I am checking to make sure that the the selected fields do generate value. However, in the combo box, I have only one field that is being displayed instead of two fields. I would like to know whether this can be solved in the existing code? Thanks CODE: <html> <head> <title>Populating two fields in combo box from a query</title> </head> <body> <h2> Populating two fields in combo box from a query</h2> <% Dim oConn Dim oRS Dim vCS Dim sqltxt set oConn=server.CreateObject("ADODB.connection") vCS = "Provider=Microsoft.Jet.OLEDB.4.0" vCS = vCS & "; Data Source=C:\Sailors.mdb" oConn.connectionstring = vCS oConn.Open set oRS = server.CreateObject("ADODB.recordset") sqltxt = "SELECT BoatName, BoatClass FROM Boats;" oRS.Open sqltxt,oConn Response.Write sqltxt & "<br>" Response.Write oRS("BoatName") & "<br>" Response.Write oRS("BoatClass") & "<br>" 'Response.End %> <select name="lstBoats" size="1"> <% Do while not oRS.EOF response.Write "<option value='" & oRS("BoatName") & "'>" response.Write oRS("BoatClass") & "</option>" oRS.MoveNext Loop %> </select> <%oRS.Close Set oRS = nothing %> <%'Response.Write "Hey You" & "<br>" %> </body> </html>
Bob,
Here is the output in html. Thanks OUTPUT: <html> <head> <title>Populating two fields in combo box from a query</title> </head> <body> <h2> Populating two fields in combo box from a query</h2> SELECT BoatName, BoatClass FROM Boats;<br>A Sweet Song<br>Laser<br> <select name="lstBoats" size="1"> <option value='A Sweet Song'>Laser</option><option value='Blackbeard'>Laser</option><option value='No Excuse to Lose'>Laser</option><option value='No Excuse Two Lose'>Laser</option><option value='White Lightning'>Soling</option><option value='Teal'>Soling</option><option value='TGV'>Soling</option><option value='BB3'>Soling</option><option value='Nuts and Bolts'>Soling</option><option value='Psycho'>Soling</option><option value='Shasta'>Flying Scot</option><option value='Daphne'>Flying Scot</option><option value='Red White and Blue'>Flying Scot</option> </select> </body> </html> [quoted text, click to view] "Bob Barrows [MVP]" wrote:
> Jack wrote: > > Hi, > > I want to display two fiels from a query in a combo box. I am > > checking to make sure that the the selected fields do generate value. > > However, in the combo box, I have only one field that is being > > displayed instead of two fields. I would like to know whether this > > can be solved in the existing code? Thanks > > Please show us the html that results from the code. > -- > 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,
In my combo box, I am seeing only one field with the output as Laser Laser Laser Laser Soling Soling Soling Soling Soling Soling Flying Scot Flying Scot Flying Scot That's the problem I have. Do you think the size of the combo box needs to be widened to accommodate the first field or what? Thanks. [quoted text, click to view] "Bob Barrows [MVP]" wrote:
> If the data in Boats looks like this: > A Sweet Song | Laser > Blackbeard | Laser > No Excuse to Lose | Laser > No Excuse Two Lose | Laser > White Lightning | Soling > Teal | Soling > TGV | Soling > BB3 | Soling > Nuts and Bolts | Soling > Psycho | Soling > Shasta | Flying Scot > Daphne | Flying Scot > Red White and Blue | Flying Scot > > Then that is the output I would expect from your code > > What is wrong with it? What do you want it to look like? > > Jack wrote: > > Bob, > > Here is the output in html. Thanks > > OUTPUT: > > > > <html> > > <head> > > <title>Populating two fields in combo box from a query</title> > > </head> > > > > <body> > > <h2> > > Populating two fields in combo box from a query</h2> > > > > SELECT BoatName, BoatClass FROM Boats;<br>A Sweet Song<br>Laser<br> > > <select name="lstBoats" size="1"> > > <option value='A Sweet Song'>Laser</option><option > > value='Blackbeard'>Laser</option><option value='No Excuse to > > Lose'>Laser</option><option value='No Excuse Two > > Lose'>Laser</option><option value='White > > Lightning'>Soling</option><option value='Teal'>Soling</option><option > > value='TGV'>Soling</option><option value='BB3'>Soling</option><option > > value='Nuts and Bolts'>Soling</option><option > > value='Psycho'>Soling</option><option value='Shasta'>Flying > > Scot</option><option value='Daphne'>Flying Scot</option><option > > value='Red White and Blue'>Flying Scot</option> </select> > > > > </body> > > </html> > > > > -- > 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. > >
Thanks for the advise Bob. I appreciate it. I will try it. Thanks again.
[quoted text, click to view] "Bob Barrows [MVP]" wrote:
> No, resizing won't do anything. The combo box (actually, it is called a > "dropdown", or, better yet, a "select" - there is no such combo box in > html) is displaying exactly what the html is telling it to display. > > Look at one of the option tags: > <option value='A Sweet Song'>Laser</option> > It sounds as if you are expecting the content of the value attribute ("A > Sweet Song") to be displayed as well as the option tag's text ("Laser" - > the portion between the opening and closing tags). Sorry, it just does > not work that way. The dropdown will display whatever is in the text, > and only what is in the text. So you need to modify your code to make > the resulting html look the way you want it to look, probably via > concatenation. Start with straight html. Write small .htm a page > containing hard-coded html that gives you what you want. Then go back to > your code and modify it so that it results in the same html. > > > Jack wrote: > > Bob, > > In my combo box, I am seeing only one field with the output as > > Laser > > Laser > > Laser > > Laser > > Soling > > Soling > > Soling > > Soling > > Soling > > Soling > > Flying Scot > > Flying Scot > > Flying Scot > > That's the problem I have. Do you think the size of the combo box > > needs to be widened to accommodate the first field or what? Thanks. > > > > "Bob Barrows [MVP]" wrote: > > > >> If the data in Boats looks like this: > >> A Sweet Song | Laser > >> Blackbeard | Laser > >> No Excuse to Lose | Laser > >> No Excuse Two Lose | Laser > >> White Lightning | Soling > >> Teal | Soling > >> TGV | Soling > >> BB3 | Soling > >> Nuts and Bolts | Soling > >> Psycho | Soling > >> Shasta | Flying Scot > >> Daphne | Flying Scot > >> Red White and Blue | Flying Scot > >> > >> Then that is the output I would expect from your code > >> > >> What is wrong with it? What do you want it to look like? > >> > >> Jack wrote: > >>> Bob, > >>> Here is the output in html. Thanks > >>> OUTPUT: > >>> > >>> <html> > >>> <head> > >>> <title>Populating two fields in combo box from a query</title> > >>> </head> > >>> > >>> <body> > >>> <h2> > >>> Populating two fields in combo box from a query</h2> > >>> > >>> SELECT BoatName, BoatClass FROM Boats;<br>A Sweet Song<br>Laser<br> > >>> <select name="lstBoats" size="1"> > >>> <option value='A Sweet Song'>Laser</option><option > >>> value='Blackbeard'>Laser</option><option value='No Excuse to > >>> Lose'>Laser</option><option value='No Excuse Two > >>> Lose'>Laser</option><option value='White > >>> Lightning'>Soling</option><option > >>> value='Teal'>Soling</option><option > >>> value='TGV'>Soling</option><option > >>> value='BB3'>Soling</option><option value='Nuts and > >>> Bolts'>Soling</option><option value='Psycho'>Soling</option><option > >>> value='Shasta'>Flying Scot</option><option value='Daphne'>Flying > >>> Scot</option><option value='Red White and Blue'>Flying > >>> Scot</option> </select> > >>> > >>> </body> > >>> </html> > >>> > >> > >> -- > >> 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. > > -- > 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]
Jack wrote: > Hi, > I want to display two fiels from a query in a combo box. I am > checking to make sure that the the selected fields do generate value. > However, in the combo box, I have only one field that is being > displayed instead of two fields. I would like to know whether this > can be solved in the existing code? Thanks Please show us the html that results from the code. -- 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.
If the data in Boats looks like this:
A Sweet Song | Laser Blackbeard | Laser No Excuse to Lose | Laser No Excuse Two Lose | Laser White Lightning | Soling Teal | Soling TGV | Soling BB3 | Soling Nuts and Bolts | Soling Psycho | Soling Shasta | Flying Scot Daphne | Flying Scot Red White and Blue | Flying Scot Then that is the output I would expect from your code What is wrong with it? What do you want it to look like? [quoted text, click to view] Jack wrote: > Bob, > Here is the output in html. Thanks > OUTPUT: > > <html> > <head> > <title>Populating two fields in combo box from a query</title> > </head> > > <body> > <h2> > Populating two fields in combo box from a query</h2> > > SELECT BoatName, BoatClass FROM Boats;<br>A Sweet Song<br>Laser<br> > <select name="lstBoats" size="1"> > <option value='A Sweet Song'>Laser</option><option > value='Blackbeard'>Laser</option><option value='No Excuse to > Lose'>Laser</option><option value='No Excuse Two > Lose'>Laser</option><option value='White > Lightning'>Soling</option><option value='Teal'>Soling</option><option > value='TGV'>Soling</option><option value='BB3'>Soling</option><option > value='Nuts and Bolts'>Soling</option><option > value='Psycho'>Soling</option><option value='Shasta'>Flying > Scot</option><option value='Daphne'>Flying Scot</option><option > value='Red White and Blue'>Flying Scot</option> </select> > > </body> > </html> > -- 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.
No, resizing won't do anything. The combo box (actually, it is called a
"dropdown", or, better yet, a "select" - there is no such combo box in html) is displaying exactly what the html is telling it to display. Look at one of the option tags: <option value='A Sweet Song'>Laser</option> It sounds as if you are expecting the content of the value attribute ("A Sweet Song") to be displayed as well as the option tag's text ("Laser" - the portion between the opening and closing tags). Sorry, it just does not work that way. The dropdown will display whatever is in the text, and only what is in the text. So you need to modify your code to make the resulting html look the way you want it to look, probably via concatenation. Start with straight html. Write small .htm a page containing hard-coded html that gives you what you want. Then go back to your code and modify it so that it results in the same html. [quoted text, click to view] Jack wrote: > Bob, > In my combo box, I am seeing only one field with the output as > Laser > Laser > Laser > Laser > Soling > Soling > Soling > Soling > Soling > Soling > Flying Scot > Flying Scot > Flying Scot > That's the problem I have. Do you think the size of the combo box > needs to be widened to accommodate the first field or what? Thanks. > > "Bob Barrows [MVP]" wrote: > >> If the data in Boats looks like this: >> A Sweet Song | Laser >> Blackbeard | Laser >> No Excuse to Lose | Laser >> No Excuse Two Lose | Laser >> White Lightning | Soling >> Teal | Soling >> TGV | Soling >> BB3 | Soling >> Nuts and Bolts | Soling >> Psycho | Soling >> Shasta | Flying Scot >> Daphne | Flying Scot >> Red White and Blue | Flying Scot >> >> Then that is the output I would expect from your code >> >> What is wrong with it? What do you want it to look like? >> >> Jack wrote: >>> Bob, >>> Here is the output in html. Thanks >>> OUTPUT: >>> >>> <html> >>> <head> >>> <title>Populating two fields in combo box from a query</title> >>> </head> >>> >>> <body> >>> <h2> >>> Populating two fields in combo box from a query</h2> >>> >>> SELECT BoatName, BoatClass FROM Boats;<br>A Sweet Song<br>Laser<br> >>> <select name="lstBoats" size="1"> >>> <option value='A Sweet Song'>Laser</option><option >>> value='Blackbeard'>Laser</option><option value='No Excuse to >>> Lose'>Laser</option><option value='No Excuse Two >>> Lose'>Laser</option><option value='White >>> Lightning'>Soling</option><option >>> value='Teal'>Soling</option><option >>> value='TGV'>Soling</option><option >>> value='BB3'>Soling</option><option value='Nuts and >>> Bolts'>Soling</option><option value='Psycho'>Soling</option><option >>> value='Shasta'>Flying Scot</option><option value='Daphne'>Flying >>> Scot</option><option value='Red White and Blue'>Flying >>> Scot</option> </select> >>> >>> </body> >>> </html> >>> >> >> -- >> 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. -- 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.
On Aug 22, 9:28 pm, "Bob Barrows [MVP]" <reb01...@NOyahoo.SPAMcom>
[quoted text, click to view] wrote: > Look at one of the option tags: > <option value='A Sweet Song'>Laser</option> > It sounds as if you are expecting the content of the value attribute ("A > Sweet Song") to be displayed as well as the option tag's text ("Laser" - > the portion between the opening and closing tags). Sorry, it just does > not work that way. The dropdown will display whatever is in the text, > and only what is in the text. So you need to modify your code to make > the resulting html look the way you want it to look, probably via > concatenation. Something like: Do while not oRS.EOF response.Write "<option value='" & oRS("BoatName") & "'>" response.Write oRS("BoatClass") & " - " & oRS("BoatName") & "</ option>" oRS.MoveNext Loop
Andyza wrote on 17 sep 2007 in microsoft.public.inetserver.asp.db:
[quoted text, click to view] > Do while not oRS.EOF > response.Write "<option value='" & oRS("BoatName") & "'>" > response.Write oRS("BoatClass") & " - " & oRS("BoatName") & "</ > option>" > oRS.MoveNext > Loop I would write that like this: <% Do while not oRS.EOF %> <option value='<% = oRS("BoatName") %>'> <% = oRS("BoatClass") %>-<% = oRS("BoatName") %> </option> <% oRS.MoveNext Loop %> Much less error prone for me at least. [oRS("BoatName") shoud not contain an apostrophe, btw] -- Evertjan. The Netherlands.
Gazing into my crystal ball I observed "Evertjan."
<exjxw.hannivoort@interxnl.net> writing in news:Xns99AEAE807E270eejj99@ 194.109.133.242: [quoted text, click to view] > Andyza wrote on 17 sep 2007 in microsoft.public.inetserver.asp.db: > >> Do while not oRS.EOF >> response.Write "<option value='" & oRS("BoatName") & "'>" >> response.Write oRS("BoatClass") & " - " & oRS("BoatName") & "</ >> option>" >> oRS.MoveNext >> Loop > > I would write that like this: > ><% > Do while not oRS.EOF > %> > ><option value='<% = oRS("BoatName") %>'> ><% = oRS("BoatClass") %>-<% = oRS("BoatName") %> ></option> > ><% > oRS.MoveNext > Loop > %> > > Much less error prone for me at least. > > [oRS("BoatName") shoud not contain an apostrophe, btw] > Even better for the user: <select name="field"> <option value="">Select</option> <% while not ors.EOF %> <option value="<% = oRS("BoatName") %>" <%if trim(field) = trim(oRS ("BoatName")) then%>selected="selected"<%end if%>><% = oRS("BoatClass") %>-<% = oRS("BoatName") %></option> <% ors.movenext wend ors.close set obs = nothing %> </select> -- Adrienne Boswell at Home Arbpen Web Site Design Services http://www.cavalcade-of-coding.info Please respond to the group so others can share
Adrienne Boswell wrote on 18 sep 2007 in
microsoft.public.inetserver.asp.db: [quoted text, click to view] > <% ors.movenext > wend > ors.close > set obs = nothing > %> > ors = Oral Rehydration Salts obs? [oops?] It is nothing. ;-) More seriously: I presume that, if the end of the serverside page code execution is near, the ASP engine will take care of such closing and nothinging without any performance damage. -- Evertjan. The Netherlands.
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 |