Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 184
  • Last Modified:

Need a dreamweaver Guru!!!!

I am trying to insert data from 1 form to 2 tables by retreiving Identity....i am almost  therebut  i am getting this error

Microsoft OLE DB Provider for SQL Server error '80040e10'

Procedure 'spInsertRecordcup' expects parameter '@StateID', which was not supplied.

/2005statecup/newform2.asp, line 350

how can i code my page in dreamweaver to supply @stateid.

Please help meeeeeeeeee it is urgent


This is my page in dreamweaver   and below i will have my stored procedure

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="../Connections/peru.asp" -->
<%

Dim Command1__Gender
Command1__Gender = ""
if(Request("Gender") <> "") then Command1__Gender = Request("Gender")

Dim Command1__Agegroup
Command1__Agegroup = ""
if(Request("Agegroup") <> "") then Command1__Agegroup = Request("Agegroup")

Dim Command1__TeamName
Command1__TeamName = ""
if(Request("TeamName") <> "") then Command1__TeamName = Request("TeamName")

Dim Command1__Team
Command1__Team = ""
if(Request("Team") <> "") then Command1__Team = Request("Team")

Dim Command1__Clubname
Command1__Clubname = ""
if(Request("Clubname") <> "") then Command1__Clubname = Request("Clubname")

Dim Command1__League
Command1__League = ""
if(Request("League") <> "") then Command1__League = Request("League")

Dim Command1__Division
Command1__Division = ""
if(Request("Division") <> "") then Command1__Division = Request("Division")

Dim Command1__Players
Command1__Players = ""
if(Request("Players") <> "") then Command1__Players = Request("Players")

Dim Command1__ContactName
Command1__ContactName = ""
if(Request("ContactName") <> "") then Command1__ContactName = Request("ContactName")

Dim Command1__Address
Command1__Address = ""
if(Request("Address") <> "") then Command1__Address = Request("Address")

Dim Command1__City
Command1__City = ""
if(Request("City") <> "") then Command1__City = Request("City")

Dim Command1__Zip
Command1__Zip = ""
if(Request("Zip") <> "") then Command1__Zip = Request("Zip")

Dim Command1__HomePhone
Command1__HomePhone = ""
if(Request("HomePhone") <> "") then Command1__HomePhone = Request("HomePhone")

Dim Command1__WorkPhone
Command1__WorkPhone = ""
if(Request("WorkPhone") <> "") then Command1__WorkPhone = Request("WorkPhone")

Dim Command1__Email
Command1__Email = ""
if(Request("Email") <> "") then Command1__Email = Request("Email")

Dim Command1__Bond
Command1__Bond = ""
if(Request("Bond") <> "") then Command1__Bond = Request("Bond")

Dim Command1__Paid
Command1__Paid = ""
if(Request("Paid") <> "") then Command1__Paid = Request("Paid")

Dim Command1__numberofteam
Command1__numberofteam = "5"
if(Request("numberofteam") <> "") then Command1__numberofteam = Request("numberofteam")

Dim Command1__teamlevel
Command1__teamlevel = ""
if(Request("teamlevel") <> "") then Command1__teamlevel = Request("teamlevel")

Dim Command1__statecupfinish
Command1__statecupfinish = ""
if(Request("statecupfinish") <> "") then Command1__statecupfinish = Request("statecupfinish")

Dim Command1__chevycupfinish
Command1__chevycupfinish = ""
if(Request("chevycupfinish") <> "") then Command1__chevycupfinish = Request("chevycupfinish")

Dim Command1__currentleague
Command1__currentleague = ""
if(Request("currentleague") <> "") then Command1__currentleague = Request("currentleague")

Dim Command1__currentdivi
Command1__currentdivi = ""
if(Request("currentdivi") <> "") then Command1__currentdivi = Request("currentdivi")

Dim Command1__fallleague
Command1__fallleague = ""
if(Request("fallleague") <> "") then Command1__fallleague = Request("fallleague")

Dim Command1__fallrecord
Command1__fallrecord = ""
if(Request("fallrecord") <> "") then Command1__fallrecord = Request("fallrecord")

Dim Command1__fallplace
Command1__fallplace = ""
if(Request("fallplace") <> "") then Command1__fallplace = Request("fallplace")

Dim Command1__springleague
Command1__springleague = ""
if(Request("springleague") <> "") then Command1__springleague = Request("springleague")

Dim Command1__springrecord
Command1__springrecord = ""
if(Request("springrecord") <> "") then Command1__springrecord = Request("springrecord")

Dim Command1__springplace
Command1__springplace = ""
if(Request("springplace") <> "") then Command1__springplace = Request("springplace")

Dim Command1__indinateams
Command1__indinateams = ""
if(Request("indinateams") <> "") then Command1__indinateams = Request("indinateams")

Dim Command1__tdate
Command1__tdate = ""
if(Request("tdate") <> "") then Command1__tdate = Request("tdate")

Dim Command1__tname
Command1__tname = ""
if(Request("tname") <> "") then Command1__tname = Request("tname")

Dim Command1__tcity
Command1__tcity = ""
if(Request("tcity") <> "") then Command1__tcity = Request("tcity")

Dim Command1__trecord
Command1__trecord = ""
if(Request("trecord") <> "") then Command1__trecord = Request("trecord")

Dim Command1__tplace
Command1__tplace = ""
if(Request("tplace") <> "") then Command1__tplace = Request("tplace")

Dim Command1__tdate2
Command1__tdate2 = ""
if(Request("tdate2") <> "") then Command1__tdate2 = Request("tdate2")

Dim Command1__tname2
Command1__tname2 = ""
if(Request("tname2") <> "") then Command1__tname2 = Request("tname2")

Dim Command1__tcity2
Command1__tcity2 = ""
if(Request("tcity2") <> "") then Command1__tcity2 = Request("tcity2")

Dim Command1__trecord2
Command1__trecord2 = ""
if(Request("trecord2") <> "") then Command1__trecord2 = Request("trecord2")

Dim Command1__tplace2
Command1__tplace2 = ""
if(Request("tplace2") <> "") then Command1__tplace2 = Request("tplace2")

Dim Command1__tdate3
Command1__tdate3 = ""
if(Request("tdate3") <> "") then Command1__tdate3 = Request("tdate3")

Dim Command1__tname3
Command1__tname3 = ""
if(Request("tname3") <> "") then Command1__tname3 = Request("tname3")

Dim Command1__tcity3
Command1__tcity3 = ""
if(Request("tcity3") <> "") then Command1__tcity3 = Request("tcity3")

Dim Command1__trecord3
Command1__trecord3 = ""
if(Request("trecord3") <> "") then Command1__trecord3 = Request("trecord3")

Dim Command1__tplace3
Command1__tplace3 = ""
if(Request("tplace3") <> "") then Command1__tplace3 = Request("tplace3")

Dim Command1__tdate4
Command1__tdate4 = ""
if(Request("tdate4") <> "") then Command1__tdate4 = Request("tdate4")

Dim Command1__tname4
Command1__tname4 = ""
if(Request("tname4") <> "") then Command1__tname4 = Request("tname4")

Dim Command1__tcity4
Command1__tcity4 = ""
if(Request("tcity4") <> "") then Command1__tcity4 = Request("tcity4")

Dim Command1__trecord4
Command1__trecord4 = ""
if(Request("trecord4") <> "") then Command1__trecord4 = Request("trecord4")

Dim Command1__tplace4
Command1__tplace4 = ""
if(Request("tplace4") <> "") then Command1__tplace4 = Request("tplace4")

Dim Command1__cclub
Command1__cclub = ""
if(Request("cclub") <> "") then Command1__cclub = Request("cclub")

Dim Command1__cteam
Command1__cteam = ""
if(Request("cteam") <> "") then Command1__cteam = Request("cteam")

Dim Command1__ccoach
Command1__ccoach = ""
if(Request("ccoach") <> "") then Command1__ccoach = Request("ccoach")

Dim Command1__ccomments
Command1__ccomments = ""
if(Request("ccomments") <> "") then Command1__ccomments = Request("ccomments")

Dim Command1__cclub2
Command1__cclub2 = ""
if(Request("cclub2") <> "") then Command1__cclub2 = Request("cclub2")

Dim Command1__cteam2
Command1__cteam2 = ""
if(Request("cteam2") <> "") then Command1__cteam2 = Request("cteam2")

Dim Command1__ccoach2
Command1__ccoach2 = ""
if(Request("ccoach2") <> "") then Command1__ccoach2 = Request("ccoach2")

Dim Command1__ccomments2
Command1__ccomments2 = ""
if(Request("ccomments2") <> "") then Command1__ccomments2 = Request("ccomments2")

Dim Command1__cclub3
Command1__cclub3 = ""
if(Request("cclub3") <> "") then Command1__cclub3 = Request("cclub3")

Dim Command1__cteam3
Command1__cteam3 = ""
if(Request("cteam3") <> "") then Command1__cteam3 = Request("cteam3")

Dim Command1__ccoach3
Command1__ccoach3 = ""
if(Request("ccoach3") <> "") then Command1__ccoach3 = Request("ccoach3")

Dim Command1__ccomments3
Command1__ccomments3 = ""
if(Request("ccomments3") <> "") then Command1__ccomments3 = Request("ccomments3")

Dim Command1__cclub4
Command1__cclub4 = ""
if(Request("cclub4") <> "") then Command1__cclub4 = Request("cclub4")

Dim Command1__cteam4
Command1__cteam4 = ""
if(Request("cteam4") <> "") then Command1__cteam4 = Request("cteam4")

Dim Command1__ccoach4
Command1__ccoach4 = ""
if(Request("ccoach4") <> "") then Command1__ccoach4 = Request("ccoach4")

Dim Command1__ccomments4
Command1__ccomments4 = ""
if(Request("ccomments4") <> "") then Command1__ccomments4 = Request("ccomments4")

Dim Command1__otherinfo
Command1__otherinfo = ""
if(Request("otherinfo") <> "") then Command1__otherinfo = Request("otherinfo")

%>
<%

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_peru_STRING
Command1.CommandText = "dbo.spInsertRecordcup"
Command1.Parameters.Append Command1.CreateParameter("@RETURN_VALUE", 3, 4)
Command1.Parameters.Append Command1.CreateParameter("@Gender", 200, 1,50,Command1__Gender)
Command1.Parameters.Append Command1.CreateParameter("@Agegroup", 200, 1,50,Command1__Agegroup)
Command1.Parameters.Append Command1.CreateParameter("@TeamName", 200, 1,50,Command1__TeamName)
Command1.Parameters.Append Command1.CreateParameter("@Team", 200, 1,50,Command1__Team)
Command1.Parameters.Append Command1.CreateParameter("@Clubname", 200, 1,50,Command1__Clubname)
Command1.Parameters.Append Command1.CreateParameter("@League", 200, 1,50,Command1__League)
Command1.Parameters.Append Command1.CreateParameter("@Division", 200, 1,50,Command1__Division)
Command1.Parameters.Append Command1.CreateParameter("@Players", 200, 1,50,Command1__Players)
Command1.Parameters.Append Command1.CreateParameter("@ContactName", 200, 1,50,Command1__ContactName)
Command1.Parameters.Append Command1.CreateParameter("@Address", 200, 1,50,Command1__Address)
Command1.Parameters.Append Command1.CreateParameter("@City", 200, 1,50,Command1__City)
Command1.Parameters.Append Command1.CreateParameter("@Zip", 200, 1,50,Command1__Zip)
Command1.Parameters.Append Command1.CreateParameter("@HomePhone", 200, 1,50,Command1__HomePhone)
Command1.Parameters.Append Command1.CreateParameter("@WorkPhone", 200, 1,50,Command1__WorkPhone)
Command1.Parameters.Append Command1.CreateParameter("@Email", 200, 1,50,Command1__Email)
Command1.Parameters.Append Command1.CreateParameter("@Bond", 200, 1,50,Command1__Bond)
Command1.Parameters.Append Command1.CreateParameter("@Paid", 200, 1,50,Command1__Paid)
Command1.Parameters.Append Command1.CreateParameter("@numberofteam", 200, 1,50,Command1__numberofteam)
Command1.Parameters.Append Command1.CreateParameter("@teamlevel", 200, 1,50,Command1__teamlevel)
Command1.Parameters.Append Command1.CreateParameter("@statecupfinish", 200, 1,50,Command1__statecupfinish)
Command1.Parameters.Append Command1.CreateParameter("@chevycupfinish", 200, 1,50,Command1__chevycupfinish)
Command1.Parameters.Append Command1.CreateParameter("@currentleague", 200, 1,50,Command1__currentleague)
Command1.Parameters.Append Command1.CreateParameter("@currentdivi", 200, 1,50,Command1__currentdivi)
Command1.Parameters.Append Command1.CreateParameter("@fallleague", 200, 1,50,Command1__fallleague)
Command1.Parameters.Append Command1.CreateParameter("@fallrecord", 200, 1,50,Command1__fallrecord)
Command1.Parameters.Append Command1.CreateParameter("@fallplace", 200, 1,50,Command1__fallplace)
Command1.Parameters.Append Command1.CreateParameter("@springleague", 200, 1,50,Command1__springleague)
Command1.Parameters.Append Command1.CreateParameter("@springrecord", 200, 1,50,Command1__springrecord)
Command1.Parameters.Append Command1.CreateParameter("@springplace", 200, 1,50,Command1__springplace)
Command1.Parameters.Append Command1.CreateParameter("@indinateams", 200, 1,50,Command1__indinateams)
Command1.Parameters.Append Command1.CreateParameter("@tdate", 200, 1,50,Command1__tdate)
Command1.Parameters.Append Command1.CreateParameter("@tname", 200, 1,50,Command1__tname)
Command1.Parameters.Append Command1.CreateParameter("@tcity", 200, 1,50,Command1__tcity)
Command1.Parameters.Append Command1.CreateParameter("@trecord", 200, 1,50,Command1__trecord)
Command1.Parameters.Append Command1.CreateParameter("@tplace", 200, 1,50,Command1__tplace)
Command1.Parameters.Append Command1.CreateParameter("@tdate2", 200, 1,50,Command1__tdate2)
Command1.Parameters.Append Command1.CreateParameter("@tname2", 200, 1,50,Command1__tname2)
Command1.Parameters.Append Command1.CreateParameter("@tcity2", 200, 1,50,Command1__tcity2)
Command1.Parameters.Append Command1.CreateParameter("@trecord2", 200, 1,50,Command1__trecord2)
Command1.Parameters.Append Command1.CreateParameter("@tplace2", 200, 1,50,Command1__tplace2)
Command1.Parameters.Append Command1.CreateParameter("@tdate3", 200, 1,50,Command1__tdate3)
Command1.Parameters.Append Command1.CreateParameter("@tname3", 200, 1,50,Command1__tname3)
Command1.Parameters.Append Command1.CreateParameter("@tcity3", 200, 1,50,Command1__tcity3)
Command1.Parameters.Append Command1.CreateParameter("@trecord3", 200, 1,50,Command1__trecord3)
Command1.Parameters.Append Command1.CreateParameter("@tplace3", 200, 1,50,Command1__tplace3)
Command1.Parameters.Append Command1.CreateParameter("@tdate4", 200, 1,50,Command1__tdate4)
Command1.Parameters.Append Command1.CreateParameter("@tname4", 200, 1,50,Command1__tname4)
Command1.Parameters.Append Command1.CreateParameter("@tcity4", 200, 1,50,Command1__tcity4)
Command1.Parameters.Append Command1.CreateParameter("@trecord4", 200, 1,50,Command1__trecord4)
Command1.Parameters.Append Command1.CreateParameter("@tplace4", 200, 1,50,Command1__tplace4)
Command1.Parameters.Append Command1.CreateParameter("@cclub", 200, 1,50,Command1__cclub)
Command1.Parameters.Append Command1.CreateParameter("@cteam", 200, 1,50,Command1__cteam)
Command1.Parameters.Append Command1.CreateParameter("@ccoach", 200, 1,50,Command1__ccoach)
Command1.Parameters.Append Command1.CreateParameter("@ccomments", 200, 1,50,Command1__ccomments)
Command1.Parameters.Append Command1.CreateParameter("@cclub2", 200, 1,50,Command1__cclub2)
Command1.Parameters.Append Command1.CreateParameter("@cteam2", 200, 1,50,Command1__cteam2)
Command1.Parameters.Append Command1.CreateParameter("@ccoach2", 200, 1,50,Command1__ccoach2)
Command1.Parameters.Append Command1.CreateParameter("@ccomments2", 200, 1,50,Command1__ccomments2)
Command1.Parameters.Append Command1.CreateParameter("@cclub3", 200, 1,50,Command1__cclub3)
Command1.Parameters.Append Command1.CreateParameter("@cteam3", 200, 1,50,Command1__cteam3)
Command1.Parameters.Append Command1.CreateParameter("@ccoach3", 200, 1,50,Command1__ccoach3)
Command1.Parameters.Append Command1.CreateParameter("@ccomments3", 200, 1,50,Command1__ccomments3)
Command1.Parameters.Append Command1.CreateParameter("@cclub4", 200, 1,50,Command1__cclub4)
Command1.Parameters.Append Command1.CreateParameter("@cteam4", 200, 1,50,Command1__cteam4)
Command1.Parameters.Append Command1.CreateParameter("@ccoach4", 200, 1,50,Command1__ccoach4)
Command1.Parameters.Append Command1.CreateParameter("@ccomments4", 200, 1,50,Command1__ccomments4)
Command1.Parameters.Append Command1.CreateParameter("@otherinfo", 200, 1,50,Command1__otherinfo)
Command1.CommandType = 4
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

Response.Redirect "confirmation.asp"
%>



CREATE PROCEDURE spInsertRecordcup

      @Gender varchar (50)  ,
      @Agegroup varchar (50)  ,
      @TeamName varchar (150)  ,
      @Team varchar (50)  ,
      @Clubname varchar (150)  ,
      @League varchar (100)  ,
      @Division varchar (50)  ,
      @Players varchar (50)  ,
      @ContactName varchar (150)  ,
      @Address varchar (100)  ,
      @City varchar (100)  ,
      @Zip varchar (50)  ,
      @HomePhone varchar (100)  ,
      @WorkPhone varchar (100)  ,
      @Email varchar (255)  ,
      @Bond varchar (150)  ,
      @Paid varchar (50)  ,
@numberofteam varchar (50) ,
      @teamlevel varchar (50) ,
      @statecupfinish varchar (50) ,
      @chevycupfinish varchar (50) ,
      @currentleague varchar (50) ,
      @currentdivi varchar (50) ,
      @fallleague varchar (50) ,
      @fallrecord varchar (50) ,
      @fallplace varchar (50) ,
      @springleague varchar (50) ,
      @springrecord varchar (50) ,
      @springplace varchar (50) ,
      @indinateams varchar (50) ,
      @tdate varchar (50) ,
      @tname varchar (50) ,
      @tcity varchar (50) ,
      @trecord varchar (50) ,
      @tplace varchar (50) ,
      @tdate2 varchar (50) ,
      @tname2 varchar (50) ,
      @tcity2 varchar (50) ,
      @trecord2 varchar (50) ,
      @tplace2 varchar (50) ,
      @tdate3 varchar (50) ,
      @tname3 varchar (50) ,
      @tcity3 varchar (50) ,
      @trecord3 varchar (50) ,
      @tplace3 varchar (50) ,
      @tdate4 varchar (50) ,
      @tname4 varchar (50) ,
      @tcity4 varchar (50) ,
      @trecord4 varchar (50) ,
      @tplace4 varchar (50),
      @cclub varchar (50) ,
      @cteam varchar (50) ,
      @ccoach varchar (50) ,
      @ccomments varchar (50) ,
      @cclub2 varchar (50) ,
      @cteam2 varchar (50) ,
      @ccoach2 varchar (50) ,
      @ccomments2 varchar (50) ,
      @cclub3 varchar (50) ,
      @cteam3 varchar (50) ,
      @ccoach3 varchar (50) ,
      @ccomments3 varchar (50) ,
      @cclub4 varchar (50) ,
      @cteam4 varchar (50) ,
      @ccoach4 varchar (50) ,
      @ccomments4 varchar (50) ,
      @otherinfo varchar (50) ,
@StateID int

AS




INSERT INTO dbo.statecupform(Gender  ,
Agegroup  ,
TeamName  ,
Team   ,
Clubname  ,
League   ,
Division   ,
Players  ,
ContactName  ,
Address   ,
City   ,
Zip  ,
HomePhone   ,
WorkPhone   ,
Email   ,
Bond   ,
Paid  
  )
 VALUES(@Gender  ,
@Agegroup  ,
@TeamName  ,
@Team   ,
@Clubname  ,
@League   ,
@Division   ,
@Players  ,
@ContactName  ,
@Address   ,
@City   ,
@Zip  ,
@HomePhone   ,
@WorkPhone   ,
@Email   ,
@Bond   ,
@Paid  
  )

SELECT @@IDENTITY

SET @StateID = @@IDENTITY





INSERT INTO dbo.statecupresume(StateID,numberofteam ,
      teamlevel  ,
      statecupfinish  ,
      chevycupfinish ,
      currentleague  ,
      currentdivi  ,
      fallleague  ,
      fallrecord  ,
      fallplace  ,
      springleague  ,
      springrecord  ,
      springplace ,
      indinateams ,
      tdate  ,
      tname  ,
      tcity  ,
      trecord  ,
      tplace ,
      tdate2  ,
      tname2  ,
      tcity2  ,
      trecord2  ,
      tplace2  ,
      tdate3  ,
      tname3  ,
      tcity3  ,
      trecord3  ,
      tplace3  ,
      tdate4 ,
      tname4  ,
      tcity4  ,
      trecord4  ,
      tplace4 ,
      cclub ,
      cteam ,
      ccoach  ,
      ccomments  ,
      cclub2  ,
      cteam2  ,
      ccoach2  ,
      ccomments2  ,
      cclub3  ,
      cteam3  ,
      ccoach3  ,
      ccomments3  ,
      cclub4  ,
      cteam4  ,
      ccoach4  ,
      ccomments4  ,
      otherinfo )

VALUES(@StateID,@numberofteam ,
      @teamlevel  ,
      @statecupfinish  ,
      @chevycupfinish ,
      @currentleague  ,
      @currentdivi  ,
      @fallleague  ,
      @fallrecord  ,
      @fallplace  ,
      @springleague  ,
      @springrecord  ,
      @springplace ,
      @indinateams ,
      @tdate  ,
      @tname  ,
      @tcity  ,
      @trecord  ,
      @tplace ,
      @tdate2  ,
      @tname2  ,
      @tcity2  ,
      @trecord2  ,
      @tplace2  ,
      @tdate3  ,
      @tname3  ,
      @tcity3  ,
      @trecord3  ,
      @tplace3  ,
      @tdate4 ,
      @tname4  ,
      @tcity4  ,
      @trecord4  ,
      @tplace4 ,
      @cclub ,
      @cteam ,
      @ccoach  ,
      @ccomments  ,
      @cclub2  ,
      @cteam2  ,
      @ccoach2  ,
      @ccomments2  ,
      @cclub3  ,
      @cteam3  ,
      @ccoach3  ,
      @ccomments3  ,
      @cclub4  ,
      @cteam4  ,
      @ccoach4  ,
      @ccomments4  ,
      @otherinfo )

return
GO
0
gianitoo
Asked:
gianitoo
1 Solution
 
Ryan ChongCommented:
@StateID should declare as a variable to output but not for input, try amend your Stored Procedure to as:

CREATE PROCEDURE spInsertRecordcup

     @Gender varchar (50)  ,
     @Agegroup varchar (50)  ,
     @TeamName varchar (150)  ,
     @Team varchar (50)  ,
     @Clubname varchar (150)  ,
     @League varchar (100)  ,
     @Division varchar (50)  ,
     @Players varchar (50)  ,
     @ContactName varchar (150)  ,
     @Address varchar (100)  ,
     @City varchar (100)  ,
     @Zip varchar (50)  ,
     @HomePhone varchar (100)  ,
     @WorkPhone varchar (100)  ,
     @Email varchar (255)  ,
     @Bond varchar (150)  ,
     @Paid varchar (50)  ,
@numberofteam varchar (50) ,
     @teamlevel varchar (50) ,
     @statecupfinish varchar (50) ,
     @chevycupfinish varchar (50) ,
     @currentleague varchar (50) ,
     @currentdivi varchar (50) ,
     @fallleague varchar (50) ,
     @fallrecord varchar (50) ,
     @fallplace varchar (50) ,
     @springleague varchar (50) ,
     @springrecord varchar (50) ,
     @springplace varchar (50) ,
     @indinateams varchar (50) ,
     @tdate varchar (50) ,
     @tname varchar (50) ,
     @tcity varchar (50) ,
     @trecord varchar (50) ,
     @tplace varchar (50) ,
     @tdate2 varchar (50) ,
     @tname2 varchar (50) ,
     @tcity2 varchar (50) ,
     @trecord2 varchar (50) ,
     @tplace2 varchar (50) ,
     @tdate3 varchar (50) ,
     @tname3 varchar (50) ,
     @tcity3 varchar (50) ,
     @trecord3 varchar (50) ,
     @tplace3 varchar (50) ,
     @tdate4 varchar (50) ,
     @tname4 varchar (50) ,
     @tcity4 varchar (50) ,
     @trecord4 varchar (50) ,
     @tplace4 varchar (50),
     @cclub varchar (50) ,
     @cteam varchar (50) ,
     @ccoach varchar (50) ,
     @ccomments varchar (50) ,
     @cclub2 varchar (50) ,
     @cteam2 varchar (50) ,
     @ccoach2 varchar (50) ,
     @ccomments2 varchar (50) ,
     @cclub3 varchar (50) ,
     @cteam3 varchar (50) ,
     @ccoach3 varchar (50) ,
     @ccomments3 varchar (50) ,
     @cclub4 varchar (50) ,
     @cteam4 varchar (50) ,
     @ccoach4 varchar (50) ,
     @ccomments4 varchar (50) ,
     @otherinfo varchar (50) ,
AS

DECLARE @StateID int

...

Working now?
0
 
gianitooAuthor Commented:
Bingo amigo
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now