Upload File Using Form Wizard
vitodcNov 16 2005 — edited Nov 17 2005Hi,
I have completed the how-to on upload and downloading files from the documentation.
I have a custom table that I would like to use to store the image along with other values.
I create a form using the Form and Report wizard in htmldb 2.0.
I am having problems when it comes to changing where the image is upload, HTMLDB_APPLICATION_FILES to custom table.
<code>
IF ( :P2_FILE_NAME is not null ) THEN
INSERT INTO file_subjects(id,NAME, SUBJECT, BLOB_CONTENT, MIME_TYPE)
SELECT ID,:P2_FILE_NAME,:P2_SUBJECT,blob_content,mime_type
FROM HTMLDB_APPLICATION_FILES WHERE name = :P2_FILE_NAME;
DELETE from HTMLDB_APPLICATION_FILES WHERE name = :P2_FILE_NAME;
END IF;
</code>
I know it works fine if I create the page manually, but then I need to create insert, update, delete and cancel processes; all of which the wizard can handle.
Is there a better solution?
Thanks
VC