>I have the ff: values in my sql table: > >Trancode Tran >001 Change Address >002 Change Number >003 Change Int'l Req'ts > >Then I have the ff: code: > >< % >qry = "select * from trantable >set rs = server.createobject("adodb.recordset") >rs.open qry, "dsn=tran_sql;uid=tran1" > >response.write "< select >" >while not rs.eof > response.write "< option value='" & rs("tran") & "'>" & rs("tran") & "< /option> > rs.MoveNext >wend > >response.write "< /select >" >% > > >The html select tag is displayed in my browser but the record with the quote is displayed as blank. I tried wrapping rs("tran") inside server.htmlencode but it still does not display right. Any suggestions? > >Ramon Carlos
Try this "
HTH Jeff
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin. www.TrueGeeks.com