Mysql5 + Select command, function and datareader

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello

I have created a function in my MYSQL Server 5.
I would like to call it via asp.net.
The function is running on mySQL Server. But if call it in my sql query it
doesn't work.

For example in vb.net

Dim mySQL As String = "SELECT column1,myfunction(2) as myfunction FROM
mytable'
...
Dim objCmd as New mySqlCommand (mySQL,myConnection)
Dim objDR As mySqlDataReader = objCmd.ExecuteReader()
objDR.Read()

DIM mytest as string = objDR("myfunction ").ToString()
response.write(mytest )


I get an error.
#42S22Unknown column 'myfunction' in 'field list'
MySql.Data.MySqlClient.MySqlException: #42S22Unknown column 'fcBretit' in
'field list'
....


if you know the right way to call mysql function in .net ...
thanks a lot...


.

Relevant Pages