SELECT column from table where City = $cty
will never work unless city is a numeric column. If you try to run
SELECT column from table where City = Denver
from within a sql tool mysql will return an error something like unknown
column name and that is effectively the sql statement you are
Jeff is right both about not using tainted user data, and
about using placeholders. But I don't think tainted data
is causing the problem you're having - see below:
John S Brigham [EMAIL PROTECTED] wrote:
>
> I need help.
>
> I am working on a MySQL /Perl web site. I am teaching myself MySQL a
John S Brigham wrote:
$cty = ;
chomp $cty;
#then
...SELECT column from table where City = $cty #doesn't work.
And that's a good thing. $cty is tainted, that means that it comes from
a source that perl can't check and could therefore include all sorts of
harmful things. Read about t
I need help.
I am working on a MySQL /Perl web site. I am teaching myself MySQL and
PERL and am making progress.
As an exercise, I want to put my Mother's Christmas card list in a MySQL
database. I want to sort and print the mailing labels from the database.
This is all done in PERL.
The ma
Looks like the problem is related to the old thread support in perl
(known as 5.005threads, which was fataly flawed and now replaced by iThreads).
I think DBI 1.32 was the last version tested to work with 5.005threads.
Assuming this is the problem... if you don't need threads then
rebuild your pe
On Sat, Nov 01, 2003 at 11:50:40AM -0700, Charlie Smith wrote:
> We're trying to get Oracle::DBD installed on a web server, where Oracle
> is installed on another server. I read Wintermute's comment in the
> README.clients file, but hope there are some standardized instructions on
> this by now.
Search the archives - there's been discussion over the last
week or two about installing Oracle client so that
DBD::Oracle can be installed - I think this is what you
need for your webserver. IIRC the person was successful
installing the Oracle client with Pro C and the "Programmer"
install, and t
Looks like the problem is related to the old thread support in perl
(known as 5.005threads, which was fataly flawed and now replaced by iThreads).
I think DBI 1.32 was the last version tested to work with 5.005threads.
Assuming this is the problem... if you don't need threads then
rebuild your pe
file: $CPAN/authors/id/S/SG/SGOELDNER/DBD-ADO-2.77.tar.gz
size: 45221 bytes
md5: d821fa652f996f0b024272de82e1c2dc
Changes:
Added DBD::ADO::Const.
Moved metadata tests into t/4?dd*.t.
Fixed significant bug (missing first row after reexecute) and
added t/12count.t to test row coun