on Tue, 20 Aug 2002 19:16:16 GMT, Learn Perl wrote:
> Yes I want to have the columns come out in a sorted order without
> specifying them like "select col1, col2, col3 from database" because
> I have too many columns (close to 80). Is there ways to select a
> table w/o specifically telling the SQL server which ones I want?
Do you think an SQL-server has psychic capabilities?
Seriously, you should always specify all the columns you want. If you
don't want to type them in, you can always create your sql-string from
code, like e.g.
my $query = "SELECT " .
(join ",", map { sprintf("col%02d", $_) } (0..80)) .
" FROM atable";
--
felix
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
