Solved

Need a dreamweaver Guru!!!!

Posted on 2004-10-07
2
172 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
2 Comments
 
LVL 49

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Simple PHP Upload Script 11 2,685
Site contents shift off page in IE 32 120
Dreamweaver rs SQL format question 4 100
Adobe Indesign CS6 4 75
For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

708 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now