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.