From: Faisal Nasim
Date: March 20 1999 4:56am
Subject: Re: Perl/Mysql problems
List-Archive: http://lists.mysql.com/mysql/679
Message-Id: <005901be728f$c04cc8e0$600e3ad1@whizpc>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

How about:

$query =3D qq!insert into xx values("I am cool","you are cool","mysql is =
cool","$variable")!;

=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D
Faisal Nasim (the Whiz Kid)
Web: http://wss.hypermart.net/
AOL: Whiz Swift
ICQ: 4265451
FAX: (815) 846-2877
-----Original Message-----
From: Robert H. Clugston <robert@stripped>
To: Mysql Mailing List <mysql@stripped>
Date: Saturday, March 20, 1999 4:29 PM
Subject: Perl/Mysql problems


>Dear List,
> I'm using Perl to write the my database. To avoid problems when =
inserting
>rows into my table I use the perl \Q\E method to escape all characters.
>Below is my query:
>
>$query =3D 'INSERT into messages VALUES("' . "\Q$name\E" . '", "' .
>"\Q$email\E" . '", "' . "\Q$d
>ate\E" . '", "' . "\Q$subject\E" . '", "' . "\Q$message\E" . '", "' .
>"\Q$id\E" . '")';
>
> Ever since updating to Debian 2.1 when ever I insert a "?" a null =
character
>is inserted in its place. In Debian 2.1 I believe the Mysql server =
version
>is 3.21.33b.
>
>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D
>Robert H. Clugston
>E-mail:robert@stripped
>Systems Administrator
>Comstock Net, www.comstocknet.com
>Phone: (909)877-6407
>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D
>
>
>---------------------------------------------------------------------
>To request this thread, e-mail mysql-thread652@stripped
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail mysql-unsubscribe@stripped instead.
>For archive commands, etc, e-mail: mysql-help@stripped
>
>