Forums

This topic is locked

Problem with ASP Upload 2.2

Posted 04 Nov 2005 20:34:52
1
has voted
04 Nov 2005 20:34:52 ROB WONG posted:
Hi, I have an insert record page in Dreamweaver MX 2004 I am using ASP upload vesion 2.2. Everthing works fine but if I don't fill in all of the image fields then I get a field required error even though I have the program set to not require uploads. I tried just adding a couple of images to see if it just required one or two but it still happens. I have 23 image fields so I don't want to have to fill in all of them, I just need to have the option avaible.

Do you know what might be causing it? Here is the code from the page.

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="../Connections/Conn_ThinkBig.asp" -->
<!--#include file="../ScriptLibrary/incPureUpload.asp" -->
<%
'*** Pure ASP File Upload 2.2.0
Dim GP_uploadAction,UploadQueryString
PureUploadSetup
If (CStr(Request.QueryString("GP_upload") <> "" Then
Dim pau_thePath,pau_Extensions,pau_Form,pau_Redirect,pau_storeType,pau_sizeLimit,pau_nameConflict,pau_requireUpload,pau_minWidth,pau_minHeight,pau_maxWidth,pau_maxHeight,pau_saveWidth,pau_saveHeight,pau_timeout,pau_progressBar,pau_progressWidth,pau_progressHeight
pau_thePath = """"""
pau_Extensions = "GIF,JPG,JPEG,BMP,PNG,PDF"
pau_Form = "InsertListingForm"
pau_Redirect = ""
pau_storeType = "path"
pau_sizeLimit = ""
pau_nameConflict = "over"
pau_requireUpload = "false"
pau_minWidth = ""
pau_minHeight = ""
pau_maxWidth = ""
pau_maxHeight = ""
pau_saveWidth = ""
pau_saveHeight = ""
pau_timeout = "600"
pau_progressBar = "blueFlashProgress.htm"
pau_progressWidth = "300"
pau_progressHeight = "100"

Dim RequestBin, UploadRequest
CheckPureUploadVersion 2.20
ProcessUpload pau_thePath,pau_Extensions,pau_Redirect,pau_storeType,pau_sizeLimit,pau_nameConflict,pau_requireUpload,pau_minWidth,pau_minHeight,pau_maxWidth,pau_maxHeight,pau_saveWidth,pau_saveHeight,pau_timeout
end if
%>
<%
' *** Edit Operations: (Modified for File Upload) declare variables

Dim MM_editAction
Dim MM_abortEdit
Dim MM_editQuery
Dim MM_editCmd

Dim MM_editConnection
Dim MM_editTable
Dim MM_editRedirectUrl
Dim MM_editColumn
Dim MM_recordId

Dim MM_fieldsStr
Dim MM_columnsStr
Dim MM_fields
Dim MM_columns
Dim MM_typeArray
Dim MM_formVal
Dim MM_delim
Dim MM_altVal
Dim MM_emptyVal
Dim MM_i

MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")
If (UploadQueryString <> "" Then
MM_editAction = MM_editAction & "?" & Server.HTMLEncode(UploadQueryString)
End If

' boolean to abort record edit
MM_abortEdit = false

' query string to execute
MM_editQuery = ""
%>
<%
' *** Insert Record: (Modified for File Upload) set variables

If (CStr(UploadFormRequest("MM_insert") = "InsertListingForm" Then

MM_editConnection = MM_Conn_ThinkBig_STRING
MM_editTable = "Listings"
MM_editRedirectUrl = "addListing.asp"
MM_fieldsStr = "MLSNumber|value|Featured|value|NewListing|value|Sold|value|Active|value|Deposits|value|TableColor|value|PropertyRegion|value|ListingCategory|value|PropertyType|value|Bedrooms|value|Bathrooms|value|ListingAddress|value|PropertyCity|value|ListingState|value|ZipCode|value|ListingPrice|value|PropertyAge|value|ListingSqFt|value|ListingLotSize|value|AreaInfo|value|ListingDescriptionShort|value|ListingDesc|value|Remarks|value|Equipment|value|Amenities|value|Basement|value|PropertyView|value|ListingForm1|value|ListingForm2|value|ListingForm3|value|ListingImage1|value|ListingImage2|value|ListingImage3|value|ListingImage4|value|ListingImage5|value|ListingImage6|value|ListingImage7|value|ListingImage8|value|ListingImage9|value|ListingImage10|value|ListingImage11|value|ListingImage12|value|ListingImage13|value|ListingImage14|value|ListingImage15|value|ListingImage16|value|ListingImage17|value|ListingImage18|value|ListingImage19|value|ListingImage20|value"
MM_columnsStr = "MLSNumber|',none,''|Featured|none,1,0|NewListing|none,1,0|Sold|none,1,0|Active|none,1,0|Deposits|',none,''|TableColor|',none,''|PropertyRegion|',none,''|ListingCategory|',none,''|PropertyType|',none,''|Bedrooms|none,none,NULL|Bathrooms|none,none,NULL|ListingAddress|',none,''|PropertyCity|',none,''|ListingState|',none,''|ZipCode|',none,''|ListingPrice|none,none,NULL|PropertyAge|none,none,NULL|ListingSqFt|',none,''|ListingLotSize|',none,''|AreaInfo|',none,''|ListingDescriptionShort|',none,''|ListingDesc|',none,''|Remarks|',none,''|Equipment|',none,''|Amenities|',none,''|Basement|none,1,0|PropertyView|',none,''|ListingForm1|',none,''|ListingForm2|',none,''|ListingForm3|',none,''|ListingImage1|',none,''|ListingImage2|',none,''|ListingImage3|',none,''|ListingImage4|',none,''|ListingImage5|',none,''|ListingImage6|',none,''|ListingImage7|',none,''|ListingImage8|',none,''|ListingImage9|',none,''|ListingImage10|',none,''|ListingImage11|',none,''|ListingImage12|',none,''|ListingImage13|',none,''|ListingImage14|',none,''|ListingImage15|',none,''|ListingImage16|',none,''|ListingImage17|',none,''|ListingImage18|',none,''|ListingImage19|',none,''|ListingImage20|',none,''"

' create the MM_fields and MM_columns arrays
MM_fields = Split(MM_fieldsStr, "|"
MM_columns = Split(MM_columnsStr, "|"

' set the form values
For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
MM_fields(MM_i+1) = CStr(UploadFormRequest(MM_fields(MM_i)))
Next

' append the query string to the redirect URL
If (MM_editRedirectUrl <> "" And UploadQueryString <> "" Then
If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And UploadQueryString <> "" Then
MM_editRedirectUrl = MM_editRedirectUrl & "?" & UploadQueryString
Else
MM_editRedirectUrl = MM_editRedirectUrl & "&" & UploadQueryString
End If
End If

End If
%>
<%
' *** Insert Record: (Modified for File Upload) construct a sql insert statement and execute it

Dim MM_tableValues
Dim MM_dbValues

If (CStr(UploadFormRequest("MM_insert") <> "" Then

' create the sql insert statement
MM_tableValues = ""
MM_dbValues = ""
For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
MM_formVal = MM_fields(MM_i+1)
MM_typeArray = Split(MM_columns(MM_i+1),","
MM_delim = MM_typeArray(0)
If (MM_delim = "none" Then MM_delim = ""
MM_altVal = MM_typeArray(1)
If (MM_altVal = "none" Then MM_altVal = ""
MM_emptyVal = MM_typeArray(2)
If (MM_emptyVal = "none" Then MM_emptyVal = ""
If (MM_formVal = "" Then
MM_formVal = MM_emptyVal
Else
If (MM_altVal <> "" Then
MM_formVal = MM_altVal
ElseIf (MM_delim = "'" Then ' escape quotes
MM_formVal = "'" & Replace(MM_formVal,"'","''" & "'"
Else
MM_formVal = MM_delim + MM_formVal + MM_delim
End If
End If
If (MM_i <> LBound(MM_fields)) Then
MM_tableValues = MM_tableValues & ","
MM_dbValues = MM_dbValues & ","
End If
MM_tableValues = MM_tableValues & MM_columns(MM_i)
MM_dbValues = MM_dbValues & MM_formVal
Next
MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & " values (" & MM_dbValues & ""

If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command"
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close

If (MM_editRedirectUrl <> "" Then
Response.Redirect(MM_editRedirectUrl)
End If
End If

End If
%>
<%
Dim rs_Region
Dim rs_Region_numRows

Set rs_Region = Server.CreateObject("ADODB.Recordset"
rs_Region.ActiveConnection = MM_Conn_ThinkBig_STRING
rs_Region.Source = "SELECT * FROM PropertyRegion"
rs_Region.CursorType = 0
rs_Region.CursorLocation = 2
rs_Region.LockType = 1
rs_Region.Open()

rs_Region_numRows = 0
%>
<%
Dim rs_ListingCategory
Dim rs_ListingCategory_numRows

Set rs_ListingCategory = Server.CreateObject("ADODB.Recordset"
rs_ListingCategory.ActiveConnection = MM_Conn_ThinkBig_STRING
rs_ListingCategory.Source = "SELECT * FROM ListingCategory"
rs_ListingCategory.CursorType = 0
rs_ListingCategory.CursorLocation = 2
rs_ListingCategory.LockType = 1
rs_ListingCategory.Open()

rs_ListingCategory_numRows = 0
%>
<%
Dim rs_ListingType
Dim rs_ListingType_numRows

Set rs_ListingType = Server.CreateObject("ADODB.Recordset"
rs_ListingType.ActiveConnection = MM_Conn_ThinkBig_STRING
rs_ListingType.Source = "SELECT * FROM PropertyType"
rs_ListingType.CursorType = 0
rs_ListingType.CursorLocation = 2
rs_ListingType.LockType = 1
rs_ListingType.Open()

rs_ListingType_numRows = 0
%>
<%
Dim rs_TableColor
Dim rs_TableColor_numRows

Set rs_TableColor = Server.CreateObject("ADODB.Recordset"
rs_TableColor.ActiveConnection = MM_Conn_ThinkBig_STRING
rs_TableColor.Source = "SELECT * FROM TableColors"
rs_TableColor.CursorType = 0
rs_TableColor.CursorLocation = 2
rs_TableColor.LockType = 1
rs_TableColor.Open()

rs_TableColor_numRows = 0
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<script language="JavaScript" src="/ScriptLibrary/incPureUpload.js" type="text/javascript"></script>
<script language="javascript" src="../ScriptLibrary/incPureUpload.js"></script>
</style>
</head>

<body>
<form action="<%=MM_editAction%>" method="post" enctype="multipart/form-data" name="InsertListingForm" id="InsertListingForm" onSubmit="checkFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','');showProgressWindow('blueFlashProgress.htm',300,100);return document.MM_returnValue">
<table width="750" border="0" cellspacing="0" cellpadding="5" class="listing">
<tr>
<td> </td>
<td width="81%"> </td>
</tr>
<tr>
<td align="right" width="19%">MLS Number:</td>
<td><input name="MLSNumber" type="text" value="N/A" size="25" maxlength="6" />
</td>
</tr>
<tr>
<td align="right">Featured Listing</td>
<td><input name="Featured" type="checkbox" id="Featured" value="checkbox" /></td>
</tr>
<tr>
<td align="right">New Listing: </td>
<td><input name="NewListing" type="checkbox" id="NewListing" value="checkbox" checked="checked" /></td>
</tr>
<tr>
<td align="right">Sold:</td>
<td><input name="Sold" type="checkbox" id="Sold" value="checkbox" /></td>
</tr>
<tr>
<td align="right">Available:</td>
<td><input name="Active" type="checkbox" value="checkbox" checked="checked" /></td>
</tr>
<tr>
<td align="right">Deposits</td>
<td><input name="Deposits" type="text" id="Deposits" value="N/A" size="12" /></td>
</tr>
<tr>
<td align="right">Table Color </td>
<td><select name="TableColor" id="TableColor" onChange="setDynaList(arrDL1)">
<%
While (NOT rs_TableColor.EOF)
%>
<option value="<%=(rs_TableColor.Fields.Item("ColorValue".Value)%>"><%=(rs_TableColor.Fields.Item("ColorName".Value)%></option>
<%
rs_TableColor.MoveNext()
Wend
If (rs_TableColor.CursorType > 0) Then
rs_TableColor.MoveFirst
Else
rs_TableColor.Requery
End If
%>
</select></td>
</tr>
<tr>
<td align="right">Region:</td>
<td><select name="PropertyRegion" id="PropertyRegion" onChange="setDynaList(arrDL1)">
<%
While (NOT rs_Region.EOF)
%>
<option value="<%=(rs_Region.Fields.Item("PropertyRegionName".Value)%>"><%=(rs_Region.Fields.Item("PropertyRegionName".Value)%></option>
<%
rs_Region.MoveNext()
Wend
If (rs_Region.CursorType > 0) Then
rs_Region.MoveFirst
Else
rs_Region.Requery
End If
%>
</select>
</td>
</tr>
<tr>
<td align="right">Listing Gategory:</td>
<td><select name="ListingCategory" id="ListingCategory">
<%
While (NOT rs_ListingCategory.EOF)
%>
<option value="<%=(rs_ListingCategory.Fields.Item("CategoryName".Value)%>"><%=(rs_ListingCategory.Fields.Item("CategoryName".Value)%></option>
<%
rs_ListingCategory.MoveNext()
Wend
If (rs_ListingCategory.CursorType > 0) Then
rs_ListingCategory.MoveFirst
Else
rs_ListingCategory.Requery
End If
%>
</select></td>
</tr>
<tr>
<td align="right">Listing Type:</td>
<td><select name="PropertyType" id="PropertyType">
<%
While (NOT rs_ListingType.EOF)
%>
<option value="<%=(rs_ListingType.Fields.Item("PropertyTypeName".Value)%>"><%=(rs_ListingType.Fields.Item("PropertyTypeName".Value)%></option>
<%
rs_ListingType.MoveNext()
Wend
If (rs_ListingType.CursorType > 0) Then
rs_ListingType.MoveFirst
Else
rs_ListingType.Requery
End If
%>
</select>
</td>
</tr>
<tr>
<td align="right">Bedrooms:</td>
<td><select name="Bedrooms" id="Bedrooms">
<option value="0" selected="selected">None</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5 </option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
</select>
</td>
</tr>
<tr>
<td align="right">Bathrooms:</td>
<td><select name="Bathrooms" id="Bathrooms">
<option value="1" selected="selected">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
</select>
</td>
</tr>
<tr>
<td align="right">Address:</td>
<td><input type="text" name="ListingAddress" size="25" /></td>
</tr>
<tr>
<td align="right">City:</td>
<td><input name="PropertyCity" type="text" id="PropertyCity" size="25" /></td>
</tr>
<tr>
<td align="right">State:</td>
<td><select name="ListingState" id="ListingState">
<option value="" selected="selected">Choose a State </option>
<option value="UNK">Outside US / Canada </option>
<option value="AL">Alabama </option>
<option value="AK">Alaska </option>
<option value="AB">Alberta </option>
<option value="AS">American Samoa </option>
<option value="AZ">Arizona </option>
<option value="AR">Arkansas </option>
<option value="AA">Armed Forces Americas </option>
<option value="AE">Armed Forces Europe </option>
<option value="AP">Armed Forces Pacific </option>
<option value="BC">British Columbia </option>
<option value="CA">California </option>
<option value="CO">Colorado </option>
<option value="CT">Connecticut </option>
<option value="DE">Delaware </option>
<option value="DC">District Of Columbia </option>
<option value="FL">Florida </option>
<option value="GA">Georgia </option>
<option value="GU">Guam </option>
<option value="HI">Hawaii </option>
<option value="ID">Idaho </option>
<option value="IL">Illinois </option>
<option value="IN">Indiana </option>
<option value="IA">Iowa </option>
<option value="KS">Kansas </option>
<option value="KY">Kentucky </option>
<option value="LA">Louisiana </option>
<option value="ME">Maine </option>
<option value="MB">Manitoba </option>
<option value="MD">Maryland </option>
<option value="MA">Massachusetts </option>
<option value="MI">Michigan </option>
<option value="MN">Minnesota </option>
<option value="MS">Mississippi </option>
<option value="MO">Missouri </option>
<option value="MT">Montana </option>
<option value="NE">Nebraska </option>
<option value="NV">Nevada </option>
<option value="NB">New Brunswick </option>
<option value="NH">New Hampshire </option>
<option value="NJ">New Jersey </option>
<option value="NM">New Mexico </option>
<option value="NY">New York </option>
<option value="NF">Newfoundland </option>
<option value="NC">North Carolina </option>
<option value="ND">North Dakota </option>
<option value="MP">Northern Mariana Is </option>
<option value="NT">Northwest Territories </option>
<option value="NS">Nova Scotia </option>
<option value="OH">Ohio </option>
<option value="OK">Oklahoma </option>
<option value="ON">Ontario </option>
<option value="OR">Oregon </option>
<option value="PW">Palau </option>
<option value="PA">Pennsylvania </option>
<option value="PE">Prince Edward Island </option>
<option value="PQ">Province du Quebec </option>
<option value="PR">Puerto Rico </option>
<option value="RI">Rhode Island </option>
<option value="SK">Saskatchewan </option>
<option value="SC">South Carolina </option>
<option value="SD">South Dakota </option>
<option value="TN">Tennessee </option>
<option value="TX">Texas </option>
<option value="UT">Utah </option>
<option value="VT">Vermont </option>
<option value="VI">Virgin Islands </option>
<option value="VA">Virginia </option>
<option value="WA">Washington </option>
<option value="WV">West Virginia </option>
<option value="WI">Wisconsin </option>
<option value="WY">Wyoming </option>
<option value="YT">Yukon Territory </option>
</select></td>
</tr>
<tr>
<td align="right" valign="top">Zip Code: </td>
<td><input name="ZipCode" type="text" id="ZipCode" /></td>
</tr>
<tr>
<td align="right" valign="top">Price:</td>
<td><input type="text" name="ListingPrice" size="12" />
<br />
&lt;span class="legal"&gt;(e.g., &lt;b&gt;300000&lt;/b&gt<img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>&lt;/span&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right" valign="top"&gt;Age of Listing:&lt;/td&gt;
&lt;td&gt;&lt;input name="PropertyAge" type="text" id="PropertyAge" size="4" /&gt;
&lt;span class="legal"&gt;&lt;br /&gt;
(e.g., &lt;b&gt;64&lt;/b&gt<img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>&lt;/span&gt; &lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right" valign="top"&gt;Square Feet:&lt;/td&gt;
&lt;td&gt;&lt;input name="ListingSqFt" type="text" value="N/A" size="12" /&gt;
&lt;span class="legal"&gt;&lt;br /&gt;
(e.g., &lt;b&gt;1,401&lt;/b&gt<img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>&lt;/span&gt; &lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right" valign="top"&gt;Lot Size:&lt;/td&gt;
&lt;td&gt;&lt;input name="ListingLotSize" type="text" value="N/A" /&gt;
&lt;span class="legal"&gt;&lt;br /&gt;
(e.g., &lt;b&gt;5,801 - 7,250 sq. ft.&lt;/b&gt<img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>&lt;/span&gt; &lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Area Info: &lt;/td&gt;
&lt;td&gt;&lt;textarea name="AreaInfo" rows="8" wrap="PHYSICAL" id="AreaInfo"&gt;N/A&lt;/textarea&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right" valign="top"&gt;Short Description (Teaser) &lt;/td&gt;
&lt;td&gt;&lt;textarea name="ListingDescriptionShort" rows="8" wrap="PHYSICAL" id="ListingDescriptionShort"&gt;N/A&lt;/textarea&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right" valign="top"&gt;Description:&lt;/td&gt;
&lt;td&gt;&lt;textarea name="ListingDesc" rows="4" wrap="PHYSICAL" id="ListingDesc"&gt;N/A&lt;/textarea&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right" valign="top"&gt;Realtor Remarks:&lt;br /&gt;
&lt;b class="legal"&gt;[internal use only]&lt;/b&gt;&nbsp;&lt;/td&gt;
&lt;td&gt;&lt;textarea name="Remarks" rows="4" wrap="PHYSICAL" id="Remarks"&gt;N/A&lt;/textarea&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right" valign="top"&gt;Equipment:&lt;/td&gt;
&lt;td&gt;&lt;textarea name="Equipment" rows="2" wrap="PHYSICAL" id="Equipment"&gt;Not available.&lt;/textarea&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right" valign="top"&gt;Amenities:&lt;/td&gt;
&lt;td&gt;&lt;textarea name="Amenities" rows="2" wrap="PHYSICAL" id="Amenities"&gt;Not available.&lt;/textarea&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Basement:&lt;/td&gt;
&lt;td&gt;&lt;input type="checkbox" name="Basement" value="checkbox" checked="checked" /&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;View:&lt;/td&gt;
&lt;td&gt;&lt;input name="PropertyView" type="text" id="PropertyView" value="N/A" size="25" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td colspan="2" align="right"&gt;&nbsp;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Upload PDF file 1: &lt;/td&gt;
&lt;td align="right"&gt;&lt;div align="left"&gt;
&lt;input name="ListingForm1" type="file" id="ListingForm1" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;
&lt;/div&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Upload FDF file 2: &lt;/td&gt;
&lt;td align="right"&gt;&lt;div align="left"&gt;
&lt;input name="ListingForm2" type="file" id="ListingForm2" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;
&lt;/div&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Upload PDF file 3: &lt;/td&gt;
&lt;td align="right"&gt;&lt;div align="left"&gt;
&lt;input name="ListingForm3" type="file" id="ListingForm3" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;
&lt;/div&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td colspan="2" align="right"&gt;&nbsp;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Image 1 &lt;/td&gt;
&lt;td align="right"&gt;&lt;div align="left"&gt;
&lt;input name="ListingImage1" type="file" id="ListingImage1" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;
&lt;/div&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Image 2 &lt;/td&gt;
&lt;td align="right"&gt;&lt;div align="left"&gt;
&lt;input name="ListingImage2" type="file" id="ListingImage2" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;
&lt;/div&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Image 3 &lt;/td&gt;
&lt;td align="right"&gt;&lt;div align="left"&gt;
&lt;input name="ListingImage3" type="file" id="ListingImage3" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;
&lt;/div&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td height="29" align="right"&gt;Image 4 &lt;/td&gt;
&lt;td align="right"&gt;&lt;div align="left"&gt;
&lt;input name="ListingImage4" type="file" id="ListingImage4" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;
&lt;/div&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td height="29" align="right"&gt;Image 5 &lt;/td&gt;
&lt;td align="right"&gt;&lt;div align="left"&gt;
&lt;input name="ListingImage5" type="file" id="ListingImage5" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;
&lt;/div&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td height="29" align="right"&gt;Image 6 &lt;/td&gt;
&lt;td align="right"&gt;&lt;div align="left"&gt;
&lt;input name="ListingImage6" type="file" id="ListingImage6" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;
&lt;/div&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Image 7 &lt;/td&gt;
&lt;td&gt;&lt;input name="ListingImage7" type="file" id="ListingImage7" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Image 8 &lt;/td&gt;
&lt;td&gt;&lt;input name="ListingImage8" type="file" id="ListingImage8" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Image 9 &lt;/td&gt;
&lt;td&gt;&lt;input name="ListingImage9" type="file" id="ListingImage9" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Image 10 &lt;/td&gt;
&lt;td&gt;&lt;input name="ListingImage10" type="file" id="ListingImage10" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Image 11 &lt;/td&gt;
&lt;td&gt;&lt;input name="ListingImage11" type="file" id="ListingImage11" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Image 12 &lt;/td&gt;
&lt;td&gt;&lt;input name="ListingImage12" type="file" id="ListingImage12" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Image 13 &lt;/td&gt;
&lt;td&gt;&lt;input name="ListingImage13" type="file" id="ListingImage13" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Image 14 &lt;/td&gt;
&lt;td&gt;&lt;input name="ListingImage14" type="file" id="ListingImage14" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Image 15 &lt;/td&gt;
&lt;td&gt;&lt;input name="ListingImage15" type="file" id="ListingImage15" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Image 16 &lt;/td&gt;
&lt;td&gt;&lt;input name="ListingImage16" type="file" id="ListingImage16" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Image 17 &lt;/td&gt;
&lt;td&gt;&lt;input name="ListingImage17" type="file" id="ListingImage17" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt; &lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Image 18 &lt;/td&gt;
&lt;td&gt;&lt;input name="ListingImage18" type="file" id="ListingImage18" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Image 19 &lt;/td&gt;
&lt;td&gt;&lt;input name="ListingImage19" type="file" id="ListingImage19" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;Image 20 &lt;/td&gt;
&lt;td&gt;&lt;input name="ListingImage20" type="file" id="ListingImage20" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,PDF',false,'','','','','','','')" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align="right"&gt;&nbsp;&lt;/td&gt;
&lt;td&gt;&lt;input type="submit" value="Add Listing" class="button" onMouseOver="this.className='buttonover'" onMouseOut="this.className='button'" /&gt;
&lt;input type="button" value="Cancel" class="button" onClick="location.href='listings.asp'" onmouseover="this.className='buttonover'" onMouseOut="this.className='button'" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;






&lt;input type="hidden" name="MM_insert" value="InsertListingForm" /&gt;
&lt;/form&gt;
&lt;/body&gt;
&lt;/html&gt;

&lt;%
rs_Region.Close()
Set rs_Region = Nothing
%&gt;
&lt;%
rs_ListingCategory.Close()
Set rs_ListingCategory = Nothing
%&gt;
&lt;%
rs_ListingType.Close()
Set rs_ListingType = Nothing
%&gt;
&lt;%
rs_TableColor.Close()
Set rs_TableColor = Nothing
%&gt;

Reply to this topic