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

["L. M. Lloyd" <ubik@austin.rr.com>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It is much easier to just store the URL to the image in the database,
and put in an SRC that calls the image from its directory based on
the URL supplied by the DB. I even do this with SQL Server and
Oracle. It keeps everything straightforward, and makes image
substitution and rework a lot easier. The only time it ever really
makes sense to keep the images in the database is if you are making a
web page of a preexisting standalone application that needs the
images native in the DB (like a catalog app). If you are just doing
for a web site and nothing else, then you will make things a lot less
stressful by storing the locations instead of the image.







The goal is to overcome the deliberate nature of the process. 

>  -----Original Message-----
> From: 	owner-scirocco-l@scirocco.org
> [mailto:owner-scirocco-l@scirocco.org]  Sent:	Wednesday, December
> 12, 2001 11:43 AM
> 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!  
> 

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>

iQA/AwUBPBecmQO3tw2TqB1hEQKT9ACeJOvlp7tjI9FjwYcU/kU35rCaENcAn2Yl
k2gEBh5D0bFzeYkUWGXIiA1U
=chQO
-----END PGP SIGNATURE-----


--
Email LIST problems to: scirocco-l-probs@scirocco.org.
To unsubscibe send "unsubscribe scirocco-l" in the message to majordomo@scirocco.org