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.