Updating a textarea

[trojnfn]

How do I update a textarea on my form ? I have <input type="text"
name="fieldname"> fields and <textarea name=textarea_fieldname> fields. Afte
the form is displayed and I make my changes on the screen, I submit the form
and go to the action page to peform an update to the db. The sql update is set
fieldname = '#form.fieldname#', etc. How do I update the textarea ? It will
not accept form.texarea_fieldname.

[Dan Bracuk]

What is the actual error message?
In your post, the names don't match. Is that the case in your real code also?

form field = tex ==> t <== area_fieldname
won't accept = form.tex ==> <== area_fieldname

Originally posted by: trojnfn
How do I update a textarea on my form ? I have <input type="text"
name="fieldname"> fields and <textarea name=textarea_fieldname> fields. Afte
the form is displayed and I make my changes on the screen, I submit the form
and go to the action page to peform an update to the db. The sql update is set
fieldname = '#form.fieldname#', etc. How do I update the textarea ? It will
not accept form.texarea_fieldname.

[trojnfn]

The actual error message is FORM.TEXTAREA_FIELDNAME does not exist. It does not
allow form for textarea but does allow form for regular <input> or <cfinput>.
Again, I have a form that I want to update. It is layed out like this :

<form action="form_action.cfm" name="form" type="post">
<cfinput type="text" name="field_1" value="#field_1#">
<cfinput type='text" name="field_2" value='#field_2#'>
<textarea name="textarea_field" rows=4 cols=100>#textarea_field#</textarea>
<input type="submit" value="submit">
</cfform>

Once all of the data is displayed, I make my changes and submit the form.

The action page does a sql update :

<cfquery="query" datasource="datasouce_name">
===
set field_1 = '#form.field_1#"'
field_2="#form.field_2#'
textarea_field = #form.textarea_field#

I can update field_1 and 2 in the database with values from form.field_1 and
2. But I cannot seem to update the textarea field because it does not like
form.textarea_field. If I make the textarea into a input type=text field, it
will cause the screen to scroll forever becaue of the columns, but at least it
does update. Again, how do I update a textarea using sql update ?

[Dan Bracuk]

This is indeed odd. What happens if you do a cfdump var="#form#" at the very
start of your page?

Originally posted by: trojnfn
The actual error message is FORM.TEXTAREA_FIELDNAME does not exist. It does
not allow form for textarea but does allow form for regular <input> or
<cfinput>. Again, I have a form that I want to update. It is layed out like
this :

<form action="form_action.cfm" name="form" type="post">
<cfinput type="text" name="field_1" value="#field_1#">
<cfinput type='text" name="field_2" value='#field_2#'>
<textarea name="textarea_field" rows=4 cols=100>#textarea_field#</textarea>
<input type="submit" value="submit">
</cfform>

Once all of the data is displayed, I make my changes and submit the form.

The action page does a sql update :

<cfquery="query" datasource="datasouce_name">
===
set field_1 = '#form.field_1#"'
field_2="#form.field_2#'
textarea_field = #form.textarea_field#

I can update field_1 and 2 in the database with values from form.field_1 and
2. But I cannot seem to update the textarea field because it does not like
form.textarea_field. If I make the textarea into a input type=text field, it
will cause the screen to scroll forever becaue of the columns, but at least it
does update. Again, how do I update a textarea using sql update ?

[Kronin555]

If that form is cut/pasted from your actual code, it looks like you're mixing
up single and double quotes...

<form action="form_action.cfm" name="form" type="post">
<cfinput type="text" name="field_1" value="#field_1#">
<cfinput type='text" name="field_2" value='#field_2#'> <!-- note single quote
before text, double quote to close it -->
<textarea name="textarea_field" rows=4 cols=100>#textarea_field#</textarea>
<input type="submit" value="submit">
</cfform>

Not sure if that's enough to throw it off, but it's best to have good, clean
code regardless.

Also, in your query, you need to surround #form.textarea_field# with single
quotes.

[trojnfn]

My code in the post is just a sample, so ignore the typos. Below is my actual
code that I use to update :

<cfset session.requestor_name = '#form.requestor_name#'>
<cfset session.location = '#form.location#'>
<cfset session.building = '#form.building#'>
<cfset session.room_number = '#form.room_number#'>
<cfset session.mail_station = '#form.mail_station#'>
<cfset session.phone_no = '#form.phone_no#'>
<cfset session.pickup_date = '#form.pickup_date#'>
<cfset session.pickup_time = '#form.pickup_time#'>
<cfset session.pickup_address_1 = '#form.pickup_address_1#'>
<cfset session.pickup_address_2 = '#form.pickup_address_2#'>
<cfset session.pickup_city = '#form.pickup_city#'>
<cfset session.dropoff_address_1 = '#form.dropoff_address_1#'>
<cfset session.dropoff_address_2 = '#form.dropoff_address_2#'>
<cfset session.dropoff_city = '#form.dropoff_city#'>
<cfset session.no_of_passengers = '#form.no_of_passengers#'>
<cfset session.type_of_vehicle = '#form.type_of_vehicle#'>
<cfset session.contact_name = '#form.contact_name#'>
<cfset session.contact_phone = '#form.contact_phone#'>
<cfset session.contact_cost_center = '#form.contact_cost_center#'>
<cfset session.comments = '#form.comments#'>

<cfif form.submit_button is "Update">
<cfquery datasource="Charter_Services_db">
update tblCharter_Services
set requestor_name = '#session.requestor_name#',
location = '#session.location#',
building = '#session.building#',
room_number = '#session.room_number#',
mail_station = '#session.mail_station#',
phone_no = '#session.phone_no#',
pickup_date = '#session.pickup_date#',
pickup_time = '#session.pickup_time#',
pickup_address_1 = '#session.pickup_address_1#',
pickup_address_2 = '#session.pickup_address_2#',
pickup_city = '#session.pickup_city#',
dropoff_address_1 = '#session.dropoff_address_1#',
dropoff_address_2 = '#session.dropoff_address_2#',
dropoff_city = '#session.dropoff_city#',
no_of_passengers = '#session.no_of_passengers#',
type_of_vehicle = '#session.type_of_vehicle#',
contact_name = '#session.contact_name#',
contact_phone = '#session.contact_phone#',
contact_cost_center = '#session.contact_cost_center#',
comments = '#session.comments#'
where service_req_no = '#session.service_req_no#';
</cfquery>

The field name comments is my textarea and that is where I am having problems.
I am able to make the changes on the screen but the changes will not update the
database, the original data is still there.

[Kronin555]

And in your debug information, FORM.comments is being submitted? and has the
information you expect?

What if you dump SESSION.comments right before the cfquery update call? is it
what you expect?

Why are you storing the FORM variables in SESSION variables?

[jdeline]

Is session.service_req_no defined in your database as a numeric value? If so,
you need to remove the single quotes around the variable in your WHERE clause.
Also, does the database you're using accept a semi-colon at the end of an SQL
statement?

I also think you would learn something if you place <CFDUMP VAR=#session#>
just before you do your update.

[trojnfn]

I put <cfdump> before the update and get this error :

ColdFusion cannot determine how to process the tag <CFDUMP>. The tag name may
be misspelled.

If you are using tags whose names begin with CF but are not ColdFusion tags
you should contact Allaire Support.


The error occurred while processing an element with a general identifier of
(CFDUMP), occupying document position (36:1) to (36:31).

Is <cfdump> only on MX ? I cannot find it in the book and I am not running MX
on this servier (our other one has MX).

[Dan Bracuk]

<cfdump> starts with version 5. What version are you running>

Originally posted by: trojnfn
I put <cfdump> before the update and get this error :

ColdFusion cannot determine how to process the tag <CFDUMP>. The tag name may
be misspelled.

If you are using tags whose names begin with CF but are not ColdFusion tags
you should contact Allaire Support.


The error occurred while processing an element with a general identifier of
(CFDUMP), occupying document position (36:1) to (36:31).

Is <cfdump> only on MX ? I cannot find it in the book and I am not running MX
on this servier (our other one has MX).

[jdeline]

You have to tell CF what to dump. <CFDUMP> by itself won't do the job. Do <CFDUMP VAR=#session#> as I posted previously.