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

["J.L." <tofunit@yahoo.com>]

BTW my email is tofunit@yahoo.com

seem like my email doesn't show up? Why!!? I can't figured out!

Joel

>  -----Original Message-----
> From: 	owner-scirocco-l@scirocco.org
> [mailto:owner-scirocco-l@scirocco.org] 
> Sent:	Wednesday, December 12, 2001 12:43 PM
> To:	Scirocco list
> Subject:	[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