Hi Jason, I too would like to name the image the same as the record ID. I have followed this post and moved the upload behaviour to after the insert record behaviour, name the file name as the session id, but get the following error message
Microsoft JScript runtime error '800a138f'
'WA_DFP_UploadStatus.WA_UploadResult1.serverFileName' is null or not an object
/Properties_Insert4.asp, line 131 - This is set in the insert record server behaviour (as on the solution recipe).
// WA Application Builder Insert
if (String(WA_DFP_UploadObj.Form("Insert.x")) != "undefined") {
var WA_connection = MM_blanug439_STRING;
var WA_table = "Properties";
var WA_sessionName = "Properties_MainPropertiesID";
var WA_redirectURL = "";
var WA_keepQueryString = false;
var WA_indexField = "MainPropertiesID";
var WA_fieldNamesStr = "FirstName|LastName|Company|PropertyType|SaleORLease|RegionName|Address1|Address2|City|County|PostCode|Country|Thumb|AgentLogo|PropertyDetails|Size|Sep|SizeMax|SizeType|shortDescription|longdescription|Price|Status";
var WA_fieldValuesStr = "" + String((WADAMembers.Fields.Item("FirstName").Value)) + "" + "|" + "" + String((WADAMembers.Fields.Item("LastName").Value)) + "" + "|" + "" + String((WADAMembers.Fields.Item("Company").Value)) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("PropertyType")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("SaleORLease")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("RegionName")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("Address_1")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("Address2")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("City")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("County")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("PostCode")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("Country")) + "" + "|" + "" + String(WA_DFP_UploadStatus["WA_UploadResult1"].serverFileName) + "" + "|" + "" + String((WADAMembers.Fields.Item("AgentLogo").Value)) + "" + "|" + "" + String(WA_DFP_UploadStatus["WA_UploadResult2"].serverFileName) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("Size")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("Separator")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("SizeMax")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("SizeType")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("shortDescription")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("longdescription")) + "" + "|" + "" + String(WA_DFP_UploadObj.Form("Price")) + "" + "|" + "Awaiting Approval";
var WA_columnTypesStr = "',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|none,none,NULL|',none,''|none,none,NULL|',none,''|',none,''|',none,''|',none,''|',none,''";
var WA_comparisonStr = " LIKE | LIKE | LIKE | LIKE | LIKE | LIKE | LIKE | LIKE | LIKE | LIKE | LIKE | LIKE | LIKE | LIKE | LIKE | = | LIKE | = | LIKE | LIKE | LIKE | LIKE | LIKE ";
var WA_fieldNames = WA_fieldNamesStr.split("|");
var WA_fieldValues = WA_fieldValuesStr.split("|");
var WA_columns = WA_columnTypesStr.split("|");
var WA_comparisons = WA_comparisonStr.split("|");
var insertParamsObj = WA_AB_generateInsertParams(WA_fieldNames, WA_columns, WA_fieldValues);
var MM_editCmd = Server.CreateObject('ADODB.Command');
MM_editCmd.ActiveConnection = WA_connection;
MM_editCmd.CommandText = "INSERT INTO " + WA_table + " (" + insertParamsObj.WA_tableValues + ") VALUES (" + insertParamsObj.WA_dbValues + ")";
MM_editCmd.Execute();
MM_editCmd.ActiveConnection.Close();
var obj = WA_AB_generateWhereClause(WA_fieldNames, WA_columns, WA_fieldValues, WA_comparisons);
var sqlstr = "SELECT " + WA_indexField + " FROM " + WA_table + " WHERE " + obj.sqlWhereClause + " ORDER BY " + WA_indexField + " DESC";
var WA_AppBuilderRecordset = Server.CreateObject("ADODB.Recordset");
WA_AppBuilderRecordset.ActiveConnection = WA_connection;
WA_AppBuilderRecordset.Source = sqlstr;
WA_AppBuilderRecordset.CursorType = 0;
WA_AppBuilderRecordset.CursorLocation = 2;
WA_AppBuilderRecordset.LockType = 1;
WA_AppBuilderRecordset.Open();
if (!WA_AppBuilderRecordset.EOF) {
Session(WA_sessionName) = WA_AppBuilderRecordset.Fields.Item(WA_indexField).Value;
}
WA_AppBuilderRecordset.Close();
if (WA_redirectURL != "") {
if (WA_keepQueryString && WA_redirectURL != "" && Request.QueryString && Request.QueryString.Count > 0) {
WA_redirectURL += ((WA_redirectURL.indexOf('?') == -1)?"?":"&") + Request.QueryString;
}
Response.Redirect(WA_redirectURL);
}
}
%>
<%
WA_DFP_SetupUploadStatusStruct("WA_UploadResult1");
if(WA_DFP_UploadStatus["WA_UploadResult1"].statusCode == 1){
WA_DFP_UploadFile("WA_UploadResult1", "Thumb", "userfiles/Thumbs/noimage.jpg", "userfiles/Thumbs/", "" + String( Session("Properties_MainPropertiesID") ) + "", "2", "[FileName]_[Increment]", "1024", "false", "0", "0");
}
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">