We use Eclipse with CFE but I can't help going back HS+ for one the best
features which CFE does not gave - Edit Tag/Insert Expression where a dialog
popped up with all the tags, syntax etc, I much missed feature in CFE!
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Yeah, I think when you sign up, under DPA law you should be given the chance
not to receive emails (for courses I mean not newsletters!)
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Its already there in CFE... so time for you to chuck away that
jurassic software
MD
On 19 Jan 2007, at 08:54, Robertson-Ravo, Neil (RX) wrote:
We use Eclipse with CFE but I can't help going back HS+ for one the
best
features which CFE does not gave - Edit Tag/Insert Expression where
a
Hey Mark, Is it?! In a new build?
If it is in the version I am using..where is it?!
Lol
-Original Message-
From: Mark Drew [mailto:[EMAIL PROTECTED]
Sent: 19 January 2007 09:21
To: CF-Talk
Subject: Re: CFML IDE's
Its already there in CFE... so time for you to chuck away that
Brian Peddle wrote:
jrun.exe uses about 629,936 mem usuage when you look at the processer usage
When you look at seefusion I can see memory usage at about 85 - 91%
consistently.
My Maximum JVM heap size is 512 MB
And the jvm arguments are:
-server -Dsun.io.useCanonCaches=false
Hi all,
Odd one here, our local machines get out to the internet via a Proxy and as
reported in various technotes (such as
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_18602), some
features of CF require you to add the following JVM arguments to jvm.config
in order for CF to be able
Beach Computers Web Hosting wrote:
Running a fully patched and updated install, I can't seem to keep Jrun.exe's
CPU usage under control.
After watching the logs for days, the symptom is as follows:
Cf starts.
Runs fine for about a half hour.
I get the following entry in the log:
An extra 0.02c on IDEs. I don't use either in much depth (mostly as simple
code editors), but I found:
HomeSite+
- Outstanding text editor
- Very fast to start up
- Has an patch to support CF7 tags
- If you are using tortoise SVN, you can still access the context menu from
the list of folders
Hi all,
I have an online poll which allows users to add the answers to the database.
I can get the results like this:
cfquery name=getData datasource=#ARGUMENTS.DSN#
SELECT ,PL.question
,PR.questionAnswer
FROMpolls as PL
LEFT OUTER JOIN
pollResults as
Should be able to get it like so...
cfquery name=getData datasource=#ARGUMENTS.DSN#
SELECT ,PL.question
,PR.questionAnswer, ((SELECT COUNT(*)) AS ratingCount
FROM polls as PL
LEFT OUTER JOIN
pollResults as PR
ON PL.pollID = PR.pollID
AND PR.active = '1'
WHERE PL.active = '#ARGUMENTS.active#'
can you provide a few rows from your table as an example? and your DBMS?
On 1/19/07, Richard Cooper [EMAIL PROTECTED] wrote:
Hi all,
I have an online poll which allows users to add the answers to the database.
I can get the results like this:
cfquery name=getData datasource=#ARGUMENTS.DSN#
Michael: would it be an idea to allow people to add a filterstring to
their registration and that string is removed from every message
they send? That way people can register their disclaimer and they are
automatically removed from their messages.
That'd be good for people like me who hate
I want to check that I'm doing this right.
The second ON DELETE CASCADE, it'll enact when a people(id) entry is deleted?
So
IOW, when an id from the table people is deleted, any table entries from
notes_to_the_record_shared that are related to this people id will also be
deleted.
create
If it is in the version I am using..where is it?!
I've got the latest beta, and you can right click a tag in the editor
and click Edit this tag. Personally I never use it, I find it faster
to just type stuff in and take advantage of the tag insight. But it's
there for those that like it.
--
Hi Doug Greg.
The query example didn't work for me. It always returned the count as 1 :(
I've made up some example data to show you want I'm trying to achieve:
polls:
| pollID | Question | active |
--
| 1| Red fav | 1|
| 2|like pets | 1|
Hi, Matt...
ContentMonger looks good... and I like your tutorials... quick-loading
and clear.
What did you use to create those?
Rick
-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 18, 2007 7:37 PM
To: CF-Talk
Subject: Re: Open Source
Try it like so.
cfquery name=getData datasource=#ARGUMENTS.DSN#
SELECT ,PL.question
,PR.questionAnswer,
(select count(*) from pollResults pr) as results
FROM polls as PL
LEFT OUTER JOIN
pollResults as PR
ON PL.pollID = PR.pollID
AND PR.active = '1'
WHERE PL.active = '#ARGUMENTS.active#'
/cfquery
Don't do that. Are you using cfqueryparam? Change the structure of the query
by adding AND 1 = 1, this will use a new exec plan and the old column won't
be referenced. You may also get away with reformatting the SQL.
Adrian
-Original Message-
From: Brent Shaub [mailto:[EMAIL PROTECTED]
SELECT
A.Question,
A.Answer,
Count(*) as recordCount --- Note! Don't use reserved words
like Count as a result
FROM
polls A left join pollAnswers B on a.pollID = B.pollID
GROUP BY
A.Question,
B.Answer
That should work nice =)
-Original
I web site which has a file directory with about 450 subdirectories. Each
subdirectory is assigned to a company and each company has there own
subdirectories and files associated to there login credentials.
For example
Support_site_folders
Company1
Folder1
Folder2
I was about to recommend something similar to Chris here. Avoid using sub
select statements in your where clause or select clause when you can. If
the data is related, joining optimizes better.
Teddy
On 1/19/07, Peterson, Chris [EMAIL PROTECTED] wrote:
SELECT
A.Question,
Richard Cooper wrote:
I tried grouping the data from the poll table and then used this in the
select:
COUNT(DISTINCT PR.questionAnswer) as answerCount
,MIN(PR.questionAnswer) as questionAnswer
But that hust returned the number of different answers. I'm looking into some
kind of sql
Was this HotFix ever released? We are having this same issue and are current
with all updaters and hotfixes.
This hot fix will hopefully be available in the next 2 - 4 weeks. The
fix is being built for 7.02. Plans for a 7.01 hot fix are not clear
at this point. You can check the current
Either way the count now seem to return the full number of results rather than
the individual tallies?
i.e Doug's.
| Question | Answer | Count |
-
| Red Fav | Yes | 7 |
| Red Fav | No| 7 |
| Red Fav | Maybe | 7 |
|like pets | Dogs | 7 |
I am having a problem on a CFMx7.0.2 server where CFX tags do not work.
I have regitered the tags in the cfadmin, and they are in a folder which is
mapped in the jvm class path {application.home}/../cfx
Whenever any CFX tag is called it results in a blank page.
this is what appears in my
Richard. Why not just add a row to your table? I would add one called say
answerCount(int) and when someone submits an answer I would simply update
the columns value. Then your query would be quite easy.
Doug B.
- Original Message -
From: Richard Cooper [EMAIL PROTECTED]
To: CF-Talk
Ah, it is in mine but the difference is that in homesite you just have to
type say cfdump and then right click on it and you get the edit box
whereas in CFE you actually have to type the full tag, attributes and all
before you can edit it. You would be surprised how useful that feature in
HS is!
In CFEclipse, Ctrl-Shift D creates: cfdump var=## and puts teh cursor
right into the middle of the two pound symbols.
Teddy
On 1/19/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]
wrote:
Ah, it is in mine but the difference is that in homesite you just have to
type say cfdump and then
While I agree that would be easier, in a high volume environment, every
extra query counts against load times. While I don't think his survey
is necessarily high volume, what you suggest kinda goes against my
grain. =)
Just my $.02!
Chris
-Original Message-
From: Doug Brown
Yeah well, it cfdump was more of an example...not really where I was
stuck... ;-p
It is the same for any tag!
-Original Message-
From: Teddy Payne [mailto:[EMAIL PROTECTED]
Sent: 19 January 2007 16:20
To: CF-Talk
Subject: Re: CFML IDE's
In CFEclipse, Ctrl-Shift D creates: cfdump
Does anyone know of any open source forms automation software, preferably one
that works with CF or Java.
many thanks,
larry
--
Larry C. Lyons
Web Analyst
BEI Resources
American Type Culture Collection
http://www.beiresources.org
email: llyons(at)atcc(dot)org
tel: 703.365.2700.2678
--
What Neil is talking about are code snippets (I think. I don't know
about this right-clicking business, but I'm using version 5.5).
Both Eclipse and Homesite support code snippets. For example, I've got a
snippet for aborting. I have a certain procedure that runs at the end of
each page
You could use categories, and then supply a category based on what you
are allowed to see.
On 1/19/07, Keith McGee [EMAIL PROTECTED] wrote:
I web site which has a file directory with about 450 subdirectories. Each
subdirectory is assigned to a company and each company has there own
Yeah, I am not talking about snippets... basically in HS you can write part
of a tag..be it cfdump , cfinvoke etc then right-click in what you
have typed the you get the tag editing...it is just one of those things you
miss when you move to CFE ..for me anyway...
-Original
One of the things that keeps me from moving to the Eclipse is the
auto-tab-indenting. I can't remember the exact example, but I think when
you write a tag, with attributes on individual lines, each attribute
goes in an additional tab. Drives me bonkers. I love putting attributes
on different
You can disable that I think by unchecking Smart Indenting from Window
Preferences CF Eclipse.
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: 19 January 2007 16:53
To: CF-Talk
Subject: RE: CFML IDE's
One of the things that keeps me from moving to the Eclipse
I'm no Java wiz, but do these changes affect CFMX and its JRE?
http://blogs.ittoolbox.com/database/technology/archives/changes-to-daylight-
savings-time-in-2007-may-affect-your-databases-db2-oracle-and-others-13443
~CV
~|
Che Vilnonis wrote:
I'm no Java wiz, but do these changes affect CFMX and its JRE?
yes. damon's put up some info:
http://www.dcooper.org/blog/client/index.cfm?mode=entryentry=E3E028EF-4E22-1671-5E1639B73574B0C5
~|
Upgrade to
I'm no Java wiz, but do these changes affect CFMX and its JRE?
Yes, I think so, because CF comes with 1.4.2_09 or earlier versions. You'll
probably want to upgrade to 1.4.2_11:
http://java.sun.com/developer/technicalArticles/Intl/USDST/
Dave Watts, CTO, Fig Leaf Software
Is 1.4.2_11 officially approved for use by Adobe for CFMX 6.1 and 7.02?
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, January 19, 2007 12:15 PM
To: CF-Talk
Subject: RE: Changes to Daylight Savings Time in 2007 may affect your data
bases (DB2, Oracle and
Yes.
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
confidential and may also be privileged. It is for the exclusive use of
I think FarCry has improved tremendously over the last few years and I think
as far as Open Source CMS solution in ColdFusion is concerned, it should be
you first port of call.
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United
hi,
i need to be able to develop a report with charts from data that is contained
in session variables.
i have looked at the cf report builder but it is not flexible enough, as i need
to have certain data on page 1, other data on page 2 etc... more like a
document than a report full of
Is 1.4.2_11 officially approved for use by Adobe for CFMX 6.1
and 7.02?
Yes.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern
Russ,
I have regitered the tags in the cfadmin, and they are in a
folder which is mapped in the jvm class path {application.home}/../cfx
Whenever any CFX tag is called it results in a blank page.
Are the tags C++ or Java? Are any debug logs created by the CFX tags
themselves?
Yours
Hello there
I have an email script that is throwing an error. I took a look at the email
addresses since the script was running fine previously. I noticed an email
address in the following format [EMAIL PROTECTED] Can an email address start
with www. or is it a good possibility that this is
On 1/19/07, Jason Rogoz [EMAIL PROTECTED] wrote:
Hello there
I have an email script that is throwing an error. I took a look at the
email addresses since the script was running fine previously. I noticed an
email address in the following format [EMAIL PROTECTED] Can an email
address
I have an email script that is throwing an error. I took a
look at the email addresses since the script was running fine
previously. I noticed an email address in the following
format [EMAIL PROTECTED] Can an email address start with
www. or is it a good possibility that this is the
It's perfectly valid. www. isn't meaningful - even with http, using www
for the hostname of a web server is simply a convention.
-Original Message-
From: Jason Rogoz [mailto:[EMAIL PROTECTED]
Sent: Friday, January 19, 2007 1:45 PM
To: CF-Talk
Subject: valid email address?
Hello
That maybe causing an issue it just depends what your regex is looking it.
Its probably the extra period though. Email addresses do not start with www.
so I dont think there is a need to change your script.
Dan Vega
http://www.danvega.org/blog
On 1/19/07, Jason Rogoz [EMAIL PROTECTED] wrote:
A huge headache later it's all sorted. Here's the finalised code (I haven't
removed extra columns)
!--- get the info from the database ---
cfquery name=getData datasource=#ARGUMENTS.DSN#
maxrows=#ARGUMENTS.maxrows#
SELECT PL.pollGroupID
,PL.questionType
my apologies i thought it was www.my.email@ what udf or regex are you using
to check the validity of the address.
Dan
On 1/19/07, Doug Bezona [EMAIL PROTECTED] wrote:
It's perfectly valid. www. isn't meaningful - even with http, using www
for the hostname of a web server is simply a
It's REALLY common for AOL users to put www in front of their name on the
left side of the @.
It's valid and works just fine.
-Original Message-
From: Jason Rogoz [mailto:[EMAIL PROTECTED]
Sent: Friday, January 19, 2007 12:45 PM
To: CF-Talk
Subject: valid email address?
Hello there
I
Of course if you're using at least sql server you can do something like this
cfquery name=updateInsert datasource=#dataname#
If not exists (select * from sometable where somefield=somevalue)
Begin
Insert into sometable (fields) values (values)
End
Else
Its actually not a udf or regex that is breaking, there is an application error
saying that the email address has been rejected. The site is actually a .net
app but i thought i'd first post here regarding the validity of the email
address before posting in a .net forum.
Jason
-Original
The Adobe ColdFusion extensions for Eclipse, which provide RDS support,
a visual query builder, and some other niceties, also installs the full
CF documentation into the Eclipse help.
Unfortunately, you need to download the whole Flex Builder trial from
Adobe to get them. You don't actually have
How is the application breaking? Are you sure an email server somewhere is
not rejecting the address?
On 1/19/07, Jason Rogoz [EMAIL PROTECTED] wrote:
Its actually not a udf or regex that is breaking, there is an application
error saying that the email address has been rejected. The site is
The application is breaking during the looping of the email addresses and
sending an email to each one. I can see the error in the application log of
the server as well. Is there anyway to test the email addresses in question to
see if they are in fact valid or being rejected?
-Original
Maybe one of you Linux/Sys Admin types can help me out...feel free to email
me offlist at [EMAIL PROTECTED]
I am getting the following error when I try to hit my site via https:
domain has sent an incorrect or unexpected message Error Code -12263
Error Code -12263 says that SSL received a
I am creating an app that merely moves a file from one folder to another. I
have this script:
cfscript
tempBylawPath = #ExpandPath(../tempBylaws)#;
currentBylawPath = #ExpandPath(../Bylaws)#;
archiveBylawPath = #ExpandPath(../ArchiveBylaws)#;
/cfscript
!--- Now move the file to the
They are JAVA tags, there is nothing in the logs other than I posted before.
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
But I am getting an error that says Attribute validation error in CFFILE. So
what gives? The server is a Windows 2K3 server running CFMX 7.2.
Is there a possibility of a permission error? The CF/Jrun service does not
have permission to read/write/copy in one or more of those directories? I
That's a really sweet tip Doug! Thanks! :o)
Chris
Doug Bezona wrote:
The Adobe ColdFusion extensions for Eclipse, which provide RDS support,
a visual query builder, and some other niceties, also installs the full
CF documentation into the Eclipse help.
Unfortunately, you need to download
The two directories do not reside on different partitions do they?
There is a note in the Livedocs to the effect that the java library
involved has an issue with that.
Is there a possibility of a permission error? The CF/Jrun service does not
have permission to read/write/copy in one or more
They are on the same partition. This is a test server that has only one
partition and currently this is the only app residing on it. The file I am
trying to move was loaded up by another part of this app using CFFILE and
there are no issues with that.
Bruce Sorge
I'm a mawg: half man, half dog.
Maybe delay the move a bit? Try separating the file placement and the
move to different CFM templates and run them independently. I have had
issues writing and then moving a file because the handle was not
completely released when I tried to move it =)
Chris
-Original Message-
From:
What a process! If they are free to use as plugins elsewhere why not provide
them for download?!
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains
I would have tried this but I was not sure if it was legal
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
confidential and
OK, so I did this on my local machine now rather than the server, and I get
this message:
An exception occurred when performing a file operation copy on files
C:\Inetpub\wwwroot\DONE\election_procedure\tempBylaws\Roser.doc and
C:\Inetpub\wwwroot\DONE\election_procedure\Bylaws.
I hardcoded the
Possibly an issue with a self signed cert I am still doing some digging for
you. I did come across this and it was on windows so that leads to believe
Webserver or SSL issue
http://apache2triad.net/forums/archive/o_t__t_4957__strange-ssl-error.html
Eric
On 1/19/07, Eric Roberts [EMAIL
I was just informed by the Sys Admins that I cannot upload files to their
production servers, so please disregard and thanks for the tips.
--
Bruce Sorge
I'm a mawg: half man, half dog. I'm my own best friend!
~|
Upgrade to
They had them available as a separate downlaod on the Adobe Labs site when Flex
2 was in beta.
I'm not sure why they don't have a separate download. I'm fairly certain
there's no licensing restriction for using them, but can't say definitively.
The few extra minutes it takes to do the Flex
Thanks...this getting rather frustrating g
-Original Message-
From: Eric Haskins [mailto:[EMAIL PROTECTED]
Sent: Friday, 19 January 2007 16:21
To: CF-Talk
Subject: Re: OT question
Possibly an issue with a self signed cert I am still doing some digging for
you. I did come across
This one goes under stupid human tricks...I forgot to put SSLEngine on in
the site's conf file *DOH*
Eric
-Original Message-
From: Eric Roberts [mailto:[EMAIL PROTECTED]
Sent: Friday, 19 January 2007 16:41
To: CF-Talk
Subject: RE: OT question
Thanks...this getting rather frustrating
Jason Rogoz wrote:
The application is breaking during the looping of the email addresses and
sending an email to each one. I can see the error in the application log of
the server as well. Is there anyway to test the email addresses in question
to see if they are in fact valid or being
Quick question. Trying to setup my CF environment on Apache instead of
IIS. I'm using the Virtual Hosts file, and running multiple domains ok,
after a bumpy start. Now another issue, one of my domains requires a
virtual directory, whereby the setup kinda works like this:
Cutter,
Don't know about Windows for sure since I use IIS there, but on Linux/
Unix I use a trailing slash and it works fine:
Alias /resources/ D:\resources\
Are you adding the alias within the Virtual Hosts block or inline in
httpd.conf (or one of the conf files if running Apache2 )?
Jon
Latest version of Apache requires that you add a Directory entry to allow
access to that directory. Something like
Directory F:/resources
Options FollowSymLinks
AllowOverride None
Order deny,allow
Allow from all
/Directory
You can check the error log to see what the problem
You should not be using a trailing slash. From apache documentation:
Note that if you include a trailing / on the url-path then the server will
require a trailing / in order to expand the alias. That is, if you use Alias
/icons/ /usr/local/apache/icons/ then the url /icons will not be aliased.
Makes sense, Russ. I never really thought about the url impact since
I mostly use aliases for file directories.
Thanks for the heads up.
Jon
On Jan 19, 2007, at 7:08 PM, Russ wrote:
You should not be using a trailing slash. From apache documentation:
Note that if you include a trailing
Apache beats the pants off IIS, but it has a bit of a learning curve.
One important measurement of how good a product is, is how easy it is to
learn and use.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction
I completely disagree with that statement. Ease of use has (nearly) nothing
to do with how good or bad a particular product is. Some people have spent
years running their sites on Apache and the same holds true for others using
IIS. It all depends what you use and what you are familiar with.
So I figured I would open up the conversation...
Thoughts, feedback, suggestions, criticisms on the new Coldfusion Community
Toolbar?
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful
Yeah Russ, I thought that might be it when I was working this last
night. I'm serving up cfml content out of the root just fine, just not
getting my resources straight. I'll check my logs, but just in case,
here's what I've been trying, but still not having any luck (any hints
on doing this
I completely disagree with that statement. Ease of use has
(nearly) nothing to do with how good or bad a particular
product is.
That is an absurd statement on its face. Ease of use may not be the most
important factor in judging the quality or value of something, but it is an
important
Seems I had my page cached. I bring it up now (with that config) and all
is well. Just a fluke (I never turn on caching...) Thanks to everyone
for their help.
Dave, I have to disagree to a point. Ease of use isn't the question,
really, it's 'What is the best tool for the job?' IIS doesn't
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, January 19, 2007 9:29 PM
To: CF-Talk
Subject: RE: Apache config
I completely disagree with that statement. Ease of use has
(nearly) nothing to do with how good or bad a particular
product is.
That
87 matches
Mail list logo