Hello,
When you sort on mathematical expressions like SUM() you need to use GROUP
BY. ORDER BY cannot contain mathematical expressions.
R.
Johan Coens
-----Original Message-----
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: maandag 31 juli 2000 11:27
To: '[EMAIL PROTECTED]'
Subject: RE: Desperately need help - sorting a QueryNew()
> See
> http://www.mail-archive.com/[email protected]/msg14920
> .html for
> sorting queries
Thanks - I'll take a look at the tag.
--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services
http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
