🚀 go-pugleaf

On Fri, 25 Oct 1996 09:08:54 -0400, Glenn Stanton <gms@lucent.com>
wrote:
>Yossi Konijn wrote:
>>> Oh, and while on the subject, does anyone know what
>>> escape sequence I should use to send a single-quote
>>> to a text field? I'm trying to type 'Can't' but the
>>> quotes are confusing Access.
>it seems to be a real problem for the ODBC "JetEngine".
>$somevar =~  s/\'/\&\#146\;/g;
>obviously this isn't the solution for non-WWW results.

I may have mentioned this in a prior post.  From what I've seen of SQL
it allows you to quote out the characters the same way C, shells, and
perl do.  Backslash 'em.

I use:
$somevar =~  s/\'/\\\'/g;
or
$somevar =~  s/\'/\\\\\\\'/g;
depending on how many times it is interpeted.

(actually $somevar =~  s#\'#\\\'#g; will prevent blindness :> )
HTH
Mark <insert sig <insert 'don't sue my boss' disclaimer here> here>