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
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
