SitePoint Sponsor

User Tag List

Results 1 to 10 of 10

Hybrid View

  1. #1
    SitePoint Addict
    Join Date
    Dec 2009
    Posts
    321
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Complex Queried Data Publish to Web Page

    I have a complex median parameter query in MS Access 2003.

    Currently I display the results, nine columns, about 45 rows in a report.

    What I really need is to have this data display to a web page.

    I guess from what I read that using tables in web page design is frowned upon.

    I have no idea on how to start and my HTML/CSS knowledge is nil.

    Direction please . . .

    Thanks.

    Rick

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by R Schreiber View Post
    I guess from what I read that using tables in web page design is frowned upon.
    not if what you're displaying is actual tabular data

    in that case, the use of the html TABLE tag is definitely advised
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Addict
    Join Date
    Dec 2009
    Posts
    321
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi Rudy - yep, it's your query design.

    I understand columns and rows.

    How is tabular data different?

    Rick

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by R Schreiber View Post
    How is tabular data different?
    different from query output? it isn't

    different from web page layouts? don't go there
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    SitePoint Addict
    Join Date
    Dec 2009
    Posts
    321
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Okay - I look up HTML <table> tag.

    Each time I run the query do I have to hand type all of the column names in, and the data also?

  6. #6
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by R Schreiber View Post
    Each time I run the query do I have to hand type all of the column names in, and the data also?
    no, the resuts of the query would be inserted within TD tags by your web application language (asp, php, whatever)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  7. #7
    SitePoint Addict
    Join Date
    Dec 2009
    Posts
    321
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    no, the resuts of the query would be inserted within TD tags by your web application language (asp, php, whatever)

    I have heard of these and recognize that they have to do with data.

    Any idea which is the better - or in my case, easier?

    Thanks Rudy.

    Rick

  8. #8
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by R Schreiber View Post
    ... or in my case, easier?
    any programming background? VB, perhaps? then use asp
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  9. #9
    SitePoint Addict
    Join Date
    Dec 2009
    Posts
    321
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    any programming background? VB, perhaps? then use asp
    A quick search says ASP is for professionals and PHP for homies like me.

    I am not looking for interactive abilities from web site visitors.

    I just wish to display my Access data on my web pages.

    I use many charts on my web site (www.propertiesWithStyle.com) but I first have to convert them to .jpg images and then upload them.

    My wish is to generate the chart data, upload that data and display a crystal clear chart on a web page.

    I found a program that may do that well, TABLAOU. I also hear that Google has free charting abilities.

    Thanks.

    Rick


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
  •