Database summary page

M

Mike

I have a website that lists projects of various types. I
would like a summary page that lists:

xx projects in system. xx are currently enabled. xx are
currently disabled. xx are in category yy, etc.

I know how to use the:

SELECT Count(ID) FROM table WHERE (enabled = 1) to show
enabled projects.

How do I get the more lengthy summary I want.

-M
 
J

Jim Buyens

To do this entirely in FrontPage, you would have to run
the Database Results Wizard once for each statistic (and
thereby create a separate database results region for each
region). This might not be too bad if you displayed the
data in tabular form, and suppressed the database results
column headings.

Otherwise, for complete flexibility, you'd need to write
custom program code in ASP or ASP.NET.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
M

Mike

Jim,

Thanks. When I try to use the select(id) in this
particular website:

SELECT Count(ID) FROM table WHERE (enabled = 1)

FP returns this error:

Database Results Wizard Error
The operation failed. If this continues, please contact
your server administrator.

What is causing this. I can't find any issue with the
code?

-M
 
J

Jim Buyens

Have you tried the same query in Access?

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
M

Mike

Jim,

Thanks. I got it working.

-M
-----Original Message-----
Have you tried the same query in Access?

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------



"Mike" <[email protected]> wrote in
.
Click to expand...
 
Top