If objRS("month") <> varLoop then ' IS THE ISSUE IN THE RIGHT COLUMN? Response.Write "-" Else Response.Write "" & objRS("issue") & "" ' IF SO, RENDER THE ISSUE NUMBER 'objRS.MoveNext ' MOVE TO THE NEXT ROW End If Next ' GO ROUND THE LOOP AGAIN

I'm sorry the links are broken, as this would enable you to see what I was trying to achieve and what I was getting with the code I have. The code you've posted above doesn't deliver a substantially different result from what I already have.

Here's what I want the table to look like:

thestoryworks/publishing/comics/collecting/wants63.htm(put www in front to make it a URL!)

The Access db is here, so you should be able to download it ...tmcreative.co.uk/db/admin/db/sw_com.mdb(www)

I see that the main problem with the code is that the objRS.movenext instruction is in the wrong place. When I try to put that command in the right place (within the If...Then, right after the issue number is rendered) I get an error.

When I put the objRS.movenext just before the Loop, the server likes that syntax better and runs the page, but each issue number is rendered on a new line, instead of being rendered across the row, with the months there was NO ISSUE having a "-" instead.

You'll see what I mean when you look at the static version on thestoryworks.com

The problem arises because there's only 7 issues of Amazing Spider-Man in 1963 and the first few were issued bi-monthly. So when there's no issue for that month, I can't do objRS.movenext, I have to move to the next column and render the correct issue there.

It gets doubly tricky when we get to The Avengers line. Issue 1 is Sept, there's no Oct issue, issue 2 is Nov, then there's no Dec issue. BIG problem. Because the code doesn't render an issue for Dec, just a "-", there isn't an objRS.movenext either, so the ASP tries to render issue 10 of Fantastic Four in that slot instead.

Funny, when I started to code this I thought, "How hard can it be? I've done a bit of ASP before and this is really straightforward."

Guess I severely underestimated the trickiness of it all ...

I really do appreciate you taking time to look at this and I apologise that I wasn't able to figure out how to get the message board to render the example URLs properly.

(GMT + 5.30 ... sounds like India to me. Only reason I know is becaue my wife has family in Pune!)

Kind regards,

MattiMan

: Hi,: : I didn't really think my changes will do much for you, what i : mainly did was make it a bit more readable. :-): : Now I can see the links, and will try to make it work the way you : want. But it's end of working day for me, I am at GMT + 5.30 . So : maybe tomorrow ?: : :

: Can you play with this for now :: : [code]: Code went here: [/code]: : : And yes, I am from India.: : tomorrow, then.: : Thanks for that second page of code. I made a couple of minor changes to get it to run with the database on the server and the result was this (make sure you put the "www." in front!):

tmcreative.co.uk/db/BuildTable03c_PH_fix.asp

Looks to me like the Loop's not finding any valid issue numbers in the array. (I did have another read through the GetRows section in Wrox's BEGINNING ACTIVE SERVER PAGES, but I still haven't got my head around it :-(

: I see you have found aspmessageboard.com :-) : : Listen to Bill, he is THE best around.

Hi, Flakes,

Thank you for all your help. ASPmessageboard's Bill may be the best around, but it looks like you solved the problem, so B-I-G respect to you :-)

I'll fiddle around with it some more, then send you a link to the page when I have it looking the way I want it to (with bolds for when I have the issue and the issue numbers as links to a detail page!)

: : I see you have found aspmessageboard.com :-) : : : : Listen to Bill, he is THE best around.: : Hi, Flakes,: : Thank you for all your help. ASPmessageboard's Bill may be the best : around, but it looks like you solved the problem, so B-I-G respect : to you :-): : I'll fiddle around with it some more, then send you a link to the : page when I have it looking the way I want it to (with bolds for : when I have the issue and the issue numbers as links to a detail : page!): : Thanks again!: : MattiMan: MattiMan: ---: "In brightest day, in darkest night, : no evil shall escape my sight ..."