Hi cftalk:
We are running CF8.
I am seeing a strange application error ScriptProtect error replacing insecure
tag in scope CGI. The error occurred on line -1..
Strangely, there are very few google references to this error, and absolutely
no explanations / solutions that I can find.
We
However, we get this ScriptProtect error if we pass in the URL:
http://www.SERVER.com/search.cfm?querystring=javascript:alert%28412898284482%29
Clearly this has nothing to do with the CGI scope, so I'm a little confused
at why an error is being thrown.
It does, in fact, have something to
This wouldn't match anchor tags with upper case,
but could be changed like so:
/?[a|A][^]*
You've got two syntaxes mixed up there.
(?:a|A) or [aA] is what you want - no bar needed for square brackets.
And I think it might be best to use a lazy match:
/?[a|A][^]+
That's not a lazy
Good call on the parens. I had those in the original since I had ripped
from code that did use the /1 element later on. Also, you could use
#reReplaceNoCase()# as an alternative to [aA] ... but I like the [aA]
better, for no particular reason.
Hey all,
I'm trying to replace a hyperlink and just display the text. I need to
remove the a href=http://www.google.ca;www.google.ca
http://www.google.ca%3c/a /a from text within fckeditor and just display
the text www.google.ca I tried finding a setting for the editor so it
doesn't
Try this:
cfset ad = reReplace(form.addesc, (/?a[^]*), , all) /
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com]
Sent: Wednesday, August 19, 2009 2:38 PM
To: cf-talk
Subject: re: Replacing characters in a string
Try this:
cfset ad = reReplace(form.addesc, (/?a[^]*), , all
Hello Andy Jason,
Thank you so much, this worked well. I wasn't sure of the syntax so this
really helped.
Kind regards,
Rick
-Original Message-
From: Andy Matthews [mailto:li...@commadelimited.com]
Sent: August-19-09 6:19 PM
To: cf-talk
Subject: RE: Replacing characters in a string
Data is cut-pasted from Word (I think), then inputted via form text area to
database. When outputting data, some characters such as apostrophies and dashes
display as little squares. I need to fix this somehow. First thought is to
replace the characters on output, but I don't even know what
cflib has a function called demoronize. some rich text editors have a
special paste from Word button that attempt to clean up the smart quotes
and other crappy MS characters.
however, it's been my experience that neither these (nor any other automated
method that I've heard of) is bulletproof.
Thanks Charlie,
I just tried DeMoronize, and it did not even touch it. Worth a try though. I
wish there was something effective. I get people cutting-pasting from Word,
Publisher, all sorts of programs always with problems. I always suggest pasting
in MS Notepad first to clean it up, but the
Personally I use this function which also replace HTML codes by true iso
characters
(HTML codes cause search requests to fail):
function toIso(text)
{
var html =
##201;,aacute;,agrave;,acirc;,aelig;,aring;,atilde;,auml;,
eacute;,egrave;,euml;,ecirc;,iacute;,igrave;,iuml;,icirc;,
I've often thought about pulling apart the JavaScript that's in use by tinyMCE
or fckEditor and building a server-side filter to get content into the DB
clean, but I haven't found the time. May be worth a look. They're open
source, so dig through the editor functions to find the cleanWord()
hi guys,
i have some text as follows...
bulletblah blah/bullet
bulletblah blah/bullet
bulletblah blah/bullet
bulletblah blah/bullet
i need to insert this into a text field using proper html eg. ulli for the
lists. so i need to replace the first occurrence of bullet with ulli, and
the last
Simple and hackish is to just reverse the string, replace tellub/
with lu/il/, and then reverse the string again. If you know the
final /bullet is at the end of the string, you could use
/bullet$ in REReplace.
cheers,
barneyb
On Fri, Dec 5, 2008 at 2:35 PM, Mike Little [EMAIL PROTECTED] wrote:
thanks heaps barneyb...
cfset new_text = reverse(trim(mytext))
cfset new_text = replaceNoCase(new_text, tellub/, lu/il/, One)
cfset new_text = reverse(new_text)
cfset new_text = replaceNoCase(new_text, bullet, ulli, One)
cfset new_text = replaceNoCase(new_text, bullet, li, All)
cfset new_text =
scope creep!
On Fri, Dec 5, 2008 at 3:40 PM, Mike Little [EMAIL PROTECTED] wrote:
thanks heaps barneyb...
cfset new_text = reverse(trim(mytext))
cfset new_text = replaceNoCase(new_text, tellub/, lu/il/,
One)
cfset new_text = reverse(new_text)
cfset new_text = replaceNoCase(new_text,
My cftextarea just outputted it straight from the field and voila,
there's a bunch of those chars in my output. I still don't understand
how they're gettin there.
hrm... that sounds like either a bug in ColdFusion or an issue with the
browser... I believe that one or the other is supposed to
There's a problem with my xForm which causes it to output a ton of these in a
textarea.
#13;
I'm trying to do a replace on it so they won't show up.
#Replace(retProductInventory.prodlongdescription, ###13;,, All)#
Doesn't work.
One # throws an error. Two doesn't do anything. Three doesn't
ok, that was supposed to be ampersandPound13Semicolon being replaced.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Two #'s should do it. If it's not working, you might be replacing them in
the wrong place.
What's the code look like in context?
Adrian
http://www.adrianlynch.co.uk/
-Original Message-
From: Will Tomlinson
Sent: 30 December 2007 18:06
To: CF-Talk
Subject: Replacing these chars
Two #'s should do it. If it's not working, you might be replacing them in
the wrong place.
What's the code look like in context?
Adrian
cfset chartoReplace = ##13;
cftextarea name=prodlongdesc label=Long Description required=yes
validate=noblanks validateat=onserver,onsubmit
value=#replace
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 30, 2007 1:06 PM
To: CF-Talk
Subject: Replacing these chars
There's a problem with my xForm which causes it to output a ton of
these in a textarea.
#13;
Do you actually see this string
Will Tomlinson wrote:
cfset chartoReplace = ##13;
cftextarea name=prodlongdesc label=Long Description required=yes
validate=noblanks validateat=onserver,onsubmit
value=#replace(retProductInventory.prodlongdescription, charToReplace, ,
All)# cols=70 rows=10/cftextarea
Do you actually see this string? That's the character entity for a Carriage
Return - like you get when you hit enter.
Yes. When I view the source, those characters are in there. Each time you save
the form, they keep building upon themselves.
I'm not using wrap here, I'll give that a shot!
cfset chartoReplace = ##13;
cftextarea name=prodlongdesc label=Long Description
required=yes validate=noblanks validateat=onserver,onsubmit
value=#replace(retProductInventory.prodlongdescription,
charToReplace, , All)# cols=70 rows=10/cftextarea
I had quotes around my variable name. It needed to be written like this:
#replace(retProductInventory.prodlongdescription, charToReplace, , All)#
Thanks to all...
Will
~|
Adobe® ColdFusion® 8 software 8 is the most important
What Jim said and, do you get them if you just output
retProductInventory.prodlongdescription to screen?
Adrian
http://www.adrianlynch.co.uk/
-Original Message-
From: Jim Davis
Sent: 30 December 2007 19:03
To: CF-Talk
Subject: RE: Replacing these chars
-Original Message-
From
I had quotes around my variable name. It needed to be written like this:
#replace(retProductInventory.prodlongdescription, charToReplace, , All)#
Thanks to all...
Just FYI, I'm not aware that htmleditformat() or xmlformat() replace
those characters with any kind of entities (I could be
Ok, I gotcha.
In this process there's nothin extra really goin on. It's a simple update.
It goes into the cfc like this:
prodlongdesc=#Trim(FORM.prodlongdesc)#
The cfc does this in the query:
prodlongdescription = cfqueryparam cfsqltype=cf_sql_longvarchar
value=#ARGUMENTS.prodlongdesc#
My
Hey list,
I'm trying to replace a double quote in a text field to a single quote. I've
tried using ReReplace, but it still crashes the Cold Fusion server.
What I've done is this:
cfoutput#REReplace(dills,,',ALL)#/cfoutput
See, users tend to like using double quotes in a text field which
Try:
cfoutput#REReplace('dills','',',ALL)#/cfoutput
Marius Milosav
ScorpioSoft Corp.
www.scorpiosoft.com
-Original Message-
From: Rick Sanders [mailto:[EMAIL PROTECTED]
Sent: November 1, 2007 8:47 AM
To: CF-Talk
Subject: Replacing Strings
Hey list,
I'm trying to replace a double
use single quotes in your replace function (and you don't need REReplace
just FYI).
REReplace('dills','',',ALL)
-Original Message-
From: Rick Sanders [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 01, 2007 7:47 AM
To: CF-Talk
Subject: Replacing Strings
Hey list,
I'm trying
is in queries, make
sure to use cfqueryparam, which handles escaping the double quotes,
single quotes, etc. If you need to capture the user input in another
form field, you might want to try replacing with the html safe
equivalent quot;
#replace(mystring, , quot;, ALL)#
Hope that helps.
Cheers,
Kris
are you using cfqueryparam's on your query? It should escape them on its own I
would think.
~|
ColdFusion is delivering applications solutions at at top companies
around the world in government. Find out how and where now
replace('dills', '', ', all)
In other words, where you are explicitly writing double-quotes (like for
the find string) wrap in single quotes, and where you are explicitly
writing single quotes (like the replace string) wrap in double quotes.
--Ben Doom
Rick Sanders wrote:
Hey list,
:42 AM
To: CF-Talk
Subject: Re: Replacing Strings
are you using cfqueryparam's on your query? It should escape them on its own
I would think.
~|
ColdFusion is delivering applications solutions at at top companies
around
Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: November-01-07 10:46 AM
To: CF-Talk
Subject: RE: Replacing Strings
use single quotes in your replace function (and you don't need REReplace
just FYI).
REReplace('dills','',',ALL)
-Original Message-
From: Rick Sanders [mailto
-01-07 11:42 AM
To: CF-Talk
Subject: Re: Replacing Strings
are you using cfqueryparam's on your query? It should escape them on its own
I would think.
~|
Download the latest ColdFusion 8 utilities including Report
On Nov 1, 2007 7:44 AM, Rick Sanders [EMAIL PROTECTED] wrote:
Didn't think of that, but it's less code to do a replace than the
cfqueryparam.
the cfqueryparam buys you more.
and you should be using it anyway.
--
Charlie Griefer
...All the
: 919-799-9076
Canada: www.webenergy.ca
USA: www.webenergyusa.com
-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]
Sent: November-01-07 12:10 PM
To: CF-Talk
Subject: Re: Replacing Strings
Not to put too fine a point on it, but if this data is coming directly
from
!
Kind regards,
Rick Sanders
Canada: 902-401-7689
USA: 919-799-9076
Canada: www.webenergy.ca
USA: www.webenergyusa.com
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: November-01-07 10:46 AM
To: CF-Talk
Subject: RE: Replacing Strings
use single
: Replacing Strings
Bigger rookie mistake is not using cfqueryparam.
Adam Haskell
http://cfrant.blogspot.com
On 11/1/07, Rick Sanders [EMAIL PROTECTED] wrote:
Hi Andy,
Thanks for your response. I can't believe I made the rookie mistake of not
using single quotes instead of double quotes
be...
not having to replace any kind of quotes. :-)
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Adam Haskell [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 01, 2007 11:28 AM
To: CF-Talk
Subject: Re: Replacing Strings
Bigger rookie
USA: www.webenergyusa.com
-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]
Sent: November-01-07 12:10 PM
To: CF-Talk
Subject: Re: Replacing Strings
Not to put too fine a point on it, but if this data is coming directly
from an end user, it would probably be in your
The null set is an adequate and equally useful replacement.
Dave Watts, CTO, Fig Leaf Software
Elequent and to the point as always LOL Thank you for the belly laugh!
Best Regards,
Dennis Powers
UXB Internet - A website design and Hosting Company
690 Wolcott Road
P.O. Box 6029
Wolcott, CT
While I'm certainly neither surprised or upset by the demise
of CFDJ, I always did get a lot of vicarious pleasure out of
the yearly CFDJ awards. Regardless of the value of such
awards (and no offense to any recipients or nominees) such a
popularity contest is always useful in one way or
On Monday 10 Sep 2007, [EMAIL PROTECTED] wrote:
Am I missing something here? Was there an announcement about CFDJ going
away?
I never even noticed it was there in the first place :-)
--
Tom Chiverton
Helping to continuously incentivize wireless IPOs
on: http://thefalken.livejournal.com
Folks,
While I'm certainly neither surprised or upset by the demise of CFDJ,
I always did get a lot of vicarious pleasure out of the yearly CFDJ
awards. Regardless of the value of such awards (and no offense to any
recipients or nominees) such a popularity contest is always useful in
one way or
How about a community driven award, for and by the community?
On 9/10/07, John Paul Ashenfelter [EMAIL PROTECTED] wrote:
Folks,
While I'm certainly neither surprised or upset by the demise of CFDJ,
I always did get a lot of vicarious pleasure out of the yearly CFDJ
awards. Regardless of the
How about a community driven award, for and by the community?
I plan on doing the CFeMmy awards again this year - and hope to have it run
much smoother and become more relevant this time around.
http://cfsilence.com/blog/client/index.cfm/2006/12/22/2006-CFeMmys--And-The-Winners-Are
Am I missing something here? Was there an announcement about CFDJ going
away?
Nothing on the cfdj main page.
Steve
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Monday, September 10, 2007 11:47 AM
To: CF-Talk
Subject: Re: Replacing the CFDJ awards ?
How
: Replacing the CFDJ awards ?
How about a community driven award, for and by the community?
On 9/10/07, John Paul Ashenfelter [EMAIL PROTECTED]
wrote:
Folks,
While I'm certainly neither surprised or upset by the demise of CFDJ,
I always did get a lot of vicarious pleasure out of the yearly
Scroll down a bit.
Am I missing something here? Was there an announcement about CFDJ going
away?
Nothing on the cfdj main page.
~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles
: DURETTE, STEVEN J (ATTASIAIT) [mailto:[EMAIL PROTECTED]
Sent: Monday, September 10, 2007 10:41 AM
To: CF-Talk
Subject: RE: Replacing the CFDJ awards ?
Am I missing something here? Was there an announcement about CFDJ going
away?
Nothing on the cfdj main page.
Steve
Am I missing something here? Was there an announcement about CFDJ going
away?
Nothing on the cfdj main page.
Steve
That's Steve, always late ;)
~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax
Regardless of the value of such awards (and no offense to any
recipients or nominees) such a popularity contest is always useful in
one way or another.
And that's my issue with itall it was was a popularity contest. Nominees
would win on name recognition alone, had nothing whatsoever to do
cfset thisTerm = Replace(thisTerm, ##38;, , all)
I'm using this code to attempt to replace #38; with because ; is
also a list delimiter in the array that this is being inserted into
It screws up the looping, without making this change..
My problem is this:
If I escape the pound sign ##
cfset thisTerm = Replace(thisTerm, ##38;, , all)
You have a space before in the first string, and not in the second.
Is it on purpose? Could it be the source of your problem.
--
___
REUSE CODE! Use custom tags;
See
PROTECTED]
Sent: Thursday, June 28, 2007 2:07 PM
To: CF-Talk
Subject: Re: Replacing with
cfset thisTerm = Replace(thisTerm, ##38;, , all)
You have a space before in the first string, and not in the second.
Is it on purpose? Could it be the source of your problem
It screws up the looping, without making this change..
Ok, which looping?
Can you show a bit more of the code?
~|
Create Web Applications With ColdFusion MX7 Flex 2.
Build powerful, scalable RIAs. Free Trial
, 2007 3:39 PM
To: CF-Talk
Subject: Re: Replacing with
It screws up the looping, without making this change..
Ok, which looping?
Can you show a bit more of the code?
~|
Upgrade to Adobe ColdFusion MX7
The most significant
hey guys,
i need to replace occurrences of 0,o,1 in a uid with valid characters.
the uid is in the form --XX
so each time an invalid character is found a random 'valid' character is
generated and inserted in its place?
really do not know where to start with this function.
any
Mike
please look this cflib UDF:
http://www.cflib.org/udf.cfm?id=437enable=1
Could be a good start point:
Generates a random 8-character password that is free of annoying easily
confused characters such as 1 or l, O or 0. This is done by taking a UUID,
combining parts of it into two-byte
I put a couple of these solutions together. It worked great.
Thank you everyone for your help.
I found that chr(28) is not the actual code for left double quote
copied from Word. It is the resulting code when we try to store the
actual code, chr(8220), to our Oracle DB. To cover new and old
and replacing
it with a single quote (though now I realize it should be a double-
quote). Here's a test that I did that shows the bad char and it's
number using asc(the_letter). Even though it goes through this
cleaning, it still shows a the chr(28) char. In addition, though it
doesn't show
Check out this UDF, http://www.cflib.org/udf.cfm?ID=725
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241779
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription:
Check out this UDF, http://www.cflib.org/udf.cfm?ID=725
I don't know why, but that didn't seem to remove the odd characters. I tried
adding my known problem char chr(28) but I suppose I didn't do it right
because I saw no change in the text. I also tried adding some chars that I saw
that it
I've used the following regex to remove non-ascii characters:
cfset variables.content = REReplaceNoCase ( variables.content,
[^\x00-\x7f], , ALL ) /
Obviously, it can be tweaked to remove any ranges that you want include/exclude.
On 5/31/06, daniel kessler [EMAIL PROTECTED] wrote:
Check out
)#, ',',',#chr(34)#,#chr(34)#);
}
I added the chr(28) which seems to be the left side of a smart quote
from Word but this doesn't seem to be cleaning that out and replacing
it with a single quote (though now I realize it should be a double-
quote). Here's a test that I did that shows the bad char
PROTECTED]
Sent: 23 March 2005 08:37
To: CF-Talk
Subject: RE: Extracting/Replacing URL's from text
Actually, this is a bit too simplified because what I needed was a way
to
search for url's in a body of text without knowing what they are.
Here's
what I came up with...a little custom tag called
-
-Original Message-
From: Dave Phillips [mailto:[EMAIL PROTECTED]
Sent: woensdag 23 maart 2005 8:37
To: CF-Talk
Subject: RE: Extracting/Replacing URL's from text
Actually, this is a bit
Hi folks,
I have a routine that needs to scan a body of text, grab all URL's in that
text, replace them with a different URL and append the URL found on to the
end of the new one. I'm looking specifically for function of CF Tag that
will 'replace' URL's in a body of text or at the very least
-
-Original Message-
From: Dave Phillips [mailto:[EMAIL PROTECTED]
Sent: woensdag 23 maart 2005 4:03
To: CF-Talk
Subject: Extracting/Replacing URL's from text
Hi folks,
I have a routine that needs to scan a body of text
Actually, this is a bit too simplified because what I needed was a way to
search for url's in a body of text without knowing what they are. Here's
what I came up with...a little custom tag called CF_GetLinkList.
If anyone can find holes in this, let me know...so far it seems to be
working
: Ryan Duckworth [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, February 01, 2005 4:25 PM
Subject: RE: Replacing variable text in a string
This works and is tested:
cfscript
yourString = set primary_assign_id = 123;
/cfscript
cfoutput
#REReplaceNoCase(yourString,set
Please disregard Ryan,
This is working fine, it seems that I left out a space before the Digit
statement.
Thanks
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and
:[EMAIL PROTECTED]
Sent: 02 February 2005 12:14
To: CF-Talk
Subject: Re: Replacing variable text in a string
Please disregard Ryan,
This is working fine, it seems that I left out a space before the
Digit
statement.
Thanks
Hello,
I would like replace a portion of a string that is a SQL statement generated by
my users via an interface that I have created. I have never used Regular
Expressions but from what I have heard about this task sounds like a candidate.
I would like to update a SQL statement that is
RERepalce(yourString,set primary_assign_id = [:digit:]{3},,all)
Should work, but has not been tested.
On Tue, 1 Feb 2005 12:57:51 -0500, Mickael [EMAIL PROTECTED] wrote:
Hello,
I would like replace a portion of a string that is a SQL statement generated
by my users via an interface that I
Hey Scott,
This is not working for me. I corrected the typo from Palace to place but
it is not working. Any Ideas?
Thanks
Mike
- Original Message -
From: Scott Stroz [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, February 01, 2005 2:04 PM
Subject: Re: Replacing
Communications
10983 Granada Lane
Overland Park, KS 66211
(913) 754-4272
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 01, 2005 2:43 PM
To: CF-Talk
Subject: Re: Replacing variable text in a string
Hey Scott,
This is not working for me. I corrected the typo
I have some apps that let's user input data intoa databases. Users ofter write a document in word then paste it's contents into a form field and submit to the website. Problem I am seeing are characters such as ', , - from Word get inputed as bizare symbols so when the test is displayed on the web
Eric Creese wrote:
I have some apps that let's user input data intoa databases. Users ofter
write a document in word then paste it's contents into a form field and
submit to the website. Problem I am seeing are characters such as ', ,
- from Word get inputed as bizare symbols so when the
http://www.cflib.org/udf.cfm?ID=725
On Tue, 21 Sep 2004 12:47:52 -0500, Eric Creese [EMAIL PROTECTED] wrote:
I have some apps that let's user input data intoa databases. Users ofter write a document in word then paste it's contents into a form field and submit to the website. Problem I am seeing
http://www.cflib.org/udf.cfm?ID=725
Pascal
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: 21 September 2004 19:48
To: CF-Talk
Subject: replacing characters
I have some apps that let's user input data intoa databases. Users
ofter
write a document in word
Hi All,
This is more of an IIS question but does anyone know how to redirect a
broken image file to a CFM template?
TIA,
Duane
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
img src="" >
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 ALAmersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
I believe you'd have to have the CFM set up in IIS as the 404 handler or
something like that.
John
-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 14, 2004 10:03 AM
To: CF-Talk
Subject: Replacing broken image with a CFM file
Hi All
Thanks. that did the trick!
Duane
_
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 14, 2004 10:15 AM
To: CF-Talk
Subject: RE: Replacing broken image with a CFM file
I believe you'd have to have the CFM set up in IIS as the 404 handler or
something like that.
John
What database are you using? This sounds like something that would be best
handled at the database level, instead of running it through CF.
- Original Message -
From: Richard Crawford
Actually, my question about replacing special characters (thanks to all
who answered, by the way
Deanna Schneider wrote:
What database are you using? This sounds like something that would be best
handled at the database level, instead of running it through CF.
Deanna,
I'm using SQL Server 7.The problem is that the field with the
characters to be replaced is a TEXT field, and you can't
Don't know SQL Server. Sorry. But, as for your 500 error - make sure that
show friendly http errors is turned off in your IE preferences. Then, you
should at least see more info.
- Original Message -
From: Richard Crawford
Deanna Schneider wrote:
What database are you using? This
Deanna Schneider wrote:
Don't know SQL Server. Sorry. But, as for your 500 error - make sure that
show friendly http errors is turned off in your IE preferences. Then, you
should at least see more info.
That in itself isn't an issue (I don't use IE if I can possibly avoid
it).I had hoped
I have a set of strings that contain carriage returns.I'd like to go
through and strip them out.I figure the REPLACE function would do the
job but I'm not sure how to refer to the carriage returns.
INPUT STRING:
I am a string with a
carriage return
OUTPUT STRING:
I am a string with a
I have a set of strings that contain carriage returns.I'd
like to go through and strip them out.I figure the REPLACE
function would do the job but I'm not sure how to refer to
the carriage returns.
INPUT STRING:
I am a string with a
carriage return
OUTPUT STRING:
I am a string
Richard,
Replace(inputstring,chr(13)chr(10),'','ALL')
Should do it
HTH
_
From: Richard Crawford [mailto:[EMAIL PROTECTED]
Sent: 07 June 2004 22:24
To: CF-Talk
Subject: Replacing special characters in a string
I have a set of strings that contain carriage returns.I'd like to go
The CR is ascii 13.I use Replace(myvar, Chr(13), , ALL). You may alsop
need to worry about line feeds which is character 10.
Tyler Clendenin
GSL Solutions
_
From: Richard Crawford [mailto:[EMAIL PROTECTED]
Sent: Monday, June 07, 2004 5:24 PM
To: CF-Talk
Subject: Replacing special
(string,chr(13)chr(10),all)
That should work too.
Hope this helps.
Dave
From: Richard Crawford [mailto:[EMAIL PROTECTED]
Sent: Monday, June 07, 2004 4:24 PM
To: CF-Talk
Subject: Replacing special characters in a string
I have a set of strings that contain
Actually, my question about replacing special characters (thanks to all
who answered, by the way) was part of a larger question.What I really
need to do is select all rows of one table, modify the value of one
field, and insert all of the rows, with that one modified field, into
another table
1 - 100 of 225 matches
Mail list logo