random number

[dave]

Hello all,
I have written one function to generate random number.
but every time I execute the function it repeats same
number many times even though I'm using Randomize.

function myrandnum()
upperbound = 32767
lowerbound = -32768
Randomize
myrandnum = Int((upperbound - lowerbound + 1) *
Rnd + lowerbound)
end function

its not as good as effective as

set objTools=server.CreateObject("MSWC.Tools")
objTools.Random()

Any help would be appreciated...
Rgds
dave

 

[Bob Milutinovic]

G'day, Dave...

A wise man once said, "the generation of random numbers is too important
to be left to chance."

Replace the generic "Randomize" statement with;

Randomize Timer

- Bob.

 

[Guest]

Or, use the inbult NewId() function inside sql server which does this
automatically.

 

[dave]

Thanx Bob..It worked good

-----Original Message-----
G'day, Dave...

A wise man once said, "the generation of random numbers is too important
to be left to chance."

Replace the generic "Randomize" statement with;

Randomize Timer

- Bob.





.