List:General Discussion« Previous MessageNext Message »
From:Faisal Nasim Date:March 20 1999 4:56am
Subject:Re: Perl/Mysql problems
View as plain text  
How about:

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

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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 = '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.
>
>============================================================================
>Robert H. Clugston
>E-mail:robert@stripped
>Systems Administrator
>Comstock Net, www.comstocknet.com
>Phone: (909)877-6407
>============================================================================
>
>
>---------------------------------------------------------------------
>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
>
>

Thread
Perl/Mysql problemsRobert H. Clugston20 Mar
  • Re: Perl/Mysql problemsDaniel Koch20 Mar
Re: Perl/Mysql problemsFaisal Nasim20 Mar