SELECT entry randomly

[scoobyd]

Hi, I'm making a web site which has a case study inset in every page. I'm using CFusion to include a .txt file of that case study. What I want to do is to randomly select the .txt files.

I've got three case studies and I've made a table with a field listing the file names. I need a statement to select one of these entries at random.

I'm a beginer so please make it easy!

 

[tlbroadbent]

Are the text file names stored in a SQL Server database? Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com

 

[scoobyd]

No, they're just in a folder. I was thinking if I could randomly get a file name I could put this inside the cfinclude: <cfinclude template=&quot;#RANDOM FILE NAME#&quot; etc etc, though I'm open to other ways of doing it!

 

[tlbroadbent]

This is a SQL Server forum. I recommend asking your question in a CF forum such as forum232. Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com