thanks heaps ben, this is exactly what was occurring. i had changed the db structure and it was showing old results when cfdumping.
cheers mike >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:244924 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
