[snip]
Are my prayers answered? I have been a bit concerned that I might not
be able to completely fulfill my clients needs because of them being
restricted to the use of single quotes.
[/snip]
Mat,
What is your programming language for the site? If it is PHP you have a
wealth of options for
Matthew Stuart said:
I am on my first MySQL DB and it is very text heavy because it is a
news site, therefore there is a great deal of use of the apostrophe
or as MySQL would see it the single quote. I was hoping to be able
to use double quotes to overcome the need to constantly have to
You could always write your own function to do the escaping for you. This following
link is an example written in VB that you could adapt to whatever language you are
using.
http://www.vbmysql.com/samplecode/stripquote.html
Here is another way of doing it if you can link to the libmySQL.dll
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
[snip]
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