What is the proper syntax for a join to make sure i do them right? but even
w/o a join its messing up
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 12:04 PM
Subject: RE: URGENT: SUM() QUESTION
> This is not how Sybase SQL is supposed to work!
>
> Unless there are some other parts of your query
> causing it to do a Cartesian product (ie you're
> referencing other tables but not joining to them
> properly) this is a bug.
>
> I guess you would need to do a CFLOOP and add
> the numbers up one at a time...
>
> There's something strange going on here!
>
> Nick
> -----Original Message-----
> From: William J Wheatley [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 11, 2000 5:02 PM
> To: [EMAIL PROTECTED]
> Subject: Re: URGENT: SUM() QUESTION
>
>
> linux, sybase
> 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:52 AM
> Subject: RE: URGENT: SUM() QUESTION
>
>
> > 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.
> >
>
> --------------------------------------------------------------------------
--
> --
> 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.
