Keep getting error message Microsoft VBScript runtime error '800a01a8'

[cpando1974]

Hi,

Getting the following error message:


Microsoft VBScript runtime error '800a01a8'
Object required /cpa/dt-new/updater2b.asp, line 40

A little baffled and I just cannot see where the problem is, I know its going to be something simple! The code is below and the last line is line 40.

Dim strConn, objConn, strMonthEnd, strDate
Dim objRS_Teams, strQ_Teams, objRS_TeamPlayers, strQ_TeamPlayers, strQ_TeamUpdate
Dim strQ_MOM, objRS_MOM, strQ_WOM, objRS_WOM, strQ_MOMUpdate, strQ_WOMUpdate, strQ_MonthEnd
Dim arrTeamPlayers(12,2), strTeamSN, strTeamScore, strTeamScoreDiff, strGkScore, strDefScore, strMidScore, strStrScore, strPresMonth
Dim strMonthEndScore, strTeamPlayerID, strTeamPlayersCounter, strPositionOld, strPositionNew, strMovement, strPositionCounter
Dim strMOMPtsCheck, strWOMPtsCheck
Dim strLeagueCount
Dim strLeague
'***** Open db connection *****
Set objConn = Server.CreateObject("ADODB.Connection")
strConn = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=mysql10.streamline.net; DATABASE=**********; UID=**********;PASSWORD=**********; OPTION=3"
objConn.Open strConn
'***** Retrieve month end from form *****
strMonthEnd = Trim(Request.Querystring("monthEnd"))
'************************************************* ************************************************** ****************************
'************************* Update teams from PLAYERS db *************************
'***** Loop through the leagues *****
For strLeagueCount = 1 to 2
'***** Determine which league to update. Count 1 = BCP and Count 2 = LOD *****
If strLeagueCount = 1 Then
strLeague = "bcp"
ElseIf strleagueCount = 2 Then
strLeague = "lod"
End If

strQ_Teams = "SELECT * FROM tbldt200708B WHERE league='" & strLeague & "'"
Set objRS_Teams = objConn.Execute(strQ_Teams)


Any help will be much appreciated.

Thanks

Chris

[thriftyspider]

Not too sure (fairly new to ASP myself), but '" & strLeague & "'" does not look quite right shouldn't the & signs be outside the quotes when your doing concatenation? i.e. strQ_Teams = "SELECT * FROM tbldt200708B WHERE league=' & "strLeague" &"

Rob

[cpando1974]

Apologies, forgot to post I had figured it out just recently.

Bit of a numty really. Further down the page I had closed off the SQL connection before the loop ended instead of after it, so when it looped back round, there was no connection.