Keep the width of img stored in db on insert after updating text but not image

I use Data Assist and Digital File PRO and all works fine... I have 1 question...

When i insert a person in dbase and their imagefile gets uploaded I save the width and height of the uploaded image in db aswell using hidden fields and upload bindings... Works great..

Then when I update the person but not the pic I keep filename of picture through using the DefaultFilename... Works great... But now!!!

I see no method for doing the same thing for the width and height that was stored for the pic on the insert.. These 2 fields do get overwritten in the update with empty values when not uploading a new pic during the update...

Is there a way and if so could someone point me in that direction?

WKR

RV

Hi Robert,

The thing I would do is just a bit of hand coding if you are comfortable doing it.

How I would do it would be to first create hidden fields that contain the width and height of the original image in your form.

Then inside your update code after the trigger for when the form is posted, make a few modifications.

Create arbitrary variables and write a simple "if" statement to see if there was a new image in the upload field like this:

if ($_POST['imagefile'] != "" OR $_POST['imagefile] != "NULL") {
$imagewidth = DFPimagewidth;
$imageheight = DFPimageheight;
} else {
$imagewidth = hiddenfieldwidth;
$imageheight = hiddenfieldheight;

}



Then in the actual update statement, change the value received by the image width column to "$imagewidth" and the image height column to "$imageheight".

Hope that helps,

Brian

Hi Brian,

Ty for your reply!

Learning to handcode things is what I am aiming for...

It seems pretty straight forward...

I will post back with some details when I get this to work...

WKR

RV