Documentation Details :: Creat Image Gallery - Problem with ON ORDER statment?

This thread was displayed: 212 times

Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.

For more information about the affected products visit: www.interaktonline.com/Support/

View Threaded Show descending

BCB

02-15-2006 16:15:08 GMT +2

In the Create Image Gallery docmentation... building the first SQL Querie below (for Access DB's) [BTW I know its its rnd() not rand()] ... however I keep getting error in ON ORDER! Is there a problem with Acces DB's and this statement in this particular example? OR a different way to state this that would produce the same results?

Thanks BCB

SELECT *, rand() as random_number

FROM image_img

ORDER BY random_number DESC LIMIT 1

Back | Reply | Quote | Top

Florin CARLIG[InterAKT] Adobe Systems Romania staff

02-15-2006 18:12:59 GMT +2

Hello,

In Microsoft access you cannot use an alias in the ORDER BY clause. So, I'm afraid you cannot use this kind of SQL, and you should try to diplay a random image by modifying the code that is displaying the actual image.

This is an Access issue, it's not really related to our products.

Regards,
Florin CARLIG

Reply | Quote | Top

Messages 1 to 1 from 1

Home > Support > Forums > Documentation > Details

Adobe acquired InterAKT

InterAKT has been acquired by Adobe.

Learn more