Bill
> select sum(pic + sic + student) as grandtotal
> from aeps.dbo.flighttimes
> where membernumber=1000017
>
> When i run this query in CF in SQL i get the column GRANDTOTAL () with the
> correct Values of the where but i get every row in the database
> so is there an alternate method of doing SUM()? I'm using CF PRO 4.51 For
> Linux
This is bizarre. What DBMS?
**********************************************************************
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.
**********************************************************************
------------------------------------------------------------------------------
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.
