Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Object doesn't support this property or method: ZoneRS.MoveFirst'

Reply
Thread Tools

Object doesn't support this property or method: ZoneRS.MoveFirst'

 
 
shank
Guest
Posts: n/a
 
      10-31-2003
Can anyone give me some general ideas on why an error like

Object doesn't support this property or method: 'ZoneRS.MoveFirst'

comes up on a page?
MoveFirst is a command to move to the first record... correct?
thanks


 
Reply With Quote
 
 
 
 
Dan Brussee
Guest
Posts: n/a
 
      10-31-2003
On Thu, 30 Oct 2003 19:25:59 -0500, "shank" <(E-Mail Removed)>
wrote:

>Can anyone give me some general ideas on why an error like
>
>Object doesn't support this property or method: 'ZoneRS.MoveFirst'
>
>comes up on a page?
>MoveFirst is a command to move to the first record... correct?
>thanks
>


For a recordset object, it is. Post the connection code and the code
you use to set the ZoneRS recordset. If the recordset is not
instantiated (failed SQL statement???) the Recordset object is not
there, so what you have is a variant - and variants do not have
MoveFirst methods.

 
Reply With Quote
 
 
 
 
Chris Barber
Guest
Posts: n/a
 
      10-31-2003
It may be a forward-only 'firehose' cursor (default if no other cursor and
cursor location specified) in which case that error is correct - moving
backward through the recordset wouldn't be supported.

Chris.

"Dan Brussee" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
On Thu, 30 Oct 2003 19:25:59 -0500, "shank" <(E-Mail Removed)>
wrote:

>Can anyone give me some general ideas on why an error like
>
>Object doesn't support this property or method: 'ZoneRS.MoveFirst'
>
>comes up on a page?
>MoveFirst is a command to move to the first record... correct?
>thanks
>


For a recordset object, it is. Post the connection code and the code
you use to set the ZoneRS recordset. If the recordset is not
instantiated (failed SQL statement???) the Recordset object is not
there, so what you have is a variant - and variants do not have
MoveFirst methods.


 
Reply With Quote
 
Dan Brussee
Guest
Posts: n/a
 
      10-31-2003
I hontestly have not tested the thought, but I figured if the user had
an real recordset, it would "have" the MoveFirst method even if it
generated an error when it was used. In other words, the MoveFirst
method is defined, but not allowed for Forwared Only recordsets. Does
this make sense?


On Fri, 31 Oct 2003 02:02:54 -0000, "Chris Barber"
<(E-Mail Removed)> wrote:

>It may be a forward-only 'firehose' cursor (default if no other cursor and
>cursor location specified) in which case that error is correct - moving
>backward through the recordset wouldn't be supported.
>
>Chris.
>
>"Dan Brussee" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed).. .
>On Thu, 30 Oct 2003 19:25:59 -0500, "shank" <(E-Mail Removed)>
>wrote:
>
>>Can anyone give me some general ideas on why an error like
>>
>>Object doesn't support this property or method: 'ZoneRS.MoveFirst'
>>
>>comes up on a page?
>>MoveFirst is a command to move to the first record... correct?
>>thanks
>>

>
>For a recordset object, it is. Post the connection code and the code
>you use to set the ZoneRS recordset. If the recordset is not
>instantiated (failed SQL statement???) the Recordset object is not
>there, so what you have is a variant - and variants do not have
>MoveFirst methods.
>


 
Reply With Quote
 
shank
Guest
Posts: n/a
 
      10-31-2003
Thanks to all..!
I took your suggestions and picked the page apart..
Ended up scrapping it and rebuilding. It now works.
I hate not know what I did wrong...
sigh...


 
Reply With Quote
 
Chris Barber
Guest
Posts: n/a
 
      10-31-2003
There is a cursor type and a cursor location that can be specified when you
open the recordset. A 'firehose' (forward-only, server-side cursor) is the
fastest type of recordset to request and traverse and is thus the default.

http://www.adopenstatic.com/faq/jetcursortypes.asp

I don't know how the MoveFirst restriction is implemented - I would presume
an error is raised.

Hope this helps.

Chris.

"Dan Brussee" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
I hontestly have not tested the thought, but I figured if the user had
an real recordset, it would "have" the MoveFirst method even if it
generated an error when it was used. In other words, the MoveFirst
method is defined, but not allowed for Forwared Only recordsets. Does
this make sense?


On Fri, 31 Oct 2003 02:02:54 -0000, "Chris Barber"
<(E-Mail Removed)> wrote:

>It may be a forward-only 'firehose' cursor (default if no other cursor and
>cursor location specified) in which case that error is correct - moving
>backward through the recordset wouldn't be supported.
>
>Chris.
>
>"Dan Brussee" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed).. .
>On Thu, 30 Oct 2003 19:25:59 -0500, "shank" <(E-Mail Removed)>
>wrote:
>
>>Can anyone give me some general ideas on why an error like
>>
>>Object doesn't support this property or method: 'ZoneRS.MoveFirst'
>>
>>comes up on a page?
>>MoveFirst is a command to move to the first record... correct?
>>thanks
>>

>
>For a recordset object, it is. Post the connection code and the code
>you use to set the ZoneRS recordset. If the recordset is not
>instantiated (failed SQL statement???) the Recordset object is not
>there, so what you have is a variant - and variants do not have
>MoveFirst methods.
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
JScript: object doesn't support this property or method zdrakec ASP .Net 0 09-26-2007 08:02 PM
Binding to property of property of object collection TS ASP .Net 3 08-31-2006 12:57 PM
DataBinder.Eval for an object's property property... like Eval(Container.DataItem,"Version.Major") Eric Newton ASP .Net 3 04-04-2005 10:11 PM
Error: Object doesn't support this property or method Roman ASP .Net 0 01-04-2004 04:50 PM
Client Side, User Control "Object Doesn't support this property or method" todd ASP .Net 3 10-16-2003 06:53 PM



Advertisments