have you tried #163;
Don't wanna hijack the Q, but (in a similar vein) does anyone know why
the apostrophes and double-quotes in this Access db are getting output
as squares?
http://www.handsthurrock.co.uk/news/item.cfm?NewsItemID=100
Thanks
--
Aidan Whitehall mailto:[EMAIL PROTECTED]
have you tried #163;
Don't wanna hijack the Q, but (in a similar vein) does anyone know why
the apostrophes and double-quotes in this Access db are getting output
as squares?
http://www.handsthurrock.co.uk/news/item.cfm?NewsItemID=100
MS smart quotes???
--
** Archive:
Hmm thanks,
Messed around with the Notes connection again last night on my home server
but still no go.
Has anyone else got a notes database connected using MX and win2k?
I'm sure ths is something simple and I am missing something really
stupid (as usual)
Regards - Paul
This was a problem of single quotes appearing as squares on win 2000
clients. I wasn't around when this problem was sorted but I know that's why
we are using this character set. The person who set this up is on holiday at
the moment so it may have to wait.
Looks like I'll have to change the doc
Am I blind or is there no body, head or doc type tags at the start of
that page?
Giles Roadnight
http://giles.roadnight.name
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]
Sent: 11 June 2003 09:02
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Bloody encoding again
At 09:02 11/06/2003, you wrote:
have you tried #163;
Don't wanna hijack the Q, but (in a similar vein) does anyone know why
the apostrophes and double-quotes in this Access db are getting output
as squares?
http://www.handsthurrock.co.uk/news/item.cfm?NewsItemID=100
the character set used in
MS smart quotes???
Yeppers, if that's what those curly apostrophes are.
Is there an encoding setting that you can specify within ColdFusion MX,
or is it a case of just replacing them with vanilla apostrophes?
Thanks
--
Aidan Whitehall mailto:[EMAIL PROTECTED]
Macromedia ColdFusion Developer
MS smart quotes???
BTW, if you open up Character map and use Times New Roman, they look
like the quotes at Alt-0145 and Alt-0146. Is that what Giles is using
the Windows encoding setting for?
--
Aidan Whitehall mailto:[EMAIL PROTECTED]
Macromedia ColdFusion Developer
Fairbanks Environmental
Don't wanna hijack the Q, but (in a similar vein) does anyone know
why
the apostrophes and double-quotes in this Access db are getting
output
as squares?
http://www.handsthurrock.co.uk/news/item.cfm?NewsItemID=100
Am I blind or is there no body, head or doc type tags at the start
of
Looking at Marks email I'd say that you could set the page encoding to
windows-1252, but you could also just use Taz's cleanMS tag to clean all
the crud out and replace smart quotes with vanilla quotes when a user pastes
in and submits Word text via your content editor.
MS smart quotes???
BTW, if you open up Character map and use Times New Roman, they look
like the quotes at Alt-0145 and Alt-0146. Is that what Giles is using
the Windows encoding setting for?
Possibly, with a typo of 1251 instead of 1252 for the character set.
Giles???
--
** Archive:
Looking at Marks email [snip]
Great -- thanks for the answers guys. I'll just create that SEP field...
--
Aidan Whitehall mailto:[EMAIL PROTECTED]
Macromedia ColdFusion Developer
Fairbanks Environmental Ltd +44 (0)1695 51775
Queen's Awards Winner 2003 http://www.fairbanks.co.uk/go/awards
Nope, definitely not a typo. I'll try to get an e-mail back from the person
who set this up and see if they can tell us any more.
Giles Roadnight
http://giles.roadnight.name
-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]
Sent: 11 June 2003 10:06
To: [EMAIL
Woo Hoo.
Done it!
Bloody notes authentication and id files :(
At least the connection to the database is in place. Just a case of reading
and writing data now sigh
Regards - Paul (Did I mention that Wolves are in the premiership)
Paul,
Any chance of a wee write up of what you need to do to get this to work in
the end?
Regards
Stephen
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 10:20 AM
Subject: RE: [ cf-dev ] Argghhh ODBC CFMX - Help!
Woo Hoo.
Done it!
http://www.macromedia.com/support/coldfusion/internationalization/inter
nationalization_cfmx/internationalization_cfmx3.html
To read a CFM page, process information, and decode Form and URL
variables, ColdFusion uses, by default, the character encoding specified
by the Java default locale
What would everyone suggest for a new install of CFMX : Self-Contained like
older versions or a J2EE version with JRUN 4?
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For
You probably saw the rumour, that cfmx standalone will be dumped in favour
of CFMX on J2ee and that Macromedia will no longer be producing future
versions of JRun.
Now MM squashed that rumour, with We have no plans to discontinue JRun.
(jeff Whatcott Sr. Director, Product Marketing ), no mention
How can you tell what the Java default locale variable is?
How to set/use the default locale:
http://short.badpen.com/?Y1K4IYIS
Getting it using Java:
cfset locale = createObject(java, java.util.Locale).getDefault()
On my system (using the methods within the java.util.Locale object) I
get
Trying to port a simple Javascript regular expression to Coldfusion:
JS: if (form.EmailAddress.value.search(/[^\s]+\s+[^\s]/) != -1)
CF: cfif REFind([^[[:Space:]]]+[[:Space:]]+[^[[:Space:]]],
Form.EmailAddress)
Basically, it's looking for any number of characters that aren't a space
character,
The first thing I can spot is too many [ and ]. Instead of:
REFind([^[[:Space:]]]+[[:Space:]]+[^[[:Space:]]]
try
REFind([^[:Space:]]+[[:Space:]]+[^[:Space:]]
See if that does it, god knows if I'm right.
Ade
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
How to set/use the default locale:
http://short.badpen.com/?Y1K4IYIS
Coolio... thanks.
BTW, just installed the SDK and done the First Cup of Java tutorial; it feels so nice
to use. I'm getting a bit bored of web stuff, really, plus I'm in the brown and sticky
stuff financially need to
no, same difference. anyway, I thought CF required the double brackets
around the Posix thingies. There's a whole paragraph about it in the old
Forta green book. I did notice someone else's regex recently not using
them; is this a change in CFMX, or can you do this in ye olde versions of
CFML
JS: if (form.EmailAddress.value.search(/[^\s]+\s+[^\s]/) != -1)
CF: cfif REFind([^[[:Space:]]]+[[:Space:]]+[^[[:Space:]]],
Form.EmailAddress)
It's hardly a good regex is it?
Find something that isn't a space more than once, then find a space,
then find something that isn't a space...
Erm
I think the outer ones are for the normal bit of the regex and the inner
ones are part of the posix dodahs. Try taking out the middle ones as well:
REFind([^[:Space:]]+[:Space:]+[^[:Space:]]
Oh and use space not Space, I think it's case sensitive
Ade
-Original Message-
From:
the JS was one I nicked off a well known ecommerce website, which probably
most of us on this list have bought something off! I'll let them know they
suck.
it's to catch things like paul @ pjnet.com. and it works. .search returns
-1 if it doesn't find a space. which is what we're testing
SELECT myValue, COUNT(myValue)
FROM myTable
GROUP BY myValue
-Original Message-
From: Damian Watson [mailto:[EMAIL PROTECTED]
Sent: 11 June 2003 15:21
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] percentages of values in recordset
Hi,
Pretty dumbass question but I'm working on a
Thanks Rich, don't think I explained myself very well though. What I'm
trying to do is:
SELECT myValue, COUNT(myValue) AS Whatever
FROM myTable
Where myValue=1 (and then on up to 5)
Then output the count as a percentage of the whole recordcount.
I realise I could loop it from 1 to 5 but myValue
(query.Whatever / query.RecordCount) * 100
???
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600
Creative solutions in a technical world
--
Get your
That bit's easy enough. The column I'm selecting records from has 5 possible
values (1-5). I'm trying to count the number of times the value appears in
the column's recordset without writing 5 queries with the where clause.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL
I don't think I understand.
the query I gave you will select all of the existing values in your table
(in this instance 1-5) along with the number of times that they exist in
that table.
Isn't this what you want?
with this you can then loop over that recordset and calculate the percentage
of
how about this. i'm making an assumption about how you're getting your 1-5
list:
cfquery name=getPoll
select myValue
from myTable
order by myValue
/cfquery
cfoutput query=getPoll group=myValue
cfquery name=getVotes
SELECT COUNT(myValue) AS Whatever
FROM
I'm not going to get into a solution, but i just wanted to mention that
anyone interested in these kinds of sql problems, should go out and buy
Clekos Sql for smarties.
~ J
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 11 June 2003 15:55
To: [EMAIL PROTECTED]
Nobody laugh, but if you want a total for each vote, 1 to 5, and the total
number of votes, all in one query(does a union still count as one query?),
try this...
CREATE TABLE #temp ( MyID INT IDENTITY, Column1 INT )
INSERT INTO #temp ( Column1 ) VALUES ( 1 )
INSERT INTO #temp ( Column1 ) VALUES
ok -- I really have confused things! Maybe it's the way I've asked the
question. I have a solution though that at least saves me querying lots,
it'll help you see what I'm doing.
cfparam name=Value1 default=0
...same for 2,3,4,5
cfquery name=QueryName
SELECT ColumnName, COUNT(ColumnName)
ok -- I really have confused things! Maybe it's the way I've asked the
question. I have a solution though that at least saves me querying lots,
it'll help you see what I'm doing.
cfparam name=Value1 default=0
...same for 2,3,4,5
cfquery name=QueryName
SELECT ColumnName,
Ah ok... beginner's SQL course for me.
Thanks everyone.
d
- Original Message -
From: Stephen Moretti [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 5:03 PM
Subject: Re: [ cf-dev ] percentages of values in recordset
ok -- I really have confused things! Maybe
that's bloody useful, Rich, thanks for that. I too have been wondering for a
while how to do it.
ianwest
- Original Message -
From: Rich Wild [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 3:12 PM
Subject: RE: [ cf-dev ] percentages of values in recordset
38 matches
Mail list logo
