SQL help
I'm trying to figure out how to do something in SQL and I'm stumped. Essentially I have 5 tables t_salesreps contains sales reps t_cdusage contains session information - each time the sales rep uses the CD t_contentusage contains 1 row for each presentation show in a session. t_contentviewers contains doctors who viewed those presentations t_doctors contains those doctors. I need to count total viewers using an aggregate function. "Total Viewers" is defined as the number of doctors who participate in a session by viewing one or more presentations. If a doctor attends two sessions, he gets counted twice - but *NOT* for each presentation. The following query returns the count of doctors * presentations select count(t_doctors.pkey_doctor) as total_viewers_month from t_doctors A inner join t_contentviewers B on A.pkey_doctor=B.pkey_doctor inner join t_contentusage C on B.pkey_contentusage=C.pkey_contentusage inner join t_cdusage D on C.pkey_cdusage=D.pkey_cdusage inner join t_salesreps E on D.pkey_salesrep=E.pkey_salesrep But I essentially need to return # of doctors * # of sessions. If I do count(distinct t_doctors.pkey_doctor) it returns only "unique viewers".. so doctors don't count twice if they attend two sessions. What am I looking for here? I'm going to experiment with some groupings and such... but if anyone out there late on a sunday night wants to pipe in let me know! Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236800 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
XP Web Publishing Wizard and Coldfusion
Has anyone used the Windows XP Web Publishing Wizard and ColdFusion together? If so, any pointers/reference material for how to get started? Thanks! Jake ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236799 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: IsValid() is good?
Ok I have 1.2 installed, how do I edit the tag ? -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 02 April 2006 20:50 To: CF-Talk Subject: Re: IsValid() is good? Edit tag has been added.. you can add tags/functions from the dictionary view autocomplete tags is there, working on functions (does homesite complete functions??) dont thing the 2 pane split code view will be there anytime soon. RDS has been added and CFC explorer is there. Does that help? MD On 2 Apr 2006, at 18:41, Snake wrote: > Well if/when CFEclipse has the features I use most in homesite and > don't really want to live without, then I'll consider switching. But > the last time I tried it, I still preferred homesite. > > These are. > > Right click insert tag/expression. > Right click edit tag properties. > Auto complete tags/functions > 2 pane split code view > > > Feel free to enlighten me if these have been added since I last looked > at it > :-) > > Russ > > -Original Message- > From: Mark Drew [mailto:[EMAIL PROTECTED] > Sent: 02 April 2006 17:59 > To: CF-Talk > Subject: Re: IsValid() is good? > > Thats the problem with still being on homesite ;) > > > MD > On 2 Apr 2006, at 15:08, Snake wrote: > >> Well there is a new function I didn't notice. >> In the CFMX7 homesite update, that function is not included in the >> expression builder. >> >> russ >> >> -Original Message- >> From: Will Tomlinson [mailto:[EMAIL PROTECTED] >> Sent: 02 April 2006 12:13 >> To: CF-Talk >> Subject: IsValid() is good? >> >> I was just thinking about using isvalid() to check my emails before >> cfmailing and such... and wanted to see if you guys are using it >> much. >> >> Does it work well? Any problems you've encountered? >> >> Thanks, >> Will >> >> >> >> > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236798 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: IsValid() is good?
Snake, I'd say so. Even cooler - if you are too lazy to install the SVS plugins, Eclipse has it's own "lite" versioning of files. Very cool to have something like that builtin. On 4/2/06, Snake <[EMAIL PROTECTED]> wrote: > I think that's enuf to make me install it again for another look :-) > > The source control is better in eclipse as well isn't it ? > > -Original Message- > From: Mark Drew [mailto:[EMAIL PROTECTED] > Sent: 02 April 2006 20:50 > To: CF-Talk > Subject: Re: IsValid() is good? > > Edit tag has been added.. you can add tags/functions from the dictionary > view autocomplete tags is there, working on functions (does homesite > complete functions??) > > dont thing the 2 pane split code view will be there anytime soon. > > RDS has been added and CFC explorer is there. > > Does that help? > > MD > > On 2 Apr 2006, at 18:41, Snake wrote: > > > Well if/when CFEclipse has the features I use most in homesite and > > don't really want to live without, then I'll consider switching. But > > the last time I tried it, I still preferred homesite. > > > > These are. > > > > Right click insert tag/expression. > > Right click edit tag properties. > > Auto complete tags/functions > > 2 pane split code view > > > > > > Feel free to enlighten me if these have been added since I last looked > > at it > > :-) > > > > Russ > > > > -Original Message- > > From: Mark Drew [mailto:[EMAIL PROTECTED] > > Sent: 02 April 2006 17:59 > > To: CF-Talk > > Subject: Re: IsValid() is good? > > > > Thats the problem with still being on homesite ;) > > > > > > MD > > On 2 Apr 2006, at 15:08, Snake wrote: > > > >> Well there is a new function I didn't notice. > >> In the CFMX7 homesite update, that function is not included in the > >> expression builder. > >> > >> russ > >> > >> -Original Message- > >> From: Will Tomlinson [mailto:[EMAIL PROTECTED] > >> Sent: 02 April 2006 12:13 > >> To: CF-Talk > >> Subject: IsValid() is good? > >> > >> I was just thinking about using isvalid() to check my emails before > >> cfmailing and such... and wanted to see if you guys are using it > >> much. > >> > >> Does it work well? Any problems you've encountered? > >> > >> Thanks, > >> Will > >> > >> > >> > >> > > > > > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236797 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: IsValid() is good?
I think that's enuf to make me install it again for another look :-) The source control is better in eclipse as well isn't it ? -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 02 April 2006 20:50 To: CF-Talk Subject: Re: IsValid() is good? Edit tag has been added.. you can add tags/functions from the dictionary view autocomplete tags is there, working on functions (does homesite complete functions??) dont thing the 2 pane split code view will be there anytime soon. RDS has been added and CFC explorer is there. Does that help? MD On 2 Apr 2006, at 18:41, Snake wrote: > Well if/when CFEclipse has the features I use most in homesite and > don't really want to live without, then I'll consider switching. But > the last time I tried it, I still preferred homesite. > > These are. > > Right click insert tag/expression. > Right click edit tag properties. > Auto complete tags/functions > 2 pane split code view > > > Feel free to enlighten me if these have been added since I last looked > at it > :-) > > Russ > > -Original Message- > From: Mark Drew [mailto:[EMAIL PROTECTED] > Sent: 02 April 2006 17:59 > To: CF-Talk > Subject: Re: IsValid() is good? > > Thats the problem with still being on homesite ;) > > > MD > On 2 Apr 2006, at 15:08, Snake wrote: > >> Well there is a new function I didn't notice. >> In the CFMX7 homesite update, that function is not included in the >> expression builder. >> >> russ >> >> -Original Message- >> From: Will Tomlinson [mailto:[EMAIL PROTECTED] >> Sent: 02 April 2006 12:13 >> To: CF-Talk >> Subject: IsValid() is good? >> >> I was just thinking about using isvalid() to check my emails before >> cfmailing and such... and wanted to see if you guys are using it >> much. >> >> Does it work well? Any problems you've encountered? >> >> Thanks, >> Will >> >> >> >> > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236796 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: IsValid() is good?
Edit tag has been added.. you can add tags/functions from the dictionary view autocomplete tags is there, working on functions (does homesite complete functions??) dont thing the 2 pane split code view will be there anytime soon. RDS has been added and CFC explorer is there. Does that help? MD On 2 Apr 2006, at 18:41, Snake wrote: > Well if/when CFEclipse has the features I use most in homesite and > don't > really want to live without, then I'll consider switching. But the > last time > I tried it, I still preferred homesite. > > These are. > > Right click insert tag/expression. > Right click edit tag properties. > Auto complete tags/functions > 2 pane split code view > > > Feel free to enlighten me if these have been added since I last > looked at it > :-) > > Russ > > -Original Message- > From: Mark Drew [mailto:[EMAIL PROTECTED] > Sent: 02 April 2006 17:59 > To: CF-Talk > Subject: Re: IsValid() is good? > > Thats the problem with still being on homesite ;) > > > MD > On 2 Apr 2006, at 15:08, Snake wrote: > >> Well there is a new function I didn't notice. >> In the CFMX7 homesite update, that function is not included in the >> expression builder. >> >> russ >> >> -Original Message- >> From: Will Tomlinson [mailto:[EMAIL PROTECTED] >> Sent: 02 April 2006 12:13 >> To: CF-Talk >> Subject: IsValid() is good? >> >> I was just thinking about using isvalid() to check my emails before >> cfmailing and such... and wanted to see if you guys are using it >> much. >> >> Does it work well? Any problems you've encountered? >> >> Thanks, >> Will >> >> >> >> > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236795 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: IsValid() is good?
Well if/when CFEclipse has the features I use most in homesite and don't really want to live without, then I'll consider switching. But the last time I tried it, I still preferred homesite. These are. Right click insert tag/expression. Right click edit tag properties. Auto complete tags/functions 2 pane split code view Feel free to enlighten me if these have been added since I last looked at it :-) Russ -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 02 April 2006 17:59 To: CF-Talk Subject: Re: IsValid() is good? Thats the problem with still being on homesite ;) MD On 2 Apr 2006, at 15:08, Snake wrote: > Well there is a new function I didn't notice. > In the CFMX7 homesite update, that function is not included in the > expression builder. > > russ > > -Original Message- > From: Will Tomlinson [mailto:[EMAIL PROTECTED] > Sent: 02 April 2006 12:13 > To: CF-Talk > Subject: IsValid() is good? > > I was just thinking about using isvalid() to check my emails before > cfmailing and such... and wanted to see if you guys are using it much. > > Does it work well? Any problems you've encountered? > > Thanks, > Will > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236794 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Anything inherently wrong with this query?
Some good thoughts, Isaac. I haven't built any blogging or forums tools so everything so far has required referential integrity. But when I do get around to some blogging tools, which I plan to, I'll definitely keep your perspective in mindgood stuff to know. Rick -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Saturday, April 01, 2006 11:57 PM To: CF-Talk Subject: RE: Anything inherently wrong with this query? > Thanks for the explanation, Isaac! Also just FYI, although referential integrity is desired in most cases, there are some exceptions in which you may not want to enforce referential integrity. Typically the only place you would want to allow orphaned records would be in a logging tool or in a record which is representative of some sort of log like a blog comment. This allows you to maintain a log entry for an event, even if the log references a deleted user. The act of deleting the user doesn't alter history, so you still want to retain a record of the event. message truncated... ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236793 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: IsValid() is good?
Thats the problem with still being on homesite ;) MD On 2 Apr 2006, at 15:08, Snake wrote: > Well there is a new function I didn't notice. > In the CFMX7 homesite update, that function is not included in the > expression builder. > > russ > > -Original Message- > From: Will Tomlinson [mailto:[EMAIL PROTECTED] > Sent: 02 April 2006 12:13 > To: CF-Talk > Subject: IsValid() is good? > > I was just thinking about using isvalid() to check my emails before > cfmailing and such... and wanted to see if you guys are using it much. > > Does it work well? Any problems you've encountered? > > Thanks, > Will > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236792 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion Tech Talk (CF-Talk): Digest every 2 hours
Small typo in the cfoutput section. it should be myVar, not myVal. On 4/2/06, Tim Lux <[EMAIL PROTECTED]> wrote: > Re: isValid(). > > I noticed a strange situtation with isValid. > > Try this and see if it works on your install: > > > > #isValid("integer",myVal)# > > I get NO for the above CFOUTPUT. > > Tim > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236791 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion Tech Talk (CF-Talk): Digest every 2 hours
Re: isValid(). I noticed a strange situtation with isValid. Try this and see if it works on your install: #isValid("integer",myVal)# I get NO for the above CFOUTPUT. Tim ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236790 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: IsValid() is good?
Well there is a new function I didn't notice. In the CFMX7 homesite update, that function is not included in the expression builder. russ -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: 02 April 2006 12:13 To: CF-Talk Subject: IsValid() is good? I was just thinking about using isvalid() to check my emails before cfmailing and such... and wanted to see if you guys are using it much. Does it work well? Any problems you've encountered? Thanks, Will ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236789 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: asynchronous messages
Bud wrote: > Is there an equivalent of this application somewhere else, or > something CF that I'm not aware of? the socket gateway in cf7? or depending on how complex or how asynch this thing needs to be you might try java.net.Socket class via cf. i'll send you a simple example off-list. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236788 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: IsValid() is good?
I'm using it like this... Will ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236787 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
IsValid() is good?
I was just thinking about using isvalid() to check my emails before cfmailing and such... and wanted to see if you guys are using it much. Does it work well? Any problems you've encountered? Thanks, Will ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236786 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
asynchronous messages
Hi. I have a need to do an asynchronous session, which I'm not familiar with. It looks like I have to post raw messages, but it's not a form post and in fact, uses no protocol I guess. Just a raw socket connection. I've attempted to use cfx_rawsocket but that apparently places header information in the post depending on the protocol entered. I need to pass the data I supply, period. There IS a Component DLL, AspSock, which I'd like to try, but they are apparently not supported.The demo is expired when you download it and the company doesn't answer email. http://www.serverobjects.com/comp/aspsock.htm Is there an equivalent of this application somewhere else, or something CF that I'm not aware of? Thanks in advance. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development & Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local & Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236785 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Java.net.connectexception
That KB article might not relate to your problem... can you post the error stack trace? As for jvm.config, just remove what you added, if you can. -Original Message- From: Webdevotion [mailto:[EMAIL PROTECTED] Sent: Sunday, 2 April 2006 4:27 AM To: CF-Talk Subject: Java.net.connectexception Hello, I ran into a java.net.connectexception when trying to start a flex-message gateway (for the session tracker example). I tried to fix it using this technote, but I did something wrong. http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19185 Can someone please do a search on "jvm.config" and "jndi.properties" on his CFMX 7 folder (with mystic update) and mail it to me ? Does anyone know why this error occured ? Thanks ! Excerpt To avoid this problem, edit either the *jvm.config* or *jndi.properties*files of the JRun server to bind the RMI service to the external IP address. The following examples demonstrate the work-arounds: 1. *jvm.config* 2. java.args=-Djava.rmi.server.hostname=[server name or IP address] 3. *jndi.properties* 4. Add the following property to jndi.properties: java.rmi.server.hostname=[server ip address 5. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236784 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54