Re: CFQUERY Timeout for SQL2005 Fails

2009-04-15 Thread Sung Woo
Anyone? Bueller? I really need an answer to this -- even though I'm running Fusion Reactor and can keep a survival strategy, this is no way to keep a server running. Is there anyone out there who's successfully used the TIMEOUT parameter in CFQUERY with CFMX 7.0.2 and SQL 2005 Standard?

Re: CFQUERY Timeout for SQL2005 Fails

2009-04-15 Thread Sung Woo
Mark and Casey, Thanks for clarifying this for me. I don't own the SQL Server that I need to hit, so it looks like I'm between a rock and a hard place. I still don't think the TIMEOUT parameter is working, though. In my example, I'm hitting a database that is fully operational, and I have a

Re: CFQUERY Timeout for SQL2005 Fails

2009-04-15 Thread Sung Woo
Also -- this may just be me being dense, but I don't get why the TIMEOUT feature in CFQUERY has to work this way. It's CF that's making the initial request to the datasource, so it should start counting down from the moment it creates that request. And then after waiting for a predetermined

Re: CFQUERY Timeout for SQL2005 Fails

2009-04-15 Thread Sung Woo
Hi Mark, To answer your question -- there's a DDL transaction that's running on the server, and from what the folks have told me, an ALTER TABLE command was causing the lock to occur. And the downside is that giving hints (i.e., WITH (NOLOCK)) is not going to have an effect in this

Re: CFQUERY Timeout for SQL2005 Fails

2009-04-15 Thread Sung Woo
Check this out. This one, as I've said before, outputs a number around 3000. cfquery name=test datasource=dsn timeout=1 select top 2 * from table/cfquery cfoutput#cfquery.ExecutionTime#/cfoutput However, this one results in an error: Error Executing Database Query.

CFQUERY Timeout for SQL2005 Fails

2009-04-14 Thread Sung Woo
Here's my test: cfquery name=test datasource=dsn timeout=1 select top 2 * from table /cfquery cfoutput#cfquery.ExecutionTime#/cfoutput I'm getting 3000+ for this value. This shouldn't be, right? Because I have the timeout parameter set for a second? The driver I'm using

Re: CFQUERY Timeout for SQL2005 Fails

2009-04-14 Thread Sung Woo
Actually, I was wrong -- even cfsetting requesttimeout=1 enablecfoutputonly=No doesn't work, because it still waits for the cfquery to finish before it outputs the timeout error. Is there any solution for this? The database we're relying on is unstable and we need to be able to kill the

Re: CFQUERY Timeout for SQL2005 Fails

2009-04-14 Thread Sung Woo
Hi Casey, What happened today is that the SQL server basically locked up. CF kept waiting for the request to come back, but it never did because it just hung infinititely. It seems as if CF waits forever in a case like this, so it's vital that I can kill the connection from the CFQUERY.

(Probably) Simple SQL Question?

2008-11-18 Thread Sung Woo
There's probably a really simple answer to this. Here's the sample dataset: id namedate_duedate_modified 1 Woo 1/1/200911/18/2008 4:55PM 1 Woo 2/1/200911/18/2008 4:57PM 1 Woo 3/1/200911/18/2008 4:59PM 2 Smith 1/1/2009

Re: (Probably) Simple SQL Question?

2008-11-18 Thread Sung Woo
Hi Rob, That would work in this instance, but I need something a little more dynamic. What if the dataset looked like this? id name date_due date_modified 1 Woo 1/1/2009 11/18/2008 4:55PM 1 Woo 2/1/2009 11/18/2008 5:21PM 1 Woo 3/1/2009 11/18/2008 5:30PM 2 Smith 1/1/2009

Re: (Probably) Simple SQL Question?

2008-11-18 Thread Sung Woo
Actually, your suggestion wouldn't work for the first set, either, as it would bring up 2 records for Smith and none for Woo. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free

Re: (Probably) Simple SQL Question?

2008-11-18 Thread Sung Woo
Thanks, Gerald. This is close, except there is a bit of a problem. I need to group this not by just one field but three fields, so the dataset actually looks like this (fields 1 - 3 make up the unique key): field 1 field 2 field 3 date_due date_modified 1 2 3 1/1/2009

Re: (Probably) Simple SQL Question?

2008-11-18 Thread Sung Woo
What database are you using? We're still using SQL2000, so 2005 commands won't help me here...thanks... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

CFDIRECTORY and Multiple Spaces Between Filename

2008-06-11 Thread Sung Woo
Running CFMX7.0.2. Not sure if this applies to other versions, but have you noticed that if you have two files in a directory, say: whatever whatever.txt (one space between names) whatever whatever.txt (two spaces between names) and if you do CFDIRECTORY in this directory, the NAME column

Re: CFDIRECTORY and Multiple Spaces Between Filename

2008-06-11 Thread Sung Woo
D'oh, never mind. It's because the browser kills the spaces. If I PRE it, it comes out fine. Running CFMX7.0.2. Not sure if this applies to other versions, but have you noticed that if you have two files in a directory, say: whatever whatever.txt (one space between names) whatever

CFDIRECTORY NUL bug

2008-04-02 Thread Sung Woo
Is it just me or does this produce an error for everyone? cfdirectory action=create directory=C:\NUL\ It's the word NUL that's giving CF 7.0.2 the heebie-jeebies. It's not able to create it. Any workarounds? - Sung ~|

Re: The request has exceeded the allowable time limit

2007-06-13 Thread Sung Woo
How long do you expect the job to take to complete? 2 hours seems way too long for an http request to run. How many templates are involved? Hi Neil, At this point, I don't expect the job to take any more than 15 minutes. I currently have around 750 records, and at the 10-minute mark, it

Re: The request has exceeded the allowable time limit

2007-06-13 Thread Sung Woo
On Wednesday 13 Jun 2007, Sung Woo wrote: I'm pulling in 5 other templates. For each record, it takes 2 seconds to run. Here's a snippet of the log file: What are you doing ? Maybe you could do it faster (like in a stored proc.) ? Hi Tom, It's possible to do it in a SP, but there's

Re: The request has exceeded the allowable time limit

2007-06-13 Thread Sung Woo
is not the issue. I have a timeout of 60 seconds, but CFSETTING RequestTimeout = xxx is supposed to overrule that. - Sung On Wednesday 13 Jun 2007, Sung Woo wrote: happening that I don't think I can replicate in a SP. At least not easily. And besides, it's already written in CF, so I

Re: The request has exceeded the allowable time limit

2007-06-13 Thread Sung Woo
-- I have a 60-second limit on templates, but that's meaningless when you have cfsetting requesttimeout=xxx on the page. If there's no solution to this, then I'll need to run the script in steps -- 300 or 400 records at a time. On Wednesday 13 Jun 2007, Sung Woo wrote: happening that I don't

Re: The request has exceeded the allowable time limit

2007-06-12 Thread Sung Woo
Which means that despite the requesttimeouts I have here, something else is overriding it and putting a hard limit of 60 seconds. I do have FusionReactor on this box, but crash protection is not enabled, so it shouldn't be the cause. What is going on here? Sorry, I meant a hard limit of

The request has exceeded the allowable time limit

2007-06-12 Thread Sung Woo
For the life of me, I can't figure out what I'm doing wrong. Running CFMX7.0.2 on Win2K: I have a scheduled task that includes a bunch of other templates, updating a bunch of tables. Anyway, I have the Timeout (sec) value in the Scheduled Task set at 7200. That's 2 hours, right? 60 seconds

Flash CFGRID and Date Sorting

2006-12-05 Thread Sung Woo
Is it just me or is Flash CFGRID's date sorting all screwed up? Here's my code: cfgridcolumn name=date_modified header=Date Modified type=STRING_NOCASE mask=MM/DD/YY LL:NNAA width=130 It does work -- eventually. I have to click on the heading three times -- after the third, it sorts

Turning the XML Contents of a SOAP Envelope into a Structure?

2006-11-08 Thread Sung Woo
Hi folks, I'm using CFINVOKE and CFHTTP to send SOAP-enveloped XML data to a server. Once the transaction is complete, the server sends me a response, also in SOAP-enveloped XML, like this one: ?xml version=1.0 encoding=utf-8? soap:Envelope

Re: Turning the XML Contents of a SOAP Envelope into a Structure ?

2006-11-08 Thread Sung Woo
Sorry for the confusion -- I'm using CFINVOKE to run the web service on my end, to generate the XML. Then I'm using CFHTTP to send the XML data to the other server. I'm using CFINVOKE and CFHTTP to send SOAP-enveloped XML data to a server. I'm confused. Which one are you using, CFINVOKE or

Re: Turning the XML Contents of a SOAP Envelope into a Structure ?

2006-11-08 Thread Sung Woo
Hi Dave, I found my error, and I took care of it with the following snippet: cfset temp = Replace(ToString(results.filecontent), 'lt;', '', 'ALL') cfset temp = Replace(temp, 'gt;', '', 'ALL') cfset myxmlobj = XMLParse(temp) What happened was that the last three bits of code were demoralized,

Re: Turning the XML Contents of a SOAP Envelope into a Structure ?

2006-11-08 Thread Sung Woo
Ooops...looks like HTML rendered my code to junk status. Here's the revised: cfset temp = Replace(ToString(results.filecontent), ' lt;', '', 'ALL') cfset temp = Replace(temp, ' gt;', '', 'ALL') Except in the real code, there aren't spaces between and lt or gt (I just did it here so it'll

Re: Turning the XML Contents of a SOAP Envelope into a Structure ?

2006-11-08 Thread Sung Woo
Just wanted to correct one thing: cfset temp = Replace(ToString(results.filecontent), ' lt;', '', 'ALL') cfset temp = Replace(temp, ' gt;', '', 'ALL') In the actual code, there is no space between lt and gt, but in order for it to display properly here, I added the spaces.

CFFLUSH and Fusebox 5

2006-10-31 Thread Sung Woo
I can't get CFFLUSH to work with FB5. My main circuit.xml looks like this. I'm still not that familiar with FB4/5 so I'm hoping somebody can point me in the right direction. I've read somewhere that using do or include will trigger cfcontentvariable, but I don't see how I can get around not

Re: CFFLUSH and Fusebox 5

2006-10-31 Thread Sung Woo
layout.header and layout.footer are your typical headers and footers -- header graphics, a dropdown menu, etc. The footer is nothing more than just a few graphics. I'm calling the cfflush from the body of the page. The circuit.xml looks like this: circuit access=public

Re: CFFLUSH and Fusebox 5

2006-10-31 Thread Sung Woo
Thanks, Sandra. Then what do you think is the reason why I can't get CFFLUSH to work? As it stands, I don't see any output until the whole page is loaded. I'm using the sample code on Macromedia's site: H1Your Magic numbers/H1 PIt will take us a little while to calculate your ten magic

Re: CFFLUSH and Fusebox 5

2006-10-31 Thread Sung Woo
Hi Brad, Not that I know of -- I'm using IIS 5 on W2K. Is your web server doing any compression? I use Apache, and enable compression in http.conf-- I have to turn that off for cfflush to work. DeflateFilterNote ratio AddOutputFilterByType DEFLATE text/* Etc.. Just a thought. ~Brad

Re: CFFLUSH and Fusebox 5

2006-10-31 Thread Sung Woo
Crap -- it is the header/footer that's causing the issue. I just tried it with the header/footer stripped, and sure enough, cfflush works just fine. The problem is that my header and footer create a table, and the body is inside the td tag. I can't imagine I'm the only one who does this in

Re: CFFLUSH and Fusebox 5

2006-10-31 Thread Sung Woo
Yup, that's the issue. I can't get around this...the layout was done by a third-party vendor and I really can't change this now. Outside of completely overhauling my layout, do I have any alternatives? Much thanks from both of you guys, by the way... - Sung Well the problem then is the fact

Re: CFFLUSH and Fusebox 5

2006-10-31 Thread Sung Woo
Thanks, Sandra. I did exactly as you suggested and now it's working fine. The only thing I lost were the gray bars on the left and right of the page (borders which were part of the table structure), but I can live without them. - Sung Unfortunately, there isn't much you can do with a tabled

RC2 via Bouncy Castle - last block incomplete in decryption

2006-10-10 Thread Sung Woo
I've followed the TechNote (http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=e546373d) to the letter, trying to get RC2 encryption/decryption to work. I keep getting last block incomplete in decryption error no matter which keys I use. It works fine for RC4. What am I doing wrong?

Re: RC2 via Bouncy Castle - last block incomplete in decryption

2006-10-10 Thread Sung Woo
Never mind -- it actually works just fine. It turns out that the encrypted string was the problem: tNMtwvuAtRO+Hvs1ciH7bw== outputs testing123 via RC2/Base64. I've followed the TechNote (http://www.adobe. com/cfusion/knowledgebase/index.cfm?id=e546373d) to the letter, trying to get RC2

Re: RC2 via Bouncy Castle - last block incomplete in decryption

2006-10-10 Thread Sung Woo
I ran into a problem after all. I'm trying to interface with AspEncrypt, a third-party app that gives ASP encryption capabilities. Has anyone had any success exchanging encrypted data with AspEncrypt? I'm running into strange issues. To summarize: I'm using a simple hash command to

Re: Crawling a Site When Site Uses Security

2006-10-10 Thread Sung Woo
Thank you for all your replies -- one of them should certainly work out for me. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your

Crawling a Site When Site Uses Security

2006-10-03 Thread Sung Woo
I run an intranet site in our company, and it is protected through CF (user table in SQL, using session variables, etc.). What I want to do is crawl through my site for the purpose of searching (we just bought a Googlebox), but I'm not sure how to approach this. Since the Googlebox is unable

Must I Use Evaluate() Here?

2006-08-30 Thread Sung Woo
I have a structure called stcFilters. In this structure, I have the following values: stcFilters.filter_1 = 100 stcFilters.filter_2 = 200 I want to show the value of these filters through a cfloop: cfloop index=i from=1 to=2 cfset temp = Evaluate(stcFilters.filter_#i#)

Re: Must I Use Evaluate() Here?

2006-08-30 Thread Sung Woo
I knew it was something really simple. Thank you! stcFilters['filter_#i#'] works Sung Woo wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your

index.cfm Conundrum

2006-06-13 Thread Sung Woo
I have a very strange issue with a server running CFMX7. This server initially was running CFMX7 standalone, and when the time came, it was uninstalled and reinstalled as a CFMX7 using IIS. So now here's the wacky issue: no matter the site (on ports 80 and 81), whenever the file index.cfm is

Re: index.cfm Conundrum

2006-06-13 Thread Sung Woo
Hi Rob, Thanks -- it's not checked. Take a look at your settings in CF Admin. In the Caching settings, ensure that Cache web server paths is unchecked. This is important for servers running multiple sites. On 6/13/06, Sung Woo [EMAIL PROTECTED] wrote: I have a very strange issue

Re: index.cfm Conundrum

2006-06-13 Thread Sung Woo
Save class files is checked. I bet I need to restart the server, right? I'll have to wait to do that. Hi Rob, Thanks -- it's not checked. Are all three values unchecked? I just unchecked the middle one and it resolved a somewhat similar issue for me. -- Ian Skinner

Re: index.cfm Conundrum

2006-06-13 Thread Sung Woo
the XML config file to change it. The problem you're describing sounds like that to me. On 6/13/06, Sung Woo [EMAIL PROTECTED] wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243381 Archives: http

Fusebox 4 Slow?

2006-06-06 Thread Sung Woo
I'm seeing some ugly execution times for Fusebox 4...the page I'm generating is nothing more than a straight HTML page, yet it takes 422ms to generate? Looks like the bulk of the time is being spent on fusebox40.runtime.cfmx.cfm, index.cfm, and fusebox40.loader.cfmx.cfm. What gives?

Re: Fusebox 4 Slow?

2006-06-06 Thread Sung Woo
the framework stop looking for changes to the XML files (both fusebox.xml and circuit.xml). cheers, barneyb On 6/6/06, Sung Woo [EMAIL PROTECTED] wrote: -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites

Re: Fusebox 4 Slow?

2006-06-06 Thread Sung Woo
the entire framework's metadata on every request. If you switch it to 'production', you'll see a nice improvement, at the expense of having the framework stop looking for changes to the XML files (both fusebox.xml and circuit.xml). cheers, barneyb On 6/6/06, Sung Woo [EMAIL PROTECTED] wrote

Re: Fusebox 4 Slow?

2006-06-06 Thread Sung Woo
Thank you both! - Sung ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242627 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe:

Turning on Metrics on CFMX7

2006-03-28 Thread Sung Woo
For some reason, I can't get metrics running on a recent CFMX7 upgrade (from CFMX6.1). The relevant portions on jrun.xml are as follows: !-- This Service provides metrics information -- !-- == --

CFMX7 Logs Using CFMX6 Logs!

2006-03-28 Thread Sung Woo
After upgrading to CFMX7, I'm seeing something weird. I haven't uninstalled CFMX6.1 yet, but the service is turned off. In any case, I'm seeing that CFMX7 is using C:\ColdFusionMX\logs instead of C:\ColdFusionMX7\logs. Why the heck would it be doing this, and how can I change it?

Re: CFMX7 Logs Using CFMX6 Logs!

2006-03-28 Thread Sung Woo
Thanks, Rob! In the MX 7 administrator, you can specify your logging directory. Look in the logging settings section, I believe. On 3/28/06, Sung Woo [EMAIL PROTECTED] wrote: After upgrading to CFMX7, I'm seeing something weird. I haven't uninstalled CFMX6.1 yet, but the service

Re: cfm vs. php?

2006-03-28 Thread Sung Woo
Costwise, you can also get CFML through BlueDragon: http://www.newatlanta.com/products/bluedragon/product_info/features.cfm The minimum server is still free, another reason to go CFML instead of PHP. ~| Message:

Re: cfm vs. php?

2006-03-28 Thread Sung Woo
Is that right? I thought CPU count only comes into account for .NET or J2EE versions. For the plain ol' server version, I thought it was no cost? http://www.newatlanta.com/products/bluedragon/product_info/pricing.cfm It's only actually cheaper for single CPU servers though. So the benefit of

Flash Form CFGRID Hyperlink

2006-03-07 Thread Sung Woo
The more I use Flash Forms, the more I find how restrictive they are. Case in point: I'm trying to create a simple CFGRID with two columns: car name and a text field for color. I want the user to be able to type in anything for the color, and I want this information to be saved to a table.

Re: Flash Form CFGRID Hyperlink

2006-03-07 Thread Sung Woo
Thanks, Nick. The problem with this method is that if I click on any part of the row, it drills down. So if I have two columns, one that's just text and another that's an editable text field, clicking on either one ends up drilling down. I need the drilldown to only happen on the static text

Dropdown in Flash CFGRID?

2006-01-11 Thread Sung Woo
Is it possible to create a dropdown (select box) inside a Flash CFGRID? This was possible with the applet version (values=1,2 valuesdisplay=fred,ethel parameter), but it doesn't look like it's a built-in feature of Flash CFGRID. Is there a workaround?

Re: Dropdown in Flash CFGRID?

2006-01-11 Thread Sung Woo
Thanks, Brad. Are there any examples around I could see? In flash, yes it is possible, but you have to use action script to specify a special cellRenderer. It is not a built in feature of CFGRID. ~Brad ~| Message:

Re: Dropdown in Flash CFGRID?

2006-01-11 Thread Sung Woo
Hi Brad, Guess what -- I googled cellrenderer and actionscript and cfgrid and got this result: http://cfpim.blogspot.com/2005/08/grid-cellrenderer-in-flash-forms.html I think this might work...big thanks for replying to this thread! I have not done this before, so I don't have any examples,

Re: Datasource Setup Question

2005-06-18 Thread Sung Woo
No -- I'd just read somewhere that 1-2 connections per CPU is the norm for SQL. I'm the one who's limiting it. Sounds like from the other reply, I should maybe remove this to see what happens. Limit Connections - YES Restrict connections to - 6 Is this because you only have a small number of

Re: Datasource Setup Question

2005-06-18 Thread Sung Woo
I'll see if removing the connection limitation has any effect. I do have CFMX fully updated (latest SP and hotfixes). I was under the impression that removing maintain connections ends up being a large performance hit -- is this not true? I do have pages taking longer than 10 seconds logged

RE: Datasource Setup Question

2005-06-18 Thread Sung Woo
Hi Mark, I believe Douglas's post suggested removing maintain connections -- at least that's the way I read it. Here's the snippet: We had some issues with 'maintain connections' set to yes and for our heavy DB based apps we still have it set to off. I'll see what kind of a performance hit

Datasource Setup Question

2005-06-16 Thread Sung Woo
I have a quad-processor machine for a webserver and a quad-processor machine for a database server. Running CFMX 6.1 and MS SQL 2000. My question is about datasource setup in the administrator. My site is an intranet, and it isn't heavily used (about 150 people online at the same time).

Slight Differences in New CFMX Install

2005-03-01 Thread Sung Woo
I'm just about to set up another server, and I'm seeing slight differences in the two installs. In my old install, I have these being referenced: C:\CFusionMX\runtime\..\lib\cfmx-j2ee.jar C:\CFusionMX\runtime\..\lib\jce1_2_1.jar C:\CFusionMX\runtime\..\lib\local_policy.jar There are

Mail Not Working

2005-03-01 Thread Sung Woo
Another issue with my new box: I've verified connectivity with the SMTP server through the CF Administrator. But mail isn't being sent out. No errors, no nothing. The .cfmail files get written to the default directory c:\cfusionmx\mail\spool, but they never leave... Any thoughts?

Installing CFMX 6.1 via Terminal Services

2005-02-28 Thread Sung Woo
Has anyone installed CFMX 6.1 via Terminal Services successfully? ~| 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

Re: Installing CFMX 6.1 via Terminal Services

2005-02-28 Thread Sung Woo
-Original Message- From: Sung Woo [mailto:[EMAIL PROTECTED] Sent: 28 February 2005 14:21 To: CF-Talk Subject: Installing CFMX 6.1 via Terminal Services Has anyone installed CFMX 6.1 via Terminal Services successfully

Re: inetinfo.exe Memory Leak After 6.1 Updater

2004-11-03 Thread Sung Woo
FYI, after many tests, we have isolated the problem as a memory leak in jrun.dll. I've replaced the current jrun.dll with the one in JRun 4 Updater 4 (build 84683), and it has brought down the memory usage, which, mind you, was going over 250MB easy a day, to a measly 19MB. It's a workaround,

Re: inetinfo.exe Memory Leak After 6.1 Updater

2004-11-03 Thread Sung Woo
One thing I forgot to mention -- it only happens if you use SSL. We use 128-bit SSL encryption for all our stuff. So that might be the distinction... I didn't extract it from the updater -- the Macromedia rep sent it to me. He says it isn't the final solution, so once I have the real thing,

Re: inetinfo.exe Memory Leak After 6.1 Updater

2004-10-27 Thread Sung Woo
Still happening. I called Macromedia (we just got their bronze support), so I'll let you all know if they can resolve this. I just uninstalled the connectors and reinstalled them (and left jrunsvc.exe alone). I'll let you know what happens tomorrow... - Sung Is re-running the

Re: inetinfo.exe Memory Leak After 6.1 Updater

2004-10-26 Thread Sung Woo
To remove and reinstall the connectors, would you run the two batch files in the \bin directory (Remove_ALL_connectors.bat, IIS_connector.bat)? I've never done this before, so I'm just curious...thanks for all your help! Hi Alex, It's standalone, using IIS 5.0. Exactly which file did

Re: inetinfo.exe Memory Leak After 6.1 Updater

2004-10-26 Thread Sung Woo
Alex, By fresh install, do you mean pre-6.1 Updater? I see 2 versions of jrunsvc.exe on my machine (doing Properties on the file): File version 4.0.0.0, 57,344 bytes File version 4.0.3.10455, 61,440 bytes The one that's running (in the c:\cfusionmx\runtime\bin dir) is the latter. Are you

Re: inetinfo.exe Memory Leak After 6.1 Updater

2004-10-26 Thread Sung Woo
I just uninstalled the connectors and reinstalled them (and left jrunsvc.exe alone). I'll let you know what happens tomorrow... - Sung Is re-running the connectors necessary or can I just replace the jrunsvc.exe? ~| Purchase

inetinfo.exe Memory Leak After 6.1 Updater

2004-10-25 Thread Sung Woo
I'm still having a rather nasty issue after installing the 6.1 Updater (and the 3 recommended hotfixes -- hf55681_61, hf56991.611, navserver_611) on my W2K box (SP4, 2GB of RAM). What's happening is that there's a slow but steady memory leak in inetinfo.exe. inetinfo hardly ever used to go

Re: inetinfo.exe Memory Leak After 6.1 Updater

2004-10-25 Thread Sung Woo
Hi Alex, It's standalone, using IIS 5.0. Exactly which file did you copy from a fresh install? jrunsvc.exe itself is not having any issues (steady at 36K, 2 threads), but I guess it is related? ~| This list and all House of

Post-6.1MX Updater - CFINSERT = String index out of range

2004-10-18 Thread Sung Woo
I just went through a little hell backing out of the CFMX 6.1 Updater (the one released on August 2004).After doing this update, many (if not all) CFINSERT operations resulted in this error: String index out of range: -2 I'm using the JDBC SQL drivers (MS SQL 7.0). BTW, I explicitly followed

jrun.xml/JVM Tuning in CFMX

2004-10-12 Thread Sung Woo
What do you folks think about this article? http://www.robisen.com/index.cfm?mode=entryentry=FD4BE2FC-55DC-F2B1-FED0717CC1C7E0AF Seems to be working OK for me, so far.jrun.exe's thread count went from 54 to 65 and memory usage jumped from 80MB to 200MB, but the site does seem to be running

Users Online, Take 2

2004-09-15 Thread Sung Woo
So I've finally gotten around to rewriting the who is online? portion of my site, and it turns out that I didn't have to do much rewriting at all.The script below was using CFID to keep track, which, as many people pointed out, was not a good idea.I keep a session variable (session.UserID) in my

Re: Users Online, Take 2

2004-09-15 Thread Sung Woo
Hi Dov, I think the CFLOOP via COLLECTION is similar to what you propose with the LIST -- at least that's what the documentation tells me. The number of threads on my machine usually hovers around 54.Just now, it jumped to 96!I took the CFLOOP out, and now it's back to 54.So I still need to find

Re: Users Online, Take 2

2004-09-15 Thread Sung Woo
Just found my stupid mistake -- the file was pulling in application.cfm, so it must've been pulling up the login page instead.Makes sense why it would run when I ran it manually (since I was already logged in).I moved the file to a non-application.cfm-enabled directory, and now it works just

Re: Count Online Users Conundrum

2004-09-07 Thread Sung Woo
I've been tied up with stuff lately, but I finally have a bit of a breather, so I'm ready to tackle this thing once and for all.I just want to get some feedback on what I plan on doing: On my site, UserID (an integer) is a session variable.I'll create a structure that has the following three

Java+JSP 10 times faster than CF? And Other Ruminations.

2004-09-07 Thread Sung Woo
I just came back from a weeklong training session with java/JSP programming and have a couple of things to discuss. FYI, I've been a long-time CF programmer (first version of 3.1).I've dabbled in UNIX shell scripts, perl, ASP, VB, and Pascal (yes, Pascal!) in my past incarnations, and hands down,

Re: Count Online Users Conundrum

2004-09-07 Thread Sung Woo
Excellent.So there are two instructions on the structure update: 1) update my time 2) kill any connections older than 15 minutes I'd still need to run a cleanup script every fifteen minutes, just to clean up any last connections, right?Otherwise, there will always be 1 person logged on, I'd

Re: Java+JSP 10 times faster than CF? And Other Ruminations.

2004-09-07 Thread Sung Woo
I think the br issue is because of the URL...I've seen this exhibited on some other messages. Here's my message again, without the link...should be easier to read. --- I just came back from a weeklong training session with java/JSP programming and have a couple of things to discuss. FYI, I've

Re: Count Online Users Conundrum

2004-08-19 Thread Sung Woo
What are you actually trying to do?I'm assuming you're attempting to see who's currently using the system, and basically discounting anyone who's not been active in the last 15 minutes? If this is the case let me know and I'll knock a little code out for you!Can't do it today, stupid firewall

Re: Count Online Users Conundrum

2004-08-18 Thread Sung Woo
Hi Ryan, Here are my results: 4 12 14 10 11 15 8 5 3 8 10 12 10 7 4 13 14 14 14 13 15 7 6 3 12 0 6 11 5 6 11 4 4 12 6 11 4 4 11 6 14 13 15 10 9 9 3 15 9 6 2 12 9 10 13 8 11 5 3 13 3 3 3 2 2 4 2 2 5 2 2 12 3 2 4 9 2 15 4 7 2 9 6 10 1 5 14 1 1 13 8 11 14 14 1 1 15 6 9 4 8 5 7 1 1 1 1 6 1 12 0 0 0

Re: Count Online Users Conundrum

2004-08-18 Thread Sung Woo
Ray, is there any way I could streamline the locks?This is in the application.cfm page, so it's being hit quite often, and I'd like it to be as efficient as possible.Thanks! - Sung Not that it helps much, but that is some pretty awful code. The locks are too much and the code generating cfid

Re: Count Online Users Conundrum

2004-08-18 Thread Sung Woo
Hi Tim, Thanks so much for the breakdown.I got the code from easycfm.com and didn't think to really analyze it.I'll make the changes you suggested and let you know if I run into anything.Thanks again! - Sung Sung, What happens is that at the end of the day (I run an intranet where there are

Re: Count Online Users Conundrum

2004-08-18 Thread Sung Woo
My apologies -- this will give you their total session time.To work out if they've been inactive for more than 15 minutes you'll have to do a time check comparing the last active timestamp and the current time using now(). Hi Tim, Thanks.I ran your script and sure enough, right now, it says

Count Online Users Conundrum

2004-08-17 Thread Sung Woo
I got this little snippet from easycfm.com to keep track of online users, but lately, it hasn't been working quite right.What happens is that at the end of the day (I run an intranet where there are about 200 peak users), around midnight, it still shows 80 or so users online!What do you think

CFMX/jrun.exe Thread Count

2004-08-16 Thread Sung Woo
This might be a ridiculous question to ask, but I thought I would anyway. On my box (hosting 3 sites), the thread count for jrun.exe hovers around 53. I've seen it go as high as 56 and as low as 48. When the box crashes, which happens not that often, the thread count goes to 80 and beyond. So

Web Services and CFMX6.1 -- Why doesn't it work?

2004-04-13 Thread Sung Woo
I'm at my wit's end here, folks.I don't know why my idiotic hello world web service just isn't working.Here's a path to my madness: helloworld.cfc cfcomponent cffunction name=getMessage access=remote returntype=string output=false cfargument name=name type=string required=yes cfreturn Hello

Re: Web Services and CFMX6.1 -- Why doesn't it work?

2004-04-13 Thread Sung Woo
Hi Michael, Thanks, but that doesn't seem to work, either. I don't understand why I'd use port 8500...I'm not using the built-in webserver, I'm using IIS? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Web Services and CFMX6.1 -- Why doesn't it work?

2004-04-13 Thread Sung Woo
Yup, I can browse it just fine.If I use the ?wsdl after the helloworld.cfc, I generate the XML file fine, too. And even stranger...I'm doing this because we're evaluating Vignette, which has nice interactivity with web services.This web service is recognized and fully usable by Vignette!So it

Re: MX: Scheduler firing off too often

2004-04-13 Thread Sung Woo
Scott, I have the same issue with my CFMX 6.1 box on W2K.It only happens sometimes, maybe once every month.I haven't found a cure for it, only a workaround.I have a lengthy scheduled task that runs at 3am once a week, but if it runs during business hours, it can create some problems.So I wrapped a

Re: Web Services and CFMX6.1 -- Why doesn't it work?

2004-04-13 Thread Sung Woo
I don't get a blank page, but I do get a redirect to the component browser, which looks something like this: ws.helloworld Component helloworld hierarchy: WEB-INF.cftags.component ws.helloworld path: E:\webroot\ws\helloworld.cfc properties: methods: getMessage * - private method

Re: Web Services and CFMX6.1 -- Why doesn't it work?

2004-04-13 Thread Sung Woo
Thanks for all your help, guys.I tried the snippet on my production server, and sure enough, it runs just fine.So I guess it is my server config.What could it be, though?I don't understand what inside CF could cause this, when all evidence points to the file being exactly where it should be.The

Re: Web Services and CFMX6.1 -- Why doesn't it work?

2004-04-13 Thread Sung Woo
Ryan -- yes, I do have that vdir on both production and test... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

CFMX Hanging Solutions?

2004-03-02 Thread Sung Woo
I've been scouring the forums here and on Macromedia regarding CFMX hangs.I have a page on my site that takes more than 1000ms to return (runs about 10 big queries).If I get on this page and hit F5 over and over again, I can see jrun.exe memory size and thread count expand.The memory size never is

  1   2   >