display 5 records across, unlimited rows

Debbie Davis

Greetings,

I have a page displaying records in a table across but there are too
many records to display and they run off the page, SO I thought I could
show five columns with an unlimited number of rows. I'm stuck though.
I've never done that before. I don't know where to start. Any thoughts
would be very helpful.

I don't need paging as I can display all records on one page, keeping it
simple.

Here's my recordset:
<%set rsAll=objConn.execute("select * from qyProd where catalogid>0
order by designer_name")%>

Thank you in advance.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 19 '05 #1

Subscribe Post Reply

1909

Ray at

Basically, you want to start a <tr> at the beginning, then put a </tr><tr>
at each five step after, and then follow that up with a final </tr>.
Additionally, you'll probably want to determine the difference between the
final record count and the next closest multiple of five so that you can
complete the final row with as many <td> </td>'s as necessary. Here's
some sample code here.

http://www.aspfaq.com/show.asp?id=2247

Ray at home

"Debbie Davis" <dd@clickfocal.com> wrote in message
news:Oi****************@TK2MSFTNGP11.phx.gbl...

Greetings,

I have a page displaying records in a table across but there are too
many records to display and they run off the page, SO I thought I could
show five columns with an unlimited number of rows. I'm stuck though.
I've never done that before. I don't know where to start. Any thoughts
would be very helpful.

I don't need paging as I can display all records on one page, keeping it
simple.

Here's my recordset:
<%set rsAll=objConn.execute("select * from qyProd where catalogid>0
order by designer_name")%>

Thank you in advance.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 19 '05 #2

Debbie Davis

Thanks Ray, I really appreciate the reply. I'll take a look. many
thanks again.
dd
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 19 '05 #3

by: addi | last post by:

All, I will be eternally greatful if someone can provide snippet of code, URL or reference material that shows how to display data in a "n colums * n rows" format. I am new to ASP and have...

ASP / Active Server Pages

Displaying two records on one row of a form

by: Matt K. | last post by:

Hi there, I have a form in an Access project that contains a subform which displays the results of a query of the style "select * from where = #a certain date#". In the main part of the form...

Microsoft Access / VBA

Records across LAN

by: Damon Grieves | last post by:

Hi I just want to be sure I understand how the Access client works. If I have an Access back end with a million records on a server and an Access client. If the client is installed on the users pc...

Microsoft Access / VBA

OleDbDataAdapter won't update database from dataset (Display at Width = 65)

by: M. David Johnson | last post by:

I cannot get my OleDbDataAdapter to update my database table from my local dataset table. The Knowledge Base doesn't seem to help - see item 10 below. I have a Microsoft Access 2000 database...

Visual Basic .NET

Display records similar to Classic ASP using DataList or Repeater

by: Kas_aspnet | last post by:

Hi, I have to display a sequence of records in an Aspx page. The problem is, i have to display the records by checking conditions like Classic ASP. For example, consider an employee table. In...

ASP.NET

Update MS Access Database Records

by: thomasp | last post by:

First of all, thanks for the help on my previous VB.NET/MS Access questions. This time I need do the following 1. Connect to a table 2. step through each of its records 3. read the value of two...

Visual Basic .NET

TreeView control checked based on if records exist

by: Ryan | last post by:

OK, here's my setup. I have a treeview control that is populated with records from a Product table, and it allows "checking". This is used for my automatic notification system. Say a particular...

Visual Basic .NET

Records added with ADo don't show up in query immediately

by: gerbski | last post by:

Hi all, I am relatively new to ADO, but up to now I got things working the way I wanted. But now I've run into somethng really annoying. I am working in MS Access. I am using an Access...

Microsoft Access / VBA

Display records on the grid based on selected item in the combobox

by: kurtzky | last post by:

i created a form that should function as follows: i will enter a number in a textbox..then it should query from the database all the records which has that number..these records will have a...

.NET Framework

Benefits of Blockchain App Development for Enterprise Businesses

by: Kemmylinns12 | last post by:

Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...

General

Basic concepts of WebLogic Admin training?

by: Naresh1 | last post by:

What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...

Oracle Database

Hyperconverged All-in-One Streaming Engine, ushering in new age for distributed database

by: antdb | last post by:

Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...

General

How to layout php header location with a variable as the location?

by: Matthew3360 | last post by:

Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. header("Location:".$urlback); Is this the right layout the...

PHP

How to use http requests (Get function) to get variable value?

by: Matthew3360 | last post by:

Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it so the python app could use a http request to get...

Python

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computer

by: AndyPSV | last post by:

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and...

General

How do I view Redshift db tables in Alteryx

by: Arjunsri | last post by:

I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...

General

Join our open community on Discord to learn programming, SEO, and marketing

by: BLUEPANDA | last post by:

At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...

General

Mastering Python: A Versatile Programming Language for All

by: Rahul1995seven | last post by:

Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...

General

Similar topics