hi there
we are making a web site ,its datbase is developed at the site
in SQL Server.
The client had asked us to include picture with each Record as well.
now the problem is this that we dont  know the syntax of uploading/downloading the picture with the database record
Kindly someone guide me so that we can perform all data
operation on the pic add/edit/display etc)
Looking forward to an urgent reply
Regards
Ahmad

____________________________
@#@#@

http://www.andreavb.com/forum/viewtopic.php?TopicID=1517&page=0#5741

Although it's better to upload the picture to a directory.

____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)

thnx JL
i have read all the link and sublink  but there is another problem that we are facing which is  how to display that image in ASP
i think we have a picture control in VB that is used for pic display.what do we have in ASP to display the stored image from database ??
using html we can just display a static image but how can we get  display  like we hav nowadays in e.g hotmail profile !!


[Edited by ahmad on 06-09-2003 at 10:40 AM GMT]

____________________________
@#@#@

in the <IMG> tag into the ASP add to "src" statement the link to an ASP page that serves the image uploaded previous for ex:

<IMG src="showimg.asp?img=100">

when
showimg.asp -> the asp page that query via "SELECT blah... FROM balh WHERE IDblah = " & request.QueryString("img"),  
the image field matched from the table and got in the code the next line:

<% Response.ContentType = "image/gif" or "image/jpg"
Response.BinaryWrite rstResult("imgfield").value %>

this is a cheap example,  but is almost right. try with this way.  

____________________________
Aleks