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
-----Original Message-----
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: 04 September 2001 16:03
To: CF-Talk
Subject: RE: help with moving from access to sql server
Declan
You could use int, or you could use a char.
But I still don't understand why you need the GROUP BY at all.
Nick
-----Original Message-----
From: Declan Maher [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 3:58 PM
To: CF-Talk
Subject: RE: help with moving from access to sql server
Nick,
Thanks for your reply.
I'm new to SQL Server and this may sound like a basic question but could
I ask you what other datatype I should use for a boolean value 1 or 0.
Is it just the int datatype?
I take it that this would be the simplest means of sorting out the
problems.
Cheers,
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
-----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.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
