Help - Extra Characters

[ErinT]

:confused;

Hi. I'm a painfully inexperienced person that has recently been handed the
task of creating a database and a web interface to work with it. It's going
pretty well, and I like cold fusion. However, I have a problem I can't seem to
figure out.

I've created a dozen forms that all seem to be working fine, except one. I
have one field, on one page, that adds blank characters each time the page is
brought up, evenutally causing the field to hit it's character max in the
database and generating truncation errors. I can't figure out why it's doing
it. If anyone can help, that would be great. i tried, as a temporary fix,
using the trim() function to remove extra characters,and it's helping, but I'm
still ending up with 22 blank characters in the field. If anyone can tell me
what's wrong, I'd be forever greatful....

Here's the code for the form field.
<textarea name="ChannelsAffected" cols="50" rows="2" onkeyup="update();" >
<cfif isdefined
('form.channelsaffected')><cfoutput>#trim(form.cha nnelsaffected)#</cfoutput>
<cfelse><cfif
isDefined('channels.channelsaffected')><cfoutput># trim(channels.channelsaffected
)#</cfoutput></cfif>
</cfif>
</textarea>

and here is the code that inserts it into the database:

<cfif (IsDefined ("Form.ChannelsAffected") AND #trim(Form.ChannelsAffected)#
NEQ "")>
<cfif channels.recordcount GT 0>
<cfquery datasource="#KBDB#" username="#KBUSER#" password="#KBPW#">
Update bullpenrca set ChannelsAffected=
'#trim(Form.ChannelsAffected)#'
where bullpenlogid=#form.bullpenlogid#
</cfquery>
<cfelse>
<cfquery datasource="#KBDB#" username="#KBUSER#" password="#KBPW#">
INSERT INTO bullpenrca (BullpenLogID, ChannelsAffected, Employee) VALUES
(
<cfif IsDefined("FORM.BullpenLogID") AND #FORM.BullpenLogID# NEQ "">
'#CurrentID#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.ChannelsAffected")>
'#trim(FORM.ChannelsAffected)#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.Name") AND #FORM.Name# NEQ "">
'#form.Name#'
<cfelse>
NULL
</cfif>
)
</cfquery>
</cfif>

[ErinT]

:confused;

Hi. I'm a painfully inexperienced person that has recently been handed the
task of creating a database and a web interface to work with it. It's going
pretty well, and I like cold fusion. However, I have a problem I can't seem to
figure out.

I've created a dozen forms that all seem to be working fine, except one. I
have one field, on one page, that adds blank characters each time the page is
brought up, evenutally causing the field to hit it's character max in the
database and generating truncation errors. I can't figure out why it's doing
it. If anyone can help, that would be great. i tried, as a temporary fix,
using the trim() function to remove extra characters,and it's helping, but I'm
still ending up with 22 blank characters in the field. If anyone can tell me
what's wrong, I'd be forever greatful....



Here's the code for the form field.
<textarea name="ChannelsAffected" cols="50" rows="2" onkeyup="update();" >
<cfif isdefined
('form.channelsaffected')><cfoutput>#trim(form.cha nnelsaffected)#</cfoutput>
<cfelse><cfif
isDefined('channels.channelsaffected')><cfoutput># trim(channels.channelsaffected
)#</cfoutput></cfif>
</cfif>
</textarea>

and here is the code that inserts it into the database:

<cfif (IsDefined ("Form.ChannelsAffected") AND #trim(Form.ChannelsAffected)#
NEQ "")>
<cfif channels.recordcount GT 0>
<cfquery datasource="#KBDB#" username="#KBUSER#" password="#KBPW#">
Update bullpenrca set ChannelsAffected=
'#trim(Form.ChannelsAffected)#'
where bullpenlogid=#form.bullpenlogid#
</cfquery>
<cfelse>
<cfquery datasource="#KBDB#" username="#KBUSER#" password="#KBPW#">
INSERT INTO bullpenrca (BullpenLogID, ChannelsAffected, Employee) VALUES
(
<cfif IsDefined("FORM.BullpenLogID") AND #FORM.BullpenLogID# NEQ "">
'#CurrentID#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.ChannelsAffected")>
'#trim(FORM.ChannelsAffected)#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.Name") AND #FORM.Name# NEQ "">
'#form.Name#'
<cfelse>
NULL
</cfif>
)
</cfquery>
</cfif>

[Stressed_Simon]

All the cfifs you are using in your text area leave blank spaces once they are
removed by the CF Administrator.

The easiest way to prevent this is to take the cfifs to outside the textarea
and then set a varaiable dependent on what you want and then output the
variable.

Like this:-

<cfset TextContent = "">
<cfif isdefined ('form.channelsaffected')>
<cfset TextContent = trim(form.channelsaffected)>
<cfelse>
<cfif isDefined('channels.channelsaffected')>
<cfset TextContent = trim(channels.channelsaffected)>
</cfif>
</cfif>


<textarea name="ChannelsAffected" cols="50" rows="2" onkeyup="update();"

><cfoutput>#Trim(TextContent)#</cfoutput></textarea>

[ErinT]

thank you so much! i'm going to give this a try, and i'll come back and let you know what happens. I REALLY appreciate the response!!!!!!!!!

[mkane1]

Anything you put between the opening textarea and closing /textarea will appear
in the box. Including spaces. I can't tell if you have spaces or TAB characters
in front of your cfif statements in that area, but I suspect that is where the
unwanted spaces are coming from.

I suggest that you determine what value should appear in the box before the
textarea statement. One suggestion would be to create an exmpty variable, set
to blank, i.e. cfset channelsaffectedval = "" and then using your cfifs set it
to either the form or query value. Then after the opening textarea just output
the channelsaffectedval

I also recommend putting the cfoutput tags outside of the texarea, and not
inside.

Finally, I would look at what the update() javascript function does. By
calling it in the onkeyup event, every time the user releases a key press while
in that box, the function is called. If it writes back to the value, it may be
adding spaces.