I am very happy to see that ASP is still on the go.
I hope this is the correct place to ask this question.
Have a stored procedure in MYSQL:
Then My Code in ASP:
CREATE PROCEDURE `insert_custdetails`(IN p_Email VARCHAR(100), IN p_Fname VARCHAR(50), IN p_Lname VARCHAR(50), IN p_IP VARCHAR(40), IN p_OS VARCHAR(10), IN p_Browser VARCHAR(20), OUT ID INTEGER(11))
SQL SECURITY DEFINER
Set ID = LAST_INSERT_ID();
SQL="CALL insert_custdetails (1," & _
"'2'," & _
"'3'," & _
"'4'," & _
"'5'," & _
If Database(SQL) Then
Does not make sense. Since the 7th is declared as an OUT.
[MySQL][ODBC 5.1 Driver][mysqld-5.1.34-community]Incorrect number of arguments for PROCEDURE mytable.insert_custdetails; expected 7, got 6
Any brainiacs around that can help?
PS! Yes I have only now started to use sp's. This is my very first one.