I'm working on a form that will add/edit task details. One of the requirements is the ability to upload files into the database.
If a task is being EDITED, the upload is no problem; I'm using a hidden iframe to handle the upload, and the task will have a task ID that the file will be associated with.
However, if a task is being ADDED, there is no existing task ID, so the file needs to be uploaded with the rest of the form. Unfortunately, jQuery .post() using the .serialize() attribute for the form breaks file uploads, because the form isn't multipart/form-data, at that point.
Does anyone have any suggestions on how to allow a file upload if the form is being submit via jQuery.post("document.cfm",serialize(formobject))?