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.

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))

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

How about:

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

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

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

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)

That was it thanks so much.