I have an update form where there is a student record that has a picture as well as other info. It is with the picture that I am having a problem. The form has a file field with id="picture" name="picture" and then a simple dynamic record call to display the picture right below this file field. The problem is, if I am not updating the picture itself, the entry for the picture in the database gets removed, presumably because I had not entered anything into the file field. The code that controls this is:
It appears that this code says "I there is a posted value from the picture field, add this to the SQL update statement. If not, leave it empty. It removes the entry. What I need is that if I have not selected a new picture, the old picture record is left as is. As it is now, the picture gets removed if I do not reselect it as part of the update.
Can post more code if necessary.