Thanks four your response.
It is the probem that I save only image name but Orbit Front software save the image name at the access databse like this
$(ROOTDIR)/CONTRACT/IMAGENAME.TIF
I try you coding but it is not run.
I required happer link on the image file, and run the asp file on explorer.
Please correct my following asp coding.
<html>
<HEAD>
</HEAD>
<BODY>
<form method=post action=wpls.asp id=form name=form>
<%
set cn=server.CreateObject("adodb.connection")
cn.ConnectionString="Provider=SQLOLEDB.1;Integrate d Security=SSPI;Persist Security Info=False;Initial Catalog=dcil;Data Source=AUHTRIPSVR2"
cn.Open
contractno=Request.QueryString("contractno")
contractno=Request.Form("contractno")
recordid=Request.Form("recordid")
ssql="SELECT * FROM archive2 where contractno='" &contractno & "'"
'Record Set
set rs=cn.Execute(ssql)
%>
<TABLE border=1 bordercolorlight="#669999" bordercolordark="#330066">
<tr bgcolor=gold>
<th>Contract No</th>
<th>Record Drawing No</th>
<th>Drawing No</th>
<th>ImageReference</th>
</tr>
<%
do while rs=false then
Response.Write("<tr>")
Response.Write("<td bgcolor=lightyellow>" & rs("contractno") & "</td>")
Response.Write("<td>" & rs("recordno") & "</td>")
Response.Write("<td>" & rs("drawingno") & "</td>")
Response.Write("<td>")
Response.Write("<a href=" & server.URLEncode(rs("imagereference")) & ">" & rs("imagereference") & "</a>")
Response.Write("</td>")
Response.Write("<tr>")
rs.movenext
loop
%>
</TABLE>
<INPUT id=submit2 name=submit2 type=submit value="Back" target=Right>
</P>
</BODY>
</HTML>
</body>
regards.
Mateen Martin
[email protected]
Quote:
quote:Originally posted by NotNowJohn
If you saved image names only in the database you can simply display:
images_dir="images/" 'directory contains the images
Response.Write "<table>"
While Not rs.EOF
image_URL=images_dir & rs("imagename")
Response.Write "<tr>"
Response.Write "<td><img src=" & image_URL & "></td>"
Response.Write "</tr>"
rs.MoveNext
Wend
Response.Write "<table>"
...but the Soon is eclipsed by the Moon
|
image display problem please help
