Front page | perl.dbi.users |
Postings from March 2005
RE: string help!
Thread Previous
|
Thread Next
From:
Anderson, James H
Date:
March 31, 2005 11:59
Subject:
RE: string help!
Message ID:
0CEB03AC7B69534AB836D1BA2C72B56201219177@NYWEXMB36.msad.ms.com
I don't remember the details, but I think they're documented in
DBD::Sybase. It believe it has something to do with the way sybase
supports ("cobbles up" may be more appropriate) placeholders.
Consequently, AFAIK, almost no one in the sybase world use them.
-----Original Message-----
From: Hardy Merrill [mailto:HMerrill@dhcr.state.ny.us]
Sent: Thursday, March 31, 2005 2:56 PM
To: elvis@elvisware.com; Anderson, James H (Company IT);
dbi-users@perl.org
Subject: RE: string help!
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.
--------------------------------------------------------
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