class TestIbmDb2 < Test::Unit::TestCase
def test_042
assert_expect {
conn = DB2::connect db,username,password
#_GET['EMPNO'] = '000130'
if isset(_GET['EMPNO'])
result = DB2::exec conn, "select photo_format, picture, length(picture) from emp_photo where photo_format='gif' and empno='" + _GET['EMPNO'] + "'"
row = DB2::fetch_array result
if row
# We'll be outputting a
header('Content-type: image/' + row[0])
header('Content-Length: ' + row[2])
print row[1]
else
print DB2::error()
end
next
else
result = DB2::exec conn, "select EMPNO, PHOTO_FORMAT from emp_photo where photo_format='gif'"
while (row = DB2::fetch_array(result))
printf("%s (%s)
",row[0], row[0], row[1])
puts ""
end
end
}
end
end
__END__
000130 (gif)
000140 (gif)
000150 (gif)
000190 (gif)