develooper Front page | perl.dbi.users | Postings from March 2005

RE: string help!

Thread Previous | Thread Next
From:
Hardy Merrill
Date:
March 31, 2005 11:56
Subject:
RE: string help!
Message ID:
s24c0f9a.070@SMTP.dhcr.state.ny.us
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)" <Jim.Anderson@morganstanley.com>
3/31/2005 2:52 PM >>>
Probably not the optimum solution if you're using Sybase... 

-----Original Message-----
From: Hardy Merrill [mailto:HMerrill@dhcr.state.ny.us] 
Sent: Thursday, March 31, 2005 2:11 PM
To: elvis@elvisware.com; 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" <elvis@elvisware.com> 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
elvis@elvisware.com 
--------------------------------------------------------
 
NOTICE: If received in error, please destroy and notify sender.  Sender
does not waive confidentiality or privilege, and use is prohibited. 
 

Thread Previous | Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About