cfwindow parent refresh
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 trying to show the updated comment on the parent page once the cfwindow has closed, thinking either I refresh the parent page on close or update a form variable on the parent page with the posted comment. would anyone have an example of how i may do the above? Thanks, Sebastian. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329213 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Null Pointers are another name for undefined values
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' resource (current value = 1). No idea where to look for this error, but at least it solved the Nullpointer exceptions errors. Maybe also our recent upgrade to the latest update of CF8 also has helped some. Sebastiaan Naafs van Dijk = So long and thanx 4 all the fish == Onlinebase.nl Date: Wed, 16 Dec 2009 23:11:31 -0500 Subject: Re: Null Pointers are another name for undefined values From: police_kidnapped_your_child...@yahoo.com To: cf-talk@houseoffusion.com I've gotten this error before. I don't know if this is the same thing or not, but in my case, I got the null pointers error only on the application start, a refresh would make it work. anyway, it took me a few weeks, but the solution (at least in my case) was either checking or unchecking (i can never remember which... so just the opposite of whatever it is now) the maintain connections box in the coldfusion admin under database connections. I had to call my hosting company to get it done, but they complied and I have never had the problem since. HTH! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329214 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Basic user stats via Coldfusion
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 via Coldfusion Ian, We track user activity in the db. this is the best approach I can think of. I'd just keep inserting every hit for every page from onRequestEnd method in Application.cfc. In your case, you can do it in Application.cfm. That will give you a lot of flexibility when creating reports. Currently our UserActivity table holds about 50M records. I have another process running every day, which normalizes the URLs and separate out key-value pairs for faster searching on URL variables example: keywords, page ids etc. Thanks Agha On Tue, Dec 15, 2009 at 1:42 PM, Jason Durham jdur...@cti-stl.com wrote: You could capture the CGI variables on onRequestStart and insert them into the DB onSessionEnd. You will lose data on server restarts for active sessions. -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Tuesday, December 15, 2009 10:54 AM To: cf-talk Subject: RE: Basic user stats via Coldfusion Ian, This sounds like you should be looking at the webserver logs. If you are using IIS, you can have it log the Windows Login info in the IIS logs. I don't know if Apache can or not. Then you can use something like LOG Parser from Microsoft to search the log files just like you would with a database. Steve -Original Message- From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk] Sent: Tuesday, December 15, 2009 11:47 AM To: cf-talk Subject: RE: Basic user stats via Coldfusion Hi Jason All I am trying to do is track what url's on our Intranet a unique user accesses each day. There could be a couple of hundred pages. The problem with most analytics software is that they do not capture the user's windows logon/network ID so we can identify exactly who is viewing what on the Intranet. Analytic software such as Google just captures a users IP address which is dynamic and changes each day so we can't tell what employees are accessing certain areas of the Intranet. It would be great if Coldfusion could help provide a solution for this ot if anybody knows of any analytical software that would capture this information? -Original Message- From: Jason Durham [mailto:jdur...@cti-stl.com] Sent: 07 December 2009 17:32 To: cf-talk Subject: RE: Basic user stats via Coldfusion Am I properly restating this... You want to track what pages each user hits in a day. How many pages are we talking about? Couple dozen? Couple hundred? Couple thousand? -Original Message- From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk] Sent: Monday, December 07, 2009 11:06 AM To: cf-talk Subject: Basic user stats via Coldfusion On our intranet I have a coldfusion script that captures a user's network/loginid cfset user = listLast(cgi.REMOTE_USER,\) This variable is then run against a user table with the following 'where' clause WHERE uPPER(NETWORK_ID) = '#ucASE(user)#' This then captures user info such as Loginid Name Job Title Department IP address etc How would you restrict the query so it only runs once on each page per day for each user, instead of running every time the page is loaded? And where would this query be better placed, as I don't really want to include it in each page manually. Any ideas would be welcome? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329215 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Basic user stats via Coldfusion
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 stats via Coldfusion Ian, This sounds like you should be looking at the webserver logs. If you are using IIS, you can have it log the Windows Login info in the IIS logs. I don't know if Apache can or not. Then you can use something like LOG Parser from Microsoft to search the log files just like you would with a database. Steve -Original Message- From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk] Sent: Tuesday, December 15, 2009 11:47 AM To: cf-talk Subject: RE: Basic user stats via Coldfusion Hi Jason All I am trying to do is track what url's on our Intranet a unique user accesses each day. There could be a couple of hundred pages. The problem with most analytics software is that they do not capture the user's windows logon/network ID so we can identify exactly who is viewing what on the Intranet. Analytic software such as Google just captures a users IP address which is dynamic and changes each day so we can't tell what employees are accessing certain areas of the Intranet. It would be great if Coldfusion could help provide a solution for this ot if anybody knows of any analytical software that would capture this information? -Original Message- From: Jason Durham [mailto:jdur...@cti-stl.com] Sent: 07 December 2009 17:32 To: cf-talk Subject: RE: Basic user stats via Coldfusion Am I properly restating this... You want to track what pages each user hits in a day. How many pages are we talking about? Couple dozen? Couple hundred? Couple thousand? -Original Message- From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk] Sent: Monday, December 07, 2009 11:06 AM To: cf-talk Subject: Basic user stats via Coldfusion On our intranet I have a coldfusion script that captures a user's network/loginid cfset user = listLast(cgi.REMOTE_USER,\) This variable is then run against a user table with the following 'where' clause WHERE uPPER(NETWORK_ID) = '#ucASE(user)#' This then captures user info such as Loginid Name Job Title Department IP address etc How would you restrict the query so it only runs once on each page per day for each user, instead of running every time the page is loaded? And where would this query be better placed, as I don't really want to include it in each page manually. Any ideas would be welcome? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329216 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Basic user stats via Coldfusion
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 user stats via Coldfusion Ian, This sounds like you should be looking at the webserver logs. If you are using IIS, you can have it log the Windows Login info in the IIS logs. I don't know if Apache can or not. Then you can use something like LOG Parser from Microsoft to search the log files just like you would with a database. Steve -Original Message- From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk] Sent: Tuesday, December 15, 2009 11:47 AM To: cf-talk Subject: RE: Basic user stats via Coldfusion Hi Jason All I am trying to do is track what url's on our Intranet a unique user accesses each day. There could be a couple of hundred pages. The problem with most analytics software is that they do not capture the user's windows logon/network ID so we can identify exactly who is viewing what on the Intranet. Analytic software such as Google just captures a users IP address which is dynamic and changes each day so we can't tell what employees are accessing certain areas of the Intranet. It would be great if Coldfusion could help provide a solution for this ot if anybody knows of any analytical software that would capture this information? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329217 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfwindow parent refresh
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 want to achieve. -Original Message- From: Sebastian Powell [mailto:bas...@gmail.com] Sent: Thursday, 17 December 2009 8:31 PM To: cf-talk Subject: cfwindow parent refresh 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 trying to show the updated comment on the parent page once the cfwindow has closed, thinking either I refresh the parent page on close or update a form variable on the parent page with the posted comment. would anyone have an example of how i may do the above? Thanks, Sebastian. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329218 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Problem in launching MultiserverMonitor
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 password and a hint No master password has been set appears. So I can't reach the MultiserverMonitor! What am I doing wrong??? Thanks in advance for your suggestions... Regards, Sigi ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329219 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Basic user stats via Coldfusion
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 -Original Message- From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk] Sent: Thursday, December 17, 2009 6:01 AM To: cf-talk Subject: RE: Basic user stats via Coldfusion 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 user stats via Coldfusion Ian, This sounds like you should be looking at the webserver logs. If you are using IIS, you can have it log the Windows Login info in the IIS logs. I don't know if Apache can or not. Then you can use something like LOG Parser from Microsoft to search the log files just like you would with a database. Steve -Original Message- From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk] Sent: Tuesday, December 15, 2009 11:47 AM To: cf-talk Subject: RE: Basic user stats via Coldfusion Hi Jason All I am trying to do is track what url's on our Intranet a unique user accesses each day. There could be a couple of hundred pages. The problem with most analytics software is that they do not capture the user's windows logon/network ID so we can identify exactly who is viewing what on the Intranet. Analytic software such as Google just captures a users IP address which is dynamic and changes each day so we can't tell what employees are accessing certain areas of the Intranet. It would be great if Coldfusion could help provide a solution for this ot if anybody knows of any analytical software that would capture this information? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329220 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem in launching MultiserverMonitor
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 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329221 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
deadlocks
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 another process and has been chosen as the deadlock victim. Rerun the transaction. On the SQL deadlocks do I need to optimize my CF code to avoid them, or optimize my database? Or both? I just took out all of the evaluates() in the CF code. Anything else I can do on the page to make it run better and avoid deadlocks? The table has 300,000 records, a primary and foreign key and 9 columns. I have a feeling in need to optimize my data and not the CF code. Any input is appreciated! Thanks, Chad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329222 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Searching a Date Range
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 something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329223 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: deadlocks
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/what is making the changes under you, and use a suitable locking strategy to mitigate it. -- Helping to confidentially entrench error-free innovative slick back-end customers as part of the IT team of the year, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329224 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: deadlocks
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 recommendation was to create an index. At least I think that is what it is telling me. DTA had this T-SQL in the definition CREATE NONCLUSTERED INDEX [_dta_index_JobTicketColor_5_662345474__K2_K3_1] ON [dbo].[JobTicketColor] ( [JobTicketID] ASC, [ColorName] ASC ) INCLUDE ( [JobTicketColorID]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY] I will read up on what this T-SQL is doing before running it. -Original Message- From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] Sent: Thursday, December 17, 2009 10:17 AM To: cf-talk Subject: Re: deadlocks 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/what is making the changes under you, and use a suitable locking strategy to mitigate it. -- Helping to confidentially entrench error-free innovative slick back-end customers as part of the IT team of the year, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329225 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
array question
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't find a function that returns the # of columns or planes, unlike arraylen() which returns the # of rows. Thanks...! --Ben -- Ben Connerb...@webworldinc.com Web World, Inc. 888-206-6486 PO Box 1122 480-704-2000 Queen Creek, AZ 85242 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329226 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: array question
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 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't find a function that returns the # of columns or planes, unlike arraylen() which returns the # of rows. Thanks...! --Ben -- Ben Connerb...@webworldinc.com Web World, Inc. 888-206-6486 PO Box 1122 480-704-2000 Queen Creek, AZ 85242 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329227 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Searching a Date Range
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 17, 2009 at 10:06 AM, Damo Drumm damien.dr...@quinn-group.comwrote: 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 something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329228 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Searching a Date Range
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 damien.dr...@quinn-group.com wrote: 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 something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329229 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Searching a Date Range
With queryparam you don't need the createODBCDate() function: SELECT blah FROM tblCalendar WHERE EventDate BETWEENcfqueryparam cfsqltype=CF_SQL_DATE value=#form.someStartDate# / AND cfqueryparam cfsqltype=CF_SQL_DATE value=#form.someEndDate# / 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: cfset endDate = dateAdd(d, 1, form.someEndDate) / and then use that in the query: ... AND cfqueryparam cfsqltype=CF_SQL_DATE value=#endDate# / ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329230 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF/Java assistance; Path questions
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 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329231 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Searching a Date Range
Ah... learn something new everyday. Good to know. G! On Thu, Dec 17, 2009 at 12:10 PM, Jason Fisher ja...@wanax.comAh... learn something wrote: With queryparam you don't need the createODBCDate() function: SELECT blah FROM tblCalendar WHERE EventDate BETWEENcfqueryparam cfsqltype=CF_SQL_DATE value=#form.someStartDate# / AND cfqueryparam cfsqltype=CF_SQL_DATE value=#form.someEndDate# / 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: cfset endDate = dateAdd(d, 1, form.someEndDate) / and then use that in the query: ... AND cfqueryparam cfsqltype=CF_SQL_DATE value=#endDate# / ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329232 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Searching a Date Range
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: cfset endDate = dateAdd(d, 1, form.someEndDate) / Yes, though the safest option is using a = and comparison since BETWEEN is inclusive. !--- omitted cfqueryparam for brevity --- WHERE EventDate = #startDate# ANDEventDate #dayAfterTheFormEndDate# -Leigh ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329233 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Searching a Date Range
!--- omitted cfqueryparam for brevity --- WHERE EventDate = #startDate# AND EventDate #dayAfterTheFormEndDate# Whoops, typo there. That should be EventDate = WHERE EventDate = #startDate# ANDEventDate #dayAfterTheFormEndDate# ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329234 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: array question
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]) 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 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't find a function that returns the # of columns or planes, unlike arraylen() which returns the # of rows. Thanks...! --Ben -- Ben Connerb...@webworldinc.com Web World, Inc. 888-206-6486 PO Box 1122 480-704-2000 Queen Creek, AZ 85242 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329235 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: array question
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 [mailto:b...@webworldinc.com] Sent: Thursday, December 17, 2009 11:08 AM To: cf-talk Subject: array question 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't find a function that returns the # of columns or planes, unlike arraylen() which returns the # of rows. Thanks...! --Ben -- Ben Connerb...@webworldinc.com Web World, Inc. 888-206-6486 PO Box 1122 480-704-2000 Queen Creek, AZ 85242 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329236 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: array question
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...@att.com 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 [mailto:b...@webworldinc.com] Sent: Thursday, December 17, 2009 11:08 AM To: cf-talk Subject: array question 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't find a function that returns the # of columns or planes, unlike arraylen() which returns the # of rows. Thanks...! --Ben -- Ben Connerb...@webworldinc.com Web World, Inc. 888-206-6486 PO Box 1122 480-704-2000 Queen Creek, AZ 85242 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329237 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
onclick refresh cfdiv
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 Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329238 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Server Performance
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 requests will max out from time to time and then requests start to queue. I want to be able to determine which sites are generating the most requests so I can examine the traffic and the code on those sites for potential problems. Anybody know of any way to do this? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329239 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Server Performance
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, webmas...@pegweb.com 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 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 requests will max out from time to time and then requests start to queue. I want to be able to determine which sites are generating the most requests so I can examine the traffic and the code on those sites for potential problems. Anybody know of any way to do this? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329240 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server Performance
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 andr...@andyscott.id.au Date: Thu, December 17, 2009 6:52 pm To: cf-talk cf-talk@houseoffusion.com As you are not running ColdFusion Enterprise your best bet would be http://www.fusion-reactor.com/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329241 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: onclick refresh cfdiv
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. Sebastian ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329242 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
