I am trying to revise the portion of the upload script that checks to see if there is a MM_INSERT or MM_UPDATE I am not using Ultradev's server behavior for updating records. I’m simply writing out the SQL statement that will do the update:

Dim id, NewImage
id = Request.QueryString("EmployeeID"
NewImage = Request("FileField" ' The one used for identifying the image to upload

SQL = "UPDATE Employees SET Picture ='" & NewImage & "' WHERE EmployeeID = " & id

The problem is that in order for me to get the value of the newly uploaded picture I need to TRIM to just get the name of the file and not its location. How do I just get the name of the file that is being uploaded and also how do I implement just updating using a SQL UPDATE and not ultradev's update server behavior?

Thanks and any help would help.