using sql server, asp, ie6
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
this happens on the vrec.open line below. it happens consistently, not sporadically.
sql = "SELECT transno FROM ClaimTrans WHERE claimno =" & claimno vrec.open sql, adoCon
i have used the same connection and recordset before, both without trouble (well, this kind of trouble at least) - they're both set in a common ssi, which is used in all of my pages (about a dozen or so). I've also used them both dozens and dozens of times without a hitch. I even have a select on the same page (which works) that is *exactly* the same bar that it selects a few more fields:
sql = "SELECT fieldname, croptype, area, transno FROM ClaimTrans WHERE claimNo=" & claimno
vrec.open sql, adoCon
transno is a unique key field with an identity seed, which my boss suggested might be the issue, but i tried selecting 'area' - float - and 'fieldname' - nvarchar - in transno's place, with the same error
puleeaaase someone point out the (probably) simple problem that is causing this...
Edited by ub3rl337ch3ch - 14 November 2005 at 10:01pm
Topic Options
Post Options
Thanks(0)
