Copy link to clipboard
Copied
I have an app that I wrote at least five years ago that has worked perfectly fine all this time. I'm not even sure what version of CF I used at the time. I've only just installed DreamWeaver CS5.5 on a new computer (the flooding from Irene destroyed my office), and I think prior to this I was using DreamWeaver MX. It might be MX that I used to build this, but I'm not sure. In any case, it works fine in Firefox and Chrome, but won't work in IE9 (it works in IE8). I can't even identify exactly where it's failing. I suspect it's at the start of my action page where I'm seeing if the checkboxes are checked, and setting variables if they are. It just fails immediately and doesn't give me a reasonable error. Also because of all the flooding and moving of our office, I'm having testing server issues, so I can't just turn on debugging at this point to find the exact line that's failing (I'm trying to address that, as well).
Apparently I'm not allowed to just say to the few people who use this application "Just use Firefox instead of IE9" (I'm still pushing for that) because this is NOT a mission critical application by any stretch of the imagination.
Anyway, I was hoping someone might have a suggestion for something to tweak or a place to look or an idea for what needs to be done to just make the thing work on IE9.
Copy link to clipboard
Copied
We're thinking we might have to rewrite this in .net. *sigh* I hate having to rewrite things that are so basic and have worked so well for so long, but I suppose that's just how it goes.
Copy link to clipboard
Copied
I think you need to describe a bit more about what the issue is. Maybe
copy/paste the nugget of the checkboxes from the form, and also the nugget
of code that processes it, so someone can actually help. Maybe a link to
the page?
Copy link to clipboard
Copied
Oh, ok... I just figured if there was a problem with IE9, folks might have heard of it. Unfortunately you can't get to the page directly, it's all inside our firewall and accessible only to our staff. Here's the code in question (I changed an email address and server name for security reasons):
<!--- Check if form audience variables exist and set variables.formXXX to proper Access value. --->
<cfif IsDefined("form.ANR") is "True">
<!--- If True, set value to Access Checked Value (1) --->
<cfset variables.FormANR = 1>
<cfelse>
<!--- If False, set value to Access Unchecked Value (0) --->
<cfset variables.FormANR = 0>
</cfif>
<cfif IsDefined("form.DEC") is "True">
<!--- If True, set value to Access Checked Value (1) --->
<cfset variables.FormDEC = 1>
<cfelse>
<!--- If False, set value to Access Unchecked Value (0) --->
<cfset variables.FormDEC = 0>
</cfif>
<cfparam name="NewsTitle" default="#FORM.NewsTitle#">
<cfparam name="NewsItem" default="#FORM.NewsItem#">
<cfparam name="More_Info_Link1" default="#FORM.More_Info_Link1#">
<cfparam name="Link1Title" default="#FORM.Link1Title#">
<cfparam name="Link2Title" default="#FORM.Link2Title#">
<cfparam name="More_info_Link2" default="#FORM.More_info_Link2#">
<cfparam name="PosterName" default="#FORM.PosterName#">
<cfparam name="PosterPhone" default="#FORM.PosterPhone#">
<cfparam name="PosterEmail" default="#FORM.PosterEmail#">
<cfparam name="ANR" default="#variables.FormANR#">
<cfparam name="DEC" default="#variables.FormDEC#">
<cfparam name="DateEvent" default="#FORM.DateEvent#">
<cfparam name="DateEnd" default="#FORM.DateEnd#">
<cfupdate datasource="StaffNews" tablename="tblNewsItems"
Formfields = "NewsTitle,
NewsItem,
More_Info_Link1,
Link1Title,
Link2Title,
More_Info_Link2,
PosterName,
PosterPhone,
PosterEmail,
ANR,
DEC,
DateEvent,
DateEnd">
<!--- <cfquery name="UpdateNews" datasource="StaffNews">
UPDATE tblNewsItems
SET NewsTitle = '#form.NewsTitle#',
NewsItem = '#form.NewsItem#',
More_Info_Link1 = '#form.More_Info_Link1#',
Link1Title = '#form.Link1Title#',
More_Info_Link2 = '#form.More_Info_Link2#',
Link2Title = '#form.Link2Title#',
PosterName = '#form.PosterName#',
PosterPhone = '#form.PosterPhone#',
PosterEmail = '#form.PosterEmail#',
ANR = '#formANR#',
DEC = '#formDEC#',
DateEvent = '#form.DateEvent#',
DateEnd = '#form.DateEnd#'
WHERE id = #form.id#
</cfquery> --->
<cfmail to="our staff news person" from="form@us" subject="StaffNewsItemEDIT">
A Staff News item was edited.
<cfif IsDefined('form.FieldNames')>
<cfloop index="Field" list="#form.Fieldnames#">
<cfoutput>#Field#: #form[Field]#
</cfoutput><br>
</cfloop>
</cfif>
</cfmail>
<cflocation url="http://staffnewslocation/cfadmin/StaffNews/Index.cfm?msg=Edited" addToken="no">
Copy link to clipboard
Copied
And causing the error is when you don't check off both boxes? Or just one?
Any specific error message? Also if you do a CFDump of the form varible
what do you see?
Copy link to clipboard
Copied
I'm not getting any error other than it isn't able to display the action page (which means it's trying to get to the action page but not processing that page at all and just failing). Because of our continuing issues with servers (due to the flood) I am not able to get a cfdump of the form variable at this time, which I realize is likely to mean we can't go much further with debugging this at this time..
This happens no matter what is checked or unchecked on the checkboxes. It's like it's not even processing the first step for some reason.
I reiterate that I was really hoping that other people had run into issues with IE9 similar to this, and could offer suggestions for things that needed to be tweaked to make it work there. It works in every other browser and every other version of IE.
Copy link to clipboard
Copied
The form that you are using, is it action="post"? Any javascript that maybe
IE9 is barfing on? Like improperly formatted dates? Doesn't seem certain
that the checkboxes are the issue.
Copy link to clipboard
Copied
This application has been working perfectly fine for about five or six years, and it is only IE9 that it doesn't work in (it works in Firefox, and Chrome, and IE versions prior to 9). If I have badly formatted dates, it wouldn't work anywhere, would it? Or some commenting error thing?
Copy link to clipboard
Copied
If it is javascript that is generating them then yes. Why would you suggest
rewriting it in .net?
Copy link to clipboard
Copied
I don't use any javascript that I know of. Everything in the app is strictly coldfusion. I said .net because we're gradually moving all our applications into .net, it's our new standard at the office. We aren't really supporting coldfusion as such. If we can fix something in CF when a bug comes up, then we do, but if we can't fix it without a lot of effort (and without it being a lot of time we don't have), and if it's pretty simple, we rewrite it in .net. My boss has decided we're gonna do this in .net, so I thank you for all the help you've tried to give me, and I'm sorry I've not been able to fully participate in debugging this.
Copy link to clipboard
Copied
Also looks like your SQL update is commented out and CFUpdate is used (which
it shouldn't be). Thus whatever your checkbox checking is doing at the top
is likely skipped anyway.