Subject | Re: in MySql i use PASSWORD. what can i use in FireBird ? |
---|---|
Author | Fernando Lopez Jr. |
Post date | 2005-03-24T17:23:15Z |
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:
thank you...
wrote:
> > in Mysql i can write something like this:Do you have any links to the download!??
> > UPDATE mysql.user SET Password=PASSWORD('newpass')
> >
> > in Firebird i get this:
> > ErrMsg :
> > Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char
> > 54 PASSWORD ErrCode : -104
> >
> > when i write this:
> > SELECT * FROM utilizatori WHERE id = "x" AND pass = PASSWORD("x")
> >
> > if someone knows how to solve this please answer
> > Thank You
>
> This isn't MySQL. PASSWORD is not a standard SQL function.
> There is an UDF to encrypt passwords f_ibpassword() if you install the
> freeudf library.
>
> Alan
thank you...