Parameters MySql and VB.Net

[Daniel]

Wondering if someone could help me with adding parameters to a mysql query with vb.net

Here's my code:

mycmd = New MySqlCommand
'mycmd.Parameters.Add("?result", MySqlType.Text)
mycmd.Parameters(0).Value = "This is a test"
mycmd.Parameters(0).Direction = ParameterDirection.Input
mycmd.CommandText = "Insert into result_holder(result_id, result) Values('45',?result)"
mycmd.Connection = mycon
'Try
mycon.Open()
mycmd.ExecuteNonQuery()
mycon.Close()
Catch ex As Exception
MsgBox(ex.Message)
End Try

I the exception I get is "You have an error in your sql statement near 'result'

What am I doing wrong??

Thanks!

Daniel

--
--------------------------------- --- -- -
Posted with NewsLeecher v3.9 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

[SuNcO]

What do you want to do with "?result" ?

Maybe you want to send a variable ? Then is like this :

mycmd.CommandText = "Insert into result_holder (result_id, result) Values
('45'," & result & ")"

--
Windows Live Butterfly
My little blog - http://sunco.codigoplus.com (in Spanish)

"Daniel" <da*@theman.comescribió en el mensaje de
noticias:48***********************@news.newshostin g.com...

Wondering if someone could help me with adding parameters to a mysql query
with vb.net

Here's my code:

mycmd = New MySqlCommand
'mycmd.Parameters.Add("?result", MySqlType.Text)
mycmd.Parameters(0).Value = "This is a test"
mycmd.Parameters(0).Direction = ParameterDirection.Input
mycmd.CommandText = "Insert into result_holder(result_id, result)
Values('45',?result)"
mycmd.Connection = mycon
'Try
mycon.Open()
mycmd.ExecuteNonQuery()
mycon.Close()
Catch ex As Exception
MsgBox(ex.Message)
End Try

I the exception I get is "You have an error in your sql statement near
'result'

What am I doing wrong??

Thanks!

Daniel

--
--------------------------------- --- -- -
Posted with NewsLeecher v3.9 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

[Jack Jackson]

On 10 Aug 2008 01:21:20 GMT, Daniel <da*@theman.comwrote:

>Wondering if someone could help me with adding parameters to a mysql query with vb.net

Here's my code:

mycmd = New MySqlCommand
'mycmd.Parameters.Add("?result", MySqlType.Text)
mycmd.Parameters(0).Value = "This is a test"
mycmd.Parameters(0).Direction = ParameterDirection.Input
mycmd.CommandText = "Insert into result_holder(result_id, result) Values('45',?result)"
mycmd.Connection = mycon
'Try
mycon.Open()
mycmd.ExecuteNonQuery()
mycon.Close()
Catch ex As Exception
MsgBox(ex.Message)
End Try

I the exception I get is "You have an error in your sql statement near 'result'

What am I doing wrong??

Thanks!

Daniel

I have never used MySql, but this link
<http://dev.mysql.com/doc/refman/5.0/en/connector-net-using-prepared.html>
uses @ instead of ? to mark parameters.

[Daniel]

That did it!! Thanks!!
--
--------------------------------- --- -- -
Posted with NewsLeecher v3.9 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -