From: Michael Peppler [EMAIL PROTECTED]
Date: 2005/03/31 Thu PM 11:29:58 CST
Placeholders in Sybase are well supported, with the notable exceptions
that you can't use them for TEXT or IMAGE (i.e. BLOB)
columns/parameters.
Yep, I use placeholders to insert the row, minus the TEXT column,
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
Ron Stephan [mailto:[EMAIL PROTECTED] wrote:
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
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
Just in case it's not clear to you, the placeholders are the question
marks in the VALUES part of the sql ;-)
Ronald J Kimball [EMAIL PROTECTED] 3/31/2005 2:36 PM
Ron Stephan [mailto:[EMAIL PROTECTED] wrote:
Placeholders?
Like how?
Here's a quick example:
my $sth =
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
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
Merrill [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 31, 2005 2:56 PM
To: [EMAIL PROTECTED]; 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
From: Anderson, James H \(Company IT\) [EMAIL PROTECTED]
Date: 2005/03/31 Thu PM 01:59:26 CST
Consequently, AFAIK, almost no one in the sybase world use them.
How sad... I already figured out that I'm a nobody, but now I'm no one at all...
*sigh*...
amonotod
--
`\|||/
On Thu, 2005-03-31 at 21:59, Anderson, James H (Company IT) wrote:
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
10 matches
Mail list logo