Is it possible you are pointing to a SQL view - and the error is in the SQL
view - I too cannot see anything obviously wrong with the SQL
(with regards to the CF - parameterexists() function has been deprecated and
has been replaced by isdefined() )
Cheers
Dan
-----Original Message-----
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: 04 September 2001 15:48
To: CF-Talk
Subject: RE: help with moving from access to sql server
Why do you need the GROUP BY clause at all?
I don't see any aggregate functions (COUNT, SUM etc)
Also, which column is a bit column and does it really need to be?
Nick
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
