At a guess, I'd say that the DB is caching pointers to the data, and
changing data via the adminstrator isn't refreshing the view's pointers for
whatever reason. Just a guess, though.
I'd look on the MS web site to see if that's a known (and admitted) bug, and
if there's a fix or better workaround.
--Ben Doom
Programmer & General Lackey
Moonbow Software
: -----Original Message-----
: From: Les Mizzell [mailto:[EMAIL PROTECTED]]
: Sent: Monday, December 16, 2002 2:52 PM
: To: CF-Talk
: Subject: RE: Slightly OT: SQL VIEW gets out of sync??
:
:
: :> What DB?
:
: MS SQL Server 7
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
