J.R.,
The difference in the way the two statements function is in your code. In the first
example, you set the cursor type (rs.Open sql, conn,3,3) as updatable. In the second
example, you set the cursor to the default type (non-updatable: rs.Open sql, conn).
I haven't used ASP extensively
I had a similar problem before, asp would not return where any bigint types
where involved in the query. The fix was to check the 'convert bigint to
int' box
in the myodbc settings and everything came back just fine. might be worth
a try
Sean
-Original Message-
From: Mariusz
it doesn't work... maybe problem lies in W2k where mySQL server is
installed?
Mariusz Muszalski
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 21 August 2001 11:39
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: mySQL and ASP
I had a similar