Content Management

[John Smith]

Hi,

Is there an article out there on dealing with content management systems and
how to replace characters (i.e. an apostrophe in a content management system
can't be put directly into a DB column, likewise paragraphs have to have the
html code in them to work)

Thanks

john

 

[Randy R]

how to replace characters (i.e. an apostrophe in a content management
system

can't be put directly into a DB column, likewise paragraphs have to have

the

You need to double up apostrophe's before putting them into a db...

variablename = replace(variablename,"'","''")