Arranging results

[Guest_imported]

Hi,<br><br>I just started with ColdFusion and am building a Curriculum Guide for my school. I have it looking at an Access Database and exporting it to the screen (bascially the same as the demo that comes with ColdFusion). But it looks at the Autonumber ID that I set when I want it to look at the Year Number to arrange the results. (In Australia Year is the same as Grade). If you don't get my drift, goto<br><A HREF="

http://ith.dynodns.net/henley/List.cfm"

TARGET="_new">

http://ith.dynodns.net/henley/List.cfm</A><br>to

see my technical demo and if you want have a look at the website i have created (not yet the official website of the school) goto:<br><A HREF="

http://ith.dynodns.net/henley/"

TARGET="_new">

http://ith.dynodns.net/henley/</A>

 

[sleepy]

Hi,<br>I suppose that you have used a SQL query to put the database on the screen. Try use something like this:<br><br>&lt;cfquery name=&quot;SelectQuery&quot; datasource=&quot;your_datasource&quot;&gt;<br>&nbsp;&nbsp;&nbsp;SELECT * FROM your_table<br>&nbsp;&nbsp;&nbsp;ORDER BY year<br>&lt;/cfquery&gt;<br><br>and then use that result to put the years on the screen.<br>This should work.<br>Success.<br>Sleepy