Re: ColdFusion 9 Session Replication

2011-10-11 Thread Russ Michaels
I have tested this method as well, and I have found that using files causes less overhead. On Tue, Oct 11, 2011 at 6:10 AM, Justin Scott leviat...@darktech.org wrote: One option is to use client vars, but they cannot store complex vars and changing from session to client scope is a PITA in

RE: Hiding email address from spiders

2011-10-11 Thread Sebastiaan GMC van Dijk
Or just use CFFormProtect @ http://cfformprotect.riaforge.com/ Has worked for me for years ;-) Sebastiaan Naafs - van Dijk = So long and thanx 4 all the fish == Onlinebase.nl To: cf-talk@houseoffusion.com Subject: Re: Hiding email address from spiders Date:

Re: Hiding email address from spiders

2011-10-11 Thread Raymond Camden
Huge +1 here. I've had a LOT of success with cfformprotect. I hate to call it a magic bullet, but it's had a significant impact on my spam issues. On Tue, Oct 11, 2011 at 5:58 AM, Sebastiaan GMC van Dijk seb...@hotmail.com wrote: Or just use CFFormProtect @ http://cfformprotect.riaforge.com/

Check for list of words in string

2011-10-11 Thread Brian Cain
Hello all, I would like to check a string against a list of keywords and either null the string or replace the keywords if found. Over the past couple of weeks someone has been probing my sites for SQL injection vulnerabilities. I have used queryparams and other types of validation. but I

Re: Check for list of words in string

2011-10-11 Thread Matt Quackenbush
Regular expressions. if ( reFindNoCase((select|declare),myString) 0 ) { // at least one of the words is present } HTH On Tue, Oct 11, 2011 at 9:11 AM, Brian Cain bcc9...@gmail.com wrote: Hello all, I would like to check a string against a list of keywords and either null the

Re: Check for list of words in string

2011-10-11 Thread Raymond Camden
Just don't forget that any special characters in your keywords would have to be escaped. So for example, if your keyword is Cat.Dog, then the dot means something special. It isn't as quick, but a simple loop over the list and making use of findNoCase may work well. On Tue, Oct 11, 2011 at 9:16

Re: 301 Redirects - showing as 302's

2011-10-11 Thread Gabriel Perez
I am having the same issue, has anyone figured out a solution for this? I'm doing the following: cfheader statuscode=301 statustext=Moved permanently cfheader name=Location value=#SomeNewURL# It produces a 302 status code So I tried cfheader statuscode=301 statustext=Moved

Re: Hiding email address from spiders

2011-10-11 Thread Mary Jo Sminkey
I had the same problem.. what I did is store the email addresses in a database and then replace the email link with a link to a feedback form on your website. When people want to email someone, they click the link, fill out and submit the form. They never get to see the actual email address.

Re: JVM Heap Size

2011-10-11 Thread Sean Corfield
On Fri, Oct 7, 2011 at 3:35 AM, John M Bliss bliss.j...@gmail.com wrote: In CFAdmin Server Settings Java and JVM, I have minimum and maximum JVM heap size form fields set to 1024 MB. However, I do not have -Xms1g -Xmx1g in the JVM args. Do I need both? I'll defer to others since I never

RE: Check for list of words in string

2011-10-11 Thread Brook Davies
Wouldn't this also catch words like 'myselection'? Brook -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: October-11-11 7:16 AM To: cf-talk Subject: Re: Check for list of words in string Regular expressions. if ( reFindNoCase((select|declare),myString)

Re: Check for list of words in string

2011-10-11 Thread Brian Cain
For my specific implementation, I decided to use a combination approach. Remembering this is an attempt to mitigate SQL injection exploits, I check for select or declare in the query string. I realized forms posed a slightly different problem, as I have many user posting long text data the

Count rows in Excel file

2011-10-11 Thread Brook Davies
Hey Everyone, Anyone know a way to count the rows in an excel file without using cfspreadsheet to read the entire file in first? That's what I am trying to avoid.. Brook ~| Order the Adobe Coldfusion Anthology now!

Re: Count rows in Excel file

2011-10-11 Thread Gerald Guido
Off the top of my head. If you set it up as a DSN you could (in theory) query it using COUNT(SomeColumn) AS myRowCount. That assumes that a DSN using Excel supports the COUNT() function. HTH, G On Tue, Oct 11, 2011 at 4:26 PM, Brook Davies cft...@logiforms.com wrote: Hey Everyone, Anyone

Re: Check for list of words in string

2011-10-11 Thread Peter Boughton
Wouldn't this also catch words like 'myselection'? Yes. \b is your friend. :) Or possibly even stuff like (?=^|;)\s*(?:SELECT|DECLARE|EXEC|etc)\b to ensure this is stuff at a beginning of a string/statement. But I don't really agree with the general approach here. With cfqueryparam +

Re: Error handler or database bringing down server?

2011-10-11 Thread Jon F
Install a full JDK and use jstack to generate a thread dump when this happens again. Then you can see what is going on and fix it. Thanks for your help on this issue. It was able to assist in finding the issue. The problem was due to the timeout setting in CF Administrator and the number of

Re: Count rows in Excel file

2011-10-11 Thread Dan Baughman
Ad hoc SQL datasources may be an option if you have sufficient privleges on a sql server and the account running sql has permissions to access the file. On Tue, Oct 11, 2011 at 2:26 PM, Brook Davies cft...@logiforms.com wrote: Hey Everyone, Anyone know a way to count the rows in an excel

Coldfusion as Windows Service Throwing 500 Errors

2011-10-11 Thread Carl Von Stetten
My backup ColdFusion Standard server, which runs on 32-bit Windows 2003, just started throwing 500 errors with the following stacktrace displayed: java.lang.NullPointerException at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:285) at

Re: Coldfusion as Windows Service Throwing 500 Errors

2011-10-11 Thread Dave Watts
My backup ColdFusion Standard server, which runs on 32-bit Windows 2003, just started throwing 500 errors with the following stacktrace displayed: java.lang.NullPointerException        at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:285)        at

Re: Coldfusion as Windows Service Throwing 500 Errors

2011-10-11 Thread Carl Von Stetten
Yeah, I forgot to state that it was configured using a domain account for ColdFusion servers, that is supposed to be in the local Administrators group on the machine. I just checked into the server's local Administrators group and discovered that this domain account is not in that group

Re: Coldfusion as Windows Service Throwing 500 Errors

2011-10-11 Thread Dave Watts
Yeah, I forgot to state that it was configured using a domain account for ColdFusion servers, that is supposed to be in the local Administrators group on the machine.  I just checked into the server's local Administrators group and discovered that this domain account is not in that group