Yes, that is what I am trying to do. Once that is done I will change that varchar to a number field. I imported the users from an excel spreadsheet and am being lazy and trying to let access do the work, but it is only 34 people so I will probably just do it by hand.
On Thu, Jul 29, 2010 at 10:27 AM, Judah McAuley <ju...@wiredotter.com>wrote: > > 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: > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:324089 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
