Solved

Need a dreamweaver Guru!!!!

Posted on 2004-10-07
2
180 Views
Last Modified: 2010-04-25
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
Comment
Question by:gianitoo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 52

Accepted Solution

by:
Ryan Chong earned 500 total points
ID: 12255451
@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
 
LVL 1

Author Comment

by:gianitoo
ID: 12281325
Bingo amigo
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question