invalid argument value error

[myatia]

I'm getting an "invalid argument value" error whenever I try to update a record, regardless of the values I try to enter. Here's a sample of my code that's getting the error:

ID = Request.Form("id")

set rs = server.createobject("ADODB.Recordset")
	
rs.cursorlocation = adUseServer
rs.cursortype = adOpenForwardOnly
rs.locktype = adLockOptimistic

st = "SELECT * FROM GuideData WHERE id = " & ID
rs.open st, connq, , , adCmdText

'' indexname is a character type, width 37
rs("indexname") = "your name here" 

rs.Update
rs.close()

I have no idea why I'm getting this error. It seems like a pretty basic update to me. Any help would be greatly appreciated.

Thanks,

Misty

 

[ehsant]

Hi...
have you tried other cursortype ?
for example : adOpenStatic

----
TNX.
E.T.

 

[myatia]

Thanks for the suggestion, but they all result in the following:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Visual FoxPro Driver]Invalid argument value
/career/career_guide/acguide_signup_demographics.asp, line 83

Line 83 is the line with rs.Update on it.

 

[ehsant]

Hi...
OK, I think it's because of your DB and your connection string.
since I don't have any experience on FoxPRo, I can't tell you what to do, but have you tried other providers liek OLEDB ?

----
TNX.
E.T.