close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

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

Thread began 2/20/2010 4:57 pm by robert254422 | Last modified 2/21/2010 2:51 pm by robert254422 | 993 views | 2 replies |

robert254422

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

Sign in to reply to this post

anonymous

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

Sign in to reply to this post

robert254422

Tyvm

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

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...