So I would just code my CF referencing and UUID as I do my primary auto-incrementing, integer keys now?
As in: a href="community.cfm?community_UUID=#get_community.community_UUID#" ??? Rick > -----Original Message----- > From: Mark Fuqua [mailto:[EMAIL PROTECTED] > Sent: Sunday, March 23, 2008 6:35 PM > To: CF-Talk > Subject: RE: Which approach to take? > > 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:301866 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
