cursorType in 8.0.2

"Lionstone" <HIDElionstone@HIDEhushmail.com> wrote in message
news:enln0r$t2h$1@forums.macromedia.com...
> You have to pass something in to Rnd which is variable in order for it to
> calculate a new value each time. If the value is cached, then it would do
> no good. :)

I thought RecordID would be sufficient for seeding Rnd, but it obviously
wasn't. Just reiterating b/c it sounds like I'm blaming you there. I was
just thinking out loud, mostly.

Anyway, the stuff in the last post should work.

You have to pass something in to Rnd which is variable in order for it to
calculate a new value each time. If the value is cached, then it would do
no good. :)

This might do it:

<%
Randomize()
randNum = (CInt(1000 * Rnd) + 1) * -1

...snip...

myRS.Source = "SELECT TOP 1 <column list>, r = Rnd(" & randNum & ") FROM
TableName ORDER BY r"
....snip....
%>

If that doesn't get a random record, then change r = Rnd(" & randNum & ") to
r = Rnd(" & randNum & "*RecordID)



"boxhead" <webforumsuser@macromedia.com> wrote in message
news:enl5qe$9j1$1@forums.macromedia.com...
> LionStone
>
> I tryed the Accces Rnd function, but it appeared to bring back the same
> record
> every time. I have read this is due to the record ID (a auto sequential
> number) being the same everytime.
>
> How do i get around this?
>
> P.S. in my defence, there are only about 8 records pulled back and I
> didn't
> have the knowledge at the time to do it properly. :)
>

LionStone

I tryed the Accces Rnd function, but it appeared to bring back the same record every time. I have read this is due to the record ID (a auto sequential number) being the same everytime.

How do i get around this?

P.S. in my defence, there are only about 8 records pulled back and I didn't have the knowledge at the time to do it properly. :)

boxhead wrote:
> so basically revert back to the old way of doing this! Are Macromedia aware of this issue?

It's not Macromedia any more, but I've drawn the attention of the Adobe
team to this thread. You can also get in touch with them directly by
filing a feature request/bug report here:

http://www.adobe.com/cfusion/mmform/index.cfm?name=wishform

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

so basically revert back to the old way of doing this! Are Macromedia aware of this issue?

I think this should be fixed, many of my recordsets won't work in DW8 and I
have to go back to MX2004 ... isn't DW8 an upgrade ? On this feels much more
like a downgrade.

A


"Julian Roberts" <nospam@charon.co.uk> wrote in message
news:enins8$au6$1@forums.macromedia.com...
> Basicly, you can't. The new recordsets use the firehose (forward only)
> cursor and can't be changed.
>
> --
> Jules
> http://www.charon.co.uk/charoncart
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>
>
>
>

Basicly, you can't. The new recordsets use the firehose (forward only)
cursor and can't be changed.

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