How to insert images into SQL7 db?

Originally posted by : juna (janice@ippadvisors.com)how to do that? I'm trying to write ASP codes that would display an image out from db. but I can't seem to get the pic out instead the directory of the image is out.

Originally posted by : rockywell u never store the picture into the database...becuase the size of db is gonna be so large!!so just store the name of image and create separate folder where u store the images..and just give a path only!!cheers!rocky~~

Originally posted by : HeatherP (vge009@aol.com)------------Rocky is right! In your database you must have a column with the Images in it, Only the name of the image, and keep them in the same place as the database...However you choose, You might have to clean this up a bit, but this is a way to list any image that is stored ina database.When using the SQL statement, connect to the database, Dim strSQLstrSQL = "SELECT Image FROM tblYourImages ORDER BY Price DESC"'Create a recordset object instance, and execute the SQL StatementDim objRSSet objRS = Server.CreateObject("ADODB.Recordset")objRS.Open strSQL, objConnDo 'We are displaying the images ordered by price%>A Listing of Images: Image