[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.