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

[Arief Bayu Purwanto]

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?

--
-- Yahoo!ID : ar1ef_310
-- http://www.silentstudio.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20051020/b836797b/attachment.html>