Jorge
Can you post a another very simple example to the list showing the error?
> -----Original Message-----
> From: Jorge Bastos [mailto:mysql.jorge@stripped]
> Sent: Tuesday, February 22, 2005 10:13 AM
> To: dotnet@stripped
> Subject: Re: Wierd problem
>
> It makes the same but only in the example where i get a
> [NULL] value from the server
>
> Jorge Bastos
>
>
>
> ----- Original Message -----
> From: "Jorge Bastos" <mysql.jorge@stripped>
> To: <dotnet@stripped>
> Sent: Tuesday, February 22, 2005 4:09 PM
> Subject: Re: Wierd problem
>
>
> > It makes the same if i close the reader first
> >
> > Jorge Bastos
> >
> >
> > ----- Original Message -----
> > From: "Reggie Burnett" <reggie@stripped>
> > To: "'Jorge Bastos'" <mysql.jorge@stripped>;
> <dotnet@stripped>
> > Sent: Tuesday, February 22, 2005 4:04 PM
> > Subject: RE: Wierd problem
> >
> >
> >> Jorge
> >>
> >> For one thing you are not closing your datareader.
> >>
> >> -reggie
> >>> -----Original Message-----
> >>> From: Jorge Bastos [mailto:mysql.jorge@stripped] Sent: Tuesday,
> >>> February 22, 2005 6:38 AM
> >>> To: dotnet@stripped; Reggie Burnett
> >>> Subject: Wierd problem
> >>>
> >>> DecimalReggie,
> >>> I got a serius issue here, i'm gonna try to reproduce
> some code to you
> >>> take do the same and try, this is with driver 1.0.4
> >>>
> >>>
> >>> ########## example 1 ##########
> >>> dim mycon as new mysqlconnection("connection string") dim
> sql as string
> >>> = "select max(id) from tbl_name"
> >>> dim mycmd as new mysqlcommand(sql , mycon) dim myrd as
> mysqldatareader
> >>> myrd=mycmd.executereader
> >>>
> >>> if myrd.read
> >>> msgbox "got some results"
> >>> else
> >>> msgbox "has a null result"
> >>> end if
> >>>
> >>> mycon.close()
> >>> mycmd.dispose()
> >>> ########## example 1 ##########
> >>>
> >>> In the abobe example everything works fine because the
> max function will
> >>> return the last value of the column "id"
> >>>
> >>>
> >>> ########## example 2 ##########
> >>> dim mycon as new mysqlconnection("connection string")
> >>> dim sql as string = "select max(id) from tbl_name where
> >>> id='laskdjflksdj'" <------ this where statment is
> impossible, mysql'll
> >>> return a null value, ---> [NULL]
> >>> dim mycmd as new mysqlcommand(sql , mycon) dim myrd as
> mysqldatareader
> >>> myrd=mycmd.executereader
> >>>
> >>> if myrd.read
> >>> msgbox "got some results"
> >>> else
> >>> msgbox "has a null result"
> >>> end if
> >>>
> >>> mycon.close() <----------- like i'll have the value
> [NULL] returned, i
> >>> get an error here, at the end of the email i show the output
> >>> mycmd.dispose()
> >>> ########## example 2 ##########
> >>>
> >>> This was not happening with the previous drivers
> versions, i already had
> >>> to change a bit of code to handle the situation.
> >>> I'm almost sure that is something with the datareader
> that doesn't like
> >>> the value [NULL] that mysql returns, can you confirm the
> driver bug and
> >>> how can i resolve this?
> >>> For now i've resolved inserting an try /catch
> >>>
> >>> Jorge Bastos
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> Output:
> >>> MySql.Data.MySqlClient.MySqlException: There is already an open
> >>> DataReader associated with this Connection which must be
> closed first.
> >>> at MySql.Data.MySqlClient.MySqlCommand.CheckState()
> >>> at
> MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehav
> >>> ior behavior)
> >>> at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
> >>> at MySql.Data.MySqlClient.Driver.ShowWarnings(Int32 count)
> >>> at MySql.Data.MySqlClient.NativeDriver.ReadEOF(Boolean
> readPacket)
> >>> at
> MySql.Data.MySqlClient.NativeDriver.OpenDataRow(Int32 fieldCount,
> >>> Boolean isBinary)
> >>> at MySql.Data.MySqlClient.CommandResult.Consume()
> >>> at MySql.Data.MySqlClient.MySqlDataReader.Close()
> >>> at MySql.Data.MySqlClient.MySqlConnection.Close()
> >>>
> >>
> >
> > --
> > MySQL on .NET Mailing List
> > For list archives: http://lists.mysql.com/dotnet
> > To unsubscribe:
> > http://lists.mysql.com/dotnet?unsub=1
> >
> >
>
>
> --
> MySQL on .NET Mailing List
> For list archives: http://lists.mysql.com/dotnet
> To unsubscribe:
> http://lists.mysql.com/dotnet?unsub=1
>
