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

Felice Cafarelli felixcafarelli at ...1176...
Thu Oct 20 01:33:20 CEST 2005


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




More information about the User mailing list