What I'm saying is, you don't need a GROUP BY *at all* in this query.
Anyway, it worked, that's the main thing :-)
Nick
-----Original Message-----
From: Declan Maher [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 4:18 PM
To: CF-Talk
Subject: RE: help with moving from access to sql server
Thanks Nick,
That worked fine when I changed the datatype to tinyint.
Heres the error message it throws when I tried to use the query without
the proper grouping.
----
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Column
'Programme_Details.Locked' is invalid in the select list because it is
not contained in either an aggregate function or the GROUP BY clause.---
>From somewhere I found the following statement and I think it was
causing the problem:
-----The GROUP BY
requires that each field in the SELECT statement appear in the GROUP BY
statement except for your aggregate functions.-----
I only used the Group By for some of the fields and not all in the
select statement
Regards,
Declan Maher
Web Applications Developer
Head Office
133-137 Lisburn Road
Belfast
Northern Ireland
BT9 7AG
T: +44 (0) 28 9022 3224
F: +44 (0) 28 9022 3223
E: [EMAIL PROTECTED]
W: biznet-solutions.com
**********************************************************************
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.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
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
