Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Stored Procedure Error - No more data available to read.

Posted on 2004-10-23
4
Medium Priority
?
1,007 Views
Last Modified: 2013-12-24
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>
0
Comment
Question by:JRockFL
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 8

Accepted Solution

by:
sigmacon earned 200 total points
ID: 12390897
I know that just posting a link might not help, but what you describe sounds like a recent driver issue discussed here:

http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=6&threadid=684306

Make sure this is the problem you have, and then download the reverse-to-6.0-update:

http://download.macromedia.com/pub/coldfusion/drivers/3.1/cfmx60_u3.zip

unzip it and find

macromedia_drivers.jar

then replace that file in you CFMX installation in the /lib folder

MAKE A COPY OF THE OLD FILE FIRST SO YOU CAN GO BACK IF NEED BE.
0
 
LVL 8

Author Comment

by:JRockFL
ID: 12392784
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.
0
 
LVL 8

Expert Comment

by:sigmacon
ID: 12394315
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!
0
 
LVL 8

Author Comment

by:JRockFL
ID: 12400718
Cool! It has been working fine for me now with that older file. Thank you
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A web service (http://en.wikipedia.org/wiki/Web_service) is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question