Of course, after all that, I've been pulled away to another project.
Although I haven't worked on it in mulling it over I haven't yet crossed the
conceptual barrier.
You have a series of dates when someone takes and leaves office.
TABLE: Governor
FNAME
MNAME
LNAME
DATE START
DATE END
STATE
PARTY
DOB
DODeath
GENDER
RACE
RELIGION
PLACE BORN
PLACE DIED
MILITARY SERVICE (ARMY CAPTAIN, etc)
...
Say you want to do a query for all female governors in the 1990s
SELECT
FNAME
MNAME
LNAME
DATESTART
DATEEND
GENDER
FROM
GOVERNOR
WHERE
DATEEND is greater or equal to January 1, 1990 and
DATESTART is lesser or equal to December 31, 1999
(If a person is still in office the date is listed as December 31, 3000.)
I'm trying to get my brain around how best to use a numbers/date table.
How to create the query.
Funny I just read you email a few minutes ago, after working on this for the
past hour.
-----Original Message-----
From: Maureen [mailto:[email protected]]
Sent: Thursday, September 30, 2010 10:15 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
Did you get this working? If not, could you post the structure of
your data table and I'll see if I can send you the SQL to generate it.
On Fri, Sep 24, 2010 at 4:23 PM, GLM <[email protected]> wrote:
>
> I have a database with presidents, governors, etc. and need to be able to
> pull out information such as:
>
>
>
> Get the number of all female governors over the years and spit out
something
> on the order of:
> This seems like a foolish way to do this. Is there a better way to do it?
Is
> it better to make one query and then use CF to parse it
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337793
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
