Updating database

[hhamdan]

Hello every body,

i have a table has username and encrypted password, and i want to write it in different table and i want to decrypt the password filed
and i am using this code
I am selection the data from the login table

<cfquery name="dec" datasource="ds">
select *
 from
 login_dec
 </cfquery>

 <cfoutput query="dec">
	[B]<cfset dec_password = #Replace(query password filed)#>
	<cfset dec_password = #Decrypt(Decrypt password)#>[/B]
  <cfquery datasource="ds">
   insert into newlogin_dec
   (email,password)
   values
   (
    '#email#',
    '#dec_password#',
      )
</cfquery>
</cfoutput>

what happen is after the execution half of the data transfer successfully but during the process i face this problem
Error Occurred While Processing Request
50
any help, please ...

[arrgh]

what happen is after the execution half of the data transfer successfully but during the process i face this problem
Error Occurred While Processing Request
50

That is just the error header. What is the rest of the error message?

[hhamdan]

That is just the error header. What is the rest of the error message?

nothing else it just this message and when i checked the db i found around 2500 records transfer from the 7000.
Thank you

[hhamdan]

it show only in the error area

50

[arrgh]

It is rare that there is not a better error message. The only thing that comes close, in my experience is a plain "500" error. But again, that is unusual.

- Did you enable debugging in the ColdFusion Administrator?
- What does is the error in the stack trace?
- Check the log files, what is the error message there?

[hhamdan]

Thank you so much,
the thing was with encryption and the description system, there was a password after you encrypted will not decrypt again, so i just reset it and every thing fine
thanks again

[arrgh]

Good. I am glad you were able to solve the problem.