My personal preference is a riff of version 1. I input the text info, and hit save (or "add photos" or "step 2") The data gets validated and written, and now I get the input fields for the photos (on a new page, or on the same page with a new section added at the bottom)
On Sat, Mar 22, 2008 at 2:10 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > 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:301792 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
