Code: Select all
INSERT INTO myTable VALUES ('AT','00132183','','[Info]
NumAttachments=1
[Attachments]
Attachment1=test|\\clint\documents\heat attachments\September 05\00132183\call_raise.asp',DATEDIFF(ss,'01-01-1970',GETDATE()))I have tried to use the CHR(10) and CHR(13) charcters at both PHP and SQL levels.
The php is ignored by the time it gets to SQL. The SQL one inserts a non-printable character in the text field.
I need the SQL TEXT field3 to finish with the formatted text
Code: Select all
[Info]
NumAttachments=1
[Attachments]
Attachment1=test|\\clint\documents\heat attachments\September 05\00132183\call_raise.asp'PLEASE HELP!!