[thelist] More ASP help

[Salvatore Palmisano]

Have you tried to Response.Write the actual SQL string?
Try this before you .edit or .update anything so you know exactly what's
being passed.

At first glance, it looks like your SQL statement is malformed.  What does
the 'connection, 2,3' portion mean?

--Salvatore Palmisano
Chief Information Officer
International Security Solutions, Inc.
spalmisano at usaiss.com

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Daniel McMurray
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