Thanks, I needed to check whether there was a built-in DataAssist behaviour but as there wasn't, I have followed your advice.
Because I was ALSO inserting the filename from a file uploaded by WA DigitalFilePro, I had to modify the Check New User Name code.
Here it is for anyone else reading this post. I have commented out the Dreanweaver lines I had to modify.
' *** Redirect if username exists
'MM_flag = "MM_insert" ***** Removed
'If (CStr(Request(MM_flag)) <> "") Then *****Replaced code with the line below
if (cStr(WA_DFP_UploadObj.Form("Insert.x")) <> "") Then
Dim MM_rsKey
Dim MM_rsKey_cmd
MM_dupKeyRedirect = "index.asp"
'MM_dupKeyUsernameValue = CStr(Request.Form("jobDescription")) *****Replaced code with the line below
MM_dupKeyUsernameValue = cStr(WA_DFP_UploadObj.Form("jobDescription"))
Set MM_rsKey_cmd = Server.CreateObject ("ADODB.Command")
MM_rsKey_cmd.ActiveConnection = MM_printShop_STRING
MM_rsKey_cmd.CommandText = "SELECT jobDescription FROM jobDescriptions WHERE jobDescription = ?"
MM_rsKey_cmd.Prepared = true
MM_rsKey_cmd.Parameters.Append MM_rsKey_cmd.CreateParameter("param1", 200, 1, 50, MM_dupKeyUsernameValue) ' adVarChar
Set MM_rsKey = MM_rsKey_cmd.Execute
If Not MM_rsKey.EOF Or Not MM_rsKey.BOF Then
' the username was found - can not add the requested username
MM_qsChar = "?"
If (InStr(1, MM_dupKeyRedirect, "?") >= 1) Then MM_qsChar = "&"
MM_dupKeyRedirect = MM_dupKeyRedirect & MM_qsChar & "requsername=" & MM_dupKeyUsernameValue
Response.Redirect(MM_dupKeyRedirect)
End If
MM_rsKey.Close
End If
%>
SUGGESTION - You should add this invaluable behaviour to DataAssist