This topic is locked

Add CHAR(13)

5/12/2008 12:35:10 PM
ASPRunnerPro General questions
T
Tim author

Hello,
I am trying the add a carriage return in a field during a record add. In the Events/Before record added I am attempting the following code:
dict("Address") = dict("Street") & CHAR(13) & dict("City") & ", " & dict("State") & " " & dict("Zip")
When I remove the Char(13) it works fine. With Char(13) I don't get any errors but the Address field is Null in my DB. Do I have a syntax error?
I am using MS SQL and ASPRunning 5.2.
Thanks,

Tim

Sergey Kornilov admin 5/12/2008

dict("Address") = dict("Street") & vbcrlf & dict("City") & ", " & dict("State") & " " & dict("Zip")

T
Tim author 5/12/2008

Thanks so much Sergey. I didn't realize I could use that.
Tim