Oh sorry. I am using ASP for this one. But everything is done with a stored proc so I guess this is a SQL post.
On Sun, Oct 24, 2010 at 2:09 PM, Jochem van Dieten <joch...@gmail.com>wrote: > > On Sun, Oct 24, 2010 at 10:52 AM, Monique Boea wrote: > > I insert the password like this: > > VALUES (@strUsername, HashBytes('MD5', @strPassword), > > > > I retrieve it on the log in like this: > > AND password= > > HashBytes('MD5',CONVERT(nvarchar,@strPassword)) > > That was in your previous post already. What is missing in your post > is how you pass the variable from ColdFusion to the database and how > your datasource is configured. > > Jochem > > -- > Jochem van Dieten > http://jochem.vandieten.net/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm