Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: returning first row of SQL query

by wallisds (Beadle)
on Mar 29, 2012 at 19:22 UTC ( #962467=note: print w/replies, xml ) Need Help??


in reply to returning first row of SQL query

my $query="SELECT severity, source, displayname 
FROM alert 
WHERE displayname LIKE '%$displayname%' 
ORDER BY severity DESC
LIMIT 1";

my ($severity, $source, $displayname) = $dbh->selectrow_array($query);

[download]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://962467]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (3)
As of 2023-02-04 03:21 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I prefer not to run the latest version of Perl because:







    Results (30 votes). Check out past polls.
    Notices?