I have a products table and I want to create a button that points to some images jpg. for each product. I dont want to store the images in SQL Server, I want to use a file system. I do I call these images through code in ASP?

You should store the image name in the database. Then just write out an image tag to the HTML with the value from the database as the "src" attribute value.

Remember that you don't want to store the literal path to the local file, because the browser can only see relative paths related to the application URL. So if you store your images in c:\inetpub\wwwroot\myWebApp\images and the ASP page is c:\inetpub\wwwroot\myWebApp\products.asp then the image tag should end up looking like this: <img src="images/<image filename from database>">.

Peter
------------------------------------------------------
Work smarter, not harder.

Thanks a lot this is just what I was looking for. One more question, can you send me some code on how I would call this from a button.

Well... I'm not sure what you mean by "call from a button". This is something you do on the page.

You said in the first post "I want to create a button that points to some images", but this in itself doesn't really make sense. What do you want this button to do? Open a new window with the image in it?

Peter
------------------------------------------------------
Work smarter, not harder.

Sorry for the confusion planoie. Yes, I have an ASP page that list all the products. I have a column that will store the jpg file name like you described, I want to create a button that will pop up another window with the corresponding image jpg.

For a new window, you can use javascript on the button click handler:

<input type="button" onClick="window.open(...);">

In window.open() you provide a window name, the destination URL and an optional list of options that set the various window properties of the new browser window.

The URL for the new window can simply be the URL to the image. You don't even need a page to show it in, just the image itself.

Peter
------------------------------------------------------
Work smarter, not harder.

Thanks dude!
You know Im an ASP Novie. I'm originally a DBA here, but I'm learning new things like ASP programming.

in the windows.open how do I insert a variable (URL) can it be the field name in my database where I store the jpg names? You also said I shouldnt store the url name in the column just the name of the file, will this change now? Lets say my column name is "images" should I pass this into windows.open() using a variable?

<input type="button" onClick="window.open(...);">

You button HTML should end up looking like this...


<input type="button" onClick="window.open('imageView','images/<%=imageFileNameFromDB%>');">

You don't need to change what you are storing, still just store the image name.

Here is what I'm using and it gives me an error "Not Valid"


<input type="button" value="Image" class="boton120" name="Image" language="javascript" id="Image" onClick="window.open('imageView','LPimages/<%=rsLPMae.Fields("Ps_ImageUrl")%>');">

I even hardcoded the complete path to the file /LPImages/BeerSaloon1.jpg and it still gave me the same error.

What do you actually get for the URL in the new window?

Is "Not valid" a code error or a browser error?