Skip to main content
Participant
September 11, 2008
Question

File Upload utility functionality

  • September 11, 2008
  • 1 reply
  • 363 views
I created a record keeping system where the user 3 uploads a files. When the user opens the system the second time to upload new files and perhaps only uploads 1 file the database records of the two other files are overwritten and not maintained. How do I correct this issue. The action page has been included.
This topic has been closed for replies.

1 reply

Inspiring
September 11, 2008
Tony Soto wrote:
> I created a record keeping system where the user 3 uploads a files. When the
> user opens the system the second time to upload new files and perhaps only
> uploads 1 file the database records of the two other files are overwritten and
> not maintained. How do I correct this issue. The action page has been included.
...
> Attachm1='#Trim(Form.Attachment_1)#',
> Attachm2='#Trim(Form.Attachment_2)#',
> Attachm3='#Trim(Form.Attachment_3)#',
...

This section of your update SQL is writing to all three attachment
fields, even if the form fields are empty. The simplest solution is
probably to make this section dynamic so that the Attachment fields are
only updated if the form fields actually contain a valid value.
Sandy_SAuthor
Participant
September 11, 2008
Hi Ian,
thanks for the response. How do I go about make the SQL statement dynamic?