Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 7th, 2003, 02:00 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: abu dbabi, , United Arab Emirates.
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default image display problem please help

Hi everyone!

I am facing problem 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 required happer link on the image file, and run the asp file on explorer.

Please correct my following asp coding which is not display the image.
how I can display the image.

<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>

How I can display the image at above image name.

regards.

Mateen Martin
mateenmohd@hotmail.com




Similar Threads
Thread Thread Starter Forum Replies Last Post
Image Display problem ratheesh_param ASP.NET 1.0 and 1.1 Professional 2 November 27th, 2006 01:02 AM
Image Display Problem ratheesh_param ASP.NET 2.0 Professional 0 November 22nd, 2006 03:24 AM
Image Display Problem ratheesh_param ASP.NET 1.x and 2.0 Application Design 0 November 22nd, 2006 03:02 AM
image display problem please help mateenmohd Classic ASP Databases 2 June 7th, 2003 01:07 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.