[erocktroll]

Hi all. Any CFML programmers out there???

Here's my situation. Until yesterday, I had never seen or attempted to make sense of any CFML code. Now, a guy in a remote office of ours who claimed to know how to write CFML has turned out to be pretty much useless. I'm doing okay with the CFML for the most part, thanks to Dreamweaver's drag and drop interface, but I have a problem.

I'm creating some very basic pages to access a single table in a MySQL database. I've made a page that shows all of the records, and I can select a record to edit. When I get to the edit page, I have the update command only updating certain fields, and the other fields are display only. What I want to be able to do is append the data that the user types in the field to the end of what is already there. The field is a problem description, so if the first person types "No Sound" and the second person types "Sound card driver failed", I end up with "No Sound., Sound card driver failed."

I know that SQL has a concat function, and I see that cold fusion uses an & to concat. What I'm having difficulty with is getting it to concatenate the correct fields. The edit page displays a record based on a url variable (parameter?) that is passed in from the link the user clicks.
The edit page's select statement uses a where clause that has where=#recordid#, where recordid is the parameter from the url. I need the concat statement to combine the current value of the field with the input value of the field. What's happening with the statement I wrote is that it is always doing the concat on record1 and the input field. I can't seem to get it to use the record number of #recordid#.

I know this question is long and probably doesn't make much sense, but I'm so incredibly new to this, I'm not sure how to phrase it any better. If anyone can help, I'd greatly appreciate it...and if seeing the CFM pages that I have would help, I can do that to.

Thanks all so much!!

Erin