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:301791 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
