Hey,
while Implementing stored procedures to increase the performance on
ColdFusion 5 I encountered following problems:
1.
<cfquery name="projects" DATASOURCE=#application.db#>
{CALL SP_PROJECTS_SLAVA('#form.project#', '#form.region#')}
</cfquery>
returns:
Sybase Error Code = 102
Incorrect syntax near '{'.
SQL = "{ CALL SP_PROJECTS_SLAVA('All', 'EAP') }"
the same without '{' and variotions with exec, and other syntax results:
SQL operation unrecognized
The SQL operation you specified is unrecognized (only SELECT, INSERT,
UPDATE, DELETE, and CALL are supported).
SQL = 'call SP_PROJECTS_SLAVA('All', 'EAP')'
Data Source = "TEST"
2. This one is also executed with error:
<cfstoredproc procedure = "SP_PROJECTS_SLAVA" dataSource
= "#application.db#">
<cfprocparam type = "IN" cfsqltype="CF_SQL_VARCHAR" dbVarName
= "@Project" value = "#form.Project#">
<cfprocparam type = "IN" cfsqltype="CF_SQL_VARCHAR" dbVarName = "@Region"
value = "#form.region#" >
<CFProcResult Name="projects">
</cfstoredproc>
returns:
Sybase Error Code = 2812
Stored procedure 'SP_PROJECTS_SLAVA' not found. Specify owner.objectname
or use sp_help to check whether the object exists (sp_help may produce
lots of output).
SQL = "SP_PROJECTS_SLAVA"
The stored procedure is there and all privileges are assigned correctly.
The server is Sybase. Everything works brilliant on ColdFusion 4 setup.
Can anybody please help?
Cheers,
SL
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
