> Your ORDER BY field(s) should determine which records are returned; it
your
> example, you should be getting the 2 records with the highest end_date
> value.
>
> If you order by ID, you'll get 2 records with the lowest (sorted
ascending)
> or highest (sorted descending) ID.
So my code is correct then?
I did see this mentioned a few weeks ago, but couldn't find it in the
archives.
> Is end_date in fact a date field? Or is it perhaps text?
Yes, it's a proper date field.
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
