[thelist] ADO

According to MSDN there is no Options property on the ADODB.Recordset
object. I believe that you can just leave that line of code out and it
should work.

HTH,

Jed.

________________________________________________________________ 
Jed Farr 
jedf@alextra.com <mailto:jedf@alextra.com> 
http://www.alextra.com 

Alextra Ltd, Unit 7, Newbery Centre, Airport Business Park, Exeter UK. EX5
2UL 
Tel +1 800 789 7515 Direct +44 (0)1392 440338   Fax: +1 281 754 4333 


> -----Original Message-----
> From: Norman Beresford [mailto:Norman@pigfe.freeserve.co.uk]
> Sent: Wednesday, June 21, 2000 4:39 PM
> To: thelist@lists.evolt.org
> Subject: [thelist] ADO
> 
> 
> Hi all
> 
> Probably a really simple one this.  I want to create a 
> recordset using an
> SQL query:
> 
> Set itemRS = Server.CreateObject("ADODB.RecordSet")
> itemRS.Source = "productTable"
> itemRS.ActiveConnection = "kusun1"
> itemRS.CursorType = adOpenKeyset
> itemRS.LockType = adLockPessimistic
> itemRS.Options = adCmdText
> itemRS.Open
> 
> However when I run this on PWS I get this error
> 
> Microsoft VBScript runtime error '800a01b6'
> 
> Object doesn't support this property or method: 'itemRS.Options'
> 
> /KUSU/admin/stock_add.asp, line 41
> 
> 
> Anyone know why this isn't working?  AFAIK (and indeed what 
> the WROX book
> tells me) is that .options is supported by the RecordSet object.
> 
> Thanks in advance
> 
> Norman
> 
> 
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt ! 
>