[thelist] More ASP help

Daniel McMurray mcmurd at ccaa.edu
Tue Mar 6 11:42:05 CST 2001

Hello once again!  I'm still in ASP hell, and I've encountered another
problem....hopefully someone can help me with this one.

I have two tables inside the database.  The fist records user information,
and the second records the user's choices for the upcoming NCAA final four
tournament.  I have no problem with a single user logging in and picking
their teams.  However, the second person that logs in overwrites the picks
for the first.  I've been making sure the session is closed and reopened,
after my previous problems.

As of now, the page is broken, and I don't know why.  That's where I need
help.  The page that's supposed to record the info looks like this:

  Dim rsWest
  Set rsWest = Server.CreateObject("ADODB.Recordset")
	rsWest.open "SELECT * FROM West where Handle=" &
session("handle"), connection, 2,3
	rsWest("West1-1") = Request.Form("r1")
	rsWest("West1-2") = Request.Form("r2")
	rsWest("West1-3") = Request.Form("r3")
	rsWest("West1-4") = Request.Form("r4")
	rsWest("West1-5") = Request.Form("r5")
	rsWest("West1-6") = Request.Form("r6")
	rsWest("West1-7") = Request.Form("r7")
	rsWest("West1-8") = Request.Form("r8")
	rsWest("West2-1") = Request.Form("r9")
	rsWest("West2-2") = Request.Form("r10")
	rsWest("West2-3") = Request.Form("r11")
	rsWest("West2-4") = Request.Form("r12")
	rsWest("West3-1") = Request.Form("r13")
	rsWest("West3-2") = Request.Form("r14")
	rsWest("West4-1") = Request.Form("r15")
	rsWest.Update                                               '
update the database

  Response.Redirect "home.asp"

There is also an included file that precedes this, but there shouldn't be
a problem with it.  The database has a field for everything listed - the
"Westx-x" fields are set to a numerical value - they pull information from
radio buttons - and the Handle field is a text field.

I have no idea what the problem is, but I keep getting an error returned
that states, "ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/doit/record_west.asp, line 6"

(line 6 is, by the way, the one that begins, "rsWest.open

Any help is greatly appreciated!

More information about the thelist mailing list