Title:
Bug 84170:I think I may have filed this bug before, but I can't find a way to search the bugs by creator, and I'm not finding it with keywords
| View in TrackerStatus/Resolution/Reason: Closed/Withdrawn/
Reporter/Name(from Bugbase): Roman Smolkin / Roman Smolkin (pixelwiz19801)
Created: 09/14/2010
Versions: 9.0
Failure Type: Unspecified
Found In Build/Fixed In Build: 0000 /
Priority/Frequency: Trivial / Unknown
Locale/System: English / Win All
Vote Count: 0
Problem:
I think I may have filed this bug before, but I can't find a way to search the bugs by creator, and I'm not finding it with keywords. And I think this was confirmed before as well, but not yet fixed (our IT guys says we are runnig 9,0,0,251028). But it may have been for CF8.When a structure change is done in MS SQL Server DB, such as deleting or renaming a column, ColdFusion starts throwing all sorts of errors even if the query is updated and is correct. Somehow CF is cashing the SQL Server table columns and structure, and when there are DB changes, CF is not detecting them till it's restarted. Not the end of the world in Development, but very scary if that happens on a live server. Let me know if I need to provide a more specific example.
Method:
Rename or delete a column in MS SQL Server DB that is not used by CFQuery. Then try to run a query againts that table, it'll fail because it's looking for that column.
Result:
Varies, sometimes is says Data Conversion Error, sometimes it says column does not exist
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3042169
External Customer Info:
External Company:
External Customer Name: Roman Smolkin
External Customer Email: 52B0693546A4D14B992015C2
External Test Config: 09/14/2010Attachments:
Comments: