Link to home
Start Free TrialLog in
Avatar of JRockFL
JRockFLFlag for United States of America

asked on

Stored Procedure Error - No more data available to read.

I just started using stored procedure with Cold Fusion. Sometimes, I get this error..
Error Executing Database Query.  
[Macromedia][SQLServer JDBC Driver]No more data available to read.

If I refresh the page, sometimes it will show the data, other times I get the error. What's causing this?

<cfstoredproc procedure="Display_Products" datasource="#request.datasource#" username="#request.username#" password="#request.password#">
<cfprocparam cfsqltype="cf_sql_integer" value="#category#">
<cfprocresult name="spProducts">
</cfstoredproc>

<table cellpadding="2" cellspacing="2" align="center">
<tr>
<cfoutput query="spProducts" startrow="#Variables.StartRow#" maxrows="#Variables.RecordsPerPage#">
<td valign="top">
<div align="center" class="buttions"> Click image for larger view<br>
<a href="/#categoryid#/#image#"><img src = "/#categoryid#/thumbnails/#image#" border="0"></a><br>
#product#<br>
<strong>#DollarFormat(price)#</strong></font></div>
<br><br>
</td>
<cfif spProducts.CurrentRow MOD 4 IS 0>
</tr>
<tr>
</cfif>
</cfoutput>
</tr>
</table>
ASKER CERTIFIED SOLUTION
Avatar of sigmacon
sigmacon

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of JRockFL

ASKER

Hey there. I tried the file you suggested. So far so good. I had read something similiar and replaced the same file with a different one but that didnt fix it.

The one I used previously was newer then the one you suggested. Hopefully it will continue to work.

Thank you.
Avatar of sigmacon
sigmacon

OK. just to clarify: Yes, the file I suggested is OLDER, and as such contains BUGS that the newer file was supposed to FIX. The forum article I linkted to earlier goes into detail about that. It's rare to encounter this bug in common scenarios. The OLDER file doesn't have the NEW BUG -the one the one that bugs you!
Avatar of JRockFL

ASKER

Cool! It has been working fine for me now with that older file. Thank you