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 gr

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 anymor

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 > jrun.se

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 jrun.servlet.Servlet

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 wrote: > > Hey Everyone, > > > > Anyone know a way to count the rows in an excel file without us

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 o

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 + tho

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 wrote: > > Hey Everyone, > > > > Anyone know a way to

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! htt

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 often

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: JVM Heap Size

2011-10-11 Thread Sean Corfield
On Fri, Oct 7, 2011 at 3:35 AM, John M Bliss 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 used to chang

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 addre

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: > > > > > It produces a 302 status code > > So I tried > > > > > Finally I tried > > > > ALL produced 302 status codes .. has anyone figured this out - did > some searching without luc

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 AM

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 wrote: > > Hello all, > > I would like to check a string against a list of keywords and either null > the string or repla

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: 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 wrote: > > Or just use CFFormProtect @ http://cfformprotect.riaforge.com/ > > Has worked for

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 > Dat

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 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 any >> sizeable app.