Matthew,
I really don't understand the question. Apostrophes must be properly
escaped when text is inserted into the MySQL db, but any perl script will
easily do this for you. You may convert to HTML at the same time.
If the database gives nothing but a path to a *.txt source then your HTML
code should invoke a cgi script which in turn pulls a pathname from the
database, gets the data from the file, converts it to HTML and returns it
to the httpd.
Sorry, but I can't be more specific
Thomas Spahni
On Mon, 1 Dec 2003, Matthew Stuart wrote:
> I am going to take over an existing website and in its present format
> it is a site powered by an Oracle DB. I will be migrating to MySQL.
>
> The site is a news based site and has the use of the single quote or
> apostrophe (') through most of it's articles. I think that each article
> at present is an external .txt file that is pulled in to Oracle. If I
> carried on this method of having an external .txt file would that over
> come the necessity to escape (\') every single quote in each article?
>
> If so, how might I be able to pull that data through so that it loads
> into the web browser. I asume it is some sort of http:// based link as
> it would be for an image. Is there any special kind of formatting I
> have to do to the text file for it to show as html?
>
> TIA
> Mat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
