You're trying to mix CF and SQL, which doesn't work. Check and see if
Access has an MD5 function, or perhaps an ENCRYPT function that uses
the MD5 algorithm. If so, you can do
<cfquery>
UPDATE members SET password = MD5(password)
</cfquery>
and be done. If not, then you'll have to pull the entire member list,
and the loop over it reseting each password individually with the CF
function.
<cfquery name="get">
SELECT memberNo
FROM members
ORDER BY memberNo
</cfquery>
<cfloop query="get">
<cfquery>
UPDATE members SET
password = #hash(memberNo)#
WHERE memberNo = #memberNo#
</cfquery>
</cfloop>
Make sure you use CFQUERYPARAM in there; I omitted them for brevity.
cheers,
barneyb
On 8/31/05, Bob Haroche <[EMAIL PROTECTED]> wrote:
> We have an Access DB where we need to re-set all passwords to match the
> user's member number (this is just a temporary change). We want to hash
> the new passwords.
>
> This query works without the hashing:
>
> <cfquery name="changePassword" datasource="#Application.Datasource#">
> UPDATE Members
> SET Password=Members.MemberNo;
> </cfquery>
>
> But this query doesn't work with the hashing:
>
> <cfquery name="changePassword" datasource="#Application.Datasource#">
> UPDATE Members
> SET Password=#Hash(Members.MemberNo)#;
> </cfquery>
>
> I get the error "Members.MemberNo" is an undefined element. Adding
> quotes around or within the function doesn't help. The MemberNo is a
> text field in the db.
>
> Suggestions? Thanks.
>
>
> --
> Regards,
> Bob Haroche
>
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/
Got Gmail? I have 100 invites.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217032
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
