How to design database using MS Access

Hi EE!

I don't know how explain exactly what my problem is, in regards to designing a database & to link it to my page (ASP).
Here it goes:
I have a structure like this:
STE Products
- Shower Unit
- Multi Point Unit
- Storage
... etc.

under Shower Unit
-- AQ Series
-- DD Series
-- DDC Series
... etc.

inside each series, it has many photos inside, such as:
(for AQ Series)
--- AQ 35 E.jpg
--- AQ 45 E.jpg

(for DD Series)
--- DD 35 E.jpg
--- DD 45 E.jpg
--- DD 60 E.jpg

... etc.

How can I do the design of it or what is the best design I can do for it.
I have a table named: STEProd, and the Field Names are ID (Auto#), Series, Photo, Link (Optional).
If I put the series for example AQ 35E under the series, and the path of its Photo, how can I link it to the web (ASP). Is it <img src="<%=rsSTEProd("Photo")%>"/>  ? But it'll show or run continuously until the end of the database. what i want is if it's for AQ Series, it will show the photos of AQ 35E & AQ 45E only. So if 1 series have many photos inside, it doesn't matter, the only thing is I want the photos by each series to be shown.

I have on my mind, to create a Table for each series. What do u think?

But I'm searching for other opinion or advise from EE.

Thank you & wait for EE's reply then....

stiebel
Stiebel EltronAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SaphiraCommented:
Well, I must admit I've understood exactly what you want but I'll try to help.
First of all let's see if I've understood the database structure. You have products, each product have one or more series and each serie has only one photo. If that's the structure... I think the best would be to have one table for the products (with the ID and NAME), and one for the series (PRODUCTID SERIEID PHOTO LINK)
Next, to show the photos, <img src=<%=rs("Photo")%>"/> is the right choice, but to get only the photos you want you have to write the corresponding sql statement. If you explain me exactly how you want to show the things I can make it for you.
0
Stiebel EltronAuthor Commented:
Thanks Saphira for your prompt response!

I have a tree-view menu. But I'll skip into some parts & jump into part where I stopped.
I have a structure like this:
STE Products
- Shower Unit
- Multi Point Unit
- Storage
... etc.

under Shower Unit
-- AQ Series
-- DD Series
-- DDC Series
... etc.

inside each series, it has many photos inside, such as:
(for AQ Series)
--- AQ 35 E.jpg
--- AQ 45 E.jpg

(for DD Series)
--- DD 35 E.jpg
--- DD 45 E.jpg
--- DD 60 E.jpg

... etc.

Each series have a minimum of 2 photos inside its folder. Other series have more than 2.

I want to show the image in another _blank page, in whereas the photos of that series only. So for example I click the AQ Series, only the photos of AQ Series will show. AQ 35E & AQ 45E.
What do u mean for the PRODUCTID? Is PHOTOLINK is the path where the photo is located?

Wait for your reply again soon...
Thanks!
0
SaphiraCommented:
Ok, now I understand
The ProducID is just an identificator, it can be just a sequential number like 1,2,3 etc. It's just because I preffer not to use text columns as keys, but that's my opinion, you can just use the name as the table key.
Next, knowing that one serie can have more than one photo, I would change a bit the structure..
PRODUCT (PRODUCTID, PRODUCTNAME)
SERIE (PRODUCTID, SERIEID, SERIENAME)
SERIE_PHOTOS (SERIEID, PHOTO, LINK)
The url to the photo is stored in the PHOTO column, and LINK... I just put it because you had it in the first post as optional but I don't know for what you need it :P

I've writed also the sql statement. Look at it and tell me if it's what you needed
SELECT P.PHOTO
FROM SERIE_PHOTOS AS P
INNER JOIN SERIE AS S ON S.SERIEID=P.SERIEID
INNER JOIN PRODUCT as PR ON PR.PRODUCTID=S.PRODUCTID
WHERE P.PRODUCTNAME='Shower Unit' AND S.SERIENAME='AQ Series'

Open in new window

0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Stiebel EltronAuthor Commented:
Hello there Saphira! To tell you straight, I'm really boggled on what you advised. I don't know where to start & what will be the next... :-(
I'm kinda confuse here... as u can see from my message ID 30005194, from the structure that I showed, the STEProducts doesn't have Shower Unit only, it has Multi Point Unit, Storage, etc.
So I'm thinking what if the selection would be from Multi Point or Storage or Heat Pump or etc.?
0
SaphiraCommented:
OK,

The SQL was just an example. Where I've put Showe Unit you could write any other Product and the same with the Serie. That sql just gets from a serie of a product all of its photos.

What I don't know is if you want to get the photos for more than one product or serie at the same time. if this is the case you would need a different sql.

Tell me where you get confused or what you need and I'll try to help.
0
Stiebel EltronAuthor Commented:
Hi Saphira!

I have created an idea on my mind already & attached are the codes:

The name of my table is Products.
I have columns ID, Series, iPhoto, SeriesID, Type, & Remarks.
The name of that page is ste-shower-AQ.asp (for test only, then will change the name later).

Then I have a page named: ste-shower.asp , and it has a links inside, something like this:
<a href='ste-shower-AQ.asp?SeriesID=1'>AQ Series</a>

That link should call the data from the other page (ste-shower-AQ.asp) that has attached database with table named Products.

The problem is, everytime I click the said link above, it shows this error:
The page cannot be displayed
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/iPhoto/ste-shower-AQ.asp, line 9

And line 9 is: Set rsProducts = myConnection.Execute(sqlContent)

What I want to happen is to show the content under SeriesID = 1. So if I have a link that the SeriesID = 2, it should show the content of that SeriesID.

But when I change the: "&SeriesID into '1'", it will show the data. But what if I have 200 or more data, I need to create 200 or more pages for it. I only want to design 1 page that will change the inside data bec. of SeriesID.
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>

Open in new window

0
SaphiraCommented:
In the DB, Seriesid what type is it?
The error I think is because the Seriesid you give and the one in the DB have different types.
Also try to write to the page the value of seriesid you get because it can be retrieving null or something like that.
0
Stiebel EltronAuthor Commented:
Hello to you again Saphira!

I changed the type of the SeriesID, from Text to Number.It worked! But the problem is, with the image, I have 2 images that I want to show. AQ 35 E.jpg & AQ 45 E.jpg
I have this code <img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>

It only show 1 image, the AQ 35 E.jpg. and the other image is not.

Could you please advise where is the problem?

Thanks in advance!
0
SaphiraCommented:
Well, one thing less :)

Are you writing the code inside a loop?


While not rsProduct.EOF
%>
  <img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
<%
  rs.MoveNext
Loop

Open in new window

0
Stiebel EltronAuthor Commented:
No it's not. It's not inside the loop. I tried your code, but it didn't work.
I'll attach my code.
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
..................
</head>
..................
<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+2"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
...........................
</html>

Open in new window

0
SaphiraCommented:
Ok, try this one.

I don't know if you want a  for each picture. In my code is done in that way. If you want all the pictures inside the same  just put the  before the DO while and the  afte Loop.
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
        Set myConnection = Server.CreateObject("ADODB.Connection")
        Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
..................
</head>
..................
<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
	<%
	Do While not rsProducts.EOF
	%>
	    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+2"> - <%=rsProducts("Remarks")%></font></b></a>
        </td>
	<%
		rsProducts.MoveNext
	Loop
	%>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
                <img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
...........................
</html>

Open in new window

0
Stiebel EltronAuthor Commented:
Got error:
Error Type:
ADODB.Field (0x80020009)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/iPhoto/ste-shower-units.asp
0
SaphiraCommented:
And this one?
The error is because it's trying to read data afte having reached last row.. but don't know why right now...
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
        Set myConnection = Server.CreateObject("ADODB.Connection")
        Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
..................
</head>
..................
<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
        <%
        Do Until rsProducts.EOF
        %>
            <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+2"> - <%=rsProducts("Remarks")%></font></b></a>
        </td>
        <%
                rsProducts.MoveNext
        Loop
        %>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
                <img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
...........................
</html>

Open in new window

0
Stiebel EltronAuthor Commented:
Still the same error:
Error Type:
ADODB.Field (0x80020009)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/iPhoto/ste-shower-units.asp
0
SaphiraCommented:
ohhhh I've seen the problem. Sorry, my mistake...
I left out of the while the las image so when it tried to read the column it gave error because we where after the last row...

Try with this one. (The appearence might not be what you want, but you can change it ;) )
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
        Set myConnection = Server.CreateObject("ADODB.Connection")
        Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
..................
</head>
..................
<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <%
	Do Until rsProducts.EOF
  %>
  <tr>
    <td>&nbsp;</td>
            <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+2"> - <%=rsProducts("Remarks")%></font></b></a>
        </td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
                <img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
	</td>
  </tr>
	<%
			rsProducts.MoveNext
	Loop
	%>
...........................
</html>

Open in new window

0
Stiebel EltronAuthor Commented:
I revised the code,  please see the attached code. But the result isn't arrange correctly.
Kindly check the attached image. And is it possible to have it close together & in 1 row should be 4 images, then next would be on the next row...
<td>&nbsp;</td>
    
    <% 
        Do Until rsProducts.EOF 
    %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
        
       
    <br /><br />
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a>

    <% 
                rsProducts.MoveNext 
        Loop 
    %> 
    <td>&nbsp;</td>

Open in new window

Error.jpg
0
SaphiraCommented:
I need a bit more of information...

What's this for?

    » &nbsp;STE Shower Units - - <%=rsProducts("Remarks")%>
       

and the images of the top which are?
Maybe it would be better if you paste all the code again...


Also a suggestion... don't use tables for the page design. Now css and divs is what it's used. But you choose :)
0
Stiebel EltronAuthor Commented:
What's this for?
<td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;STE Shower Units - <font face="verdana" size="+2"> - <%=rsProducts("Remarks")%></font>
        </td>
-- "IMG/imgfolder.gif' is just a small folder icon beside a series title, but it's not the main subject image that I want to show accordingly.
-- <%=rsProducts("Remarks")%> --> from my database, it represents as the Series of each model. Such as: STE Shower Units - AQ Series


<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <% 
        Do Until rsProducts.EOF 
    %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
        
       
    <br /><br />
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a>

    <% 
                rsProducts.MoveNext 
        Loop 
    %> 
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;
		
    </td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

0
SaphiraCommented:
Let's see if this one fits your requirements :)

If not, please attach and image of what is shown to see how to fix it
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
   <tr>   
<% 
dim i=0
Do Until rsProducts.EOF 
   end if
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>		
	</td>
	<td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;</td>
	<%
	if i>2 then
	%>
  </tr>
  <tr>
    <% 
		end if
		if i>2 then
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
%> 
    
  <tr>
	<td><a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font><a></td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

0
Stiebel EltronAuthor Commented:
Hello there Saphira!

I would like to apologize to you if I can't be able to respond to your response urgently. I'm out of the country right now for my vacation. I'm trying to remote my server so I can apply your advise, but the problem is i can't remote it. I think need to restart the server forcefully. This week, Thailand is on holiday, so no one is in our office, so I'll try to send message to my colleague by next week to help me restart it. However, if I can get chance this week, I'll let you know asap for the result.

Thanks!
0
Stiebel EltronAuthor Commented:
hello to you Saphira!

I'm back! And we can now continue to discuss this open thread again...
I tried your last advise, but still have error problem. Kindly check the attached image for the error result.

I'm just wonderin, you don't have "IF" in this part:
<%
dim i=0
Do Until rsProducts.EOF
   end if
%>

but you have "end if" already...

Thank you again & hope to hear from you again soon...

Error2.jpg
0
SaphiraCommented:
Oh, sorry for that :S

It's true, delete that first end if inside the loop and tell me if it works

Really sorry...
0
Stiebel EltronAuthor Commented:
Still the same error.
Another thing is, why does the number is color red?
I know that if it's red in color, it has error in result...

Please check...
0
SaphiraCommented:
You mean why the numbers are in red?
Well, that's only the way the editor writes numbers, nothing more. (at least it's what I've seen this far

And could you show me again a picture of the error it's giving you (like the one before), and also paste all the code please.

I know this would be faster if I could try it, but I can't right now...
0
Stiebel EltronAuthor Commented:
The error is the same error message as in ID: 32132001.

I'm attaching the whole code below...
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <% 
		dim i=0
			Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
  	</td>
	<td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;</td>
	<%
	if i>2 then
	%>
  </tr>
  <tr>
    <% 
		end if
		if i>2 then
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
%>
  </tr>
  <tr>
    <td>       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;
		
    </td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

0
SaphiraCommented:
Well, I don't see anything strange...

Try the code below and tell me, if error, in wich line does it say it is. Just copy the Error type segment
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <% 
	dim i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
  	</td>
	<td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
%>
  </tr>
  <tr>
    <td>       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;
		
    </td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

0
Stiebel EltronAuthor Commented:
I just copied the script above, like what you've said, there's no strange from that codes.
But, still the same error.

Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/iPhoto/ste-shower-units.asp, line 105, column 5

I just copy & paste the scripts above to my previous codes, but still the same error...
0
SaphiraCommented:
oh, ****
I know what's the problem (I think) and it's a stupid mistake that I usually make when I left asp for a long time...
Copy this code and I think it should work.

The problem is that in asp you cannot define a variable and assign a value in the same line, so
dim i=0 gives error
it should be
dim i
i=0

Sorry for that :S
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <% 
	dim i
        i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
  	</td>
	<td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
%>
  </tr>
  <tr>
    <td>       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;
		
    </td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

0
Stiebel EltronAuthor Commented:
Got error again, but different line.
Please see the attached image for the error result.

Thanks!
Error3.jpg
0
Stiebel EltronAuthor Commented:
Hello Saphira! Please ignore my previous response, with ID: 32331897
It worked, but the images are still scattered.
Kindly check out the attached image...
Error4.jpg
0
SaphiraCommented:
Hi again, sorry for the waiting.

Try this one, and if it's not what you want, tell me how you want it and we'll try to get it.


<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <% 
	dim i
    i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
  	</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
%>
  </tr>
  <tr>
    <td>       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;
		
    </td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

0
Stiebel EltronAuthor Commented:
Hello to you Saphira!

We're already near to what I want! Kindly check the image named Blank space. What I mean with that is is it possible not to have a space, a big space in the middle of it? What I want is something like at Error5 image.
But i just copy & paste 1 image to show u what I want to happen...
About 4 image in 1 row, until there are no more image from the database to show. 4 images in a row.
So there will be different images in a row.

Then I have another requirement with this page, not only showing them, will let u know later after we done with this page.

Hope to hear from  you again soon!
:-)
Error5.jpg
space-error5.jpg
0
SaphiraCommented:
Ok, I think this one should work...
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>    
    <% 
	dim i
    i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
  	</td>
	<%
		if i>3 then
	%>
  </tr>
  <tr>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
%>
  </tr>
  <tr>
    <td colspan="2">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;
		
    </td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td colspan="3" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

0
Stiebel EltronAuthor Commented:
It worked, Saphira! But I found a problem regarding the spacing, specially if its 2 images only. You can check the image attached named Space for 2 image.
But if its more than 2, if the images are 3 or more, it has no problem. Please check the another attached photo.

And what if I would like to add the NAME of each image below each image.

Another is, there'll be a login page for the users to download the original ZIPPED file of it. Because the images are only in Thumbnails & the original will be bigger & larger in size. And it's in CMYK format. But not all of users can download these images, that's why we need to have login page.
(Do I need to open a new thread for this login query or can continue with this thread?)
Then after that, it's done.

Hope to hear from you again soon!
:-)
Error6.jpg
correct.jpg
0
SaphiraCommented:
Hi,

About the login.. I think it would be better to open a new thread so other people can also help

I will check the code again to try to obtain what you want :)
0
Stiebel EltronAuthor Commented:
Ok. Will be waiting then... :-)
0
SaphiraCommented:
I don't know if this one will work, but let's try...

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>    
    <% 
	dim i
    i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
		<br/>
		<p><%=rsProducts("Remarks")%></p>
  	</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
	if i<>0 then
	   %>
	   <td colspan="<%=(4-i)%>">&nbsp;</td>
	   <%
	end if
%>
  </tr>
  <tr>
    <td colspan="2">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;
		
    </td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td colspan="3" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

0
Stiebel EltronAuthor Commented:
That's it! I just changed the COLUMN name so it'll show the name of each image.
Would it be possible to move 1 column to the right, all the images? Attached is the sample...

Thanks!
Move-img.jpg
0
SaphiraCommented:
Try this
Well, change again the column name :P
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr> 
	<td>&nbsp;</td>
    <% 
	dim i
    i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
		<br/>
		<p><%=rsProducts("Remarks")%></p>
  	</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
	<td>&nbsp;</td>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
	if i<>0 then
	   %>
	   <td colspan="<%=(4-i)%>">&nbsp;</td>
	   <%
	end if
%>
  </tr>
  <tr>
    <td colspan="2">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;
		
    </td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td colspan="3" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

0
Stiebel EltronAuthor Commented:
Hello to you again Saphira!

The result, still the same. Didn't move 1 column to the right.
And like what I asked you earlier, the if the images are only 2, there's a space between them, but if its 3 or more, no problem.

Please check... Thanks!
0
SaphiraCommented:
Mmm, I thought it'll move...
Let's try again...

And if it doesn't work maybe it would be faster if you try also :)
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr> 
	<td>&nbsp;</td>
	<td>&nbsp;</td>
    <% 
	dim i
    i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
		<br/>
		<p><%=rsProducts("Remarks")%></p>
  	</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
	<td>&nbsp;</td>
	<td>&nbsp;</td>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
	if i<>0 then
	   %>
	   <td colspan="<%=(6-i)%>">&nbsp;</td>
	   <%
	end if
%>
  </tr>
  <tr>
    <td colspan="2">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;
		
    </td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td colspan="3" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

0
Stiebel EltronAuthor Commented:
I think the previous design is better, just move 1 column to the right.
Because the new code that you advise, moves just a little & the link below isn't ok, it doubles the line. So I return back to the previous codes that you advise...
0
SaphiraCommented:
Could you show some images of the codes, the last and the previous one please?
0
Stiebel EltronAuthor Commented:
Please see the attached files for the comparison of the previous codes with the latest codes.
previous-code1.jpg
previous-code2.jpg
latest-code-01.jpg
latest-code-02.jpg
0
SaphiraCommented:
Let's try if this one works better
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr> 
	<td width="134">&nbsp;</td>
    <% 
	dim i
    i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
		<br/>
		<p><%=rsProducts("Remarks")%></p>
  	</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
	<td>&nbsp;</td>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
	if i<>0 then
	   %>
	   <td colspan="<%=(4-i)%>">&nbsp;</td>
	   <%
	end if
%>
  </tr>
  <tr>
	<td width="134">&nbsp;</td>
    <td colspan="4">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>		
  </tr>
   <tr>
    <td width="134">&nbsp;</td>
    <td colspan="4" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

0
Stiebel EltronAuthor Commented:
Please see the attached images for the result of 2 images, 3 images, & more than 3 images.
If it's more than 3 images, kindly check the attached picture for the result of it...

Kindly check the img named Alignment, for you to see what alignment I require...

Thanks again for the support! We're almost near :-)

Then I need to open a new thread for the link & login right?
2-img.jpg
3-img.jpg
alignment.jpg
more-than-3img.jpg
0
SaphiraCommented:
Could you tell me the width of the image logo_res.jpg?

And I would preffer if you opened a new thread for the other question :)
0
Stiebel EltronAuthor Commented:
Log_res.jpg size: W = 200px; H = 223px
0
SaphiraCommented:
And this one?
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr> 
	<td width="200">&nbsp;</td>
    <% 
	dim i
    i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
		<br/>
		<p><%=rsProducts("Remarks")%></p>
  	</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
	if i<>0 then
	   %>
	   <td colspan="<%=(4-i)%>">&nbsp;</td>
	   <%
	end if
%>
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    <td colspan="4">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>		
  </tr>
   <tr>
    <td width="200">&nbsp;</td>
    <td colspan="4" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

0
Stiebel EltronAuthor Commented:
2 images, are fit correctly. But for 3 or more images, still the same.
0
SaphiraCommented:
So with 2 images shows ok but with 3 or more not? Still too to the left?
Strange...

Image please?
0
Stiebel EltronAuthor Commented:
Please see the attached files.
2-img.jpg
3-img.jpg
more-than-3img.jpg
0
SaphiraCommented:
Try this one. If this down't work I'd need more time to check it...
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr> 
	<td width="200">&nbsp;</td>
    <% 
	dim i
    i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
		<br/>
		<p><%=rsProducts("Remarks")%></p>
  	</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
	if i<>0 then
	   %>
	   <td colspan="<%=(3-i)%>">&nbsp;</td>
	   <%
	end if
%>
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    <td colspan="4">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>		
  </tr>
   <tr>
    <td width="200">&nbsp;</td>
    <td colspan="4" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

0
Stiebel EltronAuthor Commented:
Still the same... no changes...
0
SaphiraCommented:
Could you send me the code that is being generated?
I'm a bit confused... :S
0
Stiebel EltronAuthor Commented:
What do u mean? I just used your advised code from ID: 32651197
0
SaphiraCommented:
I mean the html code that's generated when the asp page is executed.
Click with the right button and then show code or something like that.
0
Stiebel EltronAuthor Commented:
Please see the attached generated html code.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
 
<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
 
<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">
 
<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css"> 
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;
 
	}
 
	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}
 
	.b
	{
		font-color:#0A0EB7;
	}		
 
-->
</STYLE>
 
<!--date-->
<SCRIPT LANGUAGE="JavaScript"> 
 
<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>
 
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
 
 
</head>
 
<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - DD Series</font></b></a>
	</td>
 
  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr> 
	<td width="200">&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DD/DD 35 E.jpg" alt="DD Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DD Series</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DD/DD 45 E.jpg" alt="DD Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DD Series</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DD/DD 60 E.jpg" alt="DD Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DD Series</p>
  	</td>
	
	   <td colspan="0">&nbsp;</td>
	   
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    <td colspan="4">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>		
  </tr>
   <tr>
    <td width="200">&nbsp;</td>
    <td colspan="4" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

0
SaphiraCommented:
I'm starting to get reaaaaally lost....
Try this...
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr> 
	<td width="200">&nbsp;</td>
    <% 
	dim i
    i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
		<br/>
		<p><%=rsProducts("Remarks")%></p>
  	</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
	if i<>0 and (4-i)<>0 then
	   %>
	   <td colspan="<%=(4-i)%>">&nbsp;</td>
	   <%
	end if
%>
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    <td colspan="4">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>		
  </tr>
   <tr>
    <td width="200">&nbsp;</td>
    <td colspan="4" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

0
Stiebel EltronAuthor Commented:
Still the same...
2 images are fine, 3 images, little fine, but 4 or more images, are still not aligned.
0
SaphiraCommented:
generated HTML code please?

Also, have you tried changing it someway? Just wanted to know to not try the same ones...
0
Stiebel EltronAuthor Commented:
Here are the generated HTML codes:

I haven't tried to change it, because I'm searching where do u change the spaces... I couldn't find it...
 
 
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
 
<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
 
<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">
 
<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css"> 
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;
 
	}
 
	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}
 
	.b
	{
		font-color:#0A0EB7;
	}		
 
-->
</STYLE>
 
<!--date-->
<SCRIPT LANGUAGE="JavaScript"> 
 
<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>
 
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
 
 
</head>
 
<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - DJC Series</font></b></a>
	</td>
 
  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr> 
	<td width="200">&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 25 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 25E</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 35 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 35E</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 45 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 45E</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 55 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 55E</p>
  	</td>
	
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 60 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 60E</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 65 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 65E</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 70 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 70E</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 75 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 75E</p>
  	</td>
	
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 80 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 80E</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 85 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 85E</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 25.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 25</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 35.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 35</p>
  	</td>
	
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 45.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 45</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 55.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 55</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 60.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 60</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 65.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 65</p>
  	</td>
	
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 70.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 70</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 75.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 75</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 80.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 80</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 85.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 85</p>
  	</td>
	
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    <td colspan="4">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>		
  </tr>
   <tr>
    <td width="200">&nbsp;</td>
    <td colspan="4" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

0
SaphiraCommented:
I think I've seen the problem...
Try this code.
Also check the image I've uploaded. As you can see the elements align ok without the images, so I think the problem is with the table size. Now probably the images will go too far to the right, but that'll be because the picture's size.

If not tell me.
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
</table>
<table width="100%" border="0" cellspacing="3" cellpadding="1">
  <tr> 
	<td width="200">&nbsp;</td>
    <% 
	dim i
    i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
		<br/>
		<p><%=rsProducts("Remarks")%></p>
  	</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
	if i<>0 and (4-i)<>0 then
	   %>
	   <td colspan="<%=(4-i)%>">&nbsp;</td>
	   <%
	end if
%>
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    <td colspan="4">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>		
  </tr>
   <tr>
    <td width="200">&nbsp;</td>
    <td colspan="4" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

1.png
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Stiebel EltronAuthor Commented:
It's ok! Work! :-)

So for my next query, I must open a new thread for it, right? Regarding login issue...
0
SaphiraCommented:
Yes, please.
This way other people can also help :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.