here is some code that i was given great help on.
the form::
<CFQUERY NAME="FileType" DATASOURCE="new">
SELECT *
FROM tbl_File
</CFQUERY>
<CFIF set_Is.FileID IS NOT "">
<CFSET set_FileID = set_Is.FileID>
<CFQUERY NAME="File_Type" DATASOURCE="new">
SELECT * FROM tbl_File
WHERE FileID = #set_FileID#
</CFQUERY>
<CFELSE>
<CFSET set_FileID = "">
</CFIF>
<FORM action="KBase_Input.cfm" method="post"
ENCTYPE="multipart/form-data">
<CFIF NewRecord IS "No">
<INPUT TYPE="hidden" NAME="IssueID" VALUE="#IssueID#">
<INPUT TYPE="hidden" NAME="ContactID" VALUE="#AuthorID#">
<INPUT TYPE="hidden" NAME="UploadedFileName1">
<INPUT TYPE="hidden" NAME="UploadedFileName2">
<INPUT TYPE="hidden" NAME="UploadedFileName3">
</CFIF>
<TABLE>
<TR bgcolor="#006600">
<TD align=right valign="top" colspan="2">
<div align="left"><b><font size="4" face="Arial, Helvetica,
sans-serif" color="#FFFFFF">Image
File Info:</font></b><font face="Arial, Helvetica,
sans-serif" color="#FFFFFF">
You can upload up to 3 (*.jpg or *.gif)
images.</font></div>
</TD>
</TR>
<tr>
<td align=right valign="top">Upload Image 1:</td>
<td>
<cfif FileID IS NOT "">
<cfif #File_Type.UploadedFileName1# IS NOT "">
<cfoutput><img
src="images\#Trim(File_Type.UploadedFileName1)#"></cfoutput>
<input type="hidden" name="UploadedFileName1"
value="#Trim(File_Type.UploadedFileName1)#" maxlength="50">
</cfif>
<cfelse>
<input type="file" name="UploadedFileName1"
maxlength="50">
</cfif>
</td>
</tr>
<!--- Inserts Caption1 into the table: File Colum: Caption1 --->
<!--- <CFIF NewRecord IS "Yes"> --->
<TR>
<TD align=right valign="top">Caption 1:</TD>
<TD>
<CFIF FileID IS NOT "">
<cfif #File_Type.Caption1# IS NOT "">
<CFOUTPUT>
<TEXTAREA NAME="Caption1" COLS="40" ROWS="5"
WRAP="virtual">#File_Type.Caption1#</textarea>
</CFOUTPUT>
</CFIF>
<CFELSE>
<TEXTAREA NAME="Caption1" COLS="40" ROWS="5"
WRAP="virtual"></textarea>
</CFIF>
</TD>
</TR>
<tr>
<td align=right valign="top">Upload Image 2:</td>
<td>
<cfif FileID IS NOT "">
<cfif #File_Type.UploadedFileName2# IS NOT "">
<cfoutput><img
src="images\#Trim(File_Type.UploadedFileName2)#"></cfoutput>
<input type="hidden" name="UploadedFileName2"
value="#Trim(File_Type.UploadedFileName2)#" maxlength="50">
</cfif>
<cfelse>
<input type="file" name="UploadedFileName2"
maxlength="50">
</cfif>
</td>
</tr>
<!--- Inserts the file to be uploaded into tha table: File
Colum: UploadedFileName1 --->
<!--- Inserts Caption2 into the table: File Colum: Caption2 --->
<TR>
<TD align=right valign="top">Caption 2:</TD>
<TD>
<CFIF FileID IS NOT "">
<cfif #File_Type.Caption2# IS NOT "">
<CFOUTPUT>
<TEXTAREA NAME="Caption2" COLS="40" ROWS="5"
WRAP="virtual">#File_Type.Caption2#</textarea>
</CFOUTPUT>
</CFIF>
<CFELSE>
<TEXTAREA NAME="Caption2" COLS="40" ROWS="5"
WRAP="virtual"></textarea>
</CFIF>
</TD>
</TR>
<tr>
<td align=right valign="top">Upload Image 3:</td>
<td>
<cfif FileID IS NOT "">
<cfif #File_Type.UploadedFileName3# IS NOT "">
<cfoutput><img
src="images\#Trim(File_Type.UploadedFileName3)#"></cfoutput>
<input type="hidden" name="UploadedFileName3"
value="#Trim(File_Type.UploadedFileName3)#" maxlength="50">
</cfif>
<cfelse>
<input type="file" name="UploadedFileName3"
maxlength="50">
</cfif>
<!--- </cfif> ---> </td>
</tr>
<!--- Inserts the file to be uploaded into tha table: File
Colum: UploadedFileName2 --->
<!--- Inserts Caption3 into the table: File Colum: Caption3 --->
<TR>
<TD align=right valign="top">Caption 3:</TD>
<TD>
<CFIF FileID IS NOT "">
<cfif #File_Type.Caption3# IS NOT "">
<CFOUTPUT>
<TEXTAREA NAME="Caption3" COLS="40" ROWS="5"
WRAP="virtual">#File_Type.Caption3#</textarea>
</CFOUTPUT>
</CFIF>
<CFELSE>
<TEXTAREA NAME="Caption3" COLS="40" ROWS="5"
WRAP="virtual"></textarea>
</CFIF>
</TD>
</TR>
<!--- Inserts the file to be uploaded into tha table: File
Colum: UploadedFileName3 --->
<TR>
<TD colspan=2 height=10></TD>
</TR>
<TR>
<TD></TD>
<TD> <CFOUTPUT>
<INPUT TYPE="submit"
VALUE="#ButtonText#"></CFOUTPUT>
<INPUT TYPE="reset" value=" Clear ">
</TD>
</TR>
<TR>
<TD colspan=2 height=10></TD>
</TR>
</TABLE>
</FORM>
<!--- ::::::::::::::::::::::::::::::::::::::::: The action Page ::
[Paul Ihrig] ::::::::::::::::::::::::::::::::::::::::::::::::::::--->
<CFIF IsDefined("FORM.IssueID")>
<CFSET Operation="Updated">
<CFUPDATE DATASOURCE="new"
TABLENAME="tbl_Issue"
DBTYPE="ODBC"
FORMFIELDS="AuthorID, Version, IssueName, Keywords,
Description, CreateDate, LastUpdateDate">
<CFUPDATE DATASOURCE="new"
TABLENAME="tbl_Contact"
DBTYPE="ODBC"
FORMFIELDS="ContactID, FirstName, LastName, Email, Phone">
<!--- Get the ID of the record just
inserted --->
<CFQUERY NAME="GetID" DATASOURCE="new">
SELECT Max(ContactID) AS MaxOfContactID
FROM tbl_Contact;
</cfquery>
<CFELSE>
<CFSET Operation="Inserted">
<cfinsert datasource="new"
tablename="tbl_Contact"
dbtype="ODBC"
formfields="FirstName, LastName, Email, PhoneExt">
<!--- Get the ID of the record just inserted --->
<CFQUERY NAME="GetID" DATASOURCE="new">
SELECT Max(ContactID) AS MaxOfContactID
FROM tbl_Contact;
</cfquery>
<!--- start to insert into Issue ---><!--- Preferred
method --->
<CFQUERY NAME="PutID" DATASOURCE="new">
INSERT INTO tbl_Issue(CategoryTypeID,
AuthorID, SoftwareID, Description, Version, IssueName, Keywords, CreateDate)
VALUES(#CategoryTypeID#,
#GetID.MaxOfContactID#, '#SoftwareID#', '#FORM.Description#',
'#FORM.Version#', '#FORM.IssueName#', '#FORM.Keywords#',
'#FORM.CreateDate#');
</CFQUERY>
</CFIF>
<!--- After you do your first INSERT into the Issue table, you need
to find out what the ID of the newly-inserted issue is. --->
<CFQUERY NAME="MaxID" DATASOURCE="new">
SELECT Max(IssueID) AS MaxOfIssueID
FROM tbl_Issue;
</CFQUERY>
<CFQUERY NAME="getDesc_Names" DATASOURCE="new">
SELECT c.CategoryTypeName, s.SoftwareName
FROM tbl_CategoryType c, tbl_Software s
WHERE c.CategoryTypeID = #CategoryTypeID#
AND s.SoftwareID = #SoftwareID#;
</CFQUERY>
<HTML>
<HEAD>
<TITLE>User - Input</TITLE>
</HEAD>
<BASEFONT face="Arial, Helvetica" size="2">
<BODY bgcolor="#ffffff">
<!--- Include Styles --->
<LINK REL="stylesheet" TYPE="text/css" HREF="styles_sheet.css">
<!--- <FONT size="+2"><B>Knowledge Base Data Entered</B></FONT> --->
<span class=Heading><B>Knowledge Base Data Entered</B></span>
<TABLE>
<TR>
<TD valign="top">The Issue:</TD>
<TD><CFOUTPUT>#Form.IssueName#</CFOUTPUT></TD>
</TR>
<TR>
<TD valign="top">Description:</TD>
<TD><CFOUTPUT>#ParagraphFormat(Form.Description)#</CFOUTPUT></TD>
</TR>
<TR>
<TD valign="top">Category:</TD>
<TD><CFOUTPUT
QUERY="getDesc_Names">#CategoryTypeName#</CFOUTPUT></TD>
</TR>
<TR>
<TD valign="top">Keywords:</TD>
<TD><CFOUTPUT>#Form.Keywords#</CFOUTPUT></TD>
</TR>
<TR>
<TD valign="top">Date Opened:</TD>
<TD><CFOUTPUT>#Form.CreateDate#</CFOUTPUT></TD>
</TR>
<TR>
<TD valign="top">Author:</TD>
<TD><CFOUTPUT>#Form.FirstName#</CFOUTPUT>
<CFOUTPUT>#Form.LastName#</CFOUTPUT></TD>
</TR>
<TR><!--- This <TR> tag was left out --->
<TD>Email:</TD>
<TD><CFOUTPUT><CFIF Email IS NOT ""><A
HREF="mailto:#FORM.Email#">
#Form.Email#</A></CFIF></CFOUTPUT></TD>
</TR>
<TR><!--- This <TR> tag was left out --->
<TD>Phone Extension:</TD>
<TD><CFOUTPUT>#Form.PhoneExt#</CFOUTPUT></TD>
</TR>
<TR>
<CFIF LastUpdateDate IS NOT "">
<TD valign="top">Last Updated:</TD>
<TD><CFOUTPUT>#Form.LastUpdateDate#</CFOUTPUT></TD>
</CFIF>
</TR>
<TR>
<TD valign="top">Software:</TD>
<TD><CFOUTPUT
QUERY="getDesc_Names">#SoftwareName#</CFOUTPUT></TD>
</TR>
<TR>
<TD valign="top">Version:</TD>
<TD><CFOUTPUT>#Form.Version#</CFOUTPUT></TD>
</TR>
<!--- File Action Stuff goes below! --->
<CFIF #Form.UploadedFileName1# IS "">
<CFSET #TempUploadedFileName1# = "">
</CFIF>
<CFIF #Form.UploadedFileName2# IS "">
<CFSET #TempUploadedFileName2# = "">
</CFIF>
<CFIF #Form.UploadedFileName3# IS "">
<CFSET #TempUploadedFileName3# = "">
</CFIF>
<!--- File 1 --->
<CFIF #Form.UploadedFileName1# IS NOT "">
<!--- Upload of the file if it has been selected. --->
<!--- I used <CFSET test_value =
"#UCASE(CGI.PATH_TRANSLATED)#"> to get the path for this file, then added an
images directory Could not make the path you had work - don't have direct
access to the CF server --->
<CFFILE ACTION="UPLOAD"
FILEFIELD="FORM.UploadedFileName1"
DESTINATION="D:\www\inhouse\KnowledgeBase\images\"
NAMECONFLICT="OVERWRITE">
<!--- DESTINATION="C:\Inetpub\wwwroot\Kb\images\" --->
<CFSET #TempUploadedFileName1# = #File.ServerFile#>
<TR>
<TD valign="top">Caption1:</TD>
<TD><CFOUTPUT>#ParagraphFormat(Form.Caption1)#</CFOUTPUT></TD>
</TR>
<!--- Displays the actual image file that was uploaded. --->
<TR>
<TD valign="top">File to Upload1:</TD>
<TD><CFOUTPUT><img
src="images\#FILE.ServerFile#"></CFOUTPUT></TD>
</TR>
</CFIF>
<!--- File 2 --->
<CFIF #Form.UploadedFileName2# IS NOT "">
<!--- Upload of the file if it has been selected. --->
<CFFILE ACTION="UPLOAD"
FILEFIELD="FORM.UploadedFileName2"
DESTINATION="D:\www\inhouse\KnowledgeBase\images\"
NAMECONFLICT="OVERWRITE">
<CFSET #TempUploadedFileName2# = #File.ServerFile#>
<TR>
<TD valign="top">Caption2:</TD>
<TD><CFOUTPUT>#ParagraphFormat(Form.Caption2)#</CFOUTPUT></TD>
</TR>
<!--- Displays the actual image file that was uploaded. --->
<TR>
<TD valign="top">File to Upload2:</TD>
<!--- <TD><CFOUTPUT><img
src=#FILE.ServerDirectory#\#FILE.ServerFile#>#FILE.ServerDirectory#\#FILE.Se
rverFile#</CFOUTPUT></TD> --->
<TD><CFOUTPUT><img
src="images\#FILE.ServerFile#"></CFOUTPUT></TD>
</TR>
</CFIF>
<!--- File 3 --->
<CFIF #Form.UploadedFileName3# IS NOT "">
<!--- Upload of the file if it has been selected. --->
<CFFILE ACTION="UPLOAD"
FILEFIELD="FORM.UploadedFileName3"
DESTINATION="D:\www\inhouse\KnowledgeBase\images\"
NAMECONFLICT="OVERWRITE">
<CFSET #TempUploadedFileName3# = #File.ServerFile#>
<TR>
<TD valign="top">Caption3:</TD>
<TD><CFOUTPUT>#ParagraphFormat(Form.Caption3)#</CFOUTPUT></TD>
</TR>
<!--- Displays the actual image file that was uploaded. --->
<TR>
<TD valign="top">File to Upload3:</TD>
<TD><CFOUTPUT><img
src="images\#FILE.ServerFile#"></CFOUTPUT></TD>
</TR>
</CFIF>
<CFIF ParameterExists(CFFILE.ServerDirectory)>
<!--- Inserts File Values into The File Table --->
<CFQUERY NAME="InsertFileInfo1" DATASOURCE="new">
INSERT INTO tbl_File(UploadedBy, Directory,
UploadedFileName1, Caption1, UploadedFileName2, Caption2, UploadedFileName3,
Caption3)
VALUES(#GetID.MaxOfContactID#,
'#CFFILE.ServerDirectory#', '#TempUploadedFileName1#', '#FORM.Caption1#',
'#TempUploadedFileName2#', '#FORM.Caption2#', '#TempUploadedFileName3#',
'#FORM.Caption3#');
</CFQUERY><!--- UploadedBy added since we got
#GetID.MaxOfContactID# above --->
<CFQUERY NAME="GetIDFileID" DATASOURCE="new">
SELECT Max(FileID) AS MaxOfFileID
FROM tbl_File;
</CFQUERY>
<CFQUERY DATASOURCE="new" NAME="PutFileID">
UPDATE tbl_Issue SET FileID =
#GetIDFileID.MaxOfFileID#
WHERE IssueID = #MaxID.MaxOfIssueID#;
</CFQUERY>
</CFIF>
</TABLE>
<BR>
<div align="left"><a href="KBase_Form.cfm">Add/Update Another Post
to the Knowledge Base!</a>
<BR>
<div align="left"><a href="KBase_Search.cfm">Search the Knowledge
Base!</a>
<BR>
<div align="left"><a href="KBase_Admin.cfm">Administration view of
Knowledge Base!</a>
<P>
<!---Standard Disclaimer--->
<SCRIPT LANGUAGE="JavaScript" SRC='Disclaimer.js'></SCRIPT>
<SCRIPT LANGUAGE="JavaScript">drawDisclaimer();</SCRIPT>
<!---/Standard Disclaimer--->
</BODY>
</HTML>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
