Classic ASP Discussion - a simple question

Print Page | Close Window

a simple question

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=7029
Printed Date: 31 March 2026 at 4:31pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: a simple question

Posted By: brolinuk
Subject: a simple question
Date Posted: 05 November 2003 at 2:43pm

Anybody please tell me what is the meaning of the number 1 and 2 at the of the code below and where would I be able to find out the details about these prameters (any tutorial web sites?)Thanks

strSQL="select file from down where id="&request("id")&" and type="&request("no"),adoCon,1,2

Replies:

Posted By: 3BEPb
Date Posted: 05 November 2003 at 3:00pm

Obviously - locks, but they won't work this way. You must add them after opening of strSQL, like

RS.Open strSQL,adoCon,1,2

Find more on http://www.devguru.com - www.devguru.com

Posted By: brolinuk
Date Posted: 05 November 2003 at 3:24pm

I have just tried use "RS.Open strSQL,adoCon,1,2", but I got an error

Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC driver does not support the requested properties.
/cohl/ebooks/down.asp, line 43

I am using iis 5 under windows XP professional. How would I be able to solve this problem? thanks

Posted By: MorningZ
Date Posted: 05 November 2003 at 8:52pm

leave off the "1,2" at the end...

dont understand what they do.. dont use them

-------------
Contribute to the working anarchy we fondly call the Internet

Posted By: Phat
Date Posted: 05 November 2003 at 9:56pm

The fisrt one is the cursor type

0=adOpenForwardOnly
1=adOpenKeyset
2=adOpenDynamic
3=adOpenStatic

the second one is the lock type

0=adLockReadOnly
1=adLockPessimistic
2=adLockOptimistic
3=adLockBatchOptimistic

you need to use the right one depending on what you're doing. You can leave them off but then ado uses the defaults which may not be what you want.

-------------
http://buildit.sitesell.com/sitebuildithome.html - Get a website that sells