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

[nigel at ...38...]

Try switching Debug on before executing the sql.
It will show what statement is being executed;

eg. DB.Debug = True 

Nigel

> Message Received: Oct 20 2005, 12:34 AM
> From: "Felice Cafarelli" <felixcafarelli at ...1176...>
> To: gambas-user at lists.sourceforge.net
> Cc: 
> Subject: [Gambas-user] this query don't works, why?
> 
> 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
> 
> 
> -------------------------------------------------------
> 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
> 
>