From: | Peter Landis <ntwebdeveloper(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)hub(dot)org |
Subject: | postgresql and perl? |
Date: | 2000-05-25 21:16:36 |
Message-ID: | 20000525211636.7075.qmail@web3201.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 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 ?;});
$sqh->execute($sort_selection);
OR
$sqh = $dbh->prepare(q{select name from company order
by $sort_selection;});
$sqh->execute();
If anyone could help, I would greatly appreciate it.
Thanks again!
__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Herbert Liechti | 2000-05-25 21:47:14 | Re: postgresql and perl? |
Previous Message | Joseph Shraibman | 2000-05-25 21:05:48 | Re: problem with NOTICE: _outNode: don't know how to print type |