sql/access table

Results 1 to 2 of 2

Thread: sql/access table

  1. #1
    Join Date
    Dec 1969

    Default sql/access table

    hey,<BR>I have a bunch of fields, in Microsoft access, in a table. I am updating this table with an asp upload component which inserts the field names into the database. "very simple" Now I am trying to show the records in a 3 column table on my web site-<BR><BR>example table (this is what i want as the output):<BR><BR>kevin1 kevin2 kevin3<BR>kevin4 kevin5 kevin6<BR>...<BR><BR>how do I get the fieldnames to continue and repeat as 3 across?<BR>then skip a row and continue as 3 across?

  2. #2
    Join Date
    Dec 1969

    Default RE: sql/access table

    Something like this perhaps?<BR><BR>Cols = 3<BR><BR>While Not rs.eof<BR>Response.Write("&#060;tr&#062;")<BR>For iTmp = 1 to Cols<BR> If Not rs.eof Then<BR> Response.Write("&#060;td&#062;" & rs("FieldName") & "&#060;/td&#062;")<BR> rs.MoveNext<BR> Else<BR> Response.Write("&#060;td&#062;& n b s p;&#060;/td&#062;")<BR> End If<BR>Next<BR>Response.Write("&#060;/tr&#062;")<BR>Wend<BR><BR>( & n b s p ; ) &#060;-- without the spaces :)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts