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)
 How to return more than one column value w/READTEX

Author  Topic 

erikkl2003
Starting Member

14 Posts

Posted - 2006-01-01 : 19:04:08
When using the readtext i would like to also select another column reather than the one from where the readetext is reading from the TEXTPTR....

Here is what i have...

Dim cmdReadBinary As New SqlCommand("READTEXT Categories.Picture @Pointer @Offset @Size HOLDLOCK",cnn)

and i would like to so this..

Dim cmdReadBinary As New SqlCommand("READTEXT Categories.Picture @Pointer @Offset @Size HOLDLOCK, ImgName ",cnn) <-I have added the ...ImgName... to this one.
I am tring to apend the file .ext to the end of the blob...

with the readtext can i not return more than one column?

erik..


If you wait untill tomorrow; you will have no future.
   

- Advertisement -