SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Aug 2001
    Location
    Derry
    Posts
    18
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exclamation Converting figures in a database to form graphs

    Hi

    I need to get figures that are in a database to form graphs on an .asp site. The figures will be updated every quarter so the graphs will have to change automatically when the new figures are input.

    Can Dreamweaver Ultradev do this?

    Can Excel work with the .asp code to produce these?

    Any other suggestions welcome.

    Thanks in advance
    Louise
    LouiseG

  2. #2
    Drupaler bronze trophy greg.harvey's Avatar
    Join Date
    Jul 2002
    Location
    London, UK
    Posts
    3,258
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You can certainly connect to an Excel spreadsheet using MS's ODBC drivers -- it's the same as connecting to any old dB. As for the graph, I've thought about this (but had no call to do it) and I'd use a For Next loop. Very simply, your code to draw a bar would be:

    Code:
    <%
    For x = 1 to number
    %>
    |<br>
    <%
    Next
    %>
    That's the lines to be thinking along I reckon ...



Bookmarks

Posting Permissions

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