I believe with SQL 7, each time when a view is created ('saved'), it saves and maps the underlying schema for the view, hence, later on, if there's any schema revision, e.g. a column is added, the new stuff (the new column) won't be returned by the view. At least that's the theory, I haven't tested it myself.
Don Li Hegel, LLC http://www.hegelsoftware.com --- Ben Doom <[EMAIL PROTECTED]> wrote: > What DB? > > > > --Ben Doom > Programmer & General Lackey > Moonbow Software > > : -----Original Message----- > : From: Les Mizzell [mailto:[EMAIL PROTECTED]] > : Sent: Monday, December 16, 2002 2:18 PM > : To: CF-Talk > : Subject: Slightly OT: SQL VIEW gets out of sync?? > : > : > : Anybody ever seen this before... > : > : Got a View set up in a SQL Database using inner > joins...which is then > : displaying data on a CF page. View looks like: > : > : SELECT app_Master.*, app_register.*, app_1.*, > app_2.*, app_3.*, > : app_4.*, app_5.* > : FROM dbo.app_Master INNER JOIN > : dbo.app_register ON > : dbo.app_Master.MSTR_UserID = > dbo.app_register.Reg_UserID > : INNER JOIN > : dbo.app_1 ON > : dbo.app_Master.MSTR_AppID = > dbo.app_1.App1_AppID > : INNER JOIN > : dbo.app_2 ON > : dbo.app_Master.MSTR_AppID = > dbo.app_2.App2_AppID > : INNER JOIN > : dbo.app_3 ON > : dbo.app_Master.MSTR_AppID = > dbo.app_3.App3_AppID > : INNER JOIN > : dbo.app_4 ON > : dbo.app_Master.MSTR_AppID = > dbo.app_4.App4_AppID > : INNER JOIN > : dbo.app_5 ON > : dbo.app_Master.MSTR_AppID = > dbo.app_5.App5_AppID > : > : I'm not calling any specific fields in any > tables.... > : > : All works fine until I go into a specific table in > the SQL > : Administrator any > : add or change a row to the table. If I now look at > my CF display > : pagencalling the view, the displayed stuff will be > "off" - say, > : last name is > : now displaying where the first name should be or > something - the SQL View > : has gotten data "out of sync" somehow. > : > : Only way I can fix it is to go back into the SQL > administrator and resave > : the view. > : > : > : Ideas? > : > : > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com