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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
