[Gambas-user] Duplicated invalid record inserting into MySQL

[João Luís Marques Pinto]

christian.gambas wrote:
> Le mercredi 20 août 2008, Benoit Minisini a écrit :
>   
>> But do that:
>>
>>   res = mDatabase.conn.Exec("INSERT INTO customer VALUES(name) (&1)",
>> TextBox1.Text)
>>     
>
> You're right, Benoît, one could never be careful enough !
>
> But, just to avoid confusion to João Luís, you surely mean :
>     res = mDatabase.conn.Exec("INSERT INTO customer (name) VALUES(&1)", 
> TextBox1.Text)
>
> Regards.
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>   
Hello,
It was my error after all :)

I was going to research how to the escape the strings now, thanks for 
the help in advance.

Best regards,

-- 
João Luís Marques Pinto
GetDeb Project Manager
http://www.getdeb.net
http://blog.getdeb.net