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

[Nigel Gerrard]

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
>
>