Simple Question With Displaying Info From Database

[cdogstu99]

I have a small database with prices for certain items. There are 13 items with 5 different prices for each item. Could someone tell me how to display a specific price on an asp page. If i am looking for the 3rd price of item 4 and i want it to display on a certain place on my page, how can i easily do this? Thanks!

 

[ChrisHirst]

Depends on how your database is arranged.
are the items in one table and prices in another ?

if so use

objRS.Move(3,adBookmarkFirst)

to get to a specific record.

if you don't know how to retrieve a recordset there are several FAQs you can refer to


Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[cdogstu99]

Chris all my info is in one table, so it looks as such,

Price 1 Price 2 Price 3
Item 1 3 4 4
Item 2 5 2 9
Item 3 2 3 4

 

[ChrisHirst]

SELECT price3 FROM table WHERE item = 4;

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.