No, you didn't miss it! :)
Here is the original - "SELECT * FROM events ORDER BY StartDate"
Without anything, I will get 10 events listed on the page. If I try "SELECT
TOP 5 * FROM events ORDER BY StartDate", then I only get the first 2 events.
If I put it at the end like this "SELECT * FROM events ORDER BY StartDate
TOP 5", then I get an error message:
Syntax error (missing operator) in query expression 'StartDate TOP
5'.
Todd
-----Original Message-----
From: r937 [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2008 4:09 PM
To: [email protected]
Subject: Re: [wdvltalk] Limited Records - ASP
> Yeah, I do have an ORDER BY. Maybe I don't have it in the right place?
if it isn't at the end, you'd get a syntax error
could you perhaps show us the entire query? or did i miss it already?
rudy
____ . 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: [email protected]
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: [email protected]
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.
