From: Fredrick Bartlett
Date: September 25 2004 10:32pm
Subject: Re: Return parameter from query.
List-Archive: http://lists.mysql.com/dotnet/7
Message-Id: <003c01c4a34f$970d1f60$0300a8c0@REGITLAP>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

This might apply here.  Here is a quote from a previous post...

The syntax for setting parameters has changed.  Now you use ? instead of
@ to mark parameters.  This change was necessary for proper
compatibility with MySQL.  However, realizing that people may have lots
of code to change, I have included a connection string option that will
enable the old syntax.  Add "old syntax=yes" to  your connection string
and it will work.  However, you should read the help on MySqlCommand.
There is a note included that talks about the tradeoffs of doing this.

----- Original Message ----- 
From: "Asbjørn Konstad" <asbjorn@stripped>
To: <dotnet@stripped>
Sent: Friday, September 24, 2004 1:05 AM
Subject: Return parameter from query.


Hi.



Anyone as frustrated as me???



Problem:

I have a created a command to return maximum id from myTable.., like this:



//--------------------------------------------------------------------------
----------------------------------------------------------------------------
-----



MySqlCommand cmd = new MySqlCommand("SELECT @PAR := MAX(ID) FROM myTable",
myConnection);

MySqlParameter param = new MySqlParameter();

param = cmd.Parameters.Add("@PAR", MySqlDbType.Int32, 4);

param.Direction = ParameterDirection.Output;



myConnection.Open();

  cmd.ExecuteNonQuery();

  int max_id = (int)cmd.Parameters["@PAR"].Value;

myConnection.Close();



//--------------------------------------------------------------------------
----------------------------------------------------------------------------
----



This gives me an error -> "error in SQL-Syntax".

I read the issue with use of "?" instead of "@", and I've tried it all..!,
it keeps throwing exeptions like "null values"

"Object reference not set to an instance of an object". and so on.



Anyone have a fail-proof method of creating a command with
return-parameters??



Thanks.



Reg.



Asbjørn Konstad


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.768 / Virus Database: 515 - Release Date: 22.09.2004