Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Querying Select Number of Rows

by one4k4 (Hermit)
on Jun 05, 2001 at 20:34 UTC ( #85871=note: print w/ replies, xml ) Need Help??


in reply to Querying Select Number of Rows

set rowcount 11 select first_name from database where start_date <= '2001/04/14' and stop_date > '2999/12/31'

Something similar to that concept in your sql may help.... rowcount works with Sybase. MySQL, I dont know.

Update:I took the talk about his posted code out, and realized it just didnt fit in this thread. Regardless, the rowcount idea, kind of follows the suggesstion(s) above.

_14k4 - webmaster@poorheart.com (www.poorheart.com)


Comment on Re: Querying Select Number of Rows
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://85871]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (12)
As of 2014-11-27 09:52 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My preferred Perl binaries come from:














    Results (183 votes), past polls