Re: Daylight savings issue with now()

2007-03-15 Thread Jeff Congdon
You also have to install a windows patch, it's in windows update. Then verify your system time is correct. If your system time is correct, along with the timezone, you should only need to restart CF after you tell it the new JVM path. Don't forget the hotfix that comes along with the new JVM:

getTimeZoneInfo()?

2007-03-13 Thread Jeff Congdon
cfset foo = getTimeZoneInfo() cfdump var=#foo# struct isDSTon NO utcHourOffset 8 utcMinuteOffset 0 utcTotalOffset 28800 shouldn't that be 'no' be 'yes'? i see no cf hot fixes? am i missing something? all my servers (6.11) behave the same way. i hope i'm not missing something silly :)

Re: getTimeZoneInfo()?

2007-03-13 Thread Jeff Congdon
. -Jeff Paul Hastings wrote: Jeff Congdon wrote: shouldn't that be 'no' be 'yes'? i see no cf hot fixes? am i missing something? did you update your JDK according to adobe's instructions? is your server's tz actually one that is in DST? see http://www.adobe.com/go/d2ab4470

global error handling

2006-02-08 Thread Jeff Congdon
I have 5 www servers over a replicated network, each with the exact same CFMX config. All are running 6.11 with the same hotfixes (same version #, same OS, same JVM, same IIS). The error handler on 2-5 just stopped working. The error handler on 1 works as expected. There is no error in the

Re: global error handling

2006-02-08 Thread Jeff Congdon
I got it, CF simply made up my webroot. (thanks but I tried every kind of diff slash :)) Error,jrpp-4,02/08/06,17:41:22,,The filename, directory name, or volume label syntax is incorrect The specific sequence of files included or processed is: C:\CFusionMX\runtime\bin\ E:\Webdocs\error.cfm It

Re: global error handling

2006-02-08 Thread Jeff Congdon
it tried to catch an error. How very odd. -jc On 2/8/06, Jeff Congdon [EMAIL PROTECTED] wrote: I got it, CF simply made up my webroot. (thanks but I tried every kind of diff slash :)) Error,jrpp-4,02/08/06,17:41:22,,The filename, directory name, or volume label syntax is incorrect The specific

connetion reset by peer / proper JDBC settings

2005-12-01 Thread Jeff Congdon
This error is getting to the unbearable point, and I'm wondering if anybody has a solution. I have 4 CFMX servers, all 6.11, all running 3.5 jdbc drivers, connecting to a single sql server (2000) that is on their local network. Only one CF server returns this error, and it does it constantly.

Connection reset by peer: socket write error, 3.4 JDBC drivers

2005-09-21 Thread Jeff Congdon
Setup: CFMX 6.11, Windows 2003 Server, IIS, SQL Server 8 / SP3, Latest JDBC drivers from MM website (3.4) Error Message: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error First, I never saw this error until I updated the JDBC drivers

Re: DateTime problems

2005-09-21 Thread Jeff Congdon
This is hard to do without knowing what UKTodayDate is, but I'm going to guess it's now(). If it isn't, that might be your problem, and you should just use now()... You're adding 10 minutes from now, and asking for everything LESS THAN 10 minutes into the future... that means every record

Re: CFMX6.1 with KavaChart AlaCarte Applets

2005-08-25 Thread Jeff Congdon
I only use servlets with CFMX (both java, both talk to each other nicely, server processing goes quickly and is not dependent on client software package, and the resulting .png or .jpg images can be cached on the server). There's no registering classes, just dump your charts directory in

Re: CFEclipse 1.2

2005-08-15 Thread Jeff Congdon
You're not alone. Christian Cantrell wrote: For some reason, Eclipse isn't seeing that an update is available. I can just install 1.2 manually, but I just wanted to check to see if others were experiencing the same thing. Thanks, Christian -Original Message- From: Patrick Burm

Re: Query Problem - Brain Cloud

2005-07-28 Thread Jeff Congdon
Then you need a reference table of dates, so you can query what IS NOT there. You can hit this table like this: select date from datetable where date BETWEEN x AND y and date NOT IN (select distinct date from reservation where date between x AND y) right? -jc Barney Boisvert wrote:

Re: CFMX install help, IIS connectors hang

2005-07-28 Thread Jeff Congdon
, but didn't even know this thing existed so I hope that helps someone, somewhere, and they don't have to spend 6 hours installing MX like I did. -jc Jeff Congdon wrote: I'm at a loss here, as I've installed dozens of CFMX 6.1 servers, and have never seen this behavior. Brand new install

CFMX install help, IIS connectors hang

2005-07-27 Thread Jeff Congdon
I'm at a loss here, as I've installed dozens of CFMX 6.1 servers, and have never seen this behavior. Brand new install of win2003 server on a brand new server, install mx 6.1 (coldfusion-macr-win.exe) and it works fine until it launches the IIS connectors. IIS connectors just hang. They open

MX 6.11 and CFFILE difficulties, RENAME and DELETE

2005-07-14 Thread Jeff Congdon
I'm at a loss with some file handling difficulties on my setup (MX 6.11, IIS, win2k3 server) and am now looking for some advice. I'm converting a 'cf log parser' app that we've had running in cf5. It reads the log, parses, looks for certain events which it aggregates and inserts to a db,

Re: MX 6.11 and CFFILE difficulties, RENAME and DELETE

2005-07-14 Thread Jeff Congdon
parser to recognize the datestamps and to set a low tolerance for log size in CFAdmin - but this is just the way the app is written now so I'd like to get it to work as-is if at all possible) Thanks again, -Jeff Jeff Congdon wrote: I'm at a loss with some file handling difficulties on my

Re: reverse compliment a sequence

2005-06-14 Thread Jeff Congdon
the replace idea won't work. it will replace all 'a' with 'z', then replace all 'z' with 't' this leads to all 'a' being replaced with 't', not with all 'a' being replaced with 't'. without instantiating java... cfset newDNA = cfset iTo = len(dna) cfloop from=1 to=#iTo# index=i cfset

Re: reverse compliment a sequence

2005-06-14 Thread Jeff Congdon
have a dino-baby. M!ke -Original Message- From: Jeff Congdon [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 2:41 PM To: CF-Talk Subject: Re: reverse compliment a sequence the replace idea won't work. it will replace all 'a' with 'z', then replace all 'z' with 't' this leads

Re: reverse compliment a sequence

2005-06-14 Thread Jeff Congdon
Ben Doom wrote: Jeff Congdon wrote: The replace idea below will work as long as those temporary values don't exist anywhere in the original string, which seems a risky assumption. Not knowing the original values though, I can't speak for that. Since he's looking for a DNA sequence

Re: mx 6 licenses?

2005-06-13 Thread Jeff Congdon
CF7 is, in our opinion, too new to run on production. We're just now moving to 6.11 on these servers (from 5.x), after having run 6.x for a few years on our backend. I still find myself fighting, in the last 60 days, fatal errors on my 6.11 servers that that would have been disasterous if we

mx 6 licenses?

2005-06-10 Thread Jeff Congdon
Hey gang, I assume somebody in here knows the right place to go to buy MX 6? I can't find it as a listed product on MM's website, and we'd like to buy a few licenses. TIA, -Jeff -- Jeff Congdon ColdFusion Developer, Data Mining Specialist Headsprout www.headsprout.com EVERY CHILD A READER

Re: Two queries within CFMAIL

2005-05-06 Thread Jeff Congdon
Yes. By using cfloop query=(NAME) instead of cfoutput query(NAME) cfmail cfloop query=foo - loop content /cfloop cfloop query=bar - bar /cfloop /cfmail I've also grown fond of outputting my desired email OUTSIDE of the cfmail tag, using cfsavecontent to save it in a variable, then

Re: wtf are those advertising links in the text?

2005-04-20 Thread Jeff Congdon
Like this thread? Personally, I'll pay 5-10 a month just to move this thread to CF-community. -Jeff Dana wrote: I for one like the idea of paying to make certain threads go away. I can think of entire conversations about Martha Stewart and baseball that I'd pay to see disappear. The genius

Re: cfschedule and daylight savings bug

2005-04-08 Thread Jeff Congdon
, and even editing the time of the job, but none of these things worked. It seems my existing job would have run at t-1 hour until the next daylight savings, if I had not deleted it and recreated it. -Jeff Jeff Congdon wrote: After investigating some really strange behavior with my scheduled jobs

Re: Error Message No more data available to read. on CFMX 6

2005-04-05 Thread Jeff Congdon
If your CF server is located on a different server than your SQL server, uncheck Maintain Connections in CF admin/datasource setup/advanced settings In my experience, you get this error when you try to 'maintain connections' to a remote db. Your cf app makes a query, then you go to look at

cfschedule and daylight savings bug

2005-04-05 Thread Jeff Congdon
After investigating some really strange behavior with my scheduled jobs, I realized that all of my scheduled tasks are running t-1hour, and have been since Sunday morning. Fan-tas-tic. A few minutes ago I ran a test on the server in question. Server clock (it's central) reads 7:30 PM, now()

MX perfmon counters

2005-03-08 Thread Jeff Congdon
Hi list, In trying to track down a problem, I went to add the CFMX perfmon counters on 2 different servers - one a win2k server, the other a win2k3 server. In both cases, I can view the list of MX counters but the add box is greyed out - making it impossible for me to use them. Is there a

Re: MX perfmon counters

2005-03-08 Thread Jeff Congdon
Oh yes, the large checkbox that says enable performance monitoring, heh. I have now, and it works. Thanks! -Jeff Brook Davies wrote: Have you enabled the extended debugging in the cfadministrator debugging settings? At 12:04 PM 3/8/2005, you wrote: Hi list, In trying to track down a

Re: SQL Select statment query - kindly help

2005-02-17 Thread Jeff Congdon
You can use a sub-query for this, so that you limit your records by a factor unrelated to the actual record you're looking at... SELECT EventCode FROM job a INNER JOIN Event b ON b.job_id = a.job_id WHERE (b.EventCode = 100) AND (a.job_id = '1234567890') AND a.job_id NOT IN (select DISTINCT

Re: Preventing Malicious Sql without cfquery param

2005-02-02 Thread Jeff Congdon
to echo quite a few people don't play the game with a hacker, hackers are always half a step ahead and if they fall behind they will find a way to get ahead... Adam H On Tue, 01 Feb 2005 16:15:59 -0800, Jeff Congdon [EMAIL PROTECTED] wrote: which would say '(value);DROP * FROM tableName where 1

Re: Preventing Malicious Sql without cfquery param

2005-02-02 Thread Jeff Congdon
Indeed. I see myself beginning to get flogged over this, but I'm only trying to make this point: it's not that easy. Somebody said show me an example, and somebody else said here. I'm simply saying that the example is flawed, and I am CERTAINLY not saying don't worry about injection or

Re: Preventing Malicious Sql without cfquery param

2005-02-02 Thread Jeff Congdon
I did Dave, and it's a good summary, especially of the more advanced topics like extended procedures and activex integration. It (http://www.nextgenss.com/papers/advanced_sql_injection.pdf for those new to the thread) also serves as yet another reminder to never use the default error

Re: Preventing Malicious Sql without cfquery param

2005-02-01 Thread Jeff Congdon
which would say '(value);DROP * FROM tableName where 1 = 1' ... which would be harmless. at least by sql server, it would be treated as one long string to insert/update/whatever. -jc Michael T. Tangorre wrote: Strings are within single quotes. Can you tamper with '#url.emp_id#' if emp_id is

Re: Dynamic CF PDFs

2005-01-13 Thread Jeff Congdon
Micha Schopman wrote: HTMLDoc, sorry .. but that is stuff for the hobbyist. It is very limited, the quality is poor, and the stability is terrible. HTMLDOC is indeed limited. The quality, IMHO, is what you make of it (garbage in, garbage out). This is where my extra time with HTMLDOC

Re: Major PHP flaw??

2004-12-20 Thread Jeff Congdon
http://www.hardened-php.net/advisories/012004.txt all versions of 4 = 4.3.9 and all versions of 5 = 5.0.2 are vulnerable. I'd take these seriously, last time I saw a server I use (not mine though :)) owned it was b/c of a PHP buffer overflow. -jc Michael Greenberg wrote: No other info???

Re: In line Spell Checkers

2004-12-09 Thread Jeff Congdon
google for CFX_JSpellCheck -Jeff [EMAIL PROTECTED] wrote: I have an application where I need to spell check the contents of a text box any cheap (or free) widgets out there? sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt

Re: Query Errors

2004-12-09 Thread Jeff Congdon
Pounds go around variables, not dates. #12/1/2004# is asking coldfusion to resolve a variable named variables, and 12/1/2004 and that is an illegal variable name. To use a standard, regional, date use single quotes. I'm going to declare your date variable elsewhere just to make it readable:

Re: output listing problem

2004-11-09 Thread Jeff Congdon
Nov 2004 13:07:43 -0800, Jeff Congdon [EMAIL PROTECTED] wrote: sorry that should probably be ASC, not DESC, if you want it to go low-high -jc Jeff Congdon wrote: make your query like this: SELECT item, date, MIN(date) AS orderDate FROM yourtable WHERE itemID

Re: output listing problem

2004-11-04 Thread Jeff Congdon
make your query like this: SELECT item, date, MIN(date) AS orderDate FROM yourtable WHERE itemID = date_itemID GROUP BY item, date ORDER BY orderDate DESC, item, date -jc DRE wrote: Nobody has any thoughts? On Thu, 4 Nov 2004 08:14:30 -0800, DRE [EMAIL PROTECTED] wrote: Hi, I have a

Re: output listing problem

2004-11-04 Thread Jeff Congdon
sorry that should probably be ASC, not DESC, if you want it to go low-high -jc Jeff Congdon wrote: make your query like this: SELECT item, date, MIN(date) AS orderDate FROM yourtable WHERE itemID = date_itemID GROUP BY item, date ORDER BY orderDate DESC, item, date -jc DRE wrote: Nobody

cftransaction and the request scope

2004-11-04 Thread Jeff Congdon
MX 6.1 environment. For some applications, I do some datasource setup in the app.cfm to separate development and production environments, amongst other things. So my app.cfm has some code like this cfswitch expression=#server_name# cfcase value=server1 cfset REQUEST.thisDSN = devDS

Re: CFLOGOUT

2004-11-04 Thread Jeff Congdon
have they fixed the problem where if you write a cookie, and then cflocate, the cookie never gets written? If not, that's probably your problem. Try using a meta-refresh instead of a cflocation. -jc Phillip Perry wrote: Hi, I'm using the cflogout tag but I don't think the session was

Re: cflock

2004-10-19 Thread Jeff Congdon
You don't need one in the current directory, you just need to make sure the one in the previous directory has that cfapplication tag. If there's no app.cfm in the current diretory, CF will automatically look in ../, ../.../, etc until it finds one. Generally you want 1 app.cfm, and it should

Re: Upgraded to CFMX6.1 -spell check broke

2004-10-05 Thread Jeff Congdon
JSpellCheck works on MX, i've used it on 6 and 6.1.It looks like all my files are in c:\CFX_JSpellCheck, and then the cfx is pointed to that. -Jeff Mike Kear wrote: We updgraded one of our dev servers this week, and everything seems to have gone smoothly, nary an issue.Nice. Except one CFX

strange jdbc/sql server error - JVM_bind - No buffer space available

2004-09-08 Thread Jeff Congdon
[Macromedia][SQLServer JDBC Driver]Error establishing socket. No buffer space available (maximum connections reached?): JVM_Bind I've never seen this error, and it seems to have suddenly appeared on 2 servers which share the same app and a loadbalancer in common.Not only did this bring both

Re: strange jdbc/sql server error - JVM_bind - No buffer space a vailable

2004-09-08 Thread Jeff Congdon
Dave Watts wrote: [Macromedia][SQLServer JDBC Driver]Error establishing socket.No buffer space available (maximum connections reached?): JVM_Bind I restarted the CF ODBC services on both servers, and the error went away.I have unlimited connections on my sql server, and the sql server

Re: strange jdbc/sql server error - JVM_bind - No buffer space a vailable

2004-09-08 Thread Jeff Congdon
Let's start this fresh.Fully patched and service pack'd SQL server 2000, shared by many other CF servers and apps on the same network that have no problem whatsoever. MX6.1, using the latest MM provided datadirect JDBC drivers.After a month of working without a single peep (server was

Re: strange jdbc/sql server error - JVM_bind - No buffer space a vailable

2004-09-08 Thread Jeff Congdon
Dave Watts wrote: Now I can restart CF application service, go to CFadmin, hit verify all datasources four times, and get this error on the 4th time, and only on ONE datasource (i have another datasource on the same server that doesn't seem bothered): []java.sql.SQLException:

Re: SQL questions

2004-08-26 Thread Jeff Congdon
1. Try LCASE(lname) in the select statement 2. LIKE '%#people#%' -jc Daniel Kessler wrote: I have two questions. 1 - I have a list that I sort by last name (ORDER BY lname ASC).I don't have control over the data entry and noticed today that A-Z (uppercase) is before a-z (lowercase).Is

Re: A bit confused with links between tables

2004-08-19 Thread Jeff Congdon
i'm guessing that the primary key of your clients table is clientID... change it accordingly: CFQUERY name=get_tasks datasource=taskomatic SELECT T.taskID, T.taskname, T.status, T.project, P.projectsID, P.projectname, P.client, C.clientname FROM tasks T INNER JOIN projects P ON T.project =

Re: CFMX affected by Win XP SP2?

2004-08-16 Thread Jeff Congdon
The actual list is here: http://support.microsoft.com/default.aspx?kbid=842242 Program: ColdFusion MX Server Edition 6 Vendor: Macromedia Ports: TCP (by default, 8500) Default exception: See the documentation Notes: Needed to allow remote access as Web server -jc Dave Watts wrote: Other

Re: JRun Process Hangs on Queries with Large Number of Columns

2004-08-05 Thread Jeff Congdon
Do you have the new datadirect jdbc drivers, or the hotfix for the original jdbc drivers?One of the known problems with the drivers that shipped with 6.1 was 100% CPU uitilization on certain conditions if not, get the fixed drivers off of hte MM site (they're listed with the hotfixes) -jc

Re: Off topic SQL question from a novice

2004-08-04 Thread Jeff Congdon
i'm guessing your reivew table schema, so change the B.* names accordingly: select a.HikeName, a.HikeID, a.HikeDate, a.HikeStars, COUNT(b.hikeid) from Hike A INNER JOIN HikeReview B ON A.hikid = B.hikeID group by a.hikename, a.hikeid, a.hikedate, a.hikestars order by HikeDate Desc John Munyan

Re: remote restart cfmx service

2004-08-04 Thread Jeff Congdon
In fact, I tried this once -- put together a .bat with the stop and start commands and cfexecuted it... It killed CF, but wouldn't complete the .bat to bring it back up, as you would expect -jc Jochem van Dieten wrote: Tony Weeg wrote: jochem, why the question about parent and not child

Re: CFMX 6.1 - Hotfixes - Best Practice

2004-08-02 Thread Jeff Congdon
Yes, do not simply download and install all of them.I used the relevant ones only for 3 6.1 servers that I built last week (using apps that have been running stable since 6.1 was released), all died within 3 days and needed to be rebuilt due to JRUN issues.I skipped the hotfixes on the 2nd

cfftp lastmodified date is wrong by a month and 12 hours

2004-02-02 Thread Jeff Congdon
I'm new to CFFTP, i'm using it now b/c CFDIRECTORY/CFFILE is all but useless in CFMX unless you have 3 hours for the end user to wait. Unfortunately, CFFTP is adding exactly 1 month and 12 hours to every lastModified date from the win2k based ftp server.The FTP server IS in a different time zone