oh yeah, i had said that in the message :) way
too many, but heck, it was too late...
tw
-Original Message-
From: Sean A Corfield [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 18, 2002 12:52 AM
To: CF-Talk
Subject: Re: limit cfoutput
On Saturday, August 17, 2002, at 08:34 , Tony
If I may throw out another suggestion -- have your database do the work for
you, so you are returning less data to the server -- might make the query
run a little faster as well. Most db's have the same sort of Left()
function as well.
Select
HTH,
TimP
-Original Message-
From: Corey
Brook Davies wrote:
Is it possible to update a row in a cached query? I want to do this when a
record in the cached record set is edited, as opposed to reloading/caching
the entire query.
I tried:
cfset temp = querysetcell(attributes.query_name, Company, TestValue,
attributes.start)
Can someone tell me how CF determines whether a query
is the same as a previously cached query?
Does it require an exact match on both the queryName
and the SQL (including whitespace)?
Is this matching criteria DB independent?
Is this version dependent (MX, 5, 4.5)?
=
I-Lin Kuo
CFForm does not work on our installation of MX. The java it generates
does nothing. It does not error, and when you click submit it just
submits... it does not validate, or check for required. It generates
this java:
SCRIPT LANGUAGE=JavaScript TYPE=text/javascript
Is this the expected behaviour, or a bug (CFMX)?
If NOT required:
cfinput type=Text name=MonthlyIncome message=Monthly Income must be a
valid Number validate=integer required=No
Will simply return an error Error in MonthlyIncome (or something like
that...) rather than using the defined
CFForm does not work on our installation of MX. The
java it generates does nothing. It does not error,
and when you click submit it just submits... it does
not validate, or check for required. It generates
this java:
SCRIPT LANGUAGE=JavaScript TYPE=text/javascript
Is this the expected behaviour, or a bug (CFMX)?
If NOT required:
cfinput type=Text name=MonthlyIncome message=Monthly
Income must be a valid Number validate=integer
required=No
Will simply return an error Error in MonthlyIncome (or
something like that...) rather than using the
Can someone tell me how CF determines whether a query
is the same as a previously cached query?
CF compares the SQL statement and the CFQUERY attributes, except for the
caching attribute itself. If they're all the same, and the cached query
hasn't timed out, CF will use the cached query. Note
Here is the code:
cfset CurrentPage=GetFileFromPath(GetTemplatePath())
cfparam name=PageNum_rsSongSelect default=1
cfquery name=rsSongSelect datasource=BahaiMusic
username=bahaimusicadmin password=xxx
SELECT ID, Songtitle, Author, Style, Tempo, Lyrics FROM dbo.tbl_songs
/cfquery
cfset
Ok... Trying again.
It appears that CFMX, when restarted, kills the connection between
itself and IIS. Does anyone know why this is, and/or how to fix it?
I've searched everywhere, and can't find the answer. Did I miss
something obvious??
TTAIA
I happened across BEA's JVM today, and tested 2 of my applications with it.
Both run without any problems so far. The coolest thing though is that
it is blazing fast.
On my home computer, with mp3's playing etc. Here are some unscientific
averages for the front page of a forum app that deals
I have never had this happen to our MX boxes. What error do you get?
Are your restarting the service?
-Original Message-
From: Lee Fuller [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 18, 2002 11:12 AM
To: CF-Talk
Subject: Someone must know about this...
Ok... Trying again.
Basically, here's what's happening:
(CFMX, Upgrade from 5 - IIS 5)
Whenever the CFMX application server is restarted, all CFM file calls to
the IIS server timeout, as if IIS somehow loses knowledge/connection to
CF. Almost as if the preprocessor simply wasn't installed. If we
restart
It appears that CFMX, when restarted, kills the connection
between itself and IIS. Does anyone know why this is, and/or
how to fix it? I've searched everywhere, and can't find
the answer. Did I miss something obvious??
I haven't run into this problem myself. In your IIS configuration, is
I just tried what you described.
I hit restart service, and refresh the page I am currently one I get:
Server Error
The server encountered an internal error and was unable to complete your
request.
I wait a few more seconds and hit refresh on the page and everything
works fine.
We ended up
I can see the logic in this, but for me it depends on the app. If you're
talking about a CMS, then almost certainly the text will be read
from the DB
for output on the front-end *many* more times than read out for editing or
input from the back-end. Seems like a good idea performance-wise to
I have a w2000 and cf 5 and under development with little or no test use
and after a few days IIs needs to be restarted. The error I get is web
server is not responding.
Lee Fuller wrote:
Basically, here's what's happening:
(CFMX, Upgrade from 5 - IIS 5)
Whenever the CFMX
Are you restarting the ODBC services?
--
jon
mailto:[EMAIL PROTECTED]
Sunday, August 18, 2002, 12:26:12 PM, you wrote:
LF Basically, here's what's happening:
LF (CFMX, Upgrade from 5 - IIS 5)
LF Whenever the CFMX application server is restarted, all CFM file calls to
LF the IIS
Has anyone ever tried to set up a mail list that could be used for a scheduled QA
with a set topic? Something like on Monday someone would let all the house of fusion
lists know the topic and then people could spend a week talking about it. The topics
could range from verity to security.
I
This is the one that worked! Thanks Norman
At 12:20 AM 08/18/2002 -0400, you wrote:
Here's how I do it, hopefully we're talking about the same thing...
CFQUERY Name=Companies DataSource=Blah
SELECT CompanyName, Left(CompanyName,1) AS FirstLetter FROM
Companies
/cfquery
CFOUTPUT
I'm all for it. I've done ICQ lectures in the past on different subjects and it worked
out rather well. I'd suggest that we pull MM into this in a few ways for our (and
their) benefit. Lets say that we make use of the flash communication server. They set
it up and advertise it. Someone is
I believe the default jvm on windows is IBM but I'm not 100%...thx for the
tip I'm downloading it to try out. strangely enough they don't yet support
solaris...
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 18, 2002 12:13 PM
To: CF-Talk
Subject: BEA
I'm seeing examples crop up in a lot of places using cfmx and cfldap with
Microsoft's active directory to integrate authentication frameworks.
Unfortunately it's a little misleading considering CFLDAP is not functional
over HTTPS in combination with Active directory. (u can always send
everyone's
Kreig's advice is spot on!
If you think the application through, I believe that you will come to
the same conclusion.
Many thanks to everyone that responded to my post. After reading through
everyone's suggestions I've decided to follow Kreig's advice of creating a
database record for every
I'm new to Java. Do Jrun and other app servers (Bea Weblogic) use a common
JVM which is independent from the application server? I guess what I'm
asking is does this JVM from BEA work with CFMX? How would one install it?
Is it as easy as installing it over the existing JVM or is there more to
Stacy Young wrote:
MM techs have attributed this to Microsoft's quirkiness in
LDAP protocol support...regardless...considering Microsoft's install
base...might be a good idea to play by their rules.
And let us all write email client software that throws an error if
somebody starts a line
Forgive me if this same question was going through from my work email, I am having
problems with that email.
My question was the following:
I have a CF page with 7 form elements on it: 3 select boxes, 2 multi select boxes and
2 buttons.
I am populating the 3 select boxes and 1 multi select
I'm new to Java. Do Jrun and other app servers (Bea
Weblogic) use a common JVM which is independent from
the application server? I guess what I'm asking is
does this JVM from BEA work with CFMX? How would
one install it? Is it as easy as installing it over
the existing JVM or is there
I have a cf page which calls 4 different cfcomponents using cfinvoke in
sequential order. Would it be faster to use the inherit property so only 1
cfinvoke command was issued and the one component called the others
methods? Is this an appropriate use of inheritance?
thanks :) .bd
If you're going to do this without 'refreshing' the page...it's going to
require a fairly sizable array in the javascript.
You'd first need an array of states...then an array of all cities within
each state (JS doesn't natively support 2d arrays, so you have to do arrays
of arrays). Further, an
I get the following error every time I try to access the data source
options page in the administrator. I'm not sure when this started happening
exactly, but It was working at one point. Also, this only happens when
trying to create an ODBC Socket Connection.
I'd love to try the Type 4
there is a custom tag two_selects_related and there is a tag
three_selects_related. Looks like you want 4, but you can check macromedia
developer exchange.
On Sun, 18 Aug 2002, Mike Tangorre wrote:
Forgive me if this same question was going through from my work email, I am having
problems
I think I found a way around this by breaking the page out of the frameset
and adding the datasource=test to the query string.
This seems to work, but I wonder why the datasource name is not being
passed correctly in the first place..
At 03:41 PM 18/08/02 -0700, you wrote:
I get the following
I'd love to try the Type 4 Drivers, but unfortunately I'm
still running MSSQL 7.
According to the documentation, the Type 4 drivers supplied with CF MX would
work with SQL Server 7 and 2000. You can't connect to SQL Server 6.5 and
earlier with those drivers, though.
Dave Watts, CTO, Fig Leaf
Dave,
I haven't had much luck trying use the SQL Server Drivers from CF. I think
it has something to do with using trusted connections. I'm not sure how to
set up SQL Server to accept logins via a username and password. I have
changed the default account SQL Server is running under, and
I haven't had much luck trying use the SQL Server Drivers
from CF. I think it has something to do with using trusted
connections. I'm not sure how to set up SQL Server to accept
logins via a username and password. I have changed the default
account SQL Server is running under, and
On Sunday, August 18, 2002, at 03:23 , Brook Davies wrote:
I have a cf page which calls 4 different cfcomponents using cfinvoke in
sequential order. Would it be faster to use the inherit property so only
1
cfinvoke command was issued and the one component called the others
methods? Is this
Hi Mike:
I threw together a quick (basic) javascript that allows you to select 1 of 3
states, then one of 3 cities, then one of 3 streets.
It's at http://130.13.170.56:6699/bigArray.html
you can view the source to see what the arrays look like. Since I assume
your data is coming from a
Oh, yes, very biased. ;-)
I'll be interested in your feedback, good and bad.
Vince Bonfanti
New Atlanta Communications, LLC
-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 8:55 PM
To: CF-Talk
Subject: RE: CF Express
No bias
My IT person can't seem to find Only the IPs below on the relay tab in
exchange for Exchange 5.5. What is he missing here?
Jim Watkins
- Original Message -
From: Christopher Olive [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, August 15, 2002 10:43 AM
Subject: RE: MS
thanks for taking the time to throw that together!
That is a good start for me.. i'll shoot ya an email offlist when I get the
task done!
Thanks again.
Mike
- Original Message -
From: Charlie Griefer [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, August 18, 2002 7:06 PM
Did you see any mention of price for this product?
At 06:10 PM 18/08/02 -0400, you wrote:
I'm new to Java. Do Jrun and other app servers (Bea
Weblogic) use a common JVM which is independent from
the application server? I guess what I'm asking is
does this JVM from BEA work with CFMX? How
1) Any one know how to configure CFMX so that the flash gateway does not
have to be listening on the default IIS web site?
As most web software like to install stuff into the default IIS web site,
we prefer to keep it locked down answers only to 127.0.0.1, this breaks
flash integration not work.
Seth
Here is one of those places where it is convenient to set/use a business
policy.
Again, I f you think about the application, how far in advance can one
realistically
schedule a recurring event -- I would guess 6 months, tops.
So, set a policy that your application sets N recurring
On Sunday, August 18, 2002, at 04:23 , Steve Budan wrote:
2) Also with CF versions prior to MX it was very easy to have CF process
other file extension, like .htm and .html. Can't seem to get this work
with
CFMX either. Went and added the extension much like in CF5 and earlier but
CF did
Okay, partner brought me this, probably an easy fix, but up to our
elbows and can't find the forest. Please shed some light on where we
have fouled up.
We are trying to do a report which grabs by state, the sum of orders,
avg order total, and we are trying to unsuccessfully do so...here it is:
Not sure, but in both cases I got the expected pop up message.
Cheers,
Mark
Is this the expected behaviour, or a bug (CFMX)?
If NOT required:
cfinput type=Text name=MonthlyIncome message=Monthly Income must be a
valid Number validate=integer required=No
Will simply return an error Error in
did you do a cfparam=monthlyIncome Default=??
-Original Message-
From: mark brinkworth [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 18, 2002 9:11 PM
To: CF-Talk
Subject: Re: cfinput message on error question
Not sure, but in both cases I got the expected pop up message.
Cheers,
I think you can do this all within a single SQL query, itself (no loop
invoking multiple queries).
SQL Group By and Order By can be used to group and sort the results.
The IN operator of the WHERE clause will allow you to select any
record which matches any value IN the state or country
Is there anything like a Phone Dialer tag out there? I need to add it to
my web based contact manager because that's one of the few critical
functions I don't have yet...
Go to Contact X
Click a form button next to the phone field - auto-dial the number in that
field...
: did you do a cfparam=monthlyIncome Default=??
No on the form itself...
I check it inside the SQL Insert statement:
cfif IsDefined(FORM.monthlyIncome) AND #FORM.monthlyIncome# NEQ
#FORM.monthlyIncome#
cfelse
'0'
/cfif
Been using the demo chat room that comes with the Flash Comm server (I have
personal edition)...It seems that after a certain amount of use...the chat
client just dies and doesn't allow any connections. No one can log into the
chat until the sevices is restarted...I'm thinking it may just be the
Okay, I see where you are going...so do all the sums, avg blah where in
statelist...final question, when using aggregate functions like this, we
have all these extra columns not being used for *necessarily* for the
joins or selection of data, just for outputthey all have to be
accounted for
Does anyone here use Post.Office for a listserv?
I have setup a list but and everything is working but the Prologue and
Epilogue text doesn't show up.
Rick
__
Signup for the Fusion Authority news alert and keep up with the
hmmm... ok... sheesh, i have never seen this many errors for one or two days in an
event log before!
here it is... first occurence of : The server failed to load application
'/LM/W3SVC/1/ROOT'. The error was 'c03b'.
10:37:07
under app logs... at exactly the same time(10:37:07) i got this
If I'm not mistaken, this list use to run on Post.Office. It's not anymore,
and there is a reason. Run forest run!
-Cameron
-
Cameron Childress
Sumo Consulting Inc.
---
cell: 678-637-5072
aim: cameroncf
email: [EMAIL PROTECTED]
-Original Message-
From: cfhelp
On Wednesday, August 7, 2002, at 04:43 , Brook Davies wrote:
If I have a page which calls several distinct CFC's one after another, is
there a speed increase if I create a container CFC and use the
inheritance function to inherit the functionality from the other CFC's?
You can only inherit
My webserver.log file shows the following message :
Error,TID=1652,08/18/02,08:37:42,Web server provided content data
when none was expected. Data ignored.
Does anyone know what this means ? We are running CF 4.5 SP2 with IIS 5 on
WIN 2K Server, and SQL 2000 DB.
Vishal.
ah. 5.5. i was talking about 2000. 5.5. handles relay differently, but
the box and checkbox should say something to that effect.
http://www.exchangeadmin.com/Articles/Index.cfm?ArticleID=7696
has complete instructions on how to secure relay on 5.5. notice that it has
to be at least exchange
As I recall, when you use aggregate functions and a group by clause, any
columns referenced in the select clause outside the aggregate function,
must be included in the group by clause.
Realize that columns that appear in the where and join clauses do *not*
need to appear in the Select clause
From what I understand, MX is also a web server so what's the reason for
running IIS 5.0 with the MX server?
Nathaniel
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 18, 2002 9:43 AM
To: CF-Talk
Subject: RE: Someone must know about this...
I just
From what I understand, MX is also a web server so what's
the reason for running IIS 5.0 with the MX server?
There are lots of reasons for wanting to use an external web server. For
one, the built-in web server provided with CF MX isn't considered suitable
for production use by Macromedia.
I noticed something odd in the test code below...
On Friday, August 16, 2002, at 07:38 , Sean A Corfield wrote:
On Friday, August 16, 2002, at 12:25 , Douglas Brown wrote:
cfset myString =
...
cfset myString = 1
So the test of 'eq' is against an empty string but the test of 'len()' is
From what I understand, MX is also a web server so what's the reason for
running IIS 5.0 with the MX server?
It comes with a built in webserver for development, but it's not intended
for production use.
From Installing ColdFusion MX Chapter one:
ColdFusion MX has its own web server that you
I'd be grateful if anyone on the list could point me to any examples of
Verity and CF to look at please.
**
Kevin Parker
Web Services Manager
WorkCover Corporation
[EMAIL PROTECTED]
www.workcover.com
p: 08 82332548
f: 08 82332000
m: 0418 806 166
**
We are talking about CFMX right? Not CF5, in CF5, cfif Len(trim(str)) is
faster empty or not ...right?
Paul Giesenhagen
QuillDesign
I noticed something odd in the test code below...
On Friday, August 16, 2002, at 07:38 , Sean A Corfield wrote:
On Friday, August 16, 2002, at 12:25 ,
It would be fairer to compare
Trim(emptyString) eq instead of emptystring eq .
It's not fair to say that 'eq ' is simpler than
len(trim(nonEmptyString)) when the second case is performing one extra
optional function.
-Original Message-
From: Sean A Corfield [mailto:[EMAIL
I have a huge Sales Application 99.99% completed and
after hours of attempts. I'm stumped on the last part!
Please send any help/advice. Thanks.
I'm trying to extract values from a query from within a
Custom Tag. I can get a record count value, but not a
needed date column/value. Argh!
On Sunday, August 18, 2002, at 08:38 , Matthew Walker wrote:
It would be fairer to compare
Trim(emptyString) eq instead of emptystring eq .
It's not fair to say that 'eq ' is simpler than
len(trim(nonEmptyString)) when the second case is performing one extra
optional function.
I was
On Sunday, August 18, 2002, at 08:25 , Paul Giesenhagen wrote:
We are talking about CFMX right? Not CF5, in CF5, cfif Len(trim(str))
is
faster empty or not ...right?
The original post in this thread showed that was about twice as fast as
sstr eq (and was talking about CF5 or earlier).
If
There is a forum search here you can lok at. Feel free to download the
code if you like it.
Search Example
http://cfhub.com/forum//index.cfm?FuseAction=Search
Download
http://cfhub.com/tutorials/advancedverity/
(Simpler version)
http://cfhub.com/tutorials/verity/
I'd be grateful if anyone on
I agree with you Sean regarding readability. I just didn't think it was
reasonable to quote the results of timed tests when one version was
trimming and the other wasn't. I'm sure most of us think that usually
readable code is worth a small speed sacrifice anyway. There I go
assuming things...
- Original Message -
From: Sean A Corfield [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, August 18, 2002 8:18 PM
Subject: Re: Best Practices
snip
Which means that in CFMX, cfif str eq is best practice by both of the
definitions we've seen on the list.
this is the
On Sunday, August 18, 2002, at 09:33 , Matthew Walker wrote:
I agree with you Sean regarding readability. I just didn't think it was
reasonable to quote the results of timed tests when one version was
trimming and the other wasn't.
Actually if you read my detailed post with all the timings
On Sunday, August 18, 2002, at 09:38 , Charlie Griefer wrote:
this is the kind of thing that really makes me want to consider an
exciting
career in the field of house-painting.
You mean, rather than recommending len(trim(x)) over x eq ? :) :) :)
As always with these sorts of questions,
Your problem is unecessary use of string values and the evaluate() function
call ...
Pass the actual query to your custom tag rather than the name of the query
instead of using the evaluate function at all, i.e:
Your custom tag currently looks like
cf_mycustomtag query=myquery
change it to
77 matches
Mail list logo
