Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    10

    Unanswered: How can i write this store procedure

    sql result:

    startdate enddate price
    2004-1-2 2004-1-4 677
    2004-1-5 2004-1-8 900
    2004-1-9 2004-1-12 2000


    i want display in page this format:
    2004-1-2 2004-1-3 2004-1-4 2004-1-5 ... 2004-1-12
    677 677 677 900 2000

    how can i write store procedure

  2. #2
    Join Date
    Dec 2003
    Posts
    454
    This post is almost the same as the one you posted at http://www.dbforums.com/showthread.php?threadid=977455

    If there are two fields in the record set, the code is

    <table>
    <%dim row1 : row1="<tr>"%>
    <%dim row2 : row2="<tr>"%>
    <%for not rs.eof then%>
    <%row1 = row1 & "<td>" & rs("field1") & "</td>"%>
    <%row2 = row2 & "<td>" & rs("field2") & "</td>"%>
    <%next%>
    <%row1 = row1 & "</tr>"%>
    <%row2 = row2 & "</tr>"%>
    </table>
    Last edited by gyuan; 01-11-04 at 16:20.

Posting Permissions

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