用ASP开发WEB数据库（SQL Server）,如何管理图像信息？

[hjf]

1，字段属性为“image",但不可编辑；
2，如果以路径方式管理图像，如何查询，并在网页上显示？

我是个新手，敬请各位大侠不吝赐教。

[堆堆]

<% dim conn,re
set conn=server.CreateObject ("adodb.connection")
conn.open "dsn=xx" 'xx为自己的DSN名
set re=conn.execute("select xx from xxx") 'xx为字段属性为“image"的字段名，xxx为表名
if re.eof=false then
Response.BinaryWrite (re.Fields.Item(0).GetChunk (re.Fields.Item(0).ActualSize ))
re.close
end if
conn.close
set re=nothing
set conn=nothing
%>

[hnalbert]

1. How to get the picture from the input of the client side and how to write it into the corresponding field in the SQL Server table?(use Sql sentence only or use Active control?)
2. And how to show it to the client side when the client want to see it?

if somebody can give the answer in details (sample provided is the best) I will be very grateful!