Database Update

I have a web page that has several dynamically created fields. Each one of
the fields start with the following:

DPT(some number)
PID(some number)
CCD(some number)

The number is pulled from the ID field from the DB that I am querying.

Example, the DPT could be DPT88 indicating that the Department record that I
am pulling is number 88.

The problem that I am having is the updating of the DB, how can I update the
DB without knowing what the exact names of the fields are? I already know
how to create the Record Set and update the DB, I just don't know how to
call the values of the fields.

Any help will be appreciated.

TIA
RC-

Thomas
Tue Aug 29 15:19:58 CDT 2006

Pass the ID as a value to hidden form field, then use that to update the record in the DB, assuming
the ID field is the same field used by all record types in the DB.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================


"RC-" <r_candee@hotmail.com> wrote in message news:uMstpW6yGHA.4232@TK2MSFTNGP05.phx.gbl...
>I have a web page that has several dynamically created fields. Each one of the fields start with
>the following:
>
> DPT(some number)
> PID(some number)
> CCD(some number)
>
> The number is pulled from the ID field from the DB that I am querying.
>
> Example, the DPT could be DPT88 indicating that the Department record that I am pulling is number
> 88.
>
> The problem that I am having is the updating of the DB, how can I update the DB without knowing
> what the exact names of the fields are? I already know how to create the Record Set and update the
> DB, I just don't know how to call the values of the fields.
>
> Any help will be appreciated.
>
> TIA
> RC-
>
>

MD
Thu Aug 31 08:22:03 CDT 2006

RC,

Are you tiring to update this using ASP / ASP.Net or via FPSE?

--
Mike
http://www.websunlimited.com
FrontPage Add-in
MVP FrontPage '97 - '02

"RC-" <r_candee@hotmail.com> wrote in message news:uMstpW6yGHA.4232@TK2MSFTNGP05.phx.gbl...
>I have a web page that has several dynamically created fields. Each one of the fields start with the following:
>
> DPT(some number)
> PID(some number)
> CCD(some number)
>
> The number is pulled from the ID field from the DB that I am querying.
>
> Example, the DPT could be DPT88 indicating that the Department record that I am pulling is number 88.
>
> The problem that I am having is the updating of the DB, how can I update the DB without knowing what the exact names of the fields
> are? I already know how to create the Record Set and update the DB, I just don't know how to call the values of the fields.
>
> Any help will be appreciated.
>
> TIA
> RC-
>
>