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
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
