Add to that list, locally scope the query.
cfset var get =
Adrian
-Original Message-
From: Peter Boughton [mailto:[EMAIL PROTECTED]
Sent: 01 October 2008 00:01
To: cf-talk
Subject: Re: cfqueryparam within a cfc
cfcomponet
cffunction name=function
cfargument name=field_value
Add to that list, locally scope the query.
cfset var get =
Very good point - probably the most critical change to make.
I can't believe I missed that. :'(
~|
Adobe® ColdFusion® 8 software 8 is the most important and
Thanks for the suggestions. I drastically shorten the code/query to get my
question across. However, you make very good points!
Thanks!
Mike
-Original Message-
From: Peter Boughton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2008 5:51 AM
To: cf-talk
Subject: Re:
My bad, again :[ , it's the Temp method, the one without any parameters.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
CF5.0 Problem for all you old guys out there (actually, a problem for
me, an OPPORTUNITY for you):
I have a few scheduled tasks that run fine, but I want to cease for a
while. When I try to edit them I get The value specified for Port must
be between 1 and 65535; I get this error even if port
CF5.0 Problem for all you old guys out there (actually, a problem for
me, an OPPORTUNITY for you):
How is this an opportunity? Should I invoice you for the answer?
I have a few scheduled tasks that run fine, but I want to cease for a
while. When I try to edit them I get The value specified
On Tue, Sep 30, 2008 at 7:00 PM, denstar [EMAIL PROTECTED] wrote:
Well, I guess my question to you would be, what is a java app to you?
How does JSP, Tapestry, Faces, Groovy, etc. fit into your picture there?
JSP and Faces are both part of the Java spec so its java (JSF 2.0 I
suppose).
My bad, again :[ , it's the Temp method, the one without any parameters.
OK, that accepts an empty document/literal value. I suspect you might
have to pass in an empty argument.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber
I would prefer to get this running directly from CF, simply because it's
less complicated...
I'm not sure what you mean by this. Scheduled tasks by default run as
SYSTEM. They're never going to be run directly from CF because CF
isn't the scheduler service.
When I try to add /u
Hey all,
Is there a way to force a CF Server to clear it's query cache?
thanks
sas
--
Scott Stewart
ColdFusion Developer
Office of Research Information Systems
Research amp; Economic Development
University of North Carolina at Chapel Hill
Phone:(919)843-2408
Fax: (919)962-3600
Email: [EMAIL
Is there a way to force a CF Server to clear it's query cache?
If they're cached with CACHEDWITHIN/CACHEDAFTER, use CFOBJECTCACHE
ACTION=CLEAR.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our
Has anyone been able to use the css property page-break-inside:avoid with in
a CFDOCUMENT tag. I am using CF8 and I am dynamically generating a PDF report
with a variety of sections. One section contains user modifiable
recomendations that can be as short as one line and each recomendations
unfortunately their not, it's the server's query cache that has them,
is it possible to force them to not cache in the first place (without
setting the query cache setting in the CF server to 0)
thanks
sas
Dave Watts wrote:
Is there a way to force a CF Server to clear it's query cache?
Thanks for the replies, I didn't figure I would be able to do this at this
time. Maybe a future release of CF will inlucde this type of feature.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
unfortunately their not, it's the server's query cache that has them,
is it possible to force them to not cache in the first place (without
setting the query cache setting in the CF server to 0)
Are you saying they're cached within the Server scope, and you
reference them as
He might also mean the execution plan.
Adrian
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: 01 October 2008 16:24
To: cf-talk
Subject: Re: Clearing out the query cache
unfortunately their not, it's the server's query cache that has them,
is it possible to force
He might also mean the execution plan.
Maybe, but CF doesn't cache the execution plan. The database does that.
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,
It's a plain ol' vanilla query
cfquery name=get_study datasource=#request.dsn#
select cycle_id,
cycle.cycle_month,
cycle.cycle_year,
week_id,
week.start_date,
week.fiscal_year,
study.id,
What is the best way of coding this: I have a form that currently has 4
check boxes.
When processing this form I need to check for the existence of any of the
check boxes.
Now, there are 4 values now but there could be more in the future.
I tried to loop over the form variable with isdefined by
When you add a new checkbox, add logic for checking it?
Mallory Woods wrote:
What is the best way of coding this: I have a form that currently has 4
check boxes.
When processing this form I need to check for the existence of any of the
check boxes.
Now, there are 4 values now but there
Is URL.id correct?
Are you sure your hitting the right DB?
Without you asking CF to cache anything it won't.
-Original Message-
From: Scott Stewart [mailto:[EMAIL PROTECTED]
Sent: 01 October 2008 16:39
To: cf-talk
Subject: Re: Clearing out the query cache
It's a plain ol' vanilla
It's a plain ol' vanilla query
cfquery name=get_study datasource=#request.dsn#
select cycle_id,
...
from cycle
left joinweek on cycle.id = week.cycle_id
left joinstudy onweek.id =study.week_id
left joinperson on
Kind of hard to check for a form value if you are unsure the name of the
element.
Pure Curosity: Why would you not know the name of the field? Is it pulled
from a database when the form page is created?
On Wed, Oct 1, 2008 at 11:41 AM, Mallory Woods [EMAIL PROTECTED]wrote:
What is the best
You have to have some knowledge of the checkbox names.
Are they in any way similar?
input type=checkbox name=checkbox_1 /
input type=checkbox name=checkbox_2 /
input type=checkbox name=checkbox_3 /
If so, you can check in a loop:
cfloop from=1 to=3 index=i
cfif
If the names are from the DB you can either get them again on the action
page or pass them to the action page from the form. Then in a query or list
loop:
IsDefined(FORM.#yourQuery.fieldName#)
or
IsDefined(FORM.#aListIndex#)
Adrian
-Original Message-
From: Randy [mailto:[EMAIL
Whoops. Sorry I mistyped. I *DO* (thank you for no starbucks this AM) know
the name of the check boxes and they are generated from a DB. So yes, I will
have the names.
Adrian Lynch Your post just came in the gmail as I was typing this.. I will
try that approach.
Thanks all
On Wed, Oct 1, 2008
Anyone, soomeone, help please
hello all
I tried my hardest to figure this one out by myself, but here goes.
I have a query that returns sums of a few columns. I need to count the number
of
people with certain occupations and count the number of classes they took by a
certain course ID.
thanks for your help, and thanks for rays link on ajax security we will have to
read around this some more.
thanks again
richard
Richard,
We recently implemented a few webservices for our parent company. When
doing these I took a multi-tier approach:
1) folder of service requires
It sounds like you are going to need to look at your join syntax.
Since you are join your users to courses you are going to get 9 records
for that one user. Then when you sum those up you are going to get nine!.
But I am unclear on what to do about it. One would need to know a lot
more your
I'll have to check on that but... it should be...
Dave Watts wrote:
It's a plain ol' vanilla query
cfquery name=get_study datasource=#request.dsn#
select cycle_id,
...
from cycle
left joinweek on cycle.id = week.cycle_id
left joinstudy on
I looked at other server-side PDF creation tools and almost none of
them support vector graphics, even though vector graphics are
recommended to keep file sizes down and they make for better looking
logos. The latest version of iText doesn't support EPS, so unless
iText is upgraded with this
annn it's fixed.
It so wasn't a caching issue.
I dumped the query and it was right... just me being stupid and trying
to DateFormat a four digit numeric value.
cfdump is my friend..
Thanks to all for your help...
sas
Scott Stewart wrote:
Hey all,
Is there a way to force a CF
Hi Dave,
Ach! Tried to send you 65 cents, but apparently my Paypal
Account has been suspended...
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2008 9:21 AM
To: cf-talk
Subject: Re: Problem editing task schedule
CF5.0
Hi Dave,
Ach! Tried to send you 65 cents, but apparently my Paypal
Account has been suspended...
Then I must insist you return the unpaid answer at once and forget you
ever read it, you welcher.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the
Too late, it's already on BitTorrent! :O.
-Original Message-
From: Dave Watts
Sent: 01 October 2008 18:24
To: cf-talk
Subject: Re: Problem editing task schedule
Hi Dave,
Ach! Tried to send you 65 cents, but apparently my Paypal
Account has been suspended...
Then I must insist
When processing this form I need to check for the existence of any of the
check boxes.
Yeah, this is really a design problem in HTML, the name of an unchecked
checkbox is not passed
by the browser in the HTTP protocol.
IMHO some default value would pretty useful, ie:
INPUT NAME=myCheckBox
Too late, it's already on BitTorrent! :O.
You are in violation of DMCA. My lawyers will contact you shortly.
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,
You are in violation of DMCA. My lawyers will contact you shortly.
Don't forget to send a notice to Michael also to remove it from the
archive before Google gets it into their cache g.
-Justin Scott
~|
Adobe® ColdFusion® 8
Did you ever consider giving open-source answers?
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2008 4:30 PM
To: cf-talk
Subject: Re: Problem editing task schedule
Too late, it's already on BitTorrent! :O.
You are in violation of DMCA. My
Hi All,
Have NOT ventured into regular expressions much at all. Now I have the need for
one, and wonder if anyone has one made for this scenario.
Search engine, want user to be able to enter multiple words, also phrases. Want
my SQL to loop over the phrases and words with an AND... (the SQL I
On Wed, Oct 1, 2008 at 8:07 AM, Adam Haskell wrote:
On Tue, Sep 30, 2008 at 7:00 PM, denstar wrote:
Well, I guess my question to you would be, what is a java app to you?
How does JSP, Tapestry, Faces, Groovy, etc. fit into your picture there?
JSP and Faces are both part of the Java spec
On Wed, Oct 1, 2008 at 10:14 AM, Torrent Girl wrote:
Anyone, soomeone, help please
It's not as fun as one big solution, but you could break it up into
smaller chunks, and put those chunks together.
Sometimes that's fastest, even if it's not the most efficient.
Sorry no instant ah ha! when
On Wed, Oct 1, 2008 at 2:09 PM, Developer MediaDoc
[EMAIL PROTECTED]wrote:
Hi All,
Have NOT ventured into regular expressions much at all. Now I have the need
for one, and wonder if anyone has one made for this scenario.
Search engine, want user to be able to enter multiple words, also
On Wed, Oct 1, 2008 at 2:36 PM, Charlie Griefer
[EMAIL PROTECTED]wrote:
On Wed, Oct 1, 2008 at 2:09 PM, Developer MediaDoc
[EMAIL PROTECTED] wrote:
Hi All,
Have NOT ventured into regular expressions much at all. Now I have the
need for one, and wonder if anyone has one made for this
Hello,
I was surprised today that the following code actually displayed a value:
http://www.cftools.test/formtest.cfm?form.test=test
Here is the code:
cfoutput
#form.test#
/cfoutput
Why does this work? Is it considered a bug?
I did find that if I referenced the form variable like this
I was surprised today that the following code actually displayed a value:
http://www.cftools.test/formtest.cfm?form.test=test
Here is the code:
cfoutput
#form.test#
/cfoutput
Why does this work? Is it considered a bug?
I did find that if I referenced the form variable like this
I think the important part is everything between the pound signs.
So your RegEx is
(?:([^]+))|([^ ]+)
just use this with your favorite function
Just use the ReFindNoCase(), or ReFind() functions with the
returnsubexpressions attribute set to true.
then it's a matter of using other functions
Up until know I thought that scoping variables with form. that you were
guaranteed those variables were coming from a form post.
So now my question is how do you guarantee that the variable came from
the form scope?
is using form[firstname] sufficient?
What about checking
So now my question is how do you guarantee that the variable came from
the form scope?
cfif structkeyexists(form,myvarname)
!--- do whatever ---
/cfif
-- Josh
~|
Adobe® ColdFusion® 8 software 8 is the most important and
Up until know I thought that scoping variables with form. that you were
guaranteed those variables were coming from a form post.
This is one of those things that has varied from one version of CF to
another, if I recall correctly.
So now my question is how do you guarantee that the variable
I'm running CF 7.02 on a Linux server (Red Hat,Plesk 8, Apache) and would like
to have Coldfusion parse .html files as it would .cfm files. I have root
access to the server, and am hosting about 100 domains on the box. I only want
Coldfusion to process .html files as .cfm for one particular
Hello,
Following is as detailed a description as i can give as to my problem:
Problem: I am making a sign in form that will allow my customers
access to a private page populated with information specifically
targeted toward them and their account info. Within this form I have a
set of 3 cookies
2008/10/2 Dave Watts [EMAIL PROTECTED]
Up until know I thought that scoping variables with form. that you were
guaranteed those variables were coming from a form post.
This is one of those things that has varied from one version of CF to
another, if I recall correctly.
Yes, bits of this
Hello All,
We have a production CFMX server with approx 20 oracle datasources(all coming
from the same server, yes I know single point of failure).
Anyways, whenever our DB server crashes here's what happens:
10/01 19:37:09 metrics Web threads (busy/total): 0/1 Sessions: 3848 Total
We see the same thing.
We're trying Oracle RAC. In the meantime we haven't found any way to ease
the problem; the connections are probably coming from the pool so the login
timeout won't help.
You could run a page that programatically sets all the datasources to
disabled. Of course you need to
We have a production CFMX server with approx 20 oracle datasources(all coming
from the same server, yes I know single point of failure).
Anyways, whenever our DB server crashes here's what happens:
10/01 19:37:09 metrics Web threads (busy/total): 0/1 Sessions: 3848 Total
Memory=468992
You can adjust your httpd.conf file. In the section for JRun, specify
..html as one of the file types to be parsed by your coldfusion instance
(you'll see a line with .cfm, .cfc, .cfr, etc).
Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
After playing around with this I discovered that the entries in the web.xml
file (#2 above) were case sensitive (probably a linux thing). I changed the
CFMServlet to CfmServlet and the server started processing .html .htm
files asif they were .cfm files.
The problem now is that it's doing
Any thoughts on how to get CF to NOT parse the .html or .htm files on all the
domains except 1?
You can't, really, if you're running a single instance of CF. You'd
have to run at least two instances, with web.xml configured in one
instance to allow this but not in the other. You'd then have to
If that's the case, is there a huge processing increase by running the standard
.html files through CF?
There's no CF code in the .html files for most of the domains on the server,
but is it still a big processing hit to the server to run all those files
through CF? It would probably add
We have two problems with clustering our CF 8.01 Multiserver (i.e. JRun)
installs.
1) Session replication is broken. When we turn off an instance in a cluster
that has session replication and stickiness turned on, the next server that
gets the request throws a null pointer error when trying to
The most important implication is that every request for an HTML file will
now take a thread in CF for the life of the request. It really does depend
on the demand on the box.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
2008/10/2 Scott Stevens
If that's the
for point 2there maybe some timeout setting on the network - if it cant see
it for a period of time it may think the cluster is dead.
Is the newtowrk under load when it drops out?
On Thu, Oct 2, 2008 at 2:28 PM, James Holmes [EMAIL PROTECTED] wrote:
We have two problems with clustering our CF
We're hoping to set up some monitoring to work that out. If there's a
verbose log level I can turn on at the server end it might help. I'll dig
around for that.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
2008/10/2 AJ Mercer [EMAIL PROTECTED]
for point
64 matches
Mail list logo
