List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:November 4 2005 10:21pm
Subject:Re: Stored Procedure Conversion
View as plain text  
Jesse,

 >VALUES (cFirstName, cLastName, cUserName, cPassword) // error on this 
line.
 >return LAST_INSERT_ID() /*@@Identity*/
 >END
 >When I execute this, It bombs on the indicated line stating that there 
is a
 >syntax error.

A stored procedure cannot return a value.

PB

-----

Jesse Castleberry wrote:

>I am converting a MS SQL Server ASP application over to use MySQL. I have
>two simple stored procedures that I need to convert. I have very little
>experience with MS SQL stored procedures, and none-what-so-ever with stored
>procedures in MySQL, so I really don't know what this should look like. I'll
>post the first one, and if I'm able to figure it out, I'll attempt my second
>one by myself. Here's the stored procedure converted as much as I can get
>it.
>
>CREATE Procedure sp_InsertNewCamper
>(
>in cFirstName NVarChar(30),
>in cLastName NVarChar(30),
>in cUserName NVarChar(30),
>in cPassword NVarChar(30)
>)
>BEGIN
>INSERT INTO Campers (FirstName, LastName, UserName, Password)
>VALUES (cFirstName, cLastName, cUserName, cPassword) // error on this line.
>
>return LAST_INSERT_ID() /*@@Identity*/
>END
>
>
>When I execute this, It bombs on the indicated line stating that there is a
>syntax error.
>
>Thanks,
>Jesse
>
>
>  
>


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.12.8/161 - Release Date: 11/3/2005

Thread
Stored Procedure ConversionJesse Castleberry4 Nov
  • Re: Stored Procedure ConversionPeter Brawley4 Nov