Re: Email Management Software

2011-07-22 Thread Stefan Richter
If you are on a Mac you could give Direct Mail a try. http://ethreesoftware.com/directmail/index.php I've bought the Pro version and have been using it to manage lists with more than 20,000 subscribers for several years to send monthly newsletters. I like the fact that it can connect directly

Using a remote CF server for Solr collections

2011-07-22 Thread cft...@ecartech.com
We have 8 load balanced CF servers running the same site, all of which need to call the same Solr collection for a search page. Rather than creating the collection across each of the servers, is there a way to just create the collection on 1 server and have the other 7 access it? If so, is

Re: Email Management Software

2011-07-22 Thread Larry Lyons
+100 for mailchimp. Its very good at what it does, very flexible and most importantly very flexible. I've used it to manage email campaigns that have gone out to 10,000+ recipients. There's also a pretty sweet CFC wrapper for the MailChimp API, http://mailchimp.riaforge.org/ hth, larry You

Re: Orm update to reflect db changes

2011-07-22 Thread Dorioo
Try ormReload() - Gabriel On Wed, Jul 20, 2011 at 10:13 PM, Victor Moore victor.mo...@gmail.com wrote: Hi, I have a question about orm on CF 9.01. When I make changes to the db the calls using orm do not see the changes. The only way to fix it is to re-start the server. While this is OK

Re: Using a remote CF server for Solr collections

2011-07-22 Thread Dominic Watson
Yes it is. You can change the location of the Solr server in the administrator very easily - it defaults to localhost:8983 but you can have your 8 servers point at a single server by changing that entry. This is very easy to do. Solr also supports collection replication - you can have one master

Re: Using a remote CF server for Solr collections

2011-07-22 Thread Dominic Watson
This might also be useful, instructions for installing Solr standalone on Tomcat. On Step 3 of the instructions, you could try to copy your current Solr config from ColdFusion (dig around to find it) into the relevant place.

Re: Solr Question

2011-07-22 Thread Dominic Watson
Correction, Solr *could*, CF won't. In short, the CF9 implementation of Solr doesn't tap into all the goodiness that Solr provides (like defining properly named custom fields in your collections and much much more). Solr is awesome. If you have the time for a little learning curve, I'd highly

Passing a Ref_cursor to Oracle Stored procedure

2011-07-22 Thread Dave Smith
Has anyone ever passed a cf_sql_refcursor as an IN param to an oracle stored proc? I am getting the following error when I try it: [Macromedia][Oracle JDBC Driver]Unable to determine the type of the specified object. The proc works when called from another procedure w/ in Oracle but not

RE: Passing a Ref_cursor to Oracle Stored procedure

2011-07-22 Thread Mark A. Kruger
Wouldn't a reference to a cursor actually be a cursor created on the DB server? A query object would technically be an array right? A cursor is a purlely database construct. Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com

RE: Email Management Software

2011-07-22 Thread UXB
What does everybody else do or any recommendations? We use a product called Mailxpert http://www.xtreeme.com/mailxpert/ for both discussion and broadcast lists. It's primary feature was that it was very inexpensive $125.00 US but has proven to be fairly robust. It is configurable but is not

Out of memory error when creating Solr collection

2011-07-22 Thread cft...@ecartech.com
I'm trying to create a Solr collection from a query that returns about 3 million records. The query itself takes about 3 minutes to run in SQL Studio. When trying to run it in CF to create my collection, I get java.lang.OutOfMemoryError: Java heap space every time. Here's what I've tried

re: Out of memory error when creating Solr collection

2011-07-22 Thread cft...@ecartech.com
I guess I hit the send button too quickly. I realize that the java heap space error is coming from my query. I've tried putting it in a view, and a stored proc, but still get the error. So, I guess my question really should be, how can I get large amounts of data from the DB put into a

Re: Email Management Software

2011-07-22 Thread Russ Michaels
If you want to keep it all in-house then try www.phplist.com, this is a very robust host it yourself bulk mailing solution. I do not know of anything built in CF that comes close. On Fri, Jul 22, 2011 at 8:01 PM, UXB denn...@uxbinternet.com wrote: What does everybody else do or any

Re: Passing a Ref_cursor to Oracle Stored procedure

2011-07-22 Thread James Holmes
The short answer is that you can't do this from CF. -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 23 July 2011 00:09, Dave Smith cyl...@yahoo.com wrote: Has anyone ever passed a cf_sql_refcursor as an IN param to an oracle stored proc?  I am getting the following

Re: Out of memory error when creating Solr collection

2011-07-22 Thread Dan G. Switzer, II
Eric, I'd return the records in like 50,000 row chunks and process them that way. If you're using SQL Server 2005+ you can use CTEs to paginate the results (but most modern database have a way of doing pagination.) This will keep the memory footprint lower. -Dan On Friday, July 22, 2011,