try this to see if it consolidates your result to grant total.
Your original query sums up 1 pic,sic, student for that membername and
returns those rows.
select sum(sum(pic) + sum(sic) + sum(student)) as grandtotal
from aeps.dbo.flighttimes
where membernumber=1000017
venu
-----Original Message-----
From: William J Wheatley [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 11, 2000 10:50 AM
To: [EMAIL PROTECTED]
Subject: Re: URGENT: SUM() QUESTION
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
Bill Wheatley
Senior Developer
AEPS INC
http://www.aeps.com
ICQ: 417645
http://www.aeps2000.com
954-472-6684 X303
----- Original Message -----
From: "DeVoil, Nick" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 11, 2000 11:34 AM
Subject: RE: URGENT: SUM() QUESTION
> I don't see how this SQL could return 4 rows, let alone a whole
> table. It should return _one number_. You're asking the DBMS
> to find all rows where the description is one of three possible
> values, then for each row add together the numbers in three of
> the columns, then to add together all these numbers and pass
> back the result as "grandtotal".
>
> Is that what you want?
>
> Nick
>
> -----Original Message-----
> From: William J Wheatley [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 11, 2000 4:30 PM
> To: [EMAIL PROTECTED]
> Subject: Re: URGENT: SUM() QUESTION
>
>
> well I have tested by even removing it to make it membernumber=1000017 And
> hard code it because i was worried about the OR as well.
> But with the ( ) its fine but even with just membernumber=1000017 it
pulls
> back everyrecord
>
> So i guess this is a bug? is there another way to do the same thing?
>
>
> Bill Wheatley
> Senior Developer
> AEPS INC
> http://www.aeps.com
> ICQ: 417645
> http://www.aeps2000.com
> 954-472-6684 X303
> ----- Original Message -----
> From: "G" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, September 11, 2000 9:54 AM
> Subject: Re: URGENT: SUM() QUESTION
>
>
> > The SUM function really has nothing to do with how many records your
> > bringing back. Be careful with the "or" clause, this query is going to
> > bring back EVERY combination of the "membernumber/description" values
> > listed below.
> >
> >
> > ----- Original Message -----
> > From: William J Wheatley <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Monday, September 11, 2000 10:11 AM
> > Subject: URGENT: SUM() QUESTION
> >
> >
> > > This is a multi-part message in MIME format.
> > >
> > > ------=_NextPart_000_0123_01C01BE1.14ED4720
> > > Content-Type: text/plain;
> > > charset="iso-8859-1"
> > > Content-Transfer-Encoding: quoted-printable
> > >
> > > Question, i'm using sum(pic + sic + student) as grandtotal
> > >
> > > and when i run the query its returning the WHOLE table instead of jsut
> > =
> > > the
> > > values i want in the where clause
> > >
> > > select sum(pic + sic + student) as grandtotal
> > > from aeps.dbo.flighttimes
> > > where membernumber=3D1000017 and (description=3D'M RECP' or =
> > > description=3D'M TJET'
> > > or description=3D'M TPRP')
> > >
> > > Its returning the whole database instead of just the 4 records it
> > shoudl =
> > > be
> > > returning
> > > now the SUM function is adding properly but i dont wnat all those =
> > > records
> > > returned.
> > > Is there another faster way to do this then using SUM()?
> > >
> > > This is driving me crazy and its important
> > > thanks guys!
> > >
> > > ICQ: 417645
> > >
> > > Bill Wheatley
> > > Senior Developer
> > > AEPS INC
> > > http://www.aeps.com=20
> > > http://www.aeps2000.com
> > > 954-472-6684 X303
> > >
> > > ------=_NextPart_000_0123_01C01BE1.14ED4720
> > > Content-Type: text/html;
> > > charset="iso-8859-1"
> > > Content-Transfer-Encoding: quoted-printable
> > >
> > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > > <HTML><HEAD>
> > > <DEFANGED_META content=3D"text/html; charset=3Diso-8859-1" =
> > > http-equiv=3DContent-Type>
> > > <DEFANGED_META content=3D"MSHTML 5.00.3105.105" name=3DGENERATOR>
> > > <DEFANGED_STYLE></STYLE>
> > > </HEAD>
> > > <BODY bgColor=3D#ffffff>
> > > <DIV><FONT size=3D2>Question, i'm using sum(pic + sic + student) as=20
> > > grandtotal<BR><BR>and when i run the query its returning the WHOLE
> > table =
> > > instead=20
> > > of jsut the<BR>values i want in the where clause<BR><BR>select sum(pic
> > + =
> > > sic +=20
> > > student) as grandtotal<BR>from aeps.dbo.flighttimes<BR>where=20
> > > membernumber=3D1000017 and (description=3D'M RECP' or description=3D'M
> > =
> > > TJET'<BR>or=20
> > > description=3D'M TPRP')<BR><BR>Its returning the whole database
instead
> > =
> > > of just=20
> > > the 4 records it shoudl be<BR>returning<BR>now the SUM function is =
> > > adding=20
> > > properly but i dont wnat all those records<BR>returned.<BR>Is there =
> > > another=20
> > > faster way to do this then using SUM()?<BR><BR>This is driving me
crazy
> > =
> > > and its=20
> > > important<BR>thanks guys!<BR><BR>ICQ: 417645<BR></FONT></DIV>
> > > <DIV><FONT size=3D2>Bill Wheatley<BR>Senior Developer<BR>AEPS
> > INC<BR><A=20
> > > href=3D"http://www.aeps.com">http://www.aeps.com</A> <BR><A=20
> > >
> >
href=3D"http://www.aeps2000.com">http://www.aeps2000.com</A><BR>954-472-6
> > =
> > > 684=20
> > > X303</FONT></DIV></BODY></HTML>
> > >
> > > ------=_NextPart_000_0123_01C01BE1.14ED4720--
> > >
> >
> -----------------------------------------------------------------------
> > -------
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > 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/cf-talk@houseoffusion.com/
> > 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/cf-talk@houseoffusion.com/
> 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.
>
>
> **********************************************************************
> 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/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
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.
