> -----Original Message-----
> From: learn perl [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 20, 2002 3:16 PM
> To: Bob Showalter
> Cc: [EMAIL PROTECTED]
> Subject: RE: SQL question
>
>
> 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?
Define "sorted order". Sorted by column name? Sorted by value? I'm getting
confused.
If you're using DBI, you can use "SELECT * FROM table" and then call
fetchrow_hashref() (or use $sth->{NAME}) and use the column names returned
to order your columns in whatever way you want.
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
