473,549 Members | 2,239 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

password update problem with md5

121 New Member
hello,


I am getting some problem while updating password field in my application.

let me explain briefly i have table called "A" in that i have two fields Recruiter_Name and Confm_Passwd. if i want to update Recruiter_Name and Confm_Passwd its not updating.

the query i am using for updation is
Expand|Select|Wrap|Line Numbers
  1. UPDATE recruiter_profile 
  2. SET Recruiter_Name='ravish' 
  3. AND Confm_Passwd=md5('ravish') 
  4. WHERE Emp_Code='18';
  5.  
If i remove Confm_Passwd=md 5('ravish') it will work.
Jun 24 '08 #1
1 2307
Atli
5,058 Recognized Expert Expert
Hi.

Are you getting any errors?
What type of field is the password field?

Also, please use [code] tags when posting your code / queries.
Jun 25 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
3292
by: Marc | last post by:
Hello, Newbie here..... Searching and working this for a week now. We too are having the same problems. Using MySql 4.0.14 and there are "no problems" at all.
11
3691
by: John Victor | last post by:
In my mysql database, I've stored all the passwords using the PASSWORD() function. Now I'm running a test and need to compare the password in my php document to that saved in the database. I used the string "Select name From users Where password = PASSWORD('$testPass')" and ran mysql_query() using the string. But nothing was returned. ...
0
5653
by: aars | last post by:
Hello all, I am creating a user administration system where system administrator can activate services for a user, like webspace, a mail account or a subdomain. I now want to create a function that creates mysql databases and grant the right privileges to a user. But the problem is that mysql wants to have the plaintext password for the...
7
4372
by: Nerrad | last post by:
Hi, i am currently working on a project which requires me to create a form to allow the user to change their password. I know there is a user-level security login which is easier and safer but was told that i could and even must not use it. GOD KNOWS WHY So i created a custom login form with userID and password which validates with a...
0
1244
by: Newbie | last post by:
hi all, i am doing a project which requires me to provide a security login feature. i understand that access has a user level security feature but i could not use it coz i'm tested on my ability to use existing controls. i did the login form, then it occured to me that it would be much more convenient for users to change passwords...
6
1829
by: Darren | last post by:
hi y'all! i pretty much wanted to do a custom form where users can change their password to the database as they like.. the problem i encountered is that it seems that when a valid user enter their new password, the new password is not reflected in the respective tables and after clicking the cmdChangePW, nothing happen despite me puttin...
8
3303
by: Katash | last post by:
Hello, I am new to PHP and am working on a login system for my site, currently supplied passwords are passed to MySQL and stored as md5 hashes, my question is :- seeing as md5 is 1 way only what would be the best way to implement a 'Forgotten Password' system whereby the user supplies an e-mail address and the password is mailed to the user?...
2
1704
by: yasinirshad | last post by:
Hi, Please see my below code to change password. Here i need to check for old password from database and need to update new password. But when i try to submit by giving wrong old password ,its redirecting me to PasswordSet.aspx whereas it shd give message Invalid Old Password. It shd redirect me only when user gives correct old password and enters...
7
19675
by: rekhasc | last post by:
plz help me to write the code to change the current password and to update the new password: i have written the code but its giving error,my code is Private Function pass() As Boolean Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim sql As String cn.Open = "provider=microsoft.jet.OLEDB.4.0;Data...
7
3467
by: hotflash | last post by:
Hi All, I want to creat a script where I will allow user to reset their own password. I have tried different options but don't have any luck. Wonder what I want to do is kinda not valid or not. ResetLogin.asp (where user will have to enter their username, old password, and new password). <TR> <TH ALIGN=LEFT> <FONT...
0
7550
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7475
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7746
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7509
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7836
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5116
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3521
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3502
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
789
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.