Thanks all, it helped me a lot
Manisha
----- Original Message -----
From: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; "Manisha Sathe"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 10:56 PM
Subject: Re: PASSWORD() function problem
> Hi,
> If I remember, ENCODE() is reversible using DECODE() or something similar.
>
> I might be wrong, just check the manual!!!
>
>
> Thanks
> Emery
>
> ----- Original Message -----
> From: "Nitin" <[EMAIL PROTECTED]>
> To: "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday, October 16, 2003 16:13
> Subject: Re: PASSWORD() function problem
>
>
> > all encryption functions are one way only
> >
> > Nitin
> >
> > ----- Original Message -----
> > From: "Manisha Sathe" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, October 16, 2003 6:46 PM
> > Subject: Re: PASSWORD() function problem
> >
> >
> > > thanks all, it works (i just increase it to 20)
> > > but one more thing, now if i want to get this password (e.g for option
> > > forget password), can we retrieve, i believe we can not- just want to
> > > confirm
> > >
> > > manisha
> > >
> > > ----- Original Message -----
> > > From: "Paul DuBois" <[EMAIL PROTECTED]>
> > > To: "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > > Sent: Wednesday, October 15, 2003 11:05 PM
> > > Subject: Re: PASSWORD() function problem
> > >
> > >
> > > > At 17:26 +0800 10/15/03, Manisha Sathe wrote:
> > > > >Hi,
> > > > >
> > > > >I inserted one record thr PHPMyAdmin - mem_pass field of member
> > > > >table set to xyz using function 'PASSWORD'
> > > > >
> > > > >Then trying to select the same - select * from member where
mem_pass
> > > > >= PASSWORD('xyz') - then it is not getting selected
> > > > >
> > > > >I do not know why I am not getting the result. please help me.
> > > > >what's going wrong ?
> > > > >
> > > > >Thanks in advance
> > > > >Manisha
> > > >
> > > > Please consider using something other than PASSWORD(), as noted in
the
> > > > description for that function at:
> > > >
> > > > http://www.mysql.com/doc/en/Miscellaneous_functions.html
> > > >
> > > > PASSWORD() should not be used for your own applications.
> > > >
> > > > --
> > > > Paul DuBois, Senior Technical Writer
> > > > Madison, Wisconsin, USA
> > > > MySQL AB, www.mysql.com
> > > >
> > > > Are you MySQL certified? http://www.mysql.com/certification/
> > > >
> > > >
> > > > --
> > > > MySQL General Mailing List
> > > > For list archives: http://lists.mysql.com/mysql
> > > > To unsubscribe:
> > > http://lists.mysql.com/[EMAIL PROTECTED]
> > > >
> > >
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:
> > http://lists.mysql.com/[EMAIL PROTECTED]
> > >
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
> >
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
