Coldfusion is undefined
I have been trying to help a host provider who hosts one of my clients websites with troubleshooting this error. If you look at this link with IE: http://testing.mellinaassociates.com/test_richtext.cfm you will see the javascript error when you doubleclick the javascript error in the bottom left corner. The only difference between that page and this page: http://testing.mellinaassociates.com/test_no_richtext.cfm is richtext=true as a parameter in the textarea. The ISP says the cfide is in the mapping in coldfusion administrator. They also say they have a virtual directory pointing at the CFIDE directory pointing at the INETPUB pub directory on the windows server the site is on. They have verified that the AJAX directory exists. Any suggestions on what to tell them to try next? Thanks in advance for any help. Dawn ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345061 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Coldfusion is undefined
Regardless... this URL says otherwise http://testing.mellinaassociates.com/CFIDE/scripts/ajax/package/cfajax.js If they wee correct then this would pull up Javascript for the cfajax.js package. Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dawn Sekel [mailto:dawnt...@yahoo.com] Sent: Saturday, June 04, 2011 10:43 AM To: cf-talk Subject: Coldfusion is undefined I have been trying to help a host provider who hosts one of my clients websites with troubleshooting this error. If you look at this link with IE: http://testing.mellinaassociates.com/test_richtext.cfm you will see the javascript error when you doubleclick the javascript error in the bottom left corner. The only difference between that page and this page: http://testing.mellinaassociates.com/test_no_richtext.cfm is richtext=true as a parameter in the textarea. The ISP says the cfide is in the mapping in coldfusion administrator. They also say they have a virtual directory pointing at the CFIDE directory pointing at the INETPUB pub directory on the windows server the site is on. They have verified that the AJAX directory exists. Any suggestions on what to tell them to try next? Thanks in advance for any help. Dawn ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345062 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Coldfusion is undefined
Dawn, You might also let them know they are exposing the physical path of your site in their 404 error. This is a piece of information you do not really want public. -mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dawn Sekel [mailto:dawnt...@yahoo.com] Sent: Saturday, June 04, 2011 10:43 AM To: cf-talk Subject: Coldfusion is undefined I have been trying to help a host provider who hosts one of my clients websites with troubleshooting this error. If you look at this link with IE: http://testing.mellinaassociates.com/test_richtext.cfm you will see the javascript error when you doubleclick the javascript error in the bottom left corner. The only difference between that page and this page: http://testing.mellinaassociates.com/test_no_richtext.cfm is richtext=true as a parameter in the textarea. The ISP says the cfide is in the mapping in coldfusion administrator. They also say they have a virtual directory pointing at the CFIDE directory pointing at the INETPUB pub directory on the windows server the site is on. They have verified that the AJAX directory exists. Any suggestions on what to tell them to try next? Thanks in advance for any help. Dawn ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345063 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion is undefined
They are also opening their cfadmin to attack if they use the default CFIDE in the inetpub folder as stated. It is recommended to lock down the cfadmin, not make it available on every single site. On Sat, Jun 4, 2011 at 4:50 PM, Mark A. Kruger mkru...@cfwebtools.comwrote: Dawn, You might also let them know they are exposing the physical path of your site in their 404 error. This is a piece of information you do not really want public. -mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dawn Sekel [mailto:dawnt...@yahoo.com] Sent: Saturday, June 04, 2011 10:43 AM To: cf-talk Subject: Coldfusion is undefined I have been trying to help a host provider who hosts one of my clients websites with troubleshooting this error. If you look at this link with IE: http://testing.mellinaassociates.com/test_richtext.cfm you will see the javascript error when you doubleclick the javascript error in the bottom left corner. The only difference between that page and this page: http://testing.mellinaassociates.com/test_no_richtext.cfm is richtext=true as a parameter in the textarea. The ISP says the cfide is in the mapping in coldfusion administrator. They also say they have a virtual directory pointing at the CFIDE directory pointing at the INETPUB pub directory on the windows server the site is on. They have verified that the AJAX directory exists. Any suggestions on what to tell them to try next? Thanks in advance for any help. Dawn ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345064 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
web service image upload issue
I am working on a remote call cfc that will allow remote user to upload an image file. Should be pretty straight forward but I am finding that the image being saved is not quite right and therefore NFG. The remote call from my test cfm page is as follows... cfset filePath = C:\temp\rock3.jpg / cfset dataFile2 = FileRead(filePath) / !- Create a Base64 representation of this string. - cfset data64 = toBase64(dataFile2) !--- Convert string to binary. cfset binaryData = toBinary(data64) cfinvoke timeout=300 method=uploadImageFile returnvariable=results webservice=http://localdemo/billclix/billclix04.cfc?wsdl; cfinvokeargument name=pid value=113 cfinvokeargument name=buildID value=PetersTestPage01 cfinvokeargument name=email value=new...@testing.com cfinvokeargument name=pw value=pass123 cfinvokeargument name=imageToUpload value=#binaryData#/cfinvoke My simplified code on the cfc page is as follows... cfcomponent cffunction name=uploadImageFile access=remote output=no returntype=string cfargument name=imageToUpload type=binary required=no default= cfargument name=email type=string required=no default= cfargument name=pw type=string required=no default= cfargument name=pid type=string required=no default= cfargument name=buildID type=string required=no default= !--- Convert binary back to Base64. --- cfset imageToUpload2 = toBase64(arguments.imageToUpload) cffile action=write file=c:\BillClixIn\#arguments.pid#\rock3.jpg output=#ToBinary( ToBase64( arguments.imageToUpload ))# nameconflict=OVERWRITE / cfsavecontent variable=results resultImage Upload Done/result /cfsavecontent cfreturn results /cfcomponent As I said the saved image is NFG, when I open the image file in notepad and compare it to the original the source is 99.9% identical does anyone have any thoughts on why it is not 100% identical? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345065 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cf9 query not returning identityCol
I am frustrated. :( In the cf9 docs, it says that cfquery is supposed to return, in the result variable, the identity column value of the inserted record. However it is not working from me. Would one of you kind souls point out my mistake? cfquery datasource=someDsn name=insertRecord result=theResult INSERT INTO someTable ( firstName, lastName ) VALUES ( cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.firstName#, cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.lastName# ) /cfquery cfoutput#theResult.identityCol#/cfoutput When I run this, identityCol is not there. I am indeed using an autonumbering identity column in the database. Yes, I know I can just add a select to this query to get at it, but I really want this to work, dammit! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345066 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
I wanted to circle back and thank everyone who helped me on this thread. I did as Nathan described below, and it was immediately clear that the cfinvoke posts were not going out. After some painful troubleshooting and using a lot of very bad words, I figured out why. When using cfinvoke, you must pass ALL arguments specified in the wsdl -- even though they are not required by the service. I swear, I looked at the cf9 docs a bunch of times and never saw that! The good news is that you can pass unneeded arguments with omit=yes so you don't have to set their values. But how crazy is that? You are required to pass all arguments just so you can tell cfinvoke to omit them! In the end it all worked out, but what a pain in the arse! RR On Wed, May 25, 2011 at 8:57 AM, Nathan Mische nmis...@gmail.com wrote: On Tuesday, May 24, 2011, Robert Rhodes rrhode...@gmail.com wrote: I don't need to monitor between my computer and the application server. I need to monitor between the application server and a remote server across the web that hosts the web service. Adding the proxyserver and proxyport attributes to you cfinvoke call will proxy the request from the application server to the remote server through your local instance of Charles, allowing you to see the traffic. To simply things you may want to install Charles on your development server. Then you can set cfinvoke's proxyserver attribute to 127.0.0.1 and the proxyport to . If using SSL you will still need to configure the remote server in Charles and add the Chalres CA to ColdFusion key store. I have no control over the remote server and the folks that do are only marginally helpful. Worse, they are taking the position that this is a Coldfusion problem. All very frustrating. It can be a bit tricky to craft SOAP requests from CF, particularly if the remote service expects complex input. You may want to check out my chapter on web services and complex types in the ColdFusion Anthology, available on Google books: http://bit.ly/cfwebservices --Na ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345067 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFIDE weirdness in iis7
I am still grumpy about how 9.01 does not install nicely with IIS7 withouth first installing the IIS compatibility tools. But not I am having a new weirdness. I usually do not set virtual directories pointing to cfide and cfdocs. I get at the administrator on an admin site that is only available via vpn. When I installed the web connector on IIS7, it automatically added those virtual directories to a public facing web site, so I deleted them. But when you go to the admin login url, the form is still there (but the links to all the images are broken), and you can actually log into the cf admin from the public site. But those virtual directories are really deleted! What am I missing here? RR ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345068 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cf9 query not returning identityCol
It's theResult.generatedKey On Jun 4, 2011 4:46 PM, Robert Rhodes rrhode...@gmail.com wrote: I am frustrated. :( In the cf9 docs, it says that cfquery is supposed to return, in the result variable, the identity column value of the inserted record. However it is not working from me. Would one of you kind souls point out my mistake? cfquery datasource=someDsn name=insertRecord result=theResult INSERT INTO someTable ( firstName, lastName ) VALUES ( cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.firstName#, cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.lastName# ) /cfquery cfoutput#theResult.identityCol#/cfoutput When I run this, identityCol is not there. I am indeed using an autonumbering identity column in the database. Yes, I know I can just add a select to this query to get at it, but I really want this to work, dammit! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345069 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIDE weirdness in iis7
Look at the mappings in the CF Admin - that tells you and CF where the CFIDE folder is that it's actually using. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Jun 4, 2011, at 5:24 PM, Robert Rhodes wrote: I am still grumpy about how 9.01 does not install nicely with IIS7 withouth first installing the IIS compatibility tools. But not I am having a new weirdness. I usually do not set virtual directories pointing to cfide and cfdocs. I get at the administrator on an admin site that is only available via vpn. When I installed the web connector on IIS7, it automatically added those virtual directories to a public facing web site, so I deleted them. But when you go to the admin login url, the form is still there (but the links to all the images are broken), and you can actually log into the cf admin from the public site. But those virtual directories are really deleted! What am I missing here? RR ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345070 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIDE weirdness in iis7
You do need the CFIDE mapped on your sites if you use ANY of the ajax, CFFORM, applets, etc as these need to loads files form the CFIDE, it is also worth noting that even if you do not map to the master CFIDE on the site and instead create a copy with only the files you need CF itself still accesses the original folder for certain functions. This will probably only affect you if you use sandboxing though. On Sat, Jun 4, 2011 at 11:56 PM, Wil Genovese jugg...@trunkful.com wrote: Look at the mappings in the CF Admin - that tells you and CF where the CFIDE folder is that it's actually using. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Jun 4, 2011, at 5:24 PM, Robert Rhodes wrote: I am still grumpy about how 9.01 does not install nicely with IIS7 withouth first installing the IIS compatibility tools. But not I am having a new weirdness. I usually do not set virtual directories pointing to cfide and cfdocs. I get at the administrator on an admin site that is only available via vpn. When I installed the web connector on IIS7, it automatically added those virtual directories to a public facing web site, so I deleted them. But when you go to the admin login url, the form is still there (but the links to all the images are broken), and you can actually log into the cf admin from the public site. But those virtual directories are really deleted! What am I missing here? RR ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345071 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIDE weirdness in iis7
On Sat, Jun 4, 2011 at 5:24 PM, Robert Rhodes wrote: I am still grumpy about how 9.01 does not install nicely with IIS7 withouth first installing the IIS compatibility tools. FYI, on a clean installation of CF9.0.1 there is absolutely no need whatsoever to install the IIS6 compatibility tools. Simply run the CF9 installer and then immediately run the CF9.0.1 update installer. _THEN_ browse to the CF Administrator to finish the install. It truly is that simple. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345072 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIDE weirdness in iis7
aha! I see it now. Unfortunately, I can delete or change that mapping. :( On Sat, Jun 4, 2011 at 6:56 PM, Wil Genovese jugg...@trunkful.com wrote: Look at the mappings in the CF Admin - that tells you and CF where the CFIDE folder is that it's actually using. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Jun 4, 2011, at 5:24 PM, Robert Rhodes wrote: I am still grumpy about how 9.01 does not install nicely with IIS7 withouth first installing the IIS compatibility tools. But not I am having a new weirdness. I usually do not set virtual directories pointing to cfide and cfdocs. I get at the administrator on an admin site that is only available via vpn. When I installed the web connector on IIS7, it automatically added those virtual directories to a public facing web site, so I deleted them. But when you go to the admin login url, the form is still there (but the links to all the images are broken), and you can actually log into the cf admin from the public site. But those virtual directories are really deleted! What am I missing here? RR ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345073 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIDE weirdness in iis7
I always thought that cfide being available on a public site was a security risk, so I have done without, rolling my own as necessary. Is there a way to have it available and still be totally secure? On Sat, Jun 4, 2011 at 7:06 PM, Russ Michaels r...@michaels.me.uk wrote: You do need the CFIDE mapped on your sites if you use ANY of the ajax, CFFORM, applets, etc as these need to loads files form the CFIDE, it is also worth noting that even if you do not map to the master CFIDE on the site and instead create a copy with only the files you need CF itself still accesses the original folder for certain functions. This will probably only affect you if you use sandboxing though. On Sat, Jun 4, 2011 at 11:56 PM, Wil Genovese jugg...@trunkful.com wrote: Look at the mappings in the CF Admin - that tells you and CF where the CFIDE folder is that it's actually using. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Jun 4, 2011, at 5:24 PM, Robert Rhodes wrote: I am still grumpy about how 9.01 does not install nicely with IIS7 withouth first installing the IIS compatibility tools. But not I am having a new weirdness. I usually do not set virtual directories pointing to cfide and cfdocs. I get at the administrator on an admin site that is only available via vpn. When I installed the web connector on IIS7, it automatically added those virtual directories to a public facing web site, so I deleted them. But when you go to the admin login url, the form is still there (but the links to all the images are broken), and you can actually log into the cf admin from the public site. But those virtual directories are really deleted! What am I missing here? RR ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345074 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIDE weirdness in iis7
Oh yeah, I know. But if you set the connector to all sites, and you add a new site, they all go down until you remove the connector and reapply it. And even when you set the connector on a site by site basis (which is a pain), if you change the site's root directory (like when you are deploying a new version), cf stops working for that site and you have remove its connector and reapply it again. Another pain. I have chosen to go with the second approach, becuase at least it doesn;t take down all sites. I really don't want to install iis6 compatibility just to use Coldfusion. Adobe needs to fix this. On Sat, Jun 4, 2011 at 7:10 PM, Matt Quackenbush quackfu...@gmail.comwrote: On Sat, Jun 4, 2011 at 5:24 PM, Robert Rhodes wrote: I am still grumpy about how 9.01 does not install nicely with IIS7 withouth first installing the IIS compatibility tools. FYI, on a clean installation of CF9.0.1 there is absolutely no need whatsoever to install the IIS6 compatibility tools. Simply run the CF9 installer and then immediately run the CF9.0.1 update installer. _THEN_ browse to the CF Administrator to finish the install. It truly is that simple. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345075 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cf9 query not returning identityCol
That's for MYSQL. I am using SQL Server 2005. The docs say identityCol But I will give it a try.. Nope., didn't work. Thanks, though. :) On Sat, Jun 4, 2011 at 6:56 PM, Jason Durham jqdur...@gmail.com wrote: It's theResult.generatedKey On Jun 4, 2011 4:46 PM, Robert Rhodes rrhode...@gmail.com wrote: I am frustrated. :( In the cf9 docs, it says that cfquery is supposed to return, in the result variable, the identity column value of the inserted record. However it is not working from me. Would one of you kind souls point out my mistake? cfquery datasource=someDsn name=insertRecord result=theResult INSERT INTO someTable ( firstName, lastName ) VALUES ( cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.firstName#, cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.lastName# ) /cfquery cfoutput#theResult.identityCol#/cfoutput When I run this, identityCol is not there. I am indeed using an autonumbering identity column in the database. Yes, I know I can just add a select to this query to get at it, but I really want this to work, dammit! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345076 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cf9 query not returning identityCol
It works on SQL 2008. On Jun 4, 2011 6:35 PM, Robert Rhodes rrhode...@gmail.com wrote: That's for MYSQL. I am using SQL Server 2005. The docs say identityCol But I will give it a try.. Nope., didn't work. Thanks, though. :) On Sat, Jun 4, 2011 at 6:56 PM, Jason Durham jqdur...@gmail.com wrote: It's theResult.generatedKey On Jun 4, 2011 4:46 PM, Robert Rhodes rrhode...@gmail.com wrote: I am frustrated. :( In the cf9 docs, it says that cfquery is supposed to return, in the result variable, the identity column value of the inserted record. However it is not working from me. Would one of you kind souls point out my mistake? cfquery datasource=someDsn name=insertRecord result=theResult INSERT INTO someTable ( firstName, lastName ) VALUES ( cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.firstName#, cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.lastName# ) /cfquery cfoutput#theResult.identityCol#/cfoutput When I run this, identityCol is not there. I am indeed using an autonumbering identity column in the database. Yes, I know I can just add a select to this query to get at it, but I really want this to work, dammit! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345077 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cf9 query not returning identityCol
http://blog.bittersweetryan.com/2011/01/getting-generated-key-from-query-in.html. On Jun 4, 2011 6:40 PM, Jason Durham jqdur...@gmail.com wrote: It works on SQL 2008. On Jun 4, 2011 6:35 PM, Robert Rhodes rrhode...@gmail.com wrote: That's for MYSQL. I am using SQL Server 2005. The docs say identityCol But I will give it a try.. Nope., didn't work. Thanks, though. :) On Sat, Jun 4, 2011 at 6:56 PM, Jason Durham jqdur...@gmail.com wrote: It's theResult.generatedKey On Jun 4, 2011 4:46 PM, Robert Rhodes rrhode...@gmail.com wrote: I am frustrated. :( In the cf9 docs, it says that cfquery is supposed to return, in the result variable, the identity column value of the inserted record. However it is not working from me. Would one of you kind souls point out my mistake? cfquery datasource=someDsn name=insertRecord result=theResult INSERT INTO someTable ( firstName, lastName ) VALUES ( cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.firstName#, cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.lastName# ) /cfquery cfoutput#theResult.identityCol#/cfoutput When I run this, identityCol is not there. I am indeed using an autonumbering identity column in the database. Yes, I know I can just add a select to this query to get at it, but I really want this to work, dammit! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345078 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIDE weirdness in iis7
You can manually edit the neo-runtime.xml file and set the mapping to the proper location that way. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Jun 4, 2011, at 6:23 PM, Robert Rhodes wrote: aha! I see it now. Unfortunately, I can delete or change that mapping. :( On Sat, Jun 4, 2011 at 6:56 PM, Wil Genovese jugg...@trunkful.com wrote: Look at the mappings in the CF Admin - that tells you and CF where the CFIDE folder is that it's actually using. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Jun 4, 2011, at 5:24 PM, Robert Rhodes wrote: I am still grumpy about how 9.01 does not install nicely with IIS7 withouth first installing the IIS compatibility tools. But not I am having a new weirdness. I usually do not set virtual directories pointing to cfide and cfdocs. I get at the administrator on an admin site that is only available via vpn. When I installed the web connector on IIS7, it automatically added those virtual directories to a public facing web site, so I deleted them. But when you go to the admin login url, the form is still there (but the links to all the images are broken), and you can actually log into the cf admin from the public site. But those virtual directories are really deleted! What am I missing here? RR ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345079 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cf9 query not returning identityCol
It does work and thats the way to do it. Are you 100% it's an auto inc field? http://cookbooks.adobe.com/post_Generated_key___Get_the_ID_of_the_inserted_record-16593.html Paul. On Jun 5, 2011, at 9:35 AM, Robert Rhodes wrote: That's for MYSQL. I am using SQL Server 2005. The docs say identityCol But I will give it a try.. Nope., didn't work. Thanks, though. :) On Sat, Jun 4, 2011 at 6:56 PM, Jason Durham jqdur...@gmail.com wrote: It's theResult.generatedKey On Jun 4, 2011 4:46 PM, Robert Rhodes rrhode...@gmail.com wrote: I am frustrated. :( In the cf9 docs, it says that cfquery is supposed to return, in the result variable, the identity column value of the inserted record. However it is not working from me. Would one of you kind souls point out my mistake? cfquery datasource=someDsn name=insertRecord result=theResult INSERT INTO someTable ( firstName, lastName ) VALUES ( cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.firstName#, cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.lastName# ) /cfquery cfoutput#theResult.identityCol#/cfoutput When I run this, identityCol is not there. I am indeed using an autonumbering identity column in the database. Yes, I know I can just add a select to this query to get at it, but I really want this to work, dammit! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345080 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cf9 query not returning identityCol
Weird. Not working for me with cf9 and sql sever 2005. Identity Specification = Yes Is Identity = Yes Identity Increment 1 Identity Seed 1 On Sat, Jun 4, 2011 at 8:23 PM, Paul Kukiel pkuk...@gmail.com wrote: It does work and thats the way to do it. Are you 100% it's an auto inc field? http://cookbooks.adobe.com/post_Generated_key___Get_the_ID_of_the_inserted_record-16593.html Paul. On Jun 5, 2011, at 9:35 AM, Robert Rhodes wrote: That's for MYSQL. I am using SQL Server 2005. The docs say identityCol But I will give it a try.. Nope., didn't work. Thanks, though. :) On Sat, Jun 4, 2011 at 6:56 PM, Jason Durham jqdur...@gmail.com wrote: It's theResult.generatedKey On Jun 4, 2011 4:46 PM, Robert Rhodes rrhode...@gmail.com wrote: I am frustrated. :( In the cf9 docs, it says that cfquery is supposed to return, in the result variable, the identity column value of the inserted record. However it is not working from me. Would one of you kind souls point out my mistake? cfquery datasource=someDsn name=insertRecord result=theResult INSERT INTO someTable ( firstName, lastName ) VALUES ( cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.firstName#, cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.lastName# ) /cfquery cfoutput#theResult.identityCol#/cfoutput When I run this, identityCol is not there. I am indeed using an autonumbering identity column in the database. Yes, I know I can just add a select to this query to get at it, but I really want this to work, dammit! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cf9 query not returning identityCol
http://cookbooks.adobe.com/post_Getting_the_ID_of_the_Last_Record_Inserted_I nto_a-16522.html I'm curious as to the best way of doing this in CF7. Currently I do another query to find the last inserted ID, but this seems a long winded way of doing things. Jenny Gavin-Wear Fast Track eCommerce http://www.ftol-ecommerce.com/ -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: 05 June 2011 02:11 To: cf-talk Subject: Re: cf9 query not returning identityCol Weird. Not working for me with cf9 and sql sever 2005. Identity Specification = Yes Is Identity = Yes Identity Increment 1 Identity Seed 1 On Sat, Jun 4, 2011 at 8:23 PM, Paul Kukiel pkuk...@gmail.com wrote: It does work and thats the way to do it. Are you 100% it's an auto inc field? http://cookbooks.adobe.com/post_Generated_key___Get_the_ID_of_the_ inserted_record-16593.html Paul. On Jun 5, 2011, at 9:35 AM, Robert Rhodes wrote: That's for MYSQL. I am using SQL Server 2005. The docs say identityCol But I will give it a try.. Nope., didn't work. Thanks, though. :) On Sat, Jun 4, 2011 at 6:56 PM, Jason Durham jqdur...@gmail.com wrote: It's theResult.generatedKey On Jun 4, 2011 4:46 PM, Robert Rhodes rrhode...@gmail.com wrote: I am frustrated. :( In the cf9 docs, it says that cfquery is supposed to return, in the result variable, the identity column value of the inserted record. However it is not working from me. Would one of you kind souls point out my mistake? cfquery datasource=someDsn name=insertRecord result=theResult INSERT INTO someTable ( firstName, lastName ) VALUES ( cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.firstName#, cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.lastName# ) /cfquery cfoutput#theResult.identityCol#/cfoutput When I run this, identityCol is not there. I am indeed using an autonumbering identity column in the database. Yes, I know I can just add a select to this query to get at it, but I really want this to work, dammit! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345082 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cf9 query not returning identityCol
This is the way I have been doing it. I may have to keep doing it this way if I can't get result.identityCol to work the way it is supposed to: cfquery datasource=someDsn name=insertRecord INSERT INTO someTable ( firstName, lastName ) VALUES ( cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.firstName#, cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.lastName# ) SELECT Scope_Identity() AS ID /cfquery cfoutput#tinsertRecord.ID#/cfoutput It's a little more efficient than doing it with two separate querys. RR On Sat, Jun 4, 2011 at 10:12 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: http://cookbooks.adobe.com/post_Getting_the_ID_of_the_Last_Record_Inserted_I nto_a-16522.html I'm curious as to the best way of doing this in CF7. Currently I do another query to find the last inserted ID, but this seems a long winded way of doing things. Jenny Gavin-Wear Fast Track eCommerce http://www.ftol-ecommerce.com/ -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: 05 June 2011 02:11 To: cf-talk Subject: Re: cf9 query not returning identityCol Weird. Not working for me with cf9 and sql sever 2005. Identity Specification = Yes Is Identity = Yes Identity Increment 1 Identity Seed 1 On Sat, Jun 4, 2011 at 8:23 PM, Paul Kukiel pkuk...@gmail.com wrote: It does work and thats the way to do it. Are you 100% it's an auto inc field? http://cookbooks.adobe.com/post_Generated_key___Get_the_ID_of_the_ inserted_record-16593.html Paul. On Jun 5, 2011, at 9:35 AM, Robert Rhodes wrote: That's for MYSQL. I am using SQL Server 2005. The docs say identityCol But I will give it a try.. Nope., didn't work. Thanks, though. :) On Sat, Jun 4, 2011 at 6:56 PM, Jason Durham jqdur...@gmail.com wrote: It's theResult.generatedKey On Jun 4, 2011 4:46 PM, Robert Rhodes rrhode...@gmail.com wrote: I am frustrated. :( In the cf9 docs, it says that cfquery is supposed to return, in the result variable, the identity column value of the inserted record. However it is not working from me. Would one of you kind souls point out my mistake? cfquery datasource=someDsn name=insertRecord result=theResult INSERT INTO someTable ( firstName, lastName ) VALUES ( cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.firstName#, cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.lastName# ) /cfquery cfoutput#theResult.identityCol#/cfoutput When I run this, identityCol is not there. I am indeed using an autonumbering identity column in the database. Yes, I know I can just add a select to this query to get at it, but I really want this to work, dammit! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345083 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIDE weirdness in iis7
Will, thanks for the reply. I tried changing the mapping to the cfide directory in neo-runtime.xml, but it keeps reverting to its original path. I don't want to use the CFIDE that is in the wwwroot directory, but rather a copy of the directory in another location. RR On Sat, Jun 4, 2011 at 8:15 PM, Wil Genovese jugg...@trunkful.com wrote: You can manually edit the neo-runtime.xml file and set the mapping to the proper location that way. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Jun 4, 2011, at 6:23 PM, Robert Rhodes wrote: aha! I see it now. Unfortunately, I can delete or change that mapping. :( On Sat, Jun 4, 2011 at 6:56 PM, Wil Genovese jugg...@trunkful.com wrote: Look at the mappings in the CF Admin - that tells you and CF where the CFIDE folder is that it's actually using. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Jun 4, 2011, at 5:24 PM, Robert Rhodes wrote: I am still grumpy about how 9.01 does not install nicely with IIS7 withouth first installing the IIS compatibility tools. But not I am having a new weirdness. I usually do not set virtual directories pointing to cfide and cfdocs. I get at the administrator on an admin site that is only available via vpn. When I installed the web connector on IIS7, it automatically added those virtual directories to a public facing web site, so I deleted them. But when you go to the admin login url, the form is still there (but the links to all the images are broken), and you can actually log into the cf admin from the public site. But those virtual directories are really deleted! What am I missing here? RR ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIDE weirdness in iis7
On 5/06/2011 13:52, Robert Rhodes wrote: Will, thanks for the reply. I tried changing the mapping to the cfide directory in neo-runtime.xml, but it keeps reverting to its original path. make sure you do the edit with CF stopped as it writes its settings back to the file when you shut it down. -- Yours, Kym Kovan mbcomms.net.au ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345085 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cf9 query not returning identityCol
Thanks Robert :) -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: 05 June 2011 03:55 To: cf-talk Subject: Re: cf9 query not returning identityCol This is the way I have been doing it. I may have to keep doing it this way if I can't get result.identityCol to work the way it is supposed to: cfquery datasource=someDsn name=insertRecord INSERT INTO someTable ( firstName, lastName ) VALUES ( cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.firstName#, cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.lastName# ) SELECT Scope_Identity() AS ID /cfquery cfoutput#tinsertRecord.ID#/cfoutput It's a little more efficient than doing it with two separate querys. RR On Sat, Jun 4, 2011 at 10:12 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: http://cookbooks.adobe.com/post_Getting_the_ID_of_the_Last_Record_ Inserted_I nto_a-16522.html I'm curious as to the best way of doing this in CF7. Currently I do another query to find the last inserted ID, but this seems a long winded way of doing things. Jenny Gavin-Wear Fast Track eCommerce http://www.ftol-ecommerce.com/ -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: 05 June 2011 02:11 To: cf-talk Subject: Re: cf9 query not returning identityCol Weird. Not working for me with cf9 and sql sever 2005. Identity Specification = Yes Is Identity = Yes Identity Increment 1 Identity Seed 1 On Sat, Jun 4, 2011 at 8:23 PM, Paul Kukiel pkuk...@gmail.com wrote: It does work and thats the way to do it. Are you 100% it's an auto inc field? http://cookbooks.adobe.com/post_Generated_key___Get_the_ID_of_the_ inserted_record-16593.html Paul. On Jun 5, 2011, at 9:35 AM, Robert Rhodes wrote: That's for MYSQL. I am using SQL Server 2005. The docs say identityCol But I will give it a try.. Nope., didn't work. Thanks, though. :) On Sat, Jun 4, 2011 at 6:56 PM, Jason Durham jqdur...@gmail.com wrote: It's theResult.generatedKey On Jun 4, 2011 4:46 PM, Robert Rhodes rrhode...@gmail.com wrote: I am frustrated. :( In the cf9 docs, it says that cfquery is supposed to return, in the result variable, the identity column value of the inserted record. However it is not working from me. Would one of you kind souls point out my mistake? cfquery datasource=someDsn name=insertRecord result=theResult INSERT INTO someTable ( firstName, lastName ) VALUES ( cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.firstName#, cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.lastName# ) /cfquery cfoutput#theResult.identityCol#/cfoutput When I run this, identityCol is not there. I am indeed using an autonumbering identity column in the database. Yes, I know I can just add a select to this query to get at it, but I really want this to work, dammit! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345086 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: VPS Hosting
Many thanks for all the replies and information about VPS hosting. Jenny Gavin-Wear Fast Track eCommerce http://www.ftol-ecommerce.com/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345087 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIDE weirdness in iis7
Yes, I tried that. No luck. Actually, it's almost as if it is changed, but when I log into the Administrator, it reverts back then. I know that sounds crazy... On Sun, Jun 5, 2011 at 12:02 AM, Kym Kovan dev-li...@mbcomms.net.au wrote: On 5/06/2011 13:52, Robert Rhodes wrote: Will, thanks for the reply. I tried changing the mapping to the cfide directory in neo-runtime.xml, but it keeps reverting to its original path. make sure you do the edit with CF stopped as it writes its settings back to the file when you shut it down. -- Yours, Kym Kovan mbcomms.net.au ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345088 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIDE weirdness in iis7
Aha. The trick is to stop cf, rename the incorrect cfide, delete the web.config files, restart cf, load the administrator at its new location. On Sun, Jun 5, 2011 at 12:22 AM, Robert Rhodes rrhode...@gmail.com wrote: Yes, I tried that. No luck. Actually, it's almost as if it is changed, but when I log into the Administrator, it reverts back then. I know that sounds crazy... On Sun, Jun 5, 2011 at 12:02 AM, Kym Kovan dev-li...@mbcomms.net.auwrote: On 5/06/2011 13:52, Robert Rhodes wrote: Will, thanks for the reply. I tried changing the mapping to the cfide directory in neo-runtime.xml, but it keeps reverting to its original path. make sure you do the edit with CF stopped as it writes its settings back to the file when you shut it down. -- Yours, Kym Kovan mbcomms.net.au ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345089 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: VPS Hosting
We had the same problem with hosting.com. Hostmysite was great, but things seem to have fallen apart since the hosting.com merger. Problems shot up and support shot way down. +1 for Viviotech just left hosting.com for them -1,000,000 for Hosting.com - they went from awesome as hostmysite.com to the post merger loss of service as hosting.com Heck they even deleted one of my DBs because it's name wasn't the same as the name on my account, so they thought it was orphaned and toasted it with NO notice!! Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. Please consider the environment before printing this e-mail ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345090 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFIDE weirdness in iis7
There are a few things one needs to take into consideration when doing sandboxing and ORM as well as with the CFIDE, most hosting providers will setup a safe version of the CFIDE mapping for you. But what if you are looking at doing this yourself? http://www.andyscott.id.au/2011/4/18/ColdFusion-ORM-Event-Handling-and-a-pro blem-with-shared-hosting And things to know when installing ColdFusion 9.01 and some pitfalls people may come across. http://www.andyscott.id.au/2011/3/29/Things-to-know-when-installing-ColdFusi on-9-then-updating-to-901 Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: Sunday, 5 June 2011 9:30 AM To: cf-talk Subject: Re: CFIDE weirdness in iis7 Oh yeah, I know. But if you set the connector to all sites, and you add a new site, they all go down until you remove the connector and reapply it. And even when you set the connector on a site by site basis (which is a pain), if you change the site's root directory (like when you are deploying a new version), cf stops working for that site and you have remove its connector and reapply it again. Another pain. I have chosen to go with the second approach, becuase at least it doesn;t take down all sites. I really don't want to install iis6 compatibility just to use Coldfusion. Adobe needs to fix this. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIDE weirdness in iis7
Andrew, your post on the cf9.01 install problem hits the nail on the head. I have been complaining about this since I first got cf9.01 running. I talked with Adobe tech support, but they could not seem to grasp why I did not want to install IIS 6 compatibility. Therefore, they don't see this as a problem. So we should not hold our breath for a solution. RR Your other pose was an interesting read too On Sun, Jun 5, 2011 at 12:50 AM, Andrew Scott andr...@andyscott.id.auwrote: There are a few things one needs to take into consideration when doing sandboxing and ORM as well as with the CFIDE, most hosting providers will setup a safe version of the CFIDE mapping for you. But what if you are looking at doing this yourself? http://www.andyscott.id.au/2011/4/18/ColdFusion-ORM-Event-Handling-and-a-pro blem-with-shared-hosting And things to know when installing ColdFusion 9.01 and some pitfalls people may come across. http://www.andyscott.id.au/2011/3/29/Things-to-know-when-installing-ColdFusi on-9-then-updating-to-901 Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: Sunday, 5 June 2011 9:30 AM To: cf-talk Subject: Re: CFIDE weirdness in iis7 Oh yeah, I know. But if you set the connector to all sites, and you add a new site, they all go down until you remove the connector and reapply it. And even when you set the connector on a site by site basis (which is a pain), if you change the site's root directory (like when you are deploying a new version), cf stops working for that site and you have remove its connector and reapply it again. Another pain. I have chosen to go with the second approach, becuase at least it doesn;t take down all sites. I really don't want to install iis6 compatibility just to use Coldfusion. Adobe needs to fix this. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345092 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm