http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-24T23:51:55 en-us http://livedocs.adobe.com/coldfusion/7/htmldocs/00000599.htm#73215 I suspect we intended to change the column name in the database from Number, which is not a very good name, but never did it.<br><br>The example has several other errors. <br>For a working version see the version in the ColdFusion 8 Livedocs, <br>http://livedocs.adobe.com/coldfusion/8/htmldocs/functions_m-r_17.html halL 1 1 2007-09-04T11:35:13 http://livedocs.adobe.com/coldfusion/7/htmldocs/00000599.htm#73214 We probably intended to rename the database table column, as Number is not a good name for a DB column. halL 1 0 2007-09-04T11:01:22 http://livedocs.adobe.com/coldfusion/7/htmldocs/00000599.htm#73168 To Run this code without error:<br />(1) Column name "Number", should be in select clause.<br />(2) There is no such column named "Course_Number", so either remove this or replace this by column name "Number". Ashish-Saxena 0 0 2007-09-03T06:43:39