close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Update Image Simply Query?

Thread began 12/19/2010 5:53 pm by clive.henderson222953 | Last modified 2/11/2011 10:38 am by Jason Byrnes | 1279 views | 8 replies |

clive.henderson222953

Update Image Simply Query?

Hi
I have an update page that updates both text and an image field.

This all seems to work OK except when I don't upload an image in which case the image field is set to blank losing the valid details that were in there.

I can't figure out how to ignore updating this field if an image has not been browsed.


Any pointers appreciated
Thanks
Clive

Sign in to reply to this post

Dave BuchholzBeta Tester

What are you using to upload your image ? Digital File Pro or something else ?

Can you post the page in question, it may be as simple as changing an isset check to an empty check.

Sign in to reply to this post

clive.henderson222953

Originally Said By: Dave Buchholz
  What are you using to upload your image ? Digital File Pro or something else ?

Can you post the page in question, it may be as simple as changing an isset check to an empty check.  



Thanks you very much for helping me. I'm using the File_Upload functionality but can't see any menth of isset in th wizard. 'm also using dataassist for the record update. I'll check this next after my vacation.
Many thanks again for the pointer
Clive

Sign in to reply to this post

Ray BorduinWebAssist

Just set the "default value" in the server behavior to be the current value in the database and then the value won't change when it is left blank since it will use the default.

Sign in to reply to this post

twitchr377598

Originally Said By: Ray Borduin
  Just set the "default value" in the server behavior to be the current value in the database and then the value won't change when it is left blank since it will use the default.  



My page is doing the same thing. I set the default value, but it's still deleting the image name from my database if I don't upload an image.

I have attached a file with the pertinent information to see if anything sticks out at you guys. Dreamweaver CS5 and Universal Email 4.0.1

Thanks in advance,
Twitch

Attached Files
test.zip
Sign in to reply to this post

Ray BorduinWebAssist

It appears there is no recordset on the page... maybe it was deleted?

Sign in to reply to this post

Jason ByrnesWebAssist

you are using a recordset value for the default image, most likely the recordset does not have any rows in it when the form is posted.


create a hidden form element, set the hidden form element to use the recordset column for it's value, thenn bind the default image to the hidden form element.

Sign in to reply to this post

twitchr377598

I have recordsets on the page, I just didn't put them in the file. I thought you guys would be able to tell from your code and the form and you did. The hidden field was it. I totally forgot to use it. I knew I was missing something, but couldn't find the solution recipes. I finally found the one I was looking for and it's working great now.

Thanks again for the replies.

Sign in to reply to this post

Jason ByrnesWebAssist

glad to hear it is working.

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...