Command Objects

Hi

I have a Command Object from a Stored Procedure and have now been able to
populate the page with the first record returned.

However I am getting an error when I try to perform a Movenext on the
records returned from my Command Object.

What code can I use instead of Movenext?

Thanks in advance.

Brendan

--
___________________________________
Brendan.Collins (AT) NOSPAMSingularity (DOT) co.uk
Remove the NOSPAM
http://www.singularity.co.uk
___________________________________

Use the Recordset behaviour instead of the Command behaviour to call the SP.

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

Julian

Thanks for the quick reply. Your solution has solved the MoveNext problem,
but for some reason I am still getting duplicate records back.

You see my Stored Procedure returns a random requested number of records
from the database and if I use a Repeat Region and display them all on the
one page then it functions correctly.

The problem is when I look to put one on a page and use the "Move to next
record" Server behaviour it sometimes displays a record that it has
previously displayed.

Any ideas???

Brendan

--
___________________________________
Brendan.Collins (AT) NOSPAMSingularity (DOT) co.uk
Remove the NOSPAM
http://www.singularity.co.uk
___________________________________


"Julian Roberts" <news (AT) charon (DOT) co.uk> wrote

Use the Recordset behaviour instead of the Command behaviour to call the
SP.

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

You'd have to rethink your logic. Perhaps have an extra field called
Ordering and run a procedure to update with random numbers every day or so.
Not an easy concept.

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004