Image Upload Querstion

I have created an upload page.

I need to insert the image params into a table and then show the uploaded image on the same page.
The user can only submit upto a max of 12 images.

1. What order should my code be in?
2. how best should i restrict the upload to 12 (on the Upload or insert user behavior?

Thanks, Paul.

The order would be the upload code and then the insert or update into the database.

How you would limit it would depend on the database structure and user experience you want to support.

You could insert a new row into a related table for each image and add a recordset to determine how many rows they have already inserted and then don't allow another insert once they reach 12 with server validation... but there are a lot of other ways you could do it depending on how you wanted it to work.

Hi Ray, thanks for replying.

I think server validation is more robust than hiding the upload form when the recordset hits 12.
What would be my approach using the server validation on that page?

You would still add the recordset, then apply number validation to the number of rows variable with a max value of 12.

im trying to apply the following validation to an image upload that ive built using DB

successful, failed, type, size, width and height.

I'm not sure whether i should be using their error code values when building the server bevaiours aswell and if so how they should be included in each 'server validation show: region if...'

I've looked for a WA help vid, but unable find - File attached in PM.

Since you are validating a value from the recordset, you will have to manually move the validation code below the recordset.

So take the code on lines: 9-23 and move it below the recordsets... probably just above the doctype tag.

Thanks Ray, that makes sense.

I'm struggling to implement the upload limit validation.

My current thinking is show the upload form whilst my 'count' recordset is empty (not equal to twelve)
However, if i use the 'show if' validation and select the pass validation option, my form is hidden from scratch.

What logic works for this scenario?



Also as a seperate but related issue, i note that the narrative on the wizard refers to deleting a file rather than uploading it.
see screenshot attached.... or have i missed something?

Looks like we missed something, not you... I'll update the text for the next release.

I would think you would show the upload field if it passed validation using the validation show if... not based on the recordset directly.