table format and content

Results 1 to 2 of 2

Thread: table format and content

  1. #1
    Join Date
    Dec 1969

    Default table format and content

    i think that ny last question was worded wrong, the way i though to solve the problem/ logic has got to be wrong :) but anyway...<BR><BR>i have a query that brings back one row of data, there are about 40 colums of data. In one section of the page i want to display a table two by how many results fields are occupied with text and insert the text. The problem is i dont know how to step through table colums or do a loop through all the columes starting with acc_ (they all start with "acc_*") <BR><BR>any help?<BR><BR>is ther a way to loop? through all the acc_* table colume names??<BR><BR><BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default Do you mean...

    set myRS= cn.execute("SELECT * from myTable")<BR>for each iField in myRS.fields<BR> Response.Write "&#060;P&#062;" & &#039;Gives you the name of each column<BR> Response.Write " " & iField.value &#039;Gives you the content of each column<BR>next<BR>

Posting Permissions

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