On Tue, 22 Oct 2002 16:22:04 -0400 [EMAIL PROTECTED] wrote:
> insert into alerts (alrt, ncmp, suno, mess, prty, spst, dnst, crea, cdat)
> values ('$max_alert', '$company','$supplier', '$message',
> '$priority', '2',
> '2', '$userid', SYSDATE)
>
> This works fine unless there is a single quote in the message, which
> obviously is a big problem since I cannot restrict my users to not enter
> quotes into their text message. How can I avoid having this issue?
# add this near the top of your code
use HTML::Entities;
# add this just before your insert command
encode_entities($message)
Mike Schienle
Interactive Visuals, Inc.
http://www.ivsoftware.com
---------------------------------------------------------
This message sent using EMUmail -- http://www.emumail.com
---------------------------------------------------------
Jumping through hoops to get E-mail on the road?
You've got two choices: Join the circus, or use MollyMail.
Molly Mail -- http://www.mollymail.com
