I tried to get results via view. But getting error.

Discussion in 'C#' started by Phantasm, Aug 22, 2010.

0
  1. #1
    I tried to get results via view. But getting error.


    Microsoft OLE DB Provider for SQL Server error '80040e14'

The request for procedure 'view_awaiting_confirmation_details' failed because 'view_awaiting_confirmation_details' is a view object.

/_manage.asp, line 56
    Code (markup):
    line 56: Rs.Open mySQL, Con, adOpenStatic, adLockReadOnly, adCmdText

    mySQL = "view_awaiting_confirmation_details"
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.Open mySQL, Con, adOpenStatic, adLockReadOnly, adCmdText
	If Not Rs.EOF Then
	Rs.MoveFirst
	Rs.PageSize = NumPerPage
	TotalPages = Rs.PageCount
	Rs.AbsolutePage = 1
	End If
    PHP:

    View:

    SELECT     dbo.tbl_User.NickName, dbo.tbl_UserStatistic.CurrentEntryCount, dbo.tbl_UserStatistic.DeletedEntryCount, dbo.tbl_User.UID
FROM         dbo.tbl_User INNER JOIN
                      dbo.tbl_UserStatistic ON dbo.tbl_User.UID = dbo.tbl_UserStatistic.UID
WHERE     (dbo.tbl_UserStatistic.CurrentEntryCount > 9)
    Code (markup):
     
    Phantasm, Aug 22, 2010 IP
  2. camjohnson95

    camjohnson95 Active Member

    Messages:
    737
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    60
    #2
    just set the variable mySql to the actual SQL:
    
mySql = "SELECT dbo.tbl_User.NickName, dbo.tbl_UserStatistic.CurrentEntryCount, dbo.tbl_UserStatistic.DeletedEntryCount, dbo.tbl_User.UID" & _
"FROM dbo.tbl_User INNER JOIN" & _ 
"dbo.tbl_UserStatistic ON dbo.tbl_User.UID = dbo.tbl_UserStatistic.UID" & _
"WHERE (dbo.tbl_UserStatistic.CurrentEntryCount > 9)"
    Code (markup):
     
    camjohnson95, Aug 23, 2010 IP