Array Loop

[CFRAM]

Please help me to debug:

<cfquery name="qSelectPwd" datasource="#Application.AppDSN#">
select password from tablename
</cfquery>


<!--- Create List of passowrds and array --->

<cfset pwdlist = ValueList(qSelectPwd.password,",")>
<cfset pwdarray = ArrayNew(1)>
<cfset pwdarray = ListToArray(pwdlist,",")>

<cfloop index="i" from="1" to="#ArrayLen(pwdarray)#">
<cfoutput>#pwdarray#<br></cfoutput>
</cfloop>

<!--- The loop shows me different passwords. --->

<!--- Loop for the array of passwords and convert the passwords to new
passwords in the table --->
<cfloop index="i" from="1" to="#ArrayLen(pwdarray)#">
<cfquery name="qUpdate" datasource="#Application.AppDSN#">
Update TableName
Set password = '#Encrypt(pwdarray,Request.PasswordKey)#'
</cfquery>
</cfloop>

The loop updates the table with the First Password for all the records.

Thanks

[BSterner]

You're missing the 'where' clause in your update query. You need to qualify it
with something like...

Update TableName
Set password = '#Encrypt(pwdarray,Request.PasswordKey)#'
WHERE id =#id#;

You may be able to do this in a single SQL statement. I'm not a SQL expert,
but possibly someone else could suggest a way.

btw, isn't it throwing an error? You have...

Update TableName
Set password = '#Encrypt(pwdarray,Request.PasswordKey)#'

At the very least it should be...

Update TableName
Set password = '#Encrypt(pwdarray,Request.PasswordKey)#'

[CFRAM]

I have resolved this. Instead of using the Array Loop I used the <CFLOOP Query="FirstQuery"> and It worked.
Thanks for the input.