Coldfusion hotfix 14 causes [Macromedia][Oracle JDBC Driver]Internal error: Net8 protocol error
Has anyone upgraded to hotfix patch 14 on their servers and started experiencing a [Macromedia][Oracle JDBC Driver]Internal error: Net8 protocol error or a [Macromedia][Oracle JDBC Driver]Operation cancelled by user request? After applying this patch some of our SQL statements started generating these errors. If we roll back our servers to hotfix 11, the error goes away. We did notice that in hotfix 11 the jdbc driver version is atColdFusion10/cfusion/lib/postgresql-8.3-604.jdbc3.jar vs in hotfix 14 the jdbc driver changes to ColdFusion10/cfusion/lib/postgresql-9.3-1101.jdbc41.jar Any thoughts on how to troubleshoot? ~| 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:359903 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfcontent parent page issues
Has anyone come across this issue (IE8-same behavior in XP and Windows 7): - index.cfm page displays a table from a cfquery. The query is based on cfselect list allowing multiple entries in a cfform. Clicking submit on the form, correctly displays the table output below the form based on the select list parameters passed to the cfquery via form variable. - a hyperlink in the form (not a submit), target=_blank opens same index.cfm using saveas=excel url parameter via cfcontent to display table data to Excel instead of html. - When the user clicks the hyperlink, the page opens in Excel and displays data correctly. They then close the file (and window). - On parent page, user chooses other values in the select list, then clicks submit on the form. Result: debugging shows all the form variables are null and table data is not displayed correctly. List selections are ignored. As long as the hyperlink to Excel file is not selected, user chooses other values in the select list as many times as desired, clicks submit on the form and all form variables are populated -- no problems. The only time the form variables become null is if the page is opened in Excel in a _blank target window via CFContent and then the user closes the window and tries to change parameters in the select list on the previous page and clicks submit. I'm stuck. Dawn Sekel, TCLEOSE Webmaster Texas Commission on Law Enforcement Officer Standards and Education 6330 East Highway 290, Suite 200 Email: dawn.se...@tcleose.state.tx.us Website: http://www.tcleose.state.tx.us ~| 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:348262 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Win 2008 32/CF 9 hardening after the fact
Is it possible to go back after the fact and harden a server into a production machine? Or do we need to start from scratch. We have a Windows 2008 32 bit server (clean install/patches applied) installed with CF9 out of the box in the C:\Inetpub default directory. We need to quickly move the machine into a production environment. We already have the domain name pointed to that machine and accessible through a URL and we have purchased a security certificate for the URL. I would be happy to send the site address via individual email. Unfortunately, no one in our organization is very familiar with 2008, and our network administrator skills are limited. We came across http://www.adobe.com/products/coldfusion/whitepapers/pdf/91025512_cf9_lockdownguide_wp_ue.pdf and tried to follow these instructions -- but kept hitting errors and roadblocks. So most of these steps were not done. I have created a new site location on a different drive and added it in the ETC hosts file (127.0.0.1) for the primary application - but do not know what is needed next. Any tips, tricks dumbed down to a non-network adminstrator would be greatfully appreciated. ~| 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:345957 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Win 2008 32/CF 9 hardening after the fact
It is a dedicated web server -- no other services or applications. It has no other services running on it except DSN connections in Coldfusion Administrator to our various SQL server boxes and a connection to our Microsoft exchange server for handing email in CF Admin. It is a Public site that will receive approximately 3 million hits and about 200,000 unique visitors a year according to our statistics from last year. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Thursday, June 30, 2011 10:32 AM To: cf-talk Subject: Re: Win 2008 32/CF 9 hardening after the fact Is it possible to go back after the fact and harden a server into a production machine? Or do we need to start from scratch. Yes, it's possible to do this. But the big questions depend on how exactly you plan to use this machine in production. Public web server? Will it participate in a larger Windows network? Does it run other services? We have a Windows 2008 32 bit server (clean install/patches applied) installed with CF9 out of the box in the C:\Inetpub default directory. We need to quickly move the machine into a production environment. We already have the domain name pointed to that machine and accessible through a URL and we have purchased a security certificate for the URL. I would be happy to send the site address via individual email. Unfortunately, no one in our organization is very familiar with 2008, and our network administrator skills are limited. We came across http://www.adobe.com/products/coldfusion/whitepapers/pdf/91025512_cf9_lockdownguide_wp_ue.pdf and tried to follow these instructions -- but kept hitting errors and roadblocks. So most of these steps were not done. I have created a new site location on a different drive and added it in the ETC hosts file (127.0.0.1) for the primary application - but do not know what is needed next. Any tips, tricks dumbed down to a non-network adminstrator would be greatfully appreciated. Well, this is kind of hard, actually. You can't really dumb it down to a set of tips and tricks. That isn't how a coherent deployment is done. I'd recommend that you either (a) hire a consultant to help you with this process, or (b) try to implement the steps one-by-one and raise individual questions here for each step that doesn't work. And, one thing that's important - the lockdown guide, while it's very good, doesn't really cover OS security. So, you need to do that properly first if possible. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or on ~| 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:345961 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Win 2008 32/CF 9 hardening after the fact
On the new website we are bringing up the CF Administrator is available if you go to our new domain name and type in the CFIDE directory in the URL. If I follow the recommendations from Peter at the link below -- would that be all we need to do on a Windows 2008 server? http://www.petefreitag.com/item/774.cfm -Original Message- From: Alan Rother [mailto:alan.rot...@gmail.com] Sent: Thursday, June 30, 2011 10:48 AM To: cf-talk Subject: Re: Win 2008 32/CF 9 hardening after the fact One important thing is to make sure it's locked down behind a proper firewall of course. That will go a long way towards making it secure. Only open ports like 80 and 443 Of course that's just one important step. Oh, also make sure that the CF Admin is not publicly available =] On Thu, Jun 30, 2011 at 8:43 AM, Dawn Sekel dawn.se...@tcleose.state.tx.uswrote: It is a dedicated web server -- no other services or applications. It has no other services running on it except DSN connections in Coldfusion Administrator to our various SQL server boxes and a connection to our Microsoft exchange server for handing email in CF Admin. It is a Public site that will receive approximately 3 million hits and about 200,000 unique visitors a year according to our statistics from last year. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Thursday, June 30, 2011 10:32 AM To: cf-talk Subject: Re: Win 2008 32/CF 9 hardening after the fact Is it possible to go back after the fact and harden a server into a production machine? Or do we need to start from scratch. Yes, it's possible to do this. But the big questions depend on how exactly you plan to use this machine in production. Public web server? Will it participate in a larger Windows network? Does it run other services? We have a Windows 2008 32 bit server (clean install/patches applied) installed with CF9 out of the box in the C:\Inetpub default directory. We need to quickly move the machine into a production environment. We already have the domain name pointed to that machine and accessible through a URL and we have purchased a security certificate for the URL. I would be happy to send the site address via individual email. Unfortunately, no one in our organization is very familiar with 2008, and our network administrator skills are limited. We came across http://www.adobe.com/products/coldfusion/whitepapers/pdf/91025512_cf9_lockdownguide_wp_ue.pdf and tried to follow these instructions -- but kept hitting errors and roadblocks. So most of these steps were not done. I have created a new site location on a different drive and added it in the ETC hosts file (127.0.0.1) for the primary application - but do not know what is needed next. Any tips, tricks dumbed down to a non-network adminstrator would be greatfully appreciated. Well, this is kind of hard, actually. You can't really dumb it down to a set of tips and tricks. That isn't how a coherent deployment is done. I'd recommend that you either (a) hire a consultant to help you with this process, or (b) try to implement the steps one-by-one and raise individual questions here for each step that doesn't work. And, one thing that's important - the lockdown guide, while it's very good, doesn't really cover OS security. So, you need to do that properly first if possible. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or on ~| 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:345974 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
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
same content different result CFFile vs CFContent
I am converting some code that originally used CFFILE to write the contents of a variable to a file on the server and then attached it to an email and emailed. For security reasons, we have switched to https:// and are providing a link for an authenticated user that takes the contents of the variable and generates an inline file for the user to download. The new version however, contains a single ASCII character 32 (space) at the end â while the older version did not. Would anyone be able to compare the to versions of my code and see if they can identify why the space is being added? It is the very last character of the file. Thanks in advance for any advice. Dawn The original code was: !--- Create File --- cffile action=write addnewline=no file=#GetDirectoryFromPath(ExpandPath(*.*))##userInfo.LName#-#userInfo.FName#-#userInfo.UserID#-FI.txt output=#myFile# The new code is !--- Create File --- cfsavecontent variable=strText cfoutput#myFile#/cfoutput /cfsavecontent !--- Set the header info to force that file attachment. --- cfheader name=Content-Disposition value=attachment; filename=#userInfo.lName#-#userInfo.fName#-#userInfo..UserID#-FI.txt / !--- Stream the text. To do so, we have to convert it to Base64 first, then convert that to binary. --- cfcontent type=text/plain reset=true variable=#ToBinary(ToBase64(strText))# / ~| 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:343000 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFcontent puts \n at top of file -- solution?
I have a web application that creates writes text string of data to be used by a VB application and streams it to a file to be saved on the end user's computer. I am generating a text file from an online database that needs to be opened by the VB application with a CHR(10) character delimeter between fields. The end user clicks download in my application and then saves the file to their computer to use with the VB application (3rd party written). Here is an example of my code. When opening the text file locally, it alway's has a new line character at the top of the file which chokes the VB program. Any suggestions on an alternate way of doing this? Even hardcoding the line this is a test in the cfsavecontent statement causes the /n character to be inserted at the top of the file. In the real application the text string is #fname# CHR(10) #lname# etc. Thanks, in advance - Dawn !--- Store the text you want to stream. --- cfsavecontent variable=strText This is a test. /cfsavecontent !--- Set the header info to force that file attachment. --- cfheader name=Content-Disposition value=attachment; filename=test.txt / !--- Stream the text. To do so, we have to convert it to Base64 first, then convert that to binary. --- cfcontent type=text/plain reset=true variable=#ToBinary(ToBase64(strText))# / ~| 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:341012 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Upgrade CF 9 - Now getting Unknown SMTP host
We didn't change anything in our mail servers Just upgraded from CF 7 to CF 9. When I use CF Admin to verify Mail connection it reports Success. However, all mail is being marked undeliverable and the error message I'm getting is Unknown SMTP host: our mail server name Anyone know how to resolve this? Thank you in advance. :-) 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:339497 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrade CF 9 - Now getting Unknown SMTP host
Hi Russ: Thanks for your answer. I get a response back through Telnet from the mail server with the version number and that it is ready at today's date and time. Do I need to take the credentials out of CFAdmin and how to I test the email delivery to see if the settings are correct. Thanks! Dawn I went into IIS and choose SMTP e-mail (IIS 6) and put in my SMTP server information. Make sure you can still connect to the SMTP server from the web server (not via CF). You can test this with telnet Open command prompt and type telnet yourServerName 25 if you get a response back from the server then it works, if not, then there is a problem connecting to the server, not a CF problem. Russ We didn't change anything in our mail servers Just upgraded from CF 7 to CF 9. When I use CF Admin to verify Mail connection it reports Success. However, all mail is being marked undeliverable and the error message I'm getting is Unknown SMTP host: our mail server name Anyone know how to resolve this? Thank you in advance. :-) 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:339502 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrade CF 9 - Now getting Unknown SMTP host
No nothing has changed. I have another box running CF7 with the same Mail settings and it works fine. And the mail service was working before upgrading to CF9. That was the only thing I changed. If I put in a bad password or user in CF9 administrator I get unsuccessful connection. If I change the password and username to correct ones and test, I get successful connection (when choosing Mail in Coldfusion administrator) But in my mail logs -- I keep getting that the mail is undeliverable. Dawn Has there been any dns changes for your SMTP server, i.e. has its ip address changed. CF caches DNS, so restarting CF would resolve that. Or are they on the same machine ? Russ Hi Russ: Thanks for your answer. I get a response back through Telnet from the mail server with the version number and that it is ready at today's date and time. Do I need to take the credentials out of CFAdmin and how to I test the email delivery to see if the settings are correct. Thanks! Dawn I went into IIS and choose SMTP e-mail (IIS 6) and put in my SMTP server information. ~| 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:339505 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrade CF 9 - Now getting Unknown SMTP host
Yes -- it is the fully qualified external mail server name and is the same mail server name that is in my other headers. Open up one of the failed mails and check the headers, is the server name correct ? No nothing has changed. I have another box running CF7 with the same Mail settings and it works fine. And the mail service was working before upgrading to CF9. That was the only thing I changed. If I put in a bad password or user in CF9 administrator I get unsuccessful connection. If I change the password and username to correct ones and test, I get successful connection (when choosing Mail in Coldfusion administrator) But in my mail logs -- I keep getting that the mail is undeliverable. 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:339508 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF 9 Enterprise Create New Instance
I am missing something in creating an instance in Enterprise. I have the site created, the directory structure is there. It is an internal site on the Coldfusion box. The server is XP with Windows IIS 6. In IIS Manager, I can see the site in the application pool and added a virtual site to map to it. Do I need to run JRUN Administrator and do something else as well? When I try to go to the site it says Unable to display the webpage ~| 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:338723 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Installation Instructions Coldfusion Enterprise 9
Does anyone have installation instructions for Coldfusion Enterprise 9? Do I just try downloading the Developer edition and then upgrade with our upgrade license number? I tried calling Adobe Technical support and got someone in India who directed me to download the Enterprise Installation manager for CS5 -- which made no sense to me. Thanks in advance ~| 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:338520 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Installation Instructions Coldfusion Enterprise 9
Thank you! For Both posts. I kept clicking links on their products and never could get to that page. I'm installing the multi-server version and was trying to find sequence to install the other add-ons including Sharepoint. We are going to try to connect Coldfusion as a Webpart under SharePoint 2010. I can't find any documentation to see if Adobe has tested CFSharepoint with 2010 -- but other developers tell me it should work because it is just a service. I'm sure I'm going to be frustrated and have many lessons learned -- maybe we will be pleasantly surprised. ~| 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:338528 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldusion 8 Instance Manager won't load
I was in the process of adding a new development site on our server. When I added the instance in Coldfusion administrator it started the process but never finished. When I log into JRUN 4 administrator I can see the new site name. When I go to the physical server I can see the new directory structure for the website. But now when I log into CF Admin and click on the Enterprise Instances menu option, the page just starts loading and never opensI don't get a time out or anything. Thoughts? Suggestions? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336979 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Session timer??
I was reading this thread - but it is over 7 years old http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:21407#108226 I am working on a self assessment test website in which the psychologist I'm developing the site for wants to keep the end user informed of how much time they have left to complete the test. He doesn't want the session to end -- just move them to the next test at the end of the time. Obviously there are lots of flaws to doing a timer on a web page -- like if the end user accidently closes the browser. I received some good clues by looking at the thread -- but I was wondering if anyone has a recent web page timer in Coldfusion or Javascript to share that updates a database record -- or any recommendations - gotcha's that they have come across. Thanks! Dawn ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335675 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Session timer??
Thanks Andrew! (slapping my forehead) I hadn't thought about calculating the time the test should end when the user starts--that and your other thoughts are great suggestions. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335683 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Remember another column value CFSELECT on change
The purpose of my Form to provide a report completed training. I am trying to validate that the Course Hours of the training is within a minimum and maximum range of hours. I have a select field for Select_Course. When the user selects the course name - I want to remember the minimum and maximum hours of the course and then do client side javascript validation that the hours entered in the Course Hours field is within the maximum and minimum values. I know I've done something similar -- but can't remember how. Thanks in advance for any advice. My table for the select statement has the minimum and maximum hours in separate fields. Dawn ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Remember another column value CFSELECT on change
Thank you so much Michael -- that worked! Here is the finished code:
if(document.getElementById('course_list').value.length 1) {
err = err + \n Please select a course from the list.
}
else {
var cHours = document.getElementById('course_list').value;
var cHourVal = document.getElementById('hours').value;
var minMax = cHours.split(|);
if ((cHourVal = minMax[1]) (cHourVal = minMax[2])) {
// ** debugging area **
}
else
{
var msg = Course hours must be between + minMax[1] + and + minMax[2]
+ hours.;
err = err + \n + msg;
}
}
**Please note I'm doing this off the top of my head. I don't have an editor
handy.
Well say you set up your select value to be a list with a pipe delim. Say
you have a course with min 4 and max 10 hours.
option value=4|10Super Awesome Course #1/option
In your onChange you set a function call:
onChange(validateCourse(this.value))
then your javascript function
function validateCourse(objVal)
{
// set the course hours value to whatever the field name is.
var cHours = document.formname.courseHours.value;
var minMax = objVal.split(|);
if ((cHours = minMax[0]) (cHours = minMax[1]))
{
// this is what you do when it meets your condition of min and max hours.
}
else
{
// this is what you do when it doens't meet your condition.
}
}
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334544
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfsharepoint and Sharepoint 2010
Has anyone used the new CF9 cfsharepoint tag? We are implementing SharePoint 2010. It is the first time our agency has had Sharepoint. In reading the cfsharepoint documentation for CF9 it sounds like it has the capabilities to update document lists in Sharepoint 2007. We need to bulk import several thousand PDF documents into our new Sharepoint with metadata attached. We are also a CF shop and all our external websites are CF based--so cfsharepoint sounds perfect. Until I stumbled across this command, we were looking at purchasing a SharePoint bulk import tool which can be really pricey. I'm hoping the command will still work with SharePoint 2010 and I was wondering if anyone has tried using cfsharepoint w/2010 yet. Thanks in advance for any advice. Dawn Sekel E-Mail: dawn.se...@tcleose.state.tx.us ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334010 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9 Hosting
I have used them for years too -- but I have recently had a really bad experience with them. I signed one of my new customers up under a shared hosting account -- just a small application. The server he was on kept crashing. Their technical support told him that the problem was Coldfusion and that he needed to switch to another technology. They said Coldfusion is going out of business and know one uses it any more. Anyway -- I don't user them any more for my smaller customers that can't afford a dedicated server. I'll +1 for CrystalTech. I've been using them for years. Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com Alan Rother wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333853 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9 Hosting
Believe it or not it has actually been three different companies in the past few months. supp...@crystaltech.com - they said Cold Fusion is problematic and is requires constant restarts and advised us to move to a different technology. My customer said they told him Coldfusion wasn't a viable solution for today's webservers. It should be noted that this is in a shared Server environment. The next was goDaddy.com. My customer wanted to use them as a hosting service -- I haven't ever used them and we have had all sorts of problems with them. Again a shared server environment. They keep asking my customer to switch to PHP or ASP. The last was http://www.ablecommerce.com/ They were a Coldfusion shop for years and I have installed their Shopping cart software for many customers in the past. One of my old customers contacted me and said that they stopped supporting Coldfusion and no longer support it. When I called them, they said that they felt Coldfusion was no longer a market leader and it wasn't worth their investment to support that market base. Sigh Coldfusion is going out of business and know one uses it any more? What's the name of the company that said this. I'll twitter that I heard they are going out of business and get my 1,200 followers to retweet it. One good false rumor deserves another :-) Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 5133 (20100520) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333862 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Substitute/conversion for Flash Interactive Menus for iPad?
Just FYI - I highly recommend using Google Analytics to track who is visiting your site. It is a free tool and not only tells you where people are visiting your site from, it also lets you know what kinds of browers they are using, whether they are using mobile devices, if their browsers are javascript enabled and what versions of Flash they have installed. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333701 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Substitute/conversion for Flash Interactive Menus for iPad?
Cool - thanks for the tip Rick. I didn't think about jquery. I found a really cool website after reading your post: http://webdesignledger.com/tutorials/13-excellent-jquery-animation-techniques I tested this site on my iPhone and it worked: http://www.incg.nl/blog/2008/hover-block-jquery/example/animate_hover.html I'm testing some of them now on the iPAD to see what happens. :-) Dawn Hi, Mark... Have you looked into using jQuery or another javascript library for something like this? I don't think it would be very difficult to code in jQuery. I've got a real estate agent I'm building a site for and she wants the typical Flash-based virtual tours, but I'm going to try to emulate the Flash with jQuery. That will involve using photos like in the top of Utah.gov at the very least. Rick Dawn, We have a project like this pending. I would be interested in anything resources you uncover - thanks :) Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com I have looked into HTML5 -- but I can't find any references for how you would do things like gotoAndPlay() like you can in Flash. The site I have been developing has very similar banner to that of www.UTAH.gov. When you click the menu at the top, a text menu overlays the image. And when you point at things in the banner, hints display. Our users are mostly Law Enforcement and many use iPhones. A lot of them are also Apple users for some reason. I found some code that I'm testing to detect the iPad on the site that seems to work well. Currently if you go to my beta site with the iPhone it shows everything but the .swf files. If you go to it with the iPAD - it just says ERROR and doesn't display anything. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333574 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Substitute/conversion for Flash Interactive Menus for iPad?
I have looked into HTML5 -- but I can't find any references for how you would do things like gotoAndPlay() like you can in Flash. The site I have been developing has very similar banner to that of www.UTAH.gov. When you click the menu at the top, a text menu overlays the image. And when you point at things in the banner, hints display. Our users are mostly Law Enforcement and many use iPhones. A lot of them are also Apple users for some reason. I found some code that I'm testing to detect the iPad on the site that seems to work well. Currently if you go to my beta site with the iPhone it shows everything but the .swf files. If you go to it with the iPAD - it just says ERROR and doesn't display anything. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:51 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Substitute/conversion for Flash Interactive Menus for iPad?
Hi-I have several web templates that use Flash widgets for interactive menus-the buttons are non-standard floating bubbles or have sound and interactivity in them when the user mouses over them. Now my boss said that he wants to do away with them and go to something different because of the Apple iPad debate. Is there any tool that anyone knows of that can take a Flash SWF and convert it another format that the iPad Safari browser will recognize and still retain the interactivity? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:33 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Interested in LiveCycle Designer?
Hi Dave - are you going to be recording the presentation? I'm really interested in this but not in DC Hi, everyone! We're offering a free training seminar on LiveCycle Designer in Washington, DC on 25 May. If you're interested in building LiveCycle forms which you can use with CFPDFFORM, you might want to check it out! http://training.figleaf.com/courses/lceval.cfm Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333119 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Chase Paymentech Orbital Gateway
Has anyone added a shopping cart application on their site that interfaces with Paymentech? We host our own CF site and want to start accepting on-line payments. If so, do you have any recommendations for an easy to use SDK? Or what would be the steps needed to start from scratch? I researched all the shopping cart vendors listed on Chase's authorized Orbital Gateway partners, but didn't find one that mentioned Coldfusion -- all of them seemed geared towards ASP.net. Thanks in advance for any advice. Dawn Sekel dawn.sekel.tcleose.tx.state.us ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330268 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Use CFLDAP to retrieve list of groups user belongs to
Hi: I currently use this command to authenticate a user against our AD. cfldap action=QUERY name=results start=dc=DomainName,dc=com server=serveripaddress username=#trim(form.username)# password=#trim(form.password)# filter=cn=#uname# attributes=cn My IT manager wants me to now allow users to access various tasks in our web application based upon the group the user belongs to. Can I add a filter to the filter parameter such as memberOf that will return a string of all the groups the user belongs to in the results query? Or would I have to use a second follow on CFLDAP query? Would anyone be able to share an example? Thanks in advance of any advice. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330227 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Use CFLDAP to retrieve list of groups user belongs to
That Worked! Thank you. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330246 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldfusion 8 localHost, DreamWeaver CS4, CSS Caching problem
Has anyone else had this problem and solved it? Scenario is this: I have Adobe Creative Suite Standard CS4 installed on my Windows Vista laptop. I also have Coldfusion 8,0,1,195765 Developer edition installed. Then when saving a htm or cfm file in DreamWeaver while also displaying it on my CF Localhost in a web browser after I make a change to page and that also involves a change to a CSS file I get the following error: A sharing violation occurred while accessing C:\[name of the file] - where the file name is the htm page - not the CSS file. I searched the web and someone mentioned that it was a caching problem and they fix it by logging into CF Admin and going to the Caching page and clicking Clear Cache twice, then the submit changes button. And indead, if I do that, then I can click save in DreamWeaver and the error does not occur. You actually have to do the exact sequence in CF Admin to make the error go away. Any clue? Thanks in advance! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322199 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 8 localHost, DreamWeaver CS4, CSS Caching problem
Thank you! I wasn't using IIS -- I was using the CF server version. I will try your suggestion! Dawnthea On Tue, May 5, 2009 at 5:27 PM, Casey Dougall ca...@uberwebsitesolutions.com wrote: Forgot this one - also under Testing Server settings make sure URL prefix is http://project1 now test in browser http://project1 -- Casey Dougall Über Website Solutions (518) 633-1621 Saratoga Springs, NY http://uberwebsitesolutions.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322211 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF Code to create AutoIncrement column MS SQL?
Hi: I have a customer whose programmer has vanished and he is trying to get his application back on line. I'm an intermediate CF programmer and I've managed to get everything working again except for one problem. His database is hosted - and somehow, when he restored his application, the fields in his database lost their autonumbering capability. I tried creating the next number right before the insert by getting the max value of the field and then adding 1 to it, and that works for the most part, but occassionally, we are seeing the old Violation of PRIMARY KEY constraint 'PK_TblTestAnswers'. Cannot insert duplicate key in object 'dbo.TblTestAnswers' - and I can't figure out why unless to users are somehow hitting the same page at exactly the same time and clicking submit. So the only thing I can think of to fix the problem is to recreate the autoincrment key fields somehow. Does anyone have any Coldfusion code to insert a new autoincrement key field in to a MS SQL table and then remove the old one? Or is there a way to modify a key field to autoincrement? Thanks in advance for any advice. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321860 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 Code to create AutoIncrement column MS SQL?
Hi Robert: Yes, that would be the best way. The problem is, I'm working from home, don't have any SQL tools installed on my home computer. So I was trying to think of a short cut that I could modify the table using Coldfusion. The database is a student test answer repository -- so they never modify records, only insert new ones. The largest table has about 22,000 records in it. Can I MS Microsoft SQL Server Management Studio Express, if I download it, to do what you are suggesting? Thanks! Dawn ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321868 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 Code to create AutoIncrement column MS SQL?
CFTransaction is a good thought -- thanks -- I had thought of CFLock. I just wasn't sure what would be the best way. Long term though -- do you think it is better to redo the database? I was trying to do the quickest fix because it is a freebie. Thank you for everyone's help. Dawn I have a customer whose programmer has vanished and he is trying to get his You can fix the problem, in the short term, by using the CFTRANSACTION tag to select the current value, increment by one, and insert the new record within a single transaction. Does anyone have any Coldfusion code to insert a new autoincrement key field in to a MS SQL table and then remove the old one? Or is there a way to modify a key field to autoincrement? It's not really a matter of writing CF code, you just have to write the appropriate SQL statement to modify the schema. I think that would involve creating a new table with the appropriate columns, copying the values from the original table to the new table, dropping the relationships to the original table, creating the relationships on the new table, then dropping the original table. I don't think you can simply alter the column if it's part of an index or primary key, although I could certainly be wrong about that. Once you write that SQL statement, you could run it through CFQUERY if permissions allow, or from any other environment that lets you send SQL statements to the server. You might be able to do this easier if you can connect to the SQL Server with the native management tools, as well - you may be able to just change the column type in place. 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 informa ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321869 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Experienced CF Dev seeking telecommute work between June and August
Hi All, Here's my situation. I am a ColdFusion developer with 10 years of CF experience going from CF8 all the way back to CF3. I am also (primarily, since this year) a high school computer science and web design teacher and I am looking for something to keep myself busy during the summer months; I will be available from approximately June 10th until August 15th, 2008. I'm located in the western Philadelphia, PA suburbs, so unless you're local to me, I'd be looking for this to be a telecommuting gig. If you're within a couple of hours of my location, I'd be available for periodic on-site meetings (travel expenses paid, of course). In addition to broad experience in CF, where I specialize in intranets, extranets, and content management systems, I also have a lot of experience with learning management systems, performance tuning, user interface and user factors, page layout, HTML CSS, JavaScript, AJAX, and DHTML, MySQL and MS SQL Server. So, if you think you have a project that needs doing over the summer (I can get ramped up before the end of the school year), or if you need a pinch-hitter to cover for the usual summer vacation times, please shoot me an email. I'll be happy to send you my CV with references as well as a list of URL's of sites that I have worked on. Even if you aren't sure what your needs are, save this email and keep me in mind if something comes up. Thanks, Pete Ruckelshaus Hi Pete - please contact me if you are still looking. [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3732 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: Can a JDBC driver effect SQL format?
I had another thought on this thread (see original question below), I followed instructions from someone's blog on how to set up Oracle 10g express as an other data access connection. Would that be the reason for requiring so many quotes? Thanks in advance - Dawn I am trying to transfer an application from MSAccess into Oracle 10g. I the free version of Oracle 10g Express running locally for development purposes before uploading to the test server. I have used older versions of Oracle, but never 10g. It has been a while, but I do not ever remember having to put everything in quotes before. However, the only way I can get table creates and record inserts to work is by putting everything in quotes including the table name. When I look at examples of other Oracle SQL on the Internet, I'm not seeing this format. Is what I am experiencing correct or is there some setting I don't know about? Thanks in advance for any advice. This is the query I have gotten to work. cfquery name=tableCreate datasource=#session.systemTables# CREATE table systemRoles ( roleID NUMBER, description VARCHAR2(50), viewable NUMBER, help VARCHAR2(256), createdDate DATE, createdByNUMBER, modifiedDate DATE, modifiedBy NUMBER, constraint systemRoles_PK primary key (roleID) ) /cfquery ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272221 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Oracle 10g Express Quotes or no Quotes?
I am trying to transfer an application from MSAccess into Oracle 10g. I the free version of Oracle 10g Express running locally for development purposes before uploading to the test server. I have used older versions of Oracle, but never 10g. It has been a while, but I do not ever remember having to put everything in quotes before. However, the only way I can get table creates and record inserts to work is by putting everything in quotes including the table name. When I look at examples of other Oracle SQL on the Internet, I'm not seeing this format. Is what I am experiencing correct or is there some setting I don't know about? Thanks in advance for any advice. This is the query I have gotten to work. cfquery name=tableCreate datasource=#session.systemTables# CREATE table systemRoles ( roleID NUMBER, description VARCHAR2(50), viewable NUMBER, help VARCHAR2(256), createdDate DATE, createdByNUMBER, modifiedDate DATE, modifiedBy NUMBER, constraint systemRoles_PK primary key (roleID) ) /cfquery ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272005 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Does anyone have CFoutput example for SQL89 Array field?
We are working with a customer who has a legacy application written in a Progress Database that uses SQL-89 query language. In their customer table the address field (which has a column heading of ADDR) is an array field. If we use CFDump to output the query structure CFDUMP var=qryCustomer we can see the column name information. And it shows the array field elements as having an @ symbol in its column heading: NAME[EMAIL PROTECTED][EMAIL PROTECTED] CITY XYZ Company 111 Main Street [empty string]New York But, we can't figure out the correct syntax for a CFoutput statement for the individual elements of the ADDR array. The PROGRESS SQL-89 user guide says it should be #qryCustomer.addr__1#, but that causes an element undefined error. Does anyone have an example of a select statement for a Progress SQL-89 array field that they can share? Is it possible to use an @ symbol as a field name using some sort of escape sequence? Thank you in advance! Dawn ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260516 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SSL Problem? CFHTTP getting COM.Allaire.ColdFusion.HTTPFailure
Hi: I've been searching message boards trying to understand what the following message means: Error Type: COM.Allaire.ColdFusion.HTTPFailure Error Message: Connection Failure: Status code unavailable This is my source code: CFTRY CFHTTP url=http://myurl.com; method=get throwOnError=yes CFCATCH type = Any CFOUTPUT Error Type: i#Cfcatch.Type#/ibr Error Message: i#cfcatch.Message#/ibr /CFOUTPUT CFABORT /CFCATCH /CFTRY The above CFHTTP command worked fine on our test server, which does not have an SSL certificate installed (Windows Server 2003 -- IIS). But when we move it to production (again Windows Server 2003, IIS), we are getting the above error. The only clues I've found in Adobe LiveDocs is someone saying FYI, if coldfusion needs you to import an SSL certificate, and you are using throwOnError=yes, the exception won't exactly lead you right to the heart of the problem. Exception type is COM.Allaire.ColdFusion.HTTPFailure and the message is Connection Failure: Status code unavailable, which is probably shared with several other types of problems. And someone else saying: CFHTTP will not post to an https page with an expired certificate. This isn't a bug but the error message isn't very informative: COM.Allaire.ColdFusion.HTTPFailure Connection Failure: Status code unavailable. We just recently purchased an SSL certificate for our production server and installed it under IIS -- but I don't have a clue on what to do in ColdFusion. Can anyone give some things to try? Thank you in advance for any help you can give! Dawn ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259344 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problems with CFContent download of .tif image
Thank you to everyone for their help. I finally figured it out. It was a caching problem. In our Application.CFM -- which hadn't been changed in over 3 years, there was a line: CFHEADER name=cache-control value=no-cache, no-store, must-revalidate, post-check=0, pre-check=0 I took out the no-cache and no-store pieces so that it read: CFHEADER name=cache-control value=must-revalidate, post-check=0, pre-check=0 And it started working. I got the clue from reading other threads with similar problems trying to open Word and Excel files. So hopefully this post will help someone else out. :-) Dawn I am using the following code to retrieve a tif image from our internal imaging server so that I can allow Internet users to retrieve blueprint drawings that are behind our corporate firewall. cfhttp method = GET getasbinary=yes url=http://myurlname.asp?imagename; cfheader name=Content-Disposition value=attachment; filename=myfile.tif cfcontent type=image/tiff variable=#cfhttp.FileContent# This code works great except for one problem. When the Windows dialog box opens and says Do you want to open or save this file? in XP professional clicking the save button works every time. But if the Open button is clicked we can see the file downloading to the temporary folder -- but as soon as it finishes the file disappears. And when Microsoft Office Document Imaging (the default viewer) launches it give an error opening document message because the file no longer exists. This only seems to happen on XP Professional--computers with XP Home Edition or non-XP operating systems can open the file on the fly by clicking the open button. Does anyone have a clue why XP is doing this? It is also putting a (1) after the file name and the other operating systems don't do that. Is there anyway to stop it from deleting the file so the user can open it? Thanks in advance for any advice. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259346 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SSL Problem? CFHTTP getting COM.Allaire.ColdFusion.HTTPFailure
We just upgraded to ColdFusionMX7. :-) Dawn If it's the problem in the liveDocs it has to do with importing the SSL certificate into the keystore... But the error makes me think you have an older version of CF - what version are you running? -Original Message- From: Dawn Sekel [mailto:[EMAIL PROTECTED] Sent: Monday, November 06, 2006 1:08 PM To: CF-Talk Subject: SSL Problem? CFHTTP getting COM.Allaire.ColdFusion.HTTPFailure Hi: I've been searching message boards trying to understand what the following message means: Error Type: COM.Allaire.ColdFusion.HTTPFailure Error Message: Connection Failure: Status code unavailable This is my source code: CFTRY CFHTTP url=http://myurl.com; method=get throwOnError=yes CFCATCH type = Any CFOUTPUT Error Type: i#Cfcatch.Type#/ibr Error Message: i#cfcatch.Message#/ibr /CFOUTPUT CFABORT /CFCATCH /CFTRY The above CFHTTP command worked fine on our test server, which does not have an SSL certificate installed (Windows Server 2003 -- IIS). But when we move it to production (again Windows Server 2003, IIS), we are getting the above error. The only clues I've found in Adobe LiveDocs is someone saying FYI, if coldfusion needs you to import an SSL certificate, and you are using throwOnError=yes, the exception won't exactly lead you right to the heart of the problem. Exception type is COM.Allaire.ColdFusion.HTTPFailure and the message is Connection Failure: Status code unavailable, which is probably shared with several other types of problems. And someone else saying: CFHTTP will not post to an https page with an expired certificate. This isn't a bug but the error message isn't very informative: COM.Allaire.ColdFusion.HTTPFailure Connection Failure: Status code unavailable. We just recently purchased an SSL certificate for our production server and installed it under IIS -- but I don't have a clue on what to do in ColdFusion. Can anyone give some things to try? Thank you in advance for any help you can give! Dawn ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259358 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SSL Problem? CFHTTP getting COM.Allaire.ColdFusion.HTTPFailure
Hi Bryan: That is the full error message -- I'm outputting the cfcatch.type and cfcatch.message that is returned. Is there another cfcatch parameter I should output? Thanks, Dawn Dawn, Please post the full error message...if it contains peer not auntenticated I can help you jump through the flaming hoops to solve it. If not, then at leat we can rule out the known SSL cert issue (having to import the cert into the Java keystore that CF uses). Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259360 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best CF7 Hosting company
I use xtreme-host.com. I have used custom tags in my applications that I have hosted there and they support CFMX 7. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258841 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Problems with CFContent download of .tif image
I am using the following code to retrieve a tif image from our internal imaging server so that I can allow Internet users to retrieve blueprint drawings that are behind our corporate firewall. cfhttp method = GET getasbinary=yes url=http://myurlname.asp?imagename; cfheader name=Content-Disposition value=attachment; filename=myfile.tif cfcontent type=image/tiff variable=#cfhttp.FileContent# This code works great except for one problem. When the Windows dialog box opens and says Do you want to open or save this file? in XP professional clicking the save button works every time. But if the Open button is clicked we can see the file downloading to the temporary folder -- but as soon as it finishes the file disappears. And when Microsoft Office Document Imaging (the default viewer) launches it give an error opening document message because the file no longer exists. This only seems to happen on XP Professional--computers with XP Home Edition or non-XP operating systems can open the file on the fly by clicking the open button. Does anyone have a clue why XP is doing this? It is also putting a (1) after the file name and the other operating systems don't do that. Is there anyway to stop it from deleting the file so the user can open it? Thanks in advance for any advice. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258314 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
