JRockFL
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_Product s" datasource="#request.datas ource#" username="#request.usernam e#" password="#request.passwor d#">
<cfprocparam cfsqltype="cf_sql_integer" value="#category#">
<cfprocresult name="spProducts">
</cfstoredproc>
<table cellpadding="2" cellspacing="2" align="center">
<tr>
<cfoutput query="spProducts" startrow="#Variables.Start Row#" maxrows="#Variables.Record sPerPage#" >
<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(pric e)#</stron g></font>< /div>
<br><br>
</td>
<cfif spProducts.CurrentRow MOD 4 IS 0>
</tr>
<tr>
</cfif>
</cfoutput>
</tr>
</table>
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_Product
<cfprocparam cfsqltype="cf_sql_integer"
<cfprocresult name="spProducts">
</cfstoredproc>
<table cellpadding="2" cellspacing="2" align="center">
<tr>
<cfoutput query="spProducts" startrow="#Variables.Start
<td valign="top">
<div align="center" class="buttions"> Click image for larger view<br>
<a href="/#categoryid#/#image
#product#<br>
<strong>#DollarFormat(pric
<br><br>
</td>
<cfif spProducts.CurrentRow MOD 4 IS 0>
</tr>
<tr>
</cfif>
</cfoutput>
</tr>
</table>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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!
ASKER
Cool! It has been working fine for me now with that older file. Thank you
ASKER
The one I used previously was newer then the one you suggested. Hopefully it will continue to work.
Thank you.