Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Procedure has too many arguments specified.

Author  Topic 

jamie
Aged Yak Warrior

542 Posts

Posted - 2004-07-09 : 05:55:48
hello,
OI am trying to run a stored procedure to insert values into atable and gte the error:
Procedure or function Add_Info has too many arguments specified.

if one of he values as a - in it.
(the field is a varchar and works if the data is like aaasss ,
but if like aaa-sss-ss it fails)

thnaks for any info.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2004-07-09 : 05:57:51
Are you sure there are single quotes around it when it's being passed?
Go to Top of Page

jamie
Aged Yak Warrior

542 Posts

Posted - 2004-07-09 : 06:05:38
weird, it works from QA but not from an asp page..
Go to Top of Page

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2004-07-09 : 06:11:10
Please post the code. We can have a better look.

Regards
Sachin
Go to Top of Page

jamie
Aged Yak Warrior

542 Posts

Posted - 2004-07-09 : 06:11:18
nevermind, all sorted, asp error rathre than sql.
sorry for posting
Go to Top of Page
   

- Advertisement -