Re: How do I reduce scam attempts on my website. Arghh!

2009-08-27 Thread Mike Kear
I use a similar process to Akismet, but i connect all my sites to a common banIPs table on my central database. Any message or form going from any of my sites is filtered through this table. IF the sender's ip address is on the list, the message/form gets just discarded into the bit-bucket

Re: Converting from SQL to mySql

2009-08-27 Thread John Vincent
I am wondering how difficult it might be to migrate over to mySql from SQL2000? Is this a daunting task? Any assistance would be much appreciated. I would especially love to hear from someone who has done this. Regards, Doug B. I use data loader for migrating almost any data,

Re: (ot) profanity filter

2009-08-27 Thread Tom Chiverton
On Wednesday 26 Aug 2009, Peter Boughton wrote: It's idiotic that words can be considered offensive and blocked without context - yet I hope you suffer an eternity of burning agony will be allowed past just fine. You should have seen the bizzare errors I had to deal with as a sys. admin for

Re: Coldfusion Threads

2009-08-27 Thread Tom Chiverton
On Wednesday 26 Aug 2009, Byte Me wrote: Does anyone know how to get a list of Coldfusion Threads (created with the cfthread tag), programatically. I don't have access to the Server Monitor. If a thread is aborted, I need to know it was aborted, How about when you create the thread, you add

Custom 404 .cfm pages, and cf flash tags.

2009-08-27 Thread Paul Alkema
Hey All, I've recently ran into an issue that I was hoping I could have a little help with. My company has been using custom 404 pages for awhile that we set up in iis however we had never set up this custom 404 page to display on .cfm pages, only missing folders. Ie;

Re: Custom 404 .cfm pages, and cf flash tags.

2009-08-27 Thread Peter Boughton
From here I checked the verify that file exists open. Don't do that - it breaks things (as you've discovered). Instead, in the Administrator, you can specify the Missing Template Handler - set that to the same file as you're using for IIS and it should solve your problem. (You probably

Re: Custom 404 .cfm pages, and cf flash tags.

2009-08-27 Thread Azadi Saryev
you can also use onMissingTemplate() method in your Application.cfc this way you can define different error pages and handlers for your missing .cfm templates for each application running on same server, whereas settings in cf admin are server-wide (all applications running on same server will

sql deadlock

2009-08-27 Thread Chad Gray
I occasionally see this error in an application I wrote. Transaction (Process ID 54) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. The code that is causing this is below. cfloop

Re: sql deadlock

2009-08-27 Thread John M Bliss
http://en.wikipedia.org/wiki/Deadlock On Thu, Aug 27, 2009 at 8:46 AM, Chad Gray cg...@careyweb.com wrote: I occasionally see this error in an application I wrote. Transaction (Process ID 54) was deadlocked on lock | communication buffer resources with another process and has been chosen

Re: Custom 404 .cfm pages, and cf flash tags.

2009-08-27 Thread Peter Boughton
Good point, yes - if you've got multiple domains/applications on the server then you should probably do that. Still worth having a very generic server-level one as well though. ~| Want to reach the ColdFusion community with

Re: Converting from SQL to mySql

2009-08-27 Thread Larry Lyons
The value proposition of CF is that it pays for itself with shorter development and maintenance times. If that's not true for you, you shouldn't buy it no matter what the price is. If it is true for you, the price is irrelevant. As enterprise products go, CF is dirt cheap. Don't

Re: 500 Error / java.lang.Error: Error starting thread: Not enough storage is available to process this command.

2009-08-27 Thread Dave Watts
No body has a single word of advice about what this thread dump shows? Can some one point me in the right direction? I Googled it to no avail... It's a fairly generic Windows error. Are you storing client variables in the registry? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/

Cfemail issue(s)

2009-08-27 Thread Victor Moore
Hi all, I have a couple of issues with cfmail. Environment: Windows 2003, CF8.01 ent The server stopped sending emails After checking the logs .I found out that it stopped after complaining that one email had Invalid Address which is strange because I check all emails using isEmail () before

Re: Cfemail issue(s)

2009-08-27 Thread Cutter (ColdFusion)
See if this post helps you any: http://blog.cutterscrossing.com/index.cfm/2006/12/10/ColdFusion-Mail-Spool-Lock 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

Re: Cfemail issue(s)

2009-08-27 Thread Rick Root
On Thu, Aug 27, 2009 at 10:55 AM, Victor Moorevictor.mo...@gmail.com wrote: Is it possible to re-send the emails, short of restarting CF? I can't answer the other questions, but I don't know of any way to kick-start the mail spooler once it dies without restarting Coldfusion. This happens to

RE: Cfemail issue(s)

2009-08-27 Thread Mark Kruger
Victor, Do you mean you are passing a list of 500 addresses in a single attribute? As in: cfmail to=b...@blah.com,bl...@blah.com ... If that is what you are doing I would not be surprised if there is a buffer for that attribute that truncates your string at some point. You would be better

Re: Cfemail issue(s)

2009-08-27 Thread Victor Moore
Thank you both. I guess I will have to restart the server which will piss all the people on it. One would think that Adobe (Allaire, Macromedia) will have a fix for this by now. Thx Victor On Thu, Aug 27, 2009 at 11:02 AM, Rick Rootrick.r...@webworksllc.com wrote: On Thu, Aug 27, 2009 at

Re: Cfemail issue(s)

2009-08-27 Thread Cutter (ColdFusion)
One of my co-workers, Andy Matthews, wrote an app for that: http://undelivrnator.riaforge.org/ 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 _

Re: Problem with onblur event

2009-08-27 Thread Dave Watts
Likewise with all of those: can anyone provide clear benefits that are more significant than jQuery's clear dominance as THE JavaScript library: ... With other minority technologies (like CF), there are clear improvements that make them worth using compared to the more popular choices,

Re: CFSTOREDPROC kind of sucks

2009-08-27 Thread Tony Bentley
That is very nice Brad. Thanks for that perspective. First of all, it is my preference to explicitly check for an existing duplicate value prior to insertion instead of allowing SQL server to throw the error. The column constraint is my fall-back. Either way, if you want your stored

Re: Cfemail issue(s)

2009-08-27 Thread Victor Moore
Good point. I am not. The customer is sending. Now that I know that, I have to change the process and send in batches. Unfortunately the code bellow didn't restart the spooler so I had to restart the server Thanks Victor On Thu, Aug 27, 2009 at 11:06 AM, Mark Krugermkru...@cfwebtools.com

RE: 500 Error / java.lang.Error: Error starting thread: Not enough storage is available to process this command.

2009-08-27 Thread brad
I doubt his client vars are in the registry since the stack trace was trying to create a thread to get a JDBC connection as part of coldfusion.runtime.AppHelper.setupClientScope. If your JVM can't create any more threads, have you looked at the minimum and maximum amounts of memory your JVM heap

Re: Cfemail issue(s)

2009-08-27 Thread Bryan Stevenson
On Thu, 2009-08-27 at 11:35 -0400, Victor Moore wrote: Good point. I am not. The customer is sending. Now that I know that, I have to change the process and send in batches. Unfortunately the code bellow didn't restart the spooler so I had to restart the server Thanks Victor

RE: 500 Error / java.lang.Error: Error starting thread: Not enough storage is available to process this command.

2009-08-27 Thread Brook Davies
Hi Brad, Client vars in the database - never in the registry ;) Thanks for the advise. I have been tuning the JVM heap size for a long time and at a fairly happy place these days. There were some dark times along the way though, let me tell you. Maintain connections is checked and the purge

RE: sql deadlock

2009-08-27 Thread brad
Step 1: read the wiki page John sent. Step 2: Deadlocks take two resources to tango. You need to see what the two resources in question are. Run a trace and filter for deadlocks and lock escalations. That will give you some more information about ground zero at the time of the error. Are

WSDL vs. ODBC

2009-08-27 Thread Billy Cox
Has anyone here had a chance to evaluate system performance and reliability of WSDL versus ODBC? -Billy Cox ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing

Using CFReport in a Websphere (linux) environment

2009-08-27 Thread Dave Phillips
Hi all, I'm trying to create a simple report with CFReport (CF 8) and am getting the following error: Error 500: Could not find class: com.gp.java2d.ExHeadlessGraphicsEnvironment Can anyone give me any direction on how to solve this problem? I've tried CFREPORT with type=PDF or

Re: WSDL vs. ODBC

2009-08-27 Thread John M Bliss
http://en.wikipedia.org/wiki/Web_Services_Description_Language versus http://en.wikipedia.org/wiki/Open_Database_Connectivity ? In what context are you comparing those two? On Thu, Aug 27, 2009 at 11:40 AM, Billy Cox bi...@oldworldspices.comwrote: Has anyone here had a chance to evaluate

Re: WSDL vs. ODBC

2009-08-27 Thread Dave Watts
Has anyone here had a chance to evaluate system performance and reliability of WSDL versus ODBC? That question doesn't make sense. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers

Re: WSDL vs. ODBC

2009-08-27 Thread Bryan Stevenson
On Thu, 2009-08-27 at 12:46 -0400, Dave Watts wrote: Has anyone here had a chance to evaluate system performance and reliability of WSDL versus ODBC? That question doesn't make sense. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Yepat first I thought it was because

Re: Cfemail issue(s)

2009-08-27 Thread Rick Root
On Thu, Aug 27, 2009 at 11:07 AM, Cutter (ColdFusion)cold.fus...@cutterscrossing.com wrote: One of my co-workers, Andy Matthews, wrote an app for that: http://undelivrnator.riaforge.org/ This isn't an issue of respooling undeliverable email. It's a matter of noticing that the SPOOL

Re: WSDL vs. ODBC

2009-08-27 Thread Azadi Saryev
a quick evaluation showed that apples perform better, while oranges are more reliable. :) Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 28/08/2009 00:40, Billy Cox wrote: Has anyone here had a chance to evaluate system performance and reliability of WSDL versus ODBC? -Billy Cox

Re: WSDL vs. ODBC

2009-08-27 Thread Rick Root
On Thu, Aug 27, 2009 at 12:40 PM, Billy Coxbi...@oldworldspices.com wrote: Has anyone here had a chance to evaluate system performance and reliability of WSDL versus ODBC? Um... ODBC is faster. (?) -- Rick Root CFFM - Open Source Coldfusion File Manager http://www.opensourcecf.com/cffm

Re: WSDL vs. ODBC

2009-08-27 Thread Scott Stroz
Yes, but you can make a quasi-word out of WSDL. On Thu, Aug 27, 2009 at 12:55 PM, Rick Rootrick.r...@webworksllc.com wrote: On Thu, Aug 27, 2009 at 12:40 PM, Billy Coxbi...@oldworldspices.com wrote: Has anyone here had a chance to evaluate system performance and reliability of WSDL versus

Re: WSDL vs. ODBC

2009-08-27 Thread Rick Root
On Thu, Aug 27, 2009 at 12:59 PM, Scott Strozboyz...@gmail.com wrote: Yes, but you can make a quasi-word out of WSDL. Only if you're in one of those countries that has outlawed vowels. -- Rick Root CFFM - Open Source Coldfusion File Manager http://www.opensourcecf.com/cffm

Re: WSDL vs. ODBC

2009-08-27 Thread Casey Dougall
On Thu, Aug 27, 2009 at 1:02 PM, Rick Root rick.r...@webworksllc.comwrote: On Thu, Aug 27, 2009 at 12:59 PM, Scott Strozboyz...@gmail.com wrote: Yes, but you can make a quasi-word out of WSDL. Only if you're in one of those countries that has outlawed vowels. LMFAO!

Re: WSDL vs. ODBC

2009-08-27 Thread Dave Sueltenfuss
I think it would be more like comparing apples to a book On Thu, Aug 27, 2009 at 12:52 PM, Azadi Saryev az...@sabai-dee.com wrote: a quick evaluation showed that apples perform better, while oranges are more reliable. :) Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On

Re: Cfemail issue(s)

2009-08-27 Thread Victor Moore
True. I had a resend email scheduler job already implemented. I end up sending in batches. 200 emails at one time. It seems it's working fine. Is there a upper limit that I should be aware? Thanks Victor On Thu, Aug 27, 2009 at 12:52 PM, Rick Rootrick.r...@webworksllc.com wrote: On Thu, Aug

RE: Using CFReport in a Websphere (linux) environment

2009-08-27 Thread brad
You always find the weird ones Dave. :) I don't have an answer, but it appears you aren't the first with the problem: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:29706 You could try Barney's suggestion of installing X11, or perhaps you can get a hold of Dave Carabetta and

Re: WSDL vs. ODBC

2009-08-27 Thread Billy Cox
It would be in the context of syncing a local app server with a cloud system like salesforce.com or netsuite. John M Bliss wrote: http://en.wikipedia.org/wiki/Web_Services_Description_Language versus http://en.wikipedia.org/wiki/Open_Database_Connectivity ? In what context are you

Re: WSDL vs. ODBC

2009-08-27 Thread John M Bliss
I'm still not sure I understand but, ignoring that for a sec, have you determined that salesforce.com / netsuite offer API's that'd allow you to touch their systems via WSDL and ODBC? If so, I'd ask salesforce.com / netsuite which is faster. Typically, WSDL / webservices are good for touching

Re: WSDL vs. ODBC

2009-08-27 Thread Dave Watts
It would be in the context of syncing a local app server with a cloud system like salesforce.com or netsuite. I don't think that asking about system performance is an especially good idea for getting your questions answered. In general, JDBC expects direct network connections, open database

Re: WSDL vs. ODBC

2009-08-27 Thread John M Bliss
I see, said the blind man as he picked up his hammer and saw! :-) Good web services will be slower and less reliable than good ODBC. Having said that, there're many, many things you can do to make web services fast/reliable enough and, obviously, the cloud has lots of other advantages... On

Re: WSDL vs. ODBC

2009-08-27 Thread Dave Watts
Salesforce and Netsuite both have a web services API. I am trying to gauge impacts involved with switching from a system that uses ODBC to a cloud based system.  If a web service is faster and/or more reliable than ODBC, then that helps me to make a case for the cloud. I doubt it'll be

Re: WSDL vs. ODBC

2009-08-27 Thread Adam Haskell
It will be slower, reliability will also be lower when compared to ODBC if that is all behind the firewall. Security is also a lot harder with SOAP/WSDL and much more varied. Adam On Thu, Aug 27, 2009 at 3:11 PM, Billy Cox bi...@oldworldspices.com wrote: Salesforce and Netsuite both have a

Re: WSDL vs. ODBC

2009-08-27 Thread Adam Haskell
They may be up more often but you have more network hops and more breaking points. If you put your Database outside the internal network, I think net result would be a less reliable RDBMS Adam On Thu, Aug 27, 2009 at 3:17 PM, Dave Watts dwa...@figleaf.com wrote: Salesforce and Netsuite

Re: WSDL vs. ODBC

2009-08-27 Thread Alan Rother
I'll be darned.. http://www.datadirect.com/products/openaccess-sf/index.sspDataDirect OpenAccess *for* ODBC for Salesforce Data Source http://www.datadirect.com/products/openaccess-sf/index.ssp -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User

Re: WSDL vs. ODBC

2009-08-27 Thread John M Bliss
I too will be darned. :-) Wonder how much that costs... On Thu, Aug 27, 2009 at 2:24 PM, Alan Rother alan.rot...@gmail.com wrote: I'll be darned.. http://www.datadirect.com/products/openaccess-sf/index.sspDataDirect OpenAccess *for* ODBC for Salesforce Data Source

Re: WSDL vs. ODBC

2009-08-27 Thread Billy Cox
Salesforce and Netsuite both have a web services API. I am trying to gauge impacts involved with switching from a system that uses ODBC to a cloud based system. If a web service is faster and/or more reliable than ODBC, then that helps me to make a case for the cloud. John M Bliss wrote:

Re: WSDL vs. ODBC

2009-08-27 Thread Rick Root
If you are accessing a database on a remote server, and you have two options, one of them being web service calls, and the other being ODBC, I don't think there's any doubt that the ODBC route would probably be faster. But it does seem extremely unlikely that any remote service, such as

Session Based Recently Viewed Items...

2009-08-27 Thread Che Vilnonis
What would be the simplest way (using session vars), to keep track of up to four Recently Viewed Items on an e-commerce site? Once the 5th item is viewed, the 1st item is removed and so on? I have some code that works... but I think I've overcomplicated things. Any opinions? Thanks, Che

Re: WSDL vs. ODBC

2009-08-27 Thread Jason Fisher
My guess is that they're staging data calls and still routing through their API objects to handle authentication / validation and all the other business logic they have in place in their API model. ~| Want to reach the

Re: Session Based Recently Viewed Items...

2009-08-27 Thread John M Bliss
Howabout something like...? cfparam default= name=session.RecentlyViewedItems cfparam default= name=NewlyViewedItem cfif NewlyViewedItem is not cfset session.RecentlyViewedItems = ListAppend(session.RecentlyViewedItems, NewlyViewedItem) cfif ListLen(session.RecentlyViewedItems) GT 4 cfset

Re: WSDL vs. ODBC

2009-08-27 Thread Alan Rother
My guess is that they're staging data calls and still routing through their API objects to handle authentication / validation and all the other business logic they have in place in their API model. That does seem to be what they are doing, you enter a SQL command, it translates it and spits out a

RE: Session Based Recently Viewed Items...

2009-08-27 Thread Che Vilnonis
listRest EQ more elegant solution than mine. Thanks, John! -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Thursday, August 27, 2009 5:01 PM To: cf-talk Subject: Re: Session Based Recently Viewed Items... Howabout something like...? cfparam default=

How to make ODBC Connection to Access DB with MDW Connection

2009-08-27 Thread Jeanmarie Richardson
Hi -- I need to make an ODBC connection to an access database that utilizes an MBW file for security. How can this be done? Could I use a connection string? Or does the ODBC manager allow this. Thanks in advance! ~| Want