gambas-user

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

[webs37 <we...@gm...>]

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-tp23193181p23193181.html
Sent from the gambas-user mailing list archive at Nabble.com.

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

[Jack <js...@wa...>]

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

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

[Ron <ro...@cy...>]

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.

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

[wahyu b. <we...@gm...>]

On Wed, Apr 29, 2009 at 6:48 PM, Ron <ro...@cy...> 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 -

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

[Emil T. <em...@tc...>]

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:we...@gm...]
Gesendet: Mittwoch, 29. April 2009 13:25
An: gam...@li...
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
Gam...@li...
https://lists.sourceforge.net/lists/listinfo/gambas-user