Re: Coldspring error: what does this mean please?
On 10/23/07, Mike Kear [EMAIL PROTECTED] wrote: what shoud it be set to and are there any security or performance implicatoins for a shared hosting operatoin ? My understanding is that most shared hosts will use this new setting to disable access to Java objects to improve security. Mark Mandel has already had to modify Transfer to work around this and I've had to modify Fusebox for similar reasons. It's a pain in the ass but I can understand both why Adobe have added the feature and why hosting companies would use it... -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291929 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: what does this mean please?
On 10/23/07, Andrew Scott [EMAIL PROTECTED] wrote: However that does mystify me though, cfdump I would not have taken as an internal java tag? I think this is simply an oversight by the CF team - cfdump does not work properly when you turn Java object access off with this new setting. But what doed also worry me is that the file cfdump.cfm is missing as Mike also stated earlier by the hosting provider. I think that was a miscommunication... -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291930 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: New 64-bit Dev Server
Thanks all. The reason for loading all this on one box is cost at the moment. It will be a half decent spec and there will be around 5 initial users moving up to 10-15 over the next six months. Will the fact that it's 64-bit Windows throw up any problems? The risks about patches breaking things rings true as I know one sys-admin who had a similar set-up and didn't patch SQL Server because it caused problems with Exchange (or the other way around). Adrian I'm setting up a new development server that'll house CF 8, IIS 6 and SQL 2005 on Windows 2003 64-bit. The reason for 64-bit is that it's a requirement for Exchange 2007 which will also be on this box. Can anyone shed some light on whether there will be any problems with this set up? I've been reading up on WoW64 and the requirements for the various software but any other input would be great. Thanks. -- Adrian Lynch ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291931 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldspring error: what does this mean please?
Well I am really pissed off to learn that i might not be able to use CFDUMP. That's one of the best debugging tools there is, and to not have it will make a great many things more difficult. Yes, you have to do most of your development on a dev machine, but after uploading your app to production you have to test it and if something goes wrong on the production machine not to have CFDUMP would be a real pain. I guess I'm goign to have to do some negotiation with the systems guys at hostmysite. So how do i verify that coldspring is in fact working and isnt just an absense of error messages? (not the same thing) Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 10/24/07, Sean Corfield [EMAIL PROTECTED] wrote: On 10/23/07, Andrew Scott [EMAIL PROTECTED] wrote: However that does mystify me though, cfdump I would not have taken as an internal java tag? I think this is simply an oversight by the CF team - cfdump does not work properly when you turn Java object access off with this new setting. But what doed also worry me is that the file cfdump.cfm is missing as Mike also stated earlier by the hosting provider. I think that was a miscommunication... -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:291932 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: what does this mean please?
Ok as a test I did what Mike is trying to do here locally. cfdump works fine with the setting of Disable access to internal ColdFusion Java components. So that is not Mikes problem... On 10/24/07, Mike Kear [EMAIL PROTECTED] wrote: Well I am really pissed off to learn that i might not be able to use CFDUMP. That's one of the best debugging tools there is, and to not have it will make a great many things more difficult. Yes, you have to do most of your development on a dev machine, but after uploading your app to production you have to test it and if something goes wrong on the production machine not to have CFDUMP would be a real pain. I guess I'm goign to have to do some negotiation with the systems guys at hostmysite. So how do i verify that coldspring is in fact working and isnt just an absense of error messages? (not the same thing) Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 10/24/07, Sean Corfield [EMAIL PROTECTED] wrote: On 10/23/07, Andrew Scott [EMAIL PROTECTED] wrote: However that does mystify me though, cfdump I would not have taken as an internal java tag? I think this is simply an oversight by the CF team - cfdump does not work properly when you turn Java object access off with this new setting. But what doed also worry me is that the file cfdump.cfm is missing as Mike also stated earlier by the hosting provider. I think that was a miscommunication... -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291934 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New 64-bit Dev Server
Coldfusion will not install on a 64bit machine, it is not supported. On 10/24/07, Adrian Lynch [EMAIL PROTECTED] wrote: Thanks all. The reason for loading all this on one box is cost at the moment. It will be a half decent spec and there will be around 5 initial users moving up to 10-15 over the next six months. Will the fact that it's 64-bit Windows throw up any problems? The risks about patches breaking things rings true as I know one sys-admin who had a similar set-up and didn't patch SQL Server because it caused problems with Exchange (or the other way around). Adrian I'm setting up a new development server that'll house CF 8, IIS 6 and SQL 2005 on Windows 2003 64-bit. The reason for 64-bit is that it's a requirement for Exchange 2007 which will also be on this box. Can anyone shed some light on whether there will be any problems with this set up? I've been reading up on WoW64 and the requirements for the various software but any other input would be great. Thanks. -- Adrian Lynch ~| 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:291933 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldspring error: what does this mean please?
On a side note - This is one of the reasons why I suggested to you Mike to simply upload your App onto the hosting server, rather than trying to test is piecemeal. If the whole application is uploaded, you can test and fix issues that are relevant *to your application*, and not spend several days trying to track down an issue that really doesn't stop your application from running. This is just my opinion however ;o) your mileage may vary. Mark On 10/24/07, Mark Mandel [EMAIL PROTECTED] wrote: I wish I had kept an eye on this thread! Apologies to Mike - when working around the 'Disable Access to ColdFusion Java Objects' setting in CF8, I ran into the issue that you can't use cfdump on many things. On some things you can, and on other things you can't. The reason is this - by turning this setting on there is a security policy that goes into effect that restricts external access to anything that is coldfusion.* - which includes trying to access and / or interogate any class or classpath that uses that space. If you do a lot of CF/Java integration, you will quickly notice that you can't get to the CF classPath, if you want it, and trying to call .getClass() (often through reflection) on CF objects causes the error that you just saw. I would expect that CFDUMP does call getClass / does some sort of java meta data introspection on the objects it is attempting to dump - which in turn throws this error, as it won't be allowed. This setting - while essential for Shared Hosts, is a pretty damn big sword that cuts through many things, including aspects of cfdump, access to CFCProxy and some other bits and pieces that I can't think of right now. I think in the coming months, we're going to hit various pieces of functionality that will be broken on shared servers because of this setting. Mark On 10/24/07, Sean Corfield [EMAIL PROTECTED] wrote: On 10/23/07, Andrew Scott [EMAIL PROTECTED] wrote: However that does mystify me though, cfdump I would not have taken as an internal java tag? I think this is simply an oversight by the CF team - cfdump does not work properly when you turn Java object access off with this new setting. But what doed also worry me is that the file cfdump.cfm is missing as Mike also stated earlier by the hosting provider. I think that was a miscommunication... -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291936 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: what does this mean please?
I wish I had kept an eye on this thread! Apologies to Mike - when working around the 'Disable Access to ColdFusion Java Objects' setting in CF8, I ran into the issue that you can't use cfdump on many things. On some things you can, and on other things you can't. The reason is this - by turning this setting on there is a security policy that goes into effect that restricts external access to anything that is coldfusion.* - which includes trying to access and / or interogate any class or classpath that uses that space. If you do a lot of CF/Java integration, you will quickly notice that you can't get to the CF classPath, if you want it, and trying to call ..getClass() (often through reflection) on CF objects causes the error that you just saw. I would expect that CFDUMP does call getClass / does some sort of java meta data introspection on the objects it is attempting to dump - which in turn throws this error, as it won't be allowed. This setting - while essential for Shared Hosts, is a pretty damn big sword that cuts through many things, including aspects of cfdump, access to CFCProxy and some other bits and pieces that I can't think of right now. I think in the coming months, we're going to hit various pieces of functionality that will be broken on shared servers because of this setting. Mark On 10/24/07, Sean Corfield [EMAIL PROTECTED] wrote: On 10/23/07, Andrew Scott [EMAIL PROTECTED] wrote: However that does mystify me though, cfdump I would not have taken as an internal java tag? I think this is simply an oversight by the CF team - cfdump does not work properly when you turn Java object access off with this new setting. But what doed also worry me is that the file cfdump.cfm is missing as Mike also stated earlier by the hosting provider. I think that was a miscommunication... -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:291935 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Working with CFGRID
i have created a cfgrid formatted to HTML i have also added the href=page.cfm hrefkey=ID to the column as well. The grid displays ok but when the rows are empty it shows a - in the blank rows were the data would be linked to the different page. is there a way to only hyperlink the rows with data in them so that the grid doesnt look as bad. Thanks ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291937 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Working with CFGRID
Yes there is. It is called custom rendering, and Ray Camdan has a tutorial on his blog that will help you with that. On 10/24/07, Anthony Doherty [EMAIL PROTECTED] wrote: i have created a cfgrid formatted to HTML i have also added the href=page.cfm hrefkey=ID to the column as well. The grid displays ok but when the rows are empty it shows a - in the blank rows were the data would be linked to the different page. is there a way to only hyperlink the rows with data in them so that the grid doesnt look as bad. Thanks ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291938 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: fixing outofmemoryerror: java heap space
On Tuesday 23 Oct 2007, [EMAIL PROTECTED] wrote: java heap space. I have just set up this server-- so I am hoping there is some value I can tweak that will allow this page to run... it is vitally important to the website that it works... does anybody know what I could do? Thanks! Well, you can adjust the Java arguments CF uses, but it's probably a much better idea to find out why your app is so memoray intensive and fix that. -- Tom Chiverton. Are you a great ColdFusion programmer, who knows Reactor and ColdSpring, and has done some Flex work ? Would you like to work for a top 30 law firm in Manchester, UK ? Are not an agency ? If yes, send email ! This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291939 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: load balancing/failover and CF
On Tuesday 23 Oct 2007, [EMAIL PROTECTED] wrote: a previous job, we used a product called Coherence from tangosol (now owned by Oracle) (see http://www.tangosol.com/coherence-overview.jsp). the coherence box acts as a dedicated session variable repository in the cluster... Err, but then you need to load balence and cluster them as well ? -- Tom Chiverton. Are you a great ColdFusion programmer, who knows Reactor and ColdSpring, and has done some Flex work ? Would you like to work for a top 30 law firm in Manchester, UK ? Are not an agency ? If yes, send email ! This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291940 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfreport question
Thanks for the suggestion Rob. Getting cfreport to save the report to a file, then calling it in the cfwindow is still producing the gibberish. Running the cfreport directly in the browser works great and so does calling the saved pdf though. So I thought remove the cfreport component all together and just try opening some other pdf in the cfwindow.. same problem. I'm thinking this is heading towards the conclusion that the cfwindow can't open pdf or flash types? But can anyone give this a try and confirm/deny that this is the case? It really would be the perfect solution for what I'm after. -Original Message- From: Rob Parkhill [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 October 2007 3:07 AM To: CF-Talk Subject: Re: cfreport question Luke, do you have the filename attribute set for your cfreport tag? If this isn't set it basically outputs the code for a PDF file into HTML, making well gobbledegook... Try setting a filename and then your overwrite attributes for the cfreport tag. I have the following: cfwindow closable=true draggable=true name=Test modal=false initshow=true height=350 width=325 title=Test x=600 y=150 cfreport format=pdf filename=test.pdf overwrite=yes template=reports/newcoldfusionreport.cfr cfreportparam name=name value=1 /cfreport /cfwindow And it generated a PDF that I could find on my local machine and if I wanted to code in reference to it, I could. HTH, Rob ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291941 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfreport question
I suppose you didn't try to load a src file with the extension .cfm and use that template to set the content type to pdf with cfcontent and load the pdf that way? I have seen it happen from time to time with the report displaying giberish and that has been my solution with cached content. On 10/24/07, Luke Fromhold [EMAIL PROTECTED] wrote: Thanks for the suggestion Rob. Getting cfreport to save the report to a file, then calling it in the cfwindow is still producing the gibberish. Running the cfreport directly in the browser works great and so does calling the saved pdf though. So I thought remove the cfreport component all together and just try opening some other pdf in the cfwindow.. same problem. I'm thinking this is heading towards the conclusion that the cfwindow can't open pdf or flash types? But can anyone give this a try and confirm/deny that this is the case? It really would be the perfect solution for what I'm after. -Original Message- From: Rob Parkhill [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 October 2007 3:07 AM To: CF-Talk Subject: Re: cfreport question Luke, do you have the filename attribute set for your cfreport tag? If this isn't set it basically outputs the code for a PDF file into HTML, making well gobbledegook... Try setting a filename and then your overwrite attributes for the cfreport tag. I have the following: cfwindow closable=true draggable=true name=Test modal=false initshow=true height=350 width=325 title=Test x=600 y=150 cfreport format=pdf filename=test.pdf overwrite=yes template=reports/newcoldfusionreport.cfr cfreportparam name=name value=1 /cfreport /cfwindow And it generated a PDF that I could find on my local machine and if I wanted to code in reference to it, I could. HTH, Rob ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291942 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfreport question
Yeah that's the way I was attempting originally. I also gave saving the report to a variable a go (using the 'name' attrb of cfreport) and then calling that variable via cfcontent too. Further, I've tried using cfreport to save the report to a pdf on the hdd, then using filename and cfcontent to display it. All result in the same. (and same tests with flashpaper too.) When I put the url into the browser directly, they display great. Putting that url into 'source' attrb of cfwindow shows the junk. Using Firebug and watching the call when cfwindow opens, I believe I am setting the content type correctly. -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 October 2007 6:30 PM To: CF-Talk Subject: Re: cfreport question I suppose you didn't try to load a src file with the extension .cfm and use that template to set the content type to pdf with cfcontent and load the pdf that way? I have seen it happen from time to time with the report displaying giberish and that has been my solution with cached content. On 10/24/07, Luke Fromhold [EMAIL PROTECTED] wrote: Thanks for the suggestion Rob. Getting cfreport to save the report to a file, then calling it in the cfwindow is still producing the gibberish. Running the cfreport directly in the browser works great and so does calling the saved pdf though. So I thought remove the cfreport component all together and just try opening some other pdf in the cfwindow.. same problem. I'm thinking this is heading towards the conclusion that the cfwindow can't open pdf or flash types? But can anyone give this a try and confirm/deny that this is the case? It really would be the perfect solution for what I'm after. -Original Message- From: Rob Parkhill [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 October 2007 3:07 AM To: CF-Talk Subject: Re: cfreport question Luke, do you have the filename attribute set for your cfreport tag? If this isn't set it basically outputs the code for a PDF file into HTML, making well gobbledegook... Try setting a filename and then your overwrite attributes for the cfreport tag. I have the following: cfwindow closable=true draggable=true name=Test modal=false initshow=true height=350 width=325 title=Test x=600 y=150 cfreport format=pdf filename=test.pdf overwrite=yes template=reports/newcoldfusionreport.cfr cfreportparam name=name value=1 /cfreport /cfwindow And it generated a PDF that I could find on my local machine and if I wanted to code in reference to it, I could. HTH, Rob ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291943 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Which query would be better?
On Tuesday 23 Oct 2007, [EMAIL PROTECTED] wrote: Okay. Except Oracle != MySQL 5. MySQL 5 was what was specified in the original, forgive the pun, query. Heh. Free beats multi-thousend pound again :-) -- Tom Chiverton. Are you a great ColdFusion programmer, who knows Reactor and ColdSpring, and has done some Flex work ? Would you like to work for a top 30 law firm in Manchester, UK ? Are not an agency ? If yes, send email ! This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:291944 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldspring error: what does this mean please?
On Wednesday 24 Oct 2007, [EMAIL PROTECTED] wrote: As for my 3 month after launch statement, this could happen, if that dump was added in by someone unknowing and you didn't know what or where and the line looks perfectly valid. You have your site down for a day tracking down this issue. Dude, if you have people making code changes on the live server without asking or informing the whole dev team, you have bigger problems. -- Tom Chiverton. Are you a great ColdFusion programmer, who knows Reactor and ColdSpring, and has done some Flex work ? Would you like to work for a top 30 law firm in Manchester, UK ? Are not an agency ? If yes, send email ! This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291945 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam and dynamically-created SQL
On Tuesday 23 Oct 2007, [EMAIL PROTECTED] wrote: Does the presence of the cfif statement inside the cfquery block negate all the performance benefits I would have otherwise gained from using cfqueryparam? You have to remember cfqp doesn't just buy you performance, but security and robustness too. Any tiny, tiny, performance hit is unlikely to out weigh that. If so, I would guess this is a common issue people run into. Is there a best practice for handling this kind of situation? Use cfqp. Always use cfqp. -- Tom Chiverton. Are you a great ColdFusion programmer, who knows Reactor and ColdSpring, and has done some Flex work ? Would you like to work for a top 30 law firm in Manchester, UK ? Are you not an agency ? If yes, send email ! This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291946 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfqueryparam and dynamically-created SQL
Yep, I agree with Tom, _always_ use it. If you haven't done so already, do some research on 'SQL Injection Attacks' which you are vulnerable too when not using cfqueryparam ... You'll be having nightmares and panic attacks for days, until you wrap all your dynamic SQL in cfqueryparam. Rob -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: 24 October 2007 10:39 To: CF-Talk Subject: Re: cfqueryparam and dynamically-created SQL On Tuesday 23 Oct 2007, [EMAIL PROTECTED] wrote: Does the presence of the cfif statement inside the cfquery block negate all the performance benefits I would have otherwise gained from using cfqueryparam? You have to remember cfqp doesn't just buy you performance, but security and robustness too. Any tiny, tiny, performance hit is unlikely to out weigh that. If so, I would guess this is a common issue people run into. Is there a best practice for handling this kind of situation? Use cfqp. Always use cfqp. -- Tom Chiverton. Are you a great ColdFusion programmer, who knows Reactor and ColdSpring, and has done some Flex work ? Would you like to work for a top 30 law firm in Manchester, UK ? Are you not an agency ? If yes, send email ! This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:291947 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldspring error: what does this mean please?
Hey Tom, Yep we occasionally have code that goes onto production and causes problems. I guess im the only one. Regards Dale Fraser http://learncf.com -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 October 2007 7:22 PM To: CF-Talk Subject: Re: Coldspring error: what does this mean please? On Wednesday 24 Oct 2007, [EMAIL PROTECTED] wrote: As for my 3 month after launch statement, this could happen, if that dump was added in by someone unknowing and you didn't know what or where and the line looks perfectly valid. You have your site down for a day tracking down this issue. Dude, if you have people making code changes on the live server without asking or informing the whole dev team, you have bigger problems. -- Tom Chiverton. Are you a great ColdFusion programmer, who knows Reactor and ColdSpring, and has done some Flex work ? Would you like to work for a top 30 law firm in Manchester, UK ? Are not an agency ? If yes, send email ! This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291948 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldspring error: what does this mean please?
On Wednesday 24 Oct 2007, [EMAIL PROTECTED] wrote: Yep we occasionally have code that goes onto production and causes problems. I guess im the only one. Oh no, it does happen to everyone :-) But if we change something, we'd check it, so we'd know that the cfdump we added caused an explosion. -- Tom Chiverton Helping to collaboratively engage granular bandwidth on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:291949 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: New 64-bit Dev Server
http://www.forta.com/blog/index.cfm/2006/2/6/Connecting-ColdFusion-MX-7- To-64bit-IIS-6 It *will* install and evidently run fine, but you are right that it wont be 'supported' by Adobe. Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 2:52 AM To: CF-Talk Subject: Re: New 64-bit Dev Server Coldfusion will not install on a 64bit machine, it is not supported. On 10/24/07, Adrian Lynch [EMAIL PROTECTED] wrote: Thanks all. The reason for loading all this on one box is cost at the moment. It will be a half decent spec and there will be around 5 initial users moving up to 10-15 over the next six months. Will the fact that it's 64-bit Windows throw up any problems? The risks about patches breaking things rings true as I know one sys-admin who had a similar set-up and didn't patch SQL Server because it caused problems with Exchange (or the other way around). Adrian I'm setting up a new development server that'll house CF 8, IIS 6 and SQL 2005 on Windows 2003 64-bit. The reason for 64-bit is that it's a requirement for Exchange 2007 which will also be on this box. Can anyone shed some light on whether there will be any problems with this set up? I've been reading up on WoW64 and the requirements for the various software but any other input would be great. Thanks. -- Adrian Lynch ~| 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:291950 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: get the value of the drop down and pass it to the cfquery
cfif isdefined('form.ask')
cfset session.myVar = form.mySelect /
cfoutput#session.myVar#/cfoutput
/cfif
cfoutput
form action=#cgi.script_name# method=post
Questions to ask on CF-Talk:
select name=mySelect
option value=howHow?/option
option value=whoWho?/option
option value=whatWhat?/option
option value=whereWhere?/option
option value=whenWhen?/option
option value=Where can I get the CFWACK?Where can I get the
CFWACK/option
/select
input type=submit name=ask value=Ask /
/form
/cfoutput
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: erik tom [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 23, 2007 4:01 PM
To: CF-Talk
Subject: Re: get the value of the drop down and pass it to the cfquery
What do you have the submit button doing? Does it actually submit to
the server, or just forward to the next tab?
For CF to process information, you have to make a server trip of some
kind.
If you are making the server trip, but not seeing the information
passed, what are you naming your dropdown, and how are you referencing
it in the query?
--Ben Doom
The button supposed to submit so I can set the session variable to the next
tab
erik tom wrote:
I need to be able get the value from the drop down and pass ethis
value to cfquery function which located on the second tab of the form.
Once i selected the drop down item i clicked on the submit button and
going to the second tab but nothing getting passed to the query.
Help?
~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291951
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: TinyUrl's?
I second that. Very easy to build. Then you can just have URLs like http://mysite.com/urls/#uniqueID# ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Alan Rother [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 23, 2007 7:09 PM To: CF-Talk Subject: Re: TinyUrl's? You could make you own. It's not a complicated process. You enter a url into a DB, give it a unique identifier, which can be anything you want it to be (int, UUID, some complex schema you design). Then when someone requests that unique identifier, you re-direct them to that URL in your DB. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| 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:291952 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: What can PHP do that CF can't?
and a laggard in every bunch ;)~ ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Dave l [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 23, 2007 11:32 PM To: CF-Talk Subject: Re: What can PHP do that CF can't? There is a wise-guy in every bunch ;)~ I have much more important things to complain about than something that may be off topic in a community. Apparently. .:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291953 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Working with CFGRID
thanks for that andrew but that allows me to format the data within the grid into different formats from the blog that i found (http://www.coldfusionjedi.com/index.cfm/2007/8/20/Custom-grid-renderers-with-CFGRID) maybe im using the wrong blog Yes there is. It is called custom rendering, and Ray Camdan has a tutorial on his blog that will help you with that. On 10/24/07, Anthony Doherty [EMAIL PROTECTED] wrote: i have created a cfgrid formatted to HTML i have also added the href=page.cfm hrefkey=ID to the column as well. The grid displays ok but when the rows are empty it shows a - in the blank rows were the data would be linked to the different page. is there a way to only hyperlink the rows with data in them so that the grid doesnt look as bad. Thanks ~| 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:291954 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Working with CFGRID
No, you are using the right blog. The beauty with custom rendering is that you can check the value before displaying and then decide what to do. So in your case you can do something that decides to check that the data has something in it and render it or display nothing. I think you should look at this custom rendering just a little closer. On 10/24/07, Anthony Doherty [EMAIL PROTECTED] wrote: thanks for that andrew but that allows me to format the data within the grid into different formats from the blog that i found (http://www.coldfusionjedi.com/index.cfm/2007/8/20/Custom-grid-renderers-with-CFGRID) maybe im using the wrong blog Yes there is. It is called custom rendering, and Ray Camdan has a tutorial on his blog that will help you with that. On 10/24/07, Anthony Doherty [EMAIL PROTECTED] wrote: i have created a cfgrid formatted to HTML i have also added the href=page.cfm hrefkey=ID to the column as well. The grid displays ok but when the rows are empty it shows a - in the blank rows were the data would be linked to the different page. is there a way to only hyperlink the rows with data in them so that the grid doesnt look as bad. Thanks ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291955 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Max Varchar Length
HI, Just wondering if anyone works with mysql and can help us understand this little issue. we understood that the maximum length for a varchar is 255. however we read somewhere that since mysql version 5.0.3 the varchar maximum length is 767. We have just been testing this theory and dont know why but the database is allowing us to alter a columns data type to varchar(5), if we set it to varchar(65535) it tells us it is too big and that we need to include a text data type instead. This is of course what we expected but we expected this error to occur way before we was allowed to insert varchar(5) and would have expected it on either varchar(256) or varchar(768) depending on the version we have Hope this makes sense and would really appreciate any help with understanding this and how to best use the text and varchar data types thanks ~| 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:291956 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Max Varchar Length
On Wednesday 24 Oct 2007, [EMAIL PROTECTED] wrote: we understood that the maximum length for a varchar is 255. however we read somewhere that since mysql version 5.0.3 the varchar maximum length is 767. Where did you read that ? Not in the manual, I guess: http://dev.mysql.com/doc/refman/5.0/en/char.html The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions. -- Tom Chiverton Helping to carefully orchestrate wireless schemas on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291957 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Max Varchar Length
Richard White wrote: HI, Just wondering if anyone works with mysql and can help us understand this little issue. we understood that the maximum length for a varchar is 255. however we read somewhere that since mysql version 5.0.3 the varchar maximum length is 767. We have just been testing this theory and dont know why but the database is allowing us to alter a columns data type to varchar(5), if we set it to varchar(65535) it tells us it is too big and that we need to include a text data type instead. This is of course what we expected but we expected this error to occur way before we was allowed to insert varchar(5) and would have expected it on either varchar(256) or varchar(768) depending on the version we have Hope this makes sense and would really appreciate any help with understanding this and how to best use the text and varchar data types The VARCHAR maximum is 65535 - but it is subject to a limit on the size of entire row which is also 65535 bytes - so you will seldom be able to use the VARCHAR maximum size of 65535 unless you only have a single column. See: http://dev.mysql.com/doc/refman/5.0/en/char.html -tom- ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291958 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Max Varchar Length
I believe in newer versions of MySQL, there is only varchar and it can range from 1 to the max length which I believe is 65534. LargeText is for 65535 up to around 10 or 15 million characters. -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 9:56 AM To: CF-Talk Subject: Max Varchar Length HI, Just wondering if anyone works with mysql and can help us understand this little issue. we understood that the maximum length for a varchar is 255. however we read somewhere that since mysql version 5.0.3 the varchar maximum length is 767. We have just been testing this theory and dont know why but the database is allowing us to alter a columns data type to varchar(5), if we set it to varchar(65535) it tells us it is too big and that we need to include a text data type instead. This is of course what we expected but we expected this error to occur way before we was allowed to insert varchar(5) and would have expected it on either varchar(256) or varchar(768) depending on the version we have Hope this makes sense and would really appreciate any help with understanding this and how to best use the text and varchar data types thanks ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291959 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SeeFusion vs. FusionReactor
I'm about to invest in one of these, and I'm looking for advice and/or practical experience. We have several applications running, and we're trying to hunt down the source of site slowdowns. Is there an overriding reason to pick one over the other? I'm currently leaning toward FusionReactor -- it seems cleaner and easier to use. It is, of course, a bit more expensive. Is it worth the extra money? For reference, I'm running CF8 Standard on Win2k3 R2. --Ben Doom ~| 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:291961 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldspring error: what does this mean please?
On 10/24/07, Dale Fraser [EMAIL PROTECTED] wrote: Ok, I'm not going to start a flame war. I said this is the reason that I don't use third party frameworks, not that you shouldn't. As for the UI framework I released open source, I wouldn't use it either if I hadn't written it. As for my 3 month after launch statement, this could happen, if that dump was added in by someone unknowing and you didn't know what or where and the line looks perfectly valid. You have your site down for a day tracking down this issue. The same way you would if anything else changed that you didn't know about and it broke the app. This argument is meaningless. Further, what is the alternative? Write something yourself, that only you and a small group of people have looked at, and use that? Instead of something that has been out for years and has had literally thousands of eyes on it? You've got to be kidding. Again, this problem had *nothing* to do with ColdSpring. It was a problem in another part of Mike's code. And even then, if you go look back at the error message, it tells you exactly where the error is happening. I don't have access to his code so my first instinct was that it was a path issue on the shared server. But Mike (wags finger at him) should have looked at this cfdump tag first thing. I also don't want to start a flame war, so I'm fine letting this die here. I just want to be sure everyone else reading this is fully aware of the situation and that, despite your opinion, ColdSpring kicks ass (which is my opinion, and the opinion of a ton of others). Regards Dale Fraser http://learncf.com -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 October 2007 3:19 PM To: CF-Talk Subject: Re: Coldspring error: what does this mean please? AH!!! Slaps the forehead moment I removed the CFDUMP line and the error went away so whats the matter with the line cfdump var=#BeanFactory# label=Beanfactory - reset line 34 then?? can't CF8 dump out a component like CF7?? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 10/24/07, Mike Kear [EMAIL PROTECTED] wrote: Thanks for your interest Sean, i feel a lot better now you and Brian are involved. on line 47 is the line i'm using to check it's been creating a bean correctly. it says cfdump var=#BeanFactory# label=Beanfactory - reset line 34 But i get the error even if the only bit of code on the page is the one kicking off the coldspring cfset BeanFactory = createObject(component,coldspring.beans.DefaultXmlBeanFactory)/ If you like i can cut everything off the page except that line, and put it back up and let you see for yourself. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291960 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: what does this mean please?
Agreed, especially if the same dump works fine locally. In that case it has to be some configuration issue on the server (you might try dumping various other things to see if you can find a pattern in what will dump and what won't). On 10/24/07, James Holmes [EMAIL PROTECTED] wrote: This might get us back to the internal Java method setting I was talking about. On 10/24/07, Mike Kear [EMAIL PROTECTED] wrote: AH!!! Slaps the forehead moment I removed the CFDUMP line and the error went away so whats the matter with the line cfdump var=#BeanFactory# label=Beanfactory - reset line 34 then?? can't CF8 dump out a component like CF7?? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291963 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: what does this mean please?
If you mean you put code in production, then months later someone changes something without telling anyone else, and it breaks something? And then you try to say that the fault lies with anyone except the person who made the change and didn't tell anyone? Yes, I'd say you're the only one. Totally unrelated Dale, I love the learncf.com site. Good job there. (Yes, I'm bipolar). On 10/24/07, Dale Fraser [EMAIL PROTECTED] wrote: Hey Tom, Yep we occasionally have code that goes onto production and causes problems. I guess im the only one. Regards Dale Fraser ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291962 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: TinyUrl's?
Does anyone know of any tiny url like services either in CF, or that CF can integrate with? I have a requirement to create lots of tiny url's programatically. Neil There's one listed at cfczone.org: Author: Critter Gewlas Date Released: 03/01/2004 Last Updated: 03/01/2004 Description Takes a large url, passes it to www.tinyurl.com and returns a shortened one. You can download a zip of the application at http://www.cfczone.org/cfcs/downloads/ctz_tinyurl.zip. hth, larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection http://www.beiresources.org email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- ~| 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:291964 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SeeFusion vs. FusionReactor
I don't believe that CF8 Standard comes with the server monitoring tools. On 10/24/07, Peterson, Chris [EMAIL PROTECTED] wrote: Ben - the integrated server monitor in CF8 was not enough to figure out the errors? (from the admin, check out server monitor on the left) I have FusionReactor on CF7 Ent, and I agree it is much cleaner than the demo I tried of SeeFusion. I have never had a problem with it. Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291969 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SeeFusion vs. FusionReactor
Ben - the integrated server monitor in CF8 was not enough to figure out the errors? (from the admin, check out server monitor on the left) I have FusionReactor on CF7 Ent, and I agree it is much cleaner than the demo I tried of SeeFusion. I have never had a problem with it. Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 10:46 AM To: CF-Talk Subject: SeeFusion vs. FusionReactor I'm about to invest in one of these, and I'm looking for advice and/or practical experience. We have several applications running, and we're trying to hunt down the source of site slowdowns. Is there an overriding reason to pick one over the other? I'm currently leaning toward FusionReactor -- it seems cleaner and easier to use. It is, of course, a bit more expensive. Is it worth the extra money? For reference, I'm running CF8 Standard on Win2k3 R2. --Ben Doom ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291965 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfqueryparam and dynamically-created SQL
Posted this yesterday, but it didn't seem to go through... I became a convert to cfqueryparam, thanks to this list, about 2 months ago. Since then, I've wondered about this kind of statement (shortened here): cfquery SELECT username FROM user WHERE lastname = cfqueryparam type=varchar value=#mylastname# cfif len(myfirstname) AND cfqueryparam type=varchar value=#myfirstname# /cfif /cfquery Does the presence of the cfif block inside the SQL negate the speed benefits I would get from using cfqueryparam? I'm kind of hoping not, but guessing yes. Thanks in advance for the advice, Ben Mueller ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291968 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SeeFusion vs. FusionReactor
Eep, sorry, my bad =) Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 11:17 AM To: CF-Talk Subject: Re: SeeFusion vs. FusionReactor The Server Monitor doesn't ship with CF8 Standard, hence why Ben is looking at alternatives. Andy ps Fusion Reactor gets my nod On 24/10/2007, Peterson, Chris [EMAIL PROTECTED] wrote: Ben - the integrated server monitor in CF8 was not enough to figure out the errors? (from the admin, check out server monitor on the left) I have FusionReactor on CF7 Ent, and I agree it is much cleaner than the demo I tried of SeeFusion. I have never had a problem with it. Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 10:46 AM To: CF-Talk Subject: SeeFusion vs. FusionReactor I'm about to invest in one of these, and I'm looking for advice and/or practical experience. We have several applications running, and we're trying to hunt down the source of site slowdowns. Is there an overriding reason to pick one over the other? I'm currently leaning toward FusionReactor -- it seems cleaner and easier to use. It is, of course, a bit more expensive. Is it worth the extra money? For reference, I'm running CF8 Standard on Win2k3 R2. --Ben Doom ~| 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:291970 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: programmatically add functions to a CFC
There is also doco and a good google group as well, so you don't have to speed dial me ;o) Yep, I'm subscribed there as well :) Obviously, I don't really mind if you don't want to use Transfer (or any other persistence framework) ;o), it may well not fit your needs, but I just think the logic is a bit skewed. Sounds a little like Not Invented Here syndrome ;o) There is more than a bit of that too! We do like to write our own code here. It gives us an automatic in-house expert on the application (whoever wrote it) and it's written using our coding standards, which makes it easier to mod for future updates. It definitely does eat up lots of developer time though -- I definitely agree there, but it does have benefits. Putting all sane business-decision logic aside, I would like to see if I can build it. Call it pride and the stupidity of youth, but I'm still learning what I can do and what I can't. When I started it, I knew it would be a fun project that would throw challenges at me along the way -- and it has! I knew I'd learn a lot -- and I have! I've picked up a few tricks that had just picked up Transfer and ran with it, I'd still be clue-less on. Of course one could argue that I'd learn new tricks by using Transfer too -- so that weakens my argument a little. /rant :) Umn... you can setup composite object relationships across manytomany, and have been able to since version 0.1... so I'm not sure what you mean there. If you want to query it, you can also do it with TQL.. which can auto join your m2m relationships for you as well... so not sure what you need there? Querying it is what I meant -- sorry for the confusion! What I'd love is a Get me a list/query/enum of all the Book records written by this Author method from within an Author object. As you noted, I could do it with TQL, or I could write my own decorator that has that method. What I'm trying to get set up though is a generic object that does all this *without* me having to write my own TQL or custom code! The relationship data is there -- why the need to custom-code it? That's really the core of what I'm trying to build If I know the schema, I should be able to dynamically build a decent CRUD application out of it. I doubt I'll get to the press-a-button-and-be-completly-done stage, but I'm confident that I can get pretty close (maybe only having to tweak skins and custom displays) to a completely built and skinned application. Jonathon ~| 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:291971 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SeeFusion vs. FusionReactor
I'm biased because SeeFusion is the only product I have used, but I wholeheartedly recommend it. (I have absolutely no affiliation with them) Unless you are simply interested in spending more money don't think SeeFusion is less of a product because it is cheaper. The latest version of SeeFusion uses a very slick Flex interface that allows constant streaming of stats among other things which I have found to be very easy to use. The active monitoring rules E-mail me before anyone even notices the servers have a problem Where I take SeeFusion to the bank is in the database logging. I have a separate database for my webserver stats which I aggregate via jobs every night and I can produce pretty nice trending reports at the end of the month. (I will send you an example of a report I made from SeeFusion data if you are interested) Even cooler is the API that is available to build your own monitoring interfaces using live SeeFusion data. I have a monitor I built that shows me every spid running on the database, the NAME of the user running it, and the page of the application they are on. I used the SeeFusion API to tie the web server info together with the database info via running spid and web server IP. Finally, I have never had a bad experience calling up for tech support. I bugged the crap out of them for a while, and they still kept answering the phones with a smile. lol Anyway, just my 2 cents. :) ~Brad -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 9:46 AM To: CF-Talk Subject: SeeFusion vs. FusionReactor I'm about to invest in one of these, and I'm looking for advice and/or practical experience. We have several applications running, and we're trying to hunt down the source of site slowdowns. Is there an overriding reason to pick one over the other? ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291967 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SeeFusion vs. FusionReactor
The Server Monitor doesn't ship with CF8 Standard, hence why Ben is looking at alternatives. Andy ps Fusion Reactor gets my nod On 24/10/2007, Peterson, Chris [EMAIL PROTECTED] wrote: Ben - the integrated server monitor in CF8 was not enough to figure out the errors? (from the admin, check out server monitor on the left) I have FusionReactor on CF7 Ent, and I agree it is much cleaner than the demo I tried of SeeFusion. I have never had a problem with it. Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 10:46 AM To: CF-Talk Subject: SeeFusion vs. FusionReactor I'm about to invest in one of these, and I'm looking for advice and/or practical experience. We have several applications running, and we're trying to hunt down the source of site slowdowns. Is there an overriding reason to pick one over the other? I'm currently leaning toward FusionReactor -- it seems cleaner and easier to use. It is, of course, a bit more expensive. Is it worth the extra money? For reference, I'm running CF8 Standard on Win2k3 R2. --Ben Doom ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291966 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam and dynamically-created SQL
What I believe happens is that two different statements will be compiled in the database, one that has two bind variables and one that has one. So you should get the same speed benefit, the database just treats them as two different statements. On 10/24/07, Ben Mueller [EMAIL PROTECTED] wrote: Posted this yesterday, but it didn't seem to go through... I became a convert to cfqueryparam, thanks to this list, about 2 months ago. Since then, I've wondered about this kind of statement (shortened here): cfquery SELECT username FROM user WHERE lastname = cfqueryparam type=varchar value=#mylastname# cfif len(myfirstname) AND cfqueryparam type=varchar value=#myfirstname# /cfif /cfquery Does the presence of the cfif block inside the SQL negate the speed benefits I would get from using cfqueryparam? I'm kind of hoping not, but guessing yes. Thanks in advance for the advice, Ben Mueller ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291975 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam and dynamically-created SQL
Thanks, all, for your replies. So, a follow-up question: will SQL create multiple prepared statements for each condition? If so, that's great. My fear is that it will only create 1 prepared statement for each cfquery block, so if the current statement doesn't match the previous statement, it would discard the previous one and create a new one. I have a bunch of queries that have 8 or more cfif conditions, almost all in the WHERE clause. Obviously, the more cfif conditions there are, the greater the likelihood that any one individual call won't match the previous one. I know cfqp is really good and all that, but this would be pretty annoying if I got no real performance benefit. Yes, to the extent that you are less likely to have another query with the same prepared statement (and the same execution plan, of course) that can be run again. Frankly, though, I wouldn't worry too much about that, since coding around that causes all kinds of problems. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291972 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: load balancing/failover and CF
On 10/24/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Tuesday 23 Oct 2007, [EMAIL PROTECTED] wrote: a previous job, we used a product called Coherence from tangosol (now owned by Oracle) (see http://www.tangosol.com/coherence-overview.jsp). the coherence box acts as a dedicated session variable repository in the cluster... Err, but then you need to load balence and cluster them as well ? well, nobody says you -need- to, but yes :) ideally the coherence box would have to be high availability as well, or it all kinda defeats the purpose. -- Charlie Griefer ...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291973 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SeeFusion vs. FusionReactor
As Andy and Morgan pointed out, CF8 standard does not come with a server monitor. Trust me -- I'd have already been using it if standard shipped with it! Thanks for the FR nod. --Ben Doom Peterson, Chris wrote: Ben - the integrated server monitor in CF8 was not enough to figure out the errors? (from the admin, check out server monitor on the left) I have FusionReactor on CF7 Ent, and I agree it is much cleaner than the demo I tried of SeeFusion. I have never had a problem with it. Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291979 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldspring error: what does this mean please?
On 10/24/07, Andrew Scott [EMAIL PROTECTED] wrote: Ok as a test I did what Mike is trying to do here locally. cfdump works fine with the setting of Disable access to internal ColdFusion Java components. You didn't test thoroughly enough. See Mark Mandel's comment: you can cfdump *some* things with that setting enabled but not all things. So that is not Mikes problem... Yup, definitely is. -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:291982 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
no such binding error
Has anyone ever gone to a cf site and seen No Such Binding? It does not happen server wide but it seems to happen to many sites at once randomly. In my application I am loading configuration from a database. To correct the problem I simply go into my admin and verify all connections under datasources and that seems to fix the problem. I really don't think this is a coding issue but I can't seem to figure out how to fix it or at least how to notify us so that our customers are not down.Below is the stack trace from exception log. Error,jrpp-200,10/24/07,11:47:21,ApplicationName,No such binding: ApplicationName The specific sequence of files included or processed is: E:\www\appname\index.cfm coldfusion.server.ServiceRuntimeException: No such binding: ApplicationName at coldfusion.server.jrun4.SqlExecutive.getDataSource(SqlExecutive.java :149) at coldfusion.sql.Executive.getDatasource(Executive.java:464) at coldfusion.sql.DataSrcImpl.validate(DataSrcImpl.java:64) at coldfusion.sql.SqlImpl.validate(SqlImpl.java:200) at coldfusion.tagext.sql.QueryTag.doStartTag(QueryTag.java:397) at cfApplication2ecfm272758846.runPage (E:\www\appname\Application.cfm:19) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:30) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:93) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.ClientScopePersistenceFilter.invoke( ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java :249) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java :527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable( JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable( ThreadPool.java:348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable( ThreadPool.java:451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable( ThreadPool.java:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291976 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfqueryparam and dynamically-created SQL
Try not to think about queryparam as a performance benefit so much, The performance increase isn't really anything that massive, think about it from a security perspective. Without cfqueryparam people will add, edit and remove content from your database, gain access to secure sections of your site, steal important information from you, names, address, credit card information and so on. queryparam really is important... _really_ important ... I can't stress that enough. Why is it that you find it annoying? Because of the extra few moments it takes to code? It really is worth that extra few seconds to wrap up all your dynamic parameters, once you get in to the habbit you won't even think twice about it. Rob -Original Message- From: Ben Mueller [mailto:[EMAIL PROTECTED] Sent: 24 October 2007 17:33 To: CF-Talk Subject: Re: cfqueryparam and dynamically-created SQL Thanks, all, for your replies. So, a follow-up question: will SQL create multiple prepared statements for each condition? If so, that's great. My fear is that it will only create 1 prepared statement for each cfquery block, so if the current statement doesn't match the previous statement, it would discard the previous one and create a new one. I have a bunch of queries that have 8 or more cfif conditions, almost all in the WHERE clause. Obviously, the more cfif conditions there are, the greater the likelihood that any one individual call won't match the previous one. I know cfqp is really good and all that, but this would be pretty annoying if I got no real performance benefit. Yes, to the extent that you are less likely to have another query with the same prepared statement (and the same execution plan, of course) that can be run again. Frankly, though, I wouldn't worry too much about that, since coding around that causes all kinds of problems. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| 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:291981 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SeeFusion vs. FusionReactor
Thanks for the advice. See questions and comments inline. Brad Wood wrote: I'm biased because SeeFusion is the only product I have used, but I wholeheartedly recommend it. (I have absolutely no affiliation with them) Unless you are simply interested in spending more money don't think SeeFusion is less of a product because it is cheaper. No, my preference for FusionReactor wasn't because SeeFusion was cheaper. The latest version of SeeFusion uses a very slick Flex interface that allows constant streaming of stats among other things which I have found to be very easy to use. Yes. However, the FusionReactor interface seems just as nice. The active monitoring rules E-mail me before anyone even notices the servers have a problem FusionReactor seems to have this as well. Where I take SeeFusion to the bank is in the database logging. I have a separate database for my webserver stats which I aggregate via jobs every night and I can produce pretty nice trending reports at the end of the month. (I will send you an example of a report I made from SeeFusion data if you are interested) I had difficulty understanding how I was supposed to get this running. Honestly, I didn't put much time into it. Even cooler is the API that is available to build your own monitoring interfaces using live SeeFusion data. I have a monitor I built that shows me every spid running on the database, the NAME of the user running it, and the page of the application they are on. I used the SeeFusion API to tie the web server info together with the database info via running spid and web server IP. Fair enough. I'm not sure I'd use that, though. But it is a damn nifty feature. Finally, I have never had a bad experience calling up for tech support. I bugged the crap out of them for a while, and they still kept answering the phones with a smile. lol This is IMHO a great recommendation. Service is very important to me. --Ben Doom ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291978 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam and dynamically-created SQL
If you are talking about whether, in the case of your multiple IF statement DSQL, to use or not use CFQP then I think there is only one answer; use CFQP! As I said before, if there is a performance boost in using CFQP over not using it, then that performance boost should still be valid. Also, all the arguments of security probably outweigh any performance issues there may be. If you are talking about finding an alternative to the multiple IF DSQL then I would say that if it is at all possible, then do it! I.e., in the example you gave, you could replace the CFIF with this: cfquery name=myname datasource=myDB SELECT email FROM user u WHERE country = cfqueryparam cfsqltype=cf_sql_varchar value=#somecountry# AND ( Len(cfqueryparam cfsqltype=cf_sql_varchar value=#somestate#) 0 OR state = cfqueryparam cfsqltype=cf_sql_varchar value=#somestate#) /cfif /cfquery Dom On 24/10/2007, Ben Mueller [EMAIL PROTECTED] wrote: Thanks, all, for your replies. So, a follow-up question: will SQL create multiple prepared statements for each condition? If so, that's great. My fear is that it will only create 1 prepared statement for each cfquery block, so if the current statement doesn't match the previous statement, it would discard the previous one and create a new one. I have a bunch of queries that have 8 or more cfif conditions, almost all in the WHERE clause. Obviously, the more cfif conditions there are, the greater the likelihood that any one individual call won't match the previous one. I know cfqp is really good and all that, but this would be pretty annoying if I got no real performance benefit. Yes, to the extent that you are less likely to have another query with the same prepared statement (and the same execution plan, of course) that can be run again. Frankly, though, I wouldn't worry too much about that, since coding around that causes all kinds of problems. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291983 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam and dynamically-created SQL
Oh my goodness me, still wrong! Should be:
SELECT email
FROM user u
WHERE country = cfqueryparam cfsqltype=cf_sql_varchar
value=#somecountry#
AND ( Len('cfqueryparam cfsqltype=cf_sql_varchar value=#somestate#') = 0
OR state = cfqueryparam cfsqltype=cf_sql_varchar value=#somestate#)
Phew!
Dom
On 24/10/2007, Dominic Watson [EMAIL PROTECTED] wrote:
Woops, I made a mistake in that SQL, should have been:
cfquery name=myname datasource=myDB
SELECT email
FROM user u
WHERE country = cfqueryparam cfsqltype=cf_sql_varchar
value=#somecountry#
AND ( Len(cfqueryparam cfsqltype=cf_sql_varchar value=#somestate#) =
0
OR state = cfqueryparam cfsqltype=cf_sql_varchar value=#somestate#)
/cfif
/cfquery
On 24/10/2007, Dominic Watson [EMAIL PROTECTED] wrote:
If you are talking about whether, in the case of your multiple IF
statement DSQL, to use or not use CFQP then I think there is only one
answer; use CFQP! As I said before, if there is a performance boost in using
CFQP over not using it, then that performance boost should still be valid.
Also, all the arguments of security probably outweigh any performance issues
there may be.
If you are talking about finding an alternative to the multiple IF DSQL
then I would say that if it is at all possible, then do it! I.e., in the
example you gave, you could replace the CFIF with this:
cfquery name=myname datasource=myDB
SELECT email
FROM user u
WHERE country = cfqueryparam cfsqltype=cf_sql_varchar
value=#somecountry#
AND ( Len(cfqueryparam cfsqltype=cf_sql_varchar value=#somestate#)
0
OR state = cfqueryparam cfsqltype=cf_sql_varchar
value=#somestate#)
/cfif
/cfquery
Dom
On 24/10/2007, Ben Mueller [EMAIL PROTECTED] wrote:
Thanks, all, for your replies. So, a follow-up question: will SQL
create multiple prepared statements for each condition? If so, that's
great. My fear is that it will only create 1 prepared statement for each
cfquery block, so if the current statement doesn't match the previous
statement, it would discard the previous one and create a new one.
I have a bunch of queries that have 8 or more cfif conditions,
almost all in the WHERE clause. Obviously, the more cfif conditions
there
are, the greater the likelihood that any one individual call won't match
the
previous one.
I know cfqp is really good and all that, but this would be pretty
annoying if I got no real performance benefit.
Yes, to the extent that you are less likely to have another query
with the
same prepared statement (and the same execution plan, of course) that
can be
run again. Frankly, though, I wouldn't worry too much about that,
since
coding around that causes all kinds of problems.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
~|
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:291985
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SeeFusion vs. FusionReactor
I'm about to invest in one of these, and I'm looking for advice and/or practical experience. We have several applications running, and we're trying to hunt down the source of site slowdowns. Is there an overriding reason to pick one over the other? Not really. I've used them both, and like them both. For what it's worth, I prefer SeeFusion for troubleshooting and FusionReactor for monitoring. I'm currently leaning toward FusionReactor -- it seems cleaner and easier to use. It is, of course, a bit more expensive. Is it worth the extra money? They are both inexpensive enough that if you prefer one to the other, you should get it. 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! ~| 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:291977 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF Mappings
Hi I have two separate applications running on the CF server CF MX 7.0.2 Standard. Currently both are using same set of custom tags/cfc frameworks. But I want them to use two separate copies of the CFC/custom tags. So that if I am working on one application's cfcs, it doesn't affect the other. How can i do so? Caan I create separate mappings per application? Please help. - k ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291986 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: SQL Help
I'm having a weird query issue with SQL server...
The following query inserts two rows into the query_results
table:
insert into ENQUIRE.dbo.QUERY_RESULTS ( QUERYID, ENTITY_ID )
SELECT DISTINCT 1933 AS QUERYID, A.ENTITY_ID
FROM BIOTAB1 A
inner join WEBREPORTS.dbo.TB912 TB912 on A.ENTITY_ID=TB912.ENTITYID
-- inner join WEBREPORTS.dbo.TB967 TB967 on A.ENTITY_ID=TB967.ENTITYID
WHERE 1=1
AND A.PRIMARY_RECORD_STATUS IN ('A','-')
AND EXISTS (
SELECT 1 FROM AFFIL X
WHERE X.ENTITY_ID = A.ENTITY_ID AND X.RECORD_TYPE IN ('TS')
)
AND
(
1=0 OR
(
1=1 and TB912.MAILCODE IN ('YAN')
-- ) OR (
-- 1=1 and TB967.EVENTCDE IN ('AF55')
)
)
That's correct behavior. If I run the select statement by
itself, it returns 2 records.
But if I uncomment the three lines that are commented out, the
query only inserts ONE record.
The SELECT statement run by itself (with the commented out
lines uncommented) returns two records.
Why won't it insert the two records?
I'm just running this stuff in SQL Server Management Studio,
but the results from Coldfusion are the same.
Rick
~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291974
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SeeFusion vs. FusionReactor
One other thing you might want to consider is the licensing. The last time I checked SeeFusion and FusionReactor were licensed in different ways. A SeeFusion license had to be purchased for each instance of ColdFusion running on the server. Whereas, one FusionReactor license was used per server (not instance). This locked in FusionReactor for us. At the time, FusionReactor cost us a little of $700 with a year update subscription. To do the same with SeeFusion we figured out our costs to be over $3000. Of course licensing may have changed since then (almost a year ago), but I'm happy with FusionReactor. Within 45 minutes of installing it, we found what was randomly crashing our server. A user found out how to fudge a url to pull down massive amounts of data. We corrected the code and booted the user. This after 4 weeks of trying to find the problem. Steve -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 12:07 PM To: CF-Talk Subject: Re: SeeFusion vs. FusionReactor Thanks for the advice. See questions and comments inline. Brad Wood wrote: I'm biased because SeeFusion is the only product I have used, but I wholeheartedly recommend it. (I have absolutely no affiliation with them) Unless you are simply interested in spending more money don't think SeeFusion is less of a product because it is cheaper. No, my preference for FusionReactor wasn't because SeeFusion was cheaper. The latest version of SeeFusion uses a very slick Flex interface that allows constant streaming of stats among other things which I have found to be very easy to use. Yes. However, the FusionReactor interface seems just as nice. The active monitoring rules E-mail me before anyone even notices the servers have a problem FusionReactor seems to have this as well. Where I take SeeFusion to the bank is in the database logging. I have a separate database for my webserver stats which I aggregate via jobs every night and I can produce pretty nice trending reports at the end of the month. (I will send you an example of a report I made from SeeFusion data if you are interested) I had difficulty understanding how I was supposed to get this running. Honestly, I didn't put much time into it. Even cooler is the API that is available to build your own monitoring interfaces using live SeeFusion data. I have a monitor I built that shows me every spid running on the database, the NAME of the user running it, and the page of the application they are on. I used the SeeFusion API to tie the web server info together with the database info via running spid and web server IP. Fair enough. I'm not sure I'd use that, though. But it is a damn nifty feature. Finally, I have never had a bad experience calling up for tech support. I bugged the crap out of them for a while, and they still kept answering the phones with a smile. lol This is IMHO a great recommendation. Service is very important to me. --Ben Doom ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291990 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfqueryparam and dynamically-created SQL
It did go through. Check the website, there have been several responses. http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:54002 Thanks, Eric Ben Mueller wrote: Posted this yesterday, but it didn't seem to go through... I became a convert to cfqueryparam, thanks to this list, about 2 months ago. Since then, I've wondered about this kind of statement (shortened here): cfquery SELECT username FROM user WHERE lastname = cfqueryparam type=varchar value=#mylastname# cfif len(myfirstname) AND cfqueryparam type=varchar value=#myfirstname# /cfif /cfquery Does the presence of the cfif block inside the SQL negate the speed benefits I would get from using cfqueryparam? I'm kind of hoping not, but guessing yes. Thanks in advance for the advice, Ben Mueller ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291980 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFZIP and CFINDEX
In the latest of my series of most likely unanswerable Verity questions, I have a question: Using CFINDEX, will Verity index supported document types in a Zip archive that is created using CFZIP? Followup, loosely related question, is there any undocumented CFZIP functionality that will allow me to ADD a new document to an existing zip archive? It seems odd that they would add the ability to delete from an archive, but not the ability to add to an archive. Thanks Pete ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291989 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam and dynamically-created SQL
Woops, I made a mistake in that SQL, should have been: cfquery name=myname datasource=myDB SELECT email FROM user u WHERE country = cfqueryparam cfsqltype=cf_sql_varchar value=#somecountry# AND ( Len(cfqueryparam cfsqltype=cf_sql_varchar value=#somestate#) = 0 OR state = cfqueryparam cfsqltype=cf_sql_varchar value=#somestate#) /cfif /cfquery On 24/10/2007, Dominic Watson [EMAIL PROTECTED] wrote: If you are talking about whether, in the case of your multiple IF statement DSQL, to use or not use CFQP then I think there is only one answer; use CFQP! As I said before, if there is a performance boost in using CFQP over not using it, then that performance boost should still be valid. Also, all the arguments of security probably outweigh any performance issues there may be. If you are talking about finding an alternative to the multiple IF DSQL then I would say that if it is at all possible, then do it! I.e., in the example you gave, you could replace the CFIF with this: cfquery name=myname datasource=myDB SELECT email FROM user u WHERE country = cfqueryparam cfsqltype=cf_sql_varchar value=#somecountry# AND ( Len(cfqueryparam cfsqltype=cf_sql_varchar value=#somestate#) 0 OR state = cfqueryparam cfsqltype=cf_sql_varchar value=#somestate#) /cfif /cfquery Dom On 24/10/2007, Ben Mueller [EMAIL PROTECTED] wrote: Thanks, all, for your replies. So, a follow-up question: will SQL create multiple prepared statements for each condition? If so, that's great. My fear is that it will only create 1 prepared statement for each cfquery block, so if the current statement doesn't match the previous statement, it would discard the previous one and create a new one. I have a bunch of queries that have 8 or more cfif conditions, almost all in the WHERE clause. Obviously, the more cfif conditions there are, the greater the likelihood that any one individual call won't match the previous one. I know cfqp is really good and all that, but this would be pretty annoying if I got no real performance benefit. Yes, to the extent that you are less likely to have another query with the same prepared statement (and the same execution plan, of course) that can be run again. Frankly, though, I wouldn't worry too much about that, since coding around that causes all kinds of problems. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291984 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 Mappings
You can on CF8. Otherwise you'll have to maintain two copies and adjust the paths used by the applications accordingly. Though I don't really see why you want to maintain a central set of files and at the same time not have the changes applied everywhere. It sounds like you don't really want central files at all. Further, unless you're making these changes on a live server (which of course would be discouraged in the strongest possible terms), why does it matter? Just refactor locally as needed, and when you have them ready, move them to production so that the changes get applied to all sites using the shared code. On 10/24/07, Web Exp [EMAIL PROTECTED] wrote: Hi I have two separate applications running on the CF server CF MX 7.0.2Standard. Currently both are using same set of custom tags/cfc frameworks. But I want them to use two separate copies of the CFC/custom tags. So that if I am working on one application's cfcs, it doesn't affect the other. How can i do so? Caan I create separate mappings per application? Please help. - k ~| 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:291991 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfqueryparam and dynamically-created SQL
Try not to think about queryparam as a performance benefit so much, The performance increase isn't really anything that massive, think about it from a security perspective. Without cfqueryparam people will add, edit and remove content from your database, gain access to secure sections of your site, steal important information from you, names, address, credit card information and so on. queryparam really is important... _really_ important ... I can't stress that enough. Why is it that you find it annoying? Because of the extra few moments it takes to code? It really is worth that extra few seconds to wrap up all your dynamic parameters, once you get in to the habbit you won't even think twice about it. I get the fact that it's important to prevent SQL injection attacks, etc etc. While I certainly see the value of that, I must admit that I'm not sold on cfqueryparam for that reason alone. Our web application tends to check incoming data before it even gets to a SQL statement. So, while I have started using cfqp everywhere, I probably wouldn't use it for security alone. Hate me if you must. (-; I am also interested in the performance benefit, and what would annoy me is if the presence of a cfif statement inside a cfquery block negated any performance benefit gained from cfqp. There are a few cases on our site where adding cfqp seems to have made a non-trivial difference in performance, and I would hate to think that in all other other places I use it, I may be doing more harm than good in terms of performance. (I'm only slightly annoyed by how verbose the tag is, but not enough to stop using it). Anyway, thanks all for the replies. ~| 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:291992 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfqueryparam and dynamically-created SQL
Thanks, all, for your replies. So, a follow-up question: will SQL create multiple prepared statements for each condition? If so, that's great. My fear is that it will only create 1 prepared statement for each cfquery block, so if the current statement doesn't match the previous statement, it would discard the previous one and create a new one. Execution plans are cached by your database server, not by your application server, so you'll just end up with more execution plans. CF just builds the statement and sends it to the database server. 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! ~| 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:291988 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: programmatically add functions to a CFC
On 10/24/07, Jonathon Stierman [EMAIL PROTECTED] wrote: Querying it is what I meant -- sorry for the confusion! What I'd love is a Get me a list/query/enum of all the Book records written by this Author method from within an Author object. As you noted, I could do it with TQL, or I could write my own decorator that has that method. What I'm trying to get set up though is a generic object that does all this *without* me having to write my own TQL or custom code! The relationship data is there -- why the need to custom-code it? That's really the core of what I'm trying to build If I know the schema, I should be able to dynamically build a decent CRUD application out of it. You can do this already. You just set up a one to many join in your Transfer configuration, and then when you have a Book you say something like getAuthorArray() (if you told Transfer that you want the relationship to use an array) and you get back an array of Author objects associated with the book. You don't need a decorator or TQL if you're just pulling related records. ~| 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:291987 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
How should SQL handle same named columns from different tables?
SELECT a.*, b.* FROM user a INNER JOIN userprefs b ON b.userid = a.userid WHERE username = 'bsmith' In the query there's a common column named 'userid'. Should the query retun 1) one column named userid 2) two columns named userid 3) two columns with some type of unique name for each I find that the CF8 'Microsoft Access with Unicode' driver does #3, which I hadn't seen before in other ODBC drivers. It returns two columns named 'a.userid' and 'b.userid'. ~| 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:291994 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX 7 - Jrun 100%
If you have access to the web server (remote desktop is great) then you get an extremely useful thread dump of the jrun server process using the steps described below... They talk about CF 6 but it applies to CF7 too. SUMMARY: Try to get a stack trace (technote 18339 - http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18339) When you see it start to spike, set focus to the DOS Window and hit Control+(Pause/Break) (not control-C which everyone does by instinct - that kills JRun). One thing: For 6.1 at least, you don't have to run jrun from the command line; if you change the service to interact with desktop and restart it, it will open a command window and you can ctrl-break in it to create the dumps, which go the one of the jrun log files. You need to be able to connect to the machine's desktop to use this approach though. Thanks Mark -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 23, 2007 11:58 AM To: CF-Talk Subject: CFMX 7 - Jrun 100% Hi, I'm running CFMX 7 on a Windows 2003 Server - Standard Edition. I upgraded from MX 6 using the upgrade procedure during the MX7 install. After installing, I disabled MX6 in services. All has been running great for some months now, at least 6. My problem is that the jrun.exe process has suddenly started running at 98% plus. I recalled this was a problem with MX6 so I decided to uninstall MX6, as I'm no longer using it. This promptly removed my cfide directories :/ I then tried reinstalling CFMX7 assuming this would give me the CFIDE, at which point I got a message suggesting that for an upgrade, the CFMX6 needs to be intalled. So, I have two questions: 1. What could be causing Jrun to be running at 98%+ ? 2. Do I HAVE to have CFMX6 installed to run my upgrade edition of MX7? Many thanks, Jenny ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291999 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 Mappings
If you have Coldfusion 8, you can create per-application mappings. Otherwise, you can make sub-folders inside your mappings. For example, I have a 'com' mapping. Then I make domain / company based subfolders, so I can have: Com.qualcomm Com.pcMiler Com.gainey You get the idea =) Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Web Exp [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 12:53 PM To: CF-Talk Subject: CF Mappings Hi I have two separate applications running on the CF server CF MX 7.0.2 Standard. Currently both are using same set of custom tags/cfc frameworks. But I want them to use two separate copies of the CFC/custom tags. So that if I am working on one application's cfcs, it doesn't affect the other. How can i do so? Caan I create separate mappings per application? Please help. - k ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292000 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfqueryparam and dynamically-created SQL
I'd think adding the OR like that would end up with a performance, a
insanely small one, drop just like a CFIFmight.
On 10/24/07, Dominic Watson [EMAIL PROTECTED] wrote:
Oh my goodness me, still wrong! Should be:
SELECT email
FROM user u
WHERE country = cfqueryparam cfsqltype=cf_sql_varchar
value=#somecountry#
AND ( Len('cfqueryparam cfsqltype=cf_sql_varchar value=#somestate#') =
0
OR state = cfqueryparam cfsqltype=cf_sql_varchar value=#somestate#)
Phew!
Dom
On 24/10/2007, Dominic Watson [EMAIL PROTECTED] wrote:
Woops, I made a mistake in that SQL, should have been:
cfquery name=myname datasource=myDB
SELECT email
FROM user u
WHERE country = cfqueryparam cfsqltype=cf_sql_varchar
value=#somecountry#
AND ( Len(cfqueryparam cfsqltype=cf_sql_varchar value=#somestate#)
=
0
OR state = cfqueryparam cfsqltype=cf_sql_varchar
value=#somestate#)
/cfif
/cfquery
On 24/10/2007, Dominic Watson [EMAIL PROTECTED] wrote:
If you are talking about whether, in the case of your multiple IF
statement DSQL, to use or not use CFQP then I think there is only one
answer; use CFQP! As I said before, if there is a performance boost in
using
CFQP over not using it, then that performance boost should still be
valid.
Also, all the arguments of security probably outweigh any performance
issues
there may be.
If you are talking about finding an alternative to the multiple IF
DSQL
then I would say that if it is at all possible, then do it! I.e., in
the
example you gave, you could replace the CFIF with this:
cfquery name=myname datasource=myDB
SELECT email
FROM user u
WHERE country = cfqueryparam cfsqltype=cf_sql_varchar
value=#somecountry#
AND ( Len(cfqueryparam cfsqltype=cf_sql_varchar
value=#somestate#)
0
OR state = cfqueryparam cfsqltype=cf_sql_varchar
value=#somestate#)
/cfif
/cfquery
Dom
On 24/10/2007, Ben Mueller [EMAIL PROTECTED] wrote:
Thanks, all, for your replies. So, a follow-up question: will SQL
create multiple prepared statements for each condition? If so,
that's
great. My fear is that it will only create 1 prepared statement for
each
cfquery block, so if the current statement doesn't match the
previous
statement, it would discard the previous one and create a new one.
I have a bunch of queries that have 8 or more cfif conditions,
almost all in the WHERE clause. Obviously, the more cfif
conditions there
are, the greater the likelihood that any one individual call won't
match the
previous one.
I know cfqp is really good and all that, but this would be pretty
annoying if I got no real performance benefit.
Yes, to the extent that you are less likely to have another query
with the
same prepared statement (and the same execution plan, of course)
that
can be
run again. Frankly, though, I wouldn't worry too much about that,
since
coding around that causes all kinds of problems.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
~|
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:291995
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 Mappings
Absolutely you can have independant mappings. I would have 1 mapping for components that should be shared between applications (in there own directory on the server). Then have individual mappings per application to a folder within the app root that has application specific components. Dom On 24/10/2007, Web Exp [EMAIL PROTECTED] wrote: Hi I have two separate applications running on the CF server CF MX 7.0.2Standard. Currently both are using same set of custom tags/cfc frameworks. But I want them to use two separate copies of the CFC/custom tags. So that if I am working on one application's cfcs, it doesn't affect the other. How can i do so? Caan I create separate mappings per application? Please help. - k ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292004 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfqueryparam and dynamically-created SQL
I get the fact that it's important to prevent SQL injection attacks, etc etc. While I certainly see the value of that, I must admit that I'm not sold on cfqueryparam for that reason alone. Our web application tends to check incoming data before it even gets to a SQL statement. So, while I have started using cfqp everywhere, I probably wouldn't use it for security alone. Hate me if you must. (-; It's one thing to check incoming data (not to mention tend to check said data) and another thing to separate data from SQL code, which is what CFQUERYPARAM does. The former is no substitute for the latter. 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! ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291996 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How should SQL handle same named columns from different tables?
You could check the specification for the version of SQL you're using. This may also depend on the version of Access you are using. In my experience, Access would return something along the lines of: [tablename].[columnname], such as: [a].[userid] [b].[userid] These could also be referenced as a.userid and b.userid respectively. When querying against SQL Server (from version 6.5 to 2005) in SQL itself I could, of course, reference the columns prefaced with their table name as you note. However, from ColdFusion (against a query object), that was not an option, and a reference to the duplicate column name would return the first appearing column's value (left-most in the recordset). In general, it is up to the developer to alias the columns so that they can be referenced appropriately in such a scenario. I also am not a fan of the * in queries. And, I wonder, in the example you have given, why this is an issue, since the values for the columns will be exactly the same? SELECT a.userid as a_user, b.userid b_user, a.*, b.* FROM user a INNER JOIN userprefs b ON b.userid = a.userid Cheers, Kris SELECT a.*, b.* FROM user a INNER JOIN userprefs b ON b.userid = a.userid WHERE username = 'bsmith' In the query there's a common column named 'userid'. Should the query retun 1) one column named userid 2) two columns named userid 3) two columns with some type of unique name for each I find that the CF8 'Microsoft Access with Unicode' driver does #3, which I hadn't seen before in other ODBC drivers. It returns two columns named 'a.userid' and 'b.userid'. ~| 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:292011 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam and dynamically-created SQL
But do you really need the quotes around the cfqp inside the len()
statement?
No you don't, yet another mistake!
I'd think adding the OR like that would end up with a performance, a
insanely small one, drop just like a CFIFmight.
I'd be interested to know the performance difference between doing that and
using CFIF to build the query. Any other solutions that would perform
faster?
I quite often do something similar with stored procs but usually with
numerical values, i.e. Default them to 0 in the proc and do 'where (@foo = 0
OR myCol = @foo)'. I'm quite sure that is faster than building a dynamic
query and sending it to the server.
Dominic
On 24/10/2007, Aaron Rouse [EMAIL PROTECTED] wrote:
I'd think adding the OR like that would end up with a performance, a
insanely small one, drop just like a CFIFmight.
On 10/24/07, Dominic Watson [EMAIL PROTECTED] wrote:
Oh my goodness me, still wrong! Should be:
SELECT email
FROM user u
WHERE country = cfqueryparam cfsqltype=cf_sql_varchar
value=#somecountry#
AND ( Len('cfqueryparam cfsqltype=cf_sql_varchar value=#somestate#')
=
0
OR state = cfqueryparam cfsqltype=cf_sql_varchar
value=#somestate#)
Phew!
Dom
On 24/10/2007, Dominic Watson [EMAIL PROTECTED] wrote:
Woops, I made a mistake in that SQL, should have been:
cfquery name=myname datasource=myDB
SELECT email
FROM user u
WHERE country = cfqueryparam cfsqltype=cf_sql_varchar
value=#somecountry#
AND ( Len(cfqueryparam cfsqltype=cf_sql_varchar
value=#somestate#)
=
0
OR state = cfqueryparam cfsqltype=cf_sql_varchar
value=#somestate#)
/cfif
/cfquery
On 24/10/2007, Dominic Watson [EMAIL PROTECTED]
wrote:
If you are talking about whether, in the case of your multiple IF
statement DSQL, to use or not use CFQP then I think there is only
one
answer; use CFQP! As I said before, if there is a performance boost
in
using
CFQP over not using it, then that performance boost should still be
valid.
Also, all the arguments of security probably outweigh any
performance
issues
there may be.
If you are talking about finding an alternative to the multiple IF
DSQL
then I would say that if it is at all possible, then do it! I.e., in
the
example you gave, you could replace the CFIF with this:
cfquery name=myname datasource=myDB
SELECT email
FROM user u
WHERE country = cfqueryparam cfsqltype=cf_sql_varchar
value=#somecountry#
AND ( Len(cfqueryparam cfsqltype=cf_sql_varchar
value=#somestate#)
0
OR state = cfqueryparam cfsqltype=cf_sql_varchar
value=#somestate#)
/cfif
/cfquery
Dom
On 24/10/2007, Ben Mueller [EMAIL PROTECTED] wrote:
Thanks, all, for your replies. So, a follow-up question: will
SQL
create multiple prepared statements for each condition? If so,
that's
great. My fear is that it will only create 1 prepared statement
for
each
cfquery block, so if the current statement doesn't match the
previous
statement, it would discard the previous one and create a new one.
I have a bunch of queries that have 8 or more cfif conditions,
almost all in the WHERE clause. Obviously, the more cfif
conditions there
are, the greater the likelihood that any one individual call won't
match the
previous one.
I know cfqp is really good and all that, but this would be pretty
annoying if I got no real performance benefit.
Yes, to the extent that you are less likely to have another query
with the
same prepared statement (and the same execution plan, of course)
that
can be
run again. Frankly, though, I wouldn't worry too much about that,
since
coding around that causes all kinds of problems.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292002
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFZIP and CFINDEX
Using CFINDEX, will Verity index supported document types in a Zip archive that is created using CFZIP? No. 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! ~| 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:291998 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Max Varchar Length
Thanks for your help, much clearer now :) ~| 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:292001 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SeeFusion vs. FusionReactor
Actually, the SeeFusion pricing is a little different then that. http://www.seefusion.com/index.cfm?do=c.whatsnew The last item on this page details their 2 for 1 pricing model. == New 2-for-1 pricing model for individual servers For any single physical server, every 2 ColdFusion instances that you want to monitor now require just 1 SeeFusion license. So for a server with 4 ColdFusion instances that you want to monitor, you'd need 2 SeeFusion licenses. Or, for 2 physical servers each with 2 ColdFusion instances you want to monitor, you'd also still only need 2 SeeFusion licenses. == ~Brad A SeeFusion license had to be purchased for each instance of ColdFusion running on the server. Whereas, one FusionReactor license was used per server (not instance). ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292005 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam and dynamically-created SQL
Oh my goodness me, still wrong! Should be:
SELECT email
FROM user u
WHERE country = cfqueryparam cfsqltype=cf_sql_varchar
value=#somecountry#
AND ( Len('cfqueryparam cfsqltype=cf_sql_varchar value=#somestate#') = 0
OR state = cfqueryparam cfsqltype=cf_sql_varchar value=#somestate#)
Phew!
Dom
Interesting idea, Dom. Thanks. But do you really need the quotes around the
cfqp inside the len() statement? I would think not.
Ben
~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291993
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFZIP and CFINDEX
On 10/24/07, Pete Ruckelshaus [EMAIL PROTECTED] wrote: In the latest of my series of most likely unanswerable Verity questions, I have a question: Using CFINDEX, will Verity index supported document types in a Zip archive that is created using CFZIP? Since CFZIP makes a standard zip - Verity should be able to work it. Multiple zip formats are listed in the supported documents section of the docs. Followup, loosely related question, is there any undocumented CFZIP functionality that will allow me to ADD a new document to an existing zip archive? It seems odd that they would add the ability to delete from an archive, but not the ability to add to an archive. You can add, you just use the Zip action again. It can update an existing zip. -- === Raymond Camden, Camden Media Email: [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| 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:292006 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How should SQL handle same named columns from different tables?
It returns two columns named 'a.userid' and 'b.userid'. That is the behavior I have always experienced in my 10 years of database driven web application development. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292003 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Mappings
Hi Chris, Can you explain what a com mapping is and how I can create it. I am using CF 7.0.2 Also, how will the CF Applications know which mapping to go to? On 10/24/07, Peterson, Chris [EMAIL PROTECTED] wrote: If you have Coldfusion 8, you can create per-application mappings. Otherwise, you can make sub-folders inside your mappings. For example, I have a 'com' mapping. Then I make domain / company based subfolders, so I can have: Com.qualcomm Com.pcMiler Com.gainey You get the idea =) Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Web Exp [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 12:53 PM To: CF-Talk Subject: CF Mappings Hi I have two separate applications running on the CF server CF MX 7.0.2 Standard. Currently both are using same set of custom tags/cfc frameworks. But I want them to use two separate copies of the CFC/custom tags. So that if I am working on one application's cfcs, it doesn't affect the other. How can i do so? Caan I create separate mappings per application? Please help. - k ~| 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:292009 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How should SQL handle same named columns from different tables?
On 10/24/07, Jim McAtee [EMAIL PROTECTED] wrote: SELECT a.*, b.* FROM user a INNER JOIN userprefs b ON b.userid = a.userid WHERE username = 'bsmith' In the query there's a common column named 'userid'. Should the query retun I'd probably avoid using * in an effort to remove the ambiguity. Then alias the column names. SELECT a.userID AS foo, b.userID AS bar, (other columns here) FROM ... (or, assuming they're the same value, just select one or the other, but not both) :) -- Charlie Griefer ...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed. ~| 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:291997 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfqueryparam and dynamically-created SQL
I quite often do something similar with stored procs but usually with numerical values, i.e. Default them to 0 in the proc and do 'where (@foo = 0 OR myCol = @foo)'. I'm quite sure that is faster than building a dynamic query and sending it to the server. Why are you quite sure? Have you done any load testing? Very often, things don't work out the way we might expect them to. 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! ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292012 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: programmatically add functions to a CFC
You can do this already. You just set up a one to many join in your Transfer configuration, and then when you have a Book you say something like getAuthorArray() Oh -- Well, that makes me look rather silly then, doesn't it! I'll run through the docs again and pay closer attention. I had cfdump'ed a TransferObject when I was testing, so I must have either set it up wrong in the configuration or missed the method. Jonathon -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 12:02 PM To: CF-Talk Subject: Re: programmatically add functions to a CFC On 10/24/07, Jonathon Stierman [EMAIL PROTECTED] wrote: Querying it is what I meant -- sorry for the confusion! What I'd love is a Get me a list/query/enum of all the Book records written by this Author method from within an Author object. As you noted, I could do it with TQL, or I could write my own decorator that has that method. What I'm trying to get set up though is a generic object that does all this *without* me having to write my own TQL or custom code! The relationship data is there -- why the need to custom-code it? That's really the core of what I'm trying to build If I know the schema, I should be able to dynamically build a decent CRUD application out of it. You can do this already. You just set up a one to many join in your Transfer configuration, and then when you have a Book you say something like getAuthorArray() (if you told Transfer that you want the relationship to use an array) and you get back an array of Author objects associated with the book. You don't need a decorator or TQL if you're just pulling related records. ~| 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:292007 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Max Varchar Length
SQL 2005 Varchar(MAX) Regards Dale Fraser http://learncf.com -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, 25 October 2007 12:35 AM To: CF-Talk Subject: RE: Max Varchar Length I believe in newer versions of MySQL, there is only varchar and it can range from 1 to the max length which I believe is 65534. LargeText is for 65535 up to around 10 or 15 million characters. -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 9:56 AM To: CF-Talk Subject: Max Varchar Length HI, Just wondering if anyone works with mysql and can help us understand this little issue. we understood that the maximum length for a varchar is 255. however we read somewhere that since mysql version 5.0.3 the varchar maximum length is 767. We have just been testing this theory and dont know why but the database is allowing us to alter a columns data type to varchar(5), if we set it to varchar(65535) it tells us it is too big and that we need to include a text data type instead. This is of course what we expected but we expected this error to occur way before we was allowed to insert varchar(5) and would have expected it on either varchar(256) or varchar(768) depending on the version we have Hope this makes sense and would really appreciate any help with understanding this and how to best use the text and varchar data types thanks ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292016 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF8 CFGRID bind problem on include
I'm running into an interesting problem. I'm working on a CFGrid
based data list that is going to be included on several different
pages. The grid is using the BIND feature to allow for AJAX sorting
and pagination.
The problem that I'm running in to - I moved the code into an include
and now I get the grid header and footer generated and the loading
icon is spinning but noting populates. I'm testing with a 5 column
table.
Here's the grid code:
cfgrid name=MyDataGrid bindonload=true sort=yes highlighthref=yes
griddataalign=left gridlines=yes selectmode=row
insertbutton=Add deletebutton=Delete
enabled=yes visible=yes format=html
bind=cfc:data.getdatalist({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection},'#arguments.Table#')
preservepageonsort=false
striperows=yes selectonload=false autowidth=false
cfloop from=1 to=#ListLen(arguments.ColumnList)# index=x
cfif x NEQ ListLen(arguments.ColumnList)
cfgridcolumn
name=#ListGetAt(arguments.ColumnList, x)# display=yes
header=#ListGetAt(arguments.HeaderList, x)#
dataalign=#ListGetAt(arguments.AlignList, x)#
width=#ListGetAt(arguments.WidthList, x)# /
cfelse
cfgridcolumn
name=#ListGetAt(arguments.ColumnList, x)#
header=#ListGetAt(arguments.HeaderList, x)# headeralign=center
dataalign=center width=#ListGetAt(arguments.WidthList, x)#
bold=no italic=no href=#arguments.pagename#
hrefkey=#arguments.KeyName# select=no display=yes
headerbold=no headeritalic=no /
/cfif
/cfloop
/cfgrid
The CFC being called is:
cffunction name=getdatalist access=remote output=no
cfargument name=page
cfargument name=pagesize
cfargument name=gridsortcolumn
cfargument name=gridsortdirection
cfargument name=table
cfstoredproc datasource=#application.dsn#
procedure=up_get_#arguments.Table#
cfprocresult name=DataResults
/cfstoredproc
cfquery name=DataResults dbtype=query
SELECT *, 'Edit/Delete' as ActionText
FROM DataResults
cfif len(trim(arguments.gridsortcolumn)) NEQ 0 OR
len(trim(arguments.gridsortdirection)) NEQ 0
ORDER BY #arguments.gridsortcolumn#
#arguments.gridsortdirection#
/cfif
/cfquery
cfreturn QueryConvertForGrid(DataResults, arguments.page,
arguments.pagesize)
/cffunction
The QoQ is there so I don't have to fuss with dynamic SQL in my stored
procedures.
Thoughts?
Hatton
~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292013
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFZIP and CFINDEX
That's not what I see here. I used cfzip to create a zip. I included the zip in a collection. When I searched against the collection, Verity found a match in my zip. On 10/24/07, Dave Watts [EMAIL PROTECTED] wrote: Using CFINDEX, will Verity index supported document types in a Zip archive that is created using CFZIP? No. 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! ~| 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:292015 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Working with CFGRID
Do you realise that the grid can just contain HTML. So if you want a red cell or similar font color=redstrongVALUE/strong/font Regards Dale Fraser http://learncf.com -Original Message- From: Anthony Doherty [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 October 2007 11:39 PM To: CF-Talk Subject: Re: Working with CFGRID thanks for that andrew but that allows me to format the data within the grid into different formats from the blog that i found (http://www.coldfusionjedi.com/index.cfm/2007/8/20/Custom-grid-renderers-wit h-CFGRID) maybe im using the wrong blog Yes there is. It is called custom rendering, and Ray Camdan has a tutorial on his blog that will help you with that. On 10/24/07, Anthony Doherty [EMAIL PROTECTED] wrote: i have created a cfgrid formatted to HTML i have also added the href=page.cfm hrefkey=ID to the column as well. The grid displays ok but when the rows are empty it shows a - in the blank rows were the data would be linked to the different page. is there a way to only hyperlink the rows with data in them so that the grid doesnt look as bad. Thanks ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292017 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Using ColdFusion to determine if user has Flash player?
Anyone know if this is possible through whatever means? My company currently uses Browserhawk to detect this, but we'd like to do away with BH (and the cost). Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| 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:292019 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How should SQL handle same named columns from different tables?
IIRC, it should actually error and force you either to pick one or give them unique names (a.userid as bob, b.userid as fred). Expecting Access to behave properly is like expecting teens not to drink. Sometimes it works, but most of the time, it's a mistake. --Ben Doom Jim McAtee wrote: SELECT a.*, b.* FROM user a INNER JOIN userprefs b ON b.userid = a.userid WHERE username = 'bsmith' In the query there's a common column named 'userid'. Should the query retun 1) one column named userid 2) two columns named userid 3) two columns with some type of unique name for each I find that the CF8 'Microsoft Access with Unicode' driver does #3, which I hadn't seen before in other ODBC drivers. It returns two columns named 'a.userid' and 'b.userid'. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292008 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfdocument and a bar code graphic
I am trying to create a pdf which will be the cover sheet for a job system. On the PDF is a bar code graphic, the problem is that, once the pdf is created, unless you view the pdf at about 30% scale, you either don't see the graphic or is looks faded. Has anyone had problems with graphics appearing on a PDF created by cfdocument. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292010 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFMX 7 - Jrun 100%
Many thanks all for replies on this. It turned out to be a rogue app messing up Jrun. I uploaded the cfide from another server and all appears to be well. Jenny -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: 23 October 2007 17:19 To: CF-Talk Subject: Re: CFMX 7 - Jrun 100% Lots of things could cause JRun to max out, including but not limited too; bad code or client variable clean up. Check your logs to see what's going on. No, you don't need to have CF6 installed to upgrade to 7. After you stick in your CF7 upgrade key, the install process should detect it's an upgrade and simply ask for your CF6 license key. Andy On 23/10/2007, Jenny Gavin-Wear [EMAIL PROTECTED] wrote: Hi, I'm running CFMX 7 on a Windows 2003 Server - Standard Edition. I upgraded from MX 6 using the upgrade procedure during the MX7 install. After installing, I disabled MX6 in services. All has been running great for some months now, at least 6. My problem is that the jrun.exe process has suddenly started running at 98% plus. I recalled this was a problem with MX6 so I decided to uninstall MX6, as I'm no longer using it. This promptly removed my cfide directories :/ I then tried reinstalling CFMX7 assuming this would give me the CFIDE, at which point I got a message suggesting that for an upgrade, the CFMX6 needs to be intalled. So, I have two questions: 1. What could be causing Jrun to be running at 98%+ ? 2. Do I HAVE to have CFMX6 installed to run my upgrade edition of MX7? Many thanks, Jenny ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292014 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 hosting recomendation ?
Check out EdgeWeb Hosting. The only way to go! -Original Message- From: Dan Crouch [mailto:[EMAIL PROTECTED] Sent: Sun 10/21/2007 7:20 PM To: CF-Talk Cc: Subject: Re: Coldfusion hosting recomendation ? I use CFDynamics for hosting a dedicated server as well. We have been with them for almost a year now and have had no problems. Speed for me has been excellent. The only complaint I have is that sometimes it seems like they shuffle some questions internally amongst the sales or support departments and they arent sure whose responsibility certain questions should go to. So sometimes it takes longer to get a question answered than I think it should. But I have never had an actual technical problem with the server or the network itself, it just seems like there is a slight problem with the way they are organized. It has never made me look for another host, I just think they could use some work on that part of the business. ~| 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:292023 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Returning and object from a Web Service
When calling a web service that I created (which is being used as a gateway), if I try to return an object I get an error that states org.xml.sax.SAXException: No deserializer for and then my object name. If I get the object and then return individual values from that object, it works fine. But if I try to return the whole object, I get the error. From Googling, I believe that I somehow have to some additional reference to the location of the object definition but I don't know where that would be. In the wsdl file? If this is the case, where in the file does it go? Can anyone point me in the right direction? Thanks, Dean -- __ Dean Lawrence, CIO/Partner Internet Data Technology 888.GET.IDT1 ext. 701 * fax: 888.438.4381 http://www.idatatech.com/ Corporate Internet Development and Marketing Specialists ~| 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:292018 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam and dynamically-created SQL
Why I believe it to be true (though quite open to it not being the case): 1. I believe stored procs are generally faster than sending the same query to SQL Server due to query optimisation(?) 2. Less data is being sent to the SQL server 3. Less CF application process before the code is run on the SQL server 4. WHERE @foo = 0 is a very simple instruction to process and I assume the server does a good job of optimising it ( I realise to assume makes an ass out of u and me) Would you think otherwise? Dom On 24/10/2007, Dave Watts [EMAIL PROTECTED] wrote: I quite often do something similar with stored procs but usually with numerical values, i.e. Default them to 0 in the proc and do 'where (@foo = 0 OR myCol = @foo)'. I'm quite sure that is faster than building a dynamic query and sending it to the server. Why are you quite sure? Have you done any load testing? Very often, things don't work out the way we might expect them to. 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! ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292020 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Returning and object from a Web Service
What version of CF? Does the object happen to be a CFC? CFC's are not serializable in CF 8. Try returning a struct of values if can. ~Brad -Original Message- From: Dean Lawrence [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 4:30 PM To: CF-Talk Subject: Returning and object from a Web Service When calling a web service that I created (which is being used as a gateway), if I try to return an object I get an error that states org.xml.sax.SAXException: No deserializer for and then my object name. If I get the object and then return individual values from that object, it works fine. But if I try to return the whole object, I get the error. From Googling, I believe that I somehow have to some additional reference to the location of the object definition but I don't know where that would be. In the wsdl file? If this is the case, where in the file does it go? Can anyone point me in the right direction? Thanks, Dean ~| 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:292025 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfqueryparam and dynamically-created SQL
Dom, To know this you have to test. SPs are marginally faster in most cases - and just like cfqueries they have to be well written. There is not enough of a boost in performance (when comparing SPs to well written queries using cfqueryparam to bind the data) to make a hard and fast rule that SPs are best practice in all cases - that's my .02. Having said that, in a team enviornment there is some division of labor benefits. -Mark -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 5:06 PM To: CF-Talk Subject: Re: cfqueryparam and dynamically-created SQL Why I believe it to be true (though quite open to it not being the case): 1. I believe stored procs are generally faster than sending the same query to SQL Server due to query optimisation(?) 2. Less data is being sent to the SQL server 3. Less CF application process before the code is run on the SQL server 4. WHERE @foo = 0 is a very simple instruction to process and I assume the server does a good job of optimising it ( I realise to assume makes an ass out of u and me) Would you think otherwise? Dom On 24/10/2007, Dave Watts [EMAIL PROTECTED] wrote: I quite often do something similar with stored procs but usually with numerical values, i.e. Default them to 0 in the proc and do 'where (@foo = 0 OR myCol = @foo)'. I'm quite sure that is faster than building a dynamic query and sending it to the server. Why are you quite sure? Have you done any load testing? Very often, things don't work out the way we might expect them to. 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! ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292024 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What can PHP do that CF can't?
bobby.. don't pick on Will ...and a laggard in every bunch ;)~ .:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com There is a wise-guy in every bunch ;)~ ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292022 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: what does this mean please?
Mark, I seriously haven't seen this before... Well you learn something new then. I was aware that anything to do internal would be stopped, but I have never come across a situation where this has happened. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: Mark Mandel [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 October 2007 5:11 PM To: CF-Talk Subject: Re: Coldspring error: what does this mean please? I wish I had kept an eye on this thread! Apologies to Mike - when working around the 'Disable Access to ColdFusion Java Objects' setting in CF8, I ran into the issue that you can't use cfdump on many things. On some things you can, and on other things you can't. The reason is this - by turning this setting on there is a security policy that goes into effect that restricts external access to anything that is coldfusion.* - which includes trying to access and / or interogate any class or classpath that uses that space. If you do a lot of CF/Java integration, you will quickly notice that you can't get to the CF classPath, if you want it, and trying to call ...getClass() (often through reflection) on CF objects causes the error that you just saw. I would expect that CFDUMP does call getClass / does some sort of java meta data introspection on the objects it is attempting to dump - which in turn throws this error, as it won't be allowed. This setting - while essential for Shared Hosts, is a pretty damn big sword that cuts through many things, including aspects of cfdump, access to CFCProxy and some other bits and pieces that I can't think of right now. I think in the coming months, we're going to hit various pieces of functionality that will be broken on shared servers because of this setting. Mark ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292028 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using ColdFusion to determine if user has Flash player?
Google Analytics will do it for free On 10/24/07, Andy Matthews [EMAIL PROTECTED] wrote: Anyone know if this is possible through whatever means? My company currently uses Browserhawk to detect this, but we'd like to do away with BH (and the cost). Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292021 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 and CFDUMP was: (Re: Coldspring error)
This issue has now morphed into another issue. I was getting an error which I thought was coldspring-caused but which actually turned out to be caused by the CFDUMP tag i was using to check the result. So i set about wanting to get hostmysite to change and allow access to internal java components in the CF8 only to find that setting is currently UNCHECKED. Correct me if i'm wrong, but that means all kinds of CFDUMP should be allowed, shouldnt they? What does that mean (if anything) to the theory that my error was caused by the CFDUMP tag not coldspring? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 10/25/07, Sean Corfield [EMAIL PROTECTED] wrote: On 10/24/07, Andrew Scott [EMAIL PROTECTED] wrote: Ok as a test I did what Mike is trying to do here locally. cfdump works fine with the setting of Disable access to internal ColdFusion Java components. You didn't test thoroughly enough. See Mark Mandel's comment: you can cfdump *some* things with that setting enabled but not all things. So that is not Mikes problem... Yup, definitely is. -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:292027 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Returning and object from a Web Service
Hi Brad, I'm running CF8 on Windows 2003 and yes it is a CFC. I can return structures, arrays, queries and single values, but I can't return the object itself. I can access the object from within the method and use it to populate the structures and values, but if I try to just return the object, it throws the error. Is there any additional attributes that I need to set to serialize the CFC in CF8? Thanks, Dean On 10/24/07, Brad Wood [EMAIL PROTECTED] wrote: What version of CF? Does the object happen to be a CFC? CFC's are not serializable in CF 8. Try returning a struct of values if can. ~Brad -Original Message- From: Dean Lawrence [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 4:30 PM To: CF-Talk Subject: Returning and object from a Web Service When calling a web service that I created (which is being used as a gateway), if I try to return an object I get an error that states org.xml.sax.SAXException: No deserializer for and then my object name. If I get the object and then return individual values from that object, it works fine. But if I try to return the whole object, I get the error. From Googling, I believe that I somehow have to some additional reference to the location of the object definition but I don't know where that would be. In the wsdl file? If this is the case, where in the file does it go? Can anyone point me in the right direction? Thanks, Dean ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292032 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
