943,769 Members | Top Members by Rank

Ad:
  • ColdFusion Discussion Thread
  • Marked Solved
  • Views: 1618
  • ColdFusion RSS
Dec 12th, 2008
0

Updating database

Expand Post »
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">
	<cfset dec_password = #Replace(query password filed)#>
	<cfset dec_password = #Decrypt(Decrypt password)#>
  <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 ...
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
hhamdan is offline Offline
21 posts
since Nov 2008
Dec 12th, 2008
0

Re: Updating database

Quote ...
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?
Reputation Points: 32
Solved Threads: 44
Posting Whiz
arrgh is offline Offline
349 posts
since Dec 2008
Dec 12th, 2008
0

Re: Updating database

Click to Expand / Collapse  Quote originally posted by arrgh ...
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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
hhamdan is offline Offline
21 posts
since Nov 2008
Dec 12th, 2008
0

Re: Updating database

it show only in the error area

50
Reputation Points: 10
Solved Threads: 0
Newbie Poster
hhamdan is offline Offline
21 posts
since Nov 2008
Dec 13th, 2008
0

Re: Updating database

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?
Reputation Points: 32
Solved Threads: 44
Posting Whiz
arrgh is offline Offline
349 posts
since Dec 2008
Dec 15th, 2008
0

Re: Updating database

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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
hhamdan is offline Offline
21 posts
since Nov 2008
Dec 15th, 2008
0

Re: Updating database

Good. I am glad you were able to solve the problem.
Reputation Points: 32
Solved Threads: 44
Posting Whiz
arrgh is offline Offline
349 posts
since Dec 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ColdFusion Forum Timeline: capchering ip address in coldfusion
Next Thread in ColdFusion Forum Timeline: CFSearch not returning the correct context help





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC