images rows - ASP Free

ASP Free Forums Sponsor:

November 3rd, 2005, 01:19 PM

djfubar

Contributing User

Join Date: Dec 2004

Posts: 414

Time spent in forums: 5 Days 1 h 28 m 49 sec
Reputation Power: 6

images rows

hi there, i have a asp page which loads up several pictures. the problem being is that they are being displayed in a vetical list.

how can i get to display the images in horizontal rows of say 3?

any help would be great

November 3rd, 2005, 01:28 PM

mehere

Senior Sarcasm Wizardess

Join Date: Feb 2005

Location: Dreamland

Posts: 12,789

Folding Points: 10976 Folding Title: Novice Folder

Time spent in forums: 4 Months 3 Weeks 6 Days 22 h 25 m 4 sec
Reputation Power: 1567

post your code for the displaying of the images ...

__________________
Come JOIN the party!!!

Quote of the Month:
Sacrifice (Temple): All we ask here is that you give us your heart.

Questions to Ponder:
If the #2 pencil is the most popular, why is it still #2?

iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm")
copyright© 2008 sbenj69

November 3rd, 2005, 01:56 PM

djfubar

Contributing User

Join Date: Dec 2004

Posts: 414

Time spent in forums: 5 Days 1 h 28 m 49 sec
Reputation Power: 6

Code:

<% IF prodRS( "product_picture" ) <> "?????" THEN %>
 <IMG SRC="<%=prodRS( "product_picture" )%>"
  <% END IF %>

November 3rd, 2005, 02:36 PM

mehere

Senior Sarcasm Wizardess

Join Date: Feb 2005

Location: Dreamland

Posts: 12,789

Time spent in forums: 4 Months 3 Weeks 6 Days 22 h 25 m 4 sec
Reputation Power: 1567

could you post everything from the 'do while' to the 'loop' at least .... it will be easier to show you how to display 3 across before moving to the next line.

November 3rd, 2005, 03:00 PM

djfubar

Contributing User

Join Date: Dec 2004

Posts: 414

Time spent in forums: 5 Days 1 h 28 m 49 sec
Reputation Power: 6

heres the full script

Code:

<!-- #include file = "Default.asp" -->
<%




'Get the Current Page
pg = TRIM( Request( "pg" ))
if pg = "" THEN pg = 1


'Open Recordset


Set prodRS = Server.CreateObject( "ADODB.recordset" )
prodRS.ActiveConnection = Conn
prodRS.CursorType = 3 'adOpenStatic
  prodRS.PageSize = 5

sqlString = "SELECT product_id, product_picture, product_name, product_briefDesc " &_
	"FROM Products WHERE product_category= 'winter' " &_
	"AND product_status='active' " &_
	"ORDER BY product_name "
prodRS.Open sqlString
prodRS.AbsolutePage = pg


%>

<div class="product">

<%
WHILE NOT prodRS.EOF and rowCount < prodRS.PageSize
rowCount = rowCount + 1
%>
<div class="product_border">
<% IF prodRS( "product_picture" ) <> "?????" THEN %>
 <IMG SRC="<%=prodRS( "product_picture" )%>"
  <% END IF %>
<br>
</div>
  <a href="product.asp?pid=<%=prodRS( "product_id" )%>">
  <%=prodRS( "product_name" )%></a>
  <br><a href="product.asp?pid=<%=prodRS( "product_id" )%>">
  get more information</a>


  <%
prodRS.MoveNext
WEND
%>

<%
IF prodRS.PageCount > 1 THEN
%>
<font color="darkgreen">
<b>Go to page: </b>
<%
  FOR i = 1 to prodRS.PageCount
  IF i <> cINT(pg) THEN
%>
<a href="productlist.asp?=<%=Server.URLEncode( cat )%>&pg=<%=i%>">
<%=i%>
<% ELSE %>
<%=i%>
<% END IF %>
<%
  NEXT
%>
</div>
<% END IF %>

November 5th, 2005, 05:12 PM

Shadow Wizard

Moderator From Beyond

Join Date: Sep 2004

Location: Israel

Posts: 26,936

Folding Points: 340465 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 3 Months 1 Week 5 Days 11 h 28 m
Reputation Power: 1537

have such code:

Code:

<%
 Const IMAGES_PER_ROW=3
 rowCount=0
 WHILE NOT prodRS.EOF and rowCount < prodRS.PageSize
    If (rowCount Mod IMAGES_PER_ROW)=0 Then
       If rowCount>0 Then Response.Write("</div>")
       Response.Write("<div class=""product_border"">")
    End If
    Response.Write("<a href=""product.asp?pid="&prodRS( "product_id" )&""" title=""get more information"">")
    IF prodRS( "product_picture" ) <> "?????" THEN
       Response.Write("<img src="""&prodRS( "product_picture" )&""" alt="""&prodRS( "product_name" )&""" />")
    Else  
       Response.Write(prodRS( "product_name" ))
    End If
    Response.Write("</a>")
    rowCount = rowCount + 1
    prodRS.MoveNext
 WEND
%>

consider creating default image, it would be much more nice for the user to see...

__________________

Visit The Windows Scripting Guru

November 7th, 2005, 04:38 AM

djfubar

Contributing User

Join Date: Dec 2004

Posts: 414

Time spent in forums: 5 Days 1 h 28 m 49 sec
Reputation Power: 6

thanks shadow wizard.

one problem - neither the product name or "get more information" links are appearing

any ideas why?

November 7th, 2005, 04:53 AM

Shadow Wizard

Moderator From Beyond

Join Date: Sep 2004

Location: Israel

Posts: 26,936

Time spent in forums: 3 Months 1 Week 5 Days 11 h 28 m
Reputation Power: 1537

Quote:

Originally Posted by djfubar

thanks shadow wizard.

one problem - neither the product name or "get more information" links are appearing

any ideas why?

if you have images defined, you'll see only the images - they're being
used as link and when clicked will take you to the details page.
that's what looked better in my opinion, feel free to change the html
to whatever design you like.

November 7th, 2005, 11:45 AM

djfubar

Contributing User

Join Date: Dec 2004

Posts: 414

Time spent in forums: 5 Days 1 h 28 m 49 sec
Reputation Power: 6

ok. cud you point us out on how to display the "getmore information" and product name link from the code

Code:

<%
 Const IMAGES_PER_ROW=3
 rowCount=0
 WHILE NOT prodRS.EOF and rowCount < prodRS.PageSize
    If (rowCount Mod IMAGES_PER_ROW)=0 Then
       If rowCount>0 Then Response.Write("</div>")
       Response.Write("<div class=""product_border"">")
    End If
    Response.Write("<a href=""product.asp?pid="&prodRS( "product_id" )&""" title=""get more information"">")
    IF prodRS( "product_picture" ) <> "?????" THEN
       Response.Write("<img src="""&prodRS( "product_picture" )&""" alt="""&prodRS( "product_name" )&""" />")
    Else  
       Response.Write(prodRS( "product_name" ))
    End If
    Response.Write("</a>")
    rowCount = rowCount + 1
    prodRS.MoveNext
 WEND
%>

#10

November 8th, 2005, 03:29 AM

Shadow Wizard

Moderator From Beyond

Join Date: Sep 2004

Location: Israel

Posts: 26,936

Time spent in forums: 3 Months 1 Week 5 Days 11 h 28 m
Reputation Power: 1537

you can add the text beside the image:

Code:

Response.Write("<img src="""&prodRS( "product_picture" )&""" alt="""&prodRS( "product_name" )&""" />"&prodRS( "product_name" ))

#11

November 8th, 2005, 05:26 AM

djfubar

Contributing User

Join Date: Dec 2004

Posts: 414

Time spent in forums: 5 Days 1 h 28 m 49 sec
Reputation Power: 6

is it possbile to place the text below the image and a space between each record

#12

November 8th, 2005, 05:52 AM

Shadow Wizard

Moderator From Beyond

Join Date: Sep 2004

Location: Israel

Posts: 26,936

Time spent in forums: 3 Months 1 Week 5 Days 11 h 28 m
Reputation Power: 1537

I'm not very familiar with CSS yet but from what I've recently
learned, it's possible using lists with inline items:

ASP Code:

Original - ASP Code

<%