Append Form Data to Database Field

N

news

My Knowledge of SQL Is sadly lacking. Is there an automated way to do this
within dreamweaver?


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.
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
Help needed passing data from the form to a table. 0
Append New Record Via A Form? 1
Append new data from different database 1
Link Form to Access Database thru DSN 0
Blank fields become disabled after database query and submit to SP 0
Protect data entered in fields in form 2
Append with criteria exceptions 1

Top