Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Blastrix
Posting Yak Master
208 Posts |
 Posted - 2001-03-30 : 21:06:00
|
| Okay, so I finally get my stored procedure to work, and everything works fine for displaying the bulk of the information. Now I wanted to display the total number of ads and find out if there was another page worth. Unfortunately my ASP page returns the error:Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was donewhen I try to stick the adText field into a variable. Now I know that you can have problems if you try to call the field multiple times, that's why I put it into a variable first. It works fine like that, but if I try to get 'nextPage' or totalAds' then it bombs when it gets to the the 'adText' field. If I call those two after I stuff 'adText' into a variable, then they work fine. The only problem is that I need ot call them before I get to the first 'adText' because once I get there, then I'm inside a loop displaying the data. Any ideas here people? |
|
|
|
|
|
What is it with these 'text' fields?!