[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[OT] Need some web designer guru's help!! (HTML,ASP)



Hi all,

Sorry to bother with that OT, but I lost two days to find out how to
do it and if someone on the list can help me out it will be very much
appreciated!

I simply want to display a web page in HTML that will show a jpeg
stored into an access database in OLE Object format!

I run Windows 2000 server with IIS 5.0, and I use office 2000 access to
create the database file.

So I do in the first file, let's name it first.asp, this line:

...
<img src="getpic.asp?selectNo=AR-CR164L">
...

In the getpic.asp here the content:
----------------------------begin---------------------------------
<%
Dim DB, RS

Set DB = Server.CreateObject("ADODB.Connection")
DB.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};" &
"DBQ=E:\Inetpub\wwwroot\Test\DB\mydb.mdb"
DB.open

Set RS = DB.execute("SELECT Picture FROM Pictures WHERE No ='" &
Request.Form("selectNo") & "';")

Response.ContentType = "image/jpeg"

Response.BinaryWrite RS("Picture")
%>
-------------------------------end------------------------------

I found that somewhere on the web, there is many little different ways to do
it, but
none of them seem to work...

I just read on Microsoft website that I need to create a DLL (with Visual
Basic that I
don't have) that will strips the OLE and Access headers to have only the raw
image
from the database, but doesn't tell me more then that, how to use it...


Well hope someone can help me out here ;)

Question: Is that matter calling an ASP page from an ASP page?

Thank you,
Joel

PS: To not bother everyones again, please contact me privately ;)
PPS: BTW, This will be use to create a website for VW parts :) at least!

winmail.dat