Fields missing in query

[Robert10]

I am having an odd problem.

I have a table in MSSQL named Residential. In this table I have 32 fields (all
of which I use) for some reason all of a sudden I was unable to access the
field ResidentialPartOID when using CFquery with CFQUERYParam.

Doing so Cold Fusion 7 tells me that the field ResidentialPartOID does not
exist.

I run the same query in query analyzer and it works fine (replacing the
CFQUERY params with actualy values I type in). I can see the field
ResidentialPartOID in the results.

On an odd shot, I renamed the table to ResidentialTest. Voila! Ye olde query
works fine and I can access the ResidentailPartOID field just fine in Cold
Fusion.

I rename the table back to Residential... and the query fails again.

Obviously this must be something in my database causing this... any idea what?

I know that when using CFQueryParam it tells ColdFusion to access the data in
a more efficient method... but what that method is... I do not know.

Anyone have any suggestions, comments, etc?

[Robert10]

Ooooooook.... not exactly sure what was wrong (If anyone knows I would love to
know) but I fixed it.

I simply dropped the table, did a DB shrink. and then reimported the data.

The query seems to be working correctly now as expected.

However I would like to know what caused this behavior in the first place.