Le mercredi 29 avril 2009 13:24:47 webs37, vous avez écrit : > 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)"
use this syntax. Connexion.Exec("UPdate tbl_user SET title = &1, publisher = &2, year = &3, status = &4 where id = &5", TextBox32.Text , TextBox35.Text, TextBox33.Text, Label159.Caption, Label92.Caption) Jack ------------------------------------------------------------------------------ Register Now & Save for Velocity, the Web Performance & Operations Conference from O'Reilly Media. Velocity features a full day of expert-led, hands-on workshops and two days of sessions from industry leaders in dedicated Performance & Operations tracks. Use code vel09scf and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user