CursorType help

Reply

Join Date: Jun 2004
Posts: 1
Reputation: cybour is an unknown quantity at this point 
Solved Threads: 0
cybour cybour is offline Offline
Newbie Poster

CursorType help

 
0
  #1
Jun 4th, 2004
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
Reply With Quote Quick reply to this message  
Join Date: Apr 2004
Posts: 167
Reputation: Drew is an unknown quantity at this point 
Solved Threads: 7
Drew's Avatar
Drew Drew is offline Offline
Junior Poster

Re: CursorType help

 
0
  #2
Jul 13th, 2004
If PrintRec.Open strsql, connect, 3,3 works why not just use that?
Drew Gauderman
ASP / MSSQL Coder
http://www.iportalx.net - My ASP Portal
Reply With Quote Quick reply to this message  
Join Date: Jul 2004
Posts: 32
Reputation: RobUK is an unknown quantity at this point 
Solved Threads: 1
RobUK RobUK is offline Offline
Light Poster

Re: CursorType help

 
0
  #3
Jul 13th, 2004
I presume you included adovbs.inc ?

You need that file to use the named ADO constants
Rob - DMOZ Editor
Web Design Forums - Free website critiques. Web design + SEO Advice
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the ASP Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC