file upload

Hey Jason

I have a file upload section on an _insert and _update page which adds the file absolutely fine. If I go to the update page and update something else (without adding the image file) then the filename gets removed from the database whn I click on update...

How would I stop that from happening?

Cheers

Jamie

add a hidden form element to the update page.

bind the hidden form element to the file column from the recordset on the page.

in the File Upload behavior, bind the Default File setting to the hidden form element.

Have done that (I think)

<input type="hidden" name="LogoHidden" id="LogoHidden" value="<?php echo $row_WADAsponsor_info['SponsorLogo']; ?>"/>

but it isnt working...

ok, i'll need to see the entire page then to see the rest of the code.

It's always better to attach the page rather than paste a small code snippet. that snippet doesn't tell me anything about how the upload behavior is configured, or how the Update behavior is configured. from that snippet i cannot get a full view of the page, i don't even know if it is using the correct recordset, or if the recordset select statement includes the file column...

no probs.. see attached

Also, have noticed that even though I set it to change all image filetypes to jpg, it doesnt....if I upload a gif or png it keeps it as a png or gif

in the update behavior you have bound the SponsorLogo field to the file field binding in the form collection.

you need to use the WA Uploaded Files (SponsorLogo) -> Server File name binding instead.

sorry. not sure what I need to change?

  in the update behavior you have bound the SponsorLogo field to the file field binding in the form collection.

you need to use the WA Uploaded Files (SponsorLogo) -> Server File name binding instead.  

look on the binding panel.

you should see that there is a binding group named WA Uploaded Files (SponsorLogo), in this binding group is a binding named Server File name

you need to edit the Update record server behavior.

currently the SponsorLogo filed is bond to the file field in the form collection, this is the problem.

you need to edit that field and bind it to the WA Uploaded Files (SponsorLogo) -> Server File name binding instead

I have tried doing that to either the hidden field or the upload file behaviouor but it didnt work....

you don't need to bind the hidden field to the server file name binding,

you need to use the server file name binding in the Update record behavior.

when say "but it didn't work", please be more specific. In what way did it not work?

give me a copy of that page that has thew updates on it so i can see the code.