Retreive database info

[robert]

I often see webisteS that display the quanitity of a particular item, for
example.
CLOCKS (1)
BEDS (0)
I'm assuming the number besides the item (somehow) retrieves information
within a database.
Does frontpage have the ability to do something like this.

 

[Ronx]

FrontPage has wizards that help to interrogate a database and display that
information.
However, if you are thinking of an e-commerce site, you will probably be
better off searching for a shopping cart, and customising it.

 

[robert]

I've succesfully used the database wizard to retreive individual records
within my database.
However, i'm now interested in retrieving a tally of a specified group
within the database and display the tally on my site. I dont recall seeing
anytihng in the wizard that will achieve this goal, maybe i've overlooked it.
Or perhaps it's a special 3-party scipt that performs that task.
It would be great if frontpage can do this and that i have overlooked that
option but i cannot find it. Could you point me in the correct direction.
thanks

 

[Kathleen Anderson [MVP - FrontPage]]

If by "tally" you mean "sum", insert a second database results region in
your page just like the first, only modify the SQL adding the SUM function;
like this:

SELECT SUM(myAmount) AS MySum

MySum will show up on your page.


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx