CursorType help

Expand Post »

can some one help me with the CursorType

i try to use

Connect.Open "DSN=vault; uid=colu; pwd=colu;"

strSQL = "select CusId,CusName from Customer ORDER BY CusName"

rstdpt.Open strSQL, connect, 3, 1, 1

now some times this code works and some time

PrintRec.Open strsql, connect, 3,3

this works

some times when i use adOpenStatic instead of 3 works some times it doesnt

can some one guide me

Similar Threads

Need Help with ASP in ASP
Very new to ASP in ASP
html table to .csv in HTML and CSS
SQL access via Dreamweaver 2004 MX in MS SQL
Create Windows Authentication in VB.NET

cybour

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jun 2004

Permalink

Jul 13th, 2004

Re: CursorType help

If PrintRec.Open strsql, connect, 3,3 works why not just use that?

Drew

Reputation Points: 25

Solved Threads: 7

Junior Poster

Offline

166 posts
since Apr 2004

Permalink

Jul 13th, 2004

Re: CursorType help

I presume you included adovbs.inc ?

You need that file to use the named ADO constants

RobUK

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

32 posts
since Jul 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP Forum Timeline: loading and external asp link in frames

Next Thread in ASP Forum Timeline: string not working

DaniWeb Message

Cancel Changes

User Name
Password