On Wed, Apr 29, 2009 at 6:48 PM, Ron <r...@cyberjunky.nl> 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 - ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user