gotcha...
the answer then, is not so good! :^) Unless anyone knows better, I
think that you'll have to use a CFQUERY to Insert the records rather than
CFINSERT.
That way you can do the Replace() on the field.
hmmm... the only other thing you could try, and I'm not sure if this will
work, is to try doing a CFSET fieldname = Replace(fieldname, " ", "",
"ALL") before calling the CFINSERT. this would keep the formname the same,
but I haven't tried this, so I don't know if it will work. I guess it
depends on whether CFINSERT looks for variables formname or form.formname.
Nick
At 22:53 29/05/00 -0500, you wrote:
>At 10:31 AM 5/30/00 +1000, you wrote:
> >Try Replace(Form.Field, " ", "")
> >
> >Nick
>
>
>Hmm. Yeah, I get this in concept of using a CFOUTPUT.. ie,
>#replace(Form.Field," ","") however, I'm trying to get this all to execute
>in the form input command when it inserts records.. *shrug* I know I am
>missing something obvious here.. it's just too late at night ;)
>
>------------------------------------------------------------------------------
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
