Writing and Retrieving Carriage Return Line Feeds - vbCRLF

[sylvanst]

I'm having trouble inserting a vbCRLF within variable text into a SQL server database field. I'm trying to do something like:

sText = sLogon & chr(13) & chr(10)
objForm.ADORecordset("fieldname&quot = sText

Or

sText = sLogon & vbCRLF
objForm.ADORecordset("fieldname&quot = sText

and then trying to later retrieve that database field text with stored Carriage Return Line Feeds and have it break properly in a Response.Write statement like:

response.write objForm.ADORecordSet("fieldname&quot

This method does not seem to work. The output just wraps with no breaks. Do I need to do a parse routine or something to get my desired results? I don't think the CRLF's are being saved to the database field.

 

[mrmovie]

how do you know your database field can store breaks and lines feeds etc???

cant you just do

response.write objForm.ADORecordSet("fieldname&quot & chr(13) & chr(10)

that way you dont have to store all those chr(13) and chr(10) in each field of your database? thats if you can of course
rgd
mrmovie