From: tamouse mailing lists <tamouse.lists@...>
Date: 2012-12-22T22:35:52+09:00
Subject: Re: Tinytds - Save binary as file

On Fri, Dec 21, 2012 at 11:42 AM, Miguel Mendes <lists@ruby-forum.com> wrote:
> Hello,
>
> I'm learning Ruby and I'm trying to save to disk some content that is in
> sql server in a column of type 'Image'.
>
> Problem is that the column with the content always have the same
> size(4096) whem I'm iterating through the results.
>
> My code so far:
>
> client = TinyTds::Client.new(:username => 'someuser', :password =>
> 'somepass', :dataserver => 'someserver', :database => 'somedb')
> result = client.execute("SELECT top 5 Content,DirName,LeafName FROM
> sometable where ListID='819B' AND Content is not null")
>
> result.each do |row|
>   directory_name =  File.join("d:" , row["DirName"])
>   FileUtils.mkdir_p(directory_name) unless File.exists?(directory_name)
>
>   filename = File.join(directory_name , row["LeafName"])
>
>   p row["Content"].length  # Always returns 4096...
>
>   File.open(filename, "w") do |myfile|
>       myfile.write(row["Content"])
>   end
> end
>
> --
> Posted via http://www.ruby-forum.com/.
>

Can you show the table schema?