File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Problem in SQL (MySQL) select password column Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem in SQL (MySQL) select password column " Watch "Problem in SQL (MySQL) select password column " New topic
Author

Problem in SQL (MySQL) select password column

Ken Shamrock
Ranch Hand

Joined: Jan 23, 2002
Posts: 139
I created a password column using
Insert into table (password) values (PASSWORD(abc))
and ok,
but I can't select it back using
Select * from table where password="PASSWORD(abc)"
Or Select * from table where password=(Select PASSWORD(abc));
Empty set returned,why?
**I can only do it this way
1) Select PASSWORD(abc); get the encoded password
2) then Select * from table where password="Encoded String";
but I don't want to do in this indirect way


Thanks everyone who helped me
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

I've had the same problem. Can I guess that you're not running *nux and are in Windows instead?
If you search the MySQL docs, the password function is supported by the crypt() system call. This doesn't exist in Windows. I had a search and I think there are implementations you can plug in, but I never bothered...
Is this the problem you are having?
Dave.
Ken Shamrock
Ranch Hand

Joined: Jan 23, 2002
Posts: 139
Thanks for reply. Yes I m using WinXP.
I've figured out the reason why now. The password column should be exceeds 16 char, otherwise its not enough to stored the encoded string. Now it's ok
 
Don't get me started about those stupid light bulbs.
 
subject: Problem in SQL (MySQL) select password column