Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    New to the CF scene
    Join Date
    Sep 2005
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lightbulb Please help me, I'm stuck...

    Hi, thanks for reading my question! I need help

    I'm building a website with a shop function. It works like this.
    I you choose your category and then the articles shows (see image, you see the category)

    If I click on the category you see all the items (see image)

    If you click on the article you'll see the price (see image)


    What I need is a button that opens a webpage and shows all the articles and all the prices in a tabel (see image)


    if there's a way to export it to excel It would be more then great!

    The file that the store uses and the can be modified can be downloaded here:
    Zipfile
    I think this is very easy for an expert!

    Please tell me how to make this or please help me..

    Thanks sander
    Last edited by sbuijs; 09-06-2005 at 11:13 AM. Reason: I needed a more friendly title :-)

  • #2
    Regular Coder
    Join Date
    Sep 2004
    Posts
    152
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Your images were not viewable to me, but here is some help on the excel part: http://www.codetoad.com/asp_excel.asp

  • #3
    New to the CF scene
    Join Date
    Sep 2005
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    and now?

  • #4
    Senior Coder nikkiH's Avatar
    Join Date
    Jun 2005
    Location
    Near Chicago, IL, USA
    Posts
    1,973
    Thanks
    1
    Thanked 32 Times in 31 Posts
    Just query the database and write it out as an html table. Very standard.
    A simple Google search would tell you how.

    Setting content type to match Excel will automatically open it in Excel, but only if the user has it installed. You can also embed it in the document.
    Otherwise you need a third party plugin or such.
    I would not recommend doing this for anything other than an intranet application. On the internet, users very likely don't HAVE Excel -- it's not a standard Windows install, nor is it available for *nix or Mac systems AFAIK.

    If this post contains any code, I may or may not have tested it. It's probably just example code, so no getting knickers in a bunch over a typo, OK? If it doesn't have basic error checking in it, such as object detection or checking if objects are null before using them, put that in there. I'm giving examples, not typing up your whole app for you. You run code at your own risk.
    Bored? Visit
    http://www.kaelisspace.com/

  • #5
    New to the CF scene
    Join Date
    Sep 2005
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by nikkiH
    Just query the database and write it out as an html table. Very standard.
    A simple Google search would tell you how.

    Setting content type to match Excel will automatically open it in Excel, but only if the user has it installed. You can also embed it in the document.
    Otherwise you need a third party plugin or such.
    I would not recommend doing this for anything other than an intranet application. On the internet, users very likely don't HAVE Excel -- it's not a standard Windows install, nor is it available for *nix or Mac systems AFAIK.
    The "problem" is that the every user has their own prices. So Just query the database and write it out as an html table isn't an option is it?

  • #6
    Senior Coder nikkiH's Avatar
    Join Date
    Jun 2005
    Location
    Near Chicago, IL, USA
    Posts
    1,973
    Thanks
    1
    Thanked 32 Times in 31 Posts
    What I need is a button that opens a webpage and shows all the articles and all the prices in a tabel
    Where are "all the articles" and "all the prices" stored if not in a database?

    If this post contains any code, I may or may not have tested it. It's probably just example code, so no getting knickers in a bunch over a typo, OK? If it doesn't have basic error checking in it, such as object detection or checking if objects are null before using them, put that in there. I'm giving examples, not typing up your whole app for you. You run code at your own risk.
    Bored? Visit
    http://www.kaelisspace.com/

  • #7
    New to the CF scene
    Join Date
    Aug 2005
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by nikkiH
    Where are "all the articles" and "all the prices" stored if not in a database?
    in an SQL database.

  • #8
    Senior Coder nikkiH's Avatar
    Join Date
    Jun 2005
    Location
    Near Chicago, IL, USA
    Posts
    1,973
    Thanks
    1
    Thanked 32 Times in 31 Posts
    Okay, so what is the actual problem you are trying to solve that a query of that database doesn't resolve?
    You can filter query results however you want.

    Note that the query output can be anything you want. HTML, text, CSV, Excel...whatever.

    If this post contains any code, I may or may not have tested it. It's probably just example code, so no getting knickers in a bunch over a typo, OK? If it doesn't have basic error checking in it, such as object detection or checking if objects are null before using them, put that in there. I'm giving examples, not typing up your whole app for you. You run code at your own risk.
    Bored? Visit
    http://www.kaelisspace.com/

  • #9
    New to the CF scene
    Join Date
    Sep 2005
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The actual problem is that I would like to show all the data from all
    categories + prices

  • #10
    Regular Coder
    Join Date
    Sep 2004
    Posts
    152
    Thanks
    0
    Thanked 0 Times in 0 Posts
    What fields do you have in the categories and price tables and what are the relationship between the two (ie. foreign key)? If you give us a structure, hi-lighting what fields you want from each table, we can help you write a sql statement that can do it.

    P.S. Images still don't display for me, but that could be a firewall issue on my end since I'm at work and most sites are blocked

  • #11
    Senior Coder nikkiH's Avatar
    Join Date
    Jun 2005
    Location
    Near Chicago, IL, USA
    Posts
    1,973
    Thanks
    1
    Thanked 32 Times in 31 Posts
    Yeah, I still don't see why a simple query and output wouldn't give you what you want. Perhaps you just need help with the SQL?
    Images display fine for me, so it must be your firewall, neo.

    If this post contains any code, I may or may not have tested it. It's probably just example code, so no getting knickers in a bunch over a typo, OK? If it doesn't have basic error checking in it, such as object detection or checking if objects are null before using them, put that in there. I'm giving examples, not typing up your whole app for you. You run code at your own risk.
    Bored? Visit
    http://www.kaelisspace.com/

  • #12
    New to the CF scene
    Join Date
    Sep 2005
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    I'm not sure what u mean.
    The zip file I added that's the commerce page that shows everything
    as a user is logged in they get 2 prices. one price for the reseller and one for the enduser.
    They can only see all the category's. If I want to see the products I need to click on the categorie and then I see all the products of that categorie.

    I need a list off all products from all categories with the enduser price and the reseller price; product name and sku name . The best solution is that their are 3 buttons
    1 export to excel one export to CSV and one show on ASP page.

    See the website live if u like:

    Website: www.ysland.nl/portal goto inloggen
    User: demo
    Password: demo

    Online Shop / KM-1500

    if you click on online shop you'll see all the categorie's if you click on (for example) KM-1500 you'll see all the products for that categorie

    the commerce.asp file:
    http://www.ysland.nl/pricetotal.zip

    Pictures you didn't see:
    http://www.ysland.nl/pic.zip

  • #13
    Regular Coder
    Join Date
    Sep 2004
    Posts
    152
    Thanks
    0
    Thanked 0 Times in 0 Posts
    @subijs,
    The correct sql statement will do just what you are looking for. What I was asking for was the layout of the tables in sql that correspond to categories and products. That way we can help you write a simple join sql statement that will return all categories with all products for each category. But without knowing the sql table structure, it would be hard for us to suggest, especially in regards to a pre-made application (as it sounds like that is what you are dealing with).

    --neo

  • #14
    New to the CF scene
    Join Date
    Sep 2005
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by neocool00
    @subijs,
    The correct sql statement will do just what you are looking for. What I was asking for was the layout of the tables in sql that correspond to categories and products. That way we can help you write a simple join sql statement that will return all categories with all products for each category. But without knowing the sql table structure, it would be hard for us to suggest, especially in regards to a pre-made application (as it sounds like that is what you are dealing with).

    --neo
    Ok, how can I discribe the structure?
    Is this something u can use?

    http://www.ysland.nl/portal.sql

  • #15
    New to the CF scene
    Join Date
    Sep 2005
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The portal had some modifications for the pricing

    so the sql changed

    http://www.ysland.nl/ModifiedPortal.sql


  •  
    Page 1 of 2 12 LastLast

    Posting Permissions

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