Append to a field in a database

Hey guys,
I am working on some ASP stuff, and I have an html table which displays records from a SQL table.There is one field for adding notes which i want to append to. Basically I have a textbox, in which if a user enters information, it should be appended to a field (rNotes) in my database table. Right now all i can get it to do is overwrite the current information as i'm using an UPDATE query. Any ideas?In update statement you should use:

Update table_name set
column_name = column_name + new_data
where ....|||

Quote:

Originally Posted by nikhil86

Hey guys,
I am working on some ASP stuff, and I have an html table which displays records from a SQL table.There is one field for adding notes which i want to append to. Basically I have a textbox, in which if a user enters information, it should be appended to a field (rNotes) in my database table. Right now all i can get it to do is overwrite the current information as i'm using an UPDATE query. Any ideas?

Personally, I would create a notes table, and add records. This way, you can also store things like date/time, user id, etc. You can then just display them in sequential order. I do this with ASP all the time. Just did it yesterday, as a matter of fact. The client loved it.

Good luck,

Michael C. Gates

Anyway to do cell spacing?

In a matrix cell one can set padding, but I do not find any way to set
spacing between cells (like cellspacing in HTML). Is there any way to do this?
It would make the report easier to read if one uses background color.
Regards
MaranHave you tried setting a larger border size to a cell and setting the
border color to the appropriate background color?
Might effectively give you the same thing.
Andy Potter|||Thx, that made it :)
Maran
*************
"Potter" wrote:
> Have you tried setting a larger border size to a cell and setting the
> border color to the appropriate background color?
> Might effectively give you the same thing.
> Andy Potter
>