HI Bill
Thanks for responding. This sounds very interesting, and I would like
to explore it, but I had a problem using a structure for the way I'm using
the code after I get the dates. More importantly, I'm under the gun to
come up with a solution right away. I know it's klugy, but if you could
help me with just telling me how to write a query so that it only returns
dates where the year is 2014 or whatever, that would solve my immediate
problem. Then I can just write the 3 or 4 queries and get this in on
time. Later, then I can explore what you are talking about.
Thanks much,
Lewis
On Tue, May 28, 2013 at 7:38 PM, Bill Moniz <[email protected]> wrote:
>
> Ok...How about this:
>
> 1. Set up a struct called dateArrays: <cfset dateArrays = {} />
>
> 2. Do your single query as you are already, so you get back a recordset of
> dates. (I'll assume the query is called "dateQuery" and the column with the
> dates in it is called "date")
>
> 3. Loop over the query.
>
> At each iteration, check if you have a struct key defined for the year of
> the date you're looking at currently. If you don't, create one and stick
> an empty array in there:
>
> <cfif !structKeyExists(dateArrays, year(dateQuery.date))>
> <cfset dateArrays[year(dateQuery.date)] = [] />
> </cfif>
>
> Add the date you're looking at currently to the appropriate array in your
> struct:
> <cfset arrayAppend(dateArrays[year(dateQuery.date)], dateQuery.date) />
>
> 4. At the completion of your loop you should have a nice structure, with a
> key for each distinct year in your recordset, and the values being arrays
> of the dates that fall within that year.
>
> Now, I haven't actually run this code, but I'm convinced the theory is
> sound. ;)
>
> Cheers,
> Bill.
>
>
>
> On 29 May 2013 08:43, Lewis Billingsley <[email protected]>
> wrote:
>
> >
> > Thanks for responding Nick.
> >
> > The dates simply come from a database query, actually a query of a
> > stored procedure. There is a simple recordset of dates. There may be 4
> or
> > 5 years. It would be best if the query to array could happen just using
> > the one query. But, if I can't figure out how to do this that way, I
> would
> > be happy to have the 4 or 5 queries. But, I don't know what the code
> would
> > be to inject a <cfif statement in the query that would get, say, only the
> > dates that are in 2014. Can you help me figure this out?
> >
> > Thanks much,
> > Lewis
> >
> >
> >
> >
> > On Tue, May 28, 2013 at 2:53 PM, Eric Nicholas Sweeney <
> > [email protected]> wrote:
> >
> > >
> > > Lewis...
> > >
> > > How many years of data do you have?
> > >
> > > A few things come to mind.. You could have separate queries for each
> > > year... (clumsy but effective) Or tie a cfDiv to your query - based on
> > year
> > > passed to the div...
> > >
> > > The page...
> > > <cfform>
> > > <cfinput type="text" name="MyYear" value="#FORM. MyYear#" />
> > > </cfform>
> > >
> > > <h3>Results </h3>
> > > <cfdiv bind="url:MyResultsTable.cfm? MyYear ={MyYear}"
> bindonload="true"
> > />
> > >
> > >
> > > ---
> > > The Query... OnMy ResultsTable.cfm...
> > >
> > > SELECT Data
> > > FROM Table
> > > WHERE Year = <cfqueryparam value="#URL.MyYear#">
> > >
> > > This isn't final code - but it should help... Additionally - you could
> > > have the cfinput be a select - with Year drop down... looping from
> "this
> > > year" to earliest year...
> > >
> > > - Nick
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:6081
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
