a simple question

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
brolinuk Members Profile Find Members Posts Newbie Joined: 24 October 2003 Location: United Kingdom Status: Offline Points: 24	Post Options Post Reply Quote brolinuk Report Post Thanks(0) Quote Reply Topic: a simple question 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

3BEPb Members Profile Find Members Posts Groupie Joined: 07 August 2003 Location: United States Status: Offline Points: 81	Post Options Post Reply Quote 3BEPb Report Post Thanks(0) Quote Reply 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 www.devguru.com

brolinuk Members Profile Find Members Posts Newbie Joined: 24 October 2003 Location: United Kingdom Status: Offline Points: 24	Post Options Post Reply Quote brolinuk Report Post Thanks(0) Quote Reply 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

MorningZ Members Profile Find Members Posts Senior Member Joined: 06 May 2002 Location: United States Status: Offline Points: 1793	Post Options Post Reply Quote MorningZ Report Post Thanks(0) Quote Reply 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

Phat Members Profile Find Members Posts Senior Member Joined: 23 February 2003 Status: Offline Points: 386	Post Options Post Reply Quote Phat Report Post Thanks(0) Quote Reply 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.
	Get a website that sells

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.