Re: Stored Procedure Conversion

2005-11-04 Thread Peter Brawley
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

Stored Procedure Conversion

2005-11-04 Thread Jesse Castleberry
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