I just read you email a few minutes ago, after working on this for the
past hour.
-Original Message-
From: Maureen [mailto:mamamaur...@gmail.com]
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
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 g...@glmdesigns.com wrote:
I have a database with presidents, governors, etc. and need to be able to
pull out
Chabot [mailto:mcha...@gmail.com]
Sent: Saturday, September 25, 2010 10:50 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
You can do this in SQL, although the methods I can think of involve
advanced techniques so I hesitate to recommend them
, September 26, 2010 8:08 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
I was thinking years, but you could do days as well. It depends on
what you want to group on in the output.
To save you some searching, below is SQL to fill a numbers table for
SQL
-Original Message-
From: Mike Chabot [mailto:mcha...@gmail.com]
Sent: Saturday, September 25, 2010 10:50 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
You can do this in SQL, although the methods I can think of involve
advanced techniques so I hesitate
, September 25, 2010 10:50 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
You can do this in SQL, although the methods I can think of involve
advanced techniques so I hesitate to recommend them based on your
stated SQL experience. One technique involves joining
If you go with the numbers table route, I should clarify that this is
a standard technique that is commonly used, so you should be able to
find a lot of information by searching on sql server numbers table.
I use these all the time. I would think that your numbers table only
needs to contain
it a shot.
Thx
-Original Message-
From: Mike Chabot [mailto:mcha...@gmail.com]
Sent: Saturday, September 25, 2010 10:50 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
You can do this in SQL, although the methods I can think of involve
advanced
:42 AM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
If you go with the numbers table route, I should clarify that this is
a standard technique that is commonly used, so you should be able to
find a lot of information by searching on sql server numbers table.
I
.
Thx
-Original Message-
From: Mike Chabot [mailto:mcha...@gmail.com]
Sent: Saturday, September 25, 2010 10:50 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
You can do this in SQL, although the methods I can think of involve
, getting nominated to higher office, etc...)
I'll give it a shot.
Thx
-Original Message-
From: Mike Chabot [mailto:mcha...@gmail.com]
Sent: Saturday, September 25, 2010 10:50 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
You can do
I was thinking years, but you could do days as well. It depends on
what you want to group on in the output.
To save you some searching, below is SQL to fill a numbers table for
SQL Server, if you go that route. As I said earlier, the other methods
work fine also. I tend to prefer doing as much
it a shot.
Thx
-Original Message-
From: Mike Chabot [mailto:mcha...@gmail.com]
Sent: Saturday, September 25, 2010 10:50 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
You can do this in SQL, although the methods I can think
80,000 rows the numbers
table would be less than 400K. Not bad at all.
- Gil
-Original Message-
From: Mike Chabot [mailto:mcha...@gmail.com]
Sent: Sunday, September 26, 2010 8:08 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
I was thinking years
time.
For instance:
list the governors in 1889;
list the number of female governors in 2005
thx
-Original Message-
From: Mike Chabot [mailto:mcha...@gmail.com]
Sent: Friday, September 24, 2010 7:35 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical
: Re: cfoutput or cfloop? which is the more practical solution
You can do this in SQL, although the methods I can think of involve
advanced techniques so I hesitate to recommend them based on your
stated SQL experience. One technique involves joining to a numbers
table which will transform
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:
1789 : 0
1790 : 0
.
2005 : 10
.
2010 : 6
The database has dateStarted, dateEnded
Are you able to craft a query that will return the results you need
without ColdFusion having to do any extra parsing of it? That is the
first thing I would try. In your brief example it seems like that
would be solved using a GROUP BY statement in the query.
-Mike Chabot
On Fri, Sep 24, 2010
in your query only select only female governess
then use the cfoutput group attribute to group by year, this will then only
output records for the same year.
you need to next 2 cfoutput.
cfoutput query=myquery
cfoutput group=year
your output here
/cfoutput
/cfoutput
On Sat, Sep
-
From: Mike Chabot [mailto:mcha...@gmail.com]
Sent: Friday, September 24, 2010 7:35 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
Are you able to craft a query that will return the results you need
without ColdFusion having to do any extra parsing
20 matches
Mail list logo