Random portal record

[rivet]

I am creating a cdml solution that requires a random image.

I have a list of theatres with related movies. When I list the theatres I want one random movie image to show beside the name.

[cjaeger]

give your movie images a serial number starting at 1, step 1

for the key in the main db use an unstored calculation

int(RANDOM * count(MOVIEIMG::ID))

[rivet]

That works great, but it can result a zero. Can that be avoided?

[danjacoby]

How about:

(int(Random * (count(MovieImg::ID) - .5)) + .5

[rivet]

that does not seem to work. A bracket it missing but I have tried different combinations and zero still appears.

[Vaughan]

Whay not use an In-Line Action with the -FindAny tag?

[danjacoby]

Wups -- I added an open parenthesis at the beginning.

But there may be a problem using the "Int" function. Try this:

Round((Random * (count(MovieImg::ID) - .5)) + .5, 0)

[rivet]

That was it thanks so much.