RE: CFMX connector issues

2004-04-24 Thread Tim Blair
I've seen two cases resolved where this problem occurred, security was ok, the user could telnet to the port and connect.Those two were resolved by finding misconfigurations in one of the two host config files (/etc/hosts/, /etc/sysconfig/network). OK, you win.;)There was a

RE: web services under virtual hosts

2004-04-24 Thread Raymond Camden
Well shoot then. The alias defintely seems right as CFMs now work under url/tasktracker/*, of course it ends up being the same as url/. But I wonder now what the error is. It only seems to indicate that I'm using a returntype or something that CFMX can't find, the WS is truly very simple, it has

RE: ttools (or similar bug tracking systems)

2004-04-24 Thread Nando
Here's one to enter, Phil :) trying http://www.tracking-tools.com/ Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Error establishing socket. No buffer space available (maximum connections reached?): JVM_Bind The error occurred in

RE: CFMX connector issues

2004-04-24 Thread Steven Erat
Glad the connector issue worked out for you.As far as the 404s, I can't say I've seen that much.Maybe you could enable connector logging inside the JRun directive in httpd.conf.Then trace the requests just enough until you get a 404 like this before turning off logging.The connector logging is

Compatibility problem bet. Access and MSSQL

2004-04-24 Thread Claude Schneegans
Hi, I have this query which works well under Access, but generates a Incorrect syntax near ''. error under MSSQL. I'm not too familiar with MSSQL, can someone tell me what would be the equivalent for the line page2.dateMaj page1.dateMaj AS modif and possibly an alternative that would work in

RE: Combining two SQL columns as one

2004-04-24 Thread Philip Arnold
From: Philip Arnold ISNull(ISNull(CompanyName, ttoOfficeName), 'n/a') If CompanyName is null, then it will take ttoOfficeName If both are null, then it will give n/a as the result for the ORDER BY Another possible solution: Coalesce(CompanyName, ttoOfficeName, 'n/a') It works from

RE: Compatibility problem bet. Access and MSSQL

2004-04-24 Thread Philip Arnold
From: Claude Schneegans I'm not too familiar with MSSQL, can someone tell me what would be the equivalent for the line page2.dateMaj page1.dateMaj AS modif and possibly an alternative that would work in both cases? What's it meant to return? I presume you want to have it so that it

Re: Compatibility problem bet. Access and MSSQL

2004-04-24 Thread Claude Schneegans
Forget it, I managed to find how to use the DATEDIFF function. -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message]