Re: Well - I feel like an idiot.

On Fri, 31 Dec 2004 14:18:07 -0500, Jim Davis <[EMAIL PROTECTED]> wrote: > > http://livedocs.macromedia.com/coldfusion/6/Developing_ColdFusion_MX_Appli > > cations_with_CFML/sharedVars6.htm > > > > http://livedocs.macromedia.com/coldfusion/6/Developing_ColdFusion_MX_Appli > > cations_with_CFML/shar

Re: Stress Testing & Cold Fusions Limits

On Fri, 31 Dec 2004 16:38:42 -0600, Tony Hicks <[EMAIL PROTECTED]> wrote: > Where you say cold fusion on a single box really peaks out? It completely depends on your application and the traffic patterns it sees. > I've been having a few issues but its cfmx related... problems > that didn't exist

Re: Stress Testing & Cold Fusions Limits

Hi, Check out grinder out and see if it helps. http://www.anticlue.net/archives/000395.htm The one main drawback is that you need to have multiple sessions on multiple PCs, because it overwhelms the local pc's nic card since they normally are lower end. The other program that is great for load

Re: Stress Testing & Cold Fusions Limits

Tony, Finding out where an application "peaks out" is a complex question and depends on your code and the database etc. Charlie Arehart spoke before our user group a few years back on the subject of load testing. I also believe he wrote an article on the subject in CFDJ though I couldn't locate

RE: Well - I feel like an idiot.

> -Original Message- > From: Ben Rogers [mailto:[EMAIL PROTECTED] > Sent: Friday, December 31, 2004 5:43 PM > To: CF-Talk > Subject: RE: Well - I feel like an idiot. > > > Which is exactly why you have to be consistent with locking. ;^) > > I don't see how consistency directly relates to

Re: Well - I feel like an idiot.

I've never had a session write or a session read fail on me, because thank God, right after I learned what a session was, someone sent me to research CFLOCK. But I've seen them fail on other cf sites... a session read actually.. no data was being written at the time... I was browsing a forum one d

RE: Well - I feel like an idiot.

> -Original Message- > From: Tony Hicks [mailto:[EMAIL PROTECTED] > Sent: Friday, December 31, 2004 5:35 PM > To: CF-Talk > Subject: Re: Well - I feel like an idiot. > > Many session-based sites run well without any cflocks but they're > smaller sites.. It doesn't seem to me to be a policy

RE: Well - I feel like an idiot.

> Many session-based sites run well without any cflocks but they're > smaller sites.. It doesn't seem to me to be a policy of knowing what > your doing or not, its more about the fact that you don't ever want > data mixed up, ever. Which can happen as the result of deadlocks. > To me its worth a

RE: Well - I feel like an idiot.

> Which is exactly why you have to be consistent with locking. ;^) I don't see how consistency directly relates to what I was talking about. Modular code generally knows very little about its context: that's the whole point. You can be entirely consistent and still end up with deadlocks if one pi

Stress Testing & Cold Fusions Limits

You guys have some impressive knowledge.. I think I do too :) but I admire yours.. I wanted to ask a question... Where you say cold fusion on a single box really peaks out? I mean without clustering and everything... where would you say its too much load? I've been having a few issues but its cfm

Re: Well - I feel like an idiot.

Many session-based sites run well without any cflocks but they're smaller sites.. It doesn't seem to me to be a policy of knowing what your doing or not, its more about the fact that you don't ever want data mixed up, ever. To me its worth a few more lines of code to always protect my user's data.

Re: Array issue

I didn't have a part in the suggestion but I'm glad it works. I saw it and being a list fan like I am.. I would have suggested it too... I would suggest one other thing though... your summary seems like to goes beyond too much... just a thought.. I'd put pages relating to each module in a seperat

RE: Well - I feel like an idiot.

> -Original Message- > From: Ben Rogers [mailto:[EMAIL PROTECTED] > Sent: Friday, December 31, 2004 4:28 PM > To: CF-Talk > Subject: RE: Well - I feel like an idiot. > > But what happens if you call a UDF, CFC method or custom tag within a > lock? > Each of these provides a degree of encap

Array issue

Thanks As always you guys came through. The answer to my problem was I don't know much about lists or arrays, so I really don't know the available functions. As for why I am using an array I found a piece of code in a book that seem to resolve an issue. When a person logs into my site The system

RE: Well - I feel like an idiot.

> I'm not sure how this relates in CF... > > The only real way that I know of to get a real deadlock in CF is to nest > lock requests. Like the following: > > > > > As far as I know, it's only possible via nested locks. There's actually a good deal on deadlocks in the ColdFusion

RE: Well - I feel like an idiot.

> -Original Message- > From: Ben Rogers [mailto:[EMAIL PROTECTED] > Sent: Friday, December 31, 2004 3:18 PM > To: CF-Talk > Subject: RE: Well - I feel like an idiot. > > > But the core advice of "always lock" is definitely the safer option. > > I don't think I agree with the "always lock"

RE: Well - I feel like an idiot.

> But the core advice of "always lock" is definitely the safer option. I don't think I agree with the "always lock" mentality. This inevitably leads to deadlocks, and I don't believe ColdFusion handles deadlocks in a graceful way. By that I mean that ColdFusion does not roll back all operations in

Re: OT: query optimization

>(Which join type is hidden behind the popup?) Sorry I left that covered up this time... Look here: http://www.redmondinc.com/sos/exe_plan.gif Is that sufficient? >Can you give me the recordcount of the following queries: > SELECT DISTINCT proj_code, cust_job_num, cust_code, order_code > FROM o

RE: Extract year from date field

Thanks -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Friday, December 31, 2004 1:51 PM To: CF-Talk Subject: Re: Extract year from date field > How do I extract the year from a date field such as 2005-10-12? > > select distinct(datepart(m,report_date)) as month f

RE: Well - I feel like an idiot.

> -Original Message- > From: Tony Hicks [mailto:[EMAIL PROTECTED] > Sent: Friday, December 31, 2004 2:03 PM > To: CF-Talk > Subject: Re: Well - I feel like an idiot. > > Either I like to stick my foot in my mouth, or I'm feeling gutsy but I > was looking at livedocs for application variabl

Re: Well - I feel like an idiot.

Either I like to stick my foot in my mouth, or I'm feeling gutsy but I was looking at livedocs for application variables on another thing and it did say for data integrity you SHOULD lock. http://livedocs.macromedia.com/coldfusion/6/Developing_ColdFusion_MX_Applications_with_CFML/sharedVars6.htm

Re: Extract year from date field

> How do I extract the year from a date field such as 2005-10-12? > > select distinct(datepart(m,report_date)) as month from report > where datepart(yy,report_date) = '2005' > Not to be a wiseass...but if that's the query, it'll always be 2005 :) It looks like your query gets all of the months

RE: Array issue

> From: Dawson, Michael [mailto:[EMAIL PROTECTED] > You need to use the ListFind() function. CONTAINS, or ListContains() > can get you in trouble. ;-) > > You might also check CFLib.org for an ArrayFind() function so > you don't > have to build it yourself. I would also ask why you are mak

RE: Extract year from date field

Thank you Sean. How can I apply the DISTINCT to the year as well? It gives me an error when I add it in front of datepart(yy,report_date) -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Friday, December 31, 2004 12:49 PM To: CF-Talk Subject: Re: Extract year from da

RE: Array issue

You need to use the ListFind() function. CONTAINS, or ListContains() can get you in trouble. ;-) You might also check CFLib.org for an ArrayFind() function so you don't have to build it yourself. MAD -Original Message- From: Michael C.Grove [mailto:[EMAIL PROTECTED] Sent: Friday, Dec

Array issue

I have an array that I am using in a security table. The system does a query for a UserID in a table and returns all of the modules that the user has access to. The ModuleID is simply the Autonumber in an access table. The array builds fine. Using the following code below this is what I get and w

Re: Extract year from date field

On Fri, 31 Dec 2004 10:43:43 -0500, Robert Orlini <[EMAIL PROTECTED]> wrote: > How do I extract the year from a date field such as 2005-10-12? > > > select distinct(datepart(m,report_date)) as month from report > where datepart(yy,report_date) = '2005' > You need to change your query so returns

Re: Well - I feel like an idiot.

On Fri, 31 Dec 2004 08:48:06 -0500, Jeffry Houser <[EMAIL PROTECTED]> wrote: > I'm just gonna throw this out there. Would this be better?: No, it wouldn't. You would cause every single request to the server to be single threaded at this point: > > > > ... long init process ... > >

Re: Well - I feel like an idiot.

I understand completely what your saying, just had a different view on it, that's all. Two cfifs don't hurt anything really... I just try to avoid them whenever possible.. I mean its possible to let cf do the deciding in some cases without using CFIF/CFSWITCH/*shudder* IIF. Wanna see? You were cl

Re: Possible to pass formatting to Excel from CF?

Hi, Dave Ross did a great job explaining how to exploit POI which basically allows you to create your own excel sheet. Check out http://www.d-ross.org/index.cfm?objectid=9C65ECEC-508B-E116-6F8A9F878188D7CA HTH, Anticlue http://www.anticlue.net On Fri, 31 Dec 2004 11:37:28 -0400, Dale Thelen <

Possible to pass formatting to Excel from CF?

I have a conference registration page that stores data in a semi-colon delimited .txt file. I have a .cfm file that lets the user dump this out into Excel form using cfcontent and cfheader and cfoutput query. It opens in Excel (not Excel inside Explorer) and prompts the user to open or save as

RE: Extract year from date field

In cf?? Year(date) Pascal > -Original Message- > From: Robert Orlini [mailto:[EMAIL PROTECTED] > Sent: 31 December 2004 16:57 > To: CF-Talk > Subject: RE: Extract year from date field > > Thanks Jochem. How would I extract the year from 2005-10-12 please? > > -Original Message-

Re: Extract year from date field

Robert Orlini wrote: > Thanks Jochem. How would I extract the year from 2005-10-12 please? Year(). Jochem ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.ho

Re: Extract year from date field

dateformat(variable, '') That should do the trick. --Ben Robert Orlini wrote: > Thanks Jochem. How would I extract the year from 2005-10-12 please? ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics h

RE: Extract year from date field

Thanks Jochem. How would I extract the year from 2005-10-12 please? -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, December 31, 2004 10:47 AM To: CF-Talk Subject: Re: Extract year from date field Robert Orlini wrote: > How do I extract the year from a

Re: QofQ: SELECT DISTINCT

Hi, I agree with Joe, try doing the query as a stored procedure if applicable. Also if it is still a long running stored procedure check out the indexing of the query. HTH, Anticlue On Fri, 31 Dec 2004 08:41:56 -0500, Joe Rinehart <[EMAIL PROTECTED]> wrote: > Andrew, > > How does the query yo

Re: Extract year from date field

Robert Orlini wrote: > How do I extract the year from a date field such as 2005-10-12? > > I'm using datepart in the Query as: > > datepart(yy,report_date), > > but when I try to output it as: > > #datepart("", > populatedropdown.report_date)# > > it gives an form field not found erro

Extract year from date field

How do I extract the year from a date field such as 2005-10-12? I'm using datepart in the Query as: datepart(yy,report_date), but when I try to output it as: #datepart("", populatedropdown.report_date)# it gives an form field not found error. Here is the query: select distinct(date

Re: OT: query optimization

Paul Malan wrote: > > You're right, it is still too long. And it turns out it's taking > about 15 seconds on average, even slower than I thought. I updated > the execution plan scrshot and the indexes as well. (I did add the > index to all three applicable tables.) The link again is > http:ww

Re: OT: query optimization

> I think that is still rather long. Can you update the execution > plan and index pages if you need it to go even faster? You're right, it is still too long. And it turns out it's taking about 15 seconds on average, even slower than I thought. I updated the execution plan scrshot and the indexe

RE: Well - I feel like an idiot.

> -Original Message- > From: Tony Hicks [mailto:[EMAIL PROTECTED] > Sent: Friday, December 31, 2004 9:38 AM > To: CF-Talk > Subject: Re: Well - I feel like an idiot. > > Humbly, I was wrong on the locks on application variables.. thats > information to file for later, thanks. No need to b

Re: Well - I feel like an idiot.

Humbly, I was wrong on the locks on application variables.. thats information to file for later, thanks. But I can't see how both CFIFs are necessary... The outer cfif will likely never affect anything. If two people hit the site, one request behind another, they'll both fire all the way up to th

RE: Well - I feel like an idiot.

> -Original Message- > From: Jeffry Houser [mailto:[EMAIL PROTECTED] > Sent: Friday, December 31, 2004 8:48 AM > To: CF-Talk > Subject: Re: Well - I feel like an idiot. > > I'm just gonna throw this out there. Would this be better?: > > > > > ... long init process ... > >

Re: Well - I feel like an idiot.

I'm just gonna throw this out there. Would this be better?: ... long init process ... Person 1 comes in, Application.init is not defined, so they start initting the app. Person 2 comes in, and waits for the lock. Person 1 inits the app and releases the lock Person 2

Re: QofQ: SELECT DISTINCT

Andrew, How does the query you're querying get created in the first place? Is there a way to 'clean' it further 'up' the chain? -Joe On Fri, 31 Dec 2004 12:20:28 +, Andrew Dixon <[EMAIL PROTECTED]> wrote: > Hi Ryan. > > That custom tag is no help as I need to DISTINCT on three columns. As

Coldfusion & IIS behind firewall

Hi CF-Talkers! I havea little problem here , hope someone can help me. I have two sites in IIS configured with one Coldfusion MX server. both sites are named site1.myhost.xx and site2.myhost.xx and are viewable from the local network working perfectly.! Well i tried to put one of them online

Re: QofQ: SELECT DISTINCT

Hi Ryan. That custom tag is no help as I need to DISTINCT on three columns. As a work around for the moment, I'm creating a table in the mySQL datasource and then populating it, doing the select and then deleting the table and it is about 100 times (really) quicker. The QofQ takes about 2 seconds

Re: OT: query optimization

Paul Malan wrote: > That is a huge improvement! The execution time is lower than 10 > seconds now - that's amazing. I think that is still rather long. Can you update the execution plan and index pages if you need it to go even faster? > For clarification, when I set up the index all I did was

Re: Well - I feel like an idiot.

> change anything... Also reads and writes to > application variables > should be locked so the outer CFIF is not > necessarily a good idea. The outer CFIF is necessary so that once initialization is over, subsequent requests won't even try to obtain a lock. Otherwise, every request will try to ob