[imp] problems with single quotes
Chuck Hagenbuch
chuck@horde.org
Mon, 16 Oct 2000 12:08:00 -0400 (EDT)
Quoting mkb <mkb@ele.uri.edu>:
> Warning: OCIParse: ORA-01756: quoted string not properly terminated
> in ./lib/db.oci8 on line 280
>
> My guess is that has different escape sequences for quotes and such.
>
> I've checked the SQL statements that are sent to the database, and
> it's definitely that the quotes are prematurely ending the SQL
> statement ie:
>
> INSERT into imp_pref(username,sig) values('mkb@bar','Matt Kane's Brain');
What db lib are you using? Sounds like it's not calling addslashes
appropriately...
-chuck
--
Charles Hagenbuch, <chuck@horde.org>
Many states consider gambling so immoral that they not only prohibit private
gambling organizations, they thoughtfully provide their own.