Database results form navigation buttons. Numbers instead if poss.

  • Thread starter Thread starter A_ndyB
  • Start date Start date
A

A_ndyB

I have several forms where i am retreiving records from a database.
On the results pages, what i'd like to do is use a list of numbers at the
bottom of the form instead of four buttons.
If my query returns 100 results and i had the spanning set to 25, i'd like
the navigation line to have something like [1],[2],[3],[4] or similar.

So that i would know approximately where in the results list i am looking.

With the 4 buttons, it is a pain having to keep pressing the buttons to get
to where you want to go whereas if i was looking for records in between 51
and 74, all i'd have to do is press [3].

Is this possible ?

Thanks.
AndyB.
 
A_ndyB said:
I have several forms where i am retreiving records from a database.
On the results pages, what i'd like to do is use a list of numbers at the
bottom of the form instead of four buttons.
If my query returns 100 results and i had the spanning set to 25, i'd like
the navigation line to have something like [1],[2],[3],[4] or similar.

So that i would know approximately where in the results list i am looking.

With the 4 buttons, it is a pain having to keep pressing the buttons to get
to where you want to go whereas if i was looking for records in between 51
and 74, all i'd have to do is press [3].

Is this possible ?

Thanks.
AndyB.
Click to expand...

You can't really do that with the Database Results Wizard, without some
heavy modifications to the underlying code (which is hidden away in
external files to the actual page you're displaying the results in)

Expression Web (successor to Frontpage) gives a lot more options as far
as presenting data from a database is concerned, and includes the
pagination options in the form you describe. However Expression Web has
a steeper learning curve, and the pages for the data pages are ASPX
(.Net 2.0) so your host has to support that.
 
Thanks for the reply Andy.
:-)


Andrew Murray said:
A_ndyB said:
I have several forms where i am retreiving records from a database.
On the results pages, what i'd like to do is use a list of numbers at the
bottom of the form instead of four buttons.
If my query returns 100 results and i had the spanning set to 25, i'd like
the navigation line to have something like [1],[2],[3],[4] or similar.

So that i would know approximately where in the results list i am looking.

With the 4 buttons, it is a pain having to keep pressing the buttons to get
to where you want to go whereas if i was looking for records in between 51
and 74, all i'd have to do is press [3].

Is this possible ?

Thanks.
AndyB.
Click to expand...

You can't really do that with the Database Results Wizard, without some
heavy modifications to the underlying code (which is hidden away in
external files to the actual page you're displaying the results in)

Expression Web (successor to Frontpage) gives a lot more options as far
as presenting data from a database is concerned, and includes the
pagination options in the form you describe. However Expression Web has
a steeper learning curve, and the pages for the data pages are ASPX
(.Net 2.0) so your host has to support that.
Click to expand...
 
Back
Top