Really!  Why not?  I don't have any experience with Sybase but I haven't
that comment about any other databases that *shouldn't* use
placeholders.

>>> "Anderson, James H (Company IT)" <[EMAIL PROTECTED]>
3/31/2005 2:52 PM >>>
Probably not the optimum solution if you're using Sybase... 

-----Original Message-----
From: Hardy Merrill [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 31, 2005 2:11 PM
To: [EMAIL PROTECTED]; dbi-users@perl.org 
Subject: Re: string help!

Use "placeholders" - all your quoting issues will go away.

Read about them by doing

   perldoc DBI

at a command prompt and searching for "Placeholders".

HTH.

Hardy Merrill

>>> "Ron Stephan" <[EMAIL PROTECTED]> 3/31/2005 1:52 PM >>>
Help --

I am lost trying figure out what occurs to me a really simple problem.


CGI->Perl->MySQL.


Users pounding data into a CGI-Perl web page feeding MySQL.

If the user enters a special character it crashes.

As in "Bob's Market"...  Yeah - trap for special chars and escape
them.

This seems so simple - yet the solutions that come to mind make me
feel
like I am reinventing the wheel.

There must be some really simple solution everybody is using.



Ron "Elvis" Stephan
[EMAIL PROTECTED] 
--------------------------------------------------------
 
NOTICE: If received in error, please destroy and notify sender.  Sender
does not waive confidentiality or privilege, and use is prohibited. 
 

Reply via email to