That's very truly said. I guess there'd be other mailing lists for these things...
> -----Original Message----- > From: vikramjit singh [SMTP:[EMAIL PROTECTED] > Sent: Wednesday, June 04, 2003 12:52 PM > To: [EMAIL PROTECTED] > Subject: Re: Multiplying two columns and then adding up all the > records. > > Hey guys i think its a JSP forum, since when did this turn into a database > related forum. > > -----Original Message----- > From: A mailing list about Java Server Pages specification and reference > [mailto:[EMAIL PROTECTED] Behalf Of Ed Ventura > Sent: Wednesday, June 04, 2003 1:16 AM > To: [EMAIL PROTECTED] > Subject: Re: Multiplying two columns and then adding up all the records. > > > How would I incorporate the code into my sql statement below: > > SELECT * > FROM DOC.BCCHECKLIST > WHERE STARTTIMEDATE BETWEEN TO_DATE('varSTARTDATE','mm/dd/yyyy') AND > TO_DATE('varENDDATE','mm/dd/yyyy') > ORDER BY STARTTIMEDATE DESC > > > Thanks, > Ed. > > > > From: Clayton Nash <[EMAIL PROTECTED]> > > Reply-To: A mailing list about Java Server Pages specification and > reference > > <[EMAIL PROTECTED]> > > Date: Tue, 3 Jun 2003 17:01:10 +0100 > > To: [EMAIL PROTECTED] > > Subject: Re: Multiplying two columns and then adding up all the records. > > > > Select sum(pagecount*pages) > > > > Clayton > > ----- Original Message ----- > > From: "Ed Ventura" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, June 03, 2003 4:58 PM > > Subject: Multiplying two columns and then adding up all the records. > > > > > >> How do I multiply two columns and then add them all up from a > resultset? > > My > >> database looks like this: > >> > >> CLIENT PAGECOUNT PAGES > >> Xyzco 10 1 > >> Abcco 5 3 > >> Defco 3 6 > >> > >> So I need to multiply PAGECOUNT X PAGES for each record and then add > them > >> all up to get a total. In this example I would need to multiply (10 x > 1) > + > >> (5 x 3) + (3 x 6) = grandtotal. > >> > >> Thanks for any help, > >> Ed. > >> > >> > > > ========================================================================== > = > >> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > >> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > > DIGEST". > >> > >> Some relevant archives, FAQs and Forums on JSPs can be found at: > >> > >> http://java.sun.com/products/jsp > >> http://archives.java.sun.com/jsp-interest.html > >> http://forums.java.sun.com > >> http://www.jspinsider.com > >> > > > > > ========================================================================== > = > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > DIGEST". > > > > Some relevant archives, FAQs and Forums on JSPs can be found at: > > > > http://java.sun.com/products/jsp > > http://archives.java.sun.com/jsp-interest.html > > http://forums.java.sun.com > > http://www.jspinsider.com > > ========================================================================== > = > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > DIGEST". > > Some relevant archives, FAQs and Forums on JSPs can be found at: > > http://java.sun.com/products/jsp > http://archives.java.sun.com/jsp-interest.html > http://forums.java.sun.com > http://www.jspinsider.com > > ========================================================================== > = > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > DIGEST". > > Some relevant archives, FAQs and Forums on JSPs can be found at: > > http://java.sun.com/products/jsp > http://archives.java.sun.com/jsp-interest.html > http://forums.java.sun.com > http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com
