[Gambas-user] this query don't works, why?

[Felice Cafarelli]

Alle 17:29, giovedì 20 ottobre 2005, Nigel Gerrard ha scritto:
YESSS, the error was there: password encryption.
Thanks a lot

> Hello Felice,
>
> I believe your problem is with the select statement; is your password
> encrypted?
> If you did select user, password, host from user where user = 'username'
> and host = 'hostname', I suspect that it would work.
> Give it a try and let me know.
>
> Try putting together a statement that sends the following to mysql:
> 'select user, password, host from user where user = 'username' and password
> = password('user password')'
>
> Nigel
>
> > Message Received: Oct 20 2005, 03:19 PM
> > From: "Felice Cafarelli" <felixcafarelli at ...1176...>
> > To: gambas-user at lists.sourceforge.net
> > Cc:
> > Subject: Re: [Gambas-user] this query don't works, why?
> >
> > Alle 14:41, giovedì 20 ottobre 2005, nigel at ...38... ha
> >
> > scritto:
> > > Try switching Debug on before executing the sql.
> > > It will show what statement is being executed;
> > >
> > > eg. DB.Debug = True
> > >
> > > Nigel
> >
> > Hi, Nigel... it was the first thing i did... the sql statement is correct
>
> (or
>
> > so i thought before now), any ideas? I'm working on the system tables of
>
> a
>
> > mysql server, precisely on the 'user' table... with gambas1.0.9 on a
> > mandriva2005 and administrative rights on the mysql server, could help?
> > Hi all
> > Felix
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by:
> > Power Architecture Resource Center: Free content, downloads, discussions,
> > and more. http://solutions.newsforge.com/ibmarch.tmpl
> > _______________________________________________
> > Gambas-user mailing list
> > Gambas-user at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/gambas-user
>
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Power Architecture Resource Center: Free content, downloads, discussions,
> and more. http://solutions.newsforge.com/ibmarch.tmpl
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user