Re: left outer join on query of query function
Not necessarily. How many records are in joinQuery? It should just have one, empty record. The point of the first query is to get the columns, but not to select any records; the empty record is created directly below it. oh yes your right joinquery shouldnt have any records basically i am trying to run this to outer join 2 queries using 3 primary key fields - subjectID, projectID, and testOccasionID so i have adapted it as follows: cfquery name=joinQuery dbtype=query SELECT * FROM QueryB WHERE QueryB.subjectID = -1 /cfquery cfset QueryAddRow(joinQuery) / cfquery name=result dbtype=query SELECT * FROM QueryA, QueryB WHERE QueryA.subjectID = QueryB.subjectID and QueryA.projectID = QueryB.projectID and QueryA.testOccasionID = QueryB.testOccasionID UNION SELECT QueryA.*, joinQuery.* FROM QueryA, joinQuery WHERE QueryA.subjectID NOT IN (#ValueList(QueryB.subjectID)#) and QueryA.projectID NOT IN (#ValueList(QueryB.projectID)#) and QueryA.testOccasionID NOT IN (#ValueList(QueryB.testOccasionID)#) /cfquery this doesnt create more rows in fact it actually takes rows off and produces duplicate columns, and doesnt work as a normal sql outer join would instead of using the joinquery.* i will get the column list, take out the primary keys fields so it doesnt duplicate them and then see whats happening thanks dave ~| 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:308355 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Application.names and sessions
On Mon, Jun 30, 2008 at 5:38 PM, marc -- [EMAIL PROTECTED] wrote: I had a setup like this but found out to my surprise that when I switch from the 1st to the 2nd scenario (using the application.cfc with THIS.name=B), the value for session.sessionId did not change. And all my sessionvariables were still there. Why is this? The session cookies's already been set, CF detects that, and just uses it. There is no need for a new tracking cookie to be set by CF so it doesn't set one. Internally CF will still keep App A and App B's session data separate, but it will use the same tracking cookie. Internally CF will use a combination of the sessionID and application name to make that session data unique. -Cameron -- Cameron Childress Sumo Consulting Inc http://www.sumoc.com --- cell: 678.637.5072 aim: cameroncf email: [EMAIL PROTECTED] ~| 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:308356 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Killing registry keys
Somewhere along the line my client variable storage got switched from DB to registry. I've switched it back to database but I have a registry key that's so large that regedit does not appear to be able to open it. Is there a way to clean out the registry key for client variables (other than regedit)? If I delete the key will it be recreated? I've seen reference to a killclient custom tag but cannot seem to locate it. Thanks for any help PSEA E-mail Firewall annotation on Tue Jul 01 2008 09:06:49 - NOTICE: Only the individual sender is responsible for the content of the message, and the message does not necessarily reflect the position or policy of the Pennsylvania State Education Association. - ~| 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:308357 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Killing registry keys
Somewhere along the line my client variable storage got switched from DB to registry. I've switched it back to database but I have a registry key that's so large that regedit does not appear to be able to open it. Is there a way to clean out the registry key for client variables (other than regedit)? If I delete the key will it be recreated? I've seen reference to a killclient custom tag but cannot seem to locate it. You can probably use the command-line tools successfully for this: http://www.petri.co.il/reg_command_in_windows_xp.htm I'm pretty sure reg.exe is available in Windows Server 2003 also. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:308358 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) Image Rollovers
I don't recall this being a problem in the past, but my image rollovers do not appear in IE 6 7, on or off. They work perfect in Firefox. I am using the standard code and Javascript. Any thoughts from the group. a href=# onMouseOut=MM_swapImgRestore() onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img src=images/weather.jpg name=Image28 width=80 height=20 border=0/a Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www.esu.edu ~| 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:308359 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) Image Rollovers
Got a link for us to see? -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: 01 July 2008 14:20 To: CF-Talk Subject: (ot) Image Rollovers I don't recall this being a problem in the past, but my image rollovers do not appear in IE 6 7, on or off. They work perfect in Firefox. I am using the standard code and Javascript. Any thoughts from the group. a href=# onMouseOut=MM_swapImgRestore() onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img src=images/weather.jpg name=Image28 width=80 height=20 border=0/a Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www.esu.edu ~| 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:308360 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) Image Rollovers
Are these buttons inside a cfoutput? The # inside the href attribute probably needs to be escaped. -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 8:20 AM To: CF-Talk Subject: (ot) Image Rollovers I don't recall this being a problem in the past, but my image rollovers do not appear in IE 6 7, on or off. They work perfect in Firefox. I am using the standard code and Javascript. Any thoughts from the group. a href=# onMouseOut=MM_swapImgRestore() onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img src=images/weather.jpg name=Image28 width=80 height=20 border=0/a Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www.esu.edu ~| 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:308362 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
query of query timing out
hi is there any reason why a basic query of query with only if statements and no loops would make the jrun processor shoot up and for it to eventually time out 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:308361 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: query of query timing out
hi is there any reason why a basic query of query with only if statements and no loops would make the jrun processor shoot up and for it to eventually time out thanks this is the code: cfquery name=newQuery dbtype=query select query.subjectID cfif queryType neq subject ,query.projectID /cfif cfif queryType eq testOccasion or queryType eq test ,query.testOccasionID /cfif cfif arraylen(newColumnArray) gt 0 ,#arraytolist(newColumnArray)# /cfif ,mergedColumnsQuery.#currentColumn# from query, mergedColumnsQuery /cfabort there are 2 queries named as above, they both have data in them, the currentcolumn does exist in the mergedcolumnquery, and the newColumnArray has 2 elements and both exist in the query if i place an abort before the query of query then it aborts in a couple of seconds, but if i place it after the query then it clogs up the jrun and just times out 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:308363 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) Image Rollovers
http://www4.esu.edu/inside/index.cfm The images are in the white header section. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 9:33 AM To: CF-Talk Subject: RE: (ot) Image Rollovers Got a link for us to see? -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: 01 July 2008 14:20 To: CF-Talk Subject: (ot) Image Rollovers I don't recall this being a problem in the past, but my image rollovers do not appear in IE 6 7, on or off. They work perfect in Firefox. I am using the standard code and Javascript. Any thoughts from the group. a href=# onMouseOut=MM_swapImgRestore() onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img src=images/weather.jpg name=Image28 width=80 height=20 border=0/a Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www.esu.edu ~| 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:308364 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) Image Rollovers
No, they are outside. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 9:45 AM To: CF-Talk Subject: RE: (ot) Image Rollovers Are these buttons inside a cfoutput? The # inside the href attribute probably needs to be escaped. -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 8:20 AM To: CF-Talk Subject: (ot) Image Rollovers I don't recall this being a problem in the past, but my image rollovers do not appear in IE 6 7, on or off. They work perfect in Firefox. I am using the standard code and Javascript. Any thoughts from the group. a href=# onMouseOut=MM_swapImgRestore() onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img src=images/weather.jpg name=Image28 width=80 height=20 border=0/a Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www.esu.edu ~| 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:308365 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) Image Rollovers
Might be because you're missing semicolons after your method calls? Is there anything in your .headercell class which could be causing them to disappear? What happens when you remove all of the onmouseover/mouseout attributes so that you have a simple, normal link? andy -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 8:49 AM To: CF-Talk Subject: RE: (ot) Image Rollovers http://www4.esu.edu/inside/index.cfm The images are in the white header section. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 9:33 AM To: CF-Talk Subject: RE: (ot) Image Rollovers Got a link for us to see? -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: 01 July 2008 14:20 To: CF-Talk Subject: (ot) Image Rollovers I don't recall this being a problem in the past, but my image rollovers do not appear in IE 6 7, on or off. They work perfect in Firefox. I am using the standard code and Javascript. Any thoughts from the group. a href=# onMouseOut=MM_swapImgRestore() onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img src=images/weather.jpg name=Image28 width=80 height=20 border=0/a Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www.esu.edu ~| 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:308366 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Image Rollovers
I think you've run into an infamous layout bug in IE. Try setting the width of the absolutely positioned div (class=weather). Edward A Savage Jr - Sonny Senior Software Engineer Creditdiscovery, LLC An appeaser is one who feeds a crocodile, hoping it will eat him last. ~ Sir Winston Churchill On Tue, Jul 1, 2008 at 9:19 AM, Steve LaBadie [EMAIL PROTECTED] wrote: I don't recall this being a problem in the past, but my image rollovers do not appear in IE 6 7, on or off. They work perfect in Firefox. I am using the standard code and Javascript. Any thoughts from the group. a href=# onMouseOut=MM_swapImgRestore() onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img src=images/weather.jpg name=Image28 width=80 height=20 border=0/a Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www.esu.edu ~| 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:308367 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
post limit and site wide error handler
Can anyone verify for me that CF *does* or *does not* handle POST size errors with a site wide error handler? Mine does not. instead of a normal CF error I get one of them ugly jrun 500 errors that looks like this: 500 coldfusion.filter.RequestThrottleFilter$PostSizeLimitExceededException: Post Size exceeds the maximum limit. at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:112) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.intergral.fusionreactor.filter.FusionReactorFilter.G(Unknown Source) at com.intergral.fusionreactor.filter.FusionReactorFilter.B(Unknown Source) at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(Unknown Source) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| 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:308368 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) Image Rollovers
If I remove everything, they still don't appear. The only thing in the headercell is color and paading. If I clear the cache and cookies the images appear. Once I refresh the screen the disappear. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 10:01 AM To: CF-Talk Subject: RE: (ot) Image Rollovers Might be because you're missing semicolons after your method calls? Is there anything in your .headercell class which could be causing them to disappear? What happens when you remove all of the onmouseover/mouseout attributes so that you have a simple, normal link? andy -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 8:49 AM To: CF-Talk Subject: RE: (ot) Image Rollovers http://www4.esu.edu/inside/index.cfm The images are in the white header section. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 9:33 AM To: CF-Talk Subject: RE: (ot) Image Rollovers Got a link for us to see? -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: 01 July 2008 14:20 To: CF-Talk Subject: (ot) Image Rollovers I don't recall this being a problem in the past, but my image rollovers do not appear in IE 6 7, on or off. They work perfect in Firefox. I am using the standard code and Javascript. Any thoughts from the group. a href=# onMouseOut=MM_swapImgRestore() onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img src=images/weather.jpg name=Image28 width=80 height=20 border=0/a Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www.esu.edu ~| 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:308369 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: post limit and site wide error handler
(oh ... 8.0.1 with the latest cumulative hot fix, on windows.. cf standard) On Tue, Jul 1, 2008 at 10:17 AM, Rick Root [EMAIL PROTECTED] wrote: Can anyone verify for me that CF *does* or *does not* handle POST size errors with a site wide error handler? Mine does not. instead of a normal CF error I get one of them ugly jrun 500 errors that looks like this: 500 coldfusion.filter.RequestThrottleFilter$PostSizeLimitExceededException: Post Size exceeds the maximum limit. at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:112) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.intergral.fusionreactor.filter.FusionReactorFilter.G(Unknown Source) at com.intergral.fusionreactor.filter.FusionReactorFilter.B(Unknown Source) at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(Unknown Source) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| 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:308370 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL Server, CF DSNs and large text fields.
I have a requirement to work with 8K+ character blocks of text in a ColdFusion Content system using a MS SQL Server database. This is going to be a 'text' field in MS SQL Server, correct? I am going to need to enable 'CLOB' fields in the Oracle DSN am I not? Any other DSN settings that need modification, Long Text Buffer or Blob Buffer? This is run on a hosted server, and I just need to make sure what I need to request the Hosting Provider on how to configure the DSN. TIA Ian ~| 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:308371 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) Image Rollovers
You have any javascript acting upon that table cell? Maybe some sort of show/hide code? -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 9:15 AM To: CF-Talk Subject: RE: (ot) Image Rollovers If I remove everything, they still don't appear. The only thing in the headercell is color and paading. If I clear the cache and cookies the images appear. Once I refresh the screen the disappear. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 10:01 AM To: CF-Talk Subject: RE: (ot) Image Rollovers Might be because you're missing semicolons after your method calls? Is there anything in your .headercell class which could be causing them to disappear? What happens when you remove all of the onmouseover/mouseout attributes so that you have a simple, normal link? andy -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 8:49 AM To: CF-Talk Subject: RE: (ot) Image Rollovers http://www4.esu.edu/inside/index.cfm The images are in the white header section. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 9:33 AM To: CF-Talk Subject: RE: (ot) Image Rollovers Got a link for us to see? -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: 01 July 2008 14:20 To: CF-Talk Subject: (ot) Image Rollovers I don't recall this being a problem in the past, but my image rollovers do not appear in IE 6 7, on or off. They work perfect in Firefox. I am using the standard code and Javascript. Any thoughts from the group. a href=# onMouseOut=MM_swapImgRestore() onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img src=images/weather.jpg name=Image28 width=80 height=20 border=0/a Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www.esu.edu ~| 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:308372 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) Image Rollovers
Just using the standard MM code that appears when you creat the rollerover in Dreamweaver. This has never been an issue before. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 10:27 AM To: CF-Talk Subject: RE: (ot) Image Rollovers You have any javascript acting upon that table cell? Maybe some sort of show/hide code? -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 9:15 AM To: CF-Talk Subject: RE: (ot) Image Rollovers If I remove everything, they still don't appear. The only thing in the headercell is color and paading. If I clear the cache and cookies the images appear. Once I refresh the screen the disappear. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 10:01 AM To: CF-Talk Subject: RE: (ot) Image Rollovers Might be because you're missing semicolons after your method calls? Is there anything in your .headercell class which could be causing them to disappear? What happens when you remove all of the onmouseover/mouseout attributes so that you have a simple, normal link? andy -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 8:49 AM To: CF-Talk Subject: RE: (ot) Image Rollovers http://www4.esu.edu/inside/index.cfm The images are in the white header section. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 9:33 AM To: CF-Talk Subject: RE: (ot) Image Rollovers Got a link for us to see? -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: 01 July 2008 14:20 To: CF-Talk Subject: (ot) Image Rollovers I don't recall this being a problem in the past, but my image rollovers do not appear in IE 6 7, on or off. They work perfect in Firefox. I am using the standard code and Javascript. Any thoughts from the group. a href=# onMouseOut=MM_swapImgRestore() onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img src=images/weather.jpg name=Image28 width=80 height=20 border=0/a Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www.esu.edu ~| 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:308373 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) Image Rollovers
Post the page and send out a URL. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 10:15 AM To: CF-Talk Subject: RE: (ot) Image Rollovers If I remove everything, they still don't appear. The only thing in the headercell is color and paading. If I clear the cache and cookies the images appear. Once I refresh the screen the disappear. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 10:01 AM To: CF-Talk Subject: RE: (ot) Image Rollovers Might be because you're missing semicolons after your method calls? Is there anything in your .headercell class which could be causing them to disappear? What happens when you remove all of the onmouseover/mouseout attributes so that you have a simple, normal link? andy -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 8:49 AM To: CF-Talk Subject: RE: (ot) Image Rollovers http://www4.esu.edu/inside/index.cfm The images are in the white header section. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 9:33 AM To: CF-Talk Subject: RE: (ot) Image Rollovers Got a link for us to see? -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: 01 July 2008 14:20 To: CF-Talk Subject: (ot) Image Rollovers I don't recall this being a problem in the past, but my image rollovers do not appear in IE 6 7, on or off. They work perfect in Firefox. I am using the standard code and Javascript. Any thoughts from the group. a href=# onMouseOut=MM_swapImgRestore() onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img src=images/weather.jpg name=Image28 width=80 height=20 border=0/a Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www.esu.edu ~| 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:308374 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF8 on SLES 10.2 - where is an updated glibc ?
I'm doing some tests before upgrading some of our servers, and I can't get 64bit CF8 to run on SLES 10.2 (which is listed as supported on the support matrix). I installed from the 64bit download (coldfusion-801-lin64.bin, md5sum checked) on adobe.com, and all I get from running 'cd /opt/coldfusion8;./coldfusion start' as root is --- Starting ColdFusion 8... The ColdFusion 8 server is starting up and will be available shortly. There has been an error starting ColdFusion 8, please check the logs. --- The logs are empty. I su'ed to the run time user (nobody) and then run the start up commands lifted from the start up script by hand: export PATH=$PATH:$CF_DIR/runtime/bin; export LD_LIBRARY_PATH=$LD_LIBRARY_PATH; cd $CF_DIR/runtime/bin; $CF_DIR/runtime/bin/coldfusion8 -jar jrun.jar -autorestart -start coldfusion and this gives the slightly more helpful 'Floating point exception'. So I use 'strace' to run '$CF_DIR/runtime/bin/coldfusion8 ...' and it's falling over real early, just after glibc is loaded. You'll note on the support matrix that SLES 10.1 requires glibc-2.5 but nothing is mentioned about 10.2 - and 10.2 only seems to come with glibc-2.4 here. Can anyone say they've got this working ? Or knows if there is an update we need to apply to SLES 10.2 (though the IT guys tell me it's up to date) ? . open(/lib64/libc.so.6, O_RDONLY) = 3 read(3, \177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0\0\1\0\0\0\200\322..., 832) = 832 fstat(3, {st_mode=S_IFREG|0755, st_size=1570331, ...}) = 0 mmap(NULL, 2355560, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x2aee1933f000 madvise(0x2aee1933f000, 2355560, MADV_SEQUENTIAL|0x1) = 0 mprotect(0x2aee19475000, 1048576, PROT_NONE) = 0 mmap(0x2aee19575000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED| MAP_DENYWRITE, 3, 0x136000) = 0x2aee19575000 mmap(0x2aee1957a000, 16744, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED| MAP_ANONYMOUS, -1, 0) = 0x2aee1957a000 close(3)= 0 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2aee1957f000 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2aee1958 arch_prctl(ARCH_SET_FS, 0x2aee1957fed0) = 0 --- SIGFPE (Floating point exception) @ 0 (0) --- +++ killed by SIGFPE +++ -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:308375 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) Image Rollovers
He did already. http://www4.esu.edu/inside/index.cfm -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 9:53 AM To: CF-Talk Subject: RE: (ot) Image Rollovers Post the page and send out a URL. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:308376 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) Image Rollovers
My reply is in reference to what is called the IE hasLayout() rendering bug... have you tried it? On Tue, Jul 1, 2008 at 10:04 AM, Sonny Savage [EMAIL PROTECTED] wrote: I think you've run into an infamous layout bug in IE. Try setting the width of the absolutely positioned div (class=weather). ~| 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:308377 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) Image Rollovers
No I haven't, not sure how to use it. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Sonny Savage [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 11:02 AM To: CF-Talk Subject: Re: (ot) Image Rollovers My reply is in reference to what is called the IE hasLayout() rendering bug... have you tried it? On Tue, Jul 1, 2008 at 10:04 AM, Sonny Savage [EMAIL PROTECTED] wrote: I think you've run into an infamous layout bug in IE. Try setting the width of the absolutely positioned div (class=weather). ~| 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:308378 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) Image Rollovers
You must have fixed it... http://www4.esu.edu/inside/index.cfm Rollovers are working for me on IE 7. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:308379 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 query timing out
i have noticed that if i run the query without the line: mergedColumnsQuery.#currentColumn# and if i dont add the mergedColumnsQuery query onto the from line then it works fine but when i add these then it actually doesnt even time it, it just keeps on loading the page and doesnt ever stop and jrun shoots up to use 70-80% of the processing speed does anyone have any clue why this would happen? thanks richard cfquery name=newQuery dbtype=query select query.subjectID cfif queryType neq subject , query.projectID /cfif cfif queryType eq testOccasion or queryType eq test , query.testOccasionID /cfif cfif arraylen(newColumnArray) gt 0 , #arraytolist(newColumnArray)# /cfif , mergedColumnsQuery.#currentColumn# from query, mergedColumnsQuery /cfabort ~| 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:308380 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) Image Rollovers
Your right it was working. When I refreshed the screen they disappeared and they were loading in the wrong place. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 11:21 AM To: CF-Talk Subject: RE: (ot) Image Rollovers You must have fixed it... http://www4.esu.edu/inside/index.cfm Rollovers are working for me on IE 7. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:308381 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: post limit and site wide error handler
Can anyone verify for me that CF *does* or *does not* handle POST size errors with a site wide error handler? It does not. I think you can use the JRun web server error handler for this; with IIS, you'd specify an errorurl entry in wsconfig\1\jrun.ini (assuming that IIS is the first web server configured for use with CF). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:308382 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Mid to Senior Cold Fusion Developer needed!
Location: Washington, DC (Foggy Bottom Metro Stop) Security Requirements: US Citizen: Must be eligible for a secret clearance. Client: Dept. of State Additional Job Description/Information: Our team supports the Information Resource Management Division at the U.S. Department of State in the development and maintenance of ColdFusion 7 applications. The development team consists of eight software development personnel including web designers, developers, testers, and analysts. Under the direction of the project manager, the candidate will be responsible for developing enhancements to existing applications using ColdFusion, Fusebox and SQL, and planning and executing migration from a custom ColdFusion content management application to SharePoint MOSS (with assistance from the on-site SharePoint team). Expertise developing ColdFusion applications, including the use of CF Components and a strong grasp of object-oriented programming Knowledge of ColdFusion development frameworks including Fusebox, Model-Glue or similar Strengths in data modeling, relational database creation and performance tuning utilizing tools such as stored procedures, triggers and views Experience in defining and documenting application architecture. Experience leveraging tools to automate unit testing and builds/deployment Strong SQL Skills and Microsoft SQL Server experience Solid understanding of and experience with the standard Software Development Lifecycle Good communication, planning, and analysis skills âMust Haveâ Requirements: 3-6 years of Cold Fusion Development Experience SQL. âNice to Haveâ Requirements: Fusebox, Model-Glue or similar Strengths in data modeling, relational database creation and performance tuning utilizing tools such as stored procedures, triggers and views SharePoint and .Net experience a plus! Experience: ColdFusion â 3+ years SQL - 6 years T-SQL or PL/SQL - 2 years HTML/CSS/JavaScript - 6 years Subversion (or similar version control system) Software Development Lifecycle - 6 years B.S. in Computer Science 3 to 5 yrs of experience Please contact Douglas Brownell @ [EMAIL PROTECTED] ~| 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:308383 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: query of query timing out
Richard White wrote: is there any reason why a basic query of query with only if statements and no loops would make the jrun processor shoot up and for it to eventually time out cfquery name=newQuery dbtype=query select query.subjectID ,mergedColumnsQuery.#currentColumn# from query, mergedColumnsQuery /cfabort This is an unconstrained / cartesian join. Make sure you have a where clause to reduce the size of the resultset. Jochem ~| 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:308384 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: post limit and site wide error handler
On Tue, Jul 1, 2008 at 11:32 AM, Dave Watts [EMAIL PROTECTED] wrote: Can anyone verify for me that CF *does* or *does not* handle POST size errors with a site wide error handler? It does not. I think you can use the JRun web server error handler for this; with IIS, you'd specify an errorurl entry in wsconfig\1\jrun.ini (assuming that IIS is the first web server configured for use with CF). as instructed here? http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19300 But that would have to be a very generic error page for any jrun error right, I couldn't perform CF processing and display a friendly error message based on the actual error that occurred (presumably, other errors SHOULD NOT occur but you never know!) I found this blog comment: http://coldfused.blogspot.com/2007/08/coldfusion-8-changes-with-file-upload.html Down on the page, a guy named rupesh kumar said: Let the post size be there in the server and set an error page for this in the web.xml. Thats because your site error handler and application error handler will also not get a chance to handle it. but goes into no further detail... Rick ~| 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:308385 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfajaximport/IE issues
When I import the cfwindow libraries via cfajaximport, my simple javascript menus will flicker in Internet Explorer and sometimes close themselves. This is the trouble with such libraries: they include all what you need,... but also 99% of what you don't need. Look all what you have: script type=text/javascript src=/CFIDE/scripts/ajax/package/cfajax.js/script script type=text/javascript src=/CFIDE/scripts/ajax/yui/yahoo-dom-event/yahoo-dom-event.js/script script type=text/javascript src=/CFIDE/scripts/ajax/yui/animation/animation-min.js/script script type=text/javascript src=/CFIDE/scripts/ajax/ext/adapter/yui/ext-yui-adapter.js/script script type=text/javascript src=/CFIDE/scripts/ajax/ext/ext-core.js/script script type=text/javascript src=/CFIDE/scripts/ajax/ext/package/resizable.js/script script type=text/javascript src=/CFIDE/scripts/ajax/ext/package/dragdrop/dragdrop.js/script script type=text/javascript src=/CFIDE/scripts/ajax/ext/package/util.js/script script type=text/javascript src=/CFIDE/scripts/ajax/ext/build/state/State-min.js/script script type=text/javascript src=/CFIDE/scripts/ajax/ext/package/widget-core.js/script script type=text/javascript src=/CFIDE/scripts/ajax/ext/package/dialog/dialogs.js/script script type=text/javascript src=/CFIDE/scripts/ajax/package/cfwindow.js/script This may represent lots of code, and apparently it slows down MSIE. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) 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:308386 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) Image Rollovers
I justy created a new rollover for webmail and it works fine. Either the positioning or something else in the header must be causing the problem. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 11:21 AM To: CF-Talk Subject: RE: (ot) Image Rollovers You must have fixed it... http://www4.esu.edu/inside/index.cfm Rollovers are working for me on IE 7. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:308387 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 query timing out
thanks Jochem, no wonder is was timing out!!! thanks for spotting that Richard White wrote: cfquery name=newQuery dbtype=query select query.subjectID ,mergedColumnsQuery.#currentColumn# from query, mergedColumnsQuery /cfabort This is an unconstrained / cartesian join. Make sure you have a where clause to reduce the size of the resultset. Jochem ~| 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:308388 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) Image Rollovers
Figured it out, it was the DIV tag surrounding the rollover. Placed the class inside of the link and they show. The only issue left is in IE7 they don't position correctly. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 11:22 AM To: CF-Talk Subject: RE: (ot) Image Rollovers Your right it was working. When I refreshed the screen they disappeared and they were loading in the wrong place. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 11:21 AM To: CF-Talk Subject: RE: (ot) Image Rollovers You must have fixed it... http://www4.esu.edu/inside/index.cfm Rollovers are working for me on IE 7. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:308389 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 query timing out
i am getting the exact same problem with the following query but cannot see why it is taking so long and what is missing - would also appreciate your help with this one: cfquery name= dbtype=query select query.subjectID,query.projectID,query.testOccasionID,query.subjectHeight,query.subjectWeight from query, mergedColumnsQuery where query.subjectID NOT IN (#ValueList(mergedColumnsQuery.subjectID)#) and query.projectID NOT IN (#ValueList(mergedColumnsQuery.projectID)#) and query.testOccasionID NOT IN (#ValueList(mergedColumnsQuery.testOccasionID)#) /cfquery ~| 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:308390 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) MS SQL Server
If I convert an column in a table that is curently a type of 'varchar(8000)' to a type of 'text(16)', does this truncate the data? I'm using Enterprise manager, when I put the conversion in, I note I can not change the size, so I presume that text is always size '16' and that this references the rest of the text however MS SQL Server handles this data type. When I do this, I get the 'data could be truncated' message. Is this just a proforma message, or am I possible not setting this up properly so that there is enough space for the current data in the field. TIA Ian ~| 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:308391 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 query timing out
Why is the mergedColumnsQuery included in the from clause? You are not using any of its columns in the select clause, nor are you filtering it in the where clause. Not only, but you again have not specified any join criteria to join it to the query query. (perhaps there's a better name for that one). You do not need to have the mergedColumnsQuery query in the from list to do the valuelist() stuff. ~Brad -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 11:38 AM To: CF-Talk Subject: Re: query of query timing out i am getting the exact same problem with the following query but cannot see why it is taking so long and what is missing - would also appreciate your help with this one: cfquery name= dbtype=query select query.subjectID,query.projectID,query.testOccasionID,query.subjectHeight ,query.subjectWeight from query, mergedColumnsQuery where query.subjectID NOT IN (#ValueList(mergedColumnsQuery.subjectID)#) and query.projectID NOT IN (#ValueList(mergedColumnsQuery.projectID)#) and query.testOccasionID NOT IN (#ValueList(mergedColumnsQuery.testOccasionID)#) /cfquery ~| 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:308392 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) MS SQL Server
16, is the size of the text pointer which points to another storage location where the actual text is stored. I'm not sure why it would tell you that the data will be truncated since a text field should hold far more than 8000 characters. Perhaps it is a just-in-case message. Are you on SQL Server 2000? If you are on 2005, the varchar(max) is much better than text. ~Brad -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 11:41 AM To: CF-Talk Subject: (ot) MS SQL Server If I convert an column in a table that is curently a type of 'varchar(8000)' to a type of 'text(16)', does this truncate the data? I'm using Enterprise manager, when I put the conversion in, I note I can not change the size, so I presume that text is always size '16' and that this references the rest of the text however MS SQL Server handles this data type. When I do this, I get the 'data could be truncated' message. Is this just a proforma message, or am I possible not setting this up properly so that there is enough space for the current data in the field. ~| 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:308393 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) MS SQL Server
If I convert an column in a table that is curently a type of 'varchar(8000)' to a type of 'text(16)', does this truncate the data? I'm using Enterprise manager, when I put the conversion in, I note I can not change the size, so I presume that text is always size '16' and that this references the rest of the text however MS SQL Server handles this data type. When I do this, I get the 'data could be truncated' message. Is this just a proforma message, or am I possible not setting this up properly so that there is enough space for the current data in the field. Text and ntext fields are always listed as that size. That's the size of the pointer to the actual storage location. I don't think you'll truncate your data in the conversion. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:308394 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 query timing out
ok thanks brad, i have taken it out of the from list, you learn something new everyday i hadnt realised that by putting that in there that it would think that i am joining it, even if i had not specified any columns from that query but would still attempt to join it. to be honest i thought i needed it to do the valuelist stuff as you said. it has sped it up thanks. you stated that i hadnt added any join clauses but as i think you guessed there was not meant to be a join thanks brad Why is the mergedColumnsQuery included in the from clause? You are not using any of its columns in the select clause, nor are you filtering it in the where clause. Not only, but you again have not specified any join criteria to join it to the query query. (perhaps there's a better name for that one). You do not need to have the mergedColumnsQuery query in the from list to do the valuelist() stuff. ~Brad i am getting the exact same problem with the following query but cannot see why it is taking so long and what is missing - would also appreciate your help with this one: cfquery name= dbtype=query select query.subjectID,query.projectID,query.testOccasionID,query.subjectHeight ,query.subjectWeight from query, mergedColumnsQuery where query.subjectID NOT IN (#ValueList(mergedColumnsQuery.subjectID)#) and query.projectID NOT IN (#ValueList(mergedColumnsQuery.projectID)#) and query.testOccasionID NOT IN (#ValueList(mergedColumnsQuery.testOccasionID)#) /cfquery ~| 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:308395 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: post limit and site wide error handler
as instructed here? http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19300 Yes. But that would have to be a very generic error page for any jrun error right, I couldn't perform CF processing and display a friendly error message based on the actual error that occurred (presumably, other errors SHOULD NOT occur but you never know!) Yes, that's correct. That page wouldn't receive any error variables, and should be a static file. Other errors may well occur, and if those errors occur CF pages may not be available at all. In fact, I don't even know if a CF page will work there at all. I found this blog comment: http://coldfused.blogspot.com/2007/08/coldfusion-8-changes-wit h-file-upload.html Down on the page, a guy named rupesh kumar said: Let the post size be there in the server and set an error page for this in the web.xml. Thats because your site error handler and application error handler will also not get a chance to handle it. but goes into no further detail... Rupesh is the author of the blog, and is (or was) on the CF 8 development team. Here's what this means, generally: http://www.jguru.com/faq/view.jsp?EID=318806 That said, I haven't tried it. I assumed that the connector would handle file upload throttle errors. I might be wrong about that, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:308396 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: query of query timing out
Glad it's working for you. I really wish QofQ would support the INNER JOIN table_name tn ON tn.column_name = syntax. To me, it is a lot easier to visually see how each table is being tied into the results. I have seen an incomplete join bring down the server when two large tables were joined together with no criteria. Like Jochem said, that is a Cartesian join, which means EVERY POSSIBLE combination of records from both tables will be returned. Let's say you join two tables together that both have only 1,000 records. You're going to get 1,000,000 records back. This effect grows exponentially. ~Brad -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 12:13 PM To: CF-Talk Subject: Re: query of query timing out ok thanks brad, i have taken it out of the from list, you learn something new everyday i hadnt realised that by putting that in there that it would think that i am joining it, even if i had not specified any columns from that query but would still attempt to join it. to be honest i thought i needed it to do the valuelist stuff as you said. it has sped it up thanks. you stated that i hadnt added any join clauses but as i think you guessed there was not meant to be a join thanks brad ~| 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:308397 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Simple cfmail driving me crazy!
I've set up an email form (with a captcha) that will submit an email to a seller on my website. The TO attribute is simply a query variable. But for some reason, I keep getting the following error. Attribute validation error for tag CFMAIL. The value of the attribute TO is invalid. The length of the string, 0 character(s), must be greater than or equal to 1. I use a cfdump and it alwsys returns a valid email address, so I can't figure out why the cfmail thinks the TO field is empty. Below is my code. Thanks in advance. Rick --- cfparam name=URL.ProdID default= cfquery name=getproducts datasource=DB SELECT ProdID, Email FROM Products P JOIN Users U ON P.UserID = U.UserID WHERE P.ProdID = cfqueryparam value=#Val(URL.ProdID)# cfsqltype=cf_sql_integer maxlength=4 /cfquery cfset sendEmail = #getproducts.Email# cfdump var=#sendEmail# !--- create captcha --- cfif not structKeyExists(application, captcha) cfset application.captcha = createObject(component, captchaService).init(configFile=captcha.xml) / cfset application.captcha.setup() /cfif cfparam name=form.name default= cfparam name=form.email default= cfparam name=form.comments default= cfparam name=form.phone default= cfset showForm = true cfif structKeyExists(form, sendcomments) cfset error = cfif not len(trim(form.name)) cfset error = error Please include your name.br /cfif cfif not len(trim(form.email)) or not isValid(email, form.email) cfset error = error Please include a valid email address.br /cfif !---cfif not len(trim(form.comments)) cfset error = error It's called a Comment Form, stupid.br /cfif--- cfif not application.captcha.validateCaptcha(form.hash, form.captcha) cfset error = error You did not match the image text. Please try again.br /cfif cfif error is cfmail to=#sendEmail# bcc=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=I'm interested in your dress on WoreItOnce.com server=mail.domain.com From: #form.name# (#form.email#) Phone: #form.phone# Comments: #form.comments# /cfmail cfset showForm = false /cfif /cfif cfif showForm cfif structKeyExists(variables, error) cfoutput p bPlease correct these errors:br #error# /b /p /cfoutput /cfif cfoutput form action=test2.cfm method=post table tr tdYour Name:br / input type=text name=name value=#form.name#/td /tr tr tdYour Email:br / input type=text name=email value=#form.email#/td /tr tr tdYour Phone:br / input name=phone type=text id=phone value=#form.phone#/td /tr tr tdYour Comments:br / textarea name=comments#form.comments#/textarea/td /tr tr tdEnter Text Shown in Picture:br / input type=text name=captchabr !--- Captcha --- cfset captcha = application.captcha.createHashReference() img src=captcha.cfm?hash=#captcha.hash# input name=hash type=hidden value=#captcha.hash# / /td /tr tr tdnbsp; input type=submit name=sendcomments value=Send Comments/td /tr /table /form /cfoutput cfelse cfoutput p Thank you for sending your comments, #form.name#. /p /cfoutput /cfif ~| 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:308398 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Simple cfmail driving me crazy!
for grins, try this: cfset sendEmail = #getproducts.Email[1]# On Tue, Jul 1, 2008 at 10:20 AM, Rick King [EMAIL PROTECTED] wrote: I've set up an email form (with a captcha) that will submit an email to a seller on my website. The TO attribute is simply a query variable. But for some reason, I keep getting the following error. Attribute validation error for tag CFMAIL. The value of the attribute TO is invalid. The length of the string, 0 character(s), must be greater than or equal to 1. I use a cfdump and it alwsys returns a valid email address, so I can't figure out why the cfmail thinks the TO field is empty. Below is my code. Thanks in advance. Rick -- A byte walks into a bar and orders a pint. Bartender asks him What's wrong? Byte says Parity error. Bartender nods and says Yeah, I thought you looked a bit off. ~| 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:308399 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: query of query timing out
your right, i wish they would support so much more in QoQ. i have read that it was not meant to be used in the way that so many people are now trying to use it. but i hope they realise that they have started the need for something that can really help people out and they should really satisfy the need they have created i havent read or heard about any enhancements to the QoQ in version 9 though, its a real shame if they don't thanks for your help again Glad it's working for you. I really wish QofQ would support the INNER JOIN table_name tn ON tn.column_name = syntax. To me, it is a lot easier to visually see how each table is being tied into the results. I have seen an incomplete join bring down the server when two large tables were joined together with no criteria. Like Jochem said, that is a Cartesian join, which means EVERY POSSIBLE combination of records from both tables will be returned. Let's say you join two tables together that both have only 1,000 records. You're going to get 1,000,000 records back. This effect grows exponentially. ~Brad ok thanks brad, i have taken it out of the from list, you learn something new everyday i hadnt realised that by putting that in there that it would think that i am joining it, even if i had not specified any columns from that query but would still attempt to join it. to be honest i thought i needed it to do the valuelist stuff as you said. it has sped it up thanks. you stated that i hadnt added any join clauses but as i think you guessed there was not meant to be a join thanks brad ~| 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:308400 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: left outer join on query of query function
ok im getting there and have narrowed it down to 1 more problem - i hope!! the problem is coming from the second part of the union where i am trying to find the rows that are eliminated in the first inner join part this problem only stems from the fact that i have more than 1 primary key if i had only 1 primary key then saying where queryA.ID not in #valuelist(queryB.id)# would work fine but what i have been doing is the following: where queryA.ID1 not in #valuelist(queryB.id1)# and queryA.ID2 not in #valuelist(queryB.id2)# and queryA.ID3 not in #valuelist(queryB.id3)# and this is returning nothing, which is now obvious to me as it is not looking correctly at all the 3 ids to see which combination of the ids dont exist, it is looking at one column at a time and to see which id1 are not there, then which id2's are not there etc... instead of looking at them as a combination of three does anyone know how i can achieve this: if this explanation is not clear then i can provide an example thanks for your help ~| 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:308401 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simple cfmail driving me crazy!
hmm...that didn't seem to work. As soon as I hit the submit button on the form (and don't fill in the Captcha correctly so it returns the error message), the cfdump returns an empty string for the email address. For some reason, I can't get that email address to stick. Any other 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:308402 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simple cfmail driving me crazy!
directly *after* the cfif error is , do a cfdump var=#sendEmail#cfabort /. is the value there? is it what you expected? On Tue, Jul 1, 2008 at 11:32 AM, Rick King [EMAIL PROTECTED] wrote: hmm...that didn't seem to work. As soon as I hit the submit button on the form (and don't fill in the Captcha correctly so it returns the error message), the cfdump returns an empty string for the email address. For some reason, I can't get that email address to stick. Any other 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:308403 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simple cfmail driving me crazy!
Looks like you're posting the form to itself, but not carrying over the URL.ProdID used in the where clause of the query in the form, so the second time through, nothing is returned by the query. On Tue, Jul 1, 2008 at 1:32 PM, Rick King [EMAIL PROTECTED] wrote: hmm...that didn't seem to work. As soon as I hit the submit button on the form (and don't fill in the Captcha correctly so it returns the error message), the cfdump returns an empty string for the email address. For some reason, I can't get that email address to stick. Any other 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:308404 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) Anyone run into this issue w/ CrystalTech.com
Just noticed it myself. Amazing that in 2008 that this is an issue. http://forums.crystaltech.com/index.php/topic,33421.0.html ~Che ~| 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:308405 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: left outer join on query of query function
This is off the top of head, but what if you did: where not (queryA.ID1 in #valuelist(queryB.id1)# and queryA.ID2 in #valuelist(queryB.id2)# and queryA.ID3 in #valuelist(queryB.id3)#) That way the valuelists are done together as a group, and then the not applies to all of them combined. Does that even make sense? ~Brad ~| 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:308406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Simple cfmail driving me crazy!
You're correct...how would I carry over URL.ProdID? I'm drawing a blank. Looks like you're posting the form to itself, but not carrying over the URL.ProdID used in the where clause of the query in the form, so the second time through, nothing is returned by the query. ~| 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:308407 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simple cfmail driving me crazy!
oooh good catch. few ways to do it. you could stick it in the form in a hidden field, or you can append it to the form's action. form action=test2.cfm?prodID=#URL.prodID# method=post if you go the hidden form field route, i did a quickie blog post a couple weeks back on form/URL vars... http://charlie.griefer.com/blog/index.cfm/2008/5/30/dealing-with-form-and-URL-variables (which was inspired by a thread here) :) On Tue, Jul 1, 2008 at 11:52 AM, Rick King [EMAIL PROTECTED] wrote: You're correct...how would I carry over URL.ProdID? I'm drawing a blank. Looks like you're posting the form to itself, but not carrying over the URL.ProdID used in the where clause of the query in the form, so the second time through, nothing is returned by the query. ~| 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:308408 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simple cfmail driving me crazy!
I'd pass it as a hidden field in the form, and then check at the top of the page for it in the url or form scope, throw it in a variables.ProdID, and use that in the query: cfif StructKeyExists(form,ProdID) cfset variables.ProdID = form.ProdID cfelseif StructKeyExists(URL,ProdID) cfset variables.ProdID = url.ProdID cfelse cfset variables.ProdID = /cfif On Tue, Jul 1, 2008 at 1:52 PM, Rick King [EMAIL PROTECTED] wrote: You're correct...how would I carry over URL.ProdID? I'm drawing a blank. Looks like you're posting the form to itself, but not carrying over the URL.ProdID used in the where clause of the query in the form, so the second time through, nothing is returned by the query. ~| 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:308409 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: left outer join on query of query function
Hi Brad, i thought that would work but not producing the result as expected, it still returns no rows on 2 queries where i know queryb has 15 rows that are not in querya therefore it should be returning those 15 but is not thanks This is off the top of head, but what if you did: where not (queryA.ID1 in #valuelist(queryB.id1)# and queryA.ID2 in #valuelist(queryB.id2)# and queryA.ID3 in #valuelist(queryB.id3)#) That way the valuelists are done together as a group, and then the not applies to all of them combined. Does that even make sense? ~Brad ~| 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:308410 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Simple cfmail driving me crazy!
Try commenting out the cfmail part and see what To: is returning You should probably un-comment this line as well: ;-) !---cfif not len(trim(form.comments)) cfset error = error It's called a Comment Form, stupid.br /cfif--- G On Tue, Jul 1, 2008 at 1:20 PM, Rick King [EMAIL PROTECTED] wrote: I've set up an email form (with a captcha) that will submit an email to a seller on my website. The TO attribute is simply a query variable. But for some reason, I keep getting the following error. Attribute validation error for tag CFMAIL. The value of the attribute TO is invalid. The length of the string, 0 character(s), must be greater than or equal to 1. I use a cfdump and it alwsys returns a valid email address, so I can't figure out why the cfmail thinks the TO field is empty. Below is my code. Thanks in advance. Rick -- If everything seems under control, you're not going fast enough -- Mario Andretti ~| 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:308411 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: left outer join on query of query function
Maybe I should back up and make sure I understand what it is you want. What you have written is a left outer join, but what you described was a right outer join. If you want the records in query B which do not exist in query A, then you need to flip flop, Query B needs to be in your FROM clause and Query A needs to be in the value list stuff. Here is a simple example I just tried that seems to work fine for me. cfquery datasource=your_datasource name=queryA SELECT 11 AS ID1, 21 AS ID2, 31 AS ID3, 'exists in both' as description UNION SELECT 12, 22, 32, 'exists in both' UNION SELECT 13, 23, 33, 'exists only in A' UNION SELECT 14, 24, 34, 'exists only in A' /cfquery cfquery datasource=your_datasource name=queryB SELECT 11 AS ID1, 21 AS ID2, 31 AS ID3, 'exists in both' as description UNION SELECT 12, 22, 32, 'exists in both' UNION SELECT 15, 25, 35, 'exists only in B' UNION SELECT 16, 26, 36, 'exists only in B' /cfquery cfquery dbtype=query name=qry_left_outer SELECT * FROM queryB WHERE NOT (queryB.ID1 in (#valuelist(queryA.id1)#) and queryB.ID2 in (#valuelist(queryA.id2)#) and queryB.ID3 in (#valuelist(queryA.id3)#)) /cfquery cfdump var=#qry_left_outer# ~Brad -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 2:13 PM To: CF-Talk Subject: Re: left outer join on query of query function Hi Brad, i thought that would work but not producing the result as expected, it still returns no rows on 2 queries where i know queryb has 15 rows that are not in querya therefore it should be returning those 15 but is not 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:308412 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: left outer join on query of query function
thanks for the description brad, yes sorry i wrote it wrong they do exists in query a and not in query b so i want to find those that exist in querya and not in query b. however your example is quite detailed and shows that the 'where not ()' clause should do the trick so there must be something else i am missing either in my code or previous outputs. i will output everything slowly to see why it is not returning the rows as expected thanks again for your help Maybe I should back up and make sure I understand what it is you want. What you have written is a left outer join, but what you described was a right outer join. If you want the records in query B which do not exist in query A, then you need to flip flop, Query B needs to be in your FROM clause and Query A needs to be in the value list stuff. Here is a simple example I just tried that seems to work fine for me. cfquery datasource=your_datasource name=queryA SELECT 11 AS ID1, 21 AS ID2, 31 AS ID3, 'exists in both' as description UNION SELECT 12, 22, 32, 'exists in both' UNION SELECT 13, 23, 33, 'exists only in A' UNION SELECT 14, 24, 34, 'exists only in A' /cfquery cfquery datasource=your_datasource name=queryB SELECT 11 AS ID1, 21 AS ID2, 31 AS ID3, 'exists in both' as description UNION SELECT 12, 22, 32, 'exists in both' UNION SELECT 15, 25, 35, 'exists only in B' UNION SELECT 16, 26, 36, 'exists only in B' /cfquery cfquery dbtype=query name=qry_left_outer SELECT * FROM queryB WHERE NOT (queryB.ID1 in (#valuelist(queryA.id1)#) and queryB.ID2 in (#valuelist(queryA.id2)#) and queryB.ID3 in (#valuelist(queryA.id3)#)) /cfquery cfdump var=#qry_left_outer# ~Brad Hi Brad, i thought that would work but not producing the result as expected, it still returns no rows on 2 queries where i know queryb has 15 rows that are not in querya therefore it should be returning those 15 but is not 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:308413 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: left outer join on query of query function
Ok, good luck. Note: I had to fiddle a little bit for my example to work. For instance, there needed to be () around the output of the valuelist etc, but I assumed that had been omitted in your post as an oversight or for simplicity. You can start by dumping your two queries and visually confirming that what you think exists in them actually does. ~Brad -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 3:14 PM To: CF-Talk Subject: Re: left outer join on query of query function thanks for the description brad, yes sorry i wrote it wrong they do exists in query a and not in query b so i want to find those that exist in querya and not in query b. however your example is quite detailed and shows that the 'where not ()' clause should do the trick so there must be something else i am missing either in my code or previous outputs. i will output everything slowly to see why it is not returning the rows as expected thanks again for your help ~| 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:308414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Datasource Issue - CF7
We had a test server recently run low on space and neo-query.xml became corrupt. We replaced it with a backup but since them any Access datasources and ODBC Socket datasources always say they are not found. If we try to update them in the cf admin we get: TCP/IP error, connection refused. The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused. Anyone else have this issue and no the cause/fix? Thanks, Scott ~| 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:308415 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Killing registry keys
If you can you temporarily switch storage back to registry and select the Purge Registry option to a shorter time. Once cold fusion purged the registry entries you will have to compact registry with a tool: http://technet.microsoft.com/en-us/sysinternals/bb897426.aspx ~| 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:308416 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: left outer join on query of query function
thanks brad no i hadn't omitted them for simplicity, i will try that as well then thanks again you have been really helpful, will let you know what happens Ok, good luck. Note: I had to fiddle a little bit for my example to work. For instance, there needed to be () around the output of the valuelist etc, but I assumed that had been omitted in your post as an oversight or for simplicity. You can start by dumping your two queries and visually confirming that what you think exists in them actually does. ~Brad thanks for the description brad, yes sorry i wrote it wrong they do exists in query a and not in query b so i want to find those that exist in querya and not in query b. however your example is quite detailed and shows that the 'where not ()' clause should do the trick so there must be something else i am missing either in my code or previous outputs. i will output everything slowly to see why it is not returning the rows as expected thanks again for your help ~| 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:308417 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Another Regex ?
I'm trying to make sure a cfscript if or for statement has no spaces in it. if(someVar gt 0){ do this } I thought I had my regex workin, but it returns true on this: cfset str = 'with the staff (measure expressions, note articulations,' cfset re = [if|for]+\s+\(|\)\s+\{ cfoutput#reFindNoCase(re, str)#/cfoutput That ain't good. WHat am I doin wrong? Thanks, Will ~| 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:308419 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: left outer join on query of query function
actually just looked at my real example and i do have the brackets!!! i think tiredness is getting me now, ill stop till tomorrow and try again, i find sometimes just taking my mind away from it makes it easier when i come back thanks again richard thanks brad no i hadn't omitted them for simplicity, i will try that as well then thanks again you have been really helpful, will let you know what happens thanks again for your help ~| 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:308418 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Another Regex ?
I replaced the brackets with parenthesis and it seems to work now. (if|for)+\s+\(|\)\s+\{ Thanks, Will ~| 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:308420 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Simple cfmail driving me crazy!
Thanks guys, it works now! I added the hidden field to the form, tested for either a form or URL variable, and threw it in the variables.ProdID. Perfect! Rick ~| 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:308421 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Can't access variable scope in cfc?
I'm trying to play nice with OOP and CFCs and using init methods to start them up but am running into a crazy problem that must have a simple fix. I instantiate the cfc in the application scope: cfset Application.cartCFC = createObject(component, cart).init(application.ds) In the init method I have the following: cfcomponent hint=I handle all cart interaction. output=false cffunction name=init access=public output=false returntype=cart cfargument name=ds required=true type=string cfscript variables.ds=arguments.ds; /cfscript cfreturn this /cffunction Then when I try to use variables.ds in another method call, it says that variables.ds doesn't exist even though when I set a breakpoint in the debugger right before that variable is called, it is there. What am I missing? cffunction name=CalculateCartLinePricing access=public displayname=Calculate Line Item Price hint=I calculate the line item price and cost in a shopping cart. output=false returntype=Struct cfargument default=1 name=CartDetail_Pk required=true type=Numeric cfstoredproc procedure=pr_getCartLineTotals datasource=#variables.ds# ~| 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:308422 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can't access variable scope in cfc?
Oh, here is the call I'm making which appears to be calling the correct cfc cfinvoke component=#Application.cartCFC# method=getCart returnvariable=getWebCartDetails cfinvokeargument name=UserID value=#variables.UserID# /cfinvoke ~| 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:308423 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can't access variable scope in cfc?
Real simple. Here you invoked the CFC and dropped it into the Application scope When you use CFINVOKE, you are re-instantiating the CFC, thus killing the one you already had open. Don't use CFINVOKE do this instead cfscript variables.args=StructNew(); variables.args.UserID=variables.UserID; getWebCartDetails= Application.cartCFC.getCart(argumentCollection=variables.args); /cfscript On Tue, Jul 1, 2008 at 1:54 PM, Ian Rutherford [EMAIL PROTECTED] wrote: Oh, here is the call I'm making which appears to be calling the correct cfc cfinvoke component=#Application.cartCFC# method=getCart returnvariable=getWebCartDetails cfinvokeargument name=UserID value=#variables.UserID# /cfinvoke ~| 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:308424 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can't access variable scope in cfc?
I was wondering if that was the case. If that's true, then the cf docs seem to be wrong: http://livedocs.adobe.com/coldfusion/8/htmldocs/buildingComponents_16.html They say that cfinvoke doesn't recreate the object, it only calls it. ~| 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:308425 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Can't access variable scope in cfc?
Just in case, I tried your code and am getting the same error. ~| 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:308426 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can't access variable scope in cfc?
Okay, I figured it out. I was calling the cfc directly instead of the one in the Application Scope from another page which was really throwing the error. I am pretty sure that the cfinvoke tag does not create a new copy of the object. ~| 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:308427 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Can't access variable scope in cfc?
cfinvoke component=#Application.cartCFC# method=getCart returnvariable=getWebCartDetails cfinvokeargument name=UserID value=#variables.UserID# /cfinvoke Here you invoked the CFC and dropped it into the Application scope When you use CFINVOKE, you are re-instantiating the CFC, thus killing the one you already had open. This is not correct. If you use CFINVOKE and set the COMPONENT attribute's value to an existing CFC instance, as above, it will call the method of the CFC instance in memory without reinstantiating anything. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:308428 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Spry accordion in a layoutarea
Why can I do this... cfajaximport tags=cflayout-border !--Link the CSS style sheet that styles the accordion-- link href=assets/SpryAccordion.css rel=stylesheet type=text/css / !--Link the Spry Accordion JavaScript library-- script src=assets/SpryAccordion.js type=text/javascript/script cflayout style=height:285px; type=vbox cflayoutarea style=height:285px; name=mylyt cfinclude template=accordionPage.cfm /cflayoutarea /cflayout but not this... cfajaximport tags=cflayout-border !--Link the CSS style sheet that styles the accordion-- link href=assets/SpryAccordion.css rel=stylesheet type=text/css / !--Link the Spry Accordion JavaScript library-- script src=assets/SpryAccordion.js type=text/javascript/script cflayout style=height:285px; type=vbox cflayoutarea style=height:285px; name=mylyt source=accordionPage.cfm /cflayoutarea /cflayout this causes an Error processing Javascript in markup for element in mylyt: This means I can't use ColdFusion.navigate() to load a page with a Spry accordion into a div or layoutarea. ? ~| 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:308429 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Stored Procedure Not Working
I have a MS SQL database and I have a stored procedure I'm trying to call with the following code.. cfset FutureTime=DateAdd('', 3, Now()) cfoutput#futureTime#/cfoutput cfstoredproc procedure=GetDate dataSource=#datasource# cfprocparam type=IN CFSQLType=CF_SQL_DATE value=#FutureTime# dbVarName=@Future cfprocparam type=IN CFSQLType=CF_SQL_VARCHAR value=#session.UserID# dbVarName=@UserID cfprocresult name=GetDate /cfstoredproc Here is the Stored Procedure ALTER PROCEDURE [dbo].[GetDate] @UserID varchar(50), @Future Datetime AS BEGIN SET NOCOUNT ON; SELECT [DateTaken] , [DateExpire] from TestResults Where UserID = @UserID and DateExpire @Future Order by Score DESC END Here's the kicker... It works perfect on Firefox... IE and Opera, I get the following coldfusion error... Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type varchar to datetime. First of all... Wha??? Second of all, if there is error in the code, why isn't firefox having a problem displaying it. My boss (who knows a bit about coldfusion says that firefox may be ignoring the error But that doesn't seem logical to me.. Can someone shed some light on this? ~| 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:308430 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Stored Procedure Not Working
Hmm, right off the bat, I don't think the browser would make any difference unless you have ColdFusion code that behaves differently depending on the browser. Perhaps something is being cached. Since getdate is the name of a function, maybe you should call your proc something else. Regardless, if appears your data types are mixed up. Your proc params list the date first and the varchar second, but the proc has the varchar first and the date second. ~Brad -Original Message- From: Phillip Vector [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 4:52 PM To: CF-Talk Subject: Stored Procedure Not Working I have a MS SQL database and I have a stored procedure I'm trying to call with the following code.. ~| 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:308431 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
See Gmail on your Google homepage
Your friend, [EMAIL PROTECTED], has sent you the following Google Gadget and included this message: See Gmail on your Google homepage » ~| 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:308432 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Stored Procedure Not Working
On Tue, Jul 1, 2008 at 2:55 PM, Brad Wood [EMAIL PROTECTED] wrote: Hmm, right off the bat, I don't think the browser would make any difference unless you have ColdFusion code that behaves differently depending on the browser. Perhaps something is being cached. I cleared out the cache and still the same issue. Also, no browser specific code. Regardless, if appears your data types are mixed up. Your proc params list the date first and the varchar second, but the proc has the varchar first and the date second. I didn't know that it needs to be the same order. I switched it and it's working now. Thanks. :) Wierd though how firefox didn't error out. ~| 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:308433 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Lyla CAPTCHA
Anyone else using Lyla captcha? In order to change the configuration of the captcha image, I need to update the xml file. OK, that's fine. But how do I re-instantiate the captcha object after making changes to the XML file so that I can see the updates on screen? Thanks, Rick ~| 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:308434 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Phillip Perry has invited you to open a Google mail account
I've been using Gmail and thought you might like to try it out. Here's an invitation to create an account. --- Phillip Perry has invited you to open a free Gmail account. To accept this invitation and register for your account, visit http://mail.google.com/mail/a-f23f08bf6f-4bfc5ddc1f-e86d8607a5 Once you create your account, Phillip Perry will be notified with your new email address so you can stay in touch with Gmail! If you haven't already heard about Gmail, it's a new search-based webmail service that offers: - Over 2,700 megabytes (two gigabytes) of free storage - Built-in Google search that instantly finds any message you want - Automatic arrangement of messages and related replies into conversations - Powerful spam protection using innovative Google technology - No large, annoying ads--just small text ads and related pages that are relevant to the content of your messages To learn more about Gmail before registering, visit: http://mail.google.com/mail/help/benefits.html And, to see how easy it can be to switch to a new email service, check out our new switch guide: http://mail.google.com/mail/help/switch/ We're still working every day to improve Gmail, so we might ask for your comments and suggestions periodically. We hope you'll like Gmail. We do. And, it's only going to get better. Thanks, The Gmail Team (If clicking the URLs in this message does not work, copy and paste them into the address bar of your browser). ~| 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:308435 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Stored Procedure Not Working
Named parameters didn't work in CF7. There was a Hotfix that made them work but I don't think it was ever part of the 7.0.1 or 7.0.2 release. I don't know if it made it into CF 8 or not. Chances are ColdFusion was defaulting to the usual practice of going off the order of the proc param tags. FWIW, running a trace on the database while you made the call would probably have shown the inputs going in the wrong place. ~Brad -Original Message- From: Phillip Vector [mailto:[EMAIL PROTECTED] I didn't know that it needs to be the same order. I switched it and it's working now. 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:308436 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Stopping Vacation Messages on BCC'd emails
Is there a way to get my mail server NOT to send a vacation message when I'm BCC'd on an email? Is there some sort of email header I can inject with CFMAILPARAM? (We use Exchange here, but hopefully there is something more generic in the protocol?) I have a bunch of forms that post information, and many of them BCC me in the background. When I setup a vacation message, all people who use this form get my vacation messages, and are very confused. Any way to stop this, short of removing my vacation message? (Yes, I know some people are vehemently opposed to using vacation messages - let's not go down that road here) Thanks, Dan ~| 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:308437 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Coldfusion Mapping
Hi, Where will coldfusion mapping will be stored, I mean any xml file or something like that. I need to get a mapping from CF admin, but I don't have access to the cf admin, so trying to get mapping info. Can anyone please help me to find the details 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:308438 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) Anyone run into this issue w/ CrystalTech.com
-Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 2:45 PM To: CF-Talk Subject: (ot) Anyone run into this issue w/ CrystalTech.com Just noticed it myself. Amazing that in 2008 that this is an issue. http://forums.crystaltech.com/index.php/topic,33421.0.html I've not see it, but CrystalTech uses the Serv-U FTP Server (an off-the-shelf server) - the bug is apparently in there. If you're on a dedicated box you could enable the built-in Windows server to upload the file. Jim Davis ~| 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:308439 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldfusion Mapping
Hi, Where will coldfusion mapping will be stored, I mean any xml file or something like that. I need to get a mapping from CF admin, but I don't have access to the cf admin, so trying to get mapping info. Can anyone please help me to find the details 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:308440 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion Mapping
sam menon wrote: Where will coldfusion mapping will be stored, I mean any xml file or something like that. neo-runtime.xml Jochem ~| 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:308441 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Stopping Vacation Messages on BCC'd emails
Dan LeGate wrote: Is there a way to get my mail server NOT to send a vacation message when I'm BCC'd on an email? Is there some sort of email header I can inject with CFMAILPARAM? You would have to find how to do it in manual of your mail server and once you have done that we can help you program the CF side. Jochem ~| 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:308442 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Senior CF Developer - Designer Available Now
I am seeking a FT telecommute position as ColdFusion Developer. Having 10 years of programming experience, I am capable of entry into any phase of a project, whether it be from conception through QA or from QA through launch, as well as various aspects of work including: migrations, schema development/enhancement, code revision, documentation, graphical design and user-interface framework. I have experience as Lead Designer, Lead Developer and Project Manager. I hold a BFA and have worked with all formats of multimedia. Scripting I have used: ColdFusion, HTML, DHTML, Java, Javascript, SQL, Actionscript 3, ASP, ASP.NET, C# and probably a few more over the years... I am adept with Adobe Creative Suite products, hand coding, Eclipse, Server set-up, Access, SQL Server, some Oracle. I have created e-commerce solutions, goverment intranet and public sites and marketing websites and online systems. Having telecommuted for the past few years and would prefer to telecommute, travel is fine. Please find resume and contact information at http://www.Andonia.com Stephen Hoskins [EMAIL PROTECTED] ~| 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-Jobs-Talk/message.cfm/messageid:3889 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: Senior CF Developer - Designer Available Now
Can you please post any future FLEX and ColdFusion jobs also at: http://groups.google.com/group/adogo-jobs . Thanks, RG. On Tue, Jul 1, 2008 at 11:42 AM, Stephen Hoskins [EMAIL PROTECTED] wrote: I am seeking a FT telecommute position as ColdFusion Developer. Having 10 years of programming experience, I am capable of entry into any phase of a project, whether it be from conception through QA or from QA through launch, as well as various aspects of work including: migrations, schema development/enhancement, code revision, documentation, graphical design and user-interface framework. I have experience as Lead Designer, Lead Developer and Project Manager. I hold a BFA and have worked with all formats of multimedia. Scripting I have used: ColdFusion, HTML, DHTML, Java, Javascript, SQL, Actionscript 3, ASP, ASP.NET http://asp.net/, C# and probably a few more over the years... I am adept with Adobe Creative Suite products, hand coding, Eclipse, Server set-up, Access, SQL Server, some Oracle. I have created e-commerce solutions, goverment intranet and public sites and marketing websites and online systems. Having telecommuted for the past few years and would prefer to telecommute, travel is fine. Please find resume and contact information at http://www.Andonia.comhttp://www.andonia.com/ Stephen Hoskins [EMAIL PROTECTED] ~| 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-Jobs-Talk/message.cfm/messageid:3890 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: Senior CF Developer - Designer Available Now
It's really considered rude to ask people on one mailing list to go to some other mailing list without at least contacting the list owner first. Judith Dinowitz Vice President House of Fusion On Tue, Jul 1, 2008 at 7:53 PM, [BWW] Ravi Gehlot [EMAIL PROTECTED] wrote: Can you please post any future FLEX and ColdFusion jobs also at: http://groups.google.com/group/adogo-jobs . Thanks, RG. ~| 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-Jobs-Talk/message.cfm/messageid:3891 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11