We just upgraded our dev server to MX 6.1 and also have a new SQL
Server 2K machine that I just exported all of our tables to. I'm getting
the following error:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name
'tbl_Product_Main_LU'.
The error occurred in
C:\CFusionMX\wwwroot\hittite\global_files\left_nav.cfm: line 16
Called from C:\CFusionMX\wwwroot\hittite\index.cfm: line 127
Called from C:\CFusionMX\wwwroot\hittite\global_files\left_nav.cfm: line
16
Called from C:\CFusionMX\wwwroot\hittite\index.cfm: line 127
14 : AND tbl_Product_Main_LU.replace_eff_date IS NULL
15 : OR tbl_Product_Main_LU.tbl_Product_Category_ID =
tbl_Product_Category.Product_CategoryID
16 : AND tbl_Product_Main_LU.replace_eff_date >=
#Now()#
17 : AND int_Hide_Item = 0
18 : ORDER BY tbl_Product_Main_LU.Part_Number
The odd thing is that on line 16 where the error is coming from, the
table that it's choking on is being called in several lines ahead of it
and doesn't seem to have a problem. Anyone have this type of thing
happen before?
Thanks,
Ben
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
