Hi list, is there a way to
limit the Mail traffic
under CF 6.1 ? (Spooling-time ?)
We have seen high CPU-loads (smtp-threads)
with our eMail server when
sending out thousands of eMails
based on a customers newsletter.
We use Win2000, CF 6.1 and IMail
as a mail-server.
This didn't happen with CF 5.
Sorry to weigh in so late on this one...
If you add a random number to your query string, you should force a page
refresh.
For example
http://www.mysite.com?randomnumber={place random number here}
Mike Wolfe
[EMAIL PROTECTED]
_
From: Jim Gurfein [mailto:[EMAIL PROTECTED]
Sent:
cfquery datasource=moteladam_moteladam_com
update data
set data = "" value=#form.EditorDefault# cfsqltype=cf_sql_varchar
where nav_id = #form.nav_id#
/cfquery
ERROR
ODBC Error Code = S1104 (Invalid precision value)
[Microsoft][ODBC Microsoft Access Driver]Invalid precision value
[Todays
Dan,
I might be wrong here, but it looks like Access is choking on your
choice of a cfsqltype.
Cutter
Daniel Farmer wrote:
cfquery datasource=moteladam_moteladam_com
update data
set data = "" value=#form.EditorDefault#
cfsqltype=cf_sql_varchar
where nav_id = #form.nav_id#
/cfquery
you need to give it a name
CFQUERY name=something datasource=moteladam_moteladam_com
From: Daniel Farmer [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 24, 2004 10:31 AM
To: CF-Talk
Subject: so what am I doing wrong?
cfquery
Daniel Farmer wrote:
cfquery datasource=moteladam_moteladam_com
update data
set data = "" value=#form.EditorDefault# cfsqltype=cf_sql_varchar
where nav_id = #form.nav_id#
/cfquery
ERROR
ODBC Error Code = S1104 (Invalid precision value)
[Microsoft][ODBC Microsoft Access
try this:
cfquery name=qData datasource=moteladam_moteladam_com
update data
set data = "" value=#form.EditorDefault#
cfsqltype=cf_sql_varchar
where nav_id = #form.nav_id#
/cfquery
HTH,
Josh
---
Exciteworks -- expert hosting for less!
http://exciteworks.com
specializing in reseller accounts
Jochem van Dieten wrote:
Daniel Farmer wrote:
cfquery datasource=moteladam_moteladam_com
update data
set data = "" value=#form.EditorDefault# cfsqltype=cf_sql_varchar
where nav_id = #form.nav_id#
/cfquery
ERROR
ODBC Error Code = S1104 (Invalid precision value)
[Microsoft][ODBC
I'm trying to kill all the client variables in one clean sweep but can't
seem to get it right.I kind of worked out how to do one as:
cfset temp = DeleteClientVariable(user)
But how do I just go through all current client variables and delete
them all?
Is it something like?
cfset temp =
I'm in the same boat with the same software and upgrade path.However I
never noticed MX 6.1 behaving differently in terms of serfer load.I've
done these things:
1. Set the mail spool fetch rate to a low interval.The default used to
be 15 seconds, but trying it under MX I see it can now go down to
Hi all,
I have a question about the JRun that is installed with ColdFusion Enterprise (second install option).
Do I have to install Macromedia's JRun updaters or are they already added in?
Would future patches show up in the ColdFusion Support or JRun support? (I mean, I didn't purchase JRun,
I use Imail 8.x and have had no problems with CPU usage when processing CFMAIL.
I have the delay set at 1 sec. The difference is that outgoing mail is not
scanned by the anti-spam filters in Imail, and all incoming mail comes in via a
Postfix/Linux server which does the scanning, then relays to
Is anyone having any problems running CFMX, either JRUN installed or default
installation as a filter? We seem to keep having problems with the ODBC
server dropping and JRUN dying on us a few times a day. We are running IIS
6, Windows 2003 server, and CFMX with the latest update. Any feedback
Oh, and if it helps, it is 2003 enterprise edition.
From: Robert Bailey [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 24, 2004 1:18 PM
To: CF-Talk
Subject: 2003 server and CFMX
Is anyone having any problems running CFMX, either JRUN installed or default
Check your error logfiles.Sounds like there are some long running processes
that are not timing out in a timely fashion.
==
Stop spam on your domain, Anti-spam solutions
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
I had to drop Imail's antispam.It just didn't work for me.Declude
Junkmail Pro is what is dragging down my outgoing mail.Even when I
properly auto-whitelist CF-generated mail, that program still needs to
'see' the mail, and log it as whitelisted; enough to spawn a boatload of
processes that drag
If they are not timing out in a timely fashion, how can I fix that? Looking
at the logs now.
From: Doug White [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 24, 2004 1:30 PM
To: CF-Talk
Subject: Re: 2003 server and CFMX
Check your error logfiles.Sounds like
Eclipse 3 is a fair bit different. If your starting point was the
example HTML plug-in then things are going to be tough moving to
Eclipse 3.
-Matt
On Jan 23, 2004, at 11:16 PM, Rob Rohan wrote:
As far as I know it's the 2 API (I have eclipse 2.1.2) - basically I
just needed *something* as
I started with the built in editor only plug-in selection and wrote
everything else from scratch. It was based on XML. And again, the syntax
highlighting is so-so - the code completion stuff seems to work pretty
well.
Where are you getting your eclipse 3 information? everything I am
finding is
I originally used Eclipse 2 until is stopped working on my Mac. Back
then I had written my own CF plug-in and was working with several other
open source plug-ins. All of them stopped working when I moved to
Eclipse 3. I looked into the problems and saw that important parts of
the API had
a.. I gave the query a name and got the same error.
b.. I removed the cfsqltype and got the same error.
cfquery name=qData datasource=moteladam_moteladam_com
update data
set data = "" value=#form.EditorDefault#
where nav_id = #form.nav_id#
/cfquery
- Original Message -
From: Jochem van
I mean, are there sites that list the differences between 2 and 3? And
since 3 is not done yet, are they still making changes to the API?
I fear we are pretty far off topic now hehehe, but I am going to
download 3 right now and see how different it is - I'll try to port the
simple plug-in right
Yeah works the same on 3.0 - just had to move some files around. I'll
try to figure out how to post it with the 2.1 on the site I listed
before if you want to give it a shot.
On Sat, 2004-01-24 at 11:51, Rob Rohan wrote:
I mean, are there sites that list the differences between 2 and 3? And
Daniel Farmer wrote:
a.. I gave the query a name and got the same error.
Queries are not required to have a name.
b.. I removed the cfsqltype and got the same error.
cfquery name=qData datasource=moteladam_moteladam_com
update data
set data = "" value=#form.EditorDefault#
where nav_id =
Wow, that is weird. Eclipse 2 doesn't even work on my Mac anymore ever
since I upgraded to the latest JRE. Further, Eclipse 2 plug-ins don't
work for me on Eclipse 3. What milestone are you using?
-Matt
On Jan 24, 2004, at 3:20 PM, Rob Rohan wrote:
Yeah works the same on 3.0 - just had to
I would appreciate a look at your photo-album site. I am considering doing something just like that. What's important to me though is the content (geniology,photos) not that I wrote it all myself.
Thanks in advance,
Chris Phillips
You could send me a link privately to [ welcomehtml AT hotmail
I use Eclipse 2.1.2 on my Mac (X10.3 out-o-the box) and it works pretty
well (there are a bit of visual oddities but it works fine). To be frank
though I mostly develop on Linux so my usage is only in testing on the
Mac (until I can scrape together 7 million dollars to by a good Mac
hehehe). I do
In CF administrator, you can shorten the setting for terminating long running
queries.You can also set the log setting to log the long running queries.
One of the biggest challenges to ColdFusion developers is to learn enough SQL to
avoid huge queries when supporting a data driven web site.There
Thanks Doug. I personally know SQL very well, but these are hosted domains
and we do not have any control over the content that other developers use.
From: Doug White [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 24,
someone else suggested that I give it a nameso that's why I did it. I originally did not specify a name attribute.
But did you change the datatype? - yes, I used cf_sql_varchar and cf_sql_char
How long is the string you are trying to insert - pretty long as it's the equiv to an html page,
And
Daniel Farmer wrote:
someone else suggested that I give it a nameso that's why I did it. I originally did not specify a name attribute.
But did you change the datatype? - yes, I used cf_sql_varchar and cf_sql_char
How long is the string you are trying to insert - pretty long as it's the
As a host, I am in a similar position.By reviewing the log files, you can see
which application is bottlenecking things, and perhaps a polite note to the
client will encourage them to fix things.The other option is to time out those
long running queries, and the errors he will start getting will
Yeah, that is what we are going to do. We actually just purchased 160 new
hosting accounts from this one webhost/developer and all the code is so
sloppy, and I am still going through the mess. I will watch the timeouts now
that I shoved it down to 60, that should do it.
Matt,
thank you.
This was very helpful.
Infact I have the same issue, when I take
IMS-SE. The CPU-LOAD gets up too.
I have IMail 6.06
I wonder if there is something misconfigured.
Looking on number 3 of your solutions right now is not
that much an option for me, since 250 USD for IMS-SE
would be
you only have to buy IMS_SE alone.Its pretty reasonable, although if
you still have cpu spikes thats no help.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 24, 2004 3:13 PM
To: CF-Talk
Subject: Re[2]: eMail-server high load of CPU
Matt,
I am running both IMS-SE and Argosoft. IMS-SE for bulk mailings and
ArgoSoft for all other mail send by our web apps. I estimate we send about
1000-2000 emails per day with Argosoft with no problems at all. ArgoSoft is
has been a good,stable product for us.
Brook
At 03:13 PM 1/24/2004, you
I've heard from the technical editor that it's great. I can't speak on it's publishing date, but I'd suggest you reserve your copy now. :)
title something like Teach Yourself Regular Expressions.
It was listed at Amazon.com for November release. If it's anything
like the SQL in 10 Minutes
And what is the definition of the field you are trying to update? - memo
IIRC, cf_sql_longvarchar is the datatype you're looking for. On that note, I
*believe* char and varchar actually play nicely instead of choke upon
implementation. It's just when you pass the 255 character mark is when it
do you have LongRetrieval of long text checked in CF Administrtor?
==
Stop spam on your domain, Anti-spam solutions
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
==
Aspire to Inspire
I am looking at having to read anywhere from 500 to 2000 XML files at a time
and update the database with information from the files. I know how to get
around an XML file with either MX's built-in functions or SiteOjects's
custom tags.
Each XML file has a standard stucture - same main
The JRun that comes with CFMX install option 2 is JRun4 with Updater 2. This
is the latest update. You should be able to check the version number in the
JMC, and it will reflect this.
-nathan strutz
-Original Message-
From: Steven Durette [mailto:[EMAIL PROTECTED]
Sent: Saturday, January
Thanks for asking! It was delayed, but is done, and should be shipping
in a month or so I hope. It is modeled on the Sams Teach Yourself SQL
book (although a bit smaller), was tech edited by our very own Mike
Dinowitz, and includes ColdFusion coverage. I'll post a note when it
ships.
--- Ben
Actually the JRun that comes with CFMX 61 installer is a 'touch' later
build than the standalone JRun with updater 2. I haven't actually
compared build numbers but I was told this by some key MM folks.
Stace
_
From: Nathan Strutz [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 24, 2004
Thanks Ben. As the tech editor and a RegEx fan, I can say that your book
takes the perfect position between knowing nothing about RegEx and the
Mastering RegEx book. The problem with knowing nothing is obvious while the
problem with the mastering book is that it's just so dense. A RegEx fan like
I just installed CFMX on SUSE 9 and the server starts fine. I used the built in CF web sever as shown (http://192.168.1.51:8500/cfide/administrator/index.cfm) I get the following errors in the: /opt/coldfusionmx/logs/cfserver.log
error There is no web application configured to service your
I just installed CFMX on SUSE 9 and the server starts fine. I used the built in CF web sever as shown (http://192.168.1.51:8500/cfide/administrator/index.cfm) I get the following errors in the: /opt/coldfusionmx/logs/cfserver.log
error There is no web application configured to service your
found a way to make the dbvarname attribute work (among
other things). All my findings are on the blog. I'm sure the custom
tag I designed will need debugging, and I welcome any feedback anyone
has.
Thanks!
http://www.turnkey.to/ontap/blog/?20040124
s. isaac dealey 214-823-9345
team macromedia
47 matches
Mail list logo