annoying ASP error [Archive]

mattalexx

04-13-02, 22:21

I am running into an error with an ASP file:
http://www.mattalexx.com/scoville/newbooksshow.asp

Here's the script:
http://www.mattalexx.com/asperror.zip

Here's the MS documentation of the error:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q175239

MS says I need to order my SQL statements so that BLOB fields (text, memo, image) are called last. I have done this, and the error keeps coming up.

What's going on?

JonathanB

04-14-02, 18:21

Hmm... to be honest I've never had to worry in what order I call blob fields in my sql statements. Although I can't see that this is what is causing the error as it appears to work fine on the previous record. What type of blob field are you using??