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/[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.
>
------------------------------------------------------------------------------
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.
