This code will do the trick efficiently:
<cfquery name="myquery" datasource="yourdsn">
UPDATE Tablename
SET SomeField = '#ReplaceNoCase(form.somefield, " ", "", "ALL")#'
WHERE ID = #Val(form.id)#
</cfquery>
Note that ReplaceNoCase operates faster than Replace, so is preferred
if character case does not matter.
Chris Tweney
Media Application Developer
roundpeg
www.roundpeg.com
1700 California Suite 260
San Francisco, CA. 94109
Ph. 415-437-3900
Fax 415-437-3904
> -----Original Message-----
> From: AustralianAccommodation.com Pty. Ltd.
> [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, June 03, 2000 10:46 PM
> To: [EMAIL PROTECTED]
> Subject: removing space between words being uploaded to a database
>
>
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0021_01BFCE3C.048BE5A0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> can I ask what the code is to remove spaces between words so
> that I can =
> update the database with the values minus the blank spaces
>
>
> Kind Regards
>
> Claude Raiola (Director)
> AustralianAccommodation.com Pty. Ltd.
> Website: www.AustralianAccommodation.com
> Email: [EMAIL PROTECTED]
>
> ------=_NextPart_000_0021_01BFCE3C.048BE5A0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META content=3D"text/html; charset=3Diso-8859-1" =
> http-equiv=3DContent-Type>
> <META content=3D"MSHTML 5.00.2722.2800" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>can I ask what the code is
> to remove =
> spaces between=20
> words so that I can update the database with the values minus
> the blank=20
> spaces</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Kind Regards</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Claude Raiola=20
> (Director)<BR>AustralianAccommodation.com Pty. Ltd.<BR>Website: <A=20
> href=3D"http://www.AustralianAccommodation.com">www.Australian
> Accommodati=
> on.com</A><BR>Email:=20
> <A=20
> href=3D"mailto:[EMAIL PROTECTED]">Director@
> AustralianA=
> ccommodation.com</A></FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_0021_01BFCE3C.048BE5A0--
>
> --------------------------------------------------------------
> ----------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/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.
------------------------------------------------------------------------------
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.
