Query of Quries - Cfchart

[Michael Fisher]

Hi,

I am trying to establish a QofQ to determine the following:

I need to know how many people live in any given state (30 in California, 10 in 
Arizona...) The data will eventually populate a cfchart. 

my first query is as follows:

cfquery name=initial datasource=#DSN#
SELECT id, state FROM users
/cfquery

This gives me a result of about 100 rows (each user's state)

Im having troube formulating the second query. This is what I have so far

cfquery dbtype=query name=final
SELECT * FROM initial, users WHERE id = users.id AND state = users.state
/cfquery

But logically they are idential in nature...Im missing something. Can anybody 
please point me in the right direction. I need to sum up every instance of a 
state and return that as a number? Any help is appreciated!! 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311166
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Form submission issue

[Michael Fisher]

You can try this on your cfinput...confirmed working on IE7...

onKeyDown=if(Key.isDown(Key.ENTER)) {submitForm()} 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311167
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query of Quries - Cfchart

[Michael Fisher]

I think you need to look at GROUP BY which will let you write just one
query to the db, ie.

SELECT Count(id) as nUsers, state
FROM users
GROUP BY state

HTH

Dominic

That did the trick. Count along with Group worked great! Thanks!! 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311169
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CFWindow and CFForm Submit

[Michael Fisher]

Hi,

I have looked around and have found documentation stating that if I have a 
cfwindow with a cfform, the form will submit in the cfwindow and will NOT 
refresh the parent page. Is this correct. I need the parent page to refresh 
because I have a query setup when you initially hit the page. The cfwindow 
contains a cfgrid that populates from this query. When grid data is changed, 
the parent window never refreshes and the old data is still populated into the 
grid. When i manually refresh the parent page, the new data can now be seen.

Is there a way to refresh the parent page when using cfform and cfwindow?

Thanks! 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309191
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFLayout / Transparency

[Michael Fisher]

Don't want this thread to die. Does anybody have any ideas on how to get 
cflayout transparency? I have been messing around with the ext css file but am 
unable to find anything for cflayout. Any ideas?? THANKS! 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308873
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFLayout / Transparency

[Michael Fisher]

Brad, I am unfamiliar with that but I will def research it and see if it helps. 
Thanks for your input!! Much appreciated! 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308881
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CFLayout / Transparency

[Michael Fisher]

Hi,

I am running CF8 and have a question with respect to background transparency on 
CFLayouts. I came across a way to set the background to transparent if im using 
type=tabs but not type=Border. 

For cflayout type=Tabs the code is:

style
   .x-tabs-strip-wrap {
   background-color:transparent;
   }
/style

Does anybody know the css that is related to type=border or how to set the 
background to transparent / alpha:0?

Thanks 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308818
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4