By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,742 Members | 1,033 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,742 IT Pros & Developers. It's quick & easy.

best way to format html

P: n/a
dan

Im sure this has been asked a million times, but Im I couldn't find it.
So, why not make it 1 million +1.

I am looking for the best way to format html, to be put into a INSERT
statement. The main problem being the double quotes. Unfortunately not
using double quotes is not an option.

should I ,
a. Use regular expressions to change all " to something odd like ~!~. and
then when I select it again, use another regex to change ~!~ back to ".
Very ugly method.

b. Use some sort of base64 encoding. not sure how much that slows stuff
down.

c. use a regex to change the "'s to a \".. Would prefer not to do this
either.

or d. Some other method.
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Wed, 02 Jun 2004 05:36:39 -0400, in mailing.database.mysql dan
<dc****@bestweb.net> wrote:
|
| Im sure this has been asked a million times, but Im I couldn't find it.
| So, why not make it 1 million +1.
|
| I am looking for the best way to format html, to be put into a INSERT
| statement. The main problem being the double quotes. Unfortunately not
| using double quotes is not an option.
|
| should I ,
| a. Use regular expressions to change all " to something odd like ~!~. and
| then when I select it again, use another regex to change ~!~ back to ".
| Very ugly method.
|
| b. Use some sort of base64 encoding. not sure how much that slows stuff
| down.
|
| c. use a regex to change the "'s to a \".. Would prefer not to do this
| either.
|
| or d. Some other method.


You could use single quotes. Use regex to convert all " to ' or better
yet to &quot;

---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.