Can anyone tell me why I am getting a wierd capital A with a hat on before £
signs in a text field when I update a DB record?
Thanks
Giles
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:
Can anyone tell me why I am getting a wierd capital A with a hat on before £
signs in a text field when I update a DB record?
Is that the escape character for whatever RDBMS you're using? Maybe it's automatically
escaping it.
--
Aidan Whitehall [EMAIL PROTECTED]
Macromedia ColdFusion
Each time it is updated more of the weird symbold appear, am now getting
square boxes too.
I think this is a new problem since upgrading to MX.
- Original Message -
From: Giles Roadnight [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 16, 2002 9:56 AM
Subject: [ cf-dev
Errr, sorry what tdo you mean by that?
- Original Message -
From: Aidan Whitehall [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 16, 2002 9:57 AM
Subject: RE: [ cf-dev ] Weird sybols in DB
Can anyone tell me why I am getting a wierd capital A with a hat on before
£
Errr, sorry what tdo you mean by that?
I'm not sure how to explain that clearly (got brain fuzz today). What
database are you using? Access, SQL Server, Oracle...?
--
Aidan Whitehall [EMAIL PROTECTED]
Macromedia ColdFusion Developer
Fairbanks Environmental +44 (0)1695 51775
There was a similar thread a few weeks ago... might help
Character Conversion 28/08/2002
Taz
Can anyone tell me why I am getting a wierd capital A with a hat on before
£
signs in a text field when I update a DB record?
Thanks
Giles
--
** Archive:
access 2000
- Original Message -
From: Aidan Whitehall [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 16, 2002 10:02 AM
Subject: RE: [ cf-dev ] Weird sybols in DB
Errr, sorry what tdo you mean by that?
I'm not sure how to explain that clearly (got brain fuzz today).
I also experienced this whilst developing a site using MX. The prod server
was still running CF5 and this solved our problem. I think it has
something to do with the default text encoding being UTF-8, but I may be
wrong. I think you have to either convert them to pound; or whatever the
That's a bit of a pain. What other characters are going to mess it up? I
think I had a related problem with worldpay submitting forms to CFMX adn the
caracter encoding messing things up.
Isn't there a urlencodedformat equivalent function that will do all this for
me?
- Original Message -
'escaping', if that is what you did not understand is simply the the way a
system such as ColdFusion implements so to make a string/packet/whatever
valid.
hence, in a .cfm, this will fail : #FF, to get this to work you have to
'escape' the gates (or pounds as out lovely yanks call them) :
No worldpay does not use XML, it uses 16 bit character encoding but
apparently CFMX only understands 8bit.
- Original Message -
From: Robertson-Ravo, Neil (REC) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 16, 2002 10:11 AM
Subject: RE: [ cf-dev ] Weird sybols in DB
Hi,
Is it possible to use a UUID as the CFToken instead of the usual random
number on CF5? I think I remember reading about it somewhere.
MTIA
Dave
Phipps CF Development
Oxford, Oxfordshire.
Telephone: +44(0)7718 896696
It was on the list the other day under session variables... I believe it's a
registry setting.
- Original Message -
From: Dave Phipps [EMAIL PROTECTED]
To: ColdFusion User group [EMAIL PROTECTED]
Sent: Wednesday, October 16, 2002 10:40 AM
Subject: [ cf-dev ] UUID cftoken on CF 5
Hi,
Dave, here you go :
1. Select Start and Run.
2. Type regedit and click OK.
3. Navigate to the following registry key:
4.
HKEY_LOCAL_MACHINE\Software\Allaire\ColdFusion\CurrentVersion\Clients\UuidTo
ken If the key does not exist, right click on the Clients key and choose New
Thanks for that. I have now made the change and restarted the service
however I am still getting the 8 digit cftoken. Is there anything in my
code that I need to change so that I end up with
CFID=2CFTOKEN=83D000-3435355.
Thanks
Dave
At 10:43 10/16/2002 +0100, you wrote:
Dave, here
what did you add to the registry...
-Original Message-
From: Dave Phipps [mailto:[EMAIL PROTECTED]]
Sent: 16 October 2002 11:07
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] UUID cftoken on CF 5
Thanks for that. I have now made the change and restarted the service
however I am
Did you throw away your cookies? If you have an old CFID/cftoken cookie
you still get 'old' tokens, no matter what is in the registry.
-Original Message-
From: Dave Phipps [mailto:[EMAIL PROTECTED]]
Sent: 16 October 2002 11:07
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] UUID
I added a key called Uuidtoken and set the value to 1.
I then restarted the cf app service.
I am not currently using cookies only sessions which I hold on to by
passing the CFID and CFTOKEN in the url.
Thanks
Dave
At 11:06 10/16/2002 +0100, you wrote:
what did you add to the registry...
check the cookie directory anyway.I am sure the CFIDE uses them? could
be wrong, but I think they do.
-Original Message-
From: Dave Phipps [mailto:[EMAIL PROTECTED]]
Sent: 16 October 2002 11:18
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] UUID cftoken on CF 5
I added a key
Is Windows 2000 a multi byte operating system? If so there is some possibly
relevent stuff here:
http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx
.html#i18n
near the bottom of the bit on localisation. two command line things I will
probably have to run.
-
If you mean the cookies dir in the WINNT dir then this is empty. In the
Clients registry there are huge number of folders holding the client
vars. Are these worth deleting if no longer needed?
Thanks
Dave
At 11:18 10/16/2002 +0100, you wrote:
check the cookie directory anyway.I am
Hi all,
I've got a problem an a page where I'm getting an alert on load saying this
is not secure in any way! . All there is in the page though is a simple
select query and a So Editor Lite tag which is the only thing i could think
would cause this. Just wondering if anyone has come across this
Ok, I'll give that a go. Can't right now as am away from that code. I'll do
it tonight.
Tahnks
- Original Message -
From: Douglas Humphris [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 16, 2002 11:35 AM
Subject: RE: [ cf-dev ] Weird sybols in DB
Had the same problem
Here ya go:
cfoutput query=get_text
cf_soEditor_lite
form=update_text
field=update_text
html=#update_text#
scriptpath=#request.soeditor#
width=450
height=300
singlespaced=false
wordcount=true
validateonsave=true
check the code it is pulling from the DB.I bet there is a script tag
in there.
-Original Message-
From: Damian Watson [mailto:[EMAIL PROTECTED]]
Sent: 16 October 2002 11:37
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] SO Odditor / This is not secure in any way
Here ya go:
I bet there is a script tag in there.
Neil is right, replacing the offending data fixed the problem. I'd suggest
that anyone using inline editors should clean fields of naughty script tags
when submitting to a query.
CleanFields.cfm (available from dev exchange) can be customised to do this
and
Yup!
-Original Message-
From: Dave Phipps [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 16, 2002 11:29 AM
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] UUID cftoken on CF 5
If you mean the cookies dir in the WINNT dir then this is
empty. In the
Clients registry
Just taken a look at So-editor-lite, installed the files on server including
the custom tag and made a small change to apache, and called the custom tag
at the end of a test page with the default,
form action=myfile.cfm
cf_soEditor_lite
form=documentation
field=soeditor
Hi,
I have just installed CFMX on a Win2k SP3/IIS5 running on a Virtual
PC. Everything seems to have installed except when I try and load the CFMX
administrator all I get is a dns error/ cannot find server. Yet when I
know that the web server is running as I can load localstart.asp.
Has
Install problems has been posted on here 100 times now. If you refer back to
previous posts you can find a solution.
-Original Message-
From: Dave Phipps [mailto:[EMAIL PROTECTED]]
Sent: 16 October 2002 15:51
To: ColdFusion User group
Subject: [ cf-dev ] CFMX install probs on Win2k IIS5
Hi,
Message below sent around 3pm, does not appear to have got through to list,
thanks.
rgds
Colm
-Original Message-
From: Colm Brazel [mailto:[EMAIL PROTECTED]]
Sent: 16 October 2002 15:02
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] SO Editor
Just taken a look at
No, I'm afraid that didn't work.
Anyone know if windows 2000 is a multi-byte OS?
Giles Roadnight
http://giles.roadnight.name
-Original Message-
From: Douglas Humphris [mailto:[EMAIL PROTECTED]]
Sent: 16 October 2002 11:35
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Weird sybols in
Just to clarify, did you use cfset setEncoding(FORM, utf-8) as opposed to
setEncoding(FORM, utf-8) in my earlier post? Didn't make that very clear.
Douglas
-Original Message-
From: Giles Roadnight [mailto:[EMAIL PROTECTED]]
Sent: 16 October 2002 17:20
To: [EMAIL PROTECTED]
Subject: RE:
about fricking time:
http://diveintomark.org/archives/2002/10/16.html#rich_editing_in_mozilla
---
Rich Wild
Senior Web Developer
---
e-mango Tel: 01202 755 300
Gild
No I didn't. I have now used
cfset setEncoding(FORM, utf-8)
and it now works. Thanks a lot.
Giles Roadnight
http://giles.roadnight.name
-Original Message-
From: Douglas Humphris [mailto:[EMAIL PROTECTED]]
Sent: 16 October 2002 17:25
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ]
Seems a bit cumbersome all that lot, but probably necessary if there are
file operations being done by other apps.
But if the file ops are purely done by the CF app, its much easier to use
(exclusive) named locks. You can use the filename as the name of the lock,
and do that with any file
36 matches
Mail list logo