Append Form Data to Database Field

Thanks.

My Knowledge of SQL is lacking to say the least. So I'll have to look for an
automated way of doing this in dreamweaver ?

Thanks Again.


"Tim Ferguson" <FergusonTG (AT) softhome (DOT) net> wrote

"news (AT) blueyonder (DOT) co.uk" <delete007 (AT) blueyonder (DOT) co.uk> wrote in
news:dgE1d.5244$846.5153 (AT) fe2 (DOT) news.blueyonder.co.uk:


I'm using web forms to enter data into a database, so I want info
entered via the web form to be added to the existing data in it's
field in the data base.



Depends on how you are handling the web form (client-side, server-side,
what language, data pages, etc) but it comes down in the end to an INSERT
query:

INSERT INTO MyTable
(RowID, FName, LegLength, DateOfIssue)
VALUES
(1029, "Eric", 16.298, #2004-04-23#)

but it's probably up to you to build this string in the correct syntax for
the target database, and then to get the database to execute it.

Hope that helps


Tim F

Not sure what the etiquette is here but I've moved the posts so that they're
in order, top down.

"Tim Ferguson" <FergusonTG (AT) softhome (DOT) net> wrote in message
news:Xns9564B7A6DE0D7garbleme4455656 (AT) 207 (DOT) 46.248.16...
"news (AT) blueyonder (DOT) co.uk" <delete007 (AT) blueyonder (DOT) co.uk> wrote in
news:dgE1d.5244$846.5153 (AT) fe2 (DOT) news.blueyonder.co.uk:


I'm using web forms to enter data into a database, so I want info
entered via the web form to be added to the existing data in it's
field in the data base.



Depends on how you are handling the web form (client-side, server-side,
what language, data pages, etc) but it comes down in the end to an
INSERT
query:

INSERT INTO MyTable
(RowID, FName, LegLength, DateOfIssue)
VALUES
(1029, "Eric", 16.298, #2004-04-23#)

but it's probably up to you to build this string in the correct syntax
for
the target database, and then to get the database to execute it.

Hope that helps

"news (AT) blueyonder (DOT) co.uk" <delete007 (AT) blueyonder (DOT) co.uk> wrote

Thanks.

My Knowledge of SQL is lacking to say the least. So I'll have to look for
an
automated way of doing this in dreamweaver ?

As this is a DW group then I'm assuming that your using DW to do this?

I'm also assuming that you've set up a connection to the database, etc so
that dynamic elements will show up?

If this is the case then on the insert menu there is a tab for application.
One of the icons on there allows you to create an insert record form. Click
this icon and then map your form elements to your table. It's a 2 minute
job.