Top 10 IS a SQL Command. I copied this statemtent directly from my SQL 7
Enterprise manager if you still don't believe:
SELECT TOP 10 *
FROM [dbo].[objects]
It returns the top 10 rows, all columns.
-----Original Message-----
From: Jim Watkins [mailto:[EMAIL PROTECTED]]
Subject: top 10 is not a field
I noticed when I posted my question on "selecting the top ten of a list of
counties" that 2 or 3 responded with something like: "Select top 10 * (or
your fields)" now how would CF and Oracle respond to such a statement as
'top ten' as it is not a SQL command (as far as I know) or even a field in
my query?
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]