Monday, March 26, 2012

Help on report -- query posted ***********

I'm trying to run this query and it keeps erroring out on me in VS.net and on
the server -- it's generic can anyone help?
SELECT dbo.MSP_TASKS.PROJ_ID, dbo.MSP_WEB_PROJECTS.PROJ_NAME,
dbo.MSP_TASKS.TASK_ID, dbo.MSP_TASKS.TASK_NAME,
dbo.MSP_VIEW_PROJ_TASKS_STD.TaskStart,
dbo.MSP_VIEW_PROJ_TASKS_STD.TaskFinish
FROM dbo.MSP_TASKS INNER JOIN
dbo.MSP_WEB_PROJECTS ON dbo.MSP_TASKS.PROJ_ID = dbo.MSP_WEB_PROJECTS.WPROJ_ID INNER JOIN
dbo.MSP_VIEW_PROJ_TASKS_STD ON
dbo.MSP_WEB_PROJECTS.WPROJ_ID = dbo.MSP_VIEW_PROJ_TASKS_STD.WPROJ_ID
ORDER BY dbo.MSP_TASKS.PROJ_ID, dbo.MSP_TASKS.TASK_IDhere's teh error i'm getting when trying to run it on the web
Runtime Error
Description: An application error occurred on the server. The current custom
error settings for this application prevent the details of the application
error from being viewed remotely (for security reasons). It could, however,
be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable
on remote machines, please create a <customErrors> tag within a "web.config"
configuration file located in the root directory of the current web
application. This <customErrors> tag should then have its "mode" attribute
set to "Off".
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>
Notes: The current error page you are seeing can be replaced by a custom
error page by modifying the "defaultRedirect" attribute of the application's
<customErrors> configuration tag to point to a custom error page URL.
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration>
"Erin" wrote:
> I'm trying to run this query and it keeps erroring out on me in VS.net and on
> the server -- it's generic can anyone help?
> SELECT dbo.MSP_TASKS.PROJ_ID, dbo.MSP_WEB_PROJECTS.PROJ_NAME,
> dbo.MSP_TASKS.TASK_ID, dbo.MSP_TASKS.TASK_NAME,
> dbo.MSP_VIEW_PROJ_TASKS_STD.TaskStart,
> dbo.MSP_VIEW_PROJ_TASKS_STD.TaskFinish
> FROM dbo.MSP_TASKS INNER JOIN
> dbo.MSP_WEB_PROJECTS ON dbo.MSP_TASKS.PROJ_ID => dbo.MSP_WEB_PROJECTS.WPROJ_ID INNER JOIN
> dbo.MSP_VIEW_PROJ_TASKS_STD ON
> dbo.MSP_WEB_PROJECTS.WPROJ_ID = dbo.MSP_VIEW_PROJ_TASKS_STD.WPROJ_ID
> ORDER BY dbo.MSP_TASKS.PROJ_ID, dbo.MSP_TASKS.TASK_ID

No comments:

Post a Comment