ASP vs MySQL Stored Procedures - Incorrect number of arguments for PROCEDURE

[bazzapr]

Howdy All,

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:

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))
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
INSERT INTO
  `customerdetails`(
  Email,
  Fname,
  Lname,
  IP,
  OS,
  Browser)
VALUES(
  p_Email,
  p_Fname,
  p_Lname,
  p_IP,
  p_OS,
  p_Browser);


Set ID = LAST_INSERT_ID();

END;

Then My Code in ASP:

	SQL="CALL insert_custdetails (1," & _
		"'2'," & _
		"'3'," & _
		"'4'," & _
		"'5'," & _
		"'6');"
	If Database(SQL) Then
		Response.Write Rs("ID")
	End If

Error is:

-2147467259:
[MySQL][ODBC 5.1 Driver][mysqld-5.1.34-community]Incorrect number of arguments for PROCEDURE mytable.insert_custdetails; expected 7, got 6

Does not make sense. Since the 7th is declared as an OUT.

Any brainiacs around that can help?

Thanks.

PS! Yes I have only now started to use sp's. This is my very first one.

[r937]

in your calling program, you still have to have a variable to receive the output value

you have to code this variable as the 7th parameter in the CALL

[Doug G]

Just a guess, you might need text quotes ' around your first test argument

[bazzapr]

in your calling program, you still have to have a variable to receive the output value

you have to code this variable as the 7th parameter in the CALL

Nope now its worse I think or I am doing it wrong.

My Code:

	SQL="CALL insert_custdetails ('1'," & _
		"'2'," & _
		"'3'," & _
		"'4'," & _
		"'5'," & _
		"'6',0);"
	If Database(SQL) Then
		Response.Write Rs("ID")
	End If

-2147467259:
[MySQL][ODBC 5.1 Driver][mysqld-5.1.34-community]OUT or INOUT argument 7 for routine mytable.insert_custdetails is not a variable or NEW pseudo-variable in BEFORE trigger

[r937]

you cannot feed the results of the procedure (which is a number which is determined by LAST_INSERT_ID) into the constant 0 -- constants cannot take values

you have to have a variable to receive the value

heck, i don't even do asp, i do coldfusion, but it's the same concept, right?

[bazzapr]

you cannot feed the results of the procedure (which is a number which is determined by LAST_INSERT_ID) into the constant 0 -- constants cannot take values

you have to have a variable to receive the value

heck, i don't even do asp, i do coldfusion, but it's the same concept, right?

You been here tooooooo long mate!!!! If you cannot have something nice to say then do not say anything.

For those who want to know. Asked the same question on stackoverflow and got a answer in 20minutes. THE RIGHT ANSWER...NO COCKY REMARKS.

Here it is as I got it now:

	SQL="CALL insert_custdetails ('1'," & _
		"'2'," & _
		"'3'," & _
		"'4'," & _
		"'5'," & _
		"'6',@ID);"
	If Database(SQL) Then
	
		SQL="SELECT @ID"
		If Database(SQL) Then
			Response.Write Rs("@ID")
		End If
	End If

And here is a link that explains it all:

SqlCommand.Parameters Property (System.Data.SqlClient)

[DaveMaxwell]

And what Rudy told you was correct - in your example, you had a 0 (which is a constant) for the last parameter - in the stackoverflow answer, it has @ID (which is a variable).