I have a memo type form field that i want to be able to update. HOw do I prepopulate the field with existing data? I don't want to erase existing data so I am assuming I have to prepopulate it otherwise I will overwrite it when adding the new data.

I've been using Cold Fusion and with that they use this:

value="#TRIM(TableName.FieldName)#"

Thanks

Trevor Lyman

What are you using now?

Im still using CF but but CFInsert doesn't work with memo fields (I'm not sure why) so I have to use straight sql in this case.



Trevor Lyman

Perhaps you can use the SQL CONVERT or CAST functions to change the source field into a datatype that CF can handle. Of course, you risk truncation with this, but it might be your only hope.

Peter
------------------------------------------------------
Work smarter, not harder.

HI- thanks- I'm actually looking to do it in sql. THat's why I'm posting to this forum. Is there a way to do it with SQL?

Thanks

Trevor Lyman

Ok, I'm a little confused. Can you explain in more explicit detail exactly what you are doing? You mentioned that you are using cold fusion, so you are obviously building a web application of some sort. However it is not apparent (to me at least) exactly what the problem is. Is the problem getting the data or saving the data?

I don't understand how you intend to "do it in sql". SQL will give you the data, but you need to get it onto the page somehow. What exactly are you trying to accomplish?

After looking back at your posts, perhaps I understand what the problem is....
Are you asking how to insert data into SQL using straight T-SQL syntax versus using the cold fusion object methods? If that's the case then maybe this will help:

INSERT INTO tablename(field, field, ...) VALUES(value, value, ...)

Peter
------------------------------------------------------
Work smarter, not harder.

HI- thanks for the help- yes the end of your post is what I am looking to do...except when I call the form up if there is pre-existing data in the dbase for that field I want it to populate that form. This way when I press submit I don't overwrite and erase what is already there with my additional data. Basically it is for a notes section. I want to be able to add to/ edit my notes- so I don't want to erase what is already there. I need to pre populate the form field with the data from the dbase. I know how to do everything else. Thanks!

Trevor Lyman

Presumably you will have populated your form with the data that is currently in the database when the page loads. If you cange and/or add to this data then surly you want to write all of the text back to the database.

The only thing I can think of is that the page never gets loaded with the information already in the database, so when you want to add extra information all you have is that extra information and not what is currently in the database.

In this case you will want a query that is something like this:

 I am not sure if that query will actually work though, at least it gives you an idea.

Regards
Owain Williams