Hmm, it's throwing an error on me about a missing operator. I've got my
statement as
SQL = "SELECT * FROM table ORDER BY StartDate LIMIT 5"
Does that look right?
I also tried using "Top", and that doesn't produce the right results
("select top 5 * from table...")
Todd
-----Original Message-----
From: David Precious [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2008 11:04 AM
To: wdvltalk@lists.wdvl.com
Subject: Re: [wdvltalk] Limited Records - ASP
On 06/06/2008 04:54 PM, Todd Richards wrote:
> Yes, it's coming from a MS SQL Server 2000 DB, and I'm using ASP to pull
the
> data. Does that offer the "limit", or is that just a MySQL feature?
Anything that does SQL should be able to handle the LIMIT clause - even
MS SQL Server. Just stick it on the end of your query and job done :)
____ . The WDVL Discussion List from WDVL.COM . ____
To Join wdvltalk, Send An Email To:
mailto:[EMAIL PROTECTED] or
use the web interface
http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: wdvltalk@lists.wdvl.com
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
____ The WDVL Discussion List from WDVL.COM ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: wdvltalk@lists.wdvl.com
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
