READTEXT weirdness - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

READTEXT weirdness

Author

Topic

Sage
Starting Member

1 Post

Posted - 2004-02-18 : 03:55:15

Hello,

I have a bit of T-SQL that works fine in one file, but copied and pasted
into another, it gives this error:

error '80020009'
Exception occurred.

/III/administration/data_edit/edit_staff_enter.asp, line 162

Can anyone think of a reason that this could happen?

The T-SQL in question is:

if gStaff(24)<>empty then
getPTRSQL="DECLARE @ptrval varbinary(16) SELECT @ptrval =
TEXTPTR(resint) FROM staff_extra WHERE staffID=" & gStaff(0) & " READTEXT
staff_extra.resint @ptrval 0 0"
set getPTR = cnnIII.Execute(getPTRSQL)
if getPTR(0)<>empty then
value2=getPTR(0)
response.write(value2)
else
response.write("none")
end if
end if

I've put the pages up temporarily in an accessible location as text files so that you can read the code. The readtext bit works in
staff_full_display.asp (http://suzy.theshipmans.co.uk/staff_full_display.txt) but not in edit_staff_enter.asp (http://suzy.theshipmans.co.uk/edit_staff_enter.txt).

I've looked and looked but I can't see what's causing it - hope it's really
obvious to someone with fresh eyes!! :-)

Thanks very much.

Suzy

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2004-02-18 : 05:04:10

I've had a similar problem before (error '80020009' Exception occurred.) I was using data types of blobs - is that the case here?
I read up on msdn about this error. They recomended something like have the blob fields returned last in the sql statement.

Maybe this helps.

Duane

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2004-02-18 : 06:03:54

I found on MSDN the workaround for the exact error you pointed out.
You'll have to read it up yourself(I dont think I'm allowed to quote this material here).

If you have msdn 2002 apr then this is exactly where you should go
ms-help://MS.MSDNQTR.2002APR.1033/kbvstud/Source/vstudio/q234205.htm
Else just search for error '80020009' on the msdn website.
The topic name I found it under was: PRB: File '(unknown)' , Exception Occurred, or No Data Using Recordset DTCs

Regards,
Duane

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources