Web Site (using PHP) gets error executing SQL Stored Procedure - odbc_fetch_array(): SQL error: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index, SQL state S1002 in SQLGetData
This is the Stored Procedure definition.
Placing the Text fields at the end of the SQL query. Used this article - http://forums.codeguru.com/showthread.php?127276-Invalid-Descriptor-Index%92&p=342672#post342672
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Alter Procedure [dbo].[XEVE_Note_Select]
-- values here passed by web page to stored proc
@EventID Int
As
Set NoCount On
SELECT NoteID, EventID, NoteType, WinUser, SolUser, Crtd_Datetime, Lupd_Datetime, NoteText
FROM XEVE_Notes
WHERE EventID = @EventID
ORDER BY NoteID
Set NoCount Off
No comments:
Post a Comment