I need to strip (double quote) out of a string of characters. I tried the following but it bombed. Can anyone steer me in the right direction?
cfset newsym=replace(#qStockItems.Symbol#,,,ALL)
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
cfset newsym=replace(qStockItems.Symbol,'','','ALL')
You can use single ticks.NOte, no need for the #s either.
Doug
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 1:32 PM
To: CF-Talk
Subject: Replacing Characters
I need to strip (double
tags.
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 11:32 AM
To: CF-Talk
Subject: Replacing Characters
I need to strip (double quote) out of a string of characters. I tried the
following but it bombed. Can anyone steer me in the right
=replace(#qStockItems.Symbol#,'',,ALL)
note the single quotes ^ ^
Cheers,
barneyb
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 10:32 AM
To: CF-Talk
Subject: Replacing Characters
I need to strip (double quote) out of a string
Thanks
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 12:38 PM
To: CF-Talk
Subject: RE: Replacing Characters
cfset newsym=replace(qStockItems.Symbol,'','','ALL')
You can use single ticks.NOte, no need for the #s either.
Doug
Help!
I have HTML textarea I use to post info to my blog. If I copy/paste
content from Web pages and the content includes the single quote
apostrophe mark, it shows up in my form field as the square character. I
want to do replace for this character, but I can't seem to find the
ASCII code for
I have HTML textarea I use to post info to my blog. If I copy/paste
content from Web pages and the content includes the single quote
apostrophe mark, it shows up in my form field as the square character. I
want to do replace for this character, but I can't seem to find the
ASCII code for it.
.
cfoutput
cfloop from=1 to=#len(myString)# index=i
#mid(myString, i, 1)# - #asc(mid(myString, i, 1))#br /
/cfloop
/cfoutput
-Original Message-
From: Jake McKee [mailto:[EMAIL PROTECTED]
Sent: Friday, January 02, 2004 9:56 AM
To: CF-Talk
Subject: Replacing apstrophe from IE copy/paste
hello
i'm needing a bit of quick regex help... i've got the following
bit of code:
output = ReReplace(cfhttp.FileContent,'([[:alnum:]/
]+[[:alnum:]]+\.php+[[:alnum:]:;%-_\.\?/
=]?)','#CGI.SCRIPT_NAME#?section=#url.section#subsection=
#url.subsection#page=#url.page#fp=\1','ALL')
which replaces
: CF-Talk
CC:
Onderwerp: replacing all urls... with a class attribute
hello
i'm needing a bit of quick regex help... i've got the following
bit of code:
output = ReReplace(cfhttp.FileContent,'([[:alnum
Hi,
Whats the easist way to strip the last \ from var1 and insert a , (comma)?
var 1 = d:\temp\mywork\
Results: d:\temp\mywork,
~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137948
Archives:
Buhy,
How about
cfset result = reverse(replace(reverse(var),/,,))
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Monday, September 22, 2003 10:55 AM
To: CF-Talk
Subject: re: Stripping and replacing last \ from a variable
Hi,
Whats the easist way to strip the last
I assume - from your example - the variable should have a trailing \
var 1 = d:\temp\mywork\
Use this:
cfset var1 = d:\temp\mywork\
cfset var1 = #reverse(replace(reverse(var1), \, ,))#
Basically, you can only (easily) replace the first instance of something (or all, or
where you know where the
GetDirectoryFromPath()
Will probably do it...
HTH
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Monday, September 22, 2003 16:55
To: CF-Talk
Subject: re: Stripping and replacing last \ from a variable
Hi,
Whats the easist way to strip the last \ from var1
Whats the easist way to strip the last \ from var1 and insert a ,
(comma)?
try:
ReReplace(yourstring,\\$,,)
The $ character in regular expressions represents the end of a string,
and the \ had to be escaped (that's why it's there twice).
__
Pete Freitag
How can I break this string apart:
Target Present|Yes|Unit Replaced|Yes|Unit Replaced|No|Comment|Wet
So I get:
Target Present: Yes
Unit Replaced: No
Comment: Wet
...which is basically replacing every other | with different thing.
OK, something like:
#REPLACE
apart by replacing every other delimeter...
How can I break this string apart:
Target Present|Yes|Unit Replaced|Yes|Unit Replaced|No|Comment|Wet
So I get:
Target Present: Yes
Unit Replaced: No
Comment: Wet
...which is basically replacing every other | with
different thing
trying to code replacing every other
delimiter character, i.e. trying to sniff out when they occur, etc.
~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137979
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
On Monday, Sep 22, 2003, at 11:34 US/Pacific, Les Mizzell wrote:
How can I break this string apart:
Target Present|Yes|Unit Replaced|Yes|Unit Replaced|No|Comment|Wet
So I get:
Target Present: Yes
Unit Replaced: No
Comment: Wet
REreplace(PDWBD.DynamicQuestions
Sean A Corfield wrote:
REreplace(PDWBD.DynamicQuestions '|','([^\|]*)\|([^\|]*)\|','\1:
\2br','ALL')
That's some sick looking stuff, but it works like a charm.
Jezz, I need to stare at that awhile a figure exactly what it's doing
Thanks...
On Monday, Sep 22, 2003, at 12:02 US/Pacific, Les Mizzell wrote:
Sean A Corfield wrote:
REreplace(PDWBD.DynamicQuestions '|','([^\|]*)\|([^\|]*)\|','\1:
\2br','ALL')
That's some sick looking stuff, but it works like a charm.
For once I tested my code before posting :)
Jezz, I need to stare
I can't get my head around regular expressions! Help me please before I go mad!
I need to replace one word with another, matching cases (if possible), but in a smart
way. eg.
Ben lives in benland. But ben is actually not called ben. He's called ben-dabble
Say I want to replace 'ben' (any
This gets you part of the way:
cfset oldname=ben
cfset str=Ben lives in benland. But ben is actually not called ben. He's called
ben-dabble.
cfset newname=mike
cfset
t=rereplaceNoCase(str,(^|[^[a-zA-Z]]?)#oldName#([^[a-zA-Z]]?|$),\1#newName#\2,ALL)
cfoutput#t#/cfoutput
Note that it does not
That's great Jerry! Thanks! That does most of what I need. I think the majority of the
'case' problems will just be where the first letter is capitalised.
One thing I've noticed though is that if you have 'ben ben' it only replaces the first
'ben' with 'mike'. So it becomes 'mike ben'.
]]?)#oldName#([^[a-zA-Z]]?|$),\1#newName#
\2,ALL)
i.e. not using REReplaceNoCase, just REReplace.
André
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]
Sent: 04 June 2003 15:46
To: CF-Talk
Subject: Re: Regex replacing whole words
This gets you part of the way:
cfset oldname
Lackey
Moonbow Software, Inc
: -Original Message-
: From: Jim Banks [mailto:[EMAIL PROTECTED]
: Sent: Wednesday, June 04, 2003 10:54 AM
: To: CF-Talk
: Subject: Re: Regex replacing whole words
:
:
: That's great Jerry! Thanks! That does most of what I need. I
: think the majority
[mailto:[EMAIL PROTECTED]
: Sent: Wednesday, June 04, 2003 11:01 AM
: To: CF-Talk
: Subject: RE: Regex replacing whole words
:
:
: Standing on the shoulders of giants a very quick and dirty way of
: dealing with the case issue:
:
: cfset oldname=ben
: cfset newname=mike
: cfset
: t=rereplace(str
Johnson [mailto:[EMAIL PROTECTED]
Sent: 04 June 2003 15:46
To: CF-Talk
Subject: Re: Regex replacing whole words
This gets you part of the way:
cfset oldname=ben
cfset str=Ben lives in benland. But ben is actually not called ben.
He's called ben-dabble.
cfset newname=mike
cfset
t=rereplaceNoCase
]]?)#oldName#([^[a-zA-Z]]?|$),\1#newName#
\2,ALL)
i.e. not using REReplaceNoCase, just REReplace.
AndrT
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]
Sent: 04 June 2003 15:46
To: CF-Talk
Subject: Re: Regex replacing whole words
This gets you part of the way:
cfset oldname
.
-- Ben Doom
Programmer General Lackey
Moonbow Software, Inc
: -Original Message-
: From: Jerry Johnson [mailto:[EMAIL PROTECTED]
: Sent: Wednesday, June 04, 2003 11:12 AM
: To: CF-Talk
: Subject: RE: Regex replacing whole words
:
:
: Nice touch. Handles the two most obvious cases
11:19 AM
: To: CF-Talk
: Subject: RE: Regex replacing whole words
:
:
: My recent suggestion didn't work.
:
: Leave the ? in there!
:
: cfset oldname=ben
: cfset newname=mike
: cfset
: newStr=rereplace(str,(^|[^[a-zA-Z]]?)#oldName#([^[a-zA-Z]]?|$),
: \1#newName#\2,ALL)
:
: !--- second one to handle
General Lackey
Moonbow Software, Inc
: -Original Message-
: From: Jerry Johnson [mailto:[EMAIL PROTECTED]
: Sent: Wednesday, June 04, 2003 11:12 AM
: To: CF-Talk
: Subject: RE: Regex replacing whole words
:
:
: Nice touch. Handles the two most obvious cases.
:
: OK, I made a mistake, which
That's great Jerry! Thanks! That does most of what I need.
I think the majority of the 'case' problems will just be
where the first letter is capitalised.
One thing I've noticed though is that if you have 'ben
ben' it only replaces the first 'ben' with 'mike'. So it
becomes 'mike ben'.
Hello list - I have a simple form - it's in a secure area and allows
client to simply upload some PDF's. The file names though MUST allow
spaces.. Since I am dynamically creating links and display from the file
names.
Problem is - if I upload - Test PDF.pdf - it shows up as Test_PDF.pdf -
I
that are uploaded or vice
versa, though.
Anyway, if your CF is replacing the spaces in the filenames, you just have
to manually replace them back yourself:
cfset newFilename = Replace(File.ClientFileName, _, , ALL)
or something along those lines. I don't think there's a setting or anything,
but I
, if your CF is replacing the spaces in the filenames, you just
have
to manually replace them back yourself:
cfset newFilename = Replace(File.ClientFileName, _, , ALL)
or something along those lines. I don't think there's a setting or
anything,
but I could be wrong.
Gyrus
[EMAIL PROTECTED
Did you try this:
cfset StringToSearch = ##
cfset thisItem = ReplaceNoCase(thisItem, #StringToSearch#, ,
ALL)
-Original Message-
From: Pablo Varando [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 18, 2003 8:08 AM
To: CF-Talk
Subject: Re: Replacing the #
What about this:
!--- put
: Tuesday, February 18, 2003 6:09 AM
Subject: Re: Replacing the #
It currently isn't in a CFOUTPUT it errors on the cfset
Toughy huh?!
[snip]
I am trying to check a variable to make sure it doesn't have a #
sign in
the variable and if it does, I want to remove it. Here is what I
have
It is a form variable .. actually it is a Hex color #FF (I need to
remove the Pound sign).
Paul Giesenhagen
QuillDesign
- Original Message -
From: Pablo Varando [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, February 18, 2003 12:35 AM
Subject: Re: Replacing
Stephen
- Original Message -
From: Paul Giesenhagen [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, February 18, 2003 2:31 PM
Subject: Re: Replacing the #
It is a form variable .. actually it is a Hex color #FF (I need to
remove the Pound sign).
Paul Giesenhagen
What tricks does everyone use to replace apostrophes quotes from
forms?
Thanks!
Scott
Scott Wilhelm
Computer Technician/Web Developer
St. Lawrence-Lewis BOCES
PO Box 231, Outer State Street
Canton, NY 13617
P. 315-386-4504 x 164
F. 315-386-3395
W.
Use htmlEditFormat whenever you want to display data that you don't want interpreted
as HTML.
eg.
input type=text value=#htmlEditFormat(thisField)#
- Original Message -
From: Scott Wilhelm [EMAIL PROTECTED]
Date: Tuesday, February 18, 2003 12:39 pm
Subject: Replacing Apostrophes
I am trying to check a variable to make sure it doesn't have a # sign in the variable
and if it does, I want to remove it. Here is what I have, but it errors out with 1
(makes sense), but it doesn't replace if I have two! Any suggestions?
cfset thisItem = ReplaceNoCase(thisItem, #, , ALL)
Try this:
cfset thisItem = ReplaceNoCase(thisItem, chr(35), , ALL)
That should work...
Pablo
- Original Message -
From: Paul Giesenhagen [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, February 17, 2003 10:45 PM
Subject: Replacing the #
I am trying to check a variable
Just tried it, and nope, it didn't work ...
Thanks for trying though...
Paul Giesenhagen
QuillDesign
- Original Message -
From: Pablo Varando [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, February 17, 2003 11:53 PM
Subject: Re: Replacing the #
Try this:
cfset
Giesenhagen [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, February 17, 2003 11:51 PM
Subject: Re: Replacing the #
Just tried it, and nope, it didn't work ...
Thanks for trying though...
Paul Giesenhagen
QuillDesign
- Original Message -
From: Pablo Varando [EMAIL
It currently isn't in a CFOUTPUT it errors on the cfset
Toughy huh?!
Paul Giesenhagen
QuillDesign
- Original Message -
From: Pablo Varando [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, February 18, 2003 12:07 AM
Subject: Re: Replacing the #
What about this:
!--- put
OK, where are you getting the variable from.. are you setting at the top
with CFSET? or is comeing a DB, etc?
Pablo
- Original Message -
From: Paul Giesenhagen [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, February 18, 2003 12:09 AM
Subject: Re: Replacing
This should be a simple enough one...
I have a credit card number, 16 digits long, and I want to star (*) out the
middle 8. How do I do this?
TIA
Ryan
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
take the numberread the first 8 numbers and the output them with
hardcoded *'s.
simple
Or do you mean by Javascript as they type?
N
-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 12:56
To: CF-Talk
Subject: Replacing characters in a string
Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 12:56
To: CF-Talk
Subject: Replacing characters in a string
This should be a simple enough one...
I have a credit card number, 16 digits long, and I want to star (*) out the
middle 8. How do I do this?
TIA
Insert(,RemoveChars(ccnumber,5,8),4)
-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 7 januari 2003 13:56
To: CF-Talk
Subject: Replacing characters in a string
This should be a simple enough one...
I have a credit card number, 16 digits long
cfset maskedCCnumber=Left(CCnumber,4) RepeatString(*,8)
right(CCnumber,4)
Remember: Amex numbers are 15 digits long.
-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 7:56 AM
To: CF-Talk
Subject: Replacing characters in a string
Yet another way.. With regular expressions:
cfset maskDigits=8
cfset masked=REReplace(CCnum,^[0-9]{#maskDigits#},repeatString(*,maskDigits))
-Ryan
-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 7:56 AM
To: CF-Talk
Subject: Replacing
Sorry.. MIDDLE eight.. Now it gets ugly with regEx..
cfset
masked=REReplace(ccnum,([0-9]{4})[0-9]+([0-9]{4}),\1#repeatString('*',8)#\2)
-Ryan
-Original Message-
From: Ryan Emerle
Sent: Tuesday, January 07, 2003 10:47 AM
To: CF-Talk
Subject: RE: Replacing characters in a string
Yet
I'm seeing this at my error of my cfquery... I cold fusion changing th query or is it
the wasy CF outputs the error. I'm tryiing to update a timestamp and and a Hash. My
output
UPDATE Users SET DateHired = apos;{ts apos;2002-10-02 00:00:00apos;}, Username =
apos;bobapos;, Password =
-Talk
Subject: CFQUERY replacing ' with apos
I'm seeing this at my error of my cfquery... I cold fusion changing th
query or is it the wasy CF outputs the error. I'm tryiing to update a
timestamp and and a Hash. My output
UPDATE Users SET DateHired = apos;{ts apos;2002-10-02 00:00:00apos
How should Hashes be inserted? with single quotes or no?
- Original Message -
From: Ben Densmore [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, October 07, 2002 1:45 PM
Subject: RE: CFQUERY replacing ' with apos
That is just how MX displays the SQL in error messages
S. Isaac Dealey wrote:
Ok, I've got a little problem here. I'm reading an XML file from a third
party and displaying it's content. The problem is that the third party
is not checking for illegal characters in the XML file. So things like:
newsHe me are/news
will show up in the damn
Ok, I've got a little problem here. I'm reading an XML file from a third
party and displaying it's content. The problem is that the third party
is not checking for illegal characters in the XML file. So things like:
newsHe me are/news
will show up in the damn thing. So I want to replace the
Ok, I've got a little problem here. I'm reading an XML file from a third
party and displaying it's content. The problem is that the third party
is not checking for illegal characters in the XML file. So things like:
newsHe me are/news
will show up in the damn thing. So I want to replace
: morpheus
My ally is the Force, and a powerful ally it is. - Yoda
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 10:00 PM
To: CF-Talk
Subject: Re: Replacing Commas in a Form Field to keep list
from Bombing
Having to remove commas from
Hello,
I've been assigned the task to fix A news app which takes uploaded stories
(among other things that is why it is all dynamic) blows up when users have
a comma in their story. I am completely new to the code and a little (maybe
a lot) lost.
The user enters the Headline, Writer, and Story
My initial guess would be since you are treating this as a list the
commas are throwing things off since they are being treated as the
delimiter. It's difficult to diagnose without seeing more code - but
before I went and started trying to find/replace I'd make sure I was
defining and using a
[EMAIL PROTECTED]
Sent: Friday, February 01, 2002 6:49 PM
Subject: Replacing Commas in a Form Field to keep list from Bombing
Hello,
I've been assigned the task to fix A news app which takes uploaded stories
(among other things that is why it is all dynamic) blows up when users
have
a comma
chr(233) is that funky e é
The bell is a good choice. chr(07).
I had the exact same problem last night with a structure. I was populating
it with a grouped query and it worked great for a month... then died.
(someone added a field with a comma)
I changed the
StructKeyList(MyStruct) to
I'm pulling out my hair here trying to replace characters with accents
(ie: é, á, etc) as nothing seems to be working in my replace statemen
ts.
I've tried the following, all to no avail:
CFSET newbody_html = REReplace(#FORM.newbody#, #chr(130)#, eacute;
,
ALL)
CFSET newbody_html =
mais linda da Amazônia
Visit the most beautiful city in the Amazon Rain Forest
http://www.belemdopara.com.br/
---
- Original Message -
From: Emmanuel Crouvisier [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 04, 2001 7:41 PM
Subject: Replacing ASCII characters
I'm
)#
Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
-Original Message-
From: Emmanuel Crouvisier [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, October 04, 2001 3:41 PM
To: CF-Talk
Subject: Replacing ASCII characters
I'm pulling out my hair
'afternoon everyone,
We are storing meta-tag Description and Keyword information for many of our
documents in a database (MS-Access 2000), so the meta information can be
maintained without having to make changes to a static page. The problem I
am running into is that the individual who entered
: Tuesday, August 07, 2001 1:17 PM
To: CF-Talk
Subject: replacing carriage-returns in a db field with commas?
'afternoon everyone,
We are storing meta-tag Description and Keyword information for many of our
documents in a database (MS-Access 2000), so the meta information can be
maintained without
: replacing carriage-returns in a db field with commas?
'afternoon everyone,
We are storing meta-tag Description and Keyword information for many of our
documents in a database (MS-Access 2000), so the meta information can be
maintained without having to make changes to a static page. The problem I
I gave this code a try, but CF choked on the 'chr' part...does that function
(ListChangeDelims) actually take 3 parameters?
David
-Original Message-
From: Chris Martinez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 2:41 PM
To: CF-Talk
Subject: RE: replacing carriage
PROTECTED]]
Sent: Tuesday, August 07, 2001 1:17 PM
To: CF-Talk
Subject: replacing carriage-returns in a db field with commas?
'afternoon everyone,
We are storing meta-tag Description and Keyword information for many of our
documents in a database (MS-Access 2000), so the meta information can
(this tip may help you)
After struggling for a bit, found regular expressions could do what I wanted to do.
My problem:
Various files had varying strings in them, such as:
This file's name is:P1000104
This file's name is:P1000109
This file's name is:P1000167
etc.
I wanted to
[EMAIL PROTECTED]
crest.com cc:
Subject: Db to web: Replacing odd
ascii characters in
04/24/2001 03:33 db to web
.
BTY: I'm a happy Meadows customer, not a stakeholder in the company.
Paul Sizemore
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 8:03 AM
To: CF-Talk
Subject: Re: Db to web: Replacing odd ascii characters in db to web
Paul,
You
of these characters.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 8:03 AM
To: CF-Talk
Subject: Re: Db to web: Replacing odd ascii characters in db to web
Paul,
You don't say whether the folks performing this task are using Quark
I'm managing a site where articles from a magazine are being cut and pasted
into a text entry field. The people doing the actual cut and paste routine
are starting from a Quark file. When they cut the text out of Quark and into
the db, it is putting in all sorts of strange characters - probably
PROTECTED]]
Sent: Tuesday, April 24, 2001 3:34 PM
To: CF-Talk
Subject: Db to web: Replacing odd ascii characters in db to web
I'm managing a site where articles from a magazine are being cut and pasted
into a text entry field. The people doing the actual cut and paste routine
are starting from
I seem to remember about 6 months ago someone talking about "hiding" a range
of variables by using one variable that linked to a data table holding the
others.
Something like replacing: template.cfm?id=xinclude=ymenu=zsound=on with
template.cfm?var=1234
Where var called a table h
.
Studio's Find and Replace is very good, but if you can't locate the bad
characters, you might need something more powerful like Word.
Bob.
- Original Message -
From: "Josh R" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, January 08, 2001 9:23 PM
Subjec
OK, here's the problem.
We had to import our old databse into MS Access 97 and found that all the
special characters in a memo field for product descriptions have gone crazy.
ô and ö replaced ", ù replaced , Æ replaced ', etc.
So I need to go into the 2000+ fields we have and replace all
I have a list of variables sent by a form. I need to make sure that none of
the variable values are incompatible with each other. This isn't the problem.
The problem is changing the Form.whatever = value to a compatible value
(Form.field2 = 2. Form.field3 = 3 but 3 is not compatible with 2 so I
unt)
CFSET "#formField#" = 4
HTH,
Robert
-Original Message-
From: Ian [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 3:47 PM
To: [EMAIL PROTECTED]
Subject: Replacing a value in the list form.fieldnames
I have a list of variables sent by a form. I need to make sure that
Got a problem with Studio 4.5.1, it sometimes randomly replaces the a closing
tag symbol "" with the html code "gt;"
For instance, about every 4 or 5 times I save the document it will replace
this
line :
option value="3" cfif getproduct.status is
3SELECTED/cfifUnavailable/option
with this one
gt is the symbol for just as lt is the symbol for
It will still display the same
- Original Message -
From: "Hondo Burney" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 07, 2000 4:20 PM
Subject: Studio replacing characters
Got a problem with Studio 4.5.1, it
TED]]
Sent: Monday, August 07, 2000 12:36 PM
To: [EMAIL PROTECTED]
Subject: Re: Studio replacing characters
gt is the symbol for just as lt is the symbol for
It will still display the same
- Original Message -
From: "Hondo Burney" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday,
ust 07, 2000 1:46 PM
Subject: RE: Studio replacing characters
But the problem is it's not a display. It will cause problems. If it
does
it on a CF tag it will give and "invalid token found" error. If it does
it
on an HTML tag it will break the display of the page.
--K
-Orig
That's the point Kevin. It shouldn't but it is.
--K
-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 07, 2000 12:55 PM
To: [EMAIL PROTECTED]
Subject: Re: Studio replacing characters
option value="3"
cfif getproduct.status is3
SELE
Original Message-
From: Katrina Chapman [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 07, 2000 3:04 PM
To: [EMAIL PROTECTED]
Subject: RE: Studio replacing characters
That's the point Kevin. It shouldn't but it is.
--K
-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTE
In that example what tag is part of I can't see any?
- Original Message -
From: "Katrina Chapman" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 07, 2000 2:04 PM
Subject: RE: Studio replacing characters
That's the point Kevin. It shouldn't but it
quot;3" means that Studio is inserting the
"" symbol AND replacing the the intended "" with a ";gt"
This is messed up. It should not be doing any character replacing.
---Hondo---
At 12:24 PM 8/7/00 -0700, Dan Haley wrote:
There are two closing "" for the
Oops... should be:
SELECT Realtor.Name, PropType.Name
FROM Realtor, PropType
WHERE Realtor.RealtorID = RealtorAndPropType.RealtorID
AND RealtorAndPropType.PropTypeID = PropType.PropTypeID
Before you go any further, it would be wise to normalize your db design
Before you go any further, it would be wise to normalize your db design
each field in the db should be atomic - it should contain a single
value (not a list of values)...
Assuming your table is a realtor table, you need another table to
associate the list of realtors with the list of
Hi, All,
One of the fields (property.type)in my query contains a comma-delimited list
of numbers (1,3,4)
I have a lookup table (types) that consists of two fields: ID and Name.
Now, I need to replace numbers in Property.type with names from Type.Name.
How could that be done with ColdFusion?
Dennis Powers wrote:
Dave,
BTW: Although I have never taken your course, you have taught me much
through this medium and for that I thank you.
Me too. Hey! You got a course? Where can I find out more?
--
John Allred / Jackson, Mississippi
Mississippi Counties
http://www.mscounties.com/
function stripcr()
"pan" [EMAIL PROTECTED] wrote:
From: Dave Watts [EMAIL PROTECTED]
It can't be too stupid a question, because I don't really know what it is.
I
believe it's an instruction to the printer to move to the next line, but
given that's what a carriage return is as well, I don't
Me too. Hey! You got a course? Where can I find out more?
It's certainly not "my" course - I can't take credit for that. I'm a
certified Allaire instructor, and teach Allaire courses through Allaire and
through Fig Leaf.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202)
From: Dave Watts [EMAIL PROTECTED]
It can't be too stupid a question, because I don't really know what it is. I
believe it's an instruction to the printer to move to the next line, but
given that's what a carriage return is as well, I don't have a good answer.
In Windows, text files usually
101 - 200 of 225 matches
Mail list logo