Could all of this be avoided if I just used the createUUID() function to insert a userID into my users table instead of using autonumber? I am starting this thing from scratch, so I could removed the auto_increment from the userID if I have to.
I am assuming that I would then pass the UUID to both the insertUser method in the users component and the insertSubscriber method in the newsletter component. Is that correct? The waters are a little muddy for me... -Aaron On 2/10/06, Aaron Roberson <[EMAIL PROTECTED]> wrote: > Mike, > > I will look into that. I thought as long as I wrapped the insert user > query and the select user query (with the max() function) in a > cftransaction tag that I would eliminate race conditions and therefore > would return the correct userID. Is that incorrect? > > About getting the userID to the newsletter component, I am thinking > maybe I should invoke the insertUser method from within my > insertSubscriber method, but I don't know how that would work because > I am not that advanced at CFC's. > > Thanks, > Aaron > > On 2/10/06, Mike Soultanian <[EMAIL PROTECTED]> wrote: > > remember, max may not give you what you want, especially if another user > > inserts a record just in between the time when you insert your record > > and then poll for the max id. > > > > I'm not sure if mysql supports nextval (like oracle), but you might want > > to do something like this instead: > > > > http://jamesthornton.com/software/coldfusion/nextval.html > > > > enjoy, > > Mike > > > > Aaron Roberson wrote: > > > Thanks for the link! > > > > > > Actually, I do know how to get the unique ID with the MAX() function in > > > SQL. > > > > > > I guess my real question is how do I pass the unique ID from one > > > method in the users component into another method in the newsletter > > > component? Can anyone help with that? > > > > > > -Aaron > > > > > > On 2/10/06, C. Hatton Humphrey <[EMAIL PROTECTED]> wrote: > > >>> I am running MySQL 4.0.25 remotely on my production server and 4.1.12 > > >>> on my local box. > > >> I can't help you with the CFC's but you mihgt look into this page for > > >> some help > > >> http://dev.mysql.com/doc/refman/5.0/en/getting-unique-id.html > > >> Hatton > > >> > > >> > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231973 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
