Hey all...
Does anyone know how Microsoft Access 2000 handles escaping apostrophes in SQL
statements? I tried back-slashing (\') them out, but that didn't work (i.e, insert
into blah values(1, 'Bob', 'Bob\'s stuff')). And since that didn't work,
addslashes(), of course, didn't work either.
]]
Sent: Monday, September 17, 2001 8:32 AM
To: Ari M. Roth
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Quotes, double-quotes, and the like.
On Sun, 16 Sep 2001, Ari M. Roth wrote:
I'm trying to create a web-based interface that will allow me to save
essays to a mySQL database for display
I'm trying to create a web-based interface that will allow me to save
essays to a mySQL database for display on a website. The problem is
that it may include HTML in it, so I need to preserve double-quotes in
their original context. Right now, they are not encoding correctly for
some reason.
A couple of links to back that up:
http://www.snopes2.com/inboxer/hoaxes/predict.htm
http://fury.com/article/925.php
And the original essay that contains the quote:
http://www.ed.brocku.ca/~nmarshal/nostradamus.htm
Later...
-Ari
-Original