Re: [Gambas-user] How to input quotation mark in TextBox.Text to mysql
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
Re: [Gambas-user] How to input quotation mark in TextBox.Text to mysql
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. -- 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
Re: [Gambas-user] How to input quotation mark in TextBox.Text to mysql
Hi, I had this problem in the good old VBA too. my solution: use chr(39)!!! also strSQL= ...+Address=+chr(39)+TextBoxXXX.Text+chr(39)+... result will be as you wish it kind regards Emil P.S. I am not sure or the corect syntax of the CHR function in Gambas, you have to see for this (may be chr$() etc.) -Ursprungliche Nachricht- Von: webs37 [mailto:web...@gmail.com] Gesendet: Mittwoch, 29. April 2009 13:25 An: gambas-user@lists.sourceforge.net Betreff: [Gambas-user] How to input quotation mark in TextBox.Text to mysql 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-t p23193181p23193181.html Sent from the gambas-user mailing list archive at Nabble.com. -- 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 -- 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
[Gambas-user] TreeView: why is error = TRUE?
Just one question for understanding it better: Why is e. g. MoveNext or MoveChild TRUE in case there is NOTHING and not vice-versa? Seems pretty unlogical and looks somewhat strange in code... Regards Rolf -- 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
Re: [Gambas-user] Problems compiling under Ubuntu 9.04
I'm also looking forward using kubuntu 9.04 (AMD64), because it's much faster then my current kubuntu-version. Compiling QT3 from scratch should make no probs, but what's about compiling KDE3 and installing it in my home directory? And another question: When will Gambas support QT4 and KDE4? ...is there a roadmap? Greetz Stevie -- 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
Re: [Gambas-user] Problems compiling under Ubuntu 9.04
I'm also looking forward using kubuntu 9.04 (AMD64), because it's much faster then my current kubuntu-version. Compiling QT3 from scratch should make no probs, but what's about compiling KDE3 and installing it in my home directory? And another question: When will Gambas support QT4 and KDE4? ...is there a roadmap? Greetz Stevie You don't need the KDE3 components, unless you really want KHTML. As for QT3, Ubuntu should have binary packages of it. Otherwise drop this distribution and use another one. :-) Gambas will support QT4. But the component is not finished, there are many bugs it because of the changes between QT3 and QT4. I don't have the time at the moment to finish it, I am very busy with theatre, and my job (I have to put the map of Paris on the internet). As for KDE4, I don't know. KDE4 is full of bugs yet, and what is really useful is a web browser control. I think WebKit will be the solution, as it works both for QT and GTK+. Regards, -- Benoît -- 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