On Thursday, September 4, 2003 at 11:55, Ross Clutterbuck wrote:
<snip>
RC> I'm not overly familiar with SQL but I've been told
RC> about LIMIT but that's causing an SQL syntax error in
RC> my ASP debugger - I'm not sure where it should go in
RC> the query string but following examples it still
RC> doesn't work.
i think LIMIT is mysql, not access...could be wrong. anyway, what you
want is...
SELECT TOP 5
id, title
FROM
tblDocuments
WHERE
Cat = 2
ORDER BY
DateCreated DESC
hth,
darren.
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set
WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
