Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

<cfstoredproc> tag doesn't work properly

Status
Not open for further replies.

Imeshev

Programmer
Joined
May 24, 2000
Messages
1
Location
US
Hi All,<br><br>I'm calling Centura SQLBase stored procedure via ODBC as<br><br><b>&lt;CFSET nExists = 0&gt;<br><br>&lt;CFSTOREDPROC PROCEDURE=&quot;inet_check&quot; DATASOURCE=&quot;LSRSII&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&lt;CFPROCPARAM TYPE=&quot;IN&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CFSQLTYPE=&quot;CF_SQL_INTEGER&quot; VALUE=&quot;102&quot; NULL=&quot;NO&quot;&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&lt;CFPROCPARAM TYPE=&quot;OUT&quot; SQLTYPE=&quot;CF_SQL_DOUBLE&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VARIABLE=&quot;nExists&quot; NULL=&quot;NO&quot;&gt; <br>&lt;/CFSTOREDPROC&gt; <br></b><br><br>and ODBC returns S1000 error (general error), CF tells &quot;invalid parameter TYPE&quot;. Changing the OUT parameter to INOUT helps, but value isn't returned, and earlyer initialized nExists is getting blank instead having returned from sp value. <br><br>I'll be just grateful for any help. Moving all the logic from SPs wold real pain.<br><br>Slava
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top