Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-14 : 10:55:23
|
| Rajesh writes "How to retreive the image,I tried with Response.BinaryWrite for retreiving the image ,but I am getting the binary format only,not the image format so pls tell me how to retreive the image in the frame Thanks and RegardsRajesh.B" |
|
|
nizmaylo
Constraint Violating Yak Guru
258 Posts |
Posted - 2001-12-14 : 11:33:15
|
| You need to used ADODB.Sream to read text and images. Search forums for stream and you'll find an example for text. Check BOL for the properties of Stream and you'll figure out how to retrieve an image.helena |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-12-14 : 12:19:43
|
| You also might want to read articles on [url]http://www.4guysfromrolla.com[/url] on this topic where they have some examples. It's a bit more of a hassle than you might think.I would encourage you to reconsider whether you really need the images stored inside your SQL Server, or could just store the images on the web server and store the PATH in the SQL Server. Then, in your web page you just have<img src="<%=oRS.Fields("Path_Field")%>"> and you're all set (assuming oRS is your ADO recordset object into which you have retrieved the SQL data.-------------------It's a SQL thing... |
|
|
|
|
|
|
Store and retreive the images