Question

asp读取指定文件夹下所有图片名记录到sql数据库相应字段中？谢谢各位大虾，

字段：usecode；picturename
比如：usecode编号为123，picturename名称为123.jpg
在sql数据库中使新添加的图片名称和usecode编号（123）处在同一行中！

Answer 1

<%
'输出图片
j = 1
i = start
Set pp = New possible

Do While i < offset
thisPicPath = server.mappath("./" & fileArray(i))
If j > cEachLineMax Then
j = 1
response.Write "</tr><tr>"
End If
picturename = left(fileArray(i),len(fileArray(i)))-4)

sql="select * from [数据库名] where usecode ="&picturename
rs.open sql,conn,1,3
rs("picturename")=fileArray(i)
rs.update
rs.close
Loop

Set pp = Nothing
Set rs = Nothing
%>