DS
|
| Posted: 06/27/2003, 5:15 AM |
|
I'm trying to use a stored procedure to fill a grid. I can correctly get the control sources from the SP but when I publish the document I get the following error message:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Line 1: Incorrect syntax near ','.
/br_test/Classes.asp, line 2284
This is an auto generated file. This error occurs only when I try to use a stored procedure. Everything is ok when using a table or SQL statement.
Any idea about how to solve the problem ?
|
|
|
 |
Matt Lemon
|
| Posted: 07/24/2003, 12:34 AM |
|
I get a very similar message when calling an SP in SQL7 via an ASP page.
Anyone have a solution ?
|
|
|
|
Tom
|
| Posted: 07/26/2003, 2:38 PM |
|
What is data type is your sp returning? I think it needs to return a ref cursor.
|
|
|
|
|
