I have a table which records form submissions. Each form submission has a date submitted value recorded. Is there an efficient way to select the data to be able to display a graph of the last 7 days with a total value (number of submissions for each day).
I could return the total for a give date using the count() clause and datepart() clause, but this would only return 1 day's total. Is there a way to return more than 1 total in a single query? I do not have Cf5.0 or this might be a perfect candidate for a Query of a Query.... Brook Davies maracasmedia inc. At 05:01 PM 05/07/02 +0100, you wrote: >Seems to work in SQL Server 7 :O) > > >-----Original Message----- >From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] >Sent: 05 July 2002 16:55 >To: CF-Talk >Subject: Re: Adding Values (SQL) > > >No, something like this > >SELECT column1, column2 + 3 AS NewQty >FROM tablename >WHERE id = 2 > > >----- Original Message ----- >From: "Adrian Lynch" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Friday, July 05, 2002 10:48 AM >Subject: RE: Adding Values (SQL) > > > > Are you looking to add 3 to all the values in col2? > > > > -----Original Message----- > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > > Sent: 05 July 2002 16:37 > > To: CF-Talk > > Subject: Adding Values (SQL) > > > > > > I don't have any cheet sheets with me, but I need to do a simple query and > > have an addition statement in the SELECT statment of a query. > > > > Something like: > > > > SELECT, column1, column2 + 3 AS NewQty > > FROM..... > > > > Basically column2 is a numeric value and I want to add a number to it and > > rename the Column to NewQty. > > > > Does anyone have the correct sytax? > > > > Thanks! > > > > Paul Giesenhagen > > QuillDesign > > > > > > > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
