I'm trying to get this application to work properly, and can't. The CFFILE Upload for the Photo is the only thing that isn't working. Form.cfm is the page that submits everything to Insert.cfm page. The essential parts of the code for both pages is listed below.
<!---(Form.cfm) --->
<FORM ACTION="Insert.cfm" ENCTYPE="multipart/form-da
ta" METHOD="POST" NAME="EC" ONSUBMIT="return ErrorCheck();">
<TABLE ALIGN="center" BGCOLOR="000066" BORDER="0" WIDTH="350">
<TR>
<TD BGCOLOR="CCCCFF" VALIGN="top" STYLE="padding:1px;">
<TABLE>
<TR>
<TD ALIGN="left" CLASS="ContentLarge" WIDTH="140">
<B>ADMIN
</TD>
<TD ALIGN="left" WIDTH="210">
<INPUT TYPE="TEXT" CLASS="Content" MAXLENGTH="1" NAME="Admin" SIZE="1">
</TD>
</TR>
<TR>
<TD ALIGN="left" CLASS="ContentLarge">
<B>LAST NAME
</TD>
<TD ALIGN="left" WIDTH="150">
<INPUT TYPE="TEXT" CLASS="Content" MAXLENGTH="20" NAME="LastName" SIZE="23">
</TD>
</TR>
<TR>
<TD ALIGN="left" CLASS="ContentLarge">
<B>FIRST NAME
</TD>
<TD ALIGN="left">
<INPUT TYPE="TEXT" CLASS="Content" MAXLENGTH="20" NAME="FirstName" SIZE="23">
</TD>
</TR>
<TR>
<TD ALIGN="left" CLASS="ContentLarge">
<B>WORK PHONE
</TD>
<TD ALIGN="left">
<INPUT TYPE="TEXT" CLASS="Content" MAXLENGTH="12" NAME="WorkPhone" SIZE="23">
</TD>
</TR>
<TR>
<TD ALIGN="left" CLASS="ContentLarge">
<B>EMAIL
</TD>
<TD ALIGN="left">
<INPUT TYPE="TEXT" CLASS="Content" MAXLENGTH="30" NAME="Email" SIZE="23">
</TD>
</TR>
<TR>
<TD ALIGN="left" CLASS="ContentLarge">
<B>PHOTO
</TD>
<TD ALIGN="left">
<INPUT TYPE="File" CLASS="Box" MAXLENGTH="100" NAME="Photo" SIZE="18">
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<TABLE ALIGN="center">
<TR>
<TD ALIGN="center">
<BR>
<INPUT TYPE="Button" VALUE="Back" ONCLICK="history.go(-1)" onmouseover="highlightButt
on('Button
')" onmouseout="highlightButto
n('')" onmousedown="this.style.fo
ntStyle='i
talic'" ONMOUSEUP="this.style.font
Style=('')
">
<INPUT TYPE="Submit" VALUE="Submit" onmouseover="highlightButt
on('Button
')" onmouseout="highlightButto
n('')" onmousedown="this.style.fo
ntStyle='i
talic'" ONMOUSEUP="this.style.font
Style=('')
"><BR>
</TD>
</TR>
</TABLE>
</FORM>
<!---(Insert.cfm) --->
<CFQUERY NAME="qAdd" DATASOURCE="#request.datas
ource#" username="#request.usernam
e#" password="#request.passwor
d#">
INSERT INTO #request.prefix#.t_securit
yteam (Admin, LastName, FirstName, WorkPhone, Email, Photo)
VALUES('#Form.Admin#','#Fo
rm.LastNam
e#','#Form
.FirstName
#','#Form.
WorkPhone#
','#Form.E
mail#','#F
orm.Photo#
')
</CFQUERY>
<P ALIGN="center">The new member is entered into the Security Team database!
<P ALIGN="center">You will be redirected back to the Security Team Admin webpage in a few seconds. If not click button below to return.
<FORM>
<INPUT TYPE="Button" VALUE="Security Team Admin" ONCLICK="parent.location='
SecurityTe
amAdmin.cf
m'" onmouseover="highlightButt
on('start'
)" onmouseout="highlightButto
n('')" onmousedown="this.style.fo
ntStyle='i
talic'" ONMOUSEUP="this.style.font
Style=('')
">
</FORM>
<TABLE WIDTH="500">
<TR>
<TD ALIGN="center" CLASS="Heading">
The data you entered was:
</TD>
</TR>
</TABLE>
<TABLE WIDTH="500">
<TR>
<TD ALIGN="right">
<CFOUTPUT>
<TABLE WIDTH="425">
<TR>
<TD ALIGN="left" CLASS="ContentLarge" WIDTH="175">
ADMIN
</TD>
<TD ALIGN="left" CLASS="ContentLarge" WIDTH="250">
#Form.Admin#
</TD>
</TR>
<TR>
<TD ALIGN="left" CLASS="ContentLarge">
LAST NAME
</TD>
<TD ALIGN="left" CLASS="ContentLarge">
#Form.LastName#
</TD>
</TR>
<TR>
<TD ALIGN="left" CLASS="ContentLarge">
FIRST NAME
</TD>
<TD ALIGN="left" CLASS="ContentLarge">
#Form.FirstName#
</TD>
</TR>
<TR>
<TD ALIGN="left" CLASS="ContentLarge">
WORK PHONE
</TD>
<TD ALIGN="left" CLASS="ContentLarge">
#Form.WorkPhone#
</TD>
</TR>
<TR>
<TD ALIGN="left" CLASS="ContentLarge">
EMAIL
</TD>
<TD ALIGN="left" CLASS="ContentLarge">
#Form.Email#
</TD>
</TR>
<TR>
<TD ALIGN="left" CLASS="ContentLarge">
PHOTO
</TD>
<TD ALIGN="left" CLASS="ContentLarge">
<CFFILE ACTION="upload" FILEFIELD="Form.Photo" DESTINATION="Staff/" ACCEPT="*.jpg" NAMECONFLICT="Overwrite">
Content Type: #File.ContentType#<BR>
Content SubType: #File.ContentSubType#<BR>
Client Directory: #File.ClientDirectory#<BR>
Client File: #File.ClientFile#<BR>
Client FileName: #File.ClientFileName#<BR>
Client FileExt: #File.ClientFileExt#<BR>
Server Directory: #File.ServerDirectory#<BR>
Server File: #File.ServerFile#<BR>
Attempted ServerFile: #File.AttemptedServerFile#
<BR>
File Existed? #File.FileExisted#<BR>
File Was Saved? #File.FileWasSaved#<BR>
File Was Overwritten? #File.FileWasOverWritten#<
BR>
File Was Renamed? #File.FileWasRenamed#<BR>
</TD>
</TR>
</TABLE>
</CFOUTPUT>
</TD>
</TR>
</TABLE>
Start Free Trial