Re: [ACFUG Discuss] Date Range query problems
Have you tried using thisdate between startdate and enddate? Donna Quoting "Singles Concepts, Inc." <[EMAIL PROTECTED]>: Hey Group Members, I hope this question finds you in good spirits this evening. I'm having trouble creating an elegant calendar query to handle multi-day events. For example, I'm now storing startdate and enddate. Saythe event runs from yesterday until tomorrow. When querying for today, neither date is within the parameter. My current solution is something like this: where startdate = #thisdate# OR enddate = #thisdate# OR (startdate < #thisdate# and enddate > #thisdate#) Any suggestions on displaying records within a date range? Thanks Michael Won't worry, be happy! - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - -- Donna M. Martin Applications Dev/Analyst, Sr Pathology Dept, Emory University 404 727-5918 Phone - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] Date Range query problems
Hey Group Members, I hope this question finds you in good spirits this evening. I'm having trouble creating an elegant calendar query to handle multi-day events. For example, I'm now storing startdate and enddate. Saythe event runs from yesterday until tomorrow. When querying for today, neither date is within the parameter. My current solution is something like this: where startdate = #thisdate# OR enddate = #thisdate# OR (startdate < #thisdate# and enddate > #thisdate#) Any suggestions on displaying records within a date range? Thanks Michael Won't worry, be happy! - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: Re: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista Enterprise x86
Yeah this boils down to the fact that you need the newer mod_jrun for apache... FYI you have to compile it on anything other than windows. I wrote up a blog post on how to do this if anyone is interested. On 11/15/06, John Lyons <[EMAIL PROTECTED]> wrote: stop cfmx remove wsconfgi jar replace with new jar start run the java applet remove the current webserver configuration add new configuration restart apache and it should work i can get tthe exact steps tonight if youd like that. Mike Staver wrote: > When you say remove the old configuration - you mean the wsconfig.jar > file and the modules it creates? I used 7.0.2's wsconfig.jar file and > the one from the hotfix to pull the modules out of, and neither worked > for me on vista. > > John Lyons wrote: >> It works I am running 2.2 and cfmx 7.02 on my box right now. you >> have to remove the old configuration and add a new one. >> >> >> Mike Staver wrote: >>> I'd also like to add that after a few hours of banging my head on my >>> desk with Apache 2.2, it does not appear that CFMX 7 on windows will >>> work with Apache 2.2, even with this hotfix: >>> >>> http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=8001e97 >>> >>> They apparently fixed it for Linux/Unix, but the connector is still >>> not working on Windows. No biggie for me though, I rolled back to >>> Apache 2.0.59 and I now have CFMX7 running on Vista :) >>> >>> Thanks again Steven for hitting me over the head with a clue stick >>> and reminding me of this option! >>> >>> Steven Ross wrote: If you cant figure it out you can always run apache On 11/14/06, Mike Staver <[EMAIL PROTECTED]> wrote: > I don't think it's setup right. Attached is a screen shot of what I > see. I'm not sure what I should put here. > > Justin Haygood wrote: > > Do you have .cfm associated with the ColdFusion / JRun ISAPI > handler > > and/or CGI process? (not sure which is used for CFM)? > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike > Staver > > Sent: Tuesday, November 14, 2006 5:35 PM > > To: discussion@acfug.org > > Subject: Re: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista > > Enterprise x86 > > > > Thanks for the input - I thought about doing that as well > yesterday, so > > I made the change today. However, now IIS just serves up the > page for > > download rather than parsing it with CFMX. I have a feeling I'm > SOL > > until an update gets released, if one does at all. I'll be using > > virtual machines for this stuff I think until then. > > > > Damon wrote: > >> I do not have Vista and this may be a log shot but you can try > to add > > a MIME > >> type in IIS (IIS 6 you right click the computer name in the IIS > > manager and > >> go to properties, not sure for IIS 7) of .CFM for extension and > >> cfm-application/octet-stream for mime type. This should at > least let > > IIS > >> serve up the cfm. > >> > >> Just a guess > >> -Damon Ledet > >> > >> -Original Message- > >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike > > Staver > >> Sent: Monday, November 13, 2006 6:41 PM > >> To: discussion@acfug.org > >> Subject: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista > > Enterprise > >> x86 > >> > >> I'm going to go out on a limb here and assume that nobody has > tried > > this > >> yet, but I have the final release of Windows Vista Enterprise > that was > >> released to manufacturing running on my workstation now. It's a > > completely > >> fresh install, and I attempted to install CFMX 7.0.2 on it to > run with > > IIS > >> 7. As you might assume, it doesn't work. I'm running the > >> x86 version, rather than the x64 in the hopes more things work > with > > it. > >> I've been wrong with that guess mostly for a lot of apps. > >> > >> Below is what IIS spits out: > >> > > > > > > -- > >> Server Error in Application "Default Web Site" > >> HTTP Error 404.3 - Not Found > >> > >> Description: The page you are requesting cannot be served > because of > > the > >> Multipurpose Internet Mail Extensions (MIME) map policy that is > > configured > >> on the Web server. The page you requested has a file name > extension > > that is > >> not recognized, and is not allowed. > >> > >> Error Code: 0x80070032 > >> > >> Notification: ExecuteRequestHandler > >> > >> Module: StaticFileModule > >> > >> Requested URL: http://127.0.0.1:80/CFIDE/administrator/index.cfm > >> > >> Physical Path: C:\inetpub\wwwroot\CFIDE\administrator\index.cfm > >> > >> Logon User
Re: Re: Re: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista Enterprise x86
sorry here is the link to the jar http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=8001e97 On 11/15/06, Steven Ross <[EMAIL PROTECTED]> wrote: Yeah this boils down to the fact that you need the newer mod_jrun for apache... FYI you have to compile it on anything other than windows. I wrote up a blog post on how to do this if anyone is interested. On 11/15/06, John Lyons <[EMAIL PROTECTED]> wrote: > stop cfmx > remove wsconfgi jar > replace with new jar > start > run the java applet remove the current webserver configuration > add new configuration > restart apache > and it should work i can get tthe exact steps tonight if youd like that. > > > Mike Staver wrote: > > When you say remove the old configuration - you mean the wsconfig.jar > > file and the modules it creates? I used 7.0.2's wsconfig.jar file and > > the one from the hotfix to pull the modules out of, and neither worked > > for me on vista. > > > > John Lyons wrote: > >> It works I am running 2.2 and cfmx 7.02 on my box right now. you > >> have to remove the old configuration and add a new one. > >> > >> > >> Mike Staver wrote: > >>> I'd also like to add that after a few hours of banging my head on my > >>> desk with Apache 2.2, it does not appear that CFMX 7 on windows will > >>> work with Apache 2.2, even with this hotfix: > >>> > >>> http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=8001e97 > >>> > >>> They apparently fixed it for Linux/Unix, but the connector is still > >>> not working on Windows. No biggie for me though, I rolled back to > >>> Apache 2.0.59 and I now have CFMX7 running on Vista :) > >>> > >>> Thanks again Steven for hitting me over the head with a clue stick > >>> and reminding me of this option! > >>> > >>> Steven Ross wrote: > If you cant figure it out you can always run apache > > On 11/14/06, Mike Staver <[EMAIL PROTECTED]> wrote: > > I don't think it's setup right. Attached is a screen shot of what I > > see. I'm not sure what I should put here. > > > > Justin Haygood wrote: > > > Do you have .cfm associated with the ColdFusion / JRun ISAPI > > handler > > > and/or CGI process? (not sure which is used for CFM)? > > > > > > -Original Message- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike > > Staver > > > Sent: Tuesday, November 14, 2006 5:35 PM > > > To: discussion@acfug.org > > > Subject: Re: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista > > > Enterprise x86 > > > > > > Thanks for the input - I thought about doing that as well > > yesterday, so > > > I made the change today. However, now IIS just serves up the > > page for > > > download rather than parsing it with CFMX. I have a feeling I'm > > SOL > > > until an update gets released, if one does at all. I'll be using > > > virtual machines for this stuff I think until then. > > > > > > Damon wrote: > > >> I do not have Vista and this may be a log shot but you can try > > to add > > > a MIME > > >> type in IIS (IIS 6 you right click the computer name in the IIS > > > manager and > > >> go to properties, not sure for IIS 7) of .CFM for extension and > > >> cfm-application/octet-stream for mime type. This should at > > least let > > > IIS > > >> serve up the cfm. > > >> > > >> Just a guess > > >> -Damon Ledet > > >> > > >> -Original Message- > > >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike > > > Staver > > >> Sent: Monday, November 13, 2006 6:41 PM > > >> To: discussion@acfug.org > > >> Subject: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista > > > Enterprise > > >> x86 > > >> > > >> I'm going to go out on a limb here and assume that nobody has > > tried > > > this > > >> yet, but I have the final release of Windows Vista Enterprise > > that was > > >> released to manufacturing running on my workstation now. It's a > > > completely > > >> fresh install, and I attempted to install CFMX 7.0.2 on it to > > run with > > > IIS > > >> 7. As you might assume, it doesn't work. I'm running the > > >> x86 version, rather than the x64 in the hopes more things work > > with > > > it. > > >> I've been wrong with that guess mostly for a lot of apps. > > >> > > >> Below is what IIS spits out: > > >> > > > > > > > > > > -- > > >> Server Error in Application "Default Web Site" > > >> HTTP Error 404.3 - Not Found > > >> > > >> Description: The page you are requesting cannot be served > > because of > > > the > > >> Multipurpose Internet Mail Extensions (MIME) map policy that is > > > configured > > >> on the Web server. The page you requested has a file name > > extension > >
Re: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista Enterprise x86
stop cfmx remove wsconfgi jar replace with new jar start run the java applet remove the current webserver configuration add new configuration restart apache and it should work i can get tthe exact steps tonight if youd like that. Mike Staver wrote: When you say remove the old configuration - you mean the wsconfig.jar file and the modules it creates? I used 7.0.2's wsconfig.jar file and the one from the hotfix to pull the modules out of, and neither worked for me on vista. John Lyons wrote: It works I am running 2.2 and cfmx 7.02 on my box right now. you have to remove the old configuration and add a new one. Mike Staver wrote: I'd also like to add that after a few hours of banging my head on my desk with Apache 2.2, it does not appear that CFMX 7 on windows will work with Apache 2.2, even with this hotfix: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=8001e97 They apparently fixed it for Linux/Unix, but the connector is still not working on Windows. No biggie for me though, I rolled back to Apache 2.0.59 and I now have CFMX7 running on Vista :) Thanks again Steven for hitting me over the head with a clue stick and reminding me of this option! Steven Ross wrote: If you cant figure it out you can always run apache On 11/14/06, Mike Staver <[EMAIL PROTECTED]> wrote: I don't think it's setup right. Attached is a screen shot of what I see. I'm not sure what I should put here. Justin Haygood wrote: > Do you have .cfm associated with the ColdFusion / JRun ISAPI handler > and/or CGI process? (not sure which is used for CFM)? > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Staver > Sent: Tuesday, November 14, 2006 5:35 PM > To: discussion@acfug.org > Subject: Re: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista > Enterprise x86 > > Thanks for the input - I thought about doing that as well yesterday, so > I made the change today. However, now IIS just serves up the page for > download rather than parsing it with CFMX. I have a feeling I'm SOL > until an update gets released, if one does at all. I'll be using > virtual machines for this stuff I think until then. > > Damon wrote: >> I do not have Vista and this may be a log shot but you can try to add > a MIME >> type in IIS (IIS 6 you right click the computer name in the IIS > manager and >> go to properties, not sure for IIS 7) of .CFM for extension and >> cfm-application/octet-stream for mime type. This should at least let > IIS >> serve up the cfm. >> >> Just a guess >> -Damon Ledet >> >> -Original Message- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike > Staver >> Sent: Monday, November 13, 2006 6:41 PM >> To: discussion@acfug.org >> Subject: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista > Enterprise >> x86 >> >> I'm going to go out on a limb here and assume that nobody has tried > this >> yet, but I have the final release of Windows Vista Enterprise that was >> released to manufacturing running on my workstation now. It's a > completely >> fresh install, and I attempted to install CFMX 7.0.2 on it to run with > IIS >> 7. As you might assume, it doesn't work. I'm running the >> x86 version, rather than the x64 in the hopes more things work with > it. >> I've been wrong with that guess mostly for a lot of apps. >> >> Below is what IIS spits out: >> > > -- >> Server Error in Application "Default Web Site" >> HTTP Error 404.3 - Not Found >> >> Description: The page you are requesting cannot be served because of > the >> Multipurpose Internet Mail Extensions (MIME) map policy that is > configured >> on the Web server. The page you requested has a file name extension > that is >> not recognized, and is not allowed. >> >> Error Code: 0x80070032 >> >> Notification: ExecuteRequestHandler >> >> Module: StaticFileModule >> >> Requested URL: http://127.0.0.1:80/CFIDE/administrator/index.cfm >> >> Physical Path: C:\inetpub\wwwroot\CFIDE\administrator\index.cfm >> >> Logon User: Anonymous >> >> Logon Method: Anonymous >> >> Handler: StaticFile >> >> Most likely causes: >> >> * It is possible that a handler mapping is missing. By default, > the >> static file handler processes all content. >> * The feature you are trying to use may not be installed. >> * The appropriate MIME map is not enabled for the Web site or >> application. (Warning: Do not create a MIME map for content that users >> should not download, such as .ASPX pages or .config files.) >> >> What you can try: >> >> * In system.webServer/handlers: >> * Ensure that the expected handler for the current page is > mapped. >> * Pay careful attention to preconditions (e.g. runtimeVersion, >> pipelineMode, bitness) and compare them to the settings for your > application >> pool. >> * Pay careful attention to typographical errors in the expe
Re: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista Enterprise x86
When you say remove the old configuration - you mean the wsconfig.jar file and the modules it creates? I used 7.0.2's wsconfig.jar file and the one from the hotfix to pull the modules out of, and neither worked for me on vista. John Lyons wrote: It works I am running 2.2 and cfmx 7.02 on my box right now. you have to remove the old configuration and add a new one. Mike Staver wrote: I'd also like to add that after a few hours of banging my head on my desk with Apache 2.2, it does not appear that CFMX 7 on windows will work with Apache 2.2, even with this hotfix: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=8001e97 They apparently fixed it for Linux/Unix, but the connector is still not working on Windows. No biggie for me though, I rolled back to Apache 2.0.59 and I now have CFMX7 running on Vista :) Thanks again Steven for hitting me over the head with a clue stick and reminding me of this option! Steven Ross wrote: If you cant figure it out you can always run apache On 11/14/06, Mike Staver <[EMAIL PROTECTED]> wrote: I don't think it's setup right. Attached is a screen shot of what I see. I'm not sure what I should put here. Justin Haygood wrote: > Do you have .cfm associated with the ColdFusion / JRun ISAPI handler > and/or CGI process? (not sure which is used for CFM)? > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Staver > Sent: Tuesday, November 14, 2006 5:35 PM > To: discussion@acfug.org > Subject: Re: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista > Enterprise x86 > > Thanks for the input - I thought about doing that as well yesterday, so > I made the change today. However, now IIS just serves up the page for > download rather than parsing it with CFMX. I have a feeling I'm SOL > until an update gets released, if one does at all. I'll be using > virtual machines for this stuff I think until then. > > Damon wrote: >> I do not have Vista and this may be a log shot but you can try to add > a MIME >> type in IIS (IIS 6 you right click the computer name in the IIS > manager and >> go to properties, not sure for IIS 7) of .CFM for extension and >> cfm-application/octet-stream for mime type. This should at least let > IIS >> serve up the cfm. >> >> Just a guess >> -Damon Ledet >> >> -Original Message- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike > Staver >> Sent: Monday, November 13, 2006 6:41 PM >> To: discussion@acfug.org >> Subject: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista > Enterprise >> x86 >> >> I'm going to go out on a limb here and assume that nobody has tried > this >> yet, but I have the final release of Windows Vista Enterprise that was >> released to manufacturing running on my workstation now. It's a > completely >> fresh install, and I attempted to install CFMX 7.0.2 on it to run with > IIS >> 7. As you might assume, it doesn't work. I'm running the >> x86 version, rather than the x64 in the hopes more things work with > it. >> I've been wrong with that guess mostly for a lot of apps. >> >> Below is what IIS spits out: >> > > -- >> Server Error in Application "Default Web Site" >> HTTP Error 404.3 - Not Found >> >> Description: The page you are requesting cannot be served because of > the >> Multipurpose Internet Mail Extensions (MIME) map policy that is > configured >> on the Web server. The page you requested has a file name extension > that is >> not recognized, and is not allowed. >> >> Error Code: 0x80070032 >> >> Notification: ExecuteRequestHandler >> >> Module: StaticFileModule >> >> Requested URL: http://127.0.0.1:80/CFIDE/administrator/index.cfm >> >> Physical Path: C:\inetpub\wwwroot\CFIDE\administrator\index.cfm >> >> Logon User: Anonymous >> >> Logon Method: Anonymous >> >> Handler: StaticFile >> >> Most likely causes: >> >> * It is possible that a handler mapping is missing. By default, > the >> static file handler processes all content. >> * The feature you are trying to use may not be installed. >> * The appropriate MIME map is not enabled for the Web site or >> application. (Warning: Do not create a MIME map for content that users >> should not download, such as .ASPX pages or .config files.) >> >> What you can try: >> >> * In system.webServer/handlers: >> * Ensure that the expected handler for the current page is > mapped. >> * Pay careful attention to preconditions (e.g. runtimeVersion, >> pipelineMode, bitness) and compare them to the settings for your > application >> pool. >> * Pay careful attention to typographical errors in the expected > handler >> line. >> * Please verify that the feature you are trying to use is > installed. >> * Verify that the MIME map is enabled or add the MIME map for the > Web >> site using the command-line tool appcmd.exe. >> 1. Open a command prompt
Re: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista Enterprise x86
It works I am running 2.2 and cfmx 7.02 on my box right now. you have to remove the old configuration and add a new one. Mike Staver wrote: I'd also like to add that after a few hours of banging my head on my desk with Apache 2.2, it does not appear that CFMX 7 on windows will work with Apache 2.2, even with this hotfix: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=8001e97 They apparently fixed it for Linux/Unix, but the connector is still not working on Windows. No biggie for me though, I rolled back to Apache 2.0.59 and I now have CFMX7 running on Vista :) Thanks again Steven for hitting me over the head with a clue stick and reminding me of this option! Steven Ross wrote: If you cant figure it out you can always run apache On 11/14/06, Mike Staver <[EMAIL PROTECTED]> wrote: I don't think it's setup right. Attached is a screen shot of what I see. I'm not sure what I should put here. Justin Haygood wrote: > Do you have .cfm associated with the ColdFusion / JRun ISAPI handler > and/or CGI process? (not sure which is used for CFM)? > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Staver > Sent: Tuesday, November 14, 2006 5:35 PM > To: discussion@acfug.org > Subject: Re: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista > Enterprise x86 > > Thanks for the input - I thought about doing that as well yesterday, so > I made the change today. However, now IIS just serves up the page for > download rather than parsing it with CFMX. I have a feeling I'm SOL > until an update gets released, if one does at all. I'll be using > virtual machines for this stuff I think until then. > > Damon wrote: >> I do not have Vista and this may be a log shot but you can try to add > a MIME >> type in IIS (IIS 6 you right click the computer name in the IIS > manager and >> go to properties, not sure for IIS 7) of .CFM for extension and >> cfm-application/octet-stream for mime type. This should at least let > IIS >> serve up the cfm. >> >> Just a guess >> -Damon Ledet >> >> -Original Message- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike > Staver >> Sent: Monday, November 13, 2006 6:41 PM >> To: discussion@acfug.org >> Subject: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista > Enterprise >> x86 >> >> I'm going to go out on a limb here and assume that nobody has tried > this >> yet, but I have the final release of Windows Vista Enterprise that was >> released to manufacturing running on my workstation now. It's a > completely >> fresh install, and I attempted to install CFMX 7.0.2 on it to run with > IIS >> 7. As you might assume, it doesn't work. I'm running the >> x86 version, rather than the x64 in the hopes more things work with > it. >> I've been wrong with that guess mostly for a lot of apps. >> >> Below is what IIS spits out: >> > > -- >> Server Error in Application "Default Web Site" >> HTTP Error 404.3 - Not Found >> >> Description: The page you are requesting cannot be served because of > the >> Multipurpose Internet Mail Extensions (MIME) map policy that is > configured >> on the Web server. The page you requested has a file name extension > that is >> not recognized, and is not allowed. >> >> Error Code: 0x80070032 >> >> Notification: ExecuteRequestHandler >> >> Module: StaticFileModule >> >> Requested URL: http://127.0.0.1:80/CFIDE/administrator/index.cfm >> >> Physical Path: C:\inetpub\wwwroot\CFIDE\administrator\index.cfm >> >> Logon User: Anonymous >> >> Logon Method: Anonymous >> >> Handler: StaticFile >> >> Most likely causes: >> >> * It is possible that a handler mapping is missing. By default, > the >> static file handler processes all content. >> * The feature you are trying to use may not be installed. >> * The appropriate MIME map is not enabled for the Web site or >> application. (Warning: Do not create a MIME map for content that users >> should not download, such as .ASPX pages or .config files.) >> >> What you can try: >> >> * In system.webServer/handlers: >> * Ensure that the expected handler for the current page is > mapped. >> * Pay careful attention to preconditions (e.g. runtimeVersion, >> pipelineMode, bitness) and compare them to the settings for your > application >> pool. >> * Pay careful attention to typographical errors in the expected > handler >> line. >> * Please verify that the feature you are trying to use is > installed. >> * Verify that the MIME map is enabled or add the MIME map for the > Web >> site using the command-line tool appcmd.exe. >> 1. Open a command prompt and change directory to >> %windir%\system32\inetsrv. >> 2. To set a MIME type, use the following syntax: appcmd set > config >> /section:staticContent /+[fileExtension='string',mimeType='string'] >> 3. The variable fileExtensio
Re: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista Enterprise x86
I'd also like to add that after a few hours of banging my head on my desk with Apache 2.2, it does not appear that CFMX 7 on windows will work with Apache 2.2, even with this hotfix: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=8001e97 They apparently fixed it for Linux/Unix, but the connector is still not working on Windows. No biggie for me though, I rolled back to Apache 2.0.59 and I now have CFMX7 running on Vista :) Thanks again Steven for hitting me over the head with a clue stick and reminding me of this option! Steven Ross wrote: If you cant figure it out you can always run apache On 11/14/06, Mike Staver <[EMAIL PROTECTED]> wrote: I don't think it's setup right. Attached is a screen shot of what I see. I'm not sure what I should put here. Justin Haygood wrote: > Do you have .cfm associated with the ColdFusion / JRun ISAPI handler > and/or CGI process? (not sure which is used for CFM)? > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Staver > Sent: Tuesday, November 14, 2006 5:35 PM > To: discussion@acfug.org > Subject: Re: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista > Enterprise x86 > > Thanks for the input - I thought about doing that as well yesterday, so > I made the change today. However, now IIS just serves up the page for > download rather than parsing it with CFMX. I have a feeling I'm SOL > until an update gets released, if one does at all. I'll be using > virtual machines for this stuff I think until then. > > Damon wrote: >> I do not have Vista and this may be a log shot but you can try to add > a MIME >> type in IIS (IIS 6 you right click the computer name in the IIS > manager and >> go to properties, not sure for IIS 7) of .CFM for extension and >> cfm-application/octet-stream for mime type. This should at least let > IIS >> serve up the cfm. >> >> Just a guess >> -Damon Ledet >> >> -Original Message- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike > Staver >> Sent: Monday, November 13, 2006 6:41 PM >> To: discussion@acfug.org >> Subject: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista > Enterprise >> x86 >> >> I'm going to go out on a limb here and assume that nobody has tried > this >> yet, but I have the final release of Windows Vista Enterprise that was >> released to manufacturing running on my workstation now. It's a > completely >> fresh install, and I attempted to install CFMX 7.0.2 on it to run with > IIS >> 7. As you might assume, it doesn't work. I'm running the >> x86 version, rather than the x64 in the hopes more things work with > it. >> I've been wrong with that guess mostly for a lot of apps. >> >> Below is what IIS spits out: >> > > -- >> Server Error in Application "Default Web Site" >> HTTP Error 404.3 - Not Found >> >> Description: The page you are requesting cannot be served because of > the >> Multipurpose Internet Mail Extensions (MIME) map policy that is > configured >> on the Web server. The page you requested has a file name extension > that is >> not recognized, and is not allowed. >> >> Error Code: 0x80070032 >> >> Notification: ExecuteRequestHandler >> >> Module: StaticFileModule >> >> Requested URL: http://127.0.0.1:80/CFIDE/administrator/index.cfm >> >> Physical Path: C:\inetpub\wwwroot\CFIDE\administrator\index.cfm >> >> Logon User: Anonymous >> >> Logon Method: Anonymous >> >> Handler: StaticFile >> >> Most likely causes: >> >> * It is possible that a handler mapping is missing. By default, > the >> static file handler processes all content. >> * The feature you are trying to use may not be installed. >> * The appropriate MIME map is not enabled for the Web site or >> application. (Warning: Do not create a MIME map for content that users >> should not download, such as .ASPX pages or .config files.) >> >> What you can try: >> >> * In system.webServer/handlers: >> * Ensure that the expected handler for the current page is > mapped. >> * Pay careful attention to preconditions (e.g. runtimeVersion, >> pipelineMode, bitness) and compare them to the settings for your > application >> pool. >> * Pay careful attention to typographical errors in the expected > handler >> line. >> * Please verify that the feature you are trying to use is > installed. >> * Verify that the MIME map is enabled or add the MIME map for the > Web >> site using the command-line tool appcmd.exe. >> 1. Open a command prompt and change directory to >> %windir%\system32\inetsrv. >> 2. To set a MIME type, use the following syntax: appcmd set > config >> /section:staticContent /+[fileExtension='string',mimeType='string'] >> 3. The variable fileExtension string is the file name > extension >> and the variable mimeType string is the file type description. >> 4. For example, to add a MIME map for a file wh
Re: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista Enterprise x86
That's a great suggestion, I tend to forget apache runs on windows. I was going to install CentOS on VMWare, but apache is lots easier :) Steven Ross wrote: If you cant figure it out you can always run apache On 11/14/06, Mike Staver <[EMAIL PROTECTED]> wrote: I don't think it's setup right. Attached is a screen shot of what I see. I'm not sure what I should put here. Justin Haygood wrote: > Do you have .cfm associated with the ColdFusion / JRun ISAPI handler > and/or CGI process? (not sure which is used for CFM)? > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Staver > Sent: Tuesday, November 14, 2006 5:35 PM > To: discussion@acfug.org > Subject: Re: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista > Enterprise x86 > > Thanks for the input - I thought about doing that as well yesterday, so > I made the change today. However, now IIS just serves up the page for > download rather than parsing it with CFMX. I have a feeling I'm SOL > until an update gets released, if one does at all. I'll be using > virtual machines for this stuff I think until then. > > Damon wrote: >> I do not have Vista and this may be a log shot but you can try to add > a MIME >> type in IIS (IIS 6 you right click the computer name in the IIS > manager and >> go to properties, not sure for IIS 7) of .CFM for extension and >> cfm-application/octet-stream for mime type. This should at least let > IIS >> serve up the cfm. >> >> Just a guess >> -Damon Ledet >> >> -Original Message- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike > Staver >> Sent: Monday, November 13, 2006 6:41 PM >> To: discussion@acfug.org >> Subject: [ACFUG Discuss] Coldfusion MX 7.0.2 and Windows Vista > Enterprise >> x86 >> >> I'm going to go out on a limb here and assume that nobody has tried > this >> yet, but I have the final release of Windows Vista Enterprise that was >> released to manufacturing running on my workstation now. It's a > completely >> fresh install, and I attempted to install CFMX 7.0.2 on it to run with > IIS >> 7. As you might assume, it doesn't work. I'm running the >> x86 version, rather than the x64 in the hopes more things work with > it. >> I've been wrong with that guess mostly for a lot of apps. >> >> Below is what IIS spits out: >> > > -- >> Server Error in Application "Default Web Site" >> HTTP Error 404.3 - Not Found >> >> Description: The page you are requesting cannot be served because of > the >> Multipurpose Internet Mail Extensions (MIME) map policy that is > configured >> on the Web server. The page you requested has a file name extension > that is >> not recognized, and is not allowed. >> >> Error Code: 0x80070032 >> >> Notification: ExecuteRequestHandler >> >> Module: StaticFileModule >> >> Requested URL: http://127.0.0.1:80/CFIDE/administrator/index.cfm >> >> Physical Path: C:\inetpub\wwwroot\CFIDE\administrator\index.cfm >> >> Logon User: Anonymous >> >> Logon Method: Anonymous >> >> Handler: StaticFile >> >> Most likely causes: >> >> * It is possible that a handler mapping is missing. By default, > the >> static file handler processes all content. >> * The feature you are trying to use may not be installed. >> * The appropriate MIME map is not enabled for the Web site or >> application. (Warning: Do not create a MIME map for content that users >> should not download, such as .ASPX pages or .config files.) >> >> What you can try: >> >> * In system.webServer/handlers: >> * Ensure that the expected handler for the current page is > mapped. >> * Pay careful attention to preconditions (e.g. runtimeVersion, >> pipelineMode, bitness) and compare them to the settings for your > application >> pool. >> * Pay careful attention to typographical errors in the expected > handler >> line. >> * Please verify that the feature you are trying to use is > installed. >> * Verify that the MIME map is enabled or add the MIME map for the > Web >> site using the command-line tool appcmd.exe. >> 1. Open a command prompt and change directory to >> %windir%\system32\inetsrv. >> 2. To set a MIME type, use the following syntax: appcmd set > config >> /section:staticContent /+[fileExtension='string',mimeType='string'] >> 3. The variable fileExtension string is the file name > extension >> and the variable mimeType string is the file type description. >> 4. For example, to add a MIME map for a file which has the >> extension ".xyz", type the following at the command prompt, and then > press >> Enter: >> 5. appcmd set config /section:staticContent >> /+[fileExtension='.xyz',mimeType='text/plain'] >>Warning: Ensure that this MIME mapping is needed for your Web > server >> before adding it to the list. Configuration files such as .CONFIG or > dynamic >> scripting pages such as .ASP or
