Ok, I'm sure there some elementary mistake I'm making in my logic here, but here's my code:
And instead of getting a nicely laid out table where I have one state, multiple cities, and then another state listed, with more cities...
while not infoRS.eof
IF State = infoRS.fields("state") THEN
response.write "<tr><td> </td><td>" & infoRS.fields("city") & "</td></tr>"
Set State = infoRS.fields("state")
response.write "<tr><td>" & infoRS.fields("state") &"</td><td>" & infoRS.fields("city") & "</td></tr>"
I have one state listed at the top left, and every city listed. No more states. Here's the page: http://www.mickeysguidingstuff.net/p...es/content.asp
Far warning, it cycles thru about 319 records. So it'll take a second or two to process. At least, it has with me. I've trimmed some code out of my example here. Namely, an entire column. But you get the idea of what I'm wanting it to, I hope.
Is it something simple? Got things in the wrong order or something? It seems like it should work from here. The logic of it, anyway. But it's not doing what I want.