Philip,
MS Index Server is not a full blown SQL compliant product - it has a subset
of the SQL langauge available to it - you can't use 'group by' for instance.
It can't use 'TOP' either. I tried 'SELECT TOP 4 * ' but IS came back with
Column 'TOP' has not been defined. SQLSTATE=42S22
So, any more from any more?
Thanks,
Keith
-----Original Message-----
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: 26 January 2001 16:28
To: CF-Talk
Subject: RE: Index Server and setting maxRecords
> I recognise the problems of GETTING ALL the records and then USING SOME of
> them and had already tried the 'TOP n FROM' in the SQL statement but Index
> Server barfed it back - invalid syntax as it is expecting to find a column
> named 'TOP'
When you're using TOP, are you specifiying the column fields, or just using
"SELECT TOP 10 FROM" - this will confused SQL into thinking that the field
"TOP" must be returned
Can you try something like
SELECT TOP 10 *
FROM myTable
This should return just the top 10 rows in most flavors of SQL, but some
don't handle it
I use "TOP 1" an awful lot instead of "COUNT(*)" as this will return if
there are any rows in the table and is logarithmically faster than count on
large numbers of rows...
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
