This is still kind of weird looking to me. The query as G put it would seem like it is trying to convert the current rank that a User has from a text value to an id of the equivalent row in the Rank table. That would, amongst other things, mean that you're going to be now storing all numeric values in a varchar field. Is that what you're trying to do?
On Thu, Jul 29, 2010 at 9:24 AM, G Money <gm0n3...@gmail.com> wrote: > > On Thu, Jul 29, 2010 at 11:09 AM, Bruce Sorge <sor...@gmail.com> wrote: > >> >> UPDATE Users >> SET Users.User_Rank = (Select Rank_ID FROM Rank >> Where Users.User_Rank = >> (Select Rank.Rank_Name >> FROM Rank)); >> > > Will an Update...From work? Something like: > > UPDATE Users > SET Users.User_Rank = Rank.Rank_ID > FROM Users > JOIN Rank ON Users.User_Rank = Rank.Rank_Name > > -- > I've seen your flag on the marble arch > Love is not a victory march > It's a cold and it's a broken Hallelujah > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:324087 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
