Tomcat Server
Hi, I am trying to set up an apache tomcat server to run CF7, CF8 and railo on the same machine. The idea came from last week's Online CF User group presentation. I want to start and stop tomcat from eclipse for flexibility but am getting stuck with configuring it so that eclipse can see it. i have wated the presentation 3 times now but can't see what I am missing. Anyone know what needs to be done so that the servers panel can see the Tomcat servers? There is probably some config file but I can find it. Kevin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325818 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Tomcat Server
Thanks Larry, I will try that next week. Kevin On Fri, Aug 28, 2009 at 1:55 PM, Larry Lyons larrycly...@gmail.com wrote: If you're using Eclipse you'll need to install the Webtools plugin, http://www.eclipse.org/webtools/. As an alternative you can also use the MyEclipse plugin, it makes the controlling J2EE servers a lot easier, http://www.myeclipseide.com/htmlpages-func-display-pid-55. html Forgot to give the link for the instructions on installing Tomcat in Eclipse with the WTP plugin: http://www.eclipse.org/webtools/jst/components/ws/1.0/tutorials/InstallTomcat/InstallTomcat.html ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325830 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Help
Mark, What DBMS are you using? If its SQL Server, I don't think what you want to do is possible other than how you have already done it. If you find another way to do it (with a join) I would also be interested to see that. Kevin Roche ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325659 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Help
Mark, You might be right but I never got that to work myself, in MSSQL. An experiment you might try is to do that subquery separately in a different CFQUERY then plug in the retrieved value. Occasionally I have found that knid of trick is quicker. Kevin On Tue, Aug 25, 2009 at 11:49 AM, Mark Henderson shadefro...@gmail.comwrote: Kevin Roche wrote: Mark, What DBMS are you using? If its SQL Server, I don't think what you want to do is possible other than how you have already done it. If you find another way to do it (with a join) I would also be interested to see that. Kevin Roche Hi Kevin, Yes it's MS SQL. Are you sure I can't do a left join and use IS NULL for the record that isn't allowed to match? If someone can tell me that the subquery is only run once then I'm not too perturbed and will leave it as is. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325662 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion 8 Installation Problems
Try a reboot after the fail, then go back to the page that failed. Worked for me on Monday. Kevin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325581 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Centering text written on an image
I think you have to figure out the offset, and start from there. So, you'll need to determine the approximate width in pixels of your text string, But the quetion is how? How can I find the width of the string? I tried making a table of widths and that does not work really. For example with the strings AWA and HWH with Arial font the A is wider than H the kerning means that HWH is wider. ~| 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:311553 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Centering text written on an image
Is there a way to add an extra step or two and make an image of just your text, determine that width which gives you your string width I have no Idea how to do that. Can you tell me how to find the width of the text? ~| 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:311558 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Centering text written on an image
What I'm thinking is trying to avoid determining the text width by creating an image of just the text and measuring that. Yes but how? When you create an image in ColdFusion you have to give it a width and a height. If you don't you get an error when you try and use it: The image on which the operation was executed is undefined. An image must have some non-zero positive dimensions for image operations to be applicable. ~| 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:311567 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Centering text written on an image
Hi, I want to add some text to an image but have it centered rather than left justified. Does anyone know how to do that? Kevin Roche ~| 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:311408 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Centering text written on an image
I am using ColdFusion to write some text on an image and I don't know in advance what the string is going to be so I can't guess where to start writing it. Is there a way to say write this text around a particular point? I can check from the image how wide it is and work out where the centre is but I can't see how to either tell the ImageDrawText() function to center it or work out how wide the text will be once its written. Kevin Roche ~| 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:311413 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfchart and pdf
I have just tried the example from the cf documentation to create a chart and embed it in a pdf. It does not work. The two typos in the documentation kind of indicate that it was never tested. Has anyone ever got flash charts in a pdf to work? The example just produces a blank page. Here is the corrected code: cfdocument format=pdf !--- Flash chart embedded here. --- cfchart format=flash xaxistitle=Department yaxistitle=Salary Average cfchartseries type=bar query=DataTable itemcolumn=Dept_Name valuecolumn=avgSal cfchartdata item=Facilities value=35000 /cfchartseries /cfchart /cfdocument ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305681 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfchart and pdf
I am using CF8 and Yes, it certainly looks like the docs may be wrong. Ahamad Patan wrote: Currently, format=flash is not supported for cfcharts inside cfdocument. Paul Hastings wrote: the docs don't say that: ColdFusion 8: * Added support for embedding Flash charts within the cfdocument tag. in the cfchart tag docs. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305730 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion slow database connection to SQL2005
Thanks guys I will check both those suggestions. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297101 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 slow database connection to SQL2005
I have checked and the settings are exactly the same on live, and test servers. Maintain connections across client requests. is checked Enable Unicode for data sources configured for non-Latin characters. is unchecked All the other parameters under the advanced tab are the same. In fact they have not been changed from the defaults. Anyone have any other ideas? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion slow database connection to SQL2005
Well I have just replaced the JDBC Drivers with the latest version 3.5. This has reduced the time taken by a huge amount. There is no mention in the docs of there being anything that would do that. The same change on the test server made no difference. Kevin ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297152 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ColdFusion slow database connection to SQL2005
The envionment is CF7.0.2 and SQL Server 2005. It appears that queries are taking longer than usual to complete. Even simple queries can take over a second to execute. The test server has no problem executing the same query in 100ms. I supect there is some configuration issue which means that the database connections are dropped after each query, but I am not sure what is going on. The fact that it all works perfectly in test and the same code ran without any problem on CF5 and CF6.1 makes me sure there is somthing off with the configuration but I can't find it and the DBA isn't able to see any problem on the SQL Server either. We are using SQL Authentication rather than NT Authentication. Anyone out there seen somthing like this? Kevin Roche ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297077 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Slow Queries on CF7
I just upgraded one of my customers from CF5 to CF7. The site works but the queries are very slow. I have a test machine here in the office and the queries take 30ms or so there but on the staging machine and production machine the responce to the same query is 600ms. The only difference is that the test machine is using Win 2000 and the staging and production machines are using Win 2003. All are using MS SQLServer 2005. I have tried running the query concerned on the production Database with SQL Management Studio and that happens very quickly. There is another symptom. That is that some queries fail with a message saying that there are too many connections to the SQL Server. It is as if the number of connections is being limited by somthing. We are not using the Express version of SQL Server so I am at a loss. Its almost as if ColdFusion connection pooling is not working and its creating anew connection every time rather than reusing an exsiting datbase connection. I am considering upgrading the DataDirect JDBC Drivers but that is just a stab in the dark. Anyone else know any reason why this would happen? ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294581 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdSpring Error
Brian, I solved it. I was just looking in the wrong place. It wasn't ColdSpring at all. I had an invalid line of code and ColdSpring was catching the error and misleading me as to its location. Kevin ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289794 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdSpring Error
Brian, I solved it. I was just looking in the wrong place. It wasn't ColdSpring at all. I had an invalid line of code and ColdSpring was catching the error and misleading me as to its location. Kevin ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289795 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ColdSpring Error
I am getting an error in my ColdSpring Application. Cannot assign a value to a function.:Unable to assign a value to the function DailyMessage.setActive on line 156, column 24 setActive takes a boolean and that is the only thing I can see that is different about it. The CS file bean id=DailyMessageService class=ScaffoldTest.model.mFuseForum.DailyMessageService constructor-arg name=DailyMessageDAO ref bean=DailyMessageDAO / /constructor-arg constructor-arg name=DailyMessageGateway ref bean=DailyMessageGateway / /constructor-arg constructor-arg name=DailyMessageRecord ref bean=DailyMessageRecord / /constructor-arg constructor-arg name=DailyMessageTo ref bean=DailyMessageTo / /constructor-arg /bean bean id=DailyMessageDAO class=ScaffoldTest.model.mFuseForum.DailyMessageDAO constructor-arg name=dsn valueFuseForum/value /constructor-arg /bean bean id=DailyMessageGateway class=ScaffoldTest.model.mFuseForum.DailyMessageGateway constructor-arg name=dsn valueFuseForum/value /constructor-arg /bean bean id=DailyMessageRecord class=ScaffoldTest.model.mFuseForum.DailyMessageRecord constructor-arg name=dailyMessageIdvalue0/value/constructor-arg constructor-arg name=siteIdvalue0/value/constructor-arg constructor-arg name=titlevalue/value/constructor-arg constructor-arg name=messagevalue/value/constructor-arg constructor-arg name=postDatevalue0/value/constructor-arg constructor-arg name=expiryDatevalue0/value/constructor-arg constructor-arg name=activevalue0/value/constructor-arg constructor-arg name=createDatevalue0/value/constructor-arg constructor-arg name=createdByvalue0/value/constructor-arg constructor-arg name=updateDatevalue0/value/constructor-arg constructor-arg name=updatedByvalue0/value/constructor-arg constructor-arg name=Site class=ScaffoldTest.model.mFuseForum.SiteDAO ref bean=SiteDAO / /constructor-arg /bean bean id=DailyMessageTo class=ScaffoldTest.model.mFuseForum.DailyMessageTo constructor-arg name=dailyMessageIdvalue0/value/constructor-arg constructor-arg name=siteIdvalue0/value/constructor-arg constructor-arg name=titlevalue/value/constructor-arg constructor-arg name=messagevalue/value/constructor-arg constructor-arg name=postDatevalue0/value/constructor-arg constructor-arg name=expiryDatevalue0/value/constructor-arg constructor-arg name=activevalue0/value/constructor-arg constructor-arg name=createDatevalue0/value/constructor-arg constructor-arg name=createdByvalue0/value/constructor-arg constructor-arg name=updateDatevalue0/value/constructor-arg constructor-arg name=updatedByvalue0/value/constructor-arg /bean Kevin Roche ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289738 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Installing a JDBC driver for Firebird
Dave Watts wrote: Have you restarted CF? Yes Dave I did the CF restart, I am guessing that there is somthing incompatible in the set up here: I am using Firebird 1.5.4 and have tried the Jaybird JDBC drivers marked JayBird-2.0.1JDK_1.5.zip. Kevin ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283526 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Installing a JDBC driver for Firebird
Finaly got it going after much head scratching. The instruction I had read said set the Driver Class to: org.firebirdsql.jdbc.FBDriver; and what it actually needed to be was: org.firebirdsql.jdbc.FBDriver (no semicolon!) Now its working. Kevin ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283528 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Installing a JDBC driver for Firebird
Can anyone give me some pointers on how to do this? I have copied the following files into the \CFusionMX\wwwroot\WEB-INF\lib\ folder: jaybird-full-2.0.2.jar jaybird-pool-2.0.1.jar libjaybird2.so jaybird2.dll jaybird-2.0.1.jar jaybird-2.0.1.rar There is a directory in the distribution called lib should that go in lib too? I tried that but just got the following error: An exception occurred when executing method verifydatasource. The cause of this exception was that: coldfusion.sql.Executive$ConnectionVerificationFailedException: java.sql.SQLException: No suitable driver available for TallGirls, please check the driver setting in resources file, error: org/firebirdsql/jdbc/FBDriver;. The jdbc connection string is: jdbc:firebirdsql://localhost:3050/D:/FirebirdData/TallGirls.fdb Is that written correctly? This is on a windows XP machine. Kevin ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283479 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Project Time Tracking Software?
Take a look at Proworkflow http://www.proworkflow.com/. I have used that very sucessfully in the past. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278845 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Microsoft Runtime Components required for CF5
Dave Watts, CTO, Fig Leaf Software wrote: http://support.microsoft.com/kb/259403 Thanks Dave, I had in fact already tried to install this but the install would not run. The Page you pointed to did have a list of DLLs and looking though the list I found one was missing so copied that (MSVCP60.DLL) to the new machine from the old one and the install woked fine. CF5 is now running. Thanks Dave I'll get you a drink at the Flex conference. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277603 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Microsoft Runtime Components required for CF5
My CF5 development machine has died and I need to re-install it, so that I can make an update for a client. The CF installation routine want somthing called Microsoft Runtime which is not present on the machine. Anyone know where I can get the required installation? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277416 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Microsoft Runtime Components required for CF5
You will not doubt be after the Microsoft Visual C++ Run Time Library (debugging components). Which OS are you on? It is usually on the OS CD - such as NT4. Windows 2000 server - Can't see it on the CD. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277433 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
pwimageproc
Hi, Does anyone know where I can get a copy of the pwimageproc custom tag? Kevin Roche Objective Internet Limited ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263938 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cool thing about CFC's
Teddy, I am part way through writing somthing like this. Want to share? Kevin -Original Message- From: Teddy Payne [mailto:[EMAIL PROTECTED] Sent: 13 December 2006 15:14 To: CF-Talk Subject: Re: Cool thing about CFC's I have been contemplating how to create one of these for a while. I have seen several MVC frameworks (MG,MII,CFoW) implement this before. I mean ideally you want to request a view that is based upon a master template that has includes. MG has a view collection and I think Fusebox adapted soemthing similar, but really on a smaller scale, what do you need? You really just need a way to include all of the portions of a master template or view and then dynamically bring them together in the correct order. I have been deciphering the design pattern for this in my off time. Teddy On 12/13/06, Peterson, Chris [EMAIL PROTECTED] wrote: As a side note, having a render method invoke itself with the same default variables does not send Coldfusion into the tailspin of a recursive loop I thought it would, they must have some sanity check on that. But it sure did tick off firefox when it sent back TONs of html! =) Chris -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 13, 2006 9:40 AM To: CF-Talk Subject: Re: Cool thing about CFC's FYI, render is a reserved word in BlueDragon. I ran into that when working w/ BlogCFC. On 12/13/06, Peterson, Chris [EMAIL PROTECTED] wrote: I was writing a render() function to return html, and I wanted an easy way to separate div content so that I can use xmlHTTP to refresh an individual div after doing an action with my data. So, I can invoke render() with its default config, then INSIDE of the render() function, I can invoke itself with a different argument! -- === Raymond Camden Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com AOL IM : cfjedimaster Video game player? Have kids? Check out KidGamers.org ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263939 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Whats wrong with this bit of code?
perhaps there are spaces in one or other of the fields? -Original Message- From: Peter Tanswell [mailto:[EMAIL PROTECTED] Sent: 11 December 2006 02:49 To: CF-Talk Subject: Whats wrong with this bit of code? I have been trying to figure out why the value that is in both tables is not being shown as the one that is being initally displayed. The select box is still working but there is current;y no value displayed as the selected value. Any ideas on this one. Thanks in advance !--- Request Impact Area List --- select name=impact_area cfoutput query=getImpactAreas option value=#key_code# cfif getImpactAreas.key_code IS getchangerequests.impactareaselected/cfif#key_desc#/option /cfoutput /select ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263532 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF5, Win2003 and SQL2005
Hi, One of my customers wante to move an old web site written using CF5 and SQL2000 running on Win 2000 to a new server running SQL 2005 and Win 2003. What problems are likely if any? Kevin Roche ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256631 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF5, Win2003 and SQL2005
Teddy, Have you noticed any particular issues with moving from SQL2000 to SQL2005? Kevin -Original Message- From: Teddy Payne [mailto:[EMAIL PROTECTED] Sent: 13 October 2006 14:00 To: CF-Talk Subject: Re: CF5, Win2003 and SQL2005 Kevin, I suspect most of the issues that will occur will be the differences in the databases. Teddy On 10/13/06, Kevin Roche [EMAIL PROTECTED] wrote: Hi, One of my customers wante to move an old web site written using CF5 and SQL2000 running on Win 2000 to a new server running SQL 2005 and Win 2003. What problems are likely if any? Kevin Roche ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256655 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF5, Win2003 and SQL2005
By the way is there a suitable ODBC driver fron CF to SQL 2005? Will the standard SQL 2000 driver work? Kevin -Original Message- From: Kevin Roche [mailto:[EMAIL PROTECTED] Sent: 13 October 2006 15:01 To: CF-Talk Subject: RE: CF5, Win2003 and SQL2005 Teddy, Have you noticed any particular issues with moving from SQL2000 to SQL2005? Kevin -Original Message- From: Teddy Payne [mailto:[EMAIL PROTECTED] Sent: 13 October 2006 14:00 To: CF-Talk Subject: Re: CF5, Win2003 and SQL2005 Kevin, I suspect most of the issues that will occur will be the differences in the databases. Teddy On 10/13/06, Kevin Roche [EMAIL PROTECTED] wrote: Hi, One of my customers wante to move an old web site written using CF5 and SQL2000 running on Win 2000 to a new server running SQL 2005 and Win 2003. What problems are likely if any? Kevin Roche ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256661 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF5, Win2003 and SQL2005
Teddy, Thank you for that. I am a lot less concerned about it now. Kevin -Original Message- From: Teddy Payne [mailto:[EMAIL PROTECTED] Sent: 13 October 2006 15:24 To: CF-Talk Subject: Re: CF5, Win2003 and SQL2005 I have used the SQl Server 2000 driver just fine with 2005, but Microsoft does have an updated Type 4 Driver: http://msdn.microsoft.com/data/ref/jdbc/ I have not deployed the Type 4 yet. Teddy On 10/13/06, Kevin Roche [EMAIL PROTECTED] wrote: By the way is there a suitable ODBC driver fron CF to SQL 2005? Will the standard SQL 2000 driver work? Kevin -Original Message- From: Kevin Roche [mailto:[EMAIL PROTECTED] Sent: 13 October 2006 15:01 To: CF-Talk Subject: RE: CF5, Win2003 and SQL2005 Teddy, Have you noticed any particular issues with moving from SQL2000 to SQL2005? Kevin -Original Message- From: Teddy Payne [mailto:[EMAIL PROTECTED] Sent: 13 October 2006 14:00 To: CF-Talk Subject: Re: CF5, Win2003 and SQL2005 Kevin, I suspect most of the issues that will occur will be the differences in the databases. Teddy On 10/13/06, Kevin Roche [EMAIL PROTECTED] wrote: Hi, One of my customers wante to move an old web site written using CF5 and SQL2000 running on Win 2000 to a new server running SQL 2005 and Win 2003. What problems are likely if any? Kevin Roche ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256675 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SES URL Problem
Thanks, will check it out -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: 26 September 2006 14:04 To: CF-Talk Subject: RE: SES URL Problem It might be the URLscan which is installed with IISLOCKDOWN Check the filters http://www.microsoft.com/technet/security/tools/urlscan.mspx Russ -Original Message- From: Kevin Roche [mailto:[EMAIL PROTECTED] Sent: 26 September 2006 13:47 To: CF-Talk Subject: OT: SES URL Problem Hi, Sorry for the Off Topic Post but I have a problem with a CF5 application that uses Search Safe URLs. It has been working for several years without any problem on two IIS 5.0 Servers on Win2K. Just copied it to a new IIS 5.0 Win2K server and the SES URLs don't always work. It seems that if I have a URL which ends with a variable with a . in it it fails. Eg: http://mydomain.com/index.cfm/fuseaction/for.today/1 works But: http://mydomain.com/index.cfm/fuseaction/for.today fails And: http://mydomain.com/index.cfm/fuseaction/Home.Home fails But: http://mydomain.com/index.cfm/fuseaction/Home.Home/x works There are no signs of a URL rewriter, installed and the Check that file exsits checkbox is not ticked in the .cfm configuration. The main difference is that the new server has .NET 2 installed. Could that be a problem? Anyone have any idea what might cause this? Kevin Roche -- User Group Manager Thames Valley ColdFusion User Group -- ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254234 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: SES URL Problem
Hi, Sorry for the Off Topic Post but I have a problem with a CF5 application that uses Search Safe URLs. It has been working for several years without any problem on two IIS 5.0 Servers on Win2K. Just copied it to a new IIS 5.0 Win2K server and the SES URLs don't always work. It seems that if I have a URL which ends with a variable with a . in it it fails. Eg: http://mydomain.com/index.cfm/fuseaction/for.today/1 works But: http://mydomain.com/index.cfm/fuseaction/for.today fails And: http://mydomain.com/index.cfm/fuseaction/Home.Home fails But: http://mydomain.com/index.cfm/fuseaction/Home.Home/x works There are no signs of a URL rewriter, installed and the Check that file exsits checkbox is not ticked in the .cfm configuration. The main difference is that the new server has .NET 2 installed. Could that be a problem? Anyone have any idea what might cause this? Kevin Roche -- User Group Manager Thames Valley ColdFusion User Group -- ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254209 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Getting started with Railo
Hi, I am just getting started with railo and have installed railix live. Can't see any documentation anyone out there using it? I have added some cfm files to the siote and they are being served OK by the built in server but images are not being served is there some mapping I need to change to serve the imagages? Kevin Roche -- User Group Manager Thames Valley ColdFusion User Group Come along to TVCFUG on 12 September to hear Ben Forta of Adobe talk on ColdFusion Powered Flex. http://www.ukcfug.org -- ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251637 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Getting today's orders?
The problem here is that you are creating a datetime, which contains the time and comparing with a date. You need to use a greater than comparison. try this: WHERE orderdate = cfqueryparam cfsqltype=cf_sql_timestamp value=#CreateODBCDate(Now())# Kevin -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: 21 August 2006 22:50 To: CF-Talk Subject: Getting today's orders? I need to get today's orders in a query. I know there's one test order in the db today, but I can't get my query to return anything. It's SQL Server, smalldatetime field. Here's the data in the db: 8/13/2006 6:04:00 PM What do I do to make this work? cffunction name=getTodayOrders access=public returntype=query output=false hint=Returns a query of today's orders cfset var gettodayorders = cfquery name=gettodayorders datasource=#VARIABLES.dsn# SELECT orderID, orderdate, ordersubtotal, ordertotal, cartID, paymentstatusID, paypalpaymenttypeID, shiptotal FROM tblOrders WHERE orderdate = cfqueryparam cfsqltype=cf_sql_timestamp value=#CreateODBCDateTime(Now())# ORDER BY orderdate DESC /cfquery cfreturn gettodayorders /cffunction Thanks, Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250523 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 Queries - showing all entries from DB1
Roberto, I would suggest a similar series of steps but the link gives a rather complex example since they are trying to write a generic version that works out foir itself waht the queries are. If you do it yourself it may be easier to understand, and it may be possible to make it perform better. I think its just a matter of: 1/ Do an Inner Join with QonQ 2/ Do a QonQ query on the left hand table that creates an exact similar result set with null entries for any right table fields and omits any rows from the first query. 3/ Do a QonQ which does a UNION of the the first two. You may have problems with this if the results of 1 are large and can't be converted quickly into a list. Kevin -Original Message- From: Roberto Perez [mailto:[EMAIL PROTECTED] Sent: 18 August 2006 12:58 To: CF-Talk Subject: RE: Query of Queries - showing all entries from DB1 At 07:30 AM 8/18/2006, you wrote: I think with a query of queries, you can do a left outer join using *= syntax: SELECT * FROM table1, table2 WHERE table1.id *= table2.fkey I AM NOT SURE OF THIS. But I think I read it somewhere. Thanks for the input. I tried it, but CFMX did not like the syntax (I'm using Access, if that makes a difference). I found a link to a fake left outer join script at http://instantbadger.blogspot.com/2006/07/faking-left-outer-join-in-query-of ..html A left outer join sound just like what I need to do. Is there an easier way to do it (easier than what is described in the link above)? Thanks in advance, Roberto Perez [EMAIL PROTECTED] ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250287 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Project Management Software
Proworkflow in CF -Original Message- From: Neil Middleton [mailto:[EMAIL PROTECTED] Sent: 17 August 2006 16:01 To: CF-Talk Subject: Re: Project Management Software MS Project? On 8/17/06, Chad McCue [EMAIL PROTECTED] wrote: Does anyone currently use a windows based software program that tracks the life a project and can also handle daily time sheets for employees so an administrator can track what each employee does all day. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250157 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Extra newline when uploading file using cfhttpparam
Can you post your code? Often this kind of thing can be fixed by moving the tags around on the page: Eg cfsavecontent My content /cfsavecontent is changed to: cfsavecontentMy content/cfsavecontent Kevin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 17 August 2006 13:41 To: CF-Talk Subject: Extra newline when uploading file using cfhttpparam I have developed a web page that will post a multipart form with a file to another server using a cfhttpparam type=File tag inside a cfhttp tag. By the time the file has been uploaded to the other server it has an additional CR-LF pair of characters. This is being done regardless of the type of file or the mimeType attribute set for the cfhttpparam tag. If I access a page on the second server outside of ColdFusion and post the same file from my browser it makes it to the server without the additional characters. Has anyone else seen this behavior or have any idea how to get around it? I am using ColdFusionMX server version 6.1. Thanks Raymond Zeigler ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250159 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: multiple email addresses in cfmail TO attribute.
comma -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: 17 August 2006 19:46 To: CF-Talk Subject: multiple email addresses in cfmail TO attribute. I've never gotten a straight answer on how you can send one email to multiple recipients. cfmail from=#SiteOwnerEMail# to=[EMAIL PROTECTED] type=html subject=New Order Submitted Do I separate the emails with a comma or with a semicolon? Something else? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250207 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF5 on windows 2003
One of my customers wanys to run CF5 on windows 2003. Anyone know what exactly is meant by the statement on the Adsobe website: ColdFusion Application Management components are not supported on this platform. Kevin Roche Technical Director Objective Internet Ltd ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249425 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Arrays
Susan, A two dimensional array in CF is actually an array of arrays. Each of the arrays can end up being a differnt size. I think that may be your problem. Kevin Roche CF User Group Manager Thames Valley UK -Original Message- From: Susan McNab [mailto:[EMAIL PROTECTED] Sent: 07 August 2006 03:19 To: CF-Talk Subject: CF Arrays I was getting an error that appeared to be randomly occurring in one of my sites: The element at position [n] cannot be found Eventually I traced it to the fact that I had been using ArrayLen to set the number of iterations for a loop when the array size had been expanding. The code was therefore trying to reference empty array elements and causing the error. I knew that CF arrays are dynamic and that they can therefore sometimes expand beyond the minimum number of elements needed. I thought I had been careful about that though. I realise now that I need to know more about the internal mechanics of CF arrays.. What tripped me up was that the array was expanding because an IF statement referred to an outer dimensional array element that was greater than the original array size. The same thing happens with cfoutput and possibly other actions that you would expect to generate an error, but not to change the bounds of the array. This does not happen with one dimensional arrays, or the inner dimensions of 2D arrays. With both single and multidimensional arrays an error is generated when you first make an out of bounds reference to the array. That is what you want, but why should expanded array elements then persist in memory in the case of multidimensional arrays? Why should CF need to create extra elements for this? It was pretty easy to find a way to cope with the problem in my application, but I wondered wether this behaviour is correct, and why it has to be this way. In my case I had been using some multidimensional arrays in application scope so there was a risk of expanded array sizes eventually affecting performance. Does any one know what's going on under the hood here? The code below shows illustrates the effect simply: cfset application.a2DArray = ArrayNew(2) cfset application.a2DArray[1][1] = data11 cfset application.a2DArray[1][2] = data12 cfset application.a2DArray[2][1] = data21 cfset application.a2DArray[2][2] = data22 !--- Dump array with 2 x 2 elements --- cfdump label=application.a2DArray var=#application.a2DArray# cftry cfif application.a2DArray[4][2] eq somethingYou would expect this to generate an error but not to change the array size/cfif cfcatch type=Any cfoutput#cfcatch.message#/cfoutput /cfcatch /cftry !--- Array now has with 2 x 2 two elements plus 2 new empty elements --- cfdump label=application.a2DArray var=#application.a2DArray# ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248988 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CRUD
Chad, Do you want to do the model or the complete maintenance program? The model is best covered by Reactor which you can get from http://www.doughughes.net/index.cfm?filter=categorycategoryId=30 If you want to create a complete maintenance system the best choice is the Model-Glue framework which has scaffolding that generates a complete maintenance program. Kevin -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: 06 August 2006 15:47 To: CF-Talk Subject: CRUD Let me first start off I am not an OO kind of guy. I like things linear and easy to read. That is why I like CF. I have a few database tables that have hundreds of fields. Making forms and action pages to edit, insert and update the data into the tables is cumbersome and tedious. What tools are available to me to basically attach a database query to pages that edit, update and delete data? Do I have to get into an entire framework? Or are there a few CFCs/Tags out there that only do CRUD? Thanks! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248945 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ok here we go again
Doug, In this situation you need to nest your cfoutput tags and use the group parameter. cfquery name=qCatsSubs datasource=xxx SELECT categories.cat_id, categories.category, sub_categories.sub_id, sub_categories.sub_category FROM categories INNER JOIN sub_categories ON cat_id = sub_cat_id /cfquery cfoutput query=qCatsSubs group=cat_id h1#category#/h1 cfoutput #sub_category#br /cfoutput /cfoutput -Original Message- From: Doug [mailto:[EMAIL PROTECTED] Sent: 06 August 2006 16:15 To: CF-Talk Subject: ok here we go again I am very sorry to keep bothering the list with my inexperience or forgetfullness. I now have my tables populated thanks to your help. [categories] cat_id PK category [sub_categories] sub_id sub_cat_id FK to cat_id sub_category I am trying to work my query so that it will come out with the each category listed only once and the associated sub_categories beneath them. I keep getting multiple listings of the same stuff over and over again. Someone said I would need another table, do I ? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248947 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CRUD
Chad, Reactor only creates CFCs that do the standard J2EE like CRUD model (DAO, Gateway, Active Record), which you can call from your own display and edit pages, Model-Glue (version 2.0 of which incoporates reactor) will also create display and edit pages for you. Kevin -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: 06 August 2006 16:23 To: CF-Talk Subject: RE: CRUD Im not quite sure what you mean, model or maintenance. I will read up on the below links! Thanks for the suggestions. -Original Message- From: Kevin Roche [mailto:[EMAIL PROTECTED] Sent: Sunday, August 06, 2006 11:15 AM To: CF-Talk Subject: RE: CRUD Chad, Do you want to do the model or the complete maintenance program? The model is best covered by Reactor which you can get from http://www.doughughes.net/index.cfm?filter=categorycategoryId=30 If you want to create a complete maintenance system the best choice is the Model-Glue framework which has scaffolding that generates a complete maintenance program. Kevin -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: 06 August 2006 15:47 To: CF-Talk Subject: CRUD Let me first start off I am not an OO kind of guy. I like things linear and easy to read. That is why I like CF. I have a few database tables that have hundreds of fields. Making forms and action pages to edit, insert and update the data into the tables is cumbersome and tedious. What tools are available to me to basically attach a database query to pages that edit, update and delete data? Do I have to get into an entire framework? Or are there a few CFCs/Tags out there that only do CRUD? Thanks! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248950 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: problem with insert
Doug, The order of the entries of fieldnames and values has to be the same. So if you write: INSERT INTO sub_categories (sub_category,cat_id ) The second value must be an integer. Kevin -Original Message- From: Doug [mailto:[EMAIL PROTECTED] Sent: 05 August 2006 20:52 To: CF-Talk Subject: Re: problem with insert ok I did this !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN cfset mylist=Advertising,tools cfloop list=#mylist# index=listItem cfquery datasource=classifieds INSERT INTO sub_categories (sub_category,cat_id ) VALUES (cfqueryparam value=#myList#,cfqueryparam value=#listItem#) /cfquery /cfloop and I got this ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the varchar value 'Advertising' to a column of data type int. The sub_category field is a data type of varchar, not sure why it wants to convert it in the first place. - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Saturday, August 05, 2006 9:14 AM Subject: Re: problem with insert Doug wrote: I have two tables categories: (This table is populated with the categories already) [id] pri key category sub_categories (This table is empty) [id] pri key cat_id FK to categories.id sub_category I want to insert a comma delimeted list into the sub_categories table. cfloop list=#myList# index=listItem cfquery ... INSERT INTO sub_categories (cat_id, sub_category) VALUES ( cfqueryparam value=#something#, cfqueryparam value=#listItem# ) /cfquery /cfloop Jochem ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248891 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OOD/Design Patterns and ColdFusion.
The most useful thing I found on Design Patterns was an article on them in CFDJ about 2 years ago. After that all the books started to make sense. They had some code examples for DAO, Gateway, Beans and other objects that were all new to me at that time. seeing the code in CF was great. Now lots of people are writing code like that. Check out the new flex2 Beta3 to which you can add the CF and Actionscript wizards which create DAO and Bean objects from a database using RDS. Read that code as a starting point. Then read the books. The objects create are simple, but it saves a lot of typing. Kevin Roche ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240737 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: setting up standard cf 7 server on Win XP / IIS 5.1
Paul, I have installed CFMX 6.1 and 7 countless times. Sometimes the IIS configuration just doesn't work with the install program. This seems to happen when the Microsoft Techies have hardened the machine in some way. The only solution in these cases is a manual install which takes a couple of hours!! The instructions are on the macromedia site. One thing that is well hidden in the instructions is the make it not work switch which is on by deafult and has to be turned off. Look for the line attribute name=deactivatedtrue/attribute and change it to attribute name=deactivatedfalse/attribute in jrun.xml See Tech Notes 19575, 18724. (sorry can't post links as my favs all screwed since the move to adobe last week) Kevin -- Original Message -- From: Paul Ihrig [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Sat, 13 May 2006 13:32:31 -0400 sure. let me know if you need more tried to instal Coldfusion MX 7 Developer Edition, from wack 7 book disk 2 of mx studio 7. also tried to instal cf 6.1 mx.. no luck. i have unblocked ports, 51010, 51011, 51020, 80, 8080, 8500 but it dosnt seem to add cfm, cfc, cfml et to iis. so i am going to try it with IIS 6 instead of standard IIS 5.1 that comes with xp... my default root is E:\Inetpub\wwwroot instead of C:\ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240484 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: 3rd Party Cookie Reading [try to explain again]
Joe, Can you put an image on the other site? (Site A) If so what you do is this on site A img src='http://www.siteB.com/mysite/my_cookie_setting.cfm/sitea.gif' So the image displayed on site A is really coming from site B and setting a site B cookie at that point. This is what adverisers do all the time. Now when the user eventually vists site B you know they have been to site A. The image itself is created by your CF so it sets the cookie too. If you want you could also pass parameters and save them in your database. The image can be a single pixel tranparent gif. Note that in the URL some browsers are confused so you should add the spurious extra bit on the end of tyhe URL and apply the Search Safe URL fix that is available from the Macromedia web site so that it still works in CF6 or CF7. Kevin Roche -Original Message- From: Joe Velez [mailto:[EMAIL PROTECTED] Sent: 25 April 2006 04:02 To: CF-Talk Subject: Re: 3rd Party Cookie Reading [try to explain again] =) Yea - I realize the security issues. And that's not the goal I was after, but thought if you knew the cookie name, you could read the cookie value. BUMMER! Thanks. - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, April 24, 2006 3:58 PM Subject: Re: 3rd Party Cookie Reading [try to explain again] No it's not possible AFAIKHUGE security issue if that was possible. Let's think it throughthe other site stores the user's password in plain text in a cookie for some stupid reasonnow you can read it...I think not ;-) HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238581 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: 3rd Party Cookie Reading
Joe, Browsers are designed to stop this. The only way around it is to do somthing that many advertisers do and that is use a graphic or image to transfer the info. Eg: On site A you add a link to to an image on site B. If you are using CF you can make the image a link to a CF template which returns the iumage and sets the cookie as a site B cookie. Kevin -- Original Message -- From: joe velez [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Sat, 22 Apr 2006 22:25:49 -0400 Hi - I would like to be able to have a script run using an embed tag or iframe, etc that can read cookies from another site. Lets say SITE_A sets a cookie test with value thevalue. From SITE_B I would like to read the cookie 'test' and know that the value is thevalue. How can this be accomplished? Can it? Thank you JV ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238504 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: adobe certification site
John, Hi how are you? I didn't see the email from integral7.com. Must be lost in my spam filter. Can you enlighten me I'd like to check. Kevin -- Original Message -- From: John Beynon [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Tue, 11 Apr 2006 20:34:02 +0100 I updated my Adobe certification profile the other week when the email arrived from integral7.com, has anyone else been demoted from an Advanced CF Developer to a CF Developer? It's there in the list but for some reason I've been demoted.. anyone else? john. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237496 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Creating Binary Files in CF
Hi, Does anyone know an easy way of creating a binary file in CF? I want tio create a file that will be used as input for another program which has its own format that I can't change. The begining of the file contains a number of binary elements. It would be good if there was a custom tag that allowed me to add binary stuff to the stream (in hex perhaps) and then add stringsand write the combined stream out using cfwrite Any ideas? Kevin ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236383 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Creating Binary Files in CF
Chris wrote: You might be able to use toBase64() and toBinary() to create a binary output Yes, I thought about that but could not get my head around how the create the Base64 stuff in the first place as it must cause all the byte boundries to overlap. What I really want is base 16 (Hex) so I can create a binary string from a Hex number. Kevin ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236385 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Reading gedcom files from cfmx7
I wrote somthing a few years ago that worked in CF 4 I will see if it will work in CF 7 Kevin -- Original Message -- From: Jerry Johnson [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Fri, 10 Mar 2006 20:14:13 -0500 Does anyone have any code they'd like to share that can read and display gedcom data using cfmx7? I can't stand the output of my family tree programs, and want to tailor something for myself. Thanks, Jerry Johnson ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235139 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Source Code Versioning with ColdFusion
I use CVS and find it works really well for us. We are using WinCVS 1.3 as the client and CVSNT on the server. Kevin I am researching source code versioning software for our team. We are 4 ColdFusion developers using Dreamweaver and SQL mainly for our development and currently do not use any code versioning software. What would you recommend for us or what are you using and how is that going? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234841 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
DevNet version of CF7
Hi, We have a machine that we use in development as a shared machine. It has been set up with the devnet version of CFMX7. It works fine except that it adds the line META NAME=ColdFusionMXEdition CONTENT=ColdFusion DevNet Edition - Not for Production Use. at the start of every page. This OK for HTML pages but now we are developing stuff in XHTML and XML and that stops IE or wahetever is at the other end interpreting the page correctly. Is there a way to turn it off? In CFMX 6.1 we added cfcontent reset=yes at the start of a page and that worked but in 7 it doesnt. Does this mean that I really have to pay for a full CFMX 7 Licence for my development machine in order to make it do the things I need with web services? I need multiple IP addresses so one can call another and so I can keep the various sites I support separate. Kevin Roche Objective Internet ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233742 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Cold Fusion Page Execution Times
Hi, I am investigating the execution times on one of my customer's web site. The site uses CF5 and has some complex pages. I was quite happy with the home page which was excuting in an average of 110 ms. However I was still getting some complaints from users about the time the home page took to respond. I built a simple tool with CF to measure the time from my desktop machine using cfhttp. This showed that the average time for the page to return was more like 1349 ms. I saved a copy of the home page on the server and called it index.htm so that it was delivered without any interaction from CF5. Now that page comes back in 556 ms. What is causing the big time difference? If the page takes 110ms to build and IIS takes 556ms to send it I was expecting a total of 666ms! Any ideas? Kevin Roche ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220792 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Benefits of Upgrading to MX6.1 or MX7
Dave, Thanks. Unfortunately, none of this seems to be a big benefit for the client, who pays the cost. They seem quite happy to pay for us to write the unstructured CF5 code. Kevin -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 10 October 2005 18:07 To: CF-Talk Subject: RE: Benefits of Upgrading to MX6.1 or MX7 One of my customers has asked me to give him some figures on the performance improvements that would be possible if they moved from the current CF5 site to CF6.1 or CF7 Unfortunately, you're unlikely to find any useful numbers for this, since performance differences are hugely dependent upon specific applications and environments. You may find a vast improvement with your customer's applications, or you may even find worse performance! In any case, performance alone is probably not the best reason to upgrade. There are many other, much better, reasons. The ability to write and use CFCs is one - being able to structure your code in a more useful manner, and being able to incorporate OO concepts within your code, may significantly decrease the amount of time you spend maintaining that code. 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! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220647 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Benefits of Upgrading to MX6.1 or MX7
Hi, One of my customers has asked me to give him some figures on the performance improvements that would be possible if they moved from the current CF5 site to CF6.1 or CF7 Does anyone have the official figures handy (or a URL for them)? They are also considering a rewrite of the site which was written several years ago in Fusebox 2. I know Fusebox 4 is much faster. Has anyone got some comparison figures on that too? Kevin ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220557 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: 6.1 Professional - 7.0 Professional
Dov, For me the main reason would be to make use of the background processing gateway and the forms validation help. Some clients are turned on by the SMS messaging feature but that depends on the client. It would be nice to be able to make use of the flash forms features but most clients don't see that as a business benefit. Kevin Roche -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: 10 October 2005 14:50 To: CF-Talk Subject: 6.1 Professional - 7.0 Professional Is there a good place other than the macromedia upgrade guide for determining what I'd benefit from in an upgrade scenario? What are the main improvements between mx6.1 pro and 7.0 pro? Thanks -dov NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220560 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dealing with empty fields in lists
Rick use: cfset myList = Replace(myList, ,) Then the two empty items are replaced by items with a single space. Use trim to remove it later. Kevin -- Original Message -- From: Rick Root [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Thu, 15 Sep 2005 15:09:49 -0400 In the real world, the following list has 5 items: apple,,banana,,orange Of course, in Coldfusion, it only has 3. What are you all doing to work around this kind of thing? Rick ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218479 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFC caching?
George, I have a short piece of code at the start of my application that does two things. 1/ Checks for a url variable and if present sets all the cacheds CFCs to a space. 2/ Checks each cached CFC to see that it is defined and not a space. If so it reinitialises it and puts it in the application or server scope. Hope that helps. Kevin Roche -- Original Message -- From: George Abraham [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Thu, 15 Sep 2005 10:22:52 -0400 Isaac, SQL Server 2K. I renamed the stored procedure name in the cffunction, not in the db. It is in the application scope, but how does one recreate it - simply set it to null? I did have to restart the CF server service to get rid of this finally. I guess I am really curious why there is no info on this anywhere. At least I can't find any. Seems to me that no one else has run into this while developing CFCs. I change my stored procs so many times, that using CFCs this way would have me restart the CF service every so often. I must be doing something fundamentally wrong somewhere. A related question: would you instantiate an object that does auditing in the application scope or in the session scope? Initially I thought that since auditing is individual for every user, it should be in the session scope, but then some examples seem to suggest that instantiating it in the application scope is fine. Thanks, George On 9/15/05, S. Isaac Dealey [EMAIL PROTECTED] wrote: What database? And how did you rename the procedure? I would say make sure you recreate the CFC object if it's stored in a shared scope (like say the application scope) but since the spelling was changed in the db and not in the CFC that shouldn't be relevant. Other than that, I'd say try restarting the CF server service. Umm, anybody? George On 9/14/05, George Abraham [EMAIL PROTECTED] wrote: All, I am relatively new to CFCs, so pardon the (perhaps) stupid question. I have a CFC like so: cfcomponent cffunction name=auditThis cfargument name=AccountID required=Yes cfargument name=TargetID required=Yes default=0 cfargument name=ActionString required=No default= cfstoredproc datasource=#request.appDSN# procedure=upIns_CreateNewAuditLogEntry cfprocparam cfsqltype=CF_SQL_BIGINT value=#arguments.AccountID# cfprocparam cfsqltype=CF_SQL_VARCHAR value=#arguments.TargetID# cfprocparam cfsqltype=CF_SQL_VARCHAR value=#arguments.ActionString# /cfstoredproc /cffunction /cfcomponent I made a simple mistake of misspelling the stored procedure and named it 'CreateNewAuditLogEntry'. Of course there was a spitting out of This SP name CreateNewAuditLogEntry is not available. I go back and change the name and add that prefix upIns_. However on running the routine, I get the error again that the This SP name CreateNewAuditLogEntry is not available. But, I changed the spelling and how come it is repeating the old error? Which leads me to believe that somewhere, something is being cached. Now I am also reminded of other CFCs that I inherited or worked with previously that gave me similar problems of retention of old settings. Oh mighty CF-Talkers, what have I encountered? Is there some setting that I have not set? CFMX7 on Windows 2000, by the way. TIA George s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218414 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Expiring time of cookies for session management
Dave, If you use: cfapplication setclientcookies=Yes The cookies themselves are permanent which has some consequences for most applications. I have in the past come back to an application and found myself still logged in after being away for a week! I now use: cfapplication setclientcookies=No And write the cookies myself. cfif NOT (isDefined(cookie.cfid) AND cookie.cfid IS session.cfid) cfcookie name=cfid value=#session.cfid# domain=#domain# cfcookie name=cftoken value=#session.cftoken# domain=#domain# /cfif That way you can easily set the tiemout period to anything you like. (above is browser session) Kevin On 9/12/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi, I'm trying to clarify the expiration time for the Cookie.CFID and Cookie.CFTOKEN cookies created when a new session starts. Is it the length of the time that is specified in the sessionmanagement attribute of the cfapplication tag? If so, is this documented anywhere? I did find some documentation (on livedocs) on how to make the cookies automatically expire when the browser is closed, but I need to know what is actually happening when those cookies are created by CF and I need some documentation to back it up if at all possible. Thanks, Dave -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218009 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF 6.1: Problem with COM Object
I have a page that uses a COM object in CF5 and tried to run it with CF6.1 but got the following when using cfobject An exception occurred when instantiating a Com object. The cause of this exception was that: java.lang.NullPointerException. The code being executed at that point is: cfobject type=COM action=CREATE class=HPW.ProxServer2 name=Prox I saw another thread here about this which said it may be somthing to do with having empty strings as parmaters but at this point I have't sent any parameters so ca't see why that is the case. Anyone got any ideas? Kevin ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217938 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
UK SMS providers for CF7
Hi, Can anyone recommend a UK SMS Bulk Agregator that supports the ColdFusion 7 SMS gateway? Kevin Roche Technical Director Objective Internet Ltd 01256 338 490 This message (including any attachments) contains information that may be confidential and/or privileged. It is intended only for the person(s) to whom it is addressed. - If you are not the intended recipient, please notify the sender by replying to this message with Received in error as the subject and then delete it from your mailbox. - If you are not the intended recipient, you are not authorized to read, print, retain, copy or disseminate this message or any part of it, and any unauthorized use may be illegal. The sender is not responsible for the accuracy or completeness of this message when it has been transmitted over a public network, as Internet communication is not secure. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211723 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Checking for JavaScript Enabled browser
Hi, I would like my CF to be aware that the user has Turned Off Javascript and react accordingly. I was thinking of using a JS function to set a cookie and having CF look for it but I guess that won't work beacuse the first time a user visits the cookie would not get sent to the server since the page that makes it has not yet executed. Does anyone out there have any clever ideas on this? I guess the other problem is that they may have cookies turned off too. Kevin Roche Objective Internet Ltd ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207331 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Client side include
Hi, A new site I am building has a really big left hand menu. we are using some DHTML code that builds a css based hierarchical menu. It looks good but takes 'ages' to download on every page. I was just thinking that it must be possible to download it once and include it on the client side rather than at the server end to save on the download. Anyone know how to do that? I already tried: object type=text/html data=include/menu.cfm a href=include/menu.cfm Menu /a /object .but the effect of doing it that way is that when the menu jumps out the box gets bigger and disrupts the page, instead of the menu overlapping the page elements. Does anyone know if this kind of thing can be done with writeContent() ? I can't see how myself but have a hunch that there might be some way to do that. Target browsers are IE and FireFox. Kevin Roche Technical Director Objective Internet Ltd 01256 338 490 This message (including any attachments) contains information that may be confidential and/or privileged. It is intended only for the person(s) to whom it is addressed. - If you are not the intended recipient, please notify the sender by replying to this message with Received in error as the subject and then delete it from your mailbox. - If you are not the intended recipient, you are not authorized to read, print, retain, copy or disseminate this message or any part of it, and any unauthorized use may be illegal. The sender is not responsible for the accuracy or completeness of this message when it has been transmitted over a public network, as Internet communication is not secure. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206497 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Client side include
Micha, Kerry, Thanks for your replys. I have no prblem with caching on the server. I would also like to cache the menu on the client. The performace hit that really worries me is that of downloading the menu with every page. Kerry said: I would avoid DHTML menus, and recursive menus that render the whole menu in one go. Unfortunarely that answer is not the solution as the client has this as a must have item! Apart from the download time CSS menu is working well so I don't need a solution for that, just for caching it in the browser. Beacuse of the page layout putting the menu and page in separate frames is not the solution. I was wondering if anyone here had ever tried using a single frame with javascript to write the output from two sources. That way I could possibly cache the menu on the browser and merge it with the rest of the page. Kevin -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: 12 May 2005 09:27 To: CF-Talk Subject: RE: Client side include Kerry, Could you also explain why? For Kevin, overlapping parts of the menu means you either must look at how to handle such things using scrollbars using CSS or markup, or adjust the menu to fit in the user interface. For the performance hit of the cfinclude, try looking at caching the output. Often there is no reason (besides personalized links, or information) to render navigation on each request. Render it once, reuse it many times afterwards. Caching in the application scope, of the output of the menu, offers you the ability to display that cached output to all visitors. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - -Original Message- From: Kerry [mailto:[EMAIL PROTECTED] Sent: donderdag 12 mei 2005 8:56 To: CF-Talk Subject: RE: Client side include Not the answer you want but, I would avoid DHTML menus, and recursive menus that render the whole menu in one go. -Original Message- From: Kevin Roche [mailto:[EMAIL PROTECTED] Sent: 12 May 2005 08:49 To: CF-Talk Subject: Client side include Hi, A new site I am building has a really big left hand menu. we are using some DHTML code that builds a css based hierarchical menu. It looks good but takes 'ages' to download on every page. I was just thinking that it must be possible to download it once and include it on the client side rather than at the server end to save on the download. Anyone know how to do that? I already tried: object type=text/html data=include/menu.cfm a href=include/menu.cfm Menu /a /object .but the effect of doing it that way is that when the menu jumps out the box gets bigger and disrupts the page, instead of the menu overlapping the page elements. Does anyone know if this kind of thing can be done with writeContent() ? I can't see how myself but have a hunch that there might be some way to do that. Target browsers are IE and FireFox. Kevin Roche Technical Director Objective Internet Ltd 01256 338 490 This message (including any attachments) contains information that may be confidential and/or privileged. It is intended only for the person(s) to whom it is addressed. - If you are not the intended recipient, please notify the sender by replying to this message with Received in error as the subject and then delete it from your mailbox. - If you are not the intended recipient, you are not authorized to read, print, retain, copy or disseminate this message or any part of it, and any unauthorized use may be illegal. The sender is not responsible for the accuracy or completeness of this message when it has been transmitted over a public network, as Internet communication is not secure. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206501 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http
RE: Client side include
Kerry, you wrote: I have a site that I was forced to use a DHTML menu on, and I have a .js file that writes out the menu. The .js file is cached on the client independently from the page, but there is still a small delay while the js does its thing client side... Can I look at the site to see how that performs? Do you mind if I take a look at the code for it? Kevin ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206504 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Client side include
Dave, Unfortunately not an option, because of DDA compliance and the way the menu works. Kevin -Original Message- From: Dave Merrill [mailto:[EMAIL PROTECTED] Sent: 12 May 2005 15:02 To: CF-Talk Subject: RE: Client side include Another idea I'm sure you've thought of is to put the menu in its own frame. That way it's not just cached, it doesn't even have to reload or render it. It does cause problems for bookmarks and section 508 compliance, but depending on the audience and use of the site, it may be worth considering. Dave Merrill ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206548 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Client side include
Pete, How do I Convert the HTML to JavaScript? Kevin -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: 12 May 2005 13:03 To: CF-Talk Subject: Re: Client side include Convert the HTML to JavaScript and use a linked .JS file. The browser will cache that. Pete ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206547 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Regular expression in Homesite
Hi, Is there a person out there who is able to write a regulart expression that I can use in Homesite+ to change a line that says: cfset var Insert = 0 / To one that says cfset var qInsert = 0 / can be any string Kevin Roche Objective Internet Ltd 01256 338 490 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203489 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Regular expression in Homesite
Thanks Jochem. Works well I was using cfset var [A-Za-z]*Insert which gave an error Kevin -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 19 April 2005 11:42 To: CF-Talk Subject: Re: Regular expression in Homesite Kevin Roche wrote: Is there a person out there who is able to write a regulart expression that I can use in Homesite+ to change a line that says: cfset var Insert = 0 / To one that says cfset var qInsert = 0 / can be any string Asuming does not contain any spaces replace cfset var ([^ ]+)Insert with cfset var qInsert\1 Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203497 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Copying Images with cfhttp
Hi, Has anyone tried to get an image from a remote server with CFHTTP? I have an appliaction that gets several files from a remote server using CFHTTP. The text files all appear to be fetched correctly byt the gif image gets distorted in the process. Anyone out there got any idea why? Here is the code cfloop index=i from=1 to=#arrayLen(aFiles)# cfif Right(aFiles[i],1) IS NOT / cfoutputGetting #aFiles[i]#br /br //cfoutput cfset filename=ListLast(aFiles[i],/\) cfhttp url=#aFiles[i]# method=GET resolveurl=true timeout=#httptimeout# throwonerror=Yes cffile action=WRITE file=#webroot##downloaddir##filename# output=#CFHTTP.FileContent# addnewline=No /cfif /cfloop Obviously this is a binary file and maybe cfhttp can't handle it. If so anyone know of a way to do it? Kevin Roche ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195378 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Copying Images with cfhttp
Dave, Thanks for that. One small problem though. I need to copy this file to all the servers in the cluster so really there are multiple cffile action=write after the get. I guess once I have the file I need to read it with cffile action=readBinary, there is no writeBinary so will cffile action=write work? Kevin -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 18 February 2005 16:06 To: CF-Talk Subject: RE: Copying Images with cfhttp Obviously this is a binary file and maybe cfhttp can't handle it. If so anyone know of a way to do it? Use the FILE attribute of CFHTTP to save binary files directly to your filesystem. 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! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195391 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Copying Images with cfhttp
Hi, cffile action=write works fine for Binary data. Kevin -Original Message- From: Kevin Roche [mailto:[EMAIL PROTECTED] Sent: 18 February 2005 16:33 To: CF-Talk Subject: RE: Copying Images with cfhttp Dave, Thanks for that. One small problem though. I need to copy this file to all the servers in the cluster so really there are multiple cffile action=write after the get. I guess once I have the file I need to read it with cffile action=readBinary, there is no writeBinary so will cffile action=write work? Kevin -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 18 February 2005 16:06 To: CF-Talk Subject: RE: Copying Images with cfhttp Obviously this is a binary file and maybe cfhttp can't handle it. If so anyone know of a way to do it? Use the FILE attribute of CFHTTP to save binary files directly to your filesystem. 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! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195415 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Virtual Directories for Websites...follow-up remarks
One thing that makes life interesting in this case is that the CF root and the Web root will be different. Kevin -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 18 February 2005 17:26 To: CF-Talk Subject: RE: Virtual Directories for Websites...follow-up remarks So, using ports like that would mean there would be no root directory for the websites? i.e., the port would act as the root for the site? I'm not sure I understand the actual directory structure for http://66.79.46.138:85/Index.cfm... No, you would still need to have separate virtual hosts for each site, and each virtual host would typically have its own root directory. Using different ports just lets you use the same IP address or DNS name to connect to different virtual servers. 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! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195415 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Copying Images with cfhttp
Dave, I wanted to control what is happening with CF but What tools would you suggest? Kevin -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 18 February 2005 17:36 To: CF-Talk Subject: RE: Copying Images with cfhttp One small problem though. I need to copy this file to all the servers in the cluster so really there are multiple cffile action=write after the get. I guess once I have the file I need to read it with cffile action=readBinary, there is no writeBinary so will cffile action=write work? It might. However, you might be better served by another approach. Why not fetch all the files you need to one cluster member, then copy all those files to the other cluster members, rather than copying each file as you fetch it? The advantage of this approach is that you could easily do that stuff outside of CF, using more efficient tools. 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! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195417 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Writing RSS
Hi, Does anyone out there have a tag or CF code for witing an RSS feed? There seems to be lots of people offering tags to read them but none that write them. Kevin ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193808 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Built in web server
Hi, I want to use the built in web server on my CFMX installation. Up until now I always used IIS but for various reasons I need to use the built in web server instead. Where do I put the cf files? Is there a way to set up server mappings? Is there any documentation I can read about it anywhere? Kevin Roche ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191762 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion 5 RDS Visual Source Safe
Hi, Is the RDS service running? I have a problem sometimes when I reboot that RDS does not start up as it should. Forcing a start from the Services Control Panel fixes it. I have no idea why, as it only happens very occasionally I have never taken the time to investigate. I suspect that it is somthing to do with running CF5 and CFMX on the same machine as it only happened after the CFMX install. Kevin -Original Message- From: Douglas Knudsen [mailto:[EMAIL PROTECTED] Sent: 26 January 2005 04:19 To: CF-Talk Subject: Re: ColdFusion 5 RDS Visual Source Safe have u tried setting an RDS password? Doug On Tue, 25 Jan 2005 18:36:25 -0400, Rob Sherman [EMAIL PROTECTED] wrote: As a follow up, it may have nothing to do with VSS.. RDS just doesn't work. My co-worker has ColdFusion Studio 5 and can't connect via RDS either and is prompted with the same error message Unable to Authenticate.. even though the ColdFusion 5 server is set to not require a password for RDS. This is a windows 2k server, does anyone have any suggestions that would relate to IIS to ensure RDS will work? - Rob We use this configuration regulary and it works fine for us so I reckon it must be your DWMX config. Does RDS work through the browser? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191764 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Sessions being show to wrong users?
Yes, but if two people follow the link withing a few minutes of each other the fisrtt one will start a new session using the provided CFID and CFTOKEN and the second will join it! Kevin -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: 26 January 2005 08:58 To: CF-Talk Subject: RE: Sessions being show to wrong users? Sessions expire within a certain amount of time, which in general is 20 minutes. So clicking through by using a cached google page should not trigger that session, since it's data has already expired. I would advice you to try enabling single threaded sessions in the CF Administrator. See if this helps solving your issues. If it does, you know the problem is in locking the variables. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - -Original Message- From: Ian Buzer [mailto:[EMAIL PROTECTED] Sent: woensdag 26 januari 2005 8:31 To: CF-Talk Subject: Re: Sessions being show to wrong users? I'd back up Martin's theory of it being search engines indexing the site with the CFID/CFTOKEN in the URL. If two people follow that link within the session time out they will share the session. I now only use CFID/CFTOKEN in the URL from behind a log in page, or after someone has added an item to the basket etc ... all things a search engine can't do. It's always occurred to me that this is a massive security hole in the way that ColdFusion manages sessions. Having said that, most application servers use a similar method of maintaining session when cookies are not enabled. Ian What is the URL that these people are coming in on ? Meaning, has Google cached one of your pages which has mypage.cfm?CFID=xxxcftoken=xxx in the URL. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191764 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Sessions being show to wrong users?
Hi, In the past I have seen the following acuse this problem: 1/ users who sent each other links to pages with CFID and CFTOKEN in the link. 2/ Search engine spiders site and picks up a CFID and CFTOKEN. 3/ Firewall caches the CFID and CFTOKEN (This was many years ago and I think most are fixed now) 4/ Missing CFLOCK Hope that helps Kevin -Original Message- From: Ian Buzer [mailto:[EMAIL PROTECTED] Sent: 26 January 2005 07:31 To: CF-Talk Subject: Re: Sessions being show to wrong users? I'd back up Martin's theory of it being search engines indexing the site with the CFID/CFTOKEN in the URL. If two people follow that link within the session time out they will share the session. I now only use CFID/CFTOKEN in the URL from behind a log in page, or after someone has added an item to the basket etc ... all things a search engine can't do. It's always occurred to me that this is a massive security hole in the way that ColdFusion manages sessions. Having said that, most application servers use a similar method of maintaining session when cookies are not enabled. Ian What is the URL that these people are coming in on ? Meaning, has Google cached one of your pages which has mypage.cfm?CFID=xxxcftoken=xxx in the URL. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191765 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Built in web server
Thanks, that looks like what I need. -Original Message- From: Ian Winter [mailto:[EMAIL PROTECTED] Sent: 26 January 2005 09:11 To: CF-Talk Subject: Re: Built in web server Have a read of this document, it should help answer some of your questions. http://www.macromedia.com/support/coldfusion/adv_development/config_builtin_ webserver/ On Wed, 26 Jan 2005 08:59:11 -, Kevin Roche [EMAIL PROTECTED] wrote: Hi, I want to use the built in web server on my CFMX installation. Up until now I always used IIS but for various reasons I need to use the built in web server instead. Where do I put the cf files? Is there a way to set up server mappings? Is there any documentation I can read about it anywhere? Kevin Roche ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191770 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Certification exam: Wait for Blackstone?
Hi, 1. It seems so from the insider information I saw. 2. Only for a limited period. I took the CF 5 Exam just before the CFMX release and got a 1 year validation. 3. Don't know of one 4. Wait - unless you have a really good reason for wanting it now. Kevin Roche On Thu, 06 Jan 2005 10:20:16 -0400, Stephen Lapointe [EMAIL PROTECTED] wrote: For those with some insider knowledge, some questions about CF certification and Blackstone: 1) Will the Blackstone certification exam become available at about the same time as the Blackstone product release? 2) If someone were to take the CF certification exam now (and pass), would the certification be carried forward to Blackstone? 3) If the answer to 2 is no, would there be some coupon/discount for the Blackstone exam if you've taken the current CF exam just a short period before the Blackstone exam is available? 4) Bottom line: Would you recommend taking the CF certification exam now, or wait until the Blackstone exam becomes available? Thanks for any input. ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189628 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Verity Installation Problem
Hi, I have recently installed CFMX 6.1 on a server that was locked down by the hosting company. The server already had CF5 running and I wanted to be able to run the two versions on the same box. The server was installe in JRun Mode and I have now set up a new virtual server that uses CFMX while the exsiting virtual server is running CF5 All seems Ok except the verity pages which says: You must configure your application server to enable Verity. For instructions, see Installing and Using ColdFusion MX. I read the manual and it says that verity must have a couple of lines added to the JRun parameters. I checked and they are already there. Anyone know what else I should be looking for ? -- Kevin Roche ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184588 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Verity Installation Problem
- Forwarded message from [EMAIL PROTECTED] - Date: Wed, 17 Nov 2004 16:02:46 + From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Subject: Not Subscribed: RE: Verity Installation Problem To: [EMAIL PROTECTED] You are not subscribed to the CF-Talk list with the address [EMAIL PROTECTED] To add this address to your profile, please visit the sign in page at http://www.houseoffusion.com/signin/ Return-Path: [EMAIL PROTECTED] Received: from nmail1.systems.pipex.net ([62.241.160.130]) by hof001.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID# 0-54969U100L100S0V35) with ESMTP id com for [EMAIL PROTECTED]; Wed, 17 Nov 2004 11:04:35 -0500 Received: from nmail1.systems.pipex.net (localhost [127.0.0.1]) by nmail1.systems.pipex.net (8.12.10/8.12.10) with ESMTP id iAHG2kre023121 for [EMAIL PROTECTED]; Wed, 17 Nov 2004 16:02:46 GMT Received: (from [EMAIL PROTECTED]) by nmail1.systems.pipex.net (8.12.10/8.12.10/Submit) id iAHG2kih023120 for [EMAIL PROTECTED]; Wed, 17 Nov 2004 16:02:46 GMT Neil, It is Windows, but I never needed to do that before. Any ideas why this is different? How do I do I make it a Windows Service? What if I don't want to do that? Kevin Quoting Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]: What O/S? On Windows you will need to enable Verity via the Command Prompt to be a Windows Service (if you want it to be). -Original Message- From: kevin roche [mailto:[EMAIL PROTECTED] Sent: 17 November 2004 15:26 To: CF-Talk Subject: Verity Installation Problem Hi, I have recently installed CFMX 6.1 on a server that was locked down by the hosting company. The server already had CF5 running and I wanted to be able to run the two versions on the same box. The server was installe in JRun Mode and I have now set up a new virtual server that uses CFMX while the exsiting virtual server is running CF5 All seems Ok except the verity pages which says: You must configure your application server to enable Verity. For instructions, see Installing and Using ColdFusion MX. I read the manual and it says that verity must have a couple of lines added to the JRun parameters. I checked and they are already there. Anyone know what else I should be looking for ? -- Kevin Roche ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184608 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
DevNet Version of CFMX adds rubbish to the start of my HTML.
Hi, I am trying to build pages for the first time with XHTML and the validators in both Homesite and Dreamweaver seem only to do half the job. I am trying to point the W3C validator at my development machine which is running the multiuser devnet version of my site but the server adds an extra line at the front of the file and the result is invalid. Anyone know how to get rid of the line? META NAME=ColdFusionMXEdition CONTENT=ColdFusion DevNet Edition - Not for Production Use. The MM site says use cfcontent to make the file text/xml but then it does not work in a browser and I need to have both. -- Kevin Roche ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184616 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT Have I got a virus or what?
Hi, Yesterday I started getting problems with my PC. The symptoms are that the web server never responds to a request for a cfm page. If I try to look at a htm page, the start of page is not there. This is not a browser problem as the pages work OK if browsed directly. Anyone got any ideas? Kevin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT Have I got a virus or what?
Ok So I found the solution to this problem but it does not make any sense to me. I removed the registry entry which SQL Enterprise Manager has which pointed to a SQL Server which has gone down and is now disconnected to the network. Now everything works again. Explain that! Kevin -Original Message- From: Kevin Roche [mailto:[EMAIL PROTECTED] Sent: 28 July 2004 12:51 To: CF-Talk Subject: OT Have I got a virus or what? Hi, Yesterday I started getting problems with my PC. The symptoms are that the web server never responds to a request for a cfm page. If I try to look at a htm page, the start of page is not there. This is not a browser problem as the pages work OK if browsed directly. Anyone got any ideas? Kevin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT Have I got a virus or what?
Yes, Looks like you are right. Have uninstalled Zone Alarm for the time being. Let me know if you find a solution. I thought it was a problem in CF with a datasource. Kevin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 28 July 2004 14:04 To: CF-Talk Subject: RE: OT Have I got a virus or what? Yesterday I started getting problems with my PC. The symptoms are that the web server never responds to a request for a cfm page. Have you got the new Zone Alarm installed and using IIS? I had this prob at home and it turns out the new Zone Alarm mucks about with IIS, no fix as yet, you just need to stop and restart Zone Alarm if that is your issue -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Kevin Roche is Lame
Apologies, if they annoyed you.I am getting way too much SPAM now and was spending hours throwing it away. -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: 19 June 2004 15:31 To: CF-Talk Subject: Re: Kevin Roche is Lame On Fri, 18 Jun 2004 16:25:53 -0400, Adrocknaphobia wrote: Is anyone else getting Spam Interceptor emails from this guy? (This message will probably trigger another one.) I got one and promptly ignored it I've seen cases of these things as harvesters, so I'm not trusting any of them anymore [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cflocation fails
Hi, I have a strange situation which I can't track down. I have an application that I have been using successfully for some time running on CFMX 6.1 Recently the application has been giving problems because the cflocation tags are not working sometimes. The characteristics are that the browser shows the redirected URL at the address bar and the content (Usually nothing or debug info) for the page that issues the cflocation. If you position the cursor in the address bar and hit enter you do then go to the correct page. Anyone seen this before? Anyone know what could possibly cause it? Kevin Roche [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cflocation fails
The problem has been reported on two different machines. Although there is conditional logic the required location including URL variables is definitely shown in the address box. I am begining to think there is a response time problem on the server. Kevin -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 21 June 2004 13:24 To: CF-Talk Subject: RE: cflocation fails I wouldn't have thought so because the correct URL is in the browser window, if conditional logic was stopping the cflocation being executed then there would be no way for the browser to have the URL.I would suspect the browser is not handling the relocation properly, are you able to test it from a different machine? is it possible that there is conditional logic around the relocation and the conditional test fails the first time that page loads? Hi, I have a strange situation which I can't track down. I have an application that I have been using successfully for some time running on CFMX 6.1 Recently the application has been giving problems because the cflocation tags are not working sometimes. The characteristics are that the browser shows the redirected URL at the address bar and the content (Usually nothing or debug info) for the page that issues the cflocation. If you position the cursor in the address bar and hit enter you do then go to the correct page. Anyone seen this before? Anyone know what could possibly cause it? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
WSCONFIG problem
Hi, I just installed CF MX 6.1 and tried to run wsconfig.exe to set up IIS. wsconfig cant find the Java Runtime Environment. I have done this several times before without any problem. The error message I get is: Error: could not find JRE Error: could not find Java 2 Runtime Environment. I tried editing the wsconfig_jvm.config file did not help either. Anyone out there know hoe to fix this? Kevin Roche [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: WSCONFIG problem
Jochem, I already tried that. And also tried putting it in the wsconfig_jvm.config file. neither works. Just makes the program hand without giving an error message. Strange thing is that the CFMX uninstall won't work either. Kevin -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 08 June 2004 17:27 To: CF-Talk Subject: Re: WSCONFIG problem Kevin Roche wrote: wsconfig cant find the Java Runtime Environment. The error message I get is: Error: could not find JRE Error: could not find Java 2 Runtime Environment. Set the JRE_HOME environment variable: set JRE_HOME=c:\cfusion\runtime\blahblah Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Product Registration Installation
Hi, I am in the process of re-installing software on 5 machines in our office. For various reasons I want to start from scratch and make sure a the windows software is up to date. I have instaled everything I want on one machine and and have cloned a copy of it all onto another using Drive Image. This includes a copy of Studio MX. This works fine for most of the software, however there seems to be a clever thing in Dreamweaver MX which stops two copies having the same serial number. I do have licences for all these copies so I just want to update the licence key on the cloned copy. I am guessing the same might be true for Flash MX and ColdFusion MX. I do not want to uninstall and re-install the whole thing on each machine as it also means setting all the extensions and the HomeSite+ snippets. Does anyone know where I can update the serial number on the cloned copy? Kevin Roche [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: What causes this error?
Jeff, Where is the database yopu are using? Is it on the same machine? The machine is trying to use NT type security here. That means the username and password are those of a valid NT login. Is that what you intended? The username and password can be supplied with the ODBC datasource settings. Kevin -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: 06 May 2004 04:38 To: CF-Talk Subject: What causes this error? I can't add a SQL datasource, and I'm doing everything *exactly* like I do at work...it's just my home machine, and I'm trying to get a datasource up and running. I've updated CFMX, the works...but for some reason, I get the following error...anything look familiar here that's just a quick fix? Connection verification failed for data source: JeffSQL []java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'Jeff Small'. Reason: Not associated with a trusted SQL Server connection. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'Jeff Small'. Reason: Not associated with a trusted SQL Server connection. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]