displaying records using asp & sql

Adam H-W · June 1st, 2006, 05:45 AM

Hello

I'm hoping someone can solve my quandry. I need to display all records from a ms sql database on a page which is no problem. However, what I'm looking to do is display them so that the first one is right aligned, and the second records is left aligned and so on -

can anyone help me?

thanks

Adam

om_prakash · June 1st, 2006, 11:31 PM

This can be done easily in while loop. You can keep a variable and check for even/odd and based on this display the contents. You also need to increment this variable in the loop.

Om Prakash

Adam H-W · June 2nd, 2006, 07:36 AM

Great, thanks Om

So if I have my code such as

.......
<%

rs.Recordset.movenext()

loop

end if

%>

what would be the coding for the variable and how would I increment the variable in the loop?

thanks

Adam

woodyz · June 15th, 2006, 10:32 AM

The variable could be a boolean, and you just need to flip the boolean each loop

Code:

do while not rs.eof
   blnLeft = not blnLeft
   if blnLeft then
      ' Code to left justify
   else
      ' Code to right justify
   end if
   rs.movenext   
loop

Make sense?

Woody Z http://www.learntoprogramnow.com

Adam H-W · June 28th, 2006, 08:41 AM

Thanks guys but what I'm wanting to do is not pull out the same record every time - rather loop through the records pulling out a different, sequential image each time - at the moment it's pulling out the same record everytime.

Adam