Updating database

Thread Solved

•
•
Join Date: Nov 2008
Posts: 20
Reputation: hhamdan is an unknown quantity at this point 
Solved Threads: 0
hhamdan hhamdan is offline Offline
Newbie Poster

Updating database

 
0
  #1
Dec 12th, 2008
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 ...
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2008
Posts: 45
Reputation: arrgh is an unknown quantity at this point 
Solved Threads: 6
arrgh arrgh is offline Offline
Light Poster

Re: Updating database

 
0
  #2
Dec 12th, 2008
•
•
•
•
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?
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2008
Posts: 20
Reputation: hhamdan is an unknown quantity at this point 
Solved Threads: 0
hhamdan hhamdan is offline Offline
Newbie Poster

Re: Updating database

 
0
  #3
Dec 12th, 2008
•
•
•
•
Originally Posted by arrgh View Post
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
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2008
Posts: 20
Reputation: hhamdan is an unknown quantity at this point 
Solved Threads: 0
hhamdan hhamdan is offline Offline
Newbie Poster

Re: Updating database

 
0
  #4
Dec 12th, 2008
it show only in the error area

50
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2008
Posts: 45
Reputation: arrgh is an unknown quantity at this point 
Solved Threads: 6
arrgh arrgh is offline Offline
Light Poster

Re: Updating database

 
0
  #5
Dec 13th, 2008
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?
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2008
Posts: 20
Reputation: hhamdan is an unknown quantity at this point 
Solved Threads: 0
hhamdan hhamdan is offline Offline
Newbie Poster

Re: Updating database

 
0
  #6
Dec 15th, 2008
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
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2008
Posts: 45
Reputation: arrgh is an unknown quantity at this point 
Solved Threads: 6
arrgh arrgh is offline Offline
Light Poster

Re: Updating database

 
0
  #7
Dec 15th, 2008
Good. I am glad you were able to solve the problem.
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread has been marked solved.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the ColdFusion Forum
Thread Tools Search this Thread



Tag cloud for ColdFusion
adobe adobelivecyclees alfresco amazon cfquery checkbox coldfusion contentmanagement dreamweaver ebooks insert kindle multiple opensource openstandards pdf select sony sonyreader
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC