Query of Quries - Cfchart
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
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
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
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
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
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
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