Oops, sorry I got tied up here and forgot I was going to send you more
info. Basicly what you need to do is this:
my $query = "
select this, that
from table
where constant_where_clause_stuff = other constant_stuff
";
$option = @ARGV ? " and filename = $AR
On Thu, 5 Jul 2001, Kim Green wrote:
> I don't know how or where to put & how to use this $option.
> What if my Default value is a sql statement? Can I just include the name
> of the file handle between the brackets?
You can do something like
my $option = @ARGV ? shift : 'SELECT * FROM my_table
I don't know how or where to put & how to use this $option.
What if my Default value is a sql statement? Can I just include the name
of the file handle between the brackets?
-Original Message-
From: Brett W. McCoy [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 29, 2001 6:40 PM
To: M.W
On 29 Jun 2001 09:00:50 -0700, Randal L. Schwartz wrote:
> > "Chas" == Chas Owens <[EMAIL PROTECTED]> writes:
>
> Chas> my $query = "
> Chas> SELECT a.filename, a.size, a.date, b.owner, c.group
> Chas> FROM filesystem a, outer owner b, outer group c
> Chas>
On 29 Jun 2001 10:46:39 -0400, Kim Green wrote:
>
> Brett and Chas,
>
> I did create two file handles and alter my conditional statements, one to
> work when there is a variable, and one for when there's no variable. The
> first SQL statement should return everything for a given filename; the o
Brett and Chas,
I did create two file handles and alter my conditional statements, one to
work when there is a variable, and one for when there's no variable. The
first SQL statement should return everything for a given filename; the other
should return everything for all filenames that meet th
