help this

[k0d0k]

Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function usp_CreateNewAccount has too many arguments specified., SQL state 37000 in SQLExecDirect in C:\xampp\htdocs\sites\regist.php on line 107

regist account on website

 

[raventh1984]

Just like it said. The stored Procedure has to many arguments then your ACCOUNT_TBL has on fields.

 

[k0d0k]

Just like it said. The stored Procedure has to many arguments then your ACCOUNT_TBL has on fields.

can you fix this?

 

[Jerzkie]

Maybe this could help you

USE [ACCOUNT_DBF]
GO
/****** Object:  StoredProcedure [dbo].[usp_CreateNewAccount]    Script Date: 12/28/2014 14:11:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[usp_CreateNewAccount]
 [USER=162874]account[/USER] varchar(32),
@pw varchar(32),
 [USER=847664]Cash[/USER] int = 0,
 [USER=213273]email[/USER] varchar(100) = ''

as
set nocount on
set xact_abort on

if not exists (select * from ACCOUNT_TBL where account = [USER=162874]account[/USER])
begin


	begin tran
	INSERT ACCOUNT_TBL(account,password,isuse,member,id_no1,id_no2,realname, cash, votepoints)
	VALUES [USER=162874]account[/USER], @pw, 'T', 'A', '', '', '', [USER=847664]Cash[/USER])
	INSERT ACCOUNT_TBL_DETAIL(account,gamecode,tester,m_chLoginAuthority,regdate,BlockTime,EndTime,WebTime,isuse,secession, email)
	VALUES [USER=162874]account[/USER],'A000','2','F',GETDATE(),CONVERT(CHAR(8),GETDATE()-1,112),CONVERT(CHAR(8),DATEADD(year,10,GETDATE()),112),CONVERT(CHAR(8),GETDATE()-1,112),'T',NULL, [USER=213273]email[/USER])
	insert AccountPlay (Account, PlayDate)
	select [USER=162874]account[/USER], convert(int, convert(char(8), getdate(), 112))

	if @@error <> 0
	begin
		rollback tran
		select -1
	end
	else
	begin
		commit tran
		select 1
	end
end
else
begin
	select 0
end