Mike, You are most likely running into an instance of the previous developer using ColdFusion's "query of queries" functionality. That's what Teddy, John and Ken are getting at.
Once you retrieve or create a CF query result - usually by running a normal CF query to a "real" database table, you can then re-query the results. So you can do: <cfquery name="myQuery" datasource="myDSN"> SELECT * FROM myTable </cfquery> And then do: <cfquery name="mySecondQuery" dbtype="query"> SELECT myField FROM myQuery </cfquery> So in your case: SELECT * > FROM qryGetVisitRecords > ..,. there's almost surely a previous query - a 'real' one - named qryGetVisitRecords -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560
