Query of Quries - Cfchart

2008-08-18 Thread 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

Re: Form submission issue

2008-08-18 Thread 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

Re: Query of Quries - Cfchart

2008-08-18 Thread 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!!

CFWindow and CFForm Submit

2008-07-16 Thread 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

Re: CFLayout / Transparency

2008-07-10 Thread 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®

Re: CFLayout / Transparency

2008-07-10 Thread 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

CFLayout / Transparency

2008-07-09 Thread 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 {