Requesting data from a file field whilst uploading from it 1

[walderr]

Right, this should be quick and easy in theory: I'm using a pure upload to upload documents and update a database at the same time. If the user chooses not to upload a file (ie leaves the file field blank), I want to either keep the database the same, or insert some other text if the field for that record is currently blank. It appears that you can't just request the file field ("PictureLocationField", see code below) using "Uploader.Form" when you're uploading from it, as it always returns as blank. Is there a way that I can vary my output depending on whether the user inserts text in this field or not?


If type_of_submit = "Amend" Then
objRS("ID Number&quot = IDNumber
objRS("Part Name&quot = PartName
objRS("Custodian&quot = Custodian
objRS("Date Last Modified&quot = UpdateModified
objRS("Date Added&quot = UpdateAdded
objRS("Country&quot = Country
objRS("Part Application&quot = PartApplication

If PictureLocationField = "" then
If PictureServerPath = "" then
objRS("Picture Server Path&quot = "Images/noimage.jpg"
objRS("Picture File&quot = "noimage.jpg"
else
objRS("Picture Server Path&quot = PictureServerPath
objRS("Picture File&quot = PictureFile
end If
else
objRS("Picture Server Path&quot = UpdatePictureServerPath
objRS("Picture File&quot = UpdatePictureFile
end If

end If
objRS.Update

 

[ehsant]

Hi...
as you have Uploader.Form, you also shuld have Uploader.File (I think the Uploader is an instance of your object) and this object, shuld have a property like Count or something like it which you can check :
If Uploader.File.Cound > 0 Then
Do something...
Else
Do Something else
End If

----
TNX.
E.T.