Thanks mate I think that's the plan - override create and update in my UserDOAMySQL4.cfc and create a new method checkLogin in UserGatewayMySQL4.cfc
On 7/6/06, Doug Sims <[EMAIL PROTECTED]> wrote:
I would extend your user record and add the new methods to check and update/insert the logins using you existing sql and methodology. you could then call these methods off of the UserRecord just like and other reactor generated calls. If you have not extended a reactor record object yet, I posted a simple example to my blog last week at http://evenamonkey.com/extending_reactor_record_objects--2006--doug_sims Hope this helps, Doug S. On 7/5/06, Mark Stanton < [EMAIL PROTECTED]> wrote: > Hi All > > On a system I'm working on we use MySQL's PASSWORD() function to store > and compare user logins. > > For example a typical create user query would be: > > INSERT INTO user (username, password) > VALUES ('#username#', PASSWORD('#password#') > > and then checking the login would be > > SELECT userUUID > FROM user > WHERE username = '#username#' and password = 'PASSWORD('#password#') > > I've been puzzling over how this could be done using Reactor, or if it > can't how would I best integrate this funcitonality with a Reactor > based system. Do I have to resort to not using a UserRecord object at > all? > > I'd really like to avoid cf's hash() or encrypt() functions if > possible, for some reason doing this at the database level feels > intrinsically better. Maybe this is where I am wrong? > > Thanks in advance > > Mark > > -- > Mark Stanton > Gruden Pty Ltd > http://www.gruden.com > > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > Reactor for ColdFusion Mailing List > [email protected] > Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- Mark Stanton Gruden Pty Ltd http://www.gruden.com -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
