Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-17 : 21:47:51
|
Bob writes "I have been stumped by this one for some time and I was wondering if you could give me a little help.
I am currently working on a project to display records from a database based on search criteria, as well as allowing administrators to submit/edit/update/delete/search said records. There are textarea boxes that I am using to capture additional information about the firm ( clients, name of board members) , capturing these in the textarea one entry perline, after being saved, without formatting ,it would return on a single line all the values that were inserted into the field:
input1 input2 input3
But some formatting can be done using something like this :
Dim strTextAreaValue
strTextAreaValue = objRS("var_F1")
Response.Write Replace(strTextAreaValue, vbCrLf, "
")
to format the output into a neat column:
input1
input2
input3
Thats fine. But very limited in what can be done with the results.
Is there a way to have more control over the information in this field?
What I would like to accomplish is to set up a table with 2 columns, which will format information from the memo field like this :
input1 | input2 |
etc.....
Any help would be most appreciated."
|
|
|
|
|
|
|
Displaying Data from Memo fields