Are you talking about ASP-VB scripting or using a VFP mtdll called from ASP? If the latter, you could take a look at http://www.activevfp.com/avfpdemo2 . It includes examples of searching and sorting, sessions, etc.
>Hi everybody,
>
>First of all, is ASP forum dead here? I asked one or two questions so far, but got 0 response.
>
>I have a task of designing a small new application for the WEB from the beginning to the end.
>
>The data could be described this way:
>
>Category (so far, we defined 3 category, but we may add one or two more)
>Address part - all records have them
>Date - (in our system different categories have different field for this)
>----------------------------------------
>Now for each category of data there is a set of fields (properties), which define this category.
>
>=============================
>In our system, written in Visual Foxpro, we have one table, which describes all data (all types) and several Lookup tables, used to expand coded fields.
>
>I need to organize this on the WEB. I need to be able to search by address, by date, by category (but may search across categories) and by name [we have 5 name fields - for category one only one name is used, for two other categories we may have up to 5 names - different fields]
>
>I'm thinking about this model:
>

>   MainInfo table - all records
>   ID
>   Only Address Part
>   SearchDate
>   Name1 - exists in all categories
>------------------------------------
>   Category2 table
>   ID
>   Additional fields
>   Coded fields expanded
>------------------------------
>   Category3 table
>   ID
>   Additional fields
>   Coded fields expanded
>---------------------------------
>   AllNames
>   ID FirstName LastName NameDescr

>
>--------------------------------------
>This means, I will need several recordsets returned, if I'm searching in all categories.
>
>------------------------------------------------------
>What do you think? I'm also considering one flat model, as we currently have.
>
>The table currently has 750000 records with ~100 - 150 records added each week.
>
>Thanks in advance.