Re: Recordset used in Select/Option pick list
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Fri, 22 Sep 2006 13:39:32 -0400
WynnGIS wrote:
Bob,
Thank you so much for the response and for the helpful hints. I've
almost got it but I can't get the correct syntax in the GetString
loop. I see how each value get placed in the first statement
optHTML=rs.GetString(,,""">" & vbcrlf & "<option value=""")
by placing a response.write optHTML in the loop.
I don't see where the option tag gets closed and I don't
understanding the concatenation.
Sorry, I should have tested it. The option tags don't need to be closed.
I've tested this code with a table in my database and it works fine. I'm
putting in a Response.Write to help you understand what's going on. You
can comment it out when you get the idea.
Change the code to:
If not rs.EOF then
optHTML=rs.getstring(,,,vbcrlf & "")
response.write "Result of GetString:<br>"
response.write "<pre>" & optHTML & "</pre>"
optHTML="<option>" & left(s,len(s) - len(vbcrlf & "<option>"))
End If
--
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.
.
- Follow-Ups:
- Re: Recordset used in Select/Option pick list
- From: WynnGIS
- Re: Recordset used in Select/Option pick list
- References:
- Recordset used in Select/Option pick list
- From: WynnGIS
- Re: Recordset used in Select/Option pick list
- From: Bob Barrows [MVP]
- Re: Recordset used in Select/Option pick list
- From: WynnGIS
- Recordset used in Select/Option pick list
- Prev by Date: Re: Recordset used in Select/Option pick list
- Next by Date: Re: Recordset used in Select/Option pick list
- Previous by thread: Re: Recordset used in Select/Option pick list
- Next by thread: Re: Recordset used in Select/Option pick list
- Index(es):
Relevant Pages
|
|
