lo_export problem

[incoroneta]

Hi,

i'm trying to store a picture from the DB to the filesystem.
i've used the function lo_export like that:


res = conn.query("SELECT nome,physical_image FROM images;")

i=0
while(res!=nil)
conn.lo_export(res[1].to_i,'/home/andrea/senior/public/images/#{res[0]}.jpg')
i+=1

end


conn.close())

there're not errors, the script run...
The problem is that no files are created and i don't know why.
Can somebody help me??

thanks in advance...

 

[John Joyce]

Hi,

i'm trying to store a picture from the DB to the filesystem.
i've used the function lo_export like that:


res = conn.query("SELECT nome,physical_image FROM images;")

i=0
while(res!=nil)
conn.lo_export(res[1].to_i,'/home/andrea/senior/public/images/#
{res[0]}.jpg')
i+=1

end


conn.close())

there're not errors, the script run...
The problem is that no files are created and i don't know why.
Can somebody help me??

thanks in advance...

Check out the IO and File libraries.
ri File
ri IO
also, in Ruby it's a good idea to put spaces before and after
operators...
i += 1