Don't use SELECT * in your queries. This usually happens if you use SELECT * then change the structure of a data table. SQL caches the query structure and then the fields don't match up when the query is run again (post table altering).
If you want a quick fix (other than changing your query), in the CF Admin, uncheck the box for the datasource to maintain connections... Refresh the query page a few times, then check that box again (for performance reasons). ....................... Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 x 14 212.691.3477 fax www.nylontechnology.com "Some people call me the space cowboy. Some people call me the gangster of love." -----Original Message----- From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 27, 2006 3:03 AM To: CF-Talk Subject: Error message Has anyone encountered this before... ------------ Error Occurred While Processing Request 10 >= 10 Please try the following: Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debugging Settings, and select the Robust Exception Information option. Check the ColdFusion documentation to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Remote Address 60.234.180.194 Referrer http://www.eggmaternity.co.nz/headoffice/index.cfm?action=newsletter Date/Time 27-Jun-06 06:52 PM ------------ All my page is doing is querying an SQL Server DB to show a list of elements. If I log out and login again, the page displays as per normal?? 10 >= 10? There are no equations even on the page? mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244864 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
