Re: Daylight savings issue with now()

[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:
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=kb400232

Full adobe info on the DST change is here:
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=d2ab4470

HTH,
-Jeff

On 3/14/07, Jason Rogoz  wrote:
>
> Hey Chris
>
> Did you have to reboot the server or IIS? I installed the new version but
> it didn't seem to fix the issue. Instead we just changed the time zone of
> the machine.
>
> Jason
>
> -Original Message-
> From: Christopher Jordan
> Sent: Wednesday, March 14, 2007 4:02 PM
> To: CF-Talk
> Subject: Re: Daylight savings issue with now()
>
>
> I had the same problem yesterday. I installed version 1.4.2_11 of the
> JVM and it fixed the problem.
>
> download it here
> . This comes
> with netbeans but you can uninstall that after. You could also install
> 1.4.2_13, but I hear that Adobe won't support that version.
>
> Cheers mate!
> Chris
>
> Jason Rogoz wrote:
> > Hello
> >
> > I have a couple applications that rely on the now() function and because
> of the daylight savings time the function is not displaying the correct
> time.  The server in question is running CF 6.1 on a windows server 2003
> box.  Is this an issue with the cf server or the windows box
> >
> > Thanks
> >
> >
> > Jason Rogoz
> > Programmer / Analyst
> >
> > Zoom Communications Inc.
> > Calgary, Alberta, Canada
> >
> > Office: (403) 229-2511
> > Fax: (403) 229-4211
> > Toll Free: 1-866-698-8932
> >
> > www.zoomcom.ca 
> >
> >
> >
> >
>
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272743
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: getTimeZoneInfo()?

[Jeff Congdon]

Sorry, was a little terse due to it being the end of the day, and this being
the nth thing that broke today.  My time zone should be PDT, my server was
showing proper time, it is the jdk instructions from adobe that I was,
indeed, missing.

Thanks a lot for the info, will try this out tomorrow.

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

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272632
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

getTimeZoneInfo()?

[Jeff Congdon]

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 :)

thanks,
-Jeff


~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272615
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: global error handling

[Jeff Congdon]

I would like to add, this makes no sense at all.  Even after I watched it
work.

If CF thought the webroot was "C:\CFusionMX\runtime\bin\ E:\Webdocs\", how
was it serving webpages?  And all of these servers were serving pages just
fine, I watched it this morning.  This was only an issue when 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 sequence of files included or
> processed is: C:\CFusionMX\runtime\bin\ E:\Webdocs\error.cfm "
>
> It thought the webroot was C:\CFusionMX\runtime\bin\
> E:\Webdocs\error.cfm it was set to e:\webdocs
>
> We found this by changing error handling on our working server to use a
> non-existant page.  We got the same error, but it would read:
> "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: E:\Webdocs\x.cfm "
>
> Noticing this difference, we... on a whim... deleted the mapping for "/"
> on a broken server, and rebuilt it (exactly the same)
>
> Now everything works.
>
> Amazing.  And frightening.  All at the same time.
>
> -jc
>
>
>
>
> On 2/8/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
> >
> > > handling failing (global error handler set to /error.cfm):
> >
> > > This makes no sense at all.  E:\webdocs\error.cfm is the path on
> > every
> >
> > Note the slashes (perhaps error handler wants to see "\error.cfm")I
> > can't
> > recall which way CF Admin wants itbut it stuck out while reading
> > over your
> > issue so I'm chiming in ;-)
> >
> > Cheers
> >
> > Bryan Stevenson B.Comm.
> > VP & Director of E-Commerce Development
> > Electric Edge Systems Group Inc.
> > phone: 250.480.0642
> > fax: 250.480.1264
> > cell: 250.920.8830
> > e-mail: [EMAIL PROTECTED]
> > web: www.electricedgesystems.com
> >
> >
> > 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231697
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: global error handling

[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 thought the webroot was C:\CFusionMX\runtime\bin\
E:\Webdocs\error.cfm it was set to e:\webdocs

We found this by changing error handling on our working server to use a
non-existant page.  We got the same error, but it would read:
"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: E:\Webdocs\x.cfm "

Noticing this difference, we... on a whim... deleted the mapping for "/"  on
a broken server, and rebuilt it (exactly the same)

Now everything works.

Amazing.  And frightening.  All at the same time.

-jc




On 2/8/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
>
> > handling failing (global error handler set to /error.cfm):
>
> > This makes no sense at all.  E:\webdocs\error.cfm is the path on
> every
>
> Note the slashes (perhaps error handler wants to see "\error.cfm")I
> can't
> recall which way CF Admin wants itbut it stuck out while reading over
> your
> issue so I'm chiming in ;-)
>
> Cheers
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> phone: 250.480.0642
> fax: 250.480.1264
> cell: 250.920.8830
> e-mail: [EMAIL PROTECTED]
> web: www.electricedgesystems.com
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231695
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

global error handling

[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 error handler, 1-5 all have the same file, located
in the same place, with the same app.cfm.

I verified this by replacing the error file with one that said "error!" and
nothing else, it still does not trigger.

The logs on 2-5 all have this with each error, i imagine this is the error
handling failing (global error handler set to /error.cfm):

"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 "
java.io.IOException: The filename, directory name, or volume label syntax is
incorrect
at java.io.WinNTFileSystem.canonicalize0(Native Method)
at java.io.Win32FileSystem.canonicalize(Win32FileSystem.java:333)
at java.io.File.getCanonicalPath(File.java:513)
at coldfusion.jsp.JRunTagLibraryInfo.lookupTLI(JRunTagLibraryInfo.java
:110)
at coldfusion.jsp.JRunTagLibraryInfo.lookupTLI(JRunTagLibraryInfo.java
:104)


This makes no sense at all.  E:\webdocs\error.cfm is the path on every
server.  The path exists on every server.  The file exists in that path.
All the file does is say "error!".  Yet it refuses to trigger.

Help?  Please?  Thanks :P

-jc


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231692
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

connetion reset by peer / proper JDBC settings

[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.  This
happened with 3.4, 3.3, etc as well, but at some point the error message
changed from 'reset by peer' to this:

Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]A problem
occurred when attempting to contact the server (Server returned: Connection
reset). Please ensure that the server parameters passed to the driver are
correct and that the server is running. Also ensure that the maximum number
of connections have not been exceeded for this server.
The error occurred on line 19.

To give you an idea what I mean by "unbearable", my error inbox has over 100
of these since last night at 10pm.  This server is 95% used for scheduled
'data crunching' jobs, 90% of these jobs didn't run last night b/c of this
error.  One job that runs every 10 minutes to check an inbox failed every
single time it ran between 11pm and 12pm, as far as I can tell, each time
with this error.  In manually being on the server this morning, I'd say 50%
of my attempts to load a page ended in this error.

I have 3 other CFMX servers, all with the same drivers, on the same network,
connecting to this same DB.  No other CF servers return this error, so
obviously it has not exceeded connections despite the error messages
insistance otherwise.  I just checked the DB activity after receiving
another error right now, there was not a single login under the credentials
at the time.  There were 3 non-system logins.

I have tried maintaining connections and not maintaining connections.  I
have tried using the same DB login that all other cf servers use, and I have
tried using it's own dedicated login.  I have tried increasing timeout, and
decreasing timeout.   None of these things seem to have a significant
impact.

I can't go on like this.  I have to wake up at 1am every morning to see if
CF feels like connecting to the database that night, b/c it can't be trusted
to do it on its own in a scheduled task.  I need help :)

Is there a specific JDBC setting / setup that I can make to... I don't
know... make the drivers actually retrieve data from the database?  This CF
server is a bit different in purpose from my other cf servers.  my other
servers are meant to handle quick-loading user requests, whereas this server
is meant to handle slow-loading data crunching jobs.  The typical job will
run 5 seconds to a minute, but others will stretch upwards of 30-40
minutes.  While this morning is an extreme example of this error, it is rare
that a morning goes by without at least 1 job failing as a result of this
error.

TIA for any suggestions,

-Jeff


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225880
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: DateTime problems

[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 ever will be 
triggered by this... Don't you want to subtract 10 minutes from now, and 
ask for records greater than that?

if now is "9/20/2005 15:28:00", you're saying "give me all records 
before 9/20/2005 15:38:00", and you want to say "give me all records 
created after 9/20/2005 15:18:00", right?

currentDate > #DateAdd('n', -10, now())#


HTH,
-Jeff

Saturday (Stuart Kidd) wrote:

>Hi,
>
>I'm inserting some user comments into a database.  When done, they  
>insert articleID, ipAddress and commentDate (the date when they were  
>submitted).
>
>Before a comment gets added i check the database to see whether there  
>already exists a comment from the same IP Address in the last 10  
>minutes... but unfortunately I can't seem to work out the actual  
>WHERE statement.
>
>  
>SELECT articleID, ipAddress, commentDate
>FROM tbl_020publicComments
>WHERE articleID = #URL.ID# AND ipAddress = '#cgi.REMOTE_ADDR#' AND  
>commentDate < #DateAdd('n', 10, UKTodayDate)#
>  
>
>Can anyone help me out?
>
>Thanks,
>
>Saturday
>
>ps: i've already played around with  but this only persists  
>in a browser, but some people (like most of us) have more than one  
>browser.
>
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218892
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

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

[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 to 3.4 
last week.  The job that is failing with this error message was 
succeeding for months before the driver upgrade.  With that in mind, the 
job runs a single query against a db, then queries another database for 
20-40 minutes, then returns to the FIRST db and runs another query.  
Every single time, if the first and last queries are seperated by more 
than 20 minutes, that second query will fail with the 'socket write error'.

I can reproduce this error every time, outside of my specific code, with 
a very simple waiting mechanism.  datasource and table names have been 
changed to protect the innocent.

trying query 1...

SELECT MIN(datestamp) FROM TABLENAME



  
pausing for 5 minutes, beginning at #timeFormat(now(),"HH:mm")#...
  
  
  
  
  waking up...

trying last query...



SELECT MIN(datestamp) FROM TABLENAME

 



OK

If I were to run a query on the same datasource inside of that wait 
loop, thereby hitting the DB every 5 minutes, I would not get the 
'socket write' error

I assumed this had something to do with timeout values or maintaining 
connections, I seem to be wrong on both accounts.  I tried changing 
timeout values on the drivers to 5, 20 and 60 minutes, each time trying 
once while 'maintain connections' was checked and once with it unchecked.

Is there any way to make these new drivers actually run this second 
query?  Is there a specific timeout value that would make the connection 
actually timeout and re-establish itself or NOT timeout... instead of 
timing out and then trying to use the timed out connection?  Or am I on 
the wrong path with timeout values?

Any advice would be fantastic.  TIA,
-Jeff



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218837
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFMX6.1 with KavaChart AlaCarte Applets

[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 [cfroot]\lib, mine is named javachart (can't remember if it 
was kavachart and I renamed it), so you just call 
javachart.servlet.twinAxisStackBarLineApp (for example).

   
  
  tmp = this.chart.setProperty("width", 800);
 //... etc
 

If you want to make it even easier, throw all your default settings into 
a graphs.cfc,  make the dynamic settings into arguments, and have the 
cfc make the object call and setProperty calls.

Pros?  Quick, flexible, a large library of pre-made classes and graph 
types, server side, outputs to PNG, expandable, works flawlessly with 
CFMX - install is non-existant, I never get errors from my charts once 
they work.

Cons?  A large number of charts, but they're not always well documented 
b/c I'd imagine they were all written by different people.  For example, 
you can spend a good amount of time discovering whether *this* dualAxis 
graph that you've never used uses "barAxis" and "auxAxis", or "yAxis" 
and "auxAxis", or "barAxis" and "yAxis", even though the documentation 
says all graphs should behave a certain way.  This becomes negligible 
after you familiarize yourself with the various types - I find myself 
using 3 or 4 for 95% of my charts, and after using kavachart for years 
now I know exactly how they all behave.

HTH,
-Jeff


Michael Carluen (michaelc) wrote:

>Anyone have general pros/cons comments, tips, suggestions, problems,
>etc.. on using KavaChart applets on CFMX?  Many thanks!!
>
>
>

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216377
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFEclipse 1.2

[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 [mailto:[EMAIL PROTECTED] 
>>Sent: Monday, August 15, 2005 11:20 AM
>>To: CF-Talk
>>Subject: Re: CFEclipse 1.2
>>
>>http://www.cfeclipse.org/go/project/downloads
>>
>>You can also use the eclipse update feature, register a 
>>remote site using http://www.cfeclipse.org/update
>>
>>
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215020
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFMX install help, IIS connectors hang

[Jeff Congdon]

The answer:

"Supermicro servers come with a utility that monitors the hardware 
status  (and sends alerts via SNMP).  That utility was using some ports 
that prevented the CF installer/Java from connecting into IIS to 
configure it."

I thought firewall, and checked tcp/ip filtering on the server, 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 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 up a cmd prompt, and the cmd prompt 
>never closes, and the install never finishes (i let it go 45 minutes 
>once).  The only way I can get out of the install at this point is to 
>reboot the server, cancelling will also hang.
>
>The MM advice I could find said something like 'set up a self contained 
>server then manually configure IIS', so I do that.
>
>GUI/Web server configuraiton tool returns this before it even launches 
>(helpful tool):  The procedure entry point [EMAIL PROTECTED] 
>could not be located in the dynamic link library jvm.dll.
>Manual/cmd prompt returns this:
>Created file C:\CFusionMX\runtime\lib\wsconfig\jrunwin32.dll
>Found JRun server default at 127.0.0.1:2901
>
>
>at  it just sits there forever, returning nothing.
>
>I'm at a loss as to where to go next, can somebody please help?
>
>Thanks,
>-Jeff
>
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213245
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Query Problem - Brain Cloud

[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:

>here's a timeline in days (if you don't have fixed-width font, C&P
>into something that does):
>
>123456789
>xxx   reservation 1
>  xxx reservation 2
>x reservation 3
>  q   desired range
>
>there are two possible days available: 4 and 6.  That's the problem
>he's trying to solve.
>
>cheers,
>barneyb
>
>On 7/28/05, Jennifer Larkin <[EMAIL PROTECTED]> wrote:
>  
>
>>Something like this wouldn't handle them
>>where arrivaldate >= #arrivaldate# and departuredate <= #departuredate#
>>
>>?
>>
>>Maybe I don't understand what you are trying to do?
>>
>>
>>
>
>  
>


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213229
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

CFMX install help, IIS connectors hang

[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 up a cmd prompt, and the cmd prompt 
never closes, and the install never finishes (i let it go 45 minutes 
once).  The only way I can get out of the install at this point is to 
reboot the server, cancelling will also hang.

The MM advice I could find said something like 'set up a self contained 
server then manually configure IIS', so I do that.

GUI/Web server configuraiton tool returns this before it even launches 
(helpful tool):  The procedure entry point [EMAIL PROTECTED] 
could not be located in teh dynamic link library jvm.dll.
Manual/cmd prompt returns this:
Created file C:\CFusionMX\runtime\lib\wsconfig\jrunwin32.dll
Found JRun server default at 127.0.0.1:2901


at  it just sits there forever, returning nothing.

I'm at a loss as to where to go next, can somebody please help?

Thanks,
-Jeff


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213056
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: MX 6.11 and CFFILE difficulties, RENAME and DELETE

[Jeff Congdon]

Ah, I get it now.  I'm trying to move application.log and server.log, 
and if you try to rename those in file explorer (even as administrator) 
you get the "Cannot rename application: It is being used by another 
person or program".

Is there a way to manually truncate these logs WITHOUT restarting the 
services?  Or do we have to refactor the whole way we parse logs to deal 
with these locked files?

All I want to do is archive the log (which i already can do) and 
truncate the existing application.log/session.log (which i can't).

(I realize there are other ways to do this - like to train my 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 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, then renames the log file.
>
>Everything works up until the rename function, where the real fun begins.
>
>destination="\\#currentServer#\#logdir#\#log#.#yesterday_FileExt#">
>
>i know all of these variables resolve (and resolve properly), yet I get 
>this error:  FWIW, i've tried it with the nameconflict = "overwrite" 
>attribute as well, and get the same error.
>
>Attribute validation error for tag CFFILE.
>The value of the attribute source, which is currently 
>"\\www1\logs\application.log", is invalid.
>
>It's not invalid though, clearly.  The path works in other CFFILE tags 
>in the same page, and works on the server itself through windows file 
>explorer.  I've read that this error comes up when you have *other* 
>things wrong with the tag and have action="rename",  but I'm very 
>confident that all variables resolve properly and all paths exist.
>
>So I gave up on rename, and decided to copy and then delete the log.  
>Copy works FINE with the exact same parameters:
>
>destination="\\#currentServer#\#logdir#\#log#.#yesterday_FileExt#">
>
>
>Here the file copies just fine, but doesn't delete.  So i try to catch 
>the delete error...
>  
>
>
>  
> - CANNOT DELETE FILE  
>\\#currentServer#\#logDir#\#log#.log- 
> 
>
>
>Still the file copies, but doesn't delete.  But there's no error?!?!  
>the catch block never triggers, and the page maintains that it executed 
>properly, despite the fact that the file is never deleted.
>
>So... does anybody know what's going on?
>
>Thanks,
>-Jeff
>
>
>
>
>
>

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211918
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

MX 6.11 and CFFILE difficulties, RENAME and DELETE

[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, then renames the log file.

Everything works up until the rename function, where the real fun begins.



i know all of these variables resolve (and resolve properly), yet I get 
this error:  FWIW, i've tried it with the nameconflict = "overwrite" 
attribute as well, and get the same error.

Attribute validation error for tag CFFILE.
The value of the attribute source, which is currently 
"\\www1\logs\application.log", is invalid.

It's not invalid though, clearly.  The path works in other CFFILE tags 
in the same page, and works on the server itself through windows file 
explorer.  I've read that this error comes up when you have *other* 
things wrong with the tag and have action="rename",  but I'm very 
confident that all variables resolve properly and all paths exist.

So I gave up on rename, and decided to copy and then delete the log.  
Copy works FINE with the exact same parameters:




Here the file copies just fine, but doesn't delete.  So i try to catch 
the delete error...
  


  
 - CANNOT DELETE FILE  
\\#currentServer#\#logDir#\#log#.log- 
 


Still the file copies, but doesn't delete.  But there's no error?!?!  
the catch block never triggers, and the page maintains that it executed 
properly, despite the fact that the file is never deleted.

So... does anybody know what's going on?

Thanks,
-Jeff





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211898
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: reverse compliment a sequence

[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 compliment, we know that the only
>chars present will be a,t,g,c -- the four types in DNA.  Maybe not
>common knowledge, though.
>  
>
haha, I skipped that section of Ben Forta's Advanced CF book ;)   
Without that knowledge, my replies are toward a solution that will work 
with any string, and any replacable letters.

-Jeff



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209477
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: reverse compliment a sequence

[Jeff Congdon]

Yes sorry, I meant the replace idea outlined in the quoted section of my 
email ;)

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.

-Jeff

Dawson, Michael wrote:

>Replace() will work if you use *four* temporary values.
>
>Replace 'a' with '1'
>Replace 'c' with '2'
>Replace 'g' with '3'
>Replace 't' with '4'
>
>Then
>
>Replace '1' with 't'
>Replace '2' with 'g'
>Replace '3' with 'c'
>Replace '4' with 'a'
>
>Then, you mix in some love and you 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 to all 'a' being replaced with 't', not with all 'a' being
>replaced with 't'.
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209469
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: reverse compliment a sequence

[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...




 
 





  
  


Probably not the most efficient, but it should get you there.
-Jeff

Barney Boisvert wrote:

>I didn't say it was perfect. ;)  The replace stuff is a lot better, most 
>likely.
>
>I used a StringBuffer because string manipulation in Java is quite
>slow, and by using a buffer I'd circumvent the issue almost
>completely.
>
>cheers,
>barneyb
>
>On 6/14/05, Matthew Small <[EMAIL PROTECTED]> wrote:
>  
>
>>That seems like a lot of work.  Why instantiate java?
>>
>>
>>dna = "actg";
>>newdna = dna;
>>newdna = replace(newdna,"a","z");
>>newdna = replace(newdna,"t","a");
>>newdna = replace(newdna,"z","t");
>>newdna = replace(newdna,"c","z");
>>newdna = replace(newdna,"g","c");
>>newdna = replace(newdna,"z","g");
>>
>>
>>
>
>
>  
>



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209464
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: mx 6 licenses?

[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 had encountered 
them on our public WWW servers (see: client variables looping and 
crashing IIS every 7 days,  
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19590)  
So, flat out, I don't trust 7 yet for our public site, and my 
Bossman(tm) trusts it even less.  I'm even a bit worried about putting 
6.11 on these machines for the same reason, but to a much lesser extent.

The licensing issue turned out to be moot, b/c my cooworker found his 
old CF5 - MX upgrade licenses that he thought he had lost.  But what we 
would have done, we had decided, is buy MX7 licenses, put MX7 on our 
backend machines that were 'least necessary', then pushed those MX6 
licenses to the pub servers.

I'll begin playing with MX7 this summer though, as I'm really curious 
about some of the new functionality - namely CFDOCUMENT to pdf.

Thanks,
-Jeff

Jared Rypka-Hauer - CMG, LLC wrote:

>And, just to complicate matters... :)
>
>CFMX 7 is the same price as 6.1, so if you go with 7 you'll get an extra 
>upgrade cycle and a lot of benefits in terms of functionality and power.
>
>Unless you're looking to pick up 6.0 licenses on the cheap just because it's 
>a deprecated product, I'd highly recommend 7 just because of the deprecation 
>likelihood of 6.1 in future upgrade cycles.
>
>If you need licensed versions of a CF engine, look at BlueDragon Standard... 
>which happens to be quite speedy and powerful, but also happens to be free.
>
>Laterz,
>J
>
>On 6/10/05, James Holmes <[EMAIL PROTECTED]> wrote:
>  
>
>>Agreed - I stongly recommend against running CF 6.0.
>>
>>6.1 is the way to go.
>>
>>
>>
>
>
>
>  
>


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209330
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

mx 6 licenses?

[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
Headsprout's mission is to be a major force in helping eliminate illiteracy in 
young children in this country in this decade. Every hour of every day, in 
schools, learning centers, and homes across the country and around the world, 
children are learning to read with Headsprout.  



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209208
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Two queries within CFMAIL

[Jeff Congdon]

Yes.  By using  instead of 


 
   - loop content
 

   - bar



I've also grown fond of outputting my desired email OUTSIDE of the 
cfmail tag, using cfsavecontent to save it in a variable, then mailing 
the variable -  this is helpful when you're dealing with a lot of loops 
and queries and you find it difficult to fit it all inside of the cfmail 
restrictions.

so...

  
-your output
  
  
- your output 2
  

#foo#

HTH,
-Jeff

Richard Colman wrote:

>Is it possible to include results from two completely different queries
>within a CFMAIL command? How?
>
>Richard Colman
>Institute for Genomics and Bioinformatics
>949-824-1816, 701-5330
>[EMAIL PROTECTED]
>
>
>
>

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205924
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: wtf are those advertising links in the text?

[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 of this thought is that the
>people IN the conversations might want to pay even more to bring them
>back.
>
>muahahaa
>Dana
>
>On 4/20/05, Rick Faircloth <[EMAIL PROTECTED]> wrote:
>  
>
>>What about a 3-month trial period for new subscribers?
>>
>>That should give newcomers enough time to evaluate
>>their experience...
>>
>>That's the way it's done through-out the software
>>and publishing world...free trials...
>>
>>Rick
>>
>>
>>From: "Calvin Ward" <[EMAIL PROTECTED]>
>>Sent: Wednesday, April 20, 2005 5:21 PM
>>To: CF-Talk 
>>Subject: RE: wtf are those advertising links in the text?
>>
>>The downside of a fee is that then folks not familiar with HOF, and there
>>are quite a few, may never gain that understanding of the value.
>>
>>Just something to think about.
>>
>>- Calvin
>>
>>-Original Message-
>>From: Ian Skinner [mailto:[EMAIL PROTECTED]
>>Sent: Wednesday, April 20, 2005 11:48 AM
>>To: CF-Talk
>>Subject: RE: wtf are those advertising links in the text?
>>
>>I agree. I would support a small fee for membership. Of course I love free,
>>but I am willing to pay a reasonable fee for that which I feel is worth it.
>>HOF is definitely worth it.
>>
>>I would be very comfortable with a fee between $5 and $10 a month. If you
>>had the option of paying that annually by invoice or something, I suspect I
>>might even get my company to foot the bill for the help I receive on the
>>work I do here.
>>
>>It sure would be a lot less then what we are paying for our Oracle and
>>Crystal Report support.
>>
>>--
>>Ian Skinner
>>Web Programmer
>>BloodSource
>>www.BloodSource.org
>>Sacramento, CA
>>
>>"C code. C code run. Run code run. Please!"
>>- Cynthia Dunning
>>
>>..-Original Message-
>>..From: Rick Faircloth [mailto:[EMAIL PROTECTED]
>>..Sent: Wednesday, April 20, 2005 8:38 AM
>>..To: CF-Talk
>>..Subject: Re: wtf are those advertizing links in the text?
>>..
>>..Michael...
>>..
>>..Unless you're independently wealthy and can afford to support
>>..everyone who participates in this list and makes a living off of
>>..the information we gather here, I think you can feel justified in
>>..making money off of this list.
>>..
>>..I have contributed (a tiny amount, embarrassingly) to the support
>>..of the list, but certainly wouldn't mind paying a subscription fee
>>..of, say $10 per month, to participate. It's like having a panel of
>>..experts at your beck-and-call to answer questions about what
>>..I'm trying to accomplish.
>>..
>>..Imagine what Macromedia (or should I say, Adobe) would charge
>>..for the kind of support that this list provides, immediately, I might
>>..add...
>>..
>>.."A worker is worth his wages..." and you're definitely doing a good
>>..work, Michael...
>>..
>>..Rick
>>..
>>..
>>.. From: [EMAIL PROTECTED] (Michael Dinowitz)
>>..Sent: Wednesday, April 20, 2005 10:51 AM
>>..To: CF-Talk
>>..Subject: Re: wtf are those advertizing links in the text?
>>..
>>..I've been thinking of a small fee for the ability to 'turn off' ads and
>>..maybe some other added features. Problem is that I hate charging people
>>..and
>>..want to give all the features directly. I'll rethink it all.
>>..
>>..> Maybe Michael could introduce a subscription service with a small fee,
>>..so
>>..> people have the choice to turn of ads when they pay for it. It imho
>>..also
>>..> gives something back to Michael for his hard work.
>>..>
>>..> Micha.
>>..>
>>..> 
>>..>
>>..> From: Larry Lyons [mailto:[EMAIL PROTECTED]
>>..> Sent: Wed 4/20/2005 3:25 PM
>>..> To: CF-Talk
>>..> Subject: Re: wtf are those advertizing links in the text?
>>..>
>>..>
>>..>
>>..>>Why not just ignore them? Afaik people don't really send html email to
>>..>>the HOF lists, so if text in the message is linked in the archive,
>>..>>it's not because the author linked it and you can assume it's an
>>..>>advertisement (unless the text of the link is a url).
>>..>>
>>..>
>>..> Not all use the mailing list, quite a few people use the web interface
>>..> where the problem is.
>>..>
>>..> Its difficult to ignore the links in certain notes when in a paragraph
>>..> with CF mentioned multiple times times gets linked each and every
>>time,
>>..> and most of those links tend to be irrelevant. I have no problems with
>>..> targeted adverts on the side and top, but the highlight

Re: cfschedule and daylight savings bug

[Jeff Congdon]

Follow up:

Restarting services and rebooting the server did _not_ fix this.  It 
_did_ fix it for newly created jobs, but not for the existing "run 
daily" job.

No matter what I did, my existing daily job ran @ t-1 hour until I 
deleted the job and recreated it.  I tried restarting, recycling, 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, 
>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() in a cf date function returns 7:30 
>PM,  2 jobs were scheduled in advance... one for 6:30, the other for 
>7:30.  I got a result from the 6:30 one, not from the 7:30 one.
>
>CFMX 6.1 with updater, and a day of cleaning up after this that I'll 
>never get back.
>
>-Jeff
>
>
>
>
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202044
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

cfschedule and daylight savings bug

[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() in a cf date function returns 7:30 
PM,  2 jobs were scheduled in advance... one for 6:30, the other for 
7:30.  I got a result from the 6:30 one, not from the 7:30 one.

CFMX 6.1 with updater, and a day of cleaning up after this that I'll 
never get back.

-Jeff





~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201646
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

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

[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 something else, 10 minutes later you hit the db again with a new 
query and it returns this error.

HTH,
-Jeff.

Mosh Teitelbaum wrote:

>All:
>
>After moving a site to what will ultimately be its production server, I
>began receiving the following error message when trying to perform simple
>SELECT queries.  The queries did not throw this exception on development and
>test machines.  Sometimes they work and sometimes they throw this exception.
>
>Here's the exception diagnostics:
>   Error Executing Database Query. [Macromedia][SQLServer JDBC
>   Driver]No more data available to read. The error occurred
>   on line 24.
>
>Here's one of the queries:
>   SELECT Salt FROM Users WHERE Username = (param 1)
>
>   (param 1) = [type='IN', class='java.lang.String', value='Admin',
>   sqltype='CF_SQL_VARCHAR']
>
>
>It's running on a Windows 2000 server accessing MS SQL Server 2000, using
>CFMX 6.1.
>
>Has anyone ever seen this message before?  Any idea what the problem could
>be?
>
>TIA
>
>--
>Mosh Teitelbaum
>evoch, LLC
>Tel: (301) 942-5378
>Fax: (301) 933-3651
>Email: [EMAIL PROTECTED]
>WWW: http://www.evoch.com/
>
>
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201589
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: MX perfmon counters

[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 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 quick and easy solution to this?
>>
>>Thanks,
>>-Jeff
>>
>>
>>
>>
>>
>
>

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197911
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

MX perfmon counters

[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 quick and easy solution to this?

Thanks,
-Jeff


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197882
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SQL Select statment query - kindly help

[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 z.job_id FROM job z INNER JOIN event y ON z.job_id = 
y.job_id WHERE z.eventCode = 150 AND z.job_id = a.job_id)

so you're saying "give me any job where eventCode is 100 and jobID is N, 
but where the same job doesn't have an eventCode of 150 somewhere else"

is that what you're looking for?

-Jeff

cf coder wrote:

>Hello everybody, I have a question with regards to a sql select statement and 
>was hoping someone could help. I'm trying to query a table
>and trying to return row where a condition is true.
>
>To give you a better idea; picture a event table. A job can have muliple 
>events ex, an event to indicate the job is logged,
>an event to indicate the job is closed, an event to indicate the job is open 
>etc etc.
>
>Each job has a unique job id that is stored in the job table and the job_id 
>column is also present in the event table (foreign key I suppose)
>
>I'm trying to run a query that returns a recordset if it has an event present 
>in the event table but also if another event is missing from that table for a 
>particular job
>
>This will give you a better idea
>
>SELECT EventCode
>FROM job
>INNER JOIN Event ON Event.job_id = job.job_id
>WHERE (EventCode = 100) AND EventCode <> 150 AND (job_id = '1234567890')
>
>The above select statement returns a recordset if the event code 150 is 
>present in the event table. But I want it to
>only return a recordset if the table contains the eventcode 100 and does not 
>contain the eventcode 150.
>
>Can somebody show me how to do this please
>
>Best regards
>coder
>
>

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195246
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Preventing Malicious Sql without cfquery param

[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 messages or dump a sql error in a publicly viewable site.  
Most of these things are much more difficult, if not impossible, to 
accomplish if the error message doesn't provide validation to the attacker.

-Jeff

Dave Watts wrote:

>>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 
>>"don't use cfqueryparam"
>>
>>
>
>Did you read the nextgenss PDF link I posted? I'm pretty sure it has some
>examples for you.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>
>Fig Leaf Software provides the highest caliber vendor-authorized 
>instruction at our training centers in Washington DC, Atlanta, 
>Chicago, Baltimore, Northern Virginia, or on-site at your location. 
>Visit http://training.figleaf.com/ for more information!
>
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192838
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Preventing Malicious Sql without cfquery param

[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 "don't use cfqueryparam"

Best,
-jc

Jochem van Dieten wrote:

>Tyler Fitch wrote:
>  
>
>>Assume the big bad user put a ' after your (value).
>>
>>SELECT * FROM table1 WHERE field1 = 'some value';DELETE FROM table2
>>WHERE 1 = 1 --'
>>
>>
>
>And that won't work because CF automatically doubles all single 
>quotes. If it were that easy nobody needed to be convinced of the 
>need for cfqueryparam :-) You ned the combination of a string 
>delimiter and an escape character, and that is all I'm going to 
>say about it.
>
>Jochem
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192822
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Preventing Malicious Sql without cfquery param

[Jeff Congdon]

Adam, first off - I agree with you entirely, one should not be playing 
this game.  I don't post in an attempt to convince the original poster 
to not use queryparam, only as a response to what I saw to be an 
incorrect answer.

With that in mind, I still cannot get it to work.

"select * from (table) where (field) = '(value);DELETE from (table2) 
where 1 = 1 --'"

I tried this in both query analyzer and a CF page, and if the (value) 
field is a string it tries to find a value with the entire string  
specified.  If the (value) field is int, it fails trying to convert hate 
sql statement to int.  In neither case does this actually remove 
anything -- the embedded/injected sql is not being executed.

-jc

If the quoted value is an int, it will fail
Adam Haskell wrote:

>you missed the -- at the endthat comments anything trailing on
>that line...like the ending single quote. i am going 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 = 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 text??
>>>>
>>>>
>>>>
>>>>
>>>; DROP * FROM TableName WHERE 1=1 --
>>>
>>>
>>>
>>>
>>>
>>>  
>>>
>>
>>
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192816
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Preventing Malicious Sql without cfquery param

[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 text??
>>
>>
>
>; DROP * FROM TableName WHERE 1=1 --
>
>
>
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192691
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Dynamic CF PDFs

[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 
comes in, finding what translates properly from HTML and what doesn't, 
and much of it is trial and error.

Where you really lose me is stability...  Exactly what do you find 
unstable about it?  I've had HTMLDOC on multiple servers for years and 
have never noticed a single issue with it, or a single minute of server 
downtime that can be attributed to HTMLDOC.  I wish I could say the same 
about CFMX or those cursed dataDirect drivers...

-Jeff


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190330
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Major PHP flaw??

[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??? That seems extremely vague
>.
>-Original Message-
>From: Bryan Stevenson <[EMAIL PROTECTED]>
>Sent: Dec 20, 2004 3:46 PM
>To: CF-Talk 
>Subject: Re: Major PHP flaw??
>
>and the line monster ate ithere we go for try # 2:
>
>Security Notice:
>
>There has been an anouncement of a serious security problem with all current
>versions of PHP, a scripting language that you may be using on your site.
>
>PHP is used for many free forum, message board and link management scripts.
>A security flaw in PHP can allow the whole server to be compromised by 
>hackers
>who can then damage or deface all the sites on that server. This flaw is
>already being exploited, so time is of the escence in fixing this. This is 
>an
>unacceptable security risk to WeDoHosting.com Customers.
>
>If you are hosting your service on our Windows servers, you may ignore this
>notice since this is not applicable to Windows servers.
>
>If you are not using PHP on your website, then you may ignore this notice as
>well.
>
>Bryan Stevenson B.Comm.
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>phone: 250.480.0642
>fax: 250.480.1264
>cell: 250.920.8830
>e-mail: [EMAIL PROTECTED]
>web: www.electricedgesystems.com
>- Original Message - 
>From: "Bryan Stevenson" <[EMAIL PROTECTED]>
>To: "CF-Talk" 
>Sent: Monday, December 20, 2004 12:43 PM
>Subject: Major PHP flaw??
>
>
>  
>
>>Hey All,
>>
>>I just had this sent to me from a local ISP, but without any 
>>specificsanybody know anything?
>>
>>I must say it's nice to see that it's no effecting Windows Servers for a 
>>change ;-)
>>
>>
>>
>>
>>
>>
>
>
>
>

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188323
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Query Errors

[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:



WHERE tblItemPurchase.itemPurchaseDate >= '#queryPurchaseDate#'

OR

WHERE tblItemPurchase.itemPurchaseDate >= 
#createODBCDate(queryPurchaseDate)#

Good luck
-Jeff




Jason Smith wrote:

>While I have been rebuilding a cold fusion application that was using a 
>access database and was running dog slow now I have converted all the 
>databases over to SQL. Now since I'm not 100% sure on what the actual query 
>calls are if someone can direct me to a site that might list the difference 
>between access / SQL query calls I can get this working correctly.
>
>Since converting the databases over and not making any code changes this is 
>the first of what I assume will be many errors If anyone can point me in 
>the right direction I would greatly appreciate it.
>
>
>Error Executing Database Query.
>
>[Macromedia][SQLServer JDBC Driver][SQLServer]Line 3: Incorrect syntax near 
>'#'.
>
>The error occurred in C:\Inetpub\voremarketing\admin\adminMain.cfm: line 344
>
>342 :   SELECT 
>Sum(tblItemPurchase.itemPurchasePrice) AS totalMonthlyPurchase
>343 :   FROM tblItemPurchase
>344 :   WHERE 
>tblItemPurchase.itemPurchaseDate >= ###theMonth#/1/#theYear###
>345 :   
>346 :   
>
>SQLSELECT Sum(tblItemPurchase.itemPurchasePrice) AS 
>totalMonthlyPurchase FROM tblItemPurchase WHERE 
>tblItemPurchase.itemPurchaseDate >= #12/1/2004#
>DATASOURCE   vodb_remarketing
>VENDORERRORCODE   170
>SQLSTATE   HY000
>
>
>

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186913
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: In line Spell Checkers

[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 Place, Suite 100
>Chantilly, VA 20151
>Phone: (703) 471-8400
>Fax: (703) 834-5527
>
>
>
>
>
>

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186896
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: output listing problem

[Jeff Congdon]

Heh, except the ON in the subquery should be a WHERE, as pointed out by DRE

SELECT A.item, A.date, (select MIN(date) FROM yourTable B WHERE b.itemID = 
A.itemID) AS orderDate
  FROM yourTable A
ORDER BY orderDate, A.item, A.date


-Jeff


DRE wrote:

>Thanks to Jeff, the issue is resolved. For the curious, here is the solution.
>
>SELECT A.item, A.date, (select MIN(date) FROM yourTable B ON b.itemID
>= A.itemID) AS orderDate
>  FROM yourTable A
> ORDER BY orderDate, A.item, A.date
>
>DRE
>
>On Mon, 8 Nov 2004 10:45:39 -0800, DRE <[EMAIL PROTECTED]> wrote:
>  
>
>>Hi Jeff,
>>I see what you're trying to get at it but it seems not to work for me.
>>The query works but its not grouping properly in the output
>>statement.  Heres why I think that is.
>>
>>In the group by, you have to have all of the non aggregate fields
>>which include date.  Now date is the one that I need outside the
>>group.  That is, each item can have multiple dates. So, if date is in
>>the group, then it will create groups of every item/date combination.
>>Then the order by operates on the order date which is the same as
>>date.  So, effectively, there is no group.
>>
>>Does this make sense?  What have I missed?
>>
>>Thanks in advance.
>>DRE
>>
>>
>>
>>On Thu, 04 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 = 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 tricky little issue. Maybe someone can help me.
>>>>>>
>>>>>>I have a query that returns a grouped output.  There are items that
>>>>>>have mutiple dates and those dates have to be in order.
>>>>>>
>>>>>>Kinda like this.
>>>>>>
>>>>>>item z datea dateb datec
>>>>>>item r datee datef dateg
>>>>>>
>>>>>>so my query is like
>>>>>>select item, date
>>>>>>where itemid = date_itemid
>>>>>>order by itemid, date
>>>>>>
>>>>>>And the output looks like this
>>>>>>
>>>>>>#item#
>>>>>>
>>>>>>   #date#
>>>>>>
>>>>>>
>>>>>>
>>>>>>So, in order to keep the dates outputing right, I have to order them
>>>>>>after the item in the sql order by.
>>>>>>
>>>>>>Now my problem is this: I have to have the item with the earliest date
>>>>>>first.  However, to keep the cfoutput group working, I have to have
>>>>>>the date by as secondary to the item.
>>>>>>
>>>>>>I'm thinking I can do it by dumping it into an array of structures and
>>>>>>then sorting the array of structures or something like that or perhaps
>>>>>>writing a sp.  This page will be hit a lot so I'm trying to keep it
>>>>>>simple and fast.
>>>>>>
>>>>>>cfmx and sql2000.
>>>>>>
>>>>>>Any ideas???
>>>>>>
>>>>>>Thanks in advance.
>>>>>>DRE
>>>>>>
>>>>>>--
>>>>>>DRE
>>>>>>www.webmachineinc.com
>>>>>>www.theanticool.com
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>  
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>  
>>>
>
>

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183813
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFLOGOUT

[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 logged out. I
>managed to delete the cookie but the user can still get into the protected
>area after logout. This is the code for logout i'm using...
>
>
>
>
>
>
>http://localhost/applewood/mycommunity/index2.cfm";>
>
>
>I thought that the cflogout was supposed to get rid of the session. Can
>someone shed some light on this please?
>
>Thanks
>
>Phil
>
>
>
>
>

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183439
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

cftransaction and the request scope

[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


  
 
   
  
 
   


then in a page in the application, i have some transaction processing


  
   update foo set foo = bar where bar = foo
  
  
   update bar set bar = foo where foo = bar
  


sometimes, but not always,  i will get this error:
--
Data source devDS verification failed. The root cause was that: 
java.sql.SQLException: Datasource names for all the database tags within 
CFTRANSACTION must be the same.
The error occurred on line 232.
--

I was under the impression that REQUEST is a superset of the VARIABLES 
scope, and will always be thread safe and limited to the CURRENT REQUEST 
only.  While the error would imply that I am getting
different results for the REQUEST variable within the transaction, I 
have seen no evidence to back this up.  Specifically, whenever it does 
fail, it always gives the proper datasource in the error message, NEVER 
giving the "other", "improper" datasource... in this case it would be 
"productionDS".

I can work around this problem by setting variables.thisDSN = 
REQUEST.thisDSN at the top of the transaction, then just calling 
#thisDSN# in the datasource field...but what's the point?  I thought 
REQUEST was exactly the same as the VARIABLES scope, excpet REQUEST 
could be read by all parts of the thread (including custom tags).  Why 
then would it not, within the request, always define request.thisDSN 
exactly the same way?

Any ideas?  & TIA,

-Jeff


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183438
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: output listing problem

[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 has any thoughts?
>>
>>
>>On Thu, 4 Nov 2004 08:14:30 -0800, DRE <[EMAIL PROTECTED]> wrote:
>> 
>>
>>
>>
>>>Hi,
>>>I have a tricky little issue. Maybe someone can help me.
>>>
>>>I have a query that returns a grouped output.  There are items that
>>>have mutiple dates and those dates have to be in order.
>>>
>>>Kinda like this.
>>>
>>>item z datea dateb datec
>>>item r datee datef dateg
>>>
>>>so my query is like
>>>select item, date
>>>where itemid = date_itemid
>>>order by itemid, date
>>>
>>>And the output looks like this
>>>
>>> #item#
>>> 
>>>#date#
>>> 
>>>
>>>
>>>So, in order to keep the dates outputing right, I have to order them
>>>after the item in the sql order by.
>>>
>>>Now my problem is this: I have to have the item with the earliest date
>>>first.  However, to keep the cfoutput group working, I have to have
>>>the date by as secondary to the item.
>>>
>>>I'm thinking I can do it by dumping it into an array of structures and
>>>then sorting the array of structures or something like that or perhaps
>>>writing a sp.  This page will be hit a lot so I'm trying to keep it
>>>simple and fast.
>>>
>>>cfmx and sql2000.
>>>
>>>Any ideas???
>>>
>>>Thanks in advance.
>>>DRE
>>>
>>>--
>>>DRE
>>>www.webmachineinc.com
>>>www.theanticool.com
>>>
>>>   
>>>
>>>  
>>>
>> 
>>
>>
>>
>
>
>
>

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183413
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: output listing problem

[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 tricky little issue. Maybe someone can help me.
>>
>>I have a query that returns a grouped output.  There are items that
>>have mutiple dates and those dates have to be in order.
>>
>>Kinda like this.
>>
>>item z datea dateb datec
>>item r datee datef dateg
>>
>>so my query is like
>>select item, date
>>where itemid = date_itemid
>>order by itemid, date
>>
>>And the output looks like this
>>
>>  #item#
>>  
>> #date#
>>  
>>
>>
>>So, in order to keep the dates outputing right, I have to order them
>>after the item in the sql order by.
>>
>>Now my problem is this: I have to have the item with the earliest date
>>first.  However, to keep the cfoutput group working, I have to have
>>the date by as secondary to the item.
>>
>>I'm thinking I can do it by dumping it into an array of structures and
>>then sorting the array of structures or something like that or perhaps
>>writing a sp.  This page will be hit a lot so I'm trying to keep it
>>simple and fast.
>>
>>cfmx and sql2000.
>>
>>Any ideas???
>>
>>Thanks in advance.
>>DRE
>>
>>--
>>DRE
>>www.webmachineinc.com
>>www.theanticool.com
>>
>>
>>
>
>
>  
>



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183412
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cflock

[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 be in the root directory of the application.  Obviously 
there are cases where you'd want more than 1, but that's for another day.

-jc

Phillip Perry wrote:

>Great thanks. I made a new folder in the main directory so I hadn't thought
>about making an app.cfm inside it. I guess that shows how important a
>app.cfm file really is
>
>-Original Message-
>From: Barney Boisvert [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, October 19, 2004 12:52 PM
>To: CF-Talk
>Subject: Re: cflock
>
>
>You just need to add a CFAPPLICATION tag to you app, and you'll be set.
>
>cheers,
>barneyb
>
>On Tue, 19 Oct 2004 12:42:47 -0400, Phillip Perry
><[EMAIL PROTECTED]> wrote:
>  
>
>>Hi,
>>
>>First, thanks to James and everyone else for the solutions to the custom
>>tag. Now I'm into CFLOCK. I'm trying to make a custom tag for a banner
>>rotation and I am using cflock. But when I execute my code it gives this
>>error...
>>
>>Cannot lock APPLICATION scope.
>>CFLock cannot be used to lock the application or session shared scopes
>>without these scopes being established through the use of the
>>
>>
>CFApplication
>  
>
>>tag. If you want to use the session scope you need to enable session
>>management. Application and/or Session variables must also be enabled in
>>
>>
>the
>  
>
>>ColdFusion Administrator.
>>
>>I'm assuming I have to fiddle with the admin settings, but what exactly am
>>
>>
>I
>  
>
>>looking for..or is it even an admin problem in the first place?
>>
>>Thanks
>>
>>Phil
>>
>>
>>
>>
>
>
>
>

~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181892
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Upgraded to CFMX6.1 -spell check broke

[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 tag broke.  It is apparently registered correctly as a
> java tag in the CFAdministrator, yet when it's called we get the
> message:
> [quote]
> Error processing CFX custom tag "CFX_JSpellCheck".  
> The CFX custom tag "CFX_JSpellCheck" was not found in the custom tag 
> database.
> [/quote]
>
> I'm assuming it's either because we haven't put the JSpellCheck files
> in the right place or that the CFX tag that worked in CF5.0 doesnt
> work in CFX and we have to get another version from CFDEV.com.
>
> Does anyone know?    Am I right in that the CFX tag and its associated
> files have to go under the CFX directory not the CustomTags directory?
> -- 
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> AFP Webworks
> http://afpwebworks.com
> .com,.net,.org domains from AUD$20/Year
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

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

[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: [Macromedia][SQLServer JDBC
> > Driver]Error establishing socket. Address already in use:
> > connect The root cause was that: java.sql.SQLException:
> > [Macromedia][SQLServer JDBC Driver]Error establishing socket.
> > Address already in use: connect
>
> Are you using named SQL Server instances, and storing this database in a
> separate instance? That might explain this error message. The fix in that
> case would be to run the SQL Server Network Utility and specify a 
> different
> socket for that instance.
>
No, we only have a single sql server instance

Thanks,
Jeff
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

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

[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 migrated a month ago, 
the same app worked for years before this), today any query to one of 
the datasources returns this:
--
[Macromedia][SQLServer JDBC Driver]Error establishing socket.  No buffer 
space available (maximum connections reached?): JVM_Bind
--

There are 3 datasources on the machine, 2 to the same server, and only 1 
returns this error.  So I restart CF services, but after the 4th 
connection to the datasource (but not to other datasource on the exact 
same sql server), I get this:
--
[]java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error 
establishing socket. Address already in use: connect
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer 
JDBC Driver]Error establishing socket. Address already in use: connect
--

I repeat this many times to make sure it's not coincidental.  On a 
suggestion, I set the datasource to limit connections to 3 (a 
semi-abitrary number based on the connection failing at 4).  The 
datasource won't let me do this, instantly returning the original 
JVM_Bind error.  Even if I restart CF services, any connection to that 
datasource returns the JVM_bind error.  But now we have something new.  
One of the _other_ datasources on the machine, that connects to a 
different sql server on a different machine, now returns the JVM_bind 
error as well.   Fascinated in a car-crash sort of way,  I throw my 
hands up in the air and reboot the server.

The server comes back up, and now it all works.

The confidence I now have in this (production) server is overwhelming.  
While it seems to work for now, I'm sure I havne't seen the last of this 
error so if there's any insight into these errors, it will be 
greatly appreciated.

-Jeff
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

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

[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 is used by 1/2 a dozen other CF
> > 6.1 servers and apps on the network, none of which displayed
> > this problem.
>
> If you're using the JDBC driver, that doesn't use the ODBC services at 
> all,
> so I suspect your observation is coincidental.

I suspect you're right, as I've since gotten to reproducing the JDBC 
failure and those services have no effect.  IT's the application server 
that eliminates the error, but only temporarily.

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: [Macromedia][SQLServer JDBC Driver]Error 
establishing socket. Address already in use: connect
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer 
JDBC Driver]Error establishing socket. Address already in use: connect

> > I just checked the datasource settings to make sure
> > connections aren't limited (They're not), but clicking "OK"  
> > I got the same error again just trying to verify the
> > datasource?  Ack.  Has anybody seen this?  Any ideas?  Thanks
> > muchly in advance
>
> I vaguely recall hearing about this before, but I don't really 
> remember the
> context or solution. However, based on the error message, I would 
> recommend
> that you cap the number of connections. You might also look to see whether
> you're running the latest SQL Server service pack.

I'll take a look at the sql server SP state,  try capping on the CF end, 
and keep googling...   Thanks Dave,

-Jeff
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

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

[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 servers down whenever they attempted to make a DB 
connection, but it also seems to have somehow kludged either mail 
handling or my global error handler... as both servers would show my 
error handler, but neither sent the email with error details that's 
specified in the error handler... and that's a great scenario, to lose 
both loadbalanced servers and their ability to tell you that they're 
down. sigh.

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 
is used by 1/2 a dozen other CF 6.1 servers and apps on the network, 
none of which displayed this problem. 

I just checked the datasource settings to make sure connections aren't 
limited (They're not), but clicking "OK"  I got the same error again 
just trying to verify the datasource?  Ack.  Has anybody seen this?  Any 
ideas?  Thanks muchly in advance

-Jeff

(CF 6.1 with the last MM Provided datadirect drivers, win 2000, IIS, 
mssql 2000)
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: SQL questions

[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 there a way to get them to
> sort together (Aneka, botha,Sebrook, etc.)?
>
> 2 - I have a DEPARTMENT column which lists multiple departments. As a
> temporary kludge, I list all the departments in one column and
> separate them with a pipe "|".  For example, "Kinesiology|Office of
> the Dean"  I need to be able to do a query for each department
> separately, so that I can list all the "Office of the Dean" people,
> which is it's own page.  If I enter just "Office of the Dean" it
> works, but if it's "Kinesiology|Office of the Dean", it doesn't show
> up.  Here's the query:
>
> 
> 
> SELECT id,fname,lname,type,title,dept,phone
> FROM PEOPLE
> WHERE dept LIKE '#people#'
> ORDER BY lname ASC
> 
>
> -- 
> Daniel Kessler
>
> Department of Public and Community Health
> University of Maryland
> Suite 2387 Valley Drive
> College Park, MD  20742-2611
> 301-405-2545 Phone
> www.phi.umd.edu
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: A bit confused with links between tables

[Jeff Congdon]

i'm guessing that the primary key of your clients table is clientID... 
change it accordingly:


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 = P.projectsID INNER JOIN
clients C ON C.clientID = P.client


g'luck,

-jc

Chris Kavanagh wrote:

> Dear list,
>
> As the witching hour approaches and my first deadline draws near,
> expect my stress levels to climb and my emails to get less and less
> graceful.  For now, I feel remarkably composed, although I don't
> suppose I'll be getting to bed anytime soon.
>
> Now: this query fetches some data from two tables.
>
> 
> SELECT
> tasks.taskID,
> tasks.taskname,
> tasks.status,
> tasks.project,
> projects.projectsID,
> projects.projectname,
> projects.client
> FROM tasks, projects
> WHERE tasks.project=projects.projectsID
> 
>
> Further down I have a table that looks something like this:
>
> 
> #task.taskname# #task.status# #projects.projectname# 
> #projects.client#
> 
>
> The trouble is that the field project.client just returns the primary
> key from another table (clients).  I'd like it to display the field
> clients.clientname.
>
> I appreciate that this an extremely low hurdle to fall at but I've been
> frying my brain with this stuff for days and I'm finding it hard to
> think straight...
>
> Kind regards,
> CK.
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: CFMX affected by Win XP SP2?

[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 third-party programs that may require users to open
> > ports manually in order to work with SP2 include:
> >
> > - Macromedia's ColdFusion MX Server Edition 6;
> >
> > http://www.eweek.com/article2/0,1759,1636075,00.asp?kc=ewnws08
> > 1604dtx1k599
> >
> > Has anyone run into problems with this?
>
> No, you shouldn't have any problems with this, since in most CFMX
> applications you're just using plain ol' port 80.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> phone: 202-797-5496
> fax: 202-797-5444
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

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

[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

Jim Voris wrote:

> In my application a query is executed via cfstoredproc.  This is an
> "ad hoc" query, where the user may select a number of columns.  It
> works as designed, except when a large number of columns are
> selected...say 85 or so.
>
> The actual queries which cause the hang, execute just fine in query 
> analyzer.  
>
> The I/O is not that big...maybe 32K or so.
>
> When the query succeeds, JRun spikes for a second or two at 99% the
> immediately drops off.  When it hangs JRun pegs at 99%.
>
> Any thoughts?
>
> Thanks in advance.
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: remote restart cfmx service

[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 service, or
> > something like that?
>
> If you start a process from another process, it is known as a
> child process. You can see this with a tool like tlist from the
> resource kit, run it with the -t option and you see a tree of
> processes.
> Normally, if you kill a parent, all the children die (open the
> task manager, right click a running task and select "End process
> tree"). So if you have a process executing a batchfile in a child
> process, I would expect the child process to die as soon as the
> parent process dies. That means you will not be able to restart
> the parent process from the child.
> So I doubt using cfexecute to restart CF will work.
>
> Jochem
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Off topic SQL question from a novice

[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 wrote:

> Hi, I have 2 tables - the hike table which contains all the per hike 
> data.  The second table is a user review table which is assoicated 
> with the Hike table by HikeID.
>
>
> At any rate. I use a sql query to generate the left nav.  It is 
> similiar to
>
>
> select HikeName, HikeID, HikeDate, HikeStars
> from Hike
> order by HikeDate Desc
>
>
> I want to add the count of users reviews to the menu system so people 
> can see what how many user reviews exist for each hike.  This 
> information is in the UserReviews table.  As I said releated by HikeID.
>
>
> If I try a join I will get back mulitple rows since there is 
> invariably more UserReviews that 1.  I want to bring back a count value.
>
>
> It would seem like a sub query or something but I don't get how this 
> would be crafted.
>
>
> I would like the return to be the above query plus one field which is 
> the count of reviews for each HikeId.
>
>
> Thus-
>
>
> Pinnacle Peak, HikeID 40, 6/11/03, 5, (count of records in UserReviews 
> where Hike.HikeId = UserReviews.HikeId)
>
>
> Is this possible?  I would prefer this to be agregated in a sql 
> statement since I am looping over all the records in the original 
> query and would have to write a second query in the loop and query the 
> UserReview table for the hike ID bringing back a the count.  It would 
> be possible but I am thinking there must be a quick, more elegant 
> solution to this that probably someone more enlightened can just 
> rattle off.  Any ideas?
>
>
> Thanks,
>
>
> John
>
>
> Http://www.attrition.ws
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: CFMX 6.1 - Hotfixes - Best Practice

[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 round of installs and all servers still work as 
expected.

Use only the hotfixes you need, and put them first on a server that does 
not matter to you.  Examine its behavior for a few days, then consider 
using the hotfix elsewhere.

-Jeff

(i used these:
cfmx61_com_hotfix.zip
hf53257_61.zip
hf53486_61.zip
hf53797_61.zip
hf53813_61.zip
hf53852_61.zip
hf54464_61.zip
)

Novak Banda wrote:

> Anyone here have any recommendations as to how/what hotfixes should be
> installed for CFMX 6.1?  Does anyone have anything against simply
> downloading and installing all of them?
>
> -Novak
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

cfftp lastmodified date is wrong by a month and 12 hours

[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 (central to my pacific), but other clients treat this properly and don't give me a dateLastModified as being a month and 12 hours in the future...

Is there a fix for this?  I can't just manually subtract a month and 12 hours from every date, as this will obvioulsy break whenever ftp DOES get fixed, or when I swap my program into a diff time zone.

thanks in advance

-jc
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]