Re: onclick refresh cfdiv

2009-12-17 Thread Azadi Saryev
use ColdFusion.navigate() javascript function http://livedocs.adobe.com/coldfusion/8/htmldocs/JavaScriptFcns_24.html#1202179 Azadi Saryev On 18/12/2009 07:58, Sebastian Powell wrote: > Anyone done this before? I want to refresh a cfdiv when a anchor tag link is > clicked? > > thanks. > > Seb

RE: Server Performance

2009-12-17 Thread brad
Another good choice for a little less dough is SeeFusion which has some very handy database logging. http://www.seefusion.com/ ~Brad Original Message Subject: Re: Server Performance From: Andrew Scott Date: Thu, December 17, 2009 6:52 pm To: cf-talk As you are not running

Re: Server Performance

2009-12-17 Thread Andrew Scott
As you are not running ColdFusion Enterprise your best bet would be http://www.fusion-reactor.com/ On Fri, Dec 18, 2009 at 11:20 AM, wrote: > > Is there a way through command line or a 3rd party application to see > what web sites on a CF Pro 8 server are causing the most requests? On > one p

Server Performance

2009-12-17 Thread webmaster
Is there a way through command line or a 3rd party application to see what web sites on a CF Pro 8 server are causing the most requests? On one particular server it is starting to show behavior of page timeouts and longer running requests. In the Performance Monitor in windows I see the running re

onclick refresh cfdiv

2009-12-17 Thread Sebastian Powell
Anyone done this before? I want to refresh a cfdiv when a anchor tag link is clicked? thanks. Sebastian ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists

Re: array question

2009-12-17 Thread Ben Conner
Dang. That's also handy. Thanks, Dan! --Ben Dan Vega wrote: > You can find out the dimension of an array like so > > myArray.getDimension() > > > Thank You > Dan Vega > danv...@gmail.com > http://www.danvega.org/ > > > On Thu, Dec 17, 2009 at 11:15 AM, DURETTE, STEVEN J (ATTASIAIT) < > sd1...@

Re: array question

2009-12-17 Thread Ben Conner
Oh! That was obvious...after you answered it. :) Much appreciated! --Ben DURETTE, STEVEN J (ATTASIAIT) wrote: > Ben, > > Do an arraylen on the first row. arrayLen(myVar[1]) > > That will return the number of columns or planes. > > Steve > > > -Original Message- > From: Ben Conner [mai

Re: array question

2009-12-17 Thread Dan Vega
You can find out the dimension of an array like so myArray.getDimension() Thank You Dan Vega danv...@gmail.com http://www.danvega.org/ On Thu, Dec 17, 2009 at 11:15 AM, DURETTE, STEVEN J (ATTASIAIT) < sd1...@att.com> wrote: > > Ben, > > Do an arraylen on the first row. arrayLen(myVar[1]) >

Re: Searching a Date Range

2009-12-17 Thread Leigh
> > WHERE  EventDate <= #startDate# > AND    EventDate < #dayAfterTheFormEndDate# Whoops, typo there. That should be EventDate >= WHERE EventDate >= #startDate# ANDEventDate < #dayAfterTheFormEndDate# ~| Want to

Re: Searching a Date Range

2009-12-17 Thread Leigh
> Also, note that in SQL Server, the assumption is midnight, > so that the end date is really the day before, > so you could do this before your query: > > Yes, though the safest option is using a >= and < comparison since BETWEEN is inclusive. WHERE EventDate <= #startDate# ANDEvent

Re: Searching a Date Range

2009-12-17 Thread Gerald Guido
Ah... learn something new everyday. Good to know. G! On Thu, Dec 17, 2009 at 12:10 PM, Jason Fisher Ah... learn something wrote: > > With queryparam you don't need the createODBCDate() function: > > > SELECT blah > FROM tblCalendar > WHERE EventDate BETWEEN value="#form.someSt

Re: CF/Java assistance; Path questions

2009-12-17 Thread Tony Bentley
Your mapping can be either Coldfusion specific or you can use ClassPath mapping if you want to instantiate the object using the createobject function. Here is a worthy article: http://blogs.adobe.com/cantrell/archives/2004/07/the_definitive.html

Re: Searching a Date Range

2009-12-17 Thread Jason Fisher
With queryparam you don't need the createODBCDate() function: SELECT blah FROM tblCalendar WHERE EventDate BETWEEN AND Also, note that in SQL Server, the assumption is midnight, so that the end date is really the day before, so you could do this before your query: and then

Re: Searching a Date Range

2009-12-17 Thread Gerald Guido
Opps... had some stray code in there. SELECT blah FROM tblCalendar WHERE EventDate BETWEEN#CreateODBCDate(someStartDate)# AND #CreateODBCDate(someEndDate)# Much better. G! > On Thu, Dec 17, 2009 at 10:06 AM, Damo Drumm > wrote: > >> >> Hi im having some bother trying to ge

Re: Searching a Date Range

2009-12-17 Thread Gerald Guido
I just happened to have some code open... SELECT blah FROM tblCalendar WHERE EventDate BETWEEN#CreateODBCDate(someStartDate)# repeat AND #CreateODBCDate(someEndDate)# The start and end dates can come from your form values... With CFQueryparam of course. ;) HTH G! On Thu, Dec

RE: array question

2009-12-17 Thread DURETTE, STEVEN J (ATTASIAIT)
Ben, Do an arraylen on the first row. arrayLen(myVar[1]) That will return the number of columns or planes. Steve -Original Message- From: Ben Conner [mailto:b...@webworldinc.com] Sent: Thursday, December 17, 2009 11:08 AM To: cf-talk Subject: array question Hi, Haven't played muc

array question

2009-12-17 Thread Ben Conner
Hi, Haven't played much with arrays but having reviewed how they work, I have a question that I can't find an answer to: Given a 2 or 3 dimensional array, how do you determine the # of columns or planes in an array? If you reference a column that isn't defined, CF throws an error. But I don

RE: deadlocks

2009-12-17 Thread Chad Gray
Thanks Tom, I found this article on trouble shooting deadlocks and it was quite helpful. I think I need to create an index on the table. http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx In step 4 of the article I ran the Analyze Query in DTA and its rec

Re: deadlocks

2009-12-17 Thread Tom Chiverton
On Thursday 17 Dec 2009, Chad Gray wrote: > I have a feeling in need to optimize my data and not the CF code. Making it run faster will not stop you getting deadlocks (entangled pairs of conflicting transactions). It might reduce the frequency of them, however. You really need to establish who/

Searching a Date Range

2009-12-17 Thread Damo Drumm
Hi im having some bother trying to get a search by date range working on a form in coldfusion. does anyone have any tips on setting this up? It would be greatly appreciated ~| Want to reach the ColdFusion community with someth

deadlocks

2009-12-17 Thread Chad Gray
Hello, I have one page that loops over form variables analyzes the variables and with cfif statements makes decisions on whether to do a SQL update, delete or insert and I occasionally get SQL deadlocks. Transaction (Process ID 51) was deadlocked on lock | communication buffer resources with a

Re: Problem in launching MultiserverMonitor

2009-12-17 Thread Tom Chiverton
On Thursday 17 Dec 2009, Sigi Heckl wrote: > if I try a longer password the button text changes to "Set new > password" Did you press that button ? -- Helping to professionally fashion fourth-generation materials as part of the IT team of the year, '09 and '08 ***

RE: Basic user stats via Coldfusion

2009-12-17 Thread DURETTE, STEVEN J (ATTASIAIT)
Well, if this is for a company intranet, go into iis and turn on the nt authentication box. You can leave anonymous checked, but I did have one time where just checking the box made the data available. That was a long time ago and I don't remember what version of IIS it was. Steve -Origi

Problem in launching MultiserverMonitor

2009-12-17 Thread Sigi Heckl
Every time I try to open the MultiserverMonitor in ColdFusionMX8 I am prompted to type in a master password. When I enter a word with less than 4 characters I get a message "Password should be at least 4 characters long". But if I try a longer password the button text changes to "Set new passwo

RE: cfwindow parent refresh

2009-12-17 Thread Andrew Scott
There is a number of ways you can do this, but the most simplest would be for you to return the comment back to the cfwindow with a button to continue/close the window. But more importantly the cfwindow is just a div inside the document, so you could do a document.href =""; to do what you might w

RE: Basic user stats via Coldfusion

2009-12-17 Thread Ian Vaughan
Hi Steve I have looked in the IIS logs but for some reason the 'cs-username' field is not being populated? Any ideas why this may be the case? Ian -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: 15 December 2009 16:54 To: cf-talk Subject: RE: Basic

RE: Basic user stats via Coldfusion

2009-12-17 Thread Ian Vaughan
Hi Steve I have looked in the IIS logs but for some reason the 'cs-username' field is not being populated? Any ideas why this may be the case? -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: 15 December 2009 16:54 To: cf-talk Subject: RE: Basic user

RE: Basic user stats via Coldfusion

2009-12-17 Thread Ian Vaughan
Hi Agha Thanks for the info do you have any sample script that you could share so I can see how best to construct the query to capture user details? -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: 15 December 2009 21:55 To: cf-talk Subject: Re: Basic user stats v

RE: Null Pointers are another name for undefined values

2009-12-17 Thread Sebastiaan GMC van Dijk
Yes, we've had this same error popping up at times. It is most often in combination with MySQL. We got our hosting party to UNCHECK the 'maintain connections across client requests'. We then got a new error from time to time, namely that user 'dbuser' has exceeded the 'max_user_connections' r

cfwindow parent refresh

2009-12-17 Thread Sebastian Powell
Hi, I have a cfwindow that does the following: 1) receives some url variables 2) user can input a comment or text in a form within the cfwindow 3) on submit in the cfwindow it updates the comment in the database 4) confirmation message that submitted and option to close the cfwindow Issue: I am