2. ASPRunnerPro General questions
  3. Add CHAR(13)
This topic is locked

Add CHAR(13)

 		5/12/2008 12:35:10
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