Member Avatar for eddy556

In a JSP how do I access a record by its number?

  • 3 Contributors
  • 4 Replies
  • 244 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by dogma
Member Avatar for ~s.o.s~

Which record are you talking about anyways? Please make an attempt to at least specify the exact nature of your problem as explicitly as possible instead of letting the one helping you out to do all the thinking.

Member Avatar for eddy556

Sorry. I have a JSP which accesses an Access database and prints its records to screen. What I want to be able to do is to access the records and print them by there row number in the record set. Something along the lines of:

rs.Record[1]
rs.Record[2]
rs.Record[3]

..and so on.

Thanks for your help

Member Avatar for dogma

You can only use data that is in the table. All other data is artificial. You could use a for loop (or something like a <c:forEach> with an incremental variable) the numbers though are not tied to each record. I.E. record 0 is only ever the first record you retrieve not the primary key or an identifier of the data.

You won't be able to use this to update records etc.

Member Avatar for dogma

Also:
Are you using JSP tags or reverting back to java?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.