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

[Ron]

webs37 schreef:
> 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

Hi,

it's better to use a syntax like this, no need to put in all the quotes 
yourself:

Exec("UPDATE tbl_user SET title = &1 WHERE id = &2", TextBox32.Text, 
Label92.Caption)

Regards,
Ron_2nd.