Pagination/Navigation on database

From: Ruby Tuesday (rubytuzdayz_at_yahoo.com)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 13:43:08 -0500

In the database, I have about 100 or so record which consist of the
following:

imgname - text(128)
    eg: AA-nnn
imglocation - text(128)
    eg: c:\path\<imgname>.jpg
description
    1st line
    2nd line
    3rd line
location - memo text (256)
    123 ABC Street
    Suite 123
    Albany, NY 12345
note - memo text (256)
    note line1
    note line2
    note line3

I have about 300 rows of the above structure, and would love to display them
on the web with the following features:

search on each field(except the image field)
paginate(display 10 or so rows at the time) and user has
   the option to browse 1 record at the time or go to the
   next/previous page
when they click the image, it display the larger image
   and the caption(hopefully can be controlled by external
   css file(s))

In the future, I'd love to be able to update/modify using this web interface
as well. But for now, the above should be sufficient.

How do you do that in FP. I'd love to get some code example or live example
if exist. Thanks

Relevant Pages

  • Pagination/Navigation on database
    ... imglocation - text ... location - memo text ... I have about 300 rows of the above structure, and would love to display them ... I'd love to be able to update/modify using this web interface ...
    (microsoft.public.frontpage.programming)
  • Pagination/Navigation on database
    ... imglocation - text ... location - memo text ... I have about 300 rows of the above structure, and would love to display them ... I'd love to be able to update/modify using this web interface ...
    (microsoft.public.frontpage.client)
  • RE: Set label caption from query?
    ... I would like to display the latest entry in the memo ... > field in a label on a form, ...
    (microsoft.public.access.formscoding)
  • Re: Hot to display HTML in a VFP form
    ... >I have a memo field that contains HTML. ... > I want to display this properly in my form. ... > I tried the Web class but thi requires a URL whereas I have data in a memo ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Lost the ability to default to a specified Home Page
    ... > The links list in your reply will not display. ... Since you are using the web interface to access news, ... copy/paste links into a new browser window. ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
Quantcast