- Original Message -
From: Ed Loehr <[EMAIL PROTECTED]>
To: Peter Landis <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, May 26, 2000 5:35 PM
Subject: Re: [SQL] POSTGRESQL and PERL?
> Peter Landis wrote:
> >
> > but what if you have a varia
Peter Landis wrote:
>
> but what if you have a variable set like:
> $sort_selection = "name";
>
> How do you sort by the variable?
>
> For instance you cannot do...
> $sqh = $dbh->prepare(q{select name from company order
> by $sort_selection;});
Why not? The query string is created before pre
-
> From: Peter Landis [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 26, 2000 11:58 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: [SQL] POSTGRESQL and PERL?
>
>
>
> Hi-
>I'm a newbie at postgresql and was working on
> sorting by catego
Hi-
I'm a newbie at postgresql and was working on
sorting by category. What my question is, how do you
sort by category when using a variable. For instance,
you can sort by name in perl by doing:
$sqh = $dbh->prepare(q{select name from company order
by name;});
$sqh->execute();
but what i