[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

SELECT in a stored procedure must have INTO

Robin Prosch via .NET 247

3/21/2005 4:27:00 AM

(Type your message here)

--------------------------------
From: shubha rao
I have create MYSQL Procedure, it created successfully

CREATE PROCEDURE `infosearch`.`sp_info_QLink1`()
begin
Select distinct PFC.* from pre_form_col1 PFC, Quest_Link WHERE
PFC.rowid = Qlink1 ORDER BY 1;
end

Now, I am trying to invoke from asp.net

try
{
OdbcConnection Conn=new OdbcConnection("DRIVER={MySQL ODBC 3.51
Driver};SERVER=localhost;DATABASE=Infosearch;UID=root;PASSWORD=real;OPTION=3");
Conn.Open();
OdbcCommand cmd=new OdbcCommand("sp_info_QLink1",Conn);
cmd.CommandType=CommandType.StoredProcedure;
OdbcDataReader dr=cmd.ExecuteReader();
}catch(Exception ee){ee=ee;}

It is raising the exception 'SELECT in a stored procedure must have INTO'

-----------------------
Posted by a user from .NET 247 (http://www.dotn...)

<Id>HQk5Sel6gUGvhrHeOqhd8w==</Id>