[Gambas-user] How to input quotation mark in TextBox.Text to mysql

[webs37 <we...@gm...>]

Hi all,

Please help.., I have error message:"Query failed: You have an error in SQL
syntax, check the manual that corresponds to MySQL server version for the
right syntaxto use near 'an',address='Saudi Arabia" 

I want to input text that have a quotation mark like "al Qur'an" 

here these the syntax: 

syntax "edit = "UPDATE tbl_user set title='" & TextBox32.Text &
"',publisher='" & TextBox35.Text & "',year='" & TextBox33.Text &
"',volume='" & TextBox39.Text & "',colation='" & ComboBox14.Text &
"',isbn='" & TextBox53.Text & "',city='" & an1!id_city & "',publisher='" &
ana3!id_log & "',subject='" & an2!id_log & "',distribution='" & ana4!id_log
& "',hp='" & TextBox36.Text & "',status='" & Label159.Caption & "' WHERE
id='" & Label92.Caption & "'"
rsedit = connection.Exec(edit)"

any suggestion
thx
-- 
View this message in context: http://www.nabble.com/How-to-input-quotation-mark-in-TextBox.Text-to-mysql-tp23193181p23193181.html
Sent from the gambas-user mailing list archive at Nabble.com.