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

wahyu budhi webs37 at ...626...
Thu May 7 14:59:20 CEST 2009


On Wed, Apr 29, 2009 at 6:48 PM, Ron <ron at ...1740...> wrote:

> 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.


 Its works, thanks for u 2 - Jack and Ron_2nd -



More information about the User mailing list