SELECT TOP 2 ID,Left(subject,20) AS subjects,end_date
FROM advert_details
ORDER BY end_date DESC
----- Original Message -----
From: ""Hayes, David"" <[EMAIL PROTECTED]>
Newsgroups: dotcom.lists.cftalk
Sent: Tuesday, April 10, 2001 9:25 PM
Subject: RE: TOP function not performing
> Show us some code.
>
> -----Original Message-----
> From: W Luke [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 10, 2001 3:07 PM
> To: CF-Talk
> Subject: TOP function not performing
>
>
> Why doesn't the TOP function ever work in Access? Sometimes it works,
> sometimes it doesn't - most of the time it seems it pulls a random record.
>
> Is there a way round this?
>
> Thanks
>
> Will
>
> --
> [EMAIL PROTECTED] -=- www.lukrative.com
> Local-Advertising -=- www.localbounty.com
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
