Edd
|
| Posted: 08/12/2002, 12:42 AM |
|
I have a MS-SQL Stored Procedure which I have been quite happliy using with ASP, 5 parameters in and 7 Columns Out.
When I use the CCS Stored Procedure Datasource it crashes CodeCharge Studio when I press the retrieve data button in desigh mode.
Is there something special about specifying OUTPUT parameters in Codecharge Studio? I have tried this with MS-SQL and had a horrible time trying to do it.
Any help would be greatly appreciated otherwise I will have to just code it by longhand is ASP.
Version of Codecharge Studio - 1.06 and MS-SQL 7.0.
Edd
|
|
|
 |
Edd
|
| Posted: 08/12/2002, 1:04 AM |
|
Answered my own problem:
1. Issue seems to lie in input parameters - for the default (for testing) in a character field I put in 'AA' instead of plain AA (no quotes). This causes a bit of a fuss.
2. Switched from an ODBC connection to OLE DB - also a lot more stable with stored procedures.
Hope this helps the next person who falls in this trap.
On another point why won't CCS let you select a stored procedure OR build your own SQL when you are initially building a GRID - It is a real pain in the ****.
Edd
|
|
|
|
Tom
|
| Posted: 08/13/2002, 5:40 AM |
|
Edd,
You can use BuildQuery button to open Query Builder and create sql query
|
|
|
|
Tom
|
| Posted: 08/13/2002, 5:40 AM |
|
Edd,
You can use BuildQuery button to open Query Builder and create sql query
|
|
|
|
Tom
|
| Posted: 08/13/2002, 5:40 AM |
|
Edd,
You can use BuildQuery button to open Query Builder and create sql query
|
|
|
|
