Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: Retrieve file BLOB from SQL Server 'Image' field type

by Corion (Pope)
on Sep 24, 2015 at 05:45 UTC ( #1142867=note: print w/replies, xml ) Need Help??


in reply to Retrieve file BLOB from SQL Server 'Image' field type

select t.RDFILE from DB_NAME.schema.TABLE_NAME t where t.UNIQUEID = $uniqueId

Are you sure that the rows get returned in the order you want?

You will need an ORDER BY clause on something.

Replies are listed 'Best First'.
Re^2: Retrieve file BLOB from SQL Server 'Image' field type
by monkey_boy (Priest) on Sep 24, 2015 at 13:21 UTC
    The column names suggest a single row will be returned.


    This is not a Signature...
Re^2: Retrieve file BLOB from SQL Server 'Image' field type
by porg (Novice) on Sep 24, 2015 at 14:05 UTC
    Hi, thanks for the reply - this will only return one result, so I would assume the info is returned in the manner i should read it.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1142867]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (3)
As of 2021-06-22 02:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What does the "s" stand for in "perls"? (Whence perls)












    Results (100 votes). Check out past polls.

    Notices?