Beginner FrontPage Database Question

[rjm65]

I have a website that I created with FP2003 that shows our product line. Each item gets it's own page. I would like to display the selling price for each item on it's respective page, but have it linked to a database so that I can update prices via the database and not have to go to each page individually. Is this possible to do with Frontpage?


I currently have my pricelist in an excel spreadsheet, is there an easy way to transfer the information over to a database format instead of having to input each item? My spreadsheet has 3 columns: Item Code, Description, and Price.

Once all the information is in a database file, how do I reference the information from the individual items webpage.

Is a database what I need for what I want to do or is there a better way?

TIA.

 

[DotNetGnat]

what database are you planning to use...

MS Access or SQL Server or other...

Every database has a import utility where you can import data from other file formats like Excel or csv or some other...

so getting data into database should not be a big deal...

next getting the price to display on each page...

you can pass in the specific parameters of the specific product in the query string and then do a query based on that...something like

sql = " Select price from mytable where ProductId="&request.querystring("prodid")

post back if you have any questions...

-DNG

 

[rjm65]

I have MS Access, and I've been playing around with it and can see now how to import from Excel, and then gettting the database uploaded to our webserver.

I've never worked with databases before, so I'm not sure how to implement the above sql line shown above. Would that code be inserted into the HTML?

For instance, I would have,

<font face="Verdana" size="2" color="#808000">Widget A is $</font> sql = " Select price from mytable where ProductId="&request.querystring("prodid")


Is this how it's implemented so that on the webpage it would display "Widget A is $42.98" ?

My results table in MS Access has 4 columns, Key, ItemCode, Description, and Price. That is how my data will be laid out.

TIA

 

[DotNetGnat]

please read and undertand some of the basics...

http://www.frontpagehowto.com/examples.asp

you can find lot of other examples on google..

-DNG