[thelist] More ASP help

[Don Makoviney]

You may want to try subscribing to a list over on ASPLISTS.com.

The lists are full of pleasant ASP Experts that could answer your
question(s) quickly.

http://www.asplists.com/asplists/aspfreeforall.asp

HTH,

Don Makoviney

-----Original Message-----
From: Daniel McMurray [mailto:mcmurd at ccaa.edu]
Sent: Tuesday, March 06, 2001 12:42 PM
To: thelist at lists.evolt.org
Subject: [thelist] More ASP help


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
	rs.edit
	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
"SELECT........")

Any help is greatly appreciated!
Thanks,
Dan


---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !