asp读取指定文件夹下所有图片名记录到sql数据库相应字段中?谢谢各位大虾,
字段:usecode;picturename比如:usecode编号为123,picturename名称为123.jpg在sql数据库中使新添加的图片名称和usecode...
字段:usecode;picturename
比如:usecode编号为123,picturename名称为123.jpg
在sql数据库中使新添加的图片名称和usecode编号(123)处在同一行中! 展开
比如:usecode编号为123,picturename名称为123.jpg
在sql数据库中使新添加的图片名称和usecode编号(123)处在同一行中! 展开
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
%>
'输出图片
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
%>
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询