Database Results

C

Camajas

How do I add a database results counter to my asp page, created with
Frontpage? When I try to add code to certain areas, Frontpage overwrights it.
 
S

Stefan B Rusynko

Explain "database results counter"
(there is no counter in the DBRW)
Unless you want to display the record count from a DBRW query
- in which case just add below the DBRW results in code view
<p>Record Count = <%=fp_iCount%></p>


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| How do I add a database results counter to my asp page, created with
| Frontpage? When I try to add code to certain areas, Frontpage overwrights it.
 
C

Camajas

Your coding is heading me in the right direction. But to offer a little more
of what I need, I have the database result being returned in 15 record
increments. So I sometimes have several pages with 15 records in it. Which is
what you’re coding gives me, a page by page record count. What I need is a
total returned record count that can be displayed. I can work around this by
showing all the returned records at once, but I would like to keep the
viewable records down to 15 at a time. I would also like to keep track of the
records being viewed, i.e. 1-15, 16-30, 31-45, etc.
 
S

Stefan B Rusynko

All possible, but not using the DBRW for your "tool"
- it is limited to only very basic functions

You will need to spend some time learning VBScript and how to hand code it
Start at
http://www.w3schools.com/asp/default.asp
Also See http://www.devguru.com/Technologies/asp/quickref/asp_list.html
and http://www.asp101.com/samples/
Then finally when you understand above look at
http://www.aspfaq.com/show.asp?id=2120

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Your coding is heading me in the right direction. But to offer a little more
| of what I need, I have the database result being returned in 15 record
| increments. So I sometimes have several pages with 15 records in it. Which is
| what you’re coding gives me, a page by page record count. What I need is a
| total returned record count that can be displayed. I can work around this by
| showing all the returned records at once, but I would like to keep the
| viewable records down to 15 at a time. I would also like to keep track of the
| records being viewed, i.e. 1-15, 16-30, 31-45, etc.
|
| "Stefan B Rusynko" wrote:
|
| > Explain "database results counter"
| > (there is no counter in the DBRW)
| > Unless you want to display the record count from a DBRW query
| > - in which case just add below the DBRW results in code view
| > <p>Record Count = <%=fp_iCount%></p>
| >
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | How do I add a database results counter to my asp page, created with
| > | Frontpage? When I try to add code to certain areas, Frontpage overwrights it.
| >
| >
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top