INSERTing Line Breaks into MySQL DB using ASP

[Astra]

Hi All

Could you please let me know how my ASP page can insert 1 row of data
containing line breaks into a MySQL DB.

To explain, I'm using ASP Classic > MyODBC 3.5x (Win) > MySQL 4 (Win) and my
insert command is:
INSERT INTO `WEBCONTENT` (CONTENTTEXT) VALUES ('Order Number: [ORDERNUM]

Account Number: [ACCOUNTCODE

Invoice Address:

[INVADDRESS]

Tax Code: [TAXCODE]

Delivery Address:

[DELADDRESS]

Goods Ordered:

[GOODS]

');

When I retrieve this row data all of the line breaks have disappeared.
NOTE: I do have a replace function that replaces any vbCrLf's with <BR> to
make it appear correctly on my ASP page, but I still get no line breaks.

I've queried the data using SQLyog and all my linebreaks are showing as
square boxes.

When I had my row data in an Access DB the above worked fine.

Do I have to format the data in someway before inserting it into the db?

Thanks

Robbie

[Astra]

Hi Guys

You're probably not that interested anyway [ ;0) ] , but I did manage to
find out how to get round this.

I was doing a replace() for vbCrLf, but MySQL must only use vbLf because as
soon as I changed my replace function to this everything was OK.

Rgds

Robbie



"Astra" <info@NoEmail.com> wrote in message news:40c98197$1_4@127.0.0.1...
Hi All

Could you please let me know how my ASP page can insert 1 row of data
containing line breaks into a MySQL DB.

To explain, I'm using ASP Classic > MyODBC 3.5x (Win) > MySQL 4 (Win) and my
insert command is:
INSERT INTO `WEBCONTENT` (CONTENTTEXT) VALUES ('Order Number: [ORDERNUM]

Account Number: [ACCOUNTCODE

Invoice Address:

[INVADDRESS]

Tax Code: [TAXCODE]

Delivery Address:

[DELADDRESS]

Goods Ordered:

[GOODS]

');

When I retrieve this row data all of the line breaks have disappeared.
NOTE: I do have a replace function that replaces any vbCrLf's with <BR> to
make it appear correctly on my ASP page, but I still get no line breaks.

I've queried the data using SQLyog and all my linebreaks are showing as
square boxes.

When I had my row data in an Access DB the above worked fine.

Do I have to format the data in someway before inserting it into the db?

Thanks

Robbie