IP Geolocation API?

[webmaster]

Anybody know of any API services out there (free would be best) that
allow the lookup of a person's location based on their IP address?
Trying to implement a system for a client that is show me the closest 5
locations to my area type of thing and they don't want to use zip code.
Any ideas much appreciated.

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349617
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Need selectedIndex of cfselect after bind

[webmaster]

Yup figured it out. Thanks.

var DD = document.getElementById("ItemNameA");
var DDSelIndex = DD.selectedIndex;
var DDValue = DD.options[DDSelIndex].value;


-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Wednesday, January 04, 2012 5:03 PM
To: cf-talk
Subject: Re: Need selectedIndex of cfselect after bind


to get the value use

dd.value

to get the text of the selectIndex use

DD.options[DD.selectedIndex].text



On Wed, Jan 4, 2012 at 9:03 PM,  wrote:

>
> Ok I have some code that allows a user to type a word in a cfinput and

> then it suggests records from the database in a cfselect that is bound

> to that cfinput. Then I need to be able to submit that record using 
> ajax to insert some data into a database.
>
>
>
> The problem comes in when I try to reference the items in the cfselect

> drop down by using the JavaScript for getting the value of the 
> selected record like so
>
>
>
> var DD = document.getElementById("ItemNameB");
>
> DD.options[DD.selectedIndex].value
>
>
>
> When I try this and submit it I get the error
>
>
>
> "Index or size is negative or greater than the allowed amount"
>
>
>
> It seems as if the JavaScript cannot access the records brought in 
> from the database after the bind. Can anybody confirm this? Have a 
> suggestion for a different way to get that value?
>
>
>
> 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349316
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Need selectedIndex of cfselect after bind

[webmaster]

Ok I have some code that allows a user to type a word in a cfinput and
then it suggests records from the database in a cfselect that is bound
to that cfinput. Then I need to be able to submit that record using ajax
to insert some data into a database.

 

The problem comes in when I try to reference the items in the cfselect
drop down by using the JavaScript for getting the value of the selected
record like so

 

var DD = document.getElementById("ItemNameB");

DD.options[DD.selectedIndex].value

 

When I try this and submit it I get the error 

 

"Index or size is negative or greater than the allowed amount"

 

It seems as if the JavaScript cannot access the records brought in from
the database after the bind. Can anybody confirm this? Have a suggestion
for a different way to get that value?



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349312
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: CFHTTP Connection Failure on SSL

[webmaster]

Ok thank you. My next step is to try to update the JVM and see what that
does. Makes no sense why it works for a little bit after a reboot then
starts Connection Failure again.

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Tuesday, September 06, 2011 4:59 PM
To: cf-talk
Subject: Re: CFHTTP Connection Failure on SSL


> Does an updated KeyStore come with an updated JVM?

Each JVM has its own keystore. So, if you switch to a newer JVM, you'll
have to reimport certificates into that JVM keystore if you want them.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA
Schedule, and provides the highest caliber vendor-authorized instruction
at our training centers, online, or onsite.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347262
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: CFHTTP Connection Failure on SSL

[webmaster]

Yeah I'm not sure what to do next. After a reboot it works fine for about 5 min 
or so then goes back to Connection Failure. Makes no sense. :(


-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Tuesday, September 06, 2011 3:39 PM
To: cf-talk
Subject: Re: CFHTTP Connection Failure on SSL


> Nope I tried a restart of the service and it still says connection 
> failure.  Says I am using JVM 1.6.0_14 What is the latest supported JVM?

This is the latest 1.6 JVM:
http://www.oracle.com/technetwork/java/javase/downloads/jdk-6u27-download-440405.html

I don't know if it's supported, I'd have to check the Adobe site, but usually 
the latest update to the currently-supported major version works fine.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and 
provides the highest caliber vendor-authorized instruction at our training 
centers, online, or onsite



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347260
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: CFHTTP Connection Failure on SSL

[webmaster]

Does an updated KeyStore come with an updated JVM?




-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Tuesday, September 06, 2011 3:39 PM
To: cf-talk
Subject: Re: CFHTTP Connection Failure on SSL


> Nope I tried a restart of the service and it still says connection 
> failure.  Says I am using JVM 1.6.0_14 What is the latest supported JVM?

This is the latest 1.6 JVM:
http://www.oracle.com/technetwork/java/javase/downloads/jdk-6u27-download-440405.html

I don't know if it's supported, I'd have to check the Adobe site, but usually 
the latest update to the currently-supported major version works fine.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and 
provides the highest caliber vendor-authorized instruction at our training 
centers, online, or onsite



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347256
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: CFHTTP Connection Failure on SSL

[webmaster]

Nope I tried a restart of the service and it still says connection
failure.  Says I am using JVM 1.6.0_14 What is the latest supported JVM?

Seems like it should work all the time or none at all. Seems odd that it
works intermittently.  I appreciate all your help.

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Tuesday, September 06, 2011 3:20 PM
To: cf-talk
Subject: Re: CFHTTP Connection Failure on SSL


> Ok did that and the cfhttp worked one time. Now it tells me Connection

> Failure again. Any ideas? Seems like it should either work or it 
> shouldn't.

I don't really have any other ideas about what could cause the problem.
If you stop and restart CF, does it work one time again? What JVM are
you using? Can you try upgrading to the latest supported JVM, adding the
certificates to the new keystore and trying again?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA
Schedule, and provides the highest caliber vendor-authorized instruction
at our training centers, online, or onsite.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347252
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: CFHTTP Connection Failure on SSL

[webmaster]

Ok did that and the cfhttp worked one time. Now it tells me Connection
Failure again. Any ideas? Seems like it should either work or it
shouldn't.


-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Tuesday, September 06, 2011 2:39 PM
To: cf-talk
Subject: Re: CFHTTP Connection Failure on SSL


> Ok my next question would be how do I get the entire chain? Do I have 
> to get it directly from them? So far I have just saved the Certificate

> from the browser. I was assuming this saved all of them but perhaps it

> only saves the root one?

Your browser will have a screen where it shows you all the certificates
within the chain. You can select each and save it in turn.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA
Schedule, and provides the highest caliber vendor-authorized instruction
at our training centers, online, or onsite.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347247
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: CFHTTP Connection Failure on SSL

[webmaster]

Ok my next question would be how do I get the entire chain? Do I have to
get it directly from them? So far I have just saved the Certificate from
the browser. I was assuming this saved all of them but perhaps it only
saves the root one?

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Tuesday, September 06, 2011 2:28 PM
To: cf-talk
Subject: Re: CFHTTP Connection Failure on SSL


> Ok that gave me the "Certificate was added to the keystore" message 
> but after I restart ColdFusion and I attempt to CFHTTP to the URL I 
> still get a connection failure message. Not sure what to even try next

> :(

There can be all kinds of things that go wrong with certificates. Does
the site use just a root certificate, or do they also have an
intermediate certificate? You'll have to import the entire certificate
chain if the latter is the case.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA
Schedule, and provides the highest caliber vendor-authorized instruction
at our training centers, online, or onsite.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347244
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: CFHTTP Connection Failure on SSL

[webmaster]

Ok that gave me the "Certificate was added to the keystore" message but
after I restart ColdFusion and I attempt to CFHTTP to the URL I still
get a connection failure message. Not sure what to even try next :(


-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Tuesday, September 06, 2011 2:20 PM
To: cf-talk
Subject: Re: CFHTTP Connection Failure on SSL


> However it asks me for the cert password. Is this something I need to 
> get from the owner of the cert or am I just typing in the wrong set of

> params? On some of the other tutorisla that are similar I see no 
> refernece to needed a password.

Do you mean the keystore password? The default password for the Java
keystore is "changeit". The certificate itself should have no password.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA
Schedule, and provides the highest caliber vendor-authorized instruction
at our training centers, online, or onsite.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347241
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: CFHTTP Connection Failure on SSL

[webmaster]

Thanks for the reply.

I am trying the tutorial found here. Short and simple.

http://naveenchhabra.wordpress.com/2010/10/18/trusting-certificate-in-co
ldfusion-using-keytool-utility/

However it asks me for the cert password. Is this something I need to
get from the owner of the cert or am I just typing in the wrong set of
params? On some of the other tutorisla that are similar I see no
refernece to needed a password.



-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Tuesday, September 06, 2011 1:57 PM
To: cf-talk
Subject: Re: CFHTTP Connection Failure on SSL


> We recently had an API call using a CFHTTP start giving a Connection 
> Failure message. In talking with the other company I found out they 
> updated their security certificate. All the comments I have seen in 
> this list and on blogs etc. pertaining to this issue seem to relate to

> ColdFusion MX. Does this problem still exist in CF 9 Ent? If so does 
> anybody have any updated tutorial on how to fix this? Thanks in 
> advance for your help.

The problem still exists, and will probably exist for the foreseeable
future. The solution is really still the same as with older versions, so
those tutorials should still apply.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347239
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

CFHTTP Connection Failure on SSL

[webmaster]

We recently had an API call using a CFHTTP start giving a Connection
Failure message. In talking with the other company I found out they
updated their security certificate. All the comments I have seen in this
list and on blogs etc. pertaining to this issue seem to relate to
ColdFusion MX. Does this problem still exist in CF 9 Ent? If so does
anybody have any updated tutorial on how to fix this? Thanks in advance
for your help.

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347235
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Need DHL Code

[webmaster]

I've already done some googling. I was just hoping somebody out there in
the CF community already knew of a working solution.



-Original Message-
From: Pradeep Viswanathan [mailto:pradeepviswanatha...@gmail.com] 
Sent: Friday, April 15, 2011 11:08 AM
To: cf-talk
Subject: Re: Need DHL Code


There are couple of others  results which could be of use when you
google for "dhl tracking api"

On 15-Apr-2011 8:19 PM,  wrote:


Can anyone out there point me in the direction of some CF code or
software package free or otherwise that interfaces with DHL both
domestic and internationally? I see the one with adminprotools but I
can't get a reply from them to questions so looking for other
possibilities.







~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343750
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Need DHL Code

[webmaster]

Can anyone out there point me in the direction of some CF code or
software package free or otherwise that interfaces with DHL both
domestic and internationally? I see the one with adminprotools but I
can't get a reply from them to questions so looking for other
possibilities.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343747
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Performance Issue with CFLOOP

[webmaster]

This sounds like a good solution. Do you just call the same page over
and over with the cfhttp at the bottom passing a record variable until
you reach the end of file or you doing something different?


-Original Message-
From: Mark Mandel [mailto:mark.man...@gmail.com] 
Sent: Wednesday, March 09, 2011 9:03 PM
To: cf-talk
Subject: Re: Performance Issue with CFLOOP


Batch stuff like this, I tend to break into chunks, and call each chunk
via a cfhttp call. (maybe 1000 records or so per chunk?)

That way you get a single request, that can be entirely gc'd after each
request.

Worked well for me in the past.

Mark

On Thu, Mar 10, 2011 at 10:26 AM, Michael Grant  wrote:


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342877
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Performance Issue with CFLOOP

[webmaster]

I thought of this but not a lot of experience here since in my loop
there are lots of ifs and conditions then updates etc. I'm reading up on
it though.




-Original Message-
From: Andrew Scott [mailto:andr...@andyscott.id.au] 
Sent: Wednesday, March 09, 2011 9:07 PM
To: cf-talk
Subject: RE: Performance Issue with CFLOOP


Not sure what query you are calculating to add back to the original
query, but can it not be done on the database via sql? It would be a
hundreds times quicker than looping over a query to then do it.

Regards,
Andrew Scott
http://www.andyscott.id.au/





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342876
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Performance Issue with CFLOOP

[webmaster]

This sounds like a good solution. Do you just call the same page over
and over with the cfhttp at the bottom passing a record variable until
you reach the end of file or you doing something different?





-Original Message-
From: Mark Mandel [mailto:mark.man...@gmail.com] 
Sent: Wednesday, March 09, 2011 9:03 PM
To: cf-talk
Subject: Re: Performance Issue with CFLOOP


Batch stuff like this, I tend to break into chunks, and call each chunk
via a cfhttp call. (maybe 1000 records or so per chunk?)

That way you get a single request, that can be entirely gc'd after each
request.

Worked well for me in the past.

Mark

On Thu, Mar 10, 2011 at 10:26 AM, Michael Grant  wrote:

>
> Good luck.
>
> On Wed, Mar 9, 2011 at 4:44 PM,  wrote:
>
> >
> > Ok I tried this. I took all the flushes out but one so only one 
> > timer per loop and ran it over 5000 records.
> >
> > With all the flushes in place total execution time was 111905 ms 
> > With only one flush total execution time for the same query was 
> > 74622 ms
> >
> > A difference of a little over 37 seconds
> >
> > With no flushing at all total execution time was 70520 ms
> >
> > A total difference of a little over 41 seconds
> >
> > So it does appear the flushing is the cause of some of the slowdown.
> >
> > However I tried running the loop over 10k records and I run into 
> > this error
> >
> > GC overhead limit exceeded null
> >
> > I have increase my maximum heap size to 1500mb so will try again. :(
> >
> > -Original Message-
> > From: Michael Grant [mailto:mgr...@modus.bz]
> > Sent: Wednesday, March 09, 2011 4:12 PM
> > To: cf-talk
> > Subject: Re: Performance Issue with CFLOOP
> >
> >
> > Are you sure it's actually the loop slowing down or is it your 
> > browser slowing down from all the cfflush-ing? Try removing the 
> > cfflush and track the time it takes by writing the execution time to

> > an array then dump out the array after the loop completes and
compare your results.
> > That will at least help you narrow down if it's truly a problem with

> > the loop.
> >
> >
> >
> > On Wed, Mar 9, 2011 at 4:03 PM,  wrote:
> >
> > >
> > > Looking for any ideas here.
> > >
> > >
> > >
> > > I'm running a cfloop over a query from a database with a little 
> > > over
> > > 60,000 records in it on MSSQL. I am doing a cfflush so I can watch

> > > what record it is on so I can keep up with how quickly or slowly 
> > > the loop is running. The problem is after about 4850ish records 
> > > the loop slows waaay down. Any idea why the speed change or how I 
> > > can stop it
> > from happening?
> > > All I am doing is querying 2 columns and based on the data in 
> > > those 2 I am updating 3 other columns. So it looks up the data 
> > > then loops over
> >
> > > it then updates each record with some new data. Runs great till 
> > > about 95% of the loop. Looking for any ideas out there.
> > >
> > >
> > >
> > >
> >
> >
> >
> >
>
> 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342875
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Performance Issue with CFLOOP

[webmaster]

Ok I tried this. I took all the flushes out but one so only one timer
per loop and ran it over 5000 records.

With all the flushes in place total execution time was 111905 ms
With only one flush total execution time for the same query was 74622 ms

A difference of a little over 37 seconds

With no flushing at all total execution time was 70520 ms

A total difference of a little over 41 seconds

So it does appear the flushing is the cause of some of the slowdown.

However I tried running the loop over 10k records and I run into this
error

GC overhead limit exceeded null

I have increase my maximum heap size to 1500mb so will try again. :(

-Original Message-
From: Michael Grant [mailto:mgr...@modus.bz] 
Sent: Wednesday, March 09, 2011 4:12 PM
To: cf-talk
Subject: Re: Performance Issue with CFLOOP


Are you sure it's actually the loop slowing down or is it your browser
slowing down from all the cfflush-ing? Try removing the cfflush and
track the time it takes by writing the execution time to an array then
dump out the array after the loop completes and compare your results.
That will at least help you narrow down if it's truly a problem with the
loop.



On Wed, Mar 9, 2011 at 4:03 PM,  wrote:

>
> Looking for any ideas here.
>
>
>
> I'm running a cfloop over a query from a database with a little over
> 60,000 records in it on MSSQL. I am doing a cfflush so I can watch 
> what record it is on so I can keep up with how quickly or slowly the 
> loop is running. The problem is after about 4850ish records the loop 
> slows waaay down. Any idea why the speed change or how I can stop it
from happening?
> All I am doing is querying 2 columns and based on the data in those 2 
> I am updating 3 other columns. So it looks up the data then loops over

> it then updates each record with some new data. Runs great till about 
> 95% of the loop. Looking for any ideas out there.
>
>
>
> 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342861
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Performance Issue with CFLOOP

[webmaster]

Thanks a bunch :)

-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com] 
Sent: Wednesday, March 09, 2011 4:34 PM
To: cf-talk
Subject: Re: Performance Issue with CFLOOP


Yes, tweaking your JVM settings (including max heap) *can* fix this.  Of
course you are limited to the amount of RAM you have available to you,
which is limited by both the physical RAM installed and potentially your
OS.

I am by no means an expert on this particular topic.  I usually rely on
Mike Brunt (http://www.cfwhisperer.com/), one of the greatest minds on
CF/JVM tweaking, or on Google.  JVM tuning is a pretty common topic on
various lists and blogs.  I would suggest starting at Mike's blog,
honestly.

And yes, the slowdown that you are seeing across all requests is because
the JVM is out of memory.  If you peruse your logs, you will most likely
find all kinds of java.lang.OutOfMemoryError messages.

HTH




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342859
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Performance Issue with CFLOOP

[webmaster]

Can simply increasing the size of the JVM max heap fix this?

Problem is when this loop slows down all of the CFM pages seems to slow
down and timeouts start to occur.


-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com] 
Sent: Wednesday, March 09, 2011 4:14 PM
To: cf-talk
Subject: Re: Performance Issue with CFLOOP


Yes, it will slow down with a query of that size.  This is totally
natural and completely expected behavior, because you are loading up the
JVM.  The closer you get to reaching its max threshold, the slower
things will become.

Is there any reason why you are not doing this in smaller segments?

Also, what about doing it on the db server instead of CF?




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342857
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Performance Issue with CFLOOP

[webmaster]

Looking for any ideas here.

 

I'm running a cfloop over a query from a database with a little over
60,000 records in it on MSSQL. I am doing a cfflush so I can watch what
record it is on so I can keep up with how quickly or slowly the loop is
running. The problem is after about 4850ish records the loop slows waaay
down. Any idea why the speed change or how I can stop it from happening?
All I am doing is querying 2 columns and based on the data in those 2 I
am updating 3 other columns. So it looks up the data then loops over it
then updates each record with some new data. Runs great till about 95%
of the loop. Looking for any ideas out there.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342854
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Latest Hot Fix Issues

[webmaster]

I am getting this random error after applying the latest security hotfix
to our CF 9.01 Enterprise installation.

 

Could not initialize class coldfusion.security.ESAPIUtils

 

I get it anytime I try to use cfwindow and I am also getting it when I
try to update the sitewide error template in the admin area. Anybody
else running into this or know how to fix it?



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342114
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

CMS for CF

[webmaster]

I'm looking for a good open source content management system for Cold
Fusion. Something like Joomla. Any suggestions out there?

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340745
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: cfc bind issue

[webmaster]

The root would be c:\mysite\ but I am executing the cfc from the admin
folder inside the site root. It is hitting the CFC fine because I can
see it return all the values like it should using the ajax debugging
window. It just doesn't put those values into the drop downs.


-Original Message-
From: Michael Grant [mailto:mgr...@modus.bz] 
Sent: Wednesday, December 01, 2010 11:47 AM
To: cf-talk
Subject: Re: cfc bind issue


and your site root resolves to mysite\admin?



On Tue, Nov 30, 2010 at 6:21 PM,  wrote:

>
> Ok this one has me scratching my head. I have a cfc located here.
>
>
>
> C:\mysite\admin\cfc\GetCategoryData.cfc
>
>
>
> I put this code on a page where I call it using the dot notation and 
> it does not populate the cfselect. The CFC is running fine according 
> to the debugger window. It just doesn't populate the CFSELECT with the
data.
>
>
>
> 
>
>  bindonload="true">
>
> 
>
>
>
>
>
> However when I create a mapping in CF admin and use it for the same 
> CFC it works fine. Like so.
>
>
>
> 
>
>  bind="cfc:mymapping.GetCategoryData.getCategory()"
> bindonload="true">
>
> 
>
>
>
> Any ideas as to why this could be? I don't want to create a mapping 
> for every site to use a CFC. Thanks in advance for any insight into
this.
>
>
>
>
>
> 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339688
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: cfc bind issue

[webmaster]

Renaming the cfc directory didn't seem to make any difference. Really
odd.



-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Tuesday, November 30, 2010 7:04 PM
To: cf-talk
Subject: Re: cfc bind issue


Your bind code looks fine to me, perhaps CF doesn't like you have the
CFC in a folder called CFC, worth a try.
Perhaps you are also not aware but you do not need to create a mapping
in the cfadmin, you can create per application mappings in your
application.cfc since CF8.

see here:
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=appFra
mework_04.html



--
Russ Michaels
www.cfmldeveloper.com - Supporting the CF community since 1999 FREE
ColdFusion/Railo hosting for developers.

blog: www.michaels.me.uk




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339648
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

cfc bind issue

[webmaster]

Ok this one has me scratching my head. I have a cfc located here.

 

C:\mysite\admin\cfc\GetCategoryData.cfc

 

I put this code on a page where I call it using the dot notation and it
does not populate the cfselect. The CFC is running fine according to the
debugger window. It just doesn't populate the CFSELECT with the data.

 







 

 

However when I create a mapping in CF admin and use it for the same CFC
it works fine. Like so.

 







 

Any ideas as to why this could be? I don't want to create a mapping for
every site to use a CFC. Thanks in advance for any insight into this.

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339645
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

CF Job Opportunity

[Webmaster]

Hi All,

Long time lurker, first time poster.  Hopefully I'm posting this on the right 
list--apologies if it's out of place here.

My organization is looking to hire a ColdFusion/SQL developer.  The job is 70% 
web/database development, and 30% other IT projects (servers, network, etc.).  
If you're generally tech-savvy you should be fine with the "other 30%" part of 
the job.  We're a small company (6 employees) with great benefits, competitive 
pay and an insanely generous 401(k) program.

We're located in Northern Virginia (Manassas).  This is an "in person" job, no 
telecommuting is available.  

If you're interested, send me your resume at ri...@ion.org 

Thanks!
Rick


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334596
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: coldfusion.ajax.submitform

[webmaster]

Thanks. The '' is what I was missing. Always something simple we
overlook in the end :)



-Original Message-
From: Kris Sisk [mailto:ks...@gckschools.com] 
Sent: Wednesday, April 07, 2010 9:26 AM
To: cf-talk
Subject: Re: coldfusion.ajax.submitform


You're passing an undefined variable rather than the form's id with your
link. Try this:

 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332705
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

coldfusion.ajax.submitform

[webmaster]

Is it not possible to have multiple cfforms on a page and submit them
using coldfusion.ajax.submitform

 

I tried this which I would think would work but it just gives this
JavaScript error "myform is not defined"

 

 

 

 

function submitForm(FormName) { 

var FormName = FormName;

alert(FormName); 

ColdFusion.Ajax.submitForm(FormName, '~form-action.cfm',
callback, errorHandler); 

} 

 

function callback(text) 

{ 

alert("Callback: " + text); 

} 

 

function errorHandler(code, msg) 

{ 

alert("Error!!! " + code + ": " + msg); 

} 



 

 

 

 

 



 

Any ideas as to how I can have more than one form on a page and
accomplish this?



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332648
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: CFIMAGE Path Issue

[webmaster]

I found the problem. It was that I was using both destination and name.
Apparently you can not use them both you have to choose one.



-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com] 
Sent: Saturday, January 02, 2010 3:08 PM
To: cf-talk
Subject: RE: CFIMAGE Path Issue


> Are you sure the TempFileName variable has a value?

I had no problems on windows. So I too suspect the path is not valid.
What is the value of:

#ExpandPath("..\images")#\temp\#TempFileName#"

? 


  



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329390
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFIMAGE Path Issue

[webmaster]

Yes it has a value.


-Original Message-
From: b...@bradwood.com [mailto:b...@bradwood.com] 
Sent: Saturday, January 02, 2010 3:02 PM
To: cf-talk
Subject: RE: CFIMAGE Path Issue


Are you sure the TempFileName variable has a value?

Aslo, CF9's VFS might be faster/easier for your temp directory.

~Brad

 Original Message 
Subject: CFIMAGE Path Issue
From: 
Date: Sat, January 02, 2010 12:55 pm
To: cf-talk 

 source = "#ExpandPath("..\images")#\temp\#TempFileName#"
 

The com\www\images\members\ image format is not supported on this
operating system. 





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329389
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFIMAGE Path Issue

[webmaster]

I really prefer not to. All of my sites are named with this convention.
It would be great if there was another way around this. All my other
cfdirectory and cffile stuff works fine with this type of pathing so I'm
not sure why cfimage won't.


-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com] 
Sent: Saturday, January 02, 2010 2:06 PM
To: cf-talk
Subject: RE: CFIMAGE Path Issue


> The com\www\images\members\ image format is not supported on this
operating system

Yes, it definitely looks like the code is interpreting everything after
the
"."
as the file extension...can you rename the "website.com" directory to
just
"website"?

Rick

-Original Message-
From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] 
Sent: Saturday, January 02, 2010 1:55 PM
To: cf-talk
Subject: CFIMAGE Path Issue


I'm trying to use CFIMAGE for the first time and running into an issue.
I am guess it is because my path has a period in it but I am not sure
and I am not sure how to get around it if that is indeed the problem.

 

I'm using ExpandPath to get the directory path but I have tried it other
way with the same result. The path is 

 

C:\Websites\mywebsite.com\www\images

 

I'm just trying to take a file in the
C:\Websites\mywebsite.com\www\images\temp directory and resize it then
rename it to the memberid with 300 on the end and save it to this
directory C:\Websites\mywebsite.com\www\images\members

 



 

 

I keep getting the folowing error.

 

The com\www\images\members\ image format is not supported on this
operating system. 

Any ideas?

 







~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329386
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CFIMAGE Path Issue

[webmaster]

I'm trying to use CFIMAGE for the first time and running into an issue.
I am guess it is because my path has a period in it but I am not sure
and I am not sure how to get around it if that is indeed the problem.

 

I'm using ExpandPath to get the directory path but I have tried it other
way with the same result. The path is 

 

C:\Websites\mywebsite.com\www\images

 

I'm just trying to take a file in the
C:\Websites\mywebsite.com\www\images\temp directory and resize it then
rename it to the memberid with 300 on the end and save it to this
directory C:\Websites\mywebsite.com\www\images\members

 



 

 

I keep getting the folowing error.

 

The com\www\images\members\ image format is not supported on this
operating system. 

Any ideas?

 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329384
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFC Mapping Issues

[webmaster]

Thank you.



-Original Message-
From: Kym Kovan [mailto:dev-li...@mbcomms.net.au] 
Sent: Friday, January 01, 2010 10:12 PM
To: cf-talk
Subject: Re: CFC Mapping Issues


webmas...@pegweb.com wrote:
> I'm running CF 9 Enterprise and am having trouble getting a cfc to
fire.
> 
> Here is my invoke which is run after a file upload in a form field.
> ...
>  component = "file-upload.FileUploader" 
> method = "UploadMemberImage" 
> returnVariable = "rVar" 
> argumentCollection = "#args#"> 
> 
> Here is my CFC.
> 
> 
>  The CFC is located in the same directory as the cfm file calling it.
The
 > cfc file is named file-upload.cfc


You have got your naming tangled up, the "name" attribute in the 




-- 

Yours,

Kym Kovan
mbcomms.net.au




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329383
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFC Mapping Issues

[webmaster]

I'm running CF 9 Enterprise and am having trouble getting a cfc to fire.


 

Here is my invoke which is run after a file upload in a form field.

 

 

 



 

 

 



 

 

Here is my CFC.

 



 









 







 

 

 



 



  





 

The CFC is located in the same directory as the cfm file calling it. The
cfc file is named file-upload.cfc 

I have tried suing a mapping, I have tried putting it in a subdirectory
and calling it. Same result. I get the error below.

Could not find the ColdFusion component or interface
file-upload.FileUploader. 

Ensure that the name is correct and that the component or interface
exists.

 

Any ideas as to where I am going wrong here?

 

 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329380
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Server Performance

[webmaster]

Thanks. I will look over these.


-Original Message-
From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] 
Sent: Friday, December 18, 2009 9:01 AM
To: cf-talk
Subject: RE: Server Performance


CFMeetup just had a meeting on "Homebrewed ColdFusion Monitoring" by Wil
Genovese.

It was an awesome meetup and the recording can be viewed at:
http://www.meetup.com/coldfusionmeetup/pages/Recordings_of_the_ColdFusio
n_Meetup-2009/

Or at: http://experts.na3.acrobat.com/p34004904/

Also Wil has put the presentation files up at his blog. They are at:
http://www.trunkful.com/index.cfm/2009/12/10/Homebrewed-ColdFusion-Monit
or-Presentation-Files

Steve


-Original Message-
From: Mark Kruger [mailto:mkru...@cfwebtools.com] 
Sent: Friday, December 18, 2009 8:46 AM
To: cf-talk
Subject: RE: Server Performance


2 things for you.

First, check the DB for blocks and locks - about 9 times out of ten
queuing
requests are due to DB requests that are hanging. For some reason we web
developers bang our head against CF over and over thinking there is
something we can do on the web server to solve problems that exist on
the DB
server :)

Secondly,  If you are already running perfmon then you can get the
information on which site is busiest (or at least handling the most
requests).

Choose "web service" and then "Current connections" and "all instances".
Use
the report view (the little page icon next to the chart icon on the
toolbar)
it is clearer.

Oh... "current connections"  is appropriate for Wind2003 and above. For
windows 2000 use "current anonymous users". 


What you should see (using the report view) is a horizontal list of all
your
sites. The "_total" will be the first item. On a busy server you may
need to
scroll to the right to see them all. You can click on them and delete
the
ones you know are not the problem. 

Even though seeFusion and fusionReactor are great tools, I set up saved
Perfomon mcc's for all my windows servers - in fact you can view the
counters remotely (if you have the right domain rules in place) and you
can
see more than one server at a time in the same perfmon instance. Granted
it
is less introspective than one of the Java tools  - but for a quick
glimpse
of a server to answer the question - how busy is it - in real time, it's
handy and easy.

-Mark



Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com

-Original Message-
From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] 
Sent: Thursday, December 17, 2009 6:20 PM
To: cf-talk
Subject: Server Performance


Is there a way through command line or a 3rd party application to see
what
web sites on a CF Pro 8 server are causing the most requests? On one
particular server it is starting to show behavior of page timeouts and
longer running requests. In the Performance Monitor in windows I see the
running requests will max out from time to time and then requests start
to
queue. I want to be able to determine which sites are generating the
most
requests so I can examine the traffic and the code on those sites for
potential problems. Anybody know of any way to do this?

 

 

 

 









~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329254
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Server Performance

[webmaster]

Thanks Mark this actually helped quite a bit. I didn't realize that
option was available in perfmon.

Thanks,
Patrick J. Hedgepath
Pegasus Web Productions
webmas...@pegweb.com
803-996-0578





-Original Message-
From: Mark Kruger [mailto:mkru...@cfwebtools.com] 
Sent: Friday, December 18, 2009 8:46 AM
To: cf-talk
Subject: RE: Server Performance


2 things for you.

First, check the DB for blocks and locks - about 9 times out of ten
queuing
requests are due to DB requests that are hanging. For some reason we web
developers bang our head against CF over and over thinking there is
something we can do on the web server to solve problems that exist on
the DB
server :)

Secondly,  If you are already running perfmon then you can get the
information on which site is busiest (or at least handling the most
requests).

Choose "web service" and then "Current connections" and "all instances".
Use
the report view (the little page icon next to the chart icon on the
toolbar)
it is clearer.

Oh... "current connections"  is appropriate for Wind2003 and above. For
windows 2000 use "current anonymous users". 


What you should see (using the report view) is a horizontal list of all
your
sites. The "_total" will be the first item. On a busy server you may
need to
scroll to the right to see them all. You can click on them and delete
the
ones you know are not the problem. 

Even though seeFusion and fusionReactor are great tools, I set up saved
Perfomon mcc's for all my windows servers - in fact you can view the
counters remotely (if you have the right domain rules in place) and you
can
see more than one server at a time in the same perfmon instance. Granted
it
is less introspective than one of the Java tools  - but for a quick
glimpse
of a server to answer the question - how busy is it - in real time, it's
handy and easy.

-Mark



Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com

-Original Message-
From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] 
Sent: Thursday, December 17, 2009 6:20 PM
To: cf-talk
Subject: Server Performance


Is there a way through command line or a 3rd party application to see
what
web sites on a CF Pro 8 server are causing the most requests? On one
particular server it is starting to show behavior of page timeouts and
longer running requests. In the Performance Monitor in windows I see the
running requests will max out from time to time and then requests start
to
queue. I want to be able to determine which sites are generating the
most
requests so I can examine the traffic and the code on those sites for
potential problems. Anybody know of any way to do this?


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329253
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Server Performance

[webmaster]

Is there a way through command line or a 3rd party application to see
what web sites on a CF Pro 8 server are causing the most requests? On
one particular server it is starting to show behavior of page timeouts
and longer running requests. In the Performance Monitor in windows I see
the running requests will max out from time to time and then requests
start to queue. I want to be able to determine which sites are
generating the most requests so I can examine the traffic and the code
on those sites for potential problems. Anybody know of any way to do
this?

 

 

 

 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329239
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Faster SMTP

[webmaster]

So all I would need to do is recreate the txt file that is  
those .cfmail files or is there more to it than that?

Thanks,
Patrick J Hedgepath
Pegasus Web Productions
webmas...@pegweb.com
(803)-996-0578

On Dec 11, 2009, at 2:11 PM, "Justin Scott"  wrote:

>
>> This is an actual mail server though correct? My mail server is
>> not the issue it spools out fine. It's the CF Spooler that is my
>> bottleneck.
>
> Bypass it.  Some mail servers have a place where a message file can be
> written or copied to and it will pick it up and process it.  The  
> Microsoft
> SMTP spooler has a folder under mailroot called "pickup"  
> specifically for
> this purpose.  ModusMail has a similar option.  I'm not sure about  
> MDaemon
> and Smartermail, but they're fairly mature products and I'd expect  
> they do
> as well.  You can write files out a lot faster than CF's spooler can  
> move
> the mail via SMTP.
>
>
> -Justin
>
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329106
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Faster SMTP

[webmaster]

This is an actual mail server though correct? My mail server is not the
issue it spools out fine. It's the CF Spooler that is my bottleneck.


-Original Message-
From: Erik-Jan Jaquet [mailto:erik...@toomba.nl] 
Sent: Thursday, December 10, 2009 10:44 AM
To: cf-talk
Subject: Re: Faster SMTP


We're using Infusion Mail server for this kinf of thing. Works really
well and its really fast. 

http://www.coolfusion.com/downloads/index.cfm?CFID=951923&CFTOKEN=252379
43

Kind regards,

Erik-Jan

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329088
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Faster SMTP

[webmaster]

Yeah I'm using smarter mail for my mail server on a separate server. I
have clients where some of them have around 30k email lists. So when you
get one of those that goes out it takes the CF server several hours to
spool it out since it is pro and not enterprise. So any other email sent
by CF gets put in line behind that.




-Original Message-
From: Justin Scott [mailto:jscott-li...@gravityfree.com] 
Sent: Thursday, December 10, 2009 11:36 AM
To: cf-talk
Subject: RE: Faster SMTP

How many messages are we talking about?  I've generally found that
writing
MSG files directly to the pickup folder of the Microsoft SMTP service
(bundled with IIS) gets them out WAY faster than anything else I've
tried.
This, of course, assumes you're on Windows and have access to configure
the
server.

The component you linked to has some nice features that will handle some
of
the more complex tasks of creating the message file (multi-mime, etc.).
Overall it doesn't look too bad if you need those features.


-Justin Scott

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329076
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Faster SMTP

[webmaster]

I have a lot of clients with email newsletters and they all seem to send
them out at the same time which backs up in the cfspooler. I have one
client in particular that can't wait on the emails from the forms on his
site so I was looking into some solutions that would allow their mail to
go directly to our mail server. I am looking at this one.

 

http://aspfusion.net/advsmtp-d.htm

 

Anybody used this or have other suggestions?

 

 

 

 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329038
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: AJAX

[webmaster]

Can you explain in more detail ajaxified widgets?

I'm looking to prefetch possible search keywords in a search field.
Get a different image from the database when a user clicks and display
it without refreshing the page.
Change search results without refreshing the page.

Stuff like that.



-Original Message-
From: Cutter (ColdFusion) [mailto:cold.fus...@cutterscrossing.com] 
Sent: Thursday, July 02, 2009 4:20 PM
To: cf-talk
Subject: Re: AJAX


Guys, I love JQuery too, for DOM manipulation. But, if you're needing 
ajaxified 'widgets' then Ext Js is a better choice. Not only do they 
have an extensive well polished and consistent library, but you can use 
the cfajax tags to rapid prototype an app, then build out final versions

with something that looks exactly the same (since that's what they use 
under the hood).

Shameless Promotion: Good Book? (See the signature block)

Steve "Cutter" Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer

Co-Author of "Learning Ext JS"
http://www.packtpub.com/learning-ext-js/book
_
http://blog.cutterscrossing.com





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324168
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: AJAX

[webmaster]

Thanks a lot this is exactly what I needed.



-Original Message-
From: Nathan Strutz [mailto:str...@gmail.com] 
Sent: Thursday, July 02, 2009 2:54 PM
To: cf-talk
Subject: Re: AJAX


Yes, the frameworks are different, but really, there is only a few that
matter, and only one of those that really actually matter.

jQuery is, by far, the best.

If you pay attention to most javascript questions people have these
days,
it's something like this:

   "Q: How do I do X in javascript?"
   "A: You don't. Just use jQuery."

If you want a whole widget ui framework, use ExtJs. Otherwise, just use
jQuery. It's unbelievably good.

jquery.com has a tutorial area http://docs.jquery.com/Tutorials which is
good. For me, it helps to have videos, so google it or hit up youtube
for
them.

nathan strutz
[Blog and Family @ http://www.dopefly.com/]
[AZCFUG Manager @ http://www.azcfug.org/]
[Twitter @nathanstrutz]


On Thu, Jul 2, 2009 at 11:32 AM,  wrote:

>
> Thanks a lot Andy. I knew there were different frameworks out there
but
> wasn't sure how that fit in with AJAX. I assume they are all AJAX but
> much like .NET they all have different built in functions etc?
>
>
> -Original Message-
> From: Andy Matthews [mailto:li...@commadelimited.com]
> Sent: Thursday, July 02, 2009 2:26 PM
> To: cf-talk
> Subject: RE: AJAX
>
>
> I'd avoid a book on "AJAX" and instead pick a book focusing on a
> specific
> JavaScript framework such as jQuery, or ExtJS. If you just want AJAX
> then it
> might be worth it to write your own code, but if you're wanting "rich
> internet apps" then you'll be needing DOM manipulation and effects
> anyway.
>
> My choice has, for the last 3 years, been jQuery. It's lightweight and
> super
> easy to use. jQuery is to JavaScript like ColdFusion is to server side
> languages. It makes it fast, easy, and good.
>
> The Learning jQuery 1.3 book comes highly recommended. I'd also
suggest
> you
> jump on the official jQuery mailing list over at Google Groups:
> http://groups.google.com/group/jquery-en
>
>
> andy
>
> -Original Message-
> From: webmas...@pegweb.com [mailto:webmas...@pegweb.com]
> Sent: Thursday, July 02, 2009 12:56 PM
> To: cf-talk
> Subject: AJAX
>
>
> Can anyone recommend a good book for AJAX? I want to start working on
> more
> web 2.0 style apps and with the new CF server it seems to make it
> easier. I
> just need to understand more about it and how it all works. I can
> JavaScript
> and I can CF so I wouldn't think it would be too hard to pickup. Any
> recommendations for reading material on the subject? Thanks in
advance.
>
>
>
>
>
>
>
>
>
>
>
>
>
> 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324166
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: AJAX

[webmaster]

Thanks a lot Andy. I knew there were different frameworks out there but
wasn't sure how that fit in with AJAX. I assume they are all AJAX but
much like .NET they all have different built in functions etc?


-Original Message-
From: Andy Matthews [mailto:li...@commadelimited.com] 
Sent: Thursday, July 02, 2009 2:26 PM
To: cf-talk
Subject: RE: AJAX


I'd avoid a book on "AJAX" and instead pick a book focusing on a
specific
JavaScript framework such as jQuery, or ExtJS. If you just want AJAX
then it
might be worth it to write your own code, but if you're wanting "rich
internet apps" then you'll be needing DOM manipulation and effects
anyway.

My choice has, for the last 3 years, been jQuery. It's lightweight and
super
easy to use. jQuery is to JavaScript like ColdFusion is to server side
languages. It makes it fast, easy, and good.

The Learning jQuery 1.3 book comes highly recommended. I'd also suggest
you
jump on the official jQuery mailing list over at Google Groups:
http://groups.google.com/group/jquery-en


andy

-Original Message-
From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] 
Sent: Thursday, July 02, 2009 12:56 PM
To: cf-talk
Subject: AJAX


Can anyone recommend a good book for AJAX? I want to start working on
more
web 2.0 style apps and with the new CF server it seems to make it
easier. I
just need to understand more about it and how it all works. I can
JavaScript
and I can CF so I wouldn't think it would be too hard to pickup. Any
recommendations for reading material on the subject? Thanks in advance.

 

 

 







~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324164
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

AJAX

[webmaster]

Can anyone recommend a good book for AJAX? I want to start working on
more web 2.0 style apps and with the new CF server it seems to make it
easier. I just need to understand more about it and how it all works. I
can JavaScript and I can CF so I wouldn't think it would be too hard to
pickup. Any recommendations for reading material on the subject? Thanks
in advance.

 

 

 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324161
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Personalizing a CFLoop - validation error

[webmaster]

The only reason it should give you that error is if there is an empty
email for one of the records. Try dumping out the same query to a
cfoutput to verify.




-Original Message-
From: cfcom [mailto:cf...@aceligent.com] 
Sent: Monday, January 05, 2009 4:14 PM
To: cf-talk
Subject: RE: Personalizing a CFLoop - validation error

They all have email addresses, I just don't know why it's throwing the
validation error on the CFMail 'TO'. I want to send out to about 100
different addresses, is there any issues with that?





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317423
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Personalizing a CFLoop

[webmaster]

I would just do something like this then.


SELECT * FROM Recipients






  #sender_date#


  Dear #GetRecipients.Name#


  This is my message to the recipient.  This is my message to the
recipient.  This is my message to the recipient.  This is my message to
the recipient.  This is my message to the recipient.  This is my message
to the recipient.  This is my message to the recipient.  This is my
message to the recipient.  


  Yours truly,
  
  #sender_firstname# #sender_lastname#
  #sender_address#
  #sender_city#, #sender_state# #sender_zip#
  #sender_email#






-Original Message-
From: cfcom [mailto:cf...@aceligent.com] 
Sent: Monday, January 05, 2009 2:21 PM
To: cf-talk
Subject: RE: Personalizing a CFLoop

Yes, it is stored. I can store form_sender and recipients if necessary

-Original Message-
From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] 
Sent: 2009-01-05 2:13 PM
To: cf-talk
Subject: RE: Personalizing a CFLoop

Is the recipient data stored in a table by chance?




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317416
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Personalizing a CFLoop

[webmaster]

I would just do something like this then.


SELECT * FROM Recipients






  #sender_date#


  Dear #GetRecipients.Name#


  This is my message to the recipient.  This is my message to the
recipient.  This is my message to the recipient.  This is my message to
the recipient.  This is my message to the recipient.  This is my message
to the recipient.  This is my message to the recipient.  This is my
message to the recipient.  


  Yours truly,
  
  #sender_firstname# #sender_lastname#
  #sender_address#
  #sender_city#, #sender_state# #sender_zip#
  #sender_email#






-Original Message-
From: cfcom [mailto:cf...@aceligent.com] 
Sent: Monday, January 05, 2009 2:21 PM
To: cf-talk
Subject: RE: Personalizing a CFLoop

Yes, it is stored. I can store form_sender and recipients if necessary

-Original Message-
From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] 
Sent: 2009-01-05 2:13 PM
To: cf-talk
Subject: RE: Personalizing a CFLoop

Is the recipient data stored in a table by chance?



-Original Message-
From: cfcom [mailto:cf...@aceligent.com] 
Sent: Monday, January 05, 2009 2:01 PM
To: cf-talk
Subject: Personalizing a CFLoop

CFLoop Problem:
I need to take the contents a visitor enters into our form and
use
it to send out personalized emails to several recipients. How do I set
up
the cfloop so that it sends a unique email to each recipient,
personalizes
the opening sentence and ends it signed by the visitor using the form.
So
far I can loop to each different address but I am having trouble doing
the
'name/email' pair of variables. 













  #sender_date#


  Dear #_#,(needs to be name as designated by recipient
email:
'Bob' for 'b...@domain.com')


  This is my message to the recipient.  This is my message to the
recipient.  This is my message to the recipient.  This is my message to
the
recipient.  This is my message to the recipient.  This is my message to
the
recipient.  This is my message to the recipient.  This is my message to
the
recipient.  


  Yours truly,
  
  #sender_firstname# #sender_lastname#
  #sender_address#
  #sender_city#, #sender_state# #sender_zip#
  #sender_email#










~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317415
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Personalizing a CFLoop

[webmaster]

Is the recipient data stored in a table by chance?



-Original Message-
From: cfcom [mailto:cf...@aceligent.com] 
Sent: Monday, January 05, 2009 2:01 PM
To: cf-talk
Subject: Personalizing a CFLoop

CFLoop Problem:
I need to take the contents a visitor enters into our form and
use
it to send out personalized emails to several recipients. How do I set
up
the cfloop so that it sends a unique email to each recipient,
personalizes
the opening sentence and ends it signed by the visitor using the form.
So
far I can loop to each different address but I am having trouble doing
the
'name/email' pair of variables. 













  #sender_date#


  Dear #_#,(needs to be name as designated by recipient
email:
'Bob' for 'b...@domain.com')


  This is my message to the recipient.  This is my message to the
recipient.  This is my message to the recipient.  This is my message to
the
recipient.  This is my message to the recipient.  This is my message to
the
recipient.  This is my message to the recipient.  This is my message to
the
recipient.  


  Yours truly,
  
  #sender_firstname# #sender_lastname#
  #sender_address#
  #sender_city#, #sender_state# #sender_zip#
  #sender_email#






~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317409
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Mail Spooler Woes

[webmaster]

It's funny you should suggest that. This one machine in particular had
CF7 on it and we upgraded to CF8. It used to send mail fine before. :(



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 23, 2008 6:42 PM
To: cf-talk
Subject: Re: Mail Spooler Woes

> They are all behind a router together. No routers in-between. I am
> basically looking to see if anyone else has run into the situation
with
> CF8 Standard.

I think you're missing Mike's point. It isn't clear that this is a
problem with CF8 Standard, or with something else. Can you put CF7 and
CF8 on a single machine, and see how they compare for you?

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 Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314325
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Mail Spooler Woes

[webmaster]

They are all behind a router together. No routers in-between. I am
basically looking to see if anyone else has run into the situation with
CF8 Standard.




-Original Message-
From: Mike Chabot [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 23, 2008 5:05 PM
To: cf-talk
Subject: Re: Mail Spooler Woes

Your emails suggest that you don't know what information diagnostics
tools are able to give you (Hint: "same network" and "same router" are
nearly irrelevant and there is always a bottleneck). It is possible
for two servers with identical hardware, identical software, identical
configurations running on the same network to function completely
differently for reasons that would be impossible to determine without
running diagnostic checks. Although it is curious that you have a
router between your mail server and your ColdFusion server since that
reveals a bit about how the network is set up. Getting rid of the
router intermediary might help.

-Mike Chabot

On Thu, Oct 23, 2008 at 3:01 PM,  <[EMAIL PROTECTED]> wrote:
> These 3 servers are on the same network. Using the same mail server. I
> don't see how network traffic (since they are on the same network
using
> the same router etc.) would make any difference. The only difference I
> can see if the version of the CF server. I am not seeing any
bottlenecks
> just difference in the version of software.
>
>
> -Original Message-
> From: Mike Chabot [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 23, 2008 2:57 PM
> To: cf-talk
> Subject: Re: Mail Spooler Woes
>
> You really need to find out where the bottleneck is. I listed possible
> bottlenecks in prior emails, but it is unclear if you have performed
> even cursory diagnostic checks yet. Have you already analyzed the
> network packets going between the CF server and the mail server, and
> if so what did you observe and how does this contrast to that
> equivalent network activity on the fast server?
>
> -Mike Chabot
>
> On Thu, Oct 23, 2008 at 2:26 PM,  <[EMAIL PROTECTED]> wrote:
>> I can send 5k emails to my CF8 servers and they each deliver about 1
>> piece of mail to my mail server every 3 seconds.
>>
>>
>>
>> I can send 5k emails to 1 of my CF7 servers and it sends out the all
> 5k
>> email to my mail server in about 30 seconds.
>>
>>
>>
>> Does anyone have a suggestion as to where I can look to fix this
> problem
>> or explain why CF7 is sending the mail from the cf spooler so much
>> faster than my CF8 servers?
>>
>>
>>
>> All servers are Standard edition.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314321
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Mail Spooler Woes

[webmaster]

These 3 servers are on the same network. Using the same mail server. I
don't see how network traffic (since they are on the same network using
the same router etc.) would make any difference. The only difference I
can see if the version of the CF server. I am not seeing any bottlenecks
just difference in the version of software.


-Original Message-
From: Mike Chabot [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 23, 2008 2:57 PM
To: cf-talk
Subject: Re: Mail Spooler Woes

You really need to find out where the bottleneck is. I listed possible
bottlenecks in prior emails, but it is unclear if you have performed
even cursory diagnostic checks yet. Have you already analyzed the
network packets going between the CF server and the mail server, and
if so what did you observe and how does this contrast to that
equivalent network activity on the fast server?

-Mike Chabot

On Thu, Oct 23, 2008 at 2:26 PM,  <[EMAIL PROTECTED]> wrote:
> I can send 5k emails to my CF8 servers and they each deliver about 1
> piece of mail to my mail server every 3 seconds.
>
>
>
> I can send 5k emails to 1 of my CF7 servers and it sends out the all
5k
> email to my mail server in about 30 seconds.
>
>
>
> Does anyone have a suggestion as to where I can look to fix this
problem
> or explain why CF7 is sending the mail from the cf spooler so much
> faster than my CF8 servers?
>
>
>
> All servers are Standard edition.
>
>
>
>
>
>
>
>
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314313
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Mail Spooler Woes

[webmaster]

I can send 5k emails to my CF8 servers and they each deliver about 1
piece of mail to my mail server every 3 seconds.

 

I can send 5k emails to 1 of my CF7 servers and it sends out the all 5k
email to my mail server in about 30 seconds.

 

Does anyone have a suggestion as to where I can look to fix this problem
or explain why CF7 is sending the mail from the cf spooler so much
faster than my CF8 servers?

 

All servers are Standard edition.

 

 

 

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314309
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Mail Spooler

[webmaster]

Ok I changed this to every 30 seconds and it still is sending mail from
the spooler at about 1 every 3 - 5 seconds.



-Original Message-
From: Mike Chabot [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 21, 2008 2:51 PM
To: cf-talk
Subject: Re: Mail Spooler

In my opinion having the spool interval value at 5 seconds is
contributing to the problem. If you need a spooling interval that
narrow then there is a chance that you shouldn't be using spooling at
all. If 5 seconds was clearly better than 15 seconds then Adobe would
have made that the default.

Set the spooling interval to a value such that the entire spool folder
can be cleared within the interval time. If you dump 100,000 emails
into the spool folder and it takes CF 60 seconds to clear them out,
then your spool interval should be greater than 60 seconds or you will
have multiple threads competing with each other without providing any
meaningful improvements and stealing processing power away from
servicing site visitors.

-Mike Chabot

On Tue, Oct 21, 2008 at 2:28 PM,  <[EMAIL PROTECTED]> wrote:
> Wouldn't increasing the spool interval just increase my problem?
>
>
>
>
> -Original Message-
> From: Mike Chabot [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 21, 2008 1:53 PM
> To: cf-talk
> Subject: Re: Mail Spooler
>
> The 5 second spool interval is a too quick if you are sending large
> batches of emails. This might be contributing to the problem.
>
> If I was confronted with this situation I would run diagnostic tests
> to find out where the bottleneck is. It could be the hard drive, the
> CPU, the network, the mail server, the ColdFusion available thread
> count, etc.
>
> If you have a second server that is faster then one idea is to use
> that second server for the bulk emails. Offloading maintenance tasks
> to a secondary server is a common optimization technique.
>
> -Mike Chabot
>
> On Tue, Oct 21, 2008 at 1:04 PM,  <[EMAIL PROTECTED]> wrote:
>> I have it set to every 5 seconds which is the fastest amount.
>>
>> There is no option for to disk or to memory in the Standard version.
I
>> think this is an enterprise feature only.
>>
>>
>>
>>
>> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>> Sent: Tuesday, October 21, 2008 12:57 PM
>> To: cf-talk
>> Subject: RE: Mail Spooler
>>
>> In ColdFusion Administrator what is your "Spool Interval" setting?  I
>> believe it defaults to 15 seconds.
>>
>> Also, are you spooling your messages to disk or memory?
>>
>> ~Brad
>>
>>  Original Message 
>> Subject: RE: Mail Spooler
>> From: <[EMAIL PROTECTED]>
>> Date: Tue, October 21, 2008 11:44 am
>> To: cf-talk 
>>
>> It goes into the CF Spooler just fine. It just takes forever to go
> from
>> the spool folder to my actual mail server.
>>
>>
>>
>>
>>
>>
>>
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314276
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Mail Spooler

[webmaster]

I'll give this a shot. Thanks for the advice.




-Original Message-
From: Mike Chabot [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 21, 2008 2:51 PM
To: cf-talk
Subject: Re: Mail Spooler

In my opinion having the spool interval value at 5 seconds is
contributing to the problem. If you need a spooling interval that
narrow then there is a chance that you shouldn't be using spooling at
all. If 5 seconds was clearly better than 15 seconds then Adobe would
have made that the default.

Set the spooling interval to a value such that the entire spool folder
can be cleared within the interval time. If you dump 100,000 emails
into the spool folder and it takes CF 60 seconds to clear them out,
then your spool interval should be greater than 60 seconds or you will
have multiple threads competing with each other without providing any
meaningful improvements and stealing processing power away from
servicing site visitors.

-Mike Chabot

On Tue, Oct 21, 2008 at 2:28 PM,  <[EMAIL PROTECTED]> wrote:
> Wouldn't increasing the spool interval just increase my problem?
>
>
>
>
> -Original Message-
> From: Mike Chabot [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 21, 2008 1:53 PM
> To: cf-talk
> Subject: Re: Mail Spooler
>
> The 5 second spool interval is a too quick if you are sending large
> batches of emails. This might be contributing to the problem.
>
> If I was confronted with this situation I would run diagnostic tests
> to find out where the bottleneck is. It could be the hard drive, the
> CPU, the network, the mail server, the ColdFusion available thread
> count, etc.
>
> If you have a second server that is faster then one idea is to use
> that second server for the bulk emails. Offloading maintenance tasks
> to a secondary server is a common optimization technique.
>
> -Mike Chabot
>
> On Tue, Oct 21, 2008 at 1:04 PM,  <[EMAIL PROTECTED]> wrote:
>> I have it set to every 5 seconds which is the fastest amount.
>>
>> There is no option for to disk or to memory in the Standard version.
I
>> think this is an enterprise feature only.
>>
>>
>>
>>
>> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>> Sent: Tuesday, October 21, 2008 12:57 PM
>> To: cf-talk
>> Subject: RE: Mail Spooler
>>
>> In ColdFusion Administrator what is your "Spool Interval" setting?  I
>> believe it defaults to 15 seconds.
>>
>> Also, are you spooling your messages to disk or memory?
>>
>> ~Brad
>>
>>  Original Message 
>> Subject: RE: Mail Spooler
>> From: <[EMAIL PROTECTED]>
>> Date: Tue, October 21, 2008 11:44 am
>> To: cf-talk 
>>
>> It goes into the CF Spooler just fine. It just takes forever to go
> from
>> the spool folder to my actual mail server.
>>
>>
>>
>>
>>
>>
>>
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314196
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Mail Spooler

[webmaster]

Wouldn't increasing the spool interval just increase my problem?




-Original Message-
From: Mike Chabot [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 21, 2008 1:53 PM
To: cf-talk
Subject: Re: Mail Spooler

The 5 second spool interval is a too quick if you are sending large
batches of emails. This might be contributing to the problem.

If I was confronted with this situation I would run diagnostic tests
to find out where the bottleneck is. It could be the hard drive, the
CPU, the network, the mail server, the ColdFusion available thread
count, etc.

If you have a second server that is faster then one idea is to use
that second server for the bulk emails. Offloading maintenance tasks
to a secondary server is a common optimization technique.

-Mike Chabot

On Tue, Oct 21, 2008 at 1:04 PM,  <[EMAIL PROTECTED]> wrote:
> I have it set to every 5 seconds which is the fastest amount.
>
> There is no option for to disk or to memory in the Standard version. I
> think this is an enterprise feature only.
>
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 21, 2008 12:57 PM
> To: cf-talk
> Subject: RE: Mail Spooler
>
> In ColdFusion Administrator what is your "Spool Interval" setting?  I
> believe it defaults to 15 seconds.
>
> Also, are you spooling your messages to disk or memory?
>
> ~Brad
>
>  Original Message 
> Subject: RE: Mail Spooler
> From: <[EMAIL PROTECTED]>
> Date: Tue, October 21, 2008 11:44 am
> To: cf-talk 
>
> It goes into the CF Spooler just fine. It just takes forever to go
from
> the spool folder to my actual mail server.
>
>
>
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314192
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Mail Spooler

[webmaster]

I have it set to every 5 seconds which is the fastest amount.

There is no option for to disk or to memory in the Standard version. I
think this is an enterprise feature only.




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 21, 2008 12:57 PM
To: cf-talk
Subject: RE: Mail Spooler

In ColdFusion Administrator what is your "Spool Interval" setting?  I
believe it defaults to 15 seconds.

Also, are you spooling your messages to disk or memory?

~Brad

 Original Message 
Subject: RE: Mail Spooler
From: <[EMAIL PROTECTED]>
Date: Tue, October 21, 2008 11:44 am
To: cf-talk 

It goes into the CF Spooler just fine. It just takes forever to go from
the spool folder to my actual mail server.






~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314190
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Mail Spooler

[webmaster]

Is there a setting in the CF8 files to look for?
I don't understanf why CF7 spools it out fast and CF8 doesn't.


-Original Message-
From: Mike Chabot [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 20, 2008 5:23 PM
To: cf-talk
Subject: Re: Mail Spooler

One email every five seconds is much slower then I would expect.
Something is wrong somewhere. I would run typical diagnostics checks
to determine where the bottleneck is.

-Mike Chabot

On Mon, Oct 20, 2008 at 4:18 PM,  <[EMAIL PROTECTED]> wrote:
> Upon the heels of my CFMail tag questions I have run some tests.
>
>
>
> I have a CF8 Standard server and a CFMX7 Standard server that I tested
> this on.
>
>
>
> I monitored the CF8 spool folder for a couple of hours. It sent 1
piece
> of mail every 5 seconds. So when I have a clients newsletter that goes
> out it takes forever and backs up anything else sent out after that.
>
>
>
> As a test I moved out 800 pieces of cfmail from my CF8 Mail Spool
> folder. I then FTPed those files over to the Spool folder on my CFMX7
> server. All 800 of them were sent to my mail server within about 30
> seconds.
>
>
>
> So my question is why is my CF8 spooling 1 message every 5 seconds and
> my CFMX7 server spooling them out to my mail server MUCH faster? Both
> machines are sending mail to the same mail server.
>
>
>
>
>
>
>
>
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314188
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Mail Spooler

[webmaster]

It goes into the CF Spooler just fine. It just takes forever to go from
the spool folder to my actual mail server.



-Original Message-
From: Robert Harrison [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 20, 2008 5:30 PM
To: cf-talk
Subject: RE: Mail Spooler

Is it going to the CFMAIL queue quickly? It may not be a CF issue. It
may be
throttle a setting on the mail server out queue. 


Robert B. Harrison
Director of Interactive services
Austin & Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 
F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be &.





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314187
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Mail Spooler

[webmaster]

Upon the heels of my CFMail tag questions I have run some tests.

 

I have a CF8 Standard server and a CFMX7 Standard server that I tested
this on.

 

I monitored the CF8 spool folder for a couple of hours. It sent 1 piece
of mail every 5 seconds. So when I have a clients newsletter that goes
out it takes forever and backs up anything else sent out after that.

 

As a test I moved out 800 pieces of cfmail from my CF8 Mail Spool
folder. I then FTPed those files over to the Spool folder on my CFMX7
server. All 800 of them were sent to my mail server within about 30
seconds.

 

So my question is why is my CF8 spooling 1 message every 5 seconds and
my CFMX7 server spooling them out to my mail server MUCH faster? Both
machines are sending mail to the same mail server.

 

 

 

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314160
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFMail Alternatives

[webmaster]

I also am using SmarterMail Enterprise. The main reason I don't think it
is SmarterMail is because I have sent mail to that same mail server from
an enterprise version of CF and it went out plenty fast. I have also
sent mail to that same Mail Server from ListServ products and it also
goes out plenty fast.




-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 17, 2008 4:21 PM
To: cf-talk
Subject: Re: CFMail Alternatives

Can't slowly "unspooling" emails also be attributed to a mail server
thats slow in accepting them?  I know I have that problem with my
SmarterMail-based mail server, although I can live with it because my
CF-originating traffic is not all that time-critical.

Surprised no one has recommended iMS from CoolFusion.  It hasn't been
updated in years but I'd be surprised if it needed an update when it
comes down to it.  The thing always hauled ass for me... but as people
have said, ColdFusion improved its mail performance years ago.  Don't
dismiss what people are saying about CF's mail handling performance.

-- 
[EMAIL PROTECTED]
Janitor, The Robertson Team
mysecretbase.com



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314068
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CFMail Alternatives

[webmaster]

How can I control sending mail to the cf spooler or not from the cfmail
tag itself? This seems like it would be the best option.


-Original Message-
From: Mike Chabot [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 16, 2008 10:19 PM
To: cf-talk
Subject: Re: CFMail Alternatives

I worked on a site that sent many hundreds of thousands of emails
every day using CF 7 Enterprise and it was fine. The thing we had to
do though was to use two different mail servers, one optimized for
immediate mail delivery, like new account setup emails, and one
optimized for bulk newsletter emails. When we only had one mail server
it would get bogged down during the mass emails and the emails that
people expected to receive immediately got delayed. The mail server
was the bottleneck.

You can configure CF so that it doesn't spool emails by unchecking the
box in CFAdmin, if you think spooling is the problem as opposed to the
speed of the mail server. I personally like the spooling feature. You
can also override the settings in CFAdmin in a cfmail tag, so maybe
the mass mails use the spooler and others get sent directly to the
mail server.

Maybe the hard drive speed is the spooling bottleneck and that an
alternative won't be any faster because it would be subject to the
same bottleneck. It is hard to tell.

-Mike Chabot

On Thu, Oct 16, 2008 at 6:57 PM,  <[EMAIL PROTECTED]> wrote:
> I think it would be much more cost effective to buy a mail tag than to
> shell out the $ for Enterprise though.
>
> Even if you tell it to use different mail servers it is still using
the
> CF spooler. My mail server isn't the issue the cf spooler is :(
>
>
>
> -Original Message-
> From: Raymond Camden [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 16, 2008 5:54 PM
> To: cf-talk
> Subject: Re: CFMail Alternatives
>
> Last I heard, CF Enterprise could send an insane amount of email very
> quickly. I think maybe 50k per hour? I don't think 10k would be a
> problem.
>
> Of course, what about using multiple mail servers? You can have one
> client use mail server x, another one use y, etc.
>
> On Thu, Oct 16, 2008 at 4:40 PM,  <[EMAIL PROTECTED]> wrote:
>> I have clients with large newsletters and if more than 1 of them send
>> them at a time it could potentially send over 10k emails to the
cfmail
>> spooler. So naturally I have other clients that are complaining about
>> how long it takes the mail to get delivered. I know there are
>> alternatives out there to CFMAIL so does anyone out there have
>> experience with them? I need something that can send mail in bulk to
> my
>> mail server.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314050
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CFMail Alternatives

[webmaster]

Are there any side effects to turn off the spooler? How does it treat
the mail then? Does it just send it directly to the mail server each
time the cfmail tag is processed?


-Original Message-
From: Mike Chabot [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 17, 2008 12:52 AM
To: cf-talk
Subject: Re: CFMail Alternatives

If you are certain that the ColdFusion spooling process is the source
of the slowness then turn off that feature.

-Mike Chabot

On Fri, Oct 17, 2008 at 12:03 AM,  <[EMAIL PROTECTED]> wrote:
> Yes I am sure it is the spooler. I sit there and watch it.
>
>
>
>
> -Original Message-
> From: Raymond Camden [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 16, 2008 9:33 PM
> To: cf-talk
> Subject: Re: CFMail Alternatives
>
> Are you sure it is the spooler? All you said was that it took a long
> for mail to get delivered. The slowdown could be anywhere.
>
> On Thu, Oct 16, 2008 at 5:57 PM,  <[EMAIL PROTECTED]> wrote:
>> I think it would be much more cost effective to buy a mail tag than
to
>> shell out the $ for Enterprise though.
>>
>> Even if you tell it to use different mail servers it is still using
> the
>> CF spooler. My mail server isn't the issue the cf spooler is :(
>>
>>
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314049
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFMail Alternatives

[webmaster]

Yes I am sure it is the spooler. I sit there and watch it.




-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 16, 2008 9:33 PM
To: cf-talk
Subject: Re: CFMail Alternatives

Are you sure it is the spooler? All you said was that it took a long
for mail to get delivered. The slowdown could be anywhere.

On Thu, Oct 16, 2008 at 5:57 PM,  <[EMAIL PROTECTED]> wrote:
> I think it would be much more cost effective to buy a mail tag than to
> shell out the $ for Enterprise though.
>
> Even if you tell it to use different mail servers it is still using
the
> CF spooler. My mail server isn't the issue the cf spooler is :(
>
>



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314034
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFMail Alternatives

[webmaster]

8 Standard Edition.


-Original Message-
From: Wil Genovese [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 16, 2008 6:00 PM
To: cf-talk
Subject: Re: CFMail Alternatives

What version of Coldfusion are you using?

Older versions of CF could take a long time to send spooled messages.
It
used to do on 100 every 15 seconds.  I've tested CF8 and it does
thousands
every 15 seconds.

We used to use CF_mail which was a wrapper for cfx_activemail on the old
CF
version. Now we just use CFMAIL.


Wil Genovese






On Thu, Oct 16, 2008 at 4:40 PM, <[EMAIL PROTECTED]> wrote:

> I have clients with large newsletters and if more than 1 of them send
> them at a time it could potentially send over 10k emails to the cfmail
> spooler. So naturally I have other clients that are complaining about
> how long it takes the mail to get delivered. I know there are
> alternatives out there to CFMAIL so does anyone out there have
> experience with them? I need something that can send mail in bulk to
my
> mail server.
>
>
>
>
>
>
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314024
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CFMail Alternatives

[webmaster]

I think it would be much more cost effective to buy a mail tag than to
shell out the $ for Enterprise though.

Even if you tell it to use different mail servers it is still using the
CF spooler. My mail server isn't the issue the cf spooler is :(



-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 16, 2008 5:54 PM
To: cf-talk
Subject: Re: CFMail Alternatives

Last I heard, CF Enterprise could send an insane amount of email very
quickly. I think maybe 50k per hour? I don't think 10k would be a
problem.

Of course, what about using multiple mail servers? You can have one
client use mail server x, another one use y, etc.

On Thu, Oct 16, 2008 at 4:40 PM,  <[EMAIL PROTECTED]> wrote:
> I have clients with large newsletters and if more than 1 of them send
> them at a time it could potentially send over 10k emails to the cfmail
> spooler. So naturally I have other clients that are complaining about
> how long it takes the mail to get delivered. I know there are
> alternatives out there to CFMAIL so does anyone out there have
> experience with them? I need something that can send mail in bulk to
my
> mail server.
>
>
>
>
>
>
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314023
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFMail Alternatives

[webmaster]

I have clients with large newsletters and if more than 1 of them send
them at a time it could potentially send over 10k emails to the cfmail
spooler. So naturally I have other clients that are complaining about
how long it takes the mail to get delivered. I know there are
alternatives out there to CFMAIL so does anyone out there have
experience with them? I need something that can send mail in bulk to my
mail server.

 

 

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314019
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Script on one site

[webmaster]

Yeah I did that already. It is in the .cfm files themselves. I also have
code in place to prevent SQL injection attacks. I'm hoping these were
files I just missed on the first cleanup. 


-Original Message-
From: Al Musella, DPM [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 03, 2008 10:38 AM
To: CF-Talk
Subject: Re: Script on one site

Look at the .cfm file and see if these script tags are in the cfm 
file or if they are stored in a database.
  Look through your database. Look at every table and see if there is 
a lot of junk at the end of some char or varchar fields..

At 10:37 PM 9/2/2008, you wrote:


>I have one site in particular that keeps getting this kind of stuff on
>the bottom of .cfm pages right above the  tag.  I have already
>recreated their FTP account once with a strong password. It seems odd
>this is only happening to .cfm pages though and only on this site on
the
>server. Any ideas?
>
>
>
>
>
>http://www.ncwc.ru/fgg.js>src=http://www.ncwc.ru/fgg.js>

Script on one site

[webmaster]

I have one site in particular that keeps getting this kind of stuff on
the bottom of .cfm pages right above the  tag.  I have already
recreated their FTP account once with a strong password. It seems odd
this is only happening to .cfm pages though and only on this site on the
server. Any ideas?

 

 

http://www.ncwc.ru/fgg.js>http://www.ncwc.ru/fgg.js>http://www.ncwc.ru/fgg.js>http://www.ncwc.ru/fgg.js>http://www.ncwc.ru/fgg.js>http://www.ncwc.ru/fgg.js>http://www.ncwc.ru/fgg.js>http://www.ncwc.ru/fgg.js>http://www.ncwc.ru/fgg.js>http://www.kj5s.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.bosf.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.bosf.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.kj5s.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.bosf.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.po4c.ru/fgg.js>http://www.bosf.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.bosf.ru/fgg.js>http://www.kpo3.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.kj5s.ru/fgg.js>http://www.kj5s.ru/fgg.js>http://www.kj5s.ru/fgg.js>http://www.po4c.ru/fgg.js>http://www.bosf.ru/fgg.js>http://www.bosf.ru/fgg.js>http://www.bosf.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.jve4.ru/fgg.js>http://www.kpo3.ru/fgg.js>http://www.bosf.ru/fgg.js>http://www.po4c.ru/fgg.js>http://www.gty5.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.bosf.ru/fgg.js>http://www.bosf.ru/fgg.js>http://www.po4c.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.gty5.ru/fgg.js>http://www.gty5.ru/fgg.js>http://www.bosf.ru/fgg.js>http://www.bosf.ru/fgg.js>http://www.jve4.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.gty5.ru/fgg.js>http://www.bosf.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.gty5.ru/fgg.js>http://www.gty5.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.gty5.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.gty5.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.po4c.ru/fgg.js>http://www.po4c.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.ch35.ru/fgg.js>http://www.po4c.ru/fgg.js>

 

 

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311969
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: FCKeditor

[webmaster]

I readded this virtual directory and this time it works. Thanks for the
help.


-Original Message-
From: William Seiter [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 11, 2008 12:03 PM
To: CF-Talk
Subject: RE: FCKeditor

If you were to use a mailto:[EMAIL PROTECTED]
::Sent: Monday, August 11, 2008 8:58 AM
::To: CF-Talk
::Subject: FCKeditor
::
::Here is my code yet the editor does not seem to work correctly. No
::toolbar is visible etc.
::
::
::
::
::
::#Comments#
::
::
::
::
::
::Any ideas where I should start to look for problems?
::
::
::
::
::
::
::
::



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310745
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: FCKeditor

[webmaster]

No this is not working actually. So this means I just need to add a
mapping in IIS for the CFIDE directory for this site and it should work?
I think I tried that with no joy.

-Original Message-
From: William Seiter [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 11, 2008 12:03 PM
To: CF-Talk
Subject: RE: FCKeditor

If you were to use a mailto:[EMAIL PROTECTED]
::Sent: Monday, August 11, 2008 8:58 AM
::To: CF-Talk
::Subject: FCKeditor
::
::Here is my code yet the editor does not seem to work correctly. No
::toolbar is visible etc.
::
::
::
::
::
::#Comments#
::
::
::
::
::
::Any ideas where I should start to look for problems?
::
::
::
::
::
::
::
::



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310741
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

FCKeditor

[webmaster]

Here is my code yet the editor does not seem to work correctly. No
toolbar is visible etc.

 



#Comments#



 

Any ideas where I should start to look for problems?

 

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310727
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Syntax Error In Update Statement

[webmaster]

I would assume it is because it is a keyword used in SQL or Database
syntax. Again Dream Weaver wrote the code.


-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 23, 2008 5:30 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement

why is the column State in double quotes?

On Fri, May 23, 2008 at 2:18 PM,  <[EMAIL PROTECTED]> wrote:
> It is a number field in an Access DB. Below is the entire query.
>
>  "form1">
>  
>UPDATE HomeCareCompany
> SET Active=
> 1
> 
> 0
> 
> , Location=
>  maxlength="15">
> 
> 0
> 
> , CompanyName= NEQ "">
>  maxlength="85">
> 
> ''
> 
> , Email=
>  maxlength="75">
> 
> ''
> 
> , Password=
>  maxlength="15">
> 
> ''
> 
> , FirstName= "">
>  maxlength="40">
> 
> ''
> 
> , LastName=
>  maxlength="40">
> 
> ''
> 
> , Address=
>  maxlength="200">
> 
> ''
> 
> , City=
>  maxlength="85">
> 
> ''
> 
> , "State"=
>  maxlength="2">
> 
> ''
> 
> , Zip=
> 
> 
> ''
> 
> , Phone=
>  maxlength="15">
> 
> ''
> 
> , Fax=
> 
> 
> ''
> 
> WHERE ID=
>  
>
>
>
> -Original Message-
> From: Charlie Griefer [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 23, 2008 5:06 PM
> To: CF-Talk
> Subject: Re: Syntax Error In Update Statement
>
> On Fri, May 23, 2008 at 1:58 PM,  <[EMAIL PROTECTED]> wrote:
>> When I change it to CF_SQL_NUMERIC the error persists. Even if I
> remove
>> the entire statement
>>
>> , Location= "">
>> > maxlength="15">
>> 
>> 0
>> 
>>
>> The error still persists.
>
> is it numeric or is it integer?
>
> if the error persists without that line, can you paste the query as
> you currently have it?
>
> --
> A byte walks into a bar and orders a pint. Bartender asks him "What's
> wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I
> thought you looked a bit off."
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305997
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Syntax Error In Update Statement

[webmaster]

Well first off this was code generated by Dream Weaver using the testing
server environment so yell at Adobe. Can I write it from scratch myself
sure but I was trying to save time. All it appears to have done is waste
time. Why would this give you a heart attack. This query was working
until I added the additional field like I mentioned earlier. Then even
removing the field does not help now.



-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 23, 2008 5:26 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement

Holy F!?!?!?! .. surely you don't have the password, phone number,
fax number,  email and company name.
I think this email just gave every DB person on this list a heart
attack.
Clob is for storing GIGS of data.
Those are varchar's if not numeric.. Fix your query first and then let
us know if you still have problems.




On Fri, May 23, 2008 at 4:18 PM,  <[EMAIL PROTECTED]> wrote:
> It is a number field in an Access DB. Below is the entire query.
>
>  "form1">
>  
>UPDATE HomeCareCompany
> SET Active=
> 1
> 
> 0
> 
> , Location=
>  maxlength="15">
> 
> 0
> 
> , CompanyName= NEQ "">
>  maxlength="85">
> 
> ''
> 
> , Email=
>  maxlength="75">
> 
> ''
> 
> , Password=
>  maxlength="15">
> 
> ''
> 
> , FirstName= "">
>  maxlength="40">
> 
> ''
> 
> , LastName=
>  maxlength="40">
> 
> ''
> 
> , Address=
>  maxlength="200">
> 
> ''
> 
> , City=
>  maxlength="85">
> 
> ''
> 
> , "State"=
>  maxlength="2">
> 
> ''
> 
> , Zip=
> 
> 
> ''
> 
> , Phone=
>  maxlength="15">
> 
> ''
> 
> , Fax=
> 
> 
> ''
> 
> WHERE ID=
>  
>
>
>
> -Original Message-
> From: Charlie Griefer [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 23, 2008 5:06 PM
> To: CF-Talk
> Subject: Re: Syntax Error In Update Statement
>
> On Fri, May 23, 2008 at 1:58 PM,  <[EMAIL PROTECTED]> wrote:
>> When I change it to CF_SQL_NUMERIC the error persists. Even if I
> remove
>> the entire statement
>>
>> , Location= "">
>> > maxlength="15">
>> 
>> 0
>> 
>>
>> The error still persists.
>
> is it numeric or is it integer?
>
> if the error persists without that line, can you paste the query as
> you currently have it?
>
> --
> A byte walks into a bar and orders a pint. Bartender asks him "What's
> wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I
> thought you looked a bit off."
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305996
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Syntax Error In Update Statement

[webmaster]

It is a number field in an Access DB. Below is the entire query.


 
UPDATE HomeCareCompany
SET Active=
1

0

, Location=


0

, CompanyName=


''

, Email=


''

, Password=


''

, FirstName=


''

, LastName=


''

, Address=


''

, City=


''

, "State"=


''

, Zip=


''

, Phone=


''

, Fax=


''

WHERE ID=
  



-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 23, 2008 5:06 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement

On Fri, May 23, 2008 at 1:58 PM,  <[EMAIL PROTECTED]> wrote:
> When I change it to CF_SQL_NUMERIC the error persists. Even if I
remove
> the entire statement
>
> , Location=
>  maxlength="15">
> 
> 0
> 
>
> The error still persists.

is it numeric or is it integer?

if the error persists without that line, can you paste the query as
you currently have it?

-- 
A byte walks into a bar and orders a pint. Bartender asks him "What's
wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I
thought you looked a bit off."



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305979
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Syntax Error In Update Statement

[webmaster]

When I change it to CF_SQL_NUMERIC the error persists. Even if I remove
the entire statement

, Location=


0


The error still persists.

-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 23, 2008 4:37 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement

If it's numeric in the DB it should NOT be cf_sql_clob


On Fri, May 23, 2008 at 3:34 PM, morgan l <[EMAIL PROTECTED]> wrote:
> The query you posted (UPDATE HomeCareCompany) is not the query
reporting the
> error ( UPDATE Physician )
>
> On Fri, May 23, 2008 at 3:28 PM, <[EMAIL PROTECTED]> wrote:
>
>> One that is not very helpful :(
>>
>> Error Executing Database Query.
>> Syntax error in UPDATE statement.
>>
>> The error occurred in
>> C:\users\respiratorydiagnosticsllc.com\www\admin\EditPhysician.cfm:
line
>> 71
>>
>> 69 : ''
>> 70 : 
>> 71 : WHERE ID=http://form.id/#>"
>> cfsqltype="cf_sql_numeric">
>> 72 :   
>> 73 :   
>>
>> SQLSTATE   
>> SQLUPDATE Physician SET Active= 1 , NPI= (param 1) ,
FirstName=
>> (param 2) , LastName= (param 3) , Suffix= (param 4) , Email= (param
5) ,
>> Password= (param 6) , Address= (param 7) , City= (param 8) , "State"=
>> (param 9) , Zip= (param 10) , Phone= (param 11) , Fax= '' WHERE ID=
>> (param 12)
>> VENDORERRORCODE   3092
>>
>>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305977
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Syntax Error In Update Statement

[webmaster]

Ack sorry :( Having the same problem with another DW created query on
another page. Here is the correct error.

Error Executing Database Query.
Syntax error in UPDATE statement.
 
The error occurred in
C:\users\respiratorydiagnosticsllc.com\www\admin\EditCompany.cfm: line
71

69 : ''
70 : 
71 : WHERE ID=
72 :   
73 :   

SQLSTATE   
SQLUPDATE HomeCareCompany SET Active= 1 , Location= (param 1) ,
CompanyName= (param 2) , Email= (param 3) , Password= '' , FirstName=
(param 4) , LastName= (param 5) , Address= (param 6) , City= (param 7) ,
"State"= (param 8) , Zip= (param 9) , Phone= (param 10) , Fax= '' WHERE
ID= (param 11)
VENDORERRORCODE   3092




-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 23, 2008 4:33 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement

Is this the same query?
The query you posted was using a different table

 
   UPDATE HomeCareCompany
SET Active=

The query below uses "Physician"

On Fri, May 23, 2008 at 3:28 PM,  <[EMAIL PROTECTED]> wrote:
> One that is not very helpful :(
>
> Error Executing Database Query.
> Syntax error in UPDATE statement.
>
> The error occurred in
> C:\users\respiratorydiagnosticsllc.com\www\admin\EditPhysician.cfm:
line
> 71
>
> 69 : ''
> 70 : 
> 71 : WHERE ID= cfsqltype="cf_sql_numeric">
> 72 :   
> 73 :   
>
> SQLSTATE   
> SQLUPDATE Physician SET Active= 1 , NPI= (param 1) ,
FirstName=
> (param 2) , LastName= (param 3) , Suffix= (param 4) , Email= (param 5)
,
> Password= (param 6) , Address= (param 7) , City= (param 8) , "State"=
> (param 9) , Zip= (param 10) , Phone= (param 11) , Fax= '' WHERE ID=
> (param 12)
> VENDORERRORCODE   3092
>
>
>
> -Original Message-
> From: Greg Morphis [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 23, 2008 4:25 PM
> To: CF-Talk
> Subject: Re: Syntax Error In Update Statement
>
> What error does CF give?
>
> On Fri, May 23, 2008 at 3:14 PM, Patrick Hedgepath
> <[EMAIL PROTECTED]> wrote:
>> Can anybody see the syntax error that CF8 keeps giving me for this
> query? The query was made by DW CS3 and worked until I added a new
field
> by hand (Location). I can't see any reason it would not work.
>>
>>  
>>UPDATE HomeCareCompany
>> SET Active=
>> 1
>> 
>> 0
>> 
>> , Location= "">
>>  maxlength="15">
>> 
>> 0
>> 
>> , CompanyName= #FORM.CompanyName# NEQ "">
>>  maxlength="85">
>> 
>> ''
>> 
>> , Email=
>>  maxlength="75">
>> 
>> ''
>> 
>> , Password= "">
>>  maxlength="15">
>> 
>> ''
>> 
>> , FirstName= "">
>>  maxlength="40">
>> 
>> ''
>> 
>> , LastName= "">
>>  maxlength="40">
>> 
>> ''
>> 
>> , Address=
>>  maxlength="200">
>> 
>> ''
>> 
>> , City=
>>  maxlength="85">
>> 
>> ''
>> 
>> , "State"=
>>  maxlength="2">
>> 
>> ''
>> 
>> , Zip=
>>  maxlength="10">
>> 
>> ''
>> 
>> , Phone=
>>  maxlength="15">
>> 
>> ''
>> 
>> , Fax=
>>  maxlength="15">
>> 
>> ''
>> 
>> WHERE ID=
>>  
>>
>>
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305974
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Syntax Error In Update Statement

[webmaster]

Location is a number field. When I try changing it to 
I still get an error.

In fact when I remove the statement entirely I still get the error.



-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 23, 2008 4:30 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement

Also.. what is location?
Do yow know what a CLOB is? That's a HUGE character field.. can that
not be a varchar?

On Fri, May 23, 2008 at 3:25 PM,  <[EMAIL PROTECTED]> wrote:
> I actually want that field to be a 0 if no data was entered on the
form.
>
>
> -Original Message-
> From: Charlie Griefer [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 23, 2008 4:22 PM
> To: CF-Talk
> Subject: Re: Syntax Error In Update Statement
>
> On Fri, May 23, 2008 at 1:14 PM, Patrick Hedgepath
> <[EMAIL PROTECTED]> wrote:
>> Can anybody see the syntax error that CF8 keeps giving me for this
> query? The query was made by DW CS3 and worked until I added a new
field
> by hand (Location). I can't see any reason it would not work.
>>
>> , Location= "">
>>  maxlength="15">
>> 
>> 0
>> 
>
> shouldn't your  be an empty string ("") instead of a 0?
>
> --
> A byte walks into a bar and orders a pint. Bartender asks him "What's
> wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I
> thought you looked a bit off."
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305972
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Syntax Error In Update Statement

[webmaster]

Even if it is a numeric field in the database? I have tried removing the
entire statement from the update query and it still gives an error.

Thanks,
Patrick J. Hedgepath
Pegasus Web Productions
[EMAIL PROTECTED]
803-996-0578





-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 23, 2008 4:30 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement

On Fri, May 23, 2008 at 1:25 PM,  <[EMAIL PROTECTED]> wrote:
> I actually want that field to be a 0 if no data was entered on the
form.

then the 0 value should be surrounded by single quotes?

>
> -Original Message-
> From: Charlie Griefer [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 23, 2008 4:22 PM
> To: CF-Talk
> Subject: Re: Syntax Error In Update Statement
>
> On Fri, May 23, 2008 at 1:14 PM, Patrick Hedgepath
> <[EMAIL PROTECTED]> wrote:
>> Can anybody see the syntax error that CF8 keeps giving me for this
> query? The query was made by DW CS3 and worked until I added a new
field
> by hand (Location). I can't see any reason it would not work.
>>
>> , Location= "">
>>  maxlength="15">
>> 
>> 0
>> 
>
> shouldn't your  be an empty string ("") instead of a 0?
>
> --
> A byte walks into a bar and orders a pint. Bartender asks him "What's
> wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I
> thought you looked a bit off."
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305970
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Syntax Error In Update Statement

[webmaster]

One that is not very helpful :(

Error Executing Database Query.
Syntax error in UPDATE statement.
 
The error occurred in
C:\users\respiratorydiagnosticsllc.com\www\admin\EditPhysician.cfm: line
71

69 : ''
70 : 
71 : WHERE ID=
72 :   
73 :   

SQLSTATE   
SQLUPDATE Physician SET Active= 1 , NPI= (param 1) , FirstName=
(param 2) , LastName= (param 3) , Suffix= (param 4) , Email= (param 5) ,
Password= (param 6) , Address= (param 7) , City= (param 8) , "State"=
(param 9) , Zip= (param 10) , Phone= (param 11) , Fax= '' WHERE ID=
(param 12)
VENDORERRORCODE   3092



-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 23, 2008 4:25 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement

What error does CF give?

On Fri, May 23, 2008 at 3:14 PM, Patrick Hedgepath
<[EMAIL PROTECTED]> wrote:
> Can anybody see the syntax error that CF8 keeps giving me for this
query? The query was made by DW CS3 and worked until I added a new field
by hand (Location). I can't see any reason it would not work.
>
>  
>UPDATE HomeCareCompany
> SET Active=
> 1
> 
> 0
> 
> , Location=
> 
> 
> 0
> 
> , CompanyName=
> 
> 
> ''
> 
> , Email=
> 
> 
> ''
> 
> , Password=
> 
> 
> ''
> 
> , FirstName=
> 
> 
> ''
> 
> , LastName=
> 
> 
> ''
> 
> , Address=
> 
> 
> ''
> 
> , City=
> 
> 
> ''
> 
> , "State"=
> 
> 
> ''
> 
> , Zip=
> 
> 
> ''
> 
> , Phone=
> 
> 
> ''
> 
> , Fax=
> 
> 
> ''
> 
> WHERE ID=
>  
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305967
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Syntax Error In Update Statement

[webmaster]

I actually want that field to be a 0 if no data was entered on the form.


-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 23, 2008 4:22 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement

On Fri, May 23, 2008 at 1:14 PM, Patrick Hedgepath
<[EMAIL PROTECTED]> wrote:
> Can anybody see the syntax error that CF8 keeps giving me for this
query? The query was made by DW CS3 and worked until I added a new field
by hand (Location). I can't see any reason it would not work.
>
> , Location=
> 
> 
> 0
> 

shouldn't your  be an empty string ("") instead of a 0?

-- 
A byte walks into a bar and orders a pint. Bartender asks him "What's
wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I
thought you looked a bit off."



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305965
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: IO error on server communication

[webmaster]

I ran this and it showed RDS as true but I still get the IO error when I
browse for a database in the admin etc.

Thanks,
Patrick J. Hedgepath
Pegasus Web Productions
[EMAIL PROTECTED]
803-996-0578





-Original Message-
From: Vamseekrishna Manneboina [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 16, 2008 5:28 AM
To: CF-Talk
Subject: RE: IO error on server communication

You could use the admin API to enable RDS. Run the following script
(replace {admin_pwd} with your CF Admin password) and restart your
server.





Is RDS Enabled : #isRDSEnabled#



Is RDS Enabled : #isRDSEnabled#



Thanks,
Vamsee

-Original Message-
From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 16, 2008 1:14 PM
To: CF-Talk
Subject: Re: IO error on server communication

Did you verify that the RDS ports are open on your firewall? Can't 
remember what they are off the top of my head...

Steve "Cutter" Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com

[EMAIL PROTECTED] wrote:
> I checked the web.xml file and according to it RDS is enabled.
> 
> Thanks,
> Patrick J. Hedgepath
> Pegasus Web Productions
> [EMAIL PROTECTED]
> 803-996-0578
> 
> 
> 
> 
> 
> -Original Message-
> From: James Holmes [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, April 15, 2008 10:42 PM
> To: CF-Talk
> Subject: Re: IO error on server communication
> 
> Yes, RDS is not enabled on the server. You can enable it by editing
> the appropriate file - I can't recall which but a search should turn
> it up.
> 
> On Wed, Apr 16, 2008 at 10:34 AM,  <[EMAIL PROTECTED]> wrote:
>> I am getting this "IO error on server communication" when I try to
>>  browser for a file in the CF administrator. I understand this might
> be
>>  related to RDS and since I cannot seem to connect with RDS either
I'm
>>  pretty sure RDS is the root of my problems. However I'm not sure how
> to
>>  fix it. Anybody run into this on CF 8.0.1 before and know how to fix
> it?
> 






~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303581
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: IO error on server communication

[webmaster]

I think it is just port 80 and yes that is open.

Thanks,
Patrick J. Hedgepath
Pegasus Web Productions
[EMAIL PROTECTED]
803-996-0578





-Original Message-
From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 16, 2008 3:44 AM
To: CF-Talk
Subject: Re: IO error on server communication

Did you verify that the RDS ports are open on your firewall? Can't 
remember what they are off the top of my head...

Steve "Cutter" Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com

[EMAIL PROTECTED] wrote:
> I checked the web.xml file and according to it RDS is enabled.
> 
> Thanks,
> Patrick J. Hedgepath
> Pegasus Web Productions
> [EMAIL PROTECTED]
> 803-996-0578
> 
> 
> 
> 
> 
> -Original Message-
> From: James Holmes [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, April 15, 2008 10:42 PM
> To: CF-Talk
> Subject: Re: IO error on server communication
> 
> Yes, RDS is not enabled on the server. You can enable it by editing
> the appropriate file - I can't recall which but a search should turn
> it up.
> 
> On Wed, Apr 16, 2008 at 10:34 AM,  <[EMAIL PROTECTED]> wrote:
>> I am getting this "IO error on server communication" when I try to
>>  browser for a file in the CF administrator. I understand this might
> be
>>  related to RDS and since I cannot seem to connect with RDS either
I'm
>>  pretty sure RDS is the root of my problems. However I'm not sure how
> to
>>  fix it. Anybody run into this on CF 8.0.1 before and know how to fix
> it?
> 




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303555
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: IO error on server communication

[webmaster]

I checked the web.xml file and according to it RDS is enabled.

Thanks,
Patrick J. Hedgepath
Pegasus Web Productions
[EMAIL PROTECTED]
803-996-0578





-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 15, 2008 10:42 PM
To: CF-Talk
Subject: Re: IO error on server communication

Yes, RDS is not enabled on the server. You can enable it by editing
the appropriate file - I can't recall which but a search should turn
it up.

On Wed, Apr 16, 2008 at 10:34 AM,  <[EMAIL PROTECTED]> wrote:
> I am getting this "IO error on server communication" when I try to
>  browser for a file in the CF administrator. I understand this might
be
>  related to RDS and since I cannot seem to connect with RDS either I'm
>  pretty sure RDS is the root of my problems. However I'm not sure how
to
>  fix it. Anybody run into this on CF 8.0.1 before and know how to fix
it?

-- 
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303544
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

IO error on server communication

[webmaster]

I am getting this "IO error on server communication" when I try to
browser for a file in the CF administrator. I understand this might be
related to RDS and since I cannot seem to connect with RDS either I'm
pretty sure RDS is the root of my problems. However I'm not sure how to
fix it. Anybody run into this on CF 8.0.1 before and know how to fix it?

 

Thanks,

Patrick J. Hedgepath

Pegasus Web Productions

[EMAIL PROTECTED]  

803-996-0578

 

 

 

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303541
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFMDIRECTORY

[webmaster]

Where can I get a copy of the custom tag by Pablo Verando called CFMDIRECTORY? 
I see it was available on CFM-Resources.com but alas, it has been taken down :(.


~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279874
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Form Post Capture

[webmaster]

I guess the main issue is that we need to post the video to Google first, using 
our Google account, ( I found this on Google's site... working on integrating 
it into our app now 
http://code.google.com/apis/accounts/AuthForInstalledApps.html )and all we 
would need would be just the reference (the embedded link) that Google gives 
back and the Meta data that was entered so we could track all of our video's on 
our page. I am unsure if I can parse that with CFHTTP can I? Got an example?

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253347
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Form Post Capture

[webmaster]

Anyone have any suggestion how we can capture in our database, our video post 
data we post to google so we can post it automatically on our site in a list 
linking to the Google Video page?

We don't really need the upload itself... we just need the name of the video we 
post to google video perhaps we could upload the video to our site 
first anyone know how to automatically post video's to your account on 
google video? We will still need to know what was posted and when and which one 
of us uploaded it. It's all going to the same account on Google Video, just 
several producers uploading the content.

Maybe it is as simple as submitting one form to post to both sites at the same 
time, except one uploads the file and the other just captures the filename that 
was uploaded.  I am at an impasse on which way to do this, but I'm sure one of 
you Geniuses can point me in the right direction.

Thanks!

Viva_CF!!!


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253338
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Escaping #'s in outputting a CSS

[webmaster]

Stupid beginner question I know but it's been a long time since I've done any 
REAL CF coding.

I am trying to create an HTML code generator for a client and am having 
problems escaping the #'s in the CSS.  I tried the good ole ## but that's not 
working.  It throws an error.  If I just remove the #'s then the colors don't 
get set the way they're supposed to.  

I can provide code samples if needed.

TIA,
Katrina Chapman



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238140
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Need query help please

[Webmaster at FastTrack On Line]

The way I do it on a couple of sites is to store large images in one folder 
and thumbs in another.  I store one file name in the db table and just use:

#application.photos#\#table.jpeg_name#
or
#application.photos_thumb#\#table.jpeg_name#

Jenny



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223040
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: WAY OT: Configuring FCKEditor

[Webmaster at FastTrack On Line]

Hi Jay,

I'm having a real headache with this fck config, do you have any install 
notes I could take a look at please?  I've got it all working but the 
graphics upload :-S

Thanks, Jenny

- Original Message - 
From: "Jay Greer" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Friday, October 28, 2005 6:39 PM
Subject: Re: WAY OT: Configuring FCKEditor


> (for versiion 2.1.1)
>
> /FCKEditor/editor/filemanager/browser/default/connectors/cfm/config.cfm
>
> Lines 9 & 11
>
> Good Luck!
>
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222651
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SHOUTING

[Webmaster at FastTrack On Line]

Maybe the Lcase function?

Jenny

- Original Message - 
From: "Saturday (Stuart Kidd)" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Monday, October 24, 2005 6:02 PM
Subject: stop: SHOUTING


> Hi guys,
>
> Just wondering if anyone knows a good way to recognise when all the
> characters are capitalised?  Some users love putting text in CAPS and
> it just looks awful when it's displayed on screen.
>
> Any help I'd be grateful.
>
> Thanks,
>
> Saturday
>
>
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222644
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: timed event in CF

[Webmaster at FastTrack On Line]

Hi Roberto,

I think this is what you need ...

http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/Tags-pt229.htm

cfschedule ..

Hope this helps, Jenny



- Original Message - 
From: "Roberto Perez" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Wednesday, October 26, 2005 12:21 AM
Subject: timed event in CF


> Hi all,
>
> I'm working on an application form that has to be available only through
> certain dates. I have a few fields where a user with admin priviledges can
> enter a date and a time (hour:min:sec) for the application to become
> available and unavailable (thus closing the application period). Then 
> there
> is a field called "status" with the options "open" or "closed". The 
> content
> of that field should be changed on the date specified in the database, by
> an "event" or "task" that runs at the specified date and time. Thus, when
> the option is set to "closed" no application form is available, and when
> the option is set to "open" (via the automated task) the application form
> is available.
>
> My question is: what does ColdFusion offer in the way of triggering 
> events?
> For instance, I'd like the date/time that is already entered into the
> database to be checked regularly and executed automatically by the CF
> server. How can that be set up?
>
>
> Thanks in advance,
>
> Roberto Perez
> [EMAIL PROTECTED]
>
>
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:59
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: godaddy.com now has CFMX7 hosting!

[Webmaster at FastTrack On Line]

or about 50p uk ;)

also j/k .. hehe

- Original Message - 
From: "Ray Champagne" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Friday, October 14, 2005 10:08 PM
Subject: Re: godaddy.com now has CFMX7 hosting!


> $24.95 Canadian, eh?
>
> What's that, like $5.00/ mo US$?
>
> J/K, LOL
>
> Bryan Stevenson wrote:
>> I still say use Uniserve up here in Canada...$24.95 /mnth CANADIAN (still
>> CFMX 6.1)nothing disabled and you get a free MS SQL Server DB!!
>>
>> Bryan Stevenson B.Comm.
>> VP & Director of E-Commerce Development
>> Electric Edge Systems Group Inc.
>> phone: 250.480.0642
>> fax: 250.480.1264
>> cell: 250.920.8830
>> e-mail: [EMAIL PROTECTED]
>> web: www.electricedgesystems.com
>>
>>
>>
>
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221110
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Time management

[Webmaster at FastTrack On Line]

Hi Donna,

Number 1, don't have people coming to your desk if you can at all help it. 
Tell them all requests for change have to be at least emailed, better still 
sent to you on a form.  Get buy in to your need to manage your time from 
your line manager or you are really up there without a paddle.

I've been in that situation many a time, and unless you get total support 
from your line manager it's going to be horrendous.

My tuppenth,

Jenny

- Original Message - 
From: "Donna French" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Tuesday, October 11, 2005 5:05 PM
Subject: Time management


> I'm the whole IT dept. at the company I work for - development,
> networking, support, search engine optimization, etc. - and wonder
> what others out there in the same position use to manage their time?
> I've taken a couple weeks off and have been getting things here at
> home organized which has made me realize how UNorganized things at the
> office are. There are upgrades to the existing site that I want to
> implement but get caught up in the day-to-day grind of getting things
> done that are a must. Any suggestions welcome - even if it's a good
> ole pencil and paper! LOL
>
> TIA,
> Donna
>
> --
> Donna French
> [EMAIL PROTECTED]
>
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220777
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFFTP thru Corporate Firewall

[Webmaster at FastTrack On Line]

Hi Mario,

Perhaps this is the case:

The cfftp is running from your CF server and the ftp is running from your 
workstation.  Assumption being your development pc and server pc aren't one 
and the same?  So, you'd need to see how the firewall rules differ from your 
server to your workstation.

I suggest you take a live look at the firewall logs while you are attempting 
to ftp/cfftp to see exactly what is happening and it may well shed some 
light on your problem.

If you aren't sysadmin on the cf server you need to involve whoever is 
looking after it.

Jenny

- Original Message - 
From: "Ciliotta, Mario" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Tuesday, October 11, 2005 10:55 PM
Subject: CFFTP thru Corporate Firewall


> Hi,
>
> I was wondering in anyone has had any experience using CFFTP thru a 
> corporate firewall to FTP a file to outside server?
>
> I am trying to FTP a file from my internal CF server to a 3rd party 
> vendors server.  I need to go thru our proxy server in order to gain 
> access to the outside world.
>
> I can connect (OPEN) to the proxy server internal but when I try to 
> connect to the vendors server, the CFFTP fails.
>
> I have tested all the connection manually thru the command prompt on my 
> desktop and I have all the required ids, passwords and server to connect. 
> I am actual able to connect to my FTP proxy server, connect to the vendors 
> server  and FTP (PUT) a file on their system and run DIR command to see my 
> file.  I have no luck doing this with CFFTP.
>
> Do I need to investigate possibly using Java to do the FTP?
>
> Thanks
> Mario
>
> ==
> Please access the attached hyperlink for an important electronic 
> communications disclaimer:
>
> http://www.csfb.com/legal_terms/disclaimer_external_email.shtml
>
> ==
>
>
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220776
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Carriage returns

[Webmaster at FastTrack On Line]

Hi Matthew,

I do that when processing the text area input field before storing it in ms 
sql ?

Thanks, Jenny

- Original Message - 
From: "Matthew Small" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Monday, October 10, 2005 2:22 PM
Subject: RE: Carriage returns


> Replace the carriage returns with "".
>
>
>
> Matthew Small
> Web Developer
> American City Business Journals
> 704-973-1045
> [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Webmaster at FastTrack On Line
> [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 10, 2005 9:19 AM
> To: CF-Talk
> Subject: Carriage returns
>
> I'm using a form text area inout to store data into an ms sql nvartext
> field.
>
> My problem is that when the field is displayed all of the carriage returns
> are lost and it ends up one big blob of hard to read text.  Is there some
> way I can format so that the carriage returns work, please?
>
> Jenny
>
>
>
>
>
>
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220586
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Carriage returns - sorted

[Webmaster at FastTrack On Line]

Ahh, excellent, works great, thanks Mike :-) !

Jenny

- Original Message - 
From: "Dawson, Michael" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Monday, October 10, 2005 2:32 PM
Subject: RE: Carriage returns


> In other words,
>
> #replace(string, chr(13) & chr(10), "", "all")#
>
> M!ke
>
> -Original Message-
> From: Matthew Small [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 10, 2005 8:22 AM
> To: CF-Talk
> Subject: RE: Carriage returns
>
> Replace the carriage returns with "".
>
>
>
> Matthew Small
> Web Developer
> American City Business Journals
> 704-973-1045
> [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Webmaster at FastTrack On Line
> [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 10, 2005 9:19 AM
> To: CF-Talk
> Subject: Carriage returns
>
> I'm using a form text area inout to store data into an ms sql nvartext
> field.
>
> My problem is that when the field is displayed all of the carriage
> returns are lost and it ends up one big blob of hard to read text.  Is
> there some way I can format so that the carriage returns work, please?
>
> Jenny
>
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220587
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Carriage returns

[Webmaster at FastTrack On Line]

I'm using a form text area inout to store data into an ms sql nvartext 
field.

My problem is that when the field is displayed all of the carriage returns 
are lost and it ends up one big blob of hard to read text.  Is there some 
way I can format so that the carriage returns work, please?

Jenny




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220532
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54