I have a Cold Fusion mailer script that sends an email survey message where someone fills out the form in their Outlook Mail message and sends in their response to a database. Our workstations are Windows 2000. The Email form shows up in the Outlook Mail but it will only process if someone has IE6 as their default browser. But we also have alot of people with Netscape 4.77 default browsers and the form will not process it if someone has a Netscape 4.77 default Browser.

The error message says my variables are not defined in the action page after it is submitted from the email message so I assume I need to translate or do some sort of decoding for it to work?

Please advise if there is anything I can do to correct the Netscape 4 problem? My attempt using the decodeURI method didnt work.


<CFMAIL
TO="smith@mycompany.com"
FROM="jones@mycompany.com"
SUBJECT="tester"
TIMEOUT="900"
SERVER="111.222.33.44"
PORT="25"
type=HTML>
<form action="http://myurlhere/actionpagehere.cfm" method="post" onclick="alert(decodeURI(this.href));return false">
Data entry:

<input type="text" name="comments" size="25">
<input type="text" name="mydata" size="25">
<input type="submit" name="submit" value="Submit">
</form>
</cfmail>




My action page:

<CFQUERY NAME="Adddata" datasource="myAccessname">
INSERT INTO mytable
(comments, mydata)
VALUES
( '#FORM.comments#', '#FORM.mydata#' );

</CFQUERY>

Hi oaklander,

Which variables -- myTable, comments? or '#FORM.comments#' ?

NN4 (and virtually every other browser but IE) is very strict about the full DOM when referencing a form element (document.formname.fieldname.value), #FORM... may need to be defined properly

Vinny

Its the '#FORM.comments#'

The message error:

Element FORM.COMMENTS is undefined in FORM



If I change the insert (changed #form.comments# to #comments#):
<CFQUERY NAME="Adddata" datasource="myAccessname">
INSERT INTO mytable
(comments, mydata)
VALUES
( '#comments#', '#mydata#' );

</CFQUERY>

then the message error is:

Element COMMENTS is undefined in FORM

It doesnt want to process anything inside the #'s.
How can I define it properly?
Please advise.
Thanks!

hi

In your testing system just enable debugging settings there it display the form variables which you have defined in the forms. i think it may not help a lot , but you can know the things a little.



Srinivas