in reply to perl and sql

I don't think that what you have tried has any hope of working. system will run the command that you give it though the shell, not through the MySQL command line, so using system would be the same as running select ARKET_CODE from envent where CODE='${vCode}'; directly at the shell prompt (not the MySQL command line), so it will do nothing unless you happen to have a command/program called 'select', in which case it might do something, but not what you meant.

What version of Perl are you using? Is it really too old to use the DBI modules or are they just not installed?

Replies are listed 'Best First'.
Re: Re: perl and sql
by suekawar (Novice) on Feb 28, 2003 at 14:46 UTC
    I am using 5.004
[reply]
[reply]
        Hmmm ... I don't think it will work. From my version of DBI (1.32) 

         
$Id: DBI.pm,v 11.23 2002/12/01 22:34:29 timbo Exp $
#
# Copyright (c) 1994-2002  Tim Bunce  Ireland
#
# See COPYRIGHT section in pod text below for usage and distribution r
+ights.
#

require 5.005_03;

        [download]

        -derby

[reply]
[d/l]
        thanks I will try ,, there are lots of modules that deals with DBI which one do u advice me to do.
[reply]

In Section Seekers of Perl Wisdom