I guess I'm probably the rebel here, but I just completed some modifications to our company's forum post interface that contains both text input and file attachments.
The user enters the title in one input box and if the user wants to attach a file, clicks an 'attach file' link below the text area. When the link is clicked, a javascript function is called and places a file input box on the screen below the link. If clicked again, and input exists in the first file input, another file input box appears below the first. This allows the user to attach as many files as necessary. Once the post button is clicked, the title and post is validated and stored followed by the attachments. I use the ColdFusion UUID as the ID for the post so I already know the ID before the message is saved. I hope this helps, Mike Harman >Hi, all... > >I'm designing part of an app that will allow users >to input info and photos for newly constructed communities. >(Real Estate site) > >I'm going to allow the users to input unlimited photos for each >community. There will be one table holding the textual info about >each property and another table in the db holding the photos. >Therefore, the photos will need to be linked via foreign key >in the db to the property table. > >That said, I'm wondering what approach to take for the input of photos. > >First Approach: > >1) Users input textual information and submit >2) Users then click on link to upload photos which will provide the >community_id > to connect the photos to the property identified in the URL variable. > >Second Approach: > >1) Users input all data on the same page...textual and photos. >2) For processing, textual data is input first >3) New id for the property is retrieved >4) Photos are uploaded, processed, and put into the db connected to the >property > via the community_id created in the insert query for the textual info. > >The first approach is more trouble for the user, but easier. >The second approach is preferable if I can consistently retrieve that last id >inserted without any problem. > >I know this is discussed and debated from time-to-time, but I thought I'd ask >again, now that I'm on CF 8 and MySQL 5.0. > >Thoughts, anyone? > >Thanks, > >Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301819 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4