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

Felice Cafarelli felixcafarelli at ...1176...
Thu Oct 20 15:53:15 CEST 2005


Alle 08:25, giovedì 20 ottobre 2005, Arief Bayu Purwanto ha scritto:
> 2005/10/20, Felice Cafarelli <felixcafarelli at ...1176...>:
> > This query on a mysql database don't works
> >
> > sSQLUsers = "SELECT user,password FROM user WHERE user = '" &
> > FMain.$sUser &
> > "' and password = '" & txtOldPassword.Text & "' and host = '" &
> > FMain.$sHost
> > & "'"
> >
> > but works the query
> >
> > sSQLUsers = "SELECT user,password FROM user WHERE user = "'" &
> > FMain.$sUser &
> > "'"
> >
> > I need to specify more parameters but it seems that doesn't work with
> > more than 1 parameter...
> > Anyone should help???
> >
> > Cheers
> > Felix
>
> What result do you get? no result or error?
>

Yes, the error is "no result", but if I comment the last part of the query, it 
gives me a result... a little peculiar, isn't it?




More information about the User mailing list