RE: Coldfusion Crashing!
Thanks a lot for all your help guys. After struggling two days/nights and done all the audit etc. I sort of gave up and upgraded to MX6.1. It hasn't really fixed the problem as such but the number of crashes has been significantly reduced. I've found out in the application, some third party calls to Visual Fox pro (ODBC) and pages using OPENQUERY 've been causing the crash at peak hours when the server running that Fox Pro application is quite busy and not responding in timely fashion. Coldfusion5.0 was just hanging in there and waiting probably forever for that thread to respond - result ofcourse crash after few minutes. However MX is taking care of that side and takes a significant amount of unresponsive threads before it crashes (3 or 4 times) a day. Now I am going through the code and trying to avoid the OPENQUERY and also unnecessary calls to the fox pro DB. 've a great weekend!! Shaz -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: 05 July 2005 22:16 To: CF-Talk Subject: Re: Coldfusion Crashing! The issues Jennifer and Steven brought up were pretty much spot on. If you have something hanging a request and you pile on simultaneous requests that will do nothing to address the bottleneck. I would do things a little differently but the same basic principles apply. First of all, I'm going to assume this is a crisis situation, and you need at least a resemblence of stability first and diagnosis/correction can follow, so long as you stop the system from dying. First, REDUCE the number of simultaneous threads to as low of a number as you can, with one being the minimum and the most stable setting. Just because its more likely to be stable doesn't mean it will perform 'well'. This will indeed introduce a performance bottleneck, but its meant to. When in crisis mode this is often the way to stabilize a server in an emergency, letting it run long enough to work towards a fix while users get to keep using it. Be careful (i.e. watch it while this is going on to make sure you have not created a new problem). Still, only the busiest box will time threads out that are queued as the result of this. Next enable a CF restart after X threads have hung, where the restart value is one LESS than the value set in the first step above. Set the hung thread count higher than the simultaneous request count and it will never fire. In an emergency situation I would set this to one (1) thread. Again, pay close attention to what is going on because the only thing worse than a CF box that keeps dying is one that restarts itself every 15 seconds. Yes, this is aggressive but if you get even one hung thread chances are by the time the second one arrives CF will be done for and no longer able to restart itself without human intervention. Next, enable the tracking of long-running page requests. If the above two steps have stabilized your server enough so it can run (bearing in mind that each or the two in tandem can make things worse for a heavy-traffic box), this remains an excellent tool for debugging, despite its noted weaknesses. lastly, be sure to check your mail spool file. What is being described sounds a lot like that problem. I ran into it on a CF5 box a few months back and CF was dying and as soon as it got started up again it instantly croaked until I remembered this problem, checked for it and deleted the offending file (you have to stop the CF service first or the file will be locked and is undeletable. HtH, -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211415 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Coldfusion Crashing!
Hi all, I am running Coldfusion 5.0 on Windows 2000 machine using SQL Server 2000. The system has been working fine for last couple of years and never had any issue however since yesterday the Coldfusion server is crashing and I've to restart all the Coldfusion Services to get my Intranet (or any other Coldfusion app) work. There's been no apparent cause and nothing is in the log files either apart from just one error (100s of times) in Webserver.log file, the error goes like Error,3068,07/05/05,11:18:47,,Request canceled or ignored by server Server busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) Any help is highly appreciated!! Thanks, Shaz +44 7985 884 474 ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211120 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Coldfusion Crashing!
Doubled (previously 10 now 20) the number of simultaneous requests through Coldfusion Administrator interface but still the same problem. Any ideas?? Thanks, Shaz -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 05 July 2005 11:39 To: CF-Talk Subject: RE: Coldfusion Crashing! Looks like your system has reached the maximum # of simultaneous requests - try upping it via the CFIDE. -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 05 July 2005 11:36 To: CF-Talk Subject: Coldfusion Crashing! Hi all, I am running Coldfusion 5.0 on Windows 2000 machine using SQL Server 2000. The system has been working fine for last couple of years and never had any issue however since yesterday the Coldfusion server is crashing and I've to restart all the Coldfusion Services to get my Intranet (or any other Coldfusion app) work. There's been no apparent cause and nothing is in the log files either apart from just one error (100s of times) in Webserver.log file, the error goes like Error,3068,07/05/05,11:18:47,,Request canceled or ignored by server Server busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) Any help is highly appreciated!! Thanks, Shaz +44 7985 884 474 ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211127 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
XML from CF
I got .cfm file with some CF code (query and output) in it. A third party application needs to read the XML file (containing same code but in XML format). How can get that coldfusion file to output in XML? Thanks, Shaz ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193594 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Storing CGI vars in text file using HTTP Post
Hi I am trying to use HTTP POST to send the cgi vars to a cfm file which store all the cgi vars in a text file. But the text file has all those % in it. My code is as follows cfhttp method = post url = ""> cfhttpparam name = cgiVar type = CGI value = CGI.AUTH_TYPE:#CGI.AUTH_TYPE# -- CGI.CONTENT_LENGTH:#CGI.CONTENT_LENGTH# -- CGI.CONTENT_TYPE:#CGI.CONTENT_TYPE# -- CGI.PATH_INFO:#CGI.PATH_INFO# -- CGI.PATH_TRANSLATED:#CGI.PATH_TRANSLATED# CGI.QUERY_STRING:#CGI.QUERY_STRING# -- CGI.REMOTE_ADDR:#CGI.REMOTE_ADDR# -- CGI.REMOTE_HOST:#CGI.REMOTE_HOST# #CGI.REMOTE_USER# #CGI.REQUEST_METHOD# #CGI.SCRIPT_NAME# #CGI.GATEWAY_INTERFACE# #CGI.SERVER_NAME# #CGI.SERVER_PORT# #CGI.SERVER_PROTOCOL# #CGI.SERVER_SOFTWARE# #CGI.CERT_ISSUER# #CGI.CERT_SUBJECT# #CGI.CLIENT_CERT_ENCODED# #CGI.HTTP_ACCEPT# #CGI.HTTP_IF_MODIFIED_SINCE# #CGI.HTTP_USER_AGENT# /cfhttp Test.cfm cffile action="" file=C:\HTTPTest.txt output= [#DateFormat(Now())# #TimeFormat(Now())#] CGI Vars from file are: #CGI.cgiVar# Is there any other better way of doing it? Shaz ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Storing CGI vars in text file using HTTP Post
Great thanks _ From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: 16 September 2004 12:14 To: CF-Talk Subject: RE: Storing CGI vars in text file using HTTP Post Use type=formfield and then #form.cgiVar# in the other page Pascal http://www.houseoffusion.com/banners/view.cfm?bannerid=38 ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Assigning value to property using COM
I am using COM and trying to assign a value to the property. In the code below the lines with *** is VB code and the line beneath is coldfusion equivalent of that line. Set Axapta = CreateObject(AxaptaCOMConnector.Axapta) cfobject action="" class=#Attributes.ProgId# type=COM name=AXCom ***Axapta.Logon*** CFSet a = Axapta.Logon() *** MyRecord = Axapta.CreateRecord(CCMCTIInbound)*** CFSet myRecord = Axapta.CreateRecord(CCMCTIInbound) ***MyRecord.field(UserID) = Shaz*** CFSet myRecord.field(UserID) = Shaz The line above (in bold) throws an error saying Unable to assign a value to the function field on line 16, column 16. Which is pretty obvious that we cant assign a value to function though in VB we could do it as it's a property. Is there any work around for that. Thanks Shaz ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
COM Problem
I wonder if someone can write me the Coldfusion Code for the following VB Code. Sub CreateCall() Dim MyRecord As Object Set Axapta = CreateObject(AxaptaCOMConnector.Axapta) Axapta.Logon Set MyRecord = Axapta.CreateRecord(CCMCTIInbound) MyRecord.InitValue MyRecord.field(UserID) = gp1 MyRecord.field(Number) = MyRecord.Insert Axapta.Logoff End Sub I can only write the first line cfobject action="" class=#Attributes.ProgId# type=COM name= Axapta Thanks Shaz ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Delete problem
I know its more of sql problem. I want to delete just one row of ProductCode appearing twice in EPIC table. EPIC ProductCodecostsell supplier CHP034 2 ABC CHP033 2 DEF ... I just want to delete one CHP03 so I will still have atleast one in my table. Any suggestions? ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Delete problem
Can't do that as I have thousands of products with different cost prices. I was just giving an example. This query finds out all the product codes which appear more than once select ProductCode from EPIC group by ProductCode Having Count(ProductCode) 1 But this query DELETE FROM EPIC WHERE ProductCode IN ( select ProductCode from EPIC group by ProductCode Having Count(ProductCode) 1 ) Will delete all the ones appearing more than once. I want it to leave one row for each product code appearing more than once. Shaz _ From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 08 September 2004 11:08 To: CF-Talk Subject: Re: Delete problem Do the same as a select, so DELETE FROM EPIC WHERE ProductCode = 'CHP03' AND cost = 3 MD On Wed, 8 Sep 2004 11:04:24 +0100, Shahzad.Butt [EMAIL PROTECTED] wrote: I know its more of sql problem. I want to delete just one row of ProductCode appearing twice in EPIC table. EPIC ProductCodecostsell supplier CHP034 2 ABC CHP033 2 DEF ... I just want to delete one CHP03 so I will still have atleast one in my table. Any suggestions? ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Delete problem
Can't do that as I have thousands of products with different cost prices. I was just giving an example. This query finds out all the product codes which appear more than once select ProductCode from EPIC group by ProductCode Having Count(ProductCode) 1 But this query DELETE FROM EPIC WHERE ProductCode IN ( select ProductCode from EPIC group by ProductCode Having Count(ProductCode) 1 ) Will delete all the ones appearing more than once. I want it to leave one row for each product code appearing more than once. _ From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 08 September 2004 11:08 To: CF-Talk Subject: Re: Delete problem Do the same as a select, so DELETE FROM EPIC WHERE ProductCode = 'CHP03' AND cost = 3 MD On Wed, 8 Sep 2004 11:04:24 +0100, Shahzad.Butt [EMAIL PROTECTED] wrote: I know its more of sql problem. I want to delete just one row of ProductCode appearing twice in EPIC table. EPIC ProductCodecostsell supplier CHP034 2 ABC CHP033 2 DEF I just want to delete one CHP03 so I will still have atleast one in my table. Any suggestions? ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Delete problem
Thanks everyone. I have used some CF to do so cfquery name=Get datasource=EPICCleanerDSN SELECT * FROMItemsMissingFields ORDER BY Code /cfquery cfoutput query=Get cfquery name=getcode datasource=EPICCleanerDSN select code from ItemsMissingFields where id = #get.id# /cfquery cfquery name=checkifduplicate datasource=EPICCLeanerDSN Select Count(*) mycount From itemsmissingfields where code = '#getcode.code#' /cfquery CFIF checkifDuplicate.mycount GT 1 cfquery name=DeleteDuplicates datasource=EPICCleanerDSN DELETE FROM ItemsMissingFields WHERE ID = '#get.id#' /cfquery DELETE FROM ItemsMissingFields WHERE ID = '#get.id#' br /CFIF /cfoutput _ From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 08 September 2004 12:32 To: CF-Talk Subject: Re: Delete problem Not fully though out.. but .. could you not select the distinct by ProductCode into a new table (so it just gets the first instance?) MD On Wed, 8 Sep 2004 12:22:01 +0100, Michael Traher [EMAIL PROTECTED] wrote: I don't think so although my thinking went down this road as well It does not work because the product code is the part that repeats, so I think this would delete zero rows - Original Message - From: Adrian Lynch [EMAIL PROTECTED] Date: Wed, 8 Sep 2004 11:59:06 +0100 Subject: RE: Delete problem To: CF-Talk [EMAIL PROTECTED] DELETE FROM EPIC WHERE ProductCode IN ( SELECT ProductCode FROM EPIC GROUP BY ProductCode HAVING COUNT(ProductCode) 1 ) AND ProductCode ( SELECT TOP 1 ProductCode FROM EPIC GROUP BY ProductCode HAVING COUNT(ProductCode) 1 ) Would that do it? Ade -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 08 September 2004 11:18 To: CF-Talk Subject: RE: Delete problem Can't do that as I have thousands of products with different cost prices. I was just giving an example. This query finds out all the product codes which appear more than once select ProductCode from EPIC group by ProductCode Having Count(ProductCode) 1 But this query DELETE FROM EPIC WHERE ProductCode IN ( select ProductCode from EPIC group by ProductCode Having Count(ProductCode) 1 ) Will delete all the ones appearing more than once. I want it to leave one row for each product code appearing more than once. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Delete problem
Thanks everyone. I have used some CF to do so cfquery name=Get datasource=EPICCleanerDSN SELECT * FROMItemsMissingFields ORDER BY Code /cfquery cfoutput query=Get cfquery name=getcode datasource=EPICCleanerDSN select code from ItemsMissingFields where id = #get.id# /cfquery cfquery name=checkifduplicate datasource=EPICCLeanerDSN Select Count(*) mycount From itemsmissingfields where code = '#getcode.code#' /cfquery CFIF checkifDuplicate.mycount GT 1 cfquery name=DeleteDuplicates datasource=EPICCleanerDSN DELETE FROM ItemsMissingFields WHERE ID = '#get.id#' /cfquery DELETE FROM ItemsMissingFields WHERE ID = '#get.id#' br /CFIF /cfoutput ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Delete problem
Thanks everyone. I have used some CF to do so cfquery name=Get datasource=EPICCleanerDSN SELECT * FROMItemsMissingFields ORDER BY Code /cfquery cfoutput query=Get cfquery name=getcode datasource=EPICCleanerDSN select code from ItemsMissingFields where id = #get.id# /cfquery cfquery name=checkifduplicate datasource=EPICCLeanerDSN Select Count(*) mycount From itemsmissingfields where code = '#getcode.code#' /cfquery CFIF checkifDuplicate.mycount GT 1 cfquery name=DeleteDuplicates datasource=EPICCleanerDSN DELETE FROM ItemsMissingFields WHERE ID = '#get.id#' /cfquery /CFIF /cfoutput Shaz ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Javascript window.opener error
I am trying to populate a select box in FORM1 from a window which is originally opened by this form (FORM1). My browser is throwing error for some reason. I wonder if someone can tell me whats wrong with the following code? function PopulateLocality() { with (window.opener.document.forms[0]) { locality.options.length=0; for (var i = 0; i Locality.getRowCount(); i++) { locality.options[i]= new Option(Locality.alias_name[i],Locality.id[i]); } } } When I try to populate the select box in the same window not the parent then it works fine but that's not what I want Thanks Shaz ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Desc Output
How can I output the results of the query starting from last record found by query and finishing at starting record found? Can't change the Order by from Desc to Asc in the query because of loads of reasons. Thanks Shaz ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: XML load
Following is the code cfhttp url=""> license_code=XE47-EP93-RD59-GW24action=""> tcode=EN8%208RZ method=GET resolveUrl=false /cfhttp cfoutput cfxml variable=myxml rootelement#cfhttp.filecontent#/rootelement /cfxml cfdump var=#myxml# /cfoutput It shows no contents in the browser however if you just open the URL in the browser you can see the file. Is there anything I am missing or doing wrong? Shaz _ From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: 26 July 2004 18:21 To: CF-Talk Subject: Re: XML load You probably will need to do something like this to parse it cfxml variable=myxml rootelement#mypacket#/rootelement /cfxml I believe (though I could be mistaken) that error indicates that there are multiple tag-pairs at the root. Valid XML must have only one tag-pair at the root with all other elements contained within them. On Monday 26 Jul 2004 15:51 pm, Shahzad.Butt wrote: On CFMX6.1 it gives error Document root element is missing. It probably is. What are the first few lines of the XML string ? -- Tom Chiverton Advanced ColdFusion Programmer _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: XML load
Thanks everyone. I think it must be the CFMX version causing issues because I have run the code on new server (with fresh CFMX installation) and it works fine. Thanks Shaz _ From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: 27 July 2004 13:17 To: CF-Talk Subject: RE: XML load I ran your code and it worked perfectly. You don't even need the rootelement tag (there is one). Make sure you don't suppress the output somehow. Pascal -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 27 July 2004 12:07 To: CF-Talk Subject: RE: XML load Following is the code cfhttp url=""> license_code=XE47-EP93-RD59-GW24action=""> tcode=EN8%208RZ method=GET resolveUrl=false /cfhttp cfoutput cfxml variable=myxml rootelement#cfhttp.filecontent#/rootelement /cfxml cfdump var=#myxml# /cfoutput _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
XML load
Hi How can I load an XML file and display the contents on my CFM page i.e. there is an XML file at (lets say http://www.abc.com/test.xml). How can I get the data from this file and loop over a particular item in my CFM page? Thanks Shaz ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: XML load
Will XMLParse() work on CF5.0? currently its giving an error on CF5.0. On CFMX6.1 it gives error Document root element is missing. Any ideas on that? Shaz _ From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: 26 July 2004 15:47 To: CF-Talk Subject: Re: XML load XMLTransform ... duh... :) You can see how much I've used it. :) On Monday 26 Jul 2004 15:25 pm, S. Isaac Dealey wrote: also XMLTranslate() (?) I think that's the name of the XSLT function... Well, yes :-) If the question hadn't so specific, I'd have pointed at http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/fun cti20.htm#wp3468770 and http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/xml .htm -- Tom Chiverton Advanced ColdFusion Programmer s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: XML load
- http://services.postcodeanywhere.co.uk/xml.aspx?account_code=JJFAS1 license_code=XE47-EP93-RD59-GW24action=""> e=EN8%208RZ## PostcodeAnywhere Server=WS02 Version=2.0 Date=26/07/2004 14:35:22 Duration=0.016s - http://services.postcodeanywhere.co.uk/xml.aspx?account_code=JJFAS1 license_code=XE47-EP93-RD59-GW24action=""> e=EN8%208RZ##Schema Items=3 Field Name=id / Field Name=seq / Field Name=description / /Schema - http://services.postcodeanywhere.co.uk/xml.aspx?account_code=JJFAS1 license_code=XE47-EP93-RD59-GW24action=""> e=EN8%208RZ##Data Items=40 Item id=29512157 seq=0 description=1 Westgate Court Waltham Cross EN8 8OL / Item id=29512196 seq=39 description=40 Westgate Court Waltham Cross EN8 8OL / /Data /PostcodeAnywhere _ From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 26 July 2004 16:03 To: CF-Talk Subject: Re: XML load On Monday 26 Jul 2004 15:51 pm, Shahzad.Butt wrote: On CFMX6.1 it gives error Document root element is missing. It probably is. What are the first few lines of the XML string ? -- Tom Chiverton Advanced ColdFusion Programmer _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Hidden Varaibles
Hi - I know its more of a JS question than CF but I wonder if someone can help me out. In my _javascript_ function I am assigning values to the form variable. All I need is an IF statement that if the form variable is hidden variable then don't assign anything. So in short I need to find out the way in JS that if the variable is hidden form variable... Thanks Shaz ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Hidden Varaibles
Hi - I know its more of a JS question than CF but I wonder if someone can help me out. In my _javascript_ function I am assigning values to the form variable. All I need is an IF statement that if the form variable is hidden variable then don't assign anything. So in short I need to find out the way in JS that if the variable is hidden form variable... Thanks Shaz ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Hidden Varaibles
Thanks Pascal - yeah I meant hidden form field. Cheers! shaz _ From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: 29 June 2004 10:04 To: CF-Talk Subject: RE: Hidden Varaibles Error in my previous mail: if(document.myform.myfield.type != hidden) { Pascal _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Evaluate?
Hello - can you please check the code below CFSet GetAllContactTypes.PK_ContactType_ID = CAA07070-CD2A-46D6-951F-653630BFD539 cfoutput CFSet a = #Evaluate(Form.#GetAllContactTypes.PK_ContactType_ID#)# /cfoutput Its giving error though from the previous page value of form variable named CAA07070-CD2A-46D6-951F-653630BFD539 is passed to this page. Error Diagnostic Information An error occurred while evaluating the _expression_: a = #Evaluate(Form.#GetAllContactTypes.PK_ContactType_ID#)# Error near line 10, column 18. _ An error has occurred while processing the _expression_: Form.CAA07070-CD2A-46D6-951F-653630BFD539 Invalid parser construct found on line 1 at position 22. ColdFusion was looking at the following text: D6 Form Fields: 02E4F04B-4893-442D-AEAB-859F607B52B1= 02F2DF44-7063-4217-9052-C5E4179CBC73= CAA07070-CD2A-46D6-951F-653630BFD539=fdf ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Evaluate?
Good job - thx CFSET a = Form[GetAllContactTypes.PK_ContactType_ID] works Shaz _ From: JediHomer [mailto:[EMAIL PROTECTED] Sent: 24 June 2004 10:58 To: CF-Talk Subject: Re: Evaluate? Have you tried CFDumping the Form on that page to see if CF can see the form field Try changing the code to something like CFSET a = Form[GetAllContactTypes.PK_ContactType_ID] maybe wrapping it with a CFIF StructKeyExists(Form, GetAllContactTypes.PK_ContactType_ID) HTH - Original Message - From: Shahzad.Butt [EMAIL PROTECTED] Date: Thu, 24 Jun 2004 10:48:34 +0100 Subject: Evaluate? To: CF-Talk [EMAIL PROTECTED] Hello - can you please check the code below CFSet GetAllContactTypes.PK_ContactType_ID = CAA07070-CD2A-46D6-951F-653630BFD539 cfoutput CFSet a = #Evaluate(Form.#GetAllContactTypes.PK_ContactType_ID#)# /cfoutput _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Inserting Comma in DB
Hi CFSet myComments = It wasn't the best solution INSERT INTO tb_JQoS_Results (Comments) Values (' #myComments# ') It gives error because of the comma. How can we make it working? Thanks Shaz ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Inserting Comma in DB
Thanks a lot. CFQueryParam was the solution Shaz _ From: John Beynon [mailto:[EMAIL PROTECTED] Sent: 23 April 2004 15:17 To: CF-Talk Subject: RE: Inserting Comma in DB Eeeks, that should be cfsqltype=cf_sql_longvarchar Jb. -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: 23 April 2004 15:15 To: CF-Talk Subject: RE: Inserting Comma in DB Hi friend of muffin man :) cfqueryparam cfsqltype=longvarchar value=#mycomments# Jb. -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 23 April 2004 15:18 To: CF-Talk Subject: Inserting Comma in DB Hi CFSet myComments = It wasn't the best solution INSERT INTO tb_JQoS_Results (Comments) Values (' #myComments# ') It gives error because of the comma. How can we make it working? Thanks Shaz ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Installing dll online
Using Cold Fusion (MX or 5) how can we let a dll to be installed on client's web browser - online i.e. yahoo messenger installation. Shaz ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Encrypt
Hi Does anyone know how I can encrypt my source code in CFMX. Also after encrypting when I do the modification do I need to encrypt the whole folder or it would be the only modified files? Thanks Shaz ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Java Files
I've installed CFMX6.1 on Websphere. When I run a file say test.cfm it generates a java class which is cftest2ecf9184 Which is fine what I need more is to get the .java file for the same class. Just not familiar with the architecture does CFMX create java files and then compiles it to class file (which I guess it does). If so then where can I find the java source code for that file? Or .java file for test Thanks Shaz [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Length of CFC
Does it really matter if a cfc file is very long. say a couple of thousand lines. Would it slow down the request including a call to that cfc? Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Passing List into Stored Proc
Just a thought. Try adding the following line at the start of your SP SET QUOTED_IDENTIFIER OFF Also when you run the SP open up a trace in SQL Server Profiler and check exactly what query has been passed to SQL Server. Copy that query and send... Shaz _ From: John mccosker [mailto:[EMAIL PROTECTED] Sent: 27 January 2004 11:56 To: CF-Talk Subject: Passing List into Stored Proc Hi, I have wrote a stored proc that will delete items in a table by do a subquery on a list passed into it. If I test it in Query Analyzer it runs effectively, DELETE FROM DBO.a WHEREDBO.a.FOLDERNAME IN ('jim','ben','tom') AND DBO.a.CUSTOMERID = 1 but when I call through cf passing in the list it does not, cf CFSTOREDPROC PROCEDURE=p_test DATASOURCE=#request.d# USERNAME=#request.u# PASSWORD=#request.p# CFPROCPARAM DBVARNAME=@CUSTOMERID VALUE=#ListGetAt(cookie.c_userSession,1,';')# TYPE=IN CFSQLTYPE=CF_SQL_INTEGER CFPROCPARAM DBVARNAME=@FOLDERLIST VALUE=#attributes.delete_list# TYPE=IN CFSQLTYPE=CF_SQL_VARCHAR /CFSTOREDPROC proc code - CREATE PROCEDURE p_test (@CUSTOMERID INT,@FOLDERLIST VARCHAR(2000)) AS DELETE FROM DBO.a WHEREDBO.a.FOLDERNAME IN (@FOLDERLIST) AND DBO.a.CUSTOMERID = @CUSTOMERID running ms sql 7.0 and MX 6.1 Thanks for any help. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Web Application Archive
Hi When you install coldfusion MX (6.0 or 6.1 standard not on J2EE) where does it deploy the Web Application Archive?? Shaz [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX Installation
Hi I've installed Websphere on my machine (win2K professional with SP4). Now I want to install CFMX on the same machine using websphere. I am following the macromedia online help but problem I am facing is that when I install CFMX (on IIS) it doesn't ask for the EAR files(which is mentioned in the notes i am following). Should I continue installtion and then configre websphere with CF (but then I need to provide the path of ear files in admin console of websphere which i dont know)? Any ideas Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX Error
Just installed CFMX6.0 and getting following error when I open Admin page javax/crypto/CipherSpi Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX Error
I'll try that thanks dave _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 20 January 2004 17:25 To: CF-Talk Subject: RE: CFMX Error Just installed CFMX6.0 and getting following error when I open Admin page javax/crypto/CipherSpi Rather than address your specific problem, I'm going to ask you if you're installing this on Websphere. If you are, I'd strongly recommend that you install CFMX 6.1 instead, which in my experience has worked much better with various J2EE servers. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX Error
I am trying to upgrade CFMX6.1 from CFMX6.0 by choosing EAR option. At stage 4 (configure coldfusion MX) its says to choose existing web applicaiton root. I am selecting the path for it which is C:\CFusionMX\ but its not accpeting... any ideas _ From: Shahzad.Butt Sent: 20 January 2004 17:20 To: CF-Talk Subject: RE: CFMX Error I'll try that thanks dave _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 20 January 2004 17:25 To: CF-Talk Subject: RE: CFMX Error Just installed CFMX6.0 and getting following error when I open Admin page javax/crypto/CipherSpi Rather than address your specific problem, I'm going to ask you if you're installing this on Websphere. If you are, I'd strongly recommend that you install CFMX 6.1 instead, which in my experience has worked much better with various J2EE servers. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DTS from SP
Just create a scheduled job (in Sql) 'JOB1' then right click on that job, properties then click on STEPS tab. Click edit it will give you the code to run the DTS. You can copy this DTS code and paste it under DTSRUN e.g master.dbo.xp_cmdshell 'DTSRun /~Z0x3B2318455D75B2F1BC92AF9FA5AD4F411F72662FE92795909F7E45FD2518C5A3D9A 348AD5FF91DB24B84FC23F9E36EAD2975C5143E87E99773' Now you can run it as a query in coldfusion, SQL or save it as stored procedure. You can delete the job afterwards as you've created the job just to get the DTS ID Shaz _ From: Dan O'Keefe [mailto:[EMAIL PROTECTED] Sent: 14 January 2004 14:30 To: CF-Talk Subject: DTS from SP I have combed the archives, and then net, and I think I have found the info I need to be able to do this. I used the DTSRUNUI to create this string: 'DTSRun /S TESTDATA /U sa /P password /N frDay01_upload /G {F96F01E6-D82C-4ECF-899E-7DDADB1976C6} /W 0 ' When I run it from the DOS prompt, it works. When I try to run it with: exec master..xp_cmdshell, both from QA and a SP, I get the following error: DTSRun:Loading... Error:-2147024629 (8007010B); Provider Error:0 (0) Error string:The directory name is invalid. Error source:Microsoft Data Transformation Services (DTS) Package Help file:sqldts80.hlp Help context:713 NULL naturally the most frustrating part is trying to find out more info on the error. I have looked in the mentioned .hlp file as well as MS google. Anybody have any ideas? Dan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Get URL
How can I get the current URL (from browser)? e.g. I type in http://abc.com/myTest/test.cfm I need to save this URL in a variable inside test.cfm... Thanks Shaz [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
TSQL problem
I know its coldfusion group but I wonder if someone can help me with this query. What the alternative of Evaluate() in TSQL? SELECT 09/01/2004 + 'CAST(..)' AS myDateTime FROM myTest [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: TSQL problem
Following is the query SELECT DateAdd(Day, CAST(LEFT(CAST(PanelLocalDT AS Decimal(10,5)), CHARINDEX('.', CAST(PanelLocalDT AS Decimal(10,5)))-1) AS INT), '1899-12-30') + ' ' + 'CAST(((CaST(RIGHT(CONVERT(decimal(10,4),PanelLocalDT), LEN(CONVERT(decimal(10,4),PanelLocalDT)) - charindex(''.'',CONVERT(decimal(10,4),PanelLocalDT))) AS Float(8)) / 100 * 1440 / 100) / 60 ) AS int(4)) : CAST(((CaST(RIGHT(CONVERT(decimal(10,4),((CaST(RIGHT(CONVERT(decimal(10, 4),PanelLocalDT), LEN(CONVERT(decimal(10,4),PanelLocalDT)) - charindex(''.'',CONVERT(decimal(10,4),PanelLocalDT))) AS Float(8)) / 100 * 1440 / 100) / 60 )), LEN(CONVERT(decimal(10,4),((CaST(RIGHT(CONVERT(decimal (10,4),PanelLocalDT), LEN(CONVERT(decimal(10,4),PanelLocalDT)) - charindex(''.'',CONVERT(decimal(10,4),PanelLocalDT))) AS Float(8)) / 100 * 1440 / 100) / 60 ))) - charindex(''.'',CONVERT(decimal(10,4),((CaST(RIGHT(CONVERT(decimal(10,4) ,PanelLocalDT), LEN(CONVERT(decimal(10,4),PanelLocalDT)) - charindex(''.'',CONVERT(decimal(10,4),PanelLocalDT))) AS Float(8)) / 100 * 1440 / 100) / 60 AS Float(8)) / 100 * 60 / 100) ) AS Int(4)) : 00' myDate >From dbo.AFxEvents [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Frames
Hi My left frame has got a link LOGIN and it opens a Login form on right frame. I want to get rid of the LOGIN link and give my administrator direct access to that login form page. So they jus type in http://www.abc.com/index.htm and they go direct inot login form with having left and top frames on right place. How can I specify the form target through URL address bar? Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Log analysis tool
Hi Can any tell me free utility to analyse web traffic for IIS? Thanks Shaz [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Space between images
Folowing is code to show buttons (each button is an image) in my page table cellpadding=0 cellpadding=0width=100% tr td CFOutput query=GetAllUnitPromotionTypeName cfswitch _expression_=#GetAllUnitPromotionTypeName.PK_UnitPromotionType_ID# CFCase value=1 A href=""> .PK_UnitPromotionType_ID# target=Right class=smlimg align=left border=0 name=a src=""> /CFCase CFCase value=6 A href=""> .PK_UnitPromotionType_ID# target=Right class=smlimg align=left border=0 name=b src=""> /CFCase CFCase value=7 A href=""> .PK_UnitPromotionType_ID# target=Right class=smlimg align=left border=0 name=c src=""> /CFCase /cfswitch /cfoutput /td /tr /table Problem is that there is space between each button however i want not to have space between them and look like a strip. Thansk Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Space between images
you are the man. it works thanks _ From: Bailey, Neal [mailto:[EMAIL PROTECTED] Sent: 31 December 2003 16:26 To: CF-Talk Subject: RE: Space between images Also try adding (hspace=0 vspace=0) to the image tags. Neal Bailey Internet Marketing Manager UGA-Association Field Services E-mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.If you are not the intended recipient you are hereby notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.Thank you. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 10:27 AM To: CF-Talk Subject: Re: Space between images remove line breaks in the code.makes it harder to read, i know, but should resolve the space issue. - Original Message - From: Shahzad.Butt To: CF-Talk Sent: Wednesday, December 31, 2003 9:22 AM Subject: Space between images Folowing is code to show buttons (each button is an image) in my page table cellpadding=0 cellpadding=0width=100% tr td CFOutput query=GetAllUnitPromotionTypeName cfswitch _expression_=#GetAllUnitPromotionTypeName.PK_UnitPromotionType_ID# CFCase value=1 A href=""> .PK_UnitPromotionType_ID# target=Right class=smlimg align=left border=0 name=a src=""> /CFCase CFCase value=6 A href=""> .PK_UnitPromotionType_ID# target=Right class=smlimg align=left border=0 name=b src=""> /CFCase CFCase value=7 A href=""> .PK_UnitPromotionType_ID# target=Right class=smlimg align=left border=0 name=c src=""> /CFCase /cfswitch /cfoutput /td /tr /table Problem is that there is space between each button however i want not to have space between them and look like a strip. Thansk Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Javascript Help Required
Hi I am using following script to change the image for a button on mouseOver (red button) and mouseOut (white button). What I can not achieve or I dont know how to do is when link is active then display image which I am using on mouseOver script language=_javascript_ if (browserVer == 1) { b1 = new Image(107,36); b1.src = ""> b2 = new Image(107,36); b2.src = ""> } //image swapping function: function hiLite(imgDocID, imgObjName, comment) { if (browserVer == 1) { document.images[imgDocID].src = "" + .src); window.status = comment; return true; }} //end hiding -- /script Thats where I am using the function in CF A Login') Login') href="" target=Right class=sml img border=0 name=b src=""> Can anyone explain me when a link is active how can I keep the Redbutton not the white one?? Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Javascript Help Required
That must be a mistake writing email however my code works fine. Only problem is that I dont know how to keep the image active (Red One) when a link is active. _ From: MILAN MUSHRAN [mailto:[EMAIL PROTECTED] Sent: 30 December 2003 14:10 To: CF-Talk Subject: RE: _javascript_ Help Required You have a Syntax error... You missed the double quotes on the first image. b1.src = ""> From: Shahzad.Butt [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: _javascript_ Help Required Date: Tue, 30 Dec 2003 11:40:34 - Hi I am using following script to change the image for a button on mouseOver (red button) and mouseOut (white button). What I can not achieve or I dont know how to do is when link is active then display image which I am using on mouseOver script language=_javascript_ if (browserVer == 1) { b1 = new Image(107,36); b1.src = ""> b2 = new Image(107,36); b2.src = ""> } //image swapping function: function hiLite(imgDocID, imgObjName, comment) { if (browserVer == 1) { document.images[imgDocID].src = "" + .src); window.status = comment; return true; }} //end hiding -- /script Thats where I am using the function in CF A Login') Login') href="" target=Right class=sml img border=0 name=b src=""> Can anyone explain me when a link is active how can I keep the Redbutton not the white one?? Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Password encryption
Hi I am storing user name and password in Access DB and running a query to match the combination when user attempts to login. Authorised users can do everything with the DB. Whats the best way to make it secure? encrypting passwords stored in DB? or some other way.. Thanks Shaz [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Solution/suggetion...
Hi I am providing user a form to add new employees in the system. Problem I am facing is that users are adding same employees twice (as adding is managed by different departments). Now this adding form (dsp_addEmployee.cfm) is quite complicated and I dont want to touch it at all neither do I want to touch its act page (act_addEmployee.cfm) where its acutally adding looking at loads of different criterias. Solution we came up with is that check the date of birth in the form as user submits the form and provide the user with list a of all employees for that date of birth and a message that checks if the employee already exist. If h/she does then go somewhere (doesn't matter where), if no then click on CONTINUE and it will run the act page. This CONTINUE seems a bit tricky as I can have a new page called dsp_ShowEmployeesForSameDOB.cfm between dsp_addEmployee.cfm and act_addEmployee. But on continue that dsp_ShowEmployeesForSameDOB.cfm needs to carry all form variables (attributes here as i am using FB3). I cannot store them again in hidden variables as its too complicated and messy. So whats the solution for this problem? Thanks Shaz [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Refresh left frame
Hi I have Login link on left frame which opens login screen on right frame. On successfull login I want to refresh the left frame. But as I am at right frame it just refreshes right one. Reason I want to do is that some links in left are enabled only when appropriate user is logged in. Without refreshing it doesn't show the links to authorised users. Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Looping through checkbox
How can we loop through only selected checkbox items in action page. I dont want to loop through entire items and then use CFIF to check if selected then run the statement Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping through checkbox
- they all have different names - user is selecting the check boxes following is the code the way i am using cfloop query=GetAllUnitPromotionForType tr tdinput type=checkbox name=Unit#Counter# value=#GetAllUnitPromotionForType.PK_UnitPromotion_ID/td ... /cfloop _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 08 December 2003 18:04 To: CF-Talk Subject: RE: Looping through checkbox are they all the same name? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:02 PM To: CF-Talk Subject: Looping through checkbox How can we loop through only selected checkbox items in action page. I dont want to loop through entire items and then use CFIF to check if selected then run the statement Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
HTML
Hi I am displaying an image on background of everypage. It works perfect by having bgproperties = fixed in body tag means its watermark. Problem I am having is that all TEXTAREA tags are showing a white box and hiding the background image. How would I make TEXTAREA to behave in same manner and show the background image as well? Must be some DHTML or stylesheet function to do that. Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Date format in access
Hi Can someone tell the date format to use in CFQuery in select/insert statement for an access DB? thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Getting last inserted idenity value
Hi I am using CFMX and Access2000. In my action page I've got two insertion queries one inserts in table1 and other one inserts in table2. Both of these tables has got primary key as autoincrement number. Second query needs to add the primary key generated from first query as a foreign key. How would I get the PK of the record just inserted. I know in SQLServer we could use @@IDENTITY but unfortunately I am using access at the moment Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Getting last inserted idenity value
Which scope i.e queryname.MaxID...?Is it CF Function? _ From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 28 November 2003 13:31 To: CF-Talk Subject: RE: Getting last inserted idenity value Try MaxID. _ From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 28 November 2003 13:25 To: CF-Talk Subject: Getting last inserted idenity value Hi I am using CFMX and Access2000. In my action page I've got two insertion queries one inserts in table1 and other one inserts in table2. Both of these tables has got primary key as autoincrement number. Second query needs to add the primary key generated from first query as a foreign key. How would I get the PK of the record just inserted. I know in SQLServer we could use @@IDENTITY but unfortunately I am using access at the moment Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
TDateTime conversion
Hi Has anyone written any UDF or something to convert TDateTime value (in Delphi) to normal ODBC date/time format? Even a TSQL command will help me as well.. Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX in SAP
Hi I wonder if anyone has used any CF (doesn't have to be CFMX) with SAP's Web Portal (using Sap web application server)? I am having some configuration issues. I want to install CFMX on Sap's Application Server not JRUN. I would highly appreciate if some one explain me how you have configured it? Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Custom tags in CFMX
I had C++ custom tags in CF when i migrated to CFMX and didn't have any issue migrating to MX 6.1 either. Shaz -Original Message- From: chad [mailto:[EMAIL PROTECTED] Sent: 28 October 2003 16:27 To: CF-Talk Subject: Custom tags in CFMX I have recently upgraded my CF server from 5 to MX 6.1. In doing so one of my Java CFX tags is now not working. When I try to run this tag, it errors out because it applies an extra CFX_ to the tag name. So what used to be CFX_Tagname is now CFX_CFX_Tagname and because of this it no longer works.. When I log into my CF admin and go to Custom Tag Paths I have two, D:\CFusion\CustomTags and D:\CFusionMX\CustomTags. I do have 4 other CFX tags that are working properly. Any help would be greatly appreciated. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFTP - putfile problem
Just stick all the files in a directory then you can loop over a directory and then pass the dynamic file name to FTP. cfdirectory action="" directory=#Request.myDir# name=dirs filter=* cfoutput query=dirs cfftp action = "" file=#Request.myDir#\#dirs.name# /cfoutput Shaz -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 29 October 2003 12:39 To: CF-Talk Subject: Re: CFFTP - putfile problem On Wednesday 29 Oct 2003 12:24 pm, Pedro Mendes wrote: Can I pass the names of the files dinamically (#name#), so that in one cfftp I can transfer them all? You can, yes, but only one name at a time, you'll have to loop over the cfdirectory results to get these names. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
DWMX Database Connection
I've set up RDS and can view my datasourcees in Dreamweaver. Problem is that the font (font size) is weird and I cannot read anything. I can click on a datasource by guessing and then i can see tables as well but font is soweird that I am unable to read anything. Can someone tell me how to make it readable (under database)? Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DWMX Database Connection
Problem solved - changed the fonts to SMALL under display - settings - advance -Original Message- From: Shahzad.Butt Sent: 01 October 2003 10:21 To: CF-Talk Subject: DWMX Database Connection I've set up RDS and can view my datasourcees in Dreamweaver. Problem is that the font (font size) is weird and I cannot read anything. I can click on a datasource by guessing and then i can see tables as well but font is soweird that I am unable to read anything. Can someone tell me how to make it readable (under database)? Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX6.1 ODBC services
Hi I've just installed CFMX6.1 in my production environment. Problem I am facing is that I can not start 'ColdFusion MX ODBC Agent' and 'ColdFusion MX ODBC Server' services. I am using domain account to run coldfusion services. However I can start Application Server services (using same domain account) and other two mentioned above I cannot start. Is there any known reason why this is happening? Thanks Shahzad.Butt Ph: +44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138255 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFMX6.1 ODBC services
Thanks a lot. This article has solved my problem. -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: 24 September 2003 14:24 To: CF-Talk Subject: Re: CFMX6.1 ODBC services Check out the front page of http://houseoffusion.com/ Mike has an explination there that may help. Dan Phillips CFXHosting.com - Original Message - From: Shahzad.Butt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 5:08 AM Subject: CFMX6.1 ODBC services Hi I've just installed CFMX6.1 in my production environment. Problem I am facing is that I can not start 'ColdFusion MX ODBC Agent' and 'ColdFusion MX ODBC Server' services. I am using domain account to run coldfusion services. However I can start Application Server services (using same domain account) and other two mentioned above I cannot start. Is there any known reason why this is happening? Thanks Shahzad.Butt Ph: +44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138281 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Running Batch Script
I want to stop a service on SERVERA from SERVERB. I am using following command to run a batchfile cfexecute name=c:\WINNT\system32\cmd arguments=X:\WWWRoot\Services\StopLoadBalancing.bat/cfexecute Following is command in batch script psexec \\SERVERA WLBS stop This batch file works perfect when I run it and stops the service but it doesn't work through CFEXECUTE. Dont know whats going on there NOTE: CFEXECUTE is not disabled from CFAdmin Any suggetions.. Thanks Shahzad.Butt Ph: +44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Running Batch Script
Coldfusion runs under domain account and that user has got Administrative Access. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 15:43 To: CF-Talk Subject: RE: Running Batch Script I want to stop a service on SERVERA from SERVERB. I am using following command to run a batchfile cfexecute name=c:\WINNT\system32\cmd arguments=X:\WWWRoot\Services\StopLoadBalancing.bat /cfexecute Following is command in batch script psexec \\SERVERA WLBS stop This batch file works perfect when I run it and stops the service but it doesn't work through CFEXECUTE. Dont know whats going on there NOTE: CFEXECUTE is not disabled from CFAdmin It's probably a permissions problem. Is the CF service running as a user with rights to stop services on SERVERA? By default, the CF services runs as SYSTEM, which has no rights to network resources at all. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Running Batch Script
This user has got administrative access. I've tried login with that account and ran that script it WORKS. It just doesn't work thru CFEXECUTE What shall I do??? Shaz -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 15:57 To: CF-Talk Subject: RE: Running Batch Script Coldfusion runs under domain account and that user has got Administrative Access. Does the account have a persistent drive mapping to the X drive, where the batch file is located? I'm guessing it does, but it doesn't hurt to ask. And, while you've confirmed that account, you might want to login with that account and run the batch file from an interactive console session to see if it works. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Running Batch Script
Fixed Thanks dave D: CD\ cd ABCD cd EFGH psexec \\ WLBS stop Should be in batch script and cfexecute name=D:\WWWRoot\JJCServices\StopLoadBalancing.bat/cfexecute should be withing CFExecute It works Thanks Shaz -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 16:38 To: CF-Talk Subject: RE: Running Batch Script This user has got administrative access. I've tried login with that account and ran that script it WORKS. It just doesn't work thru CFEXECUTE What shall I do??? I'm out of obvious ideas. I'd recommend that you try to break the problem down into smaller components. For example, can you run any other things through CFEXECUTE? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Load Balancing
Hi I've load balanced my webservers using windows load balancing. Specs of both load balanced servers (Server1 and Server2) are Win2K advanced server CFMX SQL2K (running on third box Server3) My code is replicated between Server1 and Server2. If I shut down one box then second one takes over automatically. And if both are running then traffic is distributed between both (with no intelligence what so ever that which server is doing more work and which less). Problem I am having is that if for some reason IIS services stops or CFMX server crashes (services are started in SERVICES but giving no response) then traffic which is dedicated to that server is still going there and user is getting no response. So all I need is that if for some reason either IIS or CF server is crashed or stopped then either it shuts down the server or it restart that services. I cant set page time out in CFAdmin because some of my apps take about 45 minutes to be completed as they are running backup of some files. I know CFProbe can do that but thats for ClusterCAT which unfortunately I dont have. Any suggetions Thanks Shahzad.Butt Ph: +44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Load Balancing
How does that batch file know when to be executed. Or shall I schedule every 1 min? which I don't feel is right. Because I want to start the restart the services whenever it crashes not just one off. Also can I have a copy of that batch file (to stop or restart IIS/CFMX services) if someone has written Thanks Shaz -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 02 September 2003 10:40 To: CF-Talk Subject: Re: Load Balancing On Tuesday 02 Sep 2003 09:20 am, Shahzad.Butt wrote: So all I need is that if for some reason either IIS or CF server is crashed or stopped then either it shuts down the server or it restart that services. Seems easy enough - write a batch file that requests a file from your webserver, and if it doesn't get it, stops the service. I use CygWin for stuff like this. -- Tom Chiverton (sorry 'bout sig.) Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Text Field
I am adding data in text field in sql server 2000. User can see a memo box and they can type in long description. All I want is to keep the format user typed in so I want to keep all enters, spaces extra entered by user in DB. And then when I display result it should show in same format but it should also fit in page (with table of 100% width). Fitting in page is fine just having 100% width does the job. But how can I save data entered by user in same format in DB? When I use Pre#data#/pre when inserting in DB then it doesn't fit in page but shows everything in one line. Any help?? Thanks Shahzad.Butt Ph: +44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Dev Notes (fusebox)
Hi If someone has used Devnotes (you can find it from http://www.halhelms.com/index.cfm?fuseaction=code.detail http://www.halhelms.com ). Is there anyway that it seperates notes for each page. Currently its showing devnotes for entire Wireframe application. So if I add note for one wire frame then person working on other wireframe will see those notes as well so its whole one big note conversation going on throughout whole wireframe app. I want different notes for each wireframe P.S: wireframe app is written in Fusebox Thanks Shaz JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7739 556 280 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
UTC Again
I remember once I asked to convert UTC date format (in milliseconds starting from midnight 1970 jan) to normal date. And solution was #dateformat(dateadd(s,1057580739,1/1/1970),/mmm/dd)# = 2003/Jul/07 Now how to do the reverse. Means now I've got 7th July 2003, how do i convert it to milliseconds starting from midnight jan 1970 (UTC)? Thanks Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JSP/Java in CF Page
There was no reason no following that approach. Its perfect and does what I want. Thanks -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 08 July 2003 18:33 To: CF-Talk Subject: Re: JSP/Java in CF Page First time writing Java/JSP code in CF. What should be the syntax to include this java file in cf page and print results. is there any reason for not taking this approach? cfscript aSimpleDateFormat = createObject(java, java.text.SimpleDateFormat); millseconds = javaCast(double,1057580739 * 1000); thisDateMask=javaCast(string,/MM/dd HH:mm:ss); thisDate=aSimpleDateFormat.init(thisDateMask).format(millseconds); writeoutput(#thisDate#); /cfscript ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
JSP/Java in CF Page
Hi First time writing Java/JSP code in CF. What should be the syntax to include this java file in cf page and print results. %@ import java.text.SimpleDateFormat;% %@ import java.util.*;% % public class formatDate{ public static void main(String args[]) { String seconds = args[0]; long secs = Integer.parseInt(1057580739); long millseconds = secs * 1000; Date dateObj = new Date(millseconds); SimpleDateFormat sdf = new SimpleDateFormat(/MM/dd HH:mm:ss); String formattedDate = sdf.format(dateObj); System.out.println(formattedDate); } } % Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JSP/Java in CF Page
Getting this error \u201cUTCDate, on line 9, column 31, is not a valid identifer name. The CFML compiler was processing: an expression beginning with \u201cUTCDate.jsp\u201d, on line 9, column 31.This message is usually caused by a problem in the expressions structure. an expression beginning with GetPageContext, on line 9, column 6.This message is usually caused by a problem in the expressions structure. a script statement beginning with GetPageContext on line 9, column 6. a CFSCRIPT tag beginning on line 8, column 2. The error occurred in C:\Test\UTC.cfm: line 9 7 : body 8 : CFSCRIPT 9 : GetPageContext().include(UTCDate.jsp); 10 : /CFSCRIPT -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: 08 July 2003 11:46 To: CF-Talk Subject: RE: JSP/Java in CF Page CFSCRIPT GetPageContext().include(hello.jsp); /CFSCRIPT Full details here... http://www.macromedia.com/devnet/mx/coldfusion/articles/java.html WG -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 08 July 2003 10:14 To: CF-Talk Subject: JSP/Java in CF Page Hi First time writing Java/JSP code in CF. What should be the syntax to include this java file in cf page and print results. %@ import java.text.SimpleDateFormat;% %@ import java.util.*;% % public class formatDate{ public static void main(String args[]) { String seconds = args[0]; long secs = Integer.parseInt(1057580739); long millseconds = secs * 1000; Date dateObj = new Date(millseconds); SimpleDateFormat sdf = new SimpleDateFormat(/MM/dd HH:mm:ss); String formattedDate = sdf.format(dateObj); System.out.println(formattedDate); } } % Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JSP/Java in CF Page
Default in Dreamweaver charset=iso-8859-1 I guess. -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: 08 July 2003 13:23 To: CF-Talk Subject: RE: JSP/Java in CF Page Looks like a unicode issue, what encoding are you using ? WG -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 08 July 2003 13:10 To: CF-Talk Subject: RE: JSP/Java in CF Page Getting this error \u201cUTCDate, on line 9, column 31, is not a valid identifer name. The CFML compiler was processing: an expression beginning with \u201cUTCDate.jsp\u201d, on line 9, column 31.This message is usually caused by a problem in the expressions structure. an expression beginning with GetPageContext, on line 9, column 6.This message is usually caused by a problem in the expressions structure. a script statement beginning with GetPageContext on line 9, column 6. a CFSCRIPT tag beginning on line 8, column 2. The error occurred in C:\Test\UTC.cfm: line 9 7 : body 8 : CFSCRIPT 9 : GetPageContext().include(UTCDate.jsp); 10 : /CFSCRIPT -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: 08 July 2003 11:46 To: CF-Talk Subject: RE: JSP/Java in CF Page CFSCRIPT GetPageContext().include(hello.jsp); /CFSCRIPT Full details here... http://www.macromedia.com/devnet/mx/coldfusion/articles/java.html WG -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 08 July 2003 10:14 To: CF-Talk Subject: JSP/Java in CF Page Hi First time writing Java/JSP code in CF. What should be the syntax to include this java file in cf page and print results. %@ import java.text.SimpleDateFormat;% %@ import java.util.*;% % public class formatDate{ public static void main(String args[]) { String seconds = args[0]; long secs = Integer.parseInt(1057580739); long millseconds = secs * 1000; Date dateObj = new Date(millseconds); SimpleDateFormat sdf = new SimpleDateFormat(/MM/dd HH:mm:ss); String formattedDate = sdf.format(dateObj); System.out.println(formattedDate); } } % Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Date Time (GMT 1970)
Any custom tag / UDF which can convert date/time value with GMT (Starting from Midnight January 1970) and it should go backward as well converting GMT (1970) to normal date/time? Thanks Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Date Time (GMT 1970)
We have got a software running to LOG telephone calls and that software has got its own DB and date/time it is logging call is in seconds starting from Midnight (00:00:00) January 1, 1970. Now I want to run report with some understandable date/time format - so I need a conversion mechanism. -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 12:55 To: CF-Talk Subject: RE: Date Time (GMT 1970) tbh I don't quite understand what you are trying to do. Are you trying to convert a java/javascript milliseconds from epoch value to GMT? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 12:51 To: CF-Talk Subject: Date Time (GMT 1970) Any custom tag / UDF which can convert date/time value with GMT (Starting from Midnight January 1970) and it should go backward as well converting GMT (1970) to normal date/time? Thanks Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Date Time (GMT 1970)
That's an example 1057580739 I think it should be converted to 7th July 2003, 13:25 or something like that. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 13:17 To: CF-Talk Subject: RE: Date Time (GMT 1970) is it logging in julian format? or actually in seconds? can you provide an example of what a log looks like... -Original Message- From: Tom Smith [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 13:14 To: CF-Talk Subject: Re: Date Time (GMT 1970) are you getting the date in seconds, if so, use dateFormat() and it should work fine:) - Original Message - From: Shahzad.Butt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 07, 2003 1:09 PM Subject: RE: Date Time (GMT 1970) We have got a software running to LOG telephone calls and that software has got its own DB and date/time it is logging call is in seconds starting from Midnight (00:00:00) January 1, 1970. Now I want to run report with some understandable date/time format - so I need a conversion mechanism. -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 12:55 To: CF-Talk Subject: RE: Date Time (GMT 1970) tbh I don't quite understand what you are trying to do. Are you trying to convert a java/javascript milliseconds from epoch value to GMT? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 12:51 To: CF-Talk Subject: Date Time (GMT 1970) Any custom tag / UDF which can convert date/time value with GMT (Starting from Midnight January 1970) and it should go backward as well converting GMT (1970) to normal date/time? Thanks Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Date Time (GMT 1970)
I've been told that DateAdd() sucks on MX if the date is within DST?? -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 14:04 To: CF-Talk Subject: RE: Date Time (GMT 1970) #dateformat(dateadd(s,1057580739,1/1/1970),/mmm/dd)# = 2003/Jul/07 -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 13:58 To: CF-Talk Subject: RE: Date Time (GMT 1970) That's an example 1057580739 I think it should be converted to 7th July 2003, 13:25 or something like that. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 13:17 To: CF-Talk Subject: RE: Date Time (GMT 1970) is it logging in julian format? or actually in seconds? can you provide an example of what a log looks like... -Original Message- From: Tom Smith [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 13:14 To: CF-Talk Subject: Re: Date Time (GMT 1970) are you getting the date in seconds, if so, use dateFormat() and it should work fine:) - Original Message - From: Shahzad.Butt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 07, 2003 1:09 PM Subject: RE: Date Time (GMT 1970) We have got a software running to LOG telephone calls and that software has got its own DB and date/time it is logging call is in seconds starting from Midnight (00:00:00) January 1, 1970. Now I want to run report with some understandable date/time format - so I need a conversion mechanism. -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 12:55 To: CF-Talk Subject: RE: Date Time (GMT 1970) tbh I don't quite understand what you are trying to do. Are you trying to convert a java/javascript milliseconds from epoch value to GMT? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 12:51 To: CF-Talk Subject: Date Time (GMT 1970) Any custom tag / UDF which can convert date/time value with GMT (Starting from Midnight January 1970) and it should go backward as well converting GMT (1970) to normal date/time? Thanks Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Dreamweaver Problem
Hi I have just installed Dreamweaver MX on my machine. Text for Insert Panel (Common, Layout, Tables, Forms, Templates, Characters) is quite weird and I cant see anything at all. How can I change and increase fontsize? Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Locking Vars
Hi, I am running a query and setting my application, request and client vars in the loop like that CFOutput Query=GetVars CFParam name=#VariableName# Default= #VariableValue# /cfQuery I am not using session varaibles at all but only CLIENT, REQUEST, APPLICATION. Which type of LOCK and which order is recommended in this particular scenario - provided that deadlocks are avoided as well.. Thanks Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Session Hijack
Hi, How do we prevent our site showing critical information to hacker if someone hijacks the session and start using site of some other (admin's) session and admin's current session gets disconnected. I've been told that it has happened in past. My coding is totally irrelevant of any such hack and my security is simply session based so everone is welcome provided h/she is authorised and session is defined. What is recommended way of preventing such act in your code? Any suggetions Thanks Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Limit Simultaneous Requests
Hi My machine specs are P3 Dual Processor 1.266 GHz (512 Cache) RAM = 1.0 GB (This is just application server as DB server is different machine) How many simultaneous requests (in CFMX Admin) should I make as default for better performance of our Intranet system running (CFMX uses 10 as default). In my company concurrent users at any time are somthing like 90 - 100. I am using CFMX and its load balanced using Windows Load Balancing. Thanks Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7739 556 280 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Schedule in MX
Hi I've got 4 schedules running in my CFMX admin - every 5 mins. If I run each app direct through browser but not scheduled task then it doesn't even take a second to finish. And log is not written on SERVER.LOG (which i've set to log each page taking more than 2 secs). Thats fine - but problem is that each schedule runs every 5 mins and each app in schedule is logged in my SERVER.LOG taking 120 secs or more. Why is it? why same app which takes 1 sec to run is taking 120 sec to run through schedule in MX? Any idea, suggetions My MX server is crashing sporadically (each time I'd to restart CFMX services) and that's only problem I've found so far that may be some apps (scheduled tasks) taking so long are causing the damage. Thanks Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7739 556 280 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Schedule in MX
Any help/articles on Wget? How to use it? Thanks -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: 18 June 2003 11:55 To: CF-Talk Subject: RE: Schedule in MX Personally I never use scheduling in CF, the scheduled tasks sytem in windows works way better, I simply use wget to hit templates at scheduled intervals, this works extremely well. I also use a java program I wrote which does a similar thing for monitoring ftp directories for uploaded files. I'd go with wget and windows scheduled tasks. -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 18 June 2003 11:49 To: CF-Talk Subject: Schedule in MX Hi I've got 4 schedules running in my CFMX admin - every 5 mins. If I run each app direct through browser but not scheduled task then it doesn't even take a second to finish. And log is not written on SERVER.LOG (which i've set to log each page taking more than 2 secs). Thats fine - but problem is that each schedule runs every 5 mins and each app in schedule is logged in my SERVER.LOG taking 120 secs or more. Why is it? why same app which takes 1 sec to run is taking 120 sec to run through schedule in MX? Any idea, suggetions My MX server is crashing sporadically (each time I'd to restart CFMX services) and that's only problem I've found so far that may be some apps (scheduled tasks) taking so long are causing the damage. Thanks Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7739 556 280 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS AD
Domain Controller (in AD) -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 12:04 To: CF-Talk Subject: RE: MS AD I would assume it stands for Data Connection -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 12:07 To: CF-Talk Subject: Re: MS AD Correction. I have no clue what it stands for. I thought you asked DN. :-) - Original Message - From: Michael T. Tangorre [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 7:04 AM Subject: Re: MS AD it stands for Distinguished Name. - Original Message - From: Frank Mamone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 16, 2003 3:18 PM Subject: Re: MS AD Just for reference, what is DC? - Original Message - From: Shahzad.Butt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 16, 2003 12:48 PM Subject: RE: MS AD Got it working. Dc was missing thx -Original Message- From: Shahzad.Butt Sent: 16 June 2003 17:25 To: CF-Talk Subject: RE: MS AD Same error man, using port 389 -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 16 June 2003 17:17 To: CF-Talk Subject: RE: MS AD the 'port' attribute is missing. Adding this will fix your problem --- Marlon Moyer [EMAIL PROTECTED] wrote: Have you tried giving it a username and password? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 10:54 AM To: CF-Talk Subject: MS AD How can I query MS Active Directory and get a list of all emails for users in AD?? My impression was that something like cfldap server = TestServer action = query name = results start = cn = shaz,c = US filter = (cn = shaz) attributes = cn,o,l,st,c,mail,telephonenumber sort = cn ASC should work but its giving following error An error has occured while trying to execute query operation on the LDAP Server. One or more of the required attributes may be missing/incorrect or you do not have permissions to execute this operation on the server Thanks Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MS AD
How can I query MS Active Directory and get a list of all emails for users in AD?? My impression was that something like cfldap server = TestServer action = query name = results start = cn = shaz,c = US filter = (cn = shaz) attributes = cn,o,l,st,c,mail,telephonenumber sort = cn ASC should work but its giving following error An error has occured while trying to execute query operation on the LDAP Server. One or more of the required attributes may be missing/incorrect or you do not have permissions to execute this operation on the server Thanks Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS AD
Did try passing username and password. No luck -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: 16 June 2003 17:11 To: CF-Talk Subject: RE: MS AD Have you tried giving it a username and password? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 10:54 AM To: CF-Talk Subject: MS AD How can I query MS Active Directory and get a list of all emails for users in AD?? My impression was that something like cfldap server = TestServer action = query name = results start = cn = shaz,c = US filter = (cn = shaz) attributes = cn,o,l,st,c,mail,telephonenumber sort = cn ASC should work but its giving following error An error has occured while trying to execute query operation on the LDAP Server. One or more of the required attributes may be missing/incorrect or you do not have permissions to execute this operation on the server Thanks Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS AD
Same error man, using port 389 -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 16 June 2003 17:17 To: CF-Talk Subject: RE: MS AD the 'port' attribute is missing. Adding this will fix your problem --- Marlon Moyer [EMAIL PROTECTED] wrote: Have you tried giving it a username and password? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 10:54 AM To: CF-Talk Subject: MS AD How can I query MS Active Directory and get a list of all emails for users in AD?? My impression was that something like cfldap server = TestServer action = query name = results start = cn = shaz,c = US filter = (cn = shaz) attributes = cn,o,l,st,c,mail,telephonenumber sort = cn ASC should work but its giving following error An error has occured while trying to execute query operation on the LDAP Server. One or more of the required attributes may be missing/incorrect or you do not have permissions to execute this operation on the server Thanks Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS AD
Got it working. Dc was missing thx -Original Message- From: Shahzad.Butt Sent: 16 June 2003 17:25 To: CF-Talk Subject: RE: MS AD Same error man, using port 389 -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 16 June 2003 17:17 To: CF-Talk Subject: RE: MS AD the 'port' attribute is missing. Adding this will fix your problem --- Marlon Moyer [EMAIL PROTECTED] wrote: Have you tried giving it a username and password? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 10:54 AM To: CF-Talk Subject: MS AD How can I query MS Active Directory and get a list of all emails for users in AD?? My impression was that something like cfldap server = TestServer action = query name = results start = cn = shaz,c = US filter = (cn = shaz) attributes = cn,o,l,st,c,mail,telephonenumber sort = cn ASC should work but its giving following error An error has occured while trying to execute query operation on the LDAP Server. One or more of the required attributes may be missing/incorrect or you do not have permissions to execute this operation on the server Thanks Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Prevent Refresh
Great job! That works fine. Thanks -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 22:00 To: CF-Talk Subject: Re: Prevent Refresh Isaac wrote: You could do that -- you'd have to use javascript to submit the form and set the value of the field after the form is submitted. Nope. I use something very close to the code below. The user is assigned a form ID on arrival. This ID is checked for using both the persistent var you see here and later on when its time to hit the db and do an insert. Kind of a double check in case somehow the cvar-based test doesn't work. I know the 'UID' isn't perfect. A UUID with the dashes stripped out is probably smarter. Honestly I forget exactly. This has just worked so well over the last couple years that I pretty much forgot about it. !--- this goes on the form page. This is shorter than a UUID --- cfset DateStamp=#NumberFormat(Now(),_)# cfset TimeStamp=MID(Now(),16,9) cfset TimeStamp=REPLACE(TimeStamp,:,,ALL) cfset TimeStamp=REPLACE(TimeStamp, ,,ALL) cfset OriginIP=REPLACE(CGI.REMOTE_ADDR,.,,ALL) cfset FormUID=myUID DateStamp TimeStamp OriginIP input type=hidden name=FormUID value=Frm#variables.FormUID# !--- on the action page: --- cfset VarPart1=client. cfif isdefined (#VarPart1##form.FormUID#) error message goes here cfabort cfelse cfset client.#form.FormUID#=form.FormUID /cfif --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- Original Message -- From: S. Isaac Dealey [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 10 Jun 2003 15:22:33 -0500 You could do that -- you'd have to use javascript to submit the form and set the value of the field after the form is submitted. can always add a hidden field to the form with a specified value and then on the processing page add something like: !--- check for duplicate form submissions --- cfif #form.submissionCheck# EQ submitted Geezo have some patients, you already submitted the form! /cfif but then again, i know jack squat about cf - Original Message - From: Charlie Griefer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 3:42 PM Subject: Re: Prevent Refresh I agree with just about everything Isaac said, but wanted to chime in and say that the easiest solution would be the cflocation on the form's action page. This is generally how I prevent the duplicate submissions. The form's action page contains no HTML, just the insert query. After the query successfully runs, I do a cflocation to a Thank You page. This way, a refresh only refreshes that page. - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 12:34 PM Subject: Re: Prevent Refresh What is best way of preventing multiple entries in DB through form submission when user clicks on REFRESH or BACK button of browser? Thanks Shaz I usually use cflocation to move the browser to a confirmation template which informs the user that the record has been updated. In my case, this is often the form page, or in other words, they go back to the form with a information saved confirmation message at the top of the form, usually with all the info they just enterred filled in on the form again. I also like to use the pengoworks qForms API (www.pengoworks.com) to prevent multiple form submissions in browsers that support the DOM. If I have to use cfflush on a page, I move from cflocation to the javascript location.replace() which does the same thing client-side by replacing the current address in the browser history. It's available in Netscape as far back as version 3 and IE similarly. I'm not certain about other browsers, although I would assume at least Mozilla supports it since it was implemented in NS prior to Mozilla becoming available. There's a UDF implementation of it in the Tapestry API in my sig file also. hth s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=2181 6 ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community.
Prevent Refresh
What is best way of preventing multiple entries in DB through form submission when user clicks on REFRESH or BACK button of browser? Thanks Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Prevent Refresh
I cant use session scope in my app because of load balancing and stuff. So need a work around using request scope. Any suggetions??? Shaz -Original Message- From: Critz [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 14:48 To: CF-Talk Subject: Re: Prevent Refresh oi Critz!! whoops.. request scope won't work doh! session will.. Tuesday, June 10, 2003, 9:32:55 AM, you wrote: C oi Shahzad.Butt!! C on the preceding page... C script C window.history.forward(); C /script C this will prevent use of the back button... C on your form page.. for the refresh problem you can do this... C if not isDefined(request.pageHit) C ... do page stuff. C set request.pageHit = true C cfelse C page has already been accessed C /cfif C Crit C C Tuesday, June 10, 2003, 9:18:17 AM, you wrote: SB What is best way of preventing multiple entries in DB through form SB submission when user clicks on REFRESH or BACK button of browser? SB Thanks SB Shaz SB C ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
On Browser Close
I know its more or less javascript question. How can I update a row in DB when user closes browser? If user closes browser then message should be popped up saying you will be Unavailable YES (button1) NO (button2). and each Yes and No will have approriate actions. Thanks Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7739 556 280 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: On Browser Close
onLoad of which page cos user could be anywhere??? Don't tell me application.cfm :) -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 04 June 2003 16:50 To: CF-Talk Subject: Re: On Browser Close On Wednesday 04 Jun 2003 16:46 pm, Shahzad.Butt wrote: I know its more or less javascript question. How can I update a row in DB when user closes browser? If user closes browser then message should be popped up saying you will be Unavailable YES (button1) NO (button2). There is an onUnLoad/onClose event you can attach to body to check for that. -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
question
CFQuery name=Test datasource=DSN Select * From tb_test /cfquery (this query gives 34 results) CFSet Test.RecordCount = 1 CFOUTPUT#Test.RecordCount#/CFOUTPUT What should it display 34 or 1? It display 1. Any reason why? Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: question
OK, it display 34 but how can I set it to 1. I was a bit screwed up and said it displays 1. Actually it is displaying 34 but I want it to display 1 -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 18:01 To: CF-Talk Subject: RE: question It displays 34(or rather the equivalent on my result set) on my test. Ade -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 17:13 To: CF-Talk Subject: RE: question Because you reset it with your cfset Bryan F. Hogan Director of Internet Development Team Macromedia Volunteer Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 11:11 AM To: CF-Talk Subject: question CFQuery name=Test datasource=DSN Select * From tb_test /cfquery (this query gives 34 results) CFSet Test.RecordCount = 1 CFOUTPUT#Test.RecordCount#/CFOUTPUT What should it display 34 or 1? It display 1. Any reason why? Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4