Business Systems Analyst - Clearing - SQL Server - ASP - VB (IL) Next Step Systems US-IL-Chicago Post A Job | Post A Resume

From Jason H.:

In the article on GetString, it is shown that you should use GetString to create one giant string for tables, combos, etc from a recordset column. This is not necessary, as you can make your GetString parameters like this:

theCombo = "<option>" & prsRecordset.GetString(,,,"</option>" & vbCrLf & vbTab & "<option>","&nbsp;" )

vbCrLf inserts a linefeed, and vbTab indents. This makes for pretty code, too (thus eliminating your statement that it may be ugly, but it works!)

Windows Internet Technology | ASP.NET [1.x] [2.0] | ASPMessageboard.com | ASPFAQs.com | Advertise | Feedback | Author an Article