HTML formatting for insert query.

[Warren]

Lets try this again...

Why does this query work when executed from the MySql Control Center, but
when executed from ASP it adds white spaces to the html tags?

Here's the query:

INSERT INTO myDbase.myTable (ArticleDate, ArticleNews)
VALUES('2003-11-26','<FONT face=\"Arial, Helvetica, sans-serif\"
color=#003300 size=4><STRONG>Some text</STRONG></FONT>')

Here's the result in the table if executed from the control center:
<FONT face="Arial, Helvetica, sans-serif" color=#003300 size=4><STRONG>Some
text</STRONG></FONT>

Here's the result of the same query when executed from ASP:
< FONT face = "Arial, Helvetica, sans-serif" color = #003300 size = 4 > <
STRONG > Some text < /STRONG > < /FONT >

Notice the spaces before and after all of the '< >' braces...

I thought the '< >' were not considered 'escape' characters?

Any info/guidance woiuld be greatly appreciated.

Warren M

[Aggro]

Warren wrote:

Here's the query:

INSERT INTO myDbase.myTable (ArticleDate, ArticleNews)
VALUES('2003-11-26','<FONT face=\"Arial, Helvetica, sans-serif\"
color=#003300 size=4><STRONG>Some text</STRONG></FONT>') Here's the result of the same query when executed from ASP:
< FONT face = "Arial, Helvetica, sans-serif" color = #003300 size = 4 > <
STRONG > Some text < /STRONG > < /FONT >

Notice the spaces before and after all of the '< >' braces...

I tried that with php and didn't have the same problem. I must assume
that you have a problem with asp, not with MySQL. And since I don't
really know asp, I can't help you about it. If you know some newsgroups
about asp they might know better.

[Aggro]

Warren wrote:

Here's the query:

INSERT INTO myDbase.myTable (ArticleDate, ArticleNews)
VALUES('2003-11-26','<FONT face=\"Arial, Helvetica, sans-serif\"
color=#003300 size=4><STRONG>Some text</STRONG></FONT>') Here's the result of the same query when executed from ASP:
< FONT face = "Arial, Helvetica, sans-serif" color = #003300 size = 4 > <
STRONG > Some text < /STRONG > < /FONT >

Notice the spaces before and after all of the '< >' braces...

I tried that with php and didn't have the same problem. I must assume
that you have a problem with asp, not with MySQL. And since I don't
really know asp, I can't help you about it. If you know some newsgroups
about asp they might know better.