Append Data to Field

[news]

Hi all, I haven't used access for a while and was wondering how you append
data to existing data in that field.

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.

Thanks

Paul.

 

[Tim Ferguson]

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

 

[news]

Thanks.

My Knowledge of SQL is lacking to say the least. Is there any automated way
of doing this in dreamweaver ?

Thanks Again.

 

[news]

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]

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 ?

Ummm... try a Macromedia support group? If you have problems with the
tables and schema layout and design we can probably help. This is very much
focussed on Jet and Access.

All the best


Tim F

 

[news]

Thanks Tim
I'll Ask on Dreamweaver newsgroup.

Paul.