If you make the UUID an alternate key, you don't even have to change the structure of you table. Your primary key can stay the same as it is now.
Mark -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 12:05 AM To: CF-Talk Subject: RE: Which approach to take? > I use the ColdFusion UUID as the ID > for the post so I already know the ID before the message is saved. I guess using the UUID would make that approach work well. I'll have to check into that. Rick > -----Original Message----- > From: Mike Harman [mailto:[EMAIL PROTECTED] > Sent: Sunday, March 23, 2008 12:11 AM > To: CF-Talk > Subject: Re: Which approach to take? > > 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:301864 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
