Well it would blow up on various states. All the time on CF8. But this has never happened on 7. I restarted the CF service and it seems to be ok now. But that is beside the point really, I am more concerned on what might have caused this issue since it is a very simple query that just pulls state data.
In CF7 you could not use cachedwithin and cfqueryparam together, thus.....no cfqueryparam - I am doing some checks for injection before the data is passed to the query. With 8 will be adding the cfqueryparam in b/c they can be used together. > On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: > > the sudden, something that has been working without fail for months > in CF7 > > is giving odd errors. On CF8 I will get intermittent errors that > say > > "corrupt table null". If I remove the cachedwithin attribute the > query runs > > fine. For example, I can pass in the state argument of AL and it > works > > fine, but when I pass in CO it blows up. Any thoughts? > > You mean it always blows up with 'CO', or only sometimes ? > > Oh, and cfqueryparam everything ! > > -- > Tom Chiverton > > **************************************************** > > This email is sent for and on behalf of Halliwells LLP. > > Halliwells LLP is a limited liability partnership registered in > England and Wales under registered number OC307980 whose registered > office address is at St James's Court Brown Street Manchester M2 2JF. > A list of members is available for inspection at the registered office. > Any reference to a partner in relation to Halliwells LLP means a > member of Halliwells LLP. Regulated by the Law Society. > > CONFIDENTIALITY > > This email is intended only for the use of the addressee named above > and may be confidential or legally privileged. If you are not the > addressee you must not read it and must not use any information > contained in nor copy it nor inform any person other than Halliwells > LLP or the addressee of its existence or contents. If you have > received this email in error please delete it and notify Halliwells > LLP IT Department on 0870 365 8008. > > For more information about Halliwells LLP visit www.halliwells.com. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285688 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4