Error 'Only input parameters are supported by MySql'
Running MySql 5.0.18 on Windows Server 2003, IIS 6 and .Net Framework V2, using .Net Connector 1.0.7 for .Net V2, C# for application
Stored Procedure:
+++++++++++++++++++++++++++++++++++++
CREATE PROCEDURE `sp_CreateCustomer2`(
IN fname1 VARCHAR(50),
IN lname1 VARCHAR(50),
IN fname2 VARCHAR(50),
IN lname2 VARCHAR(50),
IN address VARCHAR(75),
IN telephone VARCHAR(10),
IN zipcode VARCHAR(10),
IN route INT,
IN route_type VARCHAR(20),
IN status VARCHAR(25),
IN start_date DATE,
IN promo VARCHAR(45),
IN stop_date DATE,
IN resume_date DATE,
IN route_cost DECIMAL,
IN payment DECIMAL,
IN pay_date DATE,
IN balance DECIMAL,
IN pay_type VARCHAR(20),
IN instructions VARCHAR(100),
OUT returnvalue INT
)
BEGIN
INSERT INTO customers (Fname1, Lname1, Fname2, Lname2, Address, Telephone, ZipCode, Route, RouteType, Status,
StartDate, Promotion, StopDate, ResumeDate, RouteCost, Payment, PayDate, Balance, PayType, Instructions)
VALUES (fname1, lname1, fname2, lname2, address, telephone, zipcode, route, route_type, status, start_date,
promo, stop_date, resume_date, route_cost, payment, pay_date, balance, pay_type, instructions);
SELECT LAST_INSERT_ID() INTO returnvalue;
END
++++++++++++++++++++++++++++++++++++++++++++++
TIA,
Michael