Forum Home
Press F1
 
Thread ID: 16646 2002-03-14 05:33:00 Another ASP Hicough Guest (0) Press F1
Post ID Timestamp Content User
39069 2002-03-14 05:33:00 Hi,

Another sticking point here, I'm trying to update a database. It's in my 'Parts' Database again, and the table is called 'Customers'.

Thye problematic line of code reads:

Customers.Open Query, Connect, adOpenStatic, adLockOptimistic

The Value for Query is:

Query = 'SELECT * FROM Customers'

And it is on the preceding line.

It throws me the error:

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/5040/unleash/Purchase2.asp, line 17


What's wrong?

Thanks in advance,

:)

Erin
Guest (0)
39070 2002-03-16 08:59:00 Hi Erin,

Surely if you are trying to UPDATE the database you use the SQL UPDATE rather than SELECT?
Guest (0)
1