RE: How to suppress the Header and Footer info when printing fr o m a browser
It is possible using ScriptX, an ActiveX component available for free. Currently only works in MSIE, and depending on Mozilla ActiveX support maybe in the future for other platforms. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFCONTENT and PDFs (Re: CFCONTENT and GetPageContext())
One really versatile tool in my arsenal: curl Just use curl.exe -i [url] | less/more/vim - and have a peek at the headers. http://curl.haxx.se/latest.cgi?curl=win32-nossl -- Hugo Ahlenius - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Adrian Moreno [mailto:[EMAIL PROTECTED] | Sent: Friday, October 08, 2004 18:42 | To: CF-Talk | Subject: CFCONTENT and PDFs (Re: CFCONTENT and GetPageContext()) | | Greetings. | | Anyone run into problems with using GetPageContext().Include()and | CFCONTENT to serve, say a PDF file, on the same page. | | I'm having a similar problem. I'm almost positive it's a | security fix in MSIE. The main function of the application | I'm building is to create and present PDF docs to the user. | | If we use FireFox, the PDF loads correctly in the Acrobat | plug-in, inside the browser. If we use MSIE (6.0.x), we get a | dialog box (stating Adobe Acrobat ActiveX component) that | prompts to Save or Open the file. Some versions of IE don't | even offer the Open option. | | If you Save the file in MSIE, it saves as index.cfm (as | expected). Change .cfm to .pdf and it opens in Acrobat | Reader properly. | | If you Open the file and .cfm is mapped to a program, it | opens in that program as text. Otherwise you get the list of | all programs, you can choose Acrobat/Acrobat Reader and the | PDF displays correctly. | | It was the case in years past and (IIRC) earlier this year | that you could open a PDF served by cfcontent inside MSIE | correctly. Something has to have changed in the way MSIE functions. | | Surely there are more people having this problem? | | Adrian J. Moreno | --- | Factors of i, Inc. | - http://FactorsOfi.com | - Linux Web Hosting: CF/PHP with MySQL | --- | i Know Kung Foo Consulting | - http://iKnowKungFoo.com | - ColdFusionMX, Java, JBoss, JSP Struts | - XML Database Development | - Internationalization (i18n) | --- | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How to suppress the Header and Footer info when printing fr o m a browser
If you want to make the change permanently, you *CAN* suppress the header and footer in IE by changing the following registry keys HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\PageSetup\header HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\PageSetup\footer Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: exception handling, kindly help
Hi and thank you all for posting the code. I'm afraid I'm still stuck with this problem. My application uses a lot of iframes and the custom error message can have a green background or a orange background depending on the page the error occurred and to be able to do that I use the custom tag inside the cfcatch block and color is the one of the attributes of this tag. cfcatch type=any cf_caughtIt catchMessage=#cfcatch.message# color=red /cfcatch I still don't know how to call the cferror tag. To give you a better idea, here is what I'm trying to do Step 1: Exception occurred. error code wrapped around cftry and cfcatch blocks Step 2: custom tag caughtIt called inside the cfcatch tag, see above. Step 3: caughtIt.cfm displays the custom error message and emails the error details to the administrator i.e form, session, url info. I'm trying to get detailed error info (ie line error occurred, root cause, diagnostics etc. This info is contained in the error structure that is returned by the cferror tag. Now then, if I can somehow call the cferror tag inside application.cfm or some other way I can get something out. The problem is (I don't know how serious this is), but my application uses iframes. If the error occured in an inner iframe, how do I get to display the error message in that iframe and not on the top-level iframe? You see what I'm saying. I hope I'm making sense guys. I'll appreciate your help Regards cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: exception handling, kindly help
Hi and thank you all for posting the code. I'm afraid I'm still stuck with this problem. My application uses a lot of iframes and the custom error message can have a green background or a orange background depending on the page the error occurred and to be able to do that I use the custom tag inside the cfcatch block and color is the one of the attributes of this tag. cfcatch type=any cf_caughtIt catchMessage=#cfcatch.message# color=red /cfcatch I still don't know how to call the cferror tag. To give you a better idea, here is what I'm trying to do Step 1: Exception occurred. error code wrapped around cftry and cfcatch blocks Step 2: custom tag caughtIt called inside the cfcatch tag, see above. Step 3: caughtIt.cfm displays the custom error message and emails the error details to the administrator i.e form, session, url info. I'm trying to get detailed error info (ie line error occurred, root cause, diagnostics etc. This info is contained in the error structure that is returned by the cferror tag. Now then, if I can somehow call the cferror tag inside application.cfm or some other way I can get something out. The problem is (I don't know how serious this is), but my application uses iframes. If the error occured in an inner iframe, how do I get to display the error message in that iframe and not on the top-level iframe? You see what I'm saying. I hope I'm making sense guys. I'll appreciate your help Regards cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Digitally Signed Emails
Anyone successfully got a Digitally Signed Email system working which does not required PGP or something? You know the kind where you can add a trusted email certificate to an email via CF? N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be privileged.It is for the exclusive use of the intended recipient(s).If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
New HOTFIX breaks J2EE sessions!
Hi. I put this out under a different subject but got no response. The new hotfix released on 10/7 does not decode the JSESSIONID cookie. 1) If I manually set a JSESSIONID cookie based on a URL variable or whatnot, which I do when I move from one domain to another (such as a shared SSL URL when collecting payment info), it is URL encoded. 2) CF reads it but does not decode the value. It must think it is an invalid ID since the $ become %24. The session is sufficiently broken. Until now, as with any URL Encoded value, CF will decode it before processing it, comparing it, etc. My only workaround is to set the cookie with _javascript_. I don't want to rely on _javascript_. I need to get this to MM. I've got applications breaking all over the place. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How to suppress the Header and Footer info when printing fr o m a browser
There's also some scripting type stuff you can do in IE (search Microsoft's site) but when I looked into it, the time invested to do this far outweighed the benefit.Also, that means IE only...but it is out there. John Burns -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 5:05 AM To: CF-Talk Subject: RE: How to suppress the Header and Footer info when printing fr o m a browser If you want to make the change permanently, you *CAN* suppress the header and footer in IE by changing the following registry keys HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\PageSetup\header HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\PageSetup\footer Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF / PHP Forum ?
Looking to implement a public discussion forum... preferably free or low cost solution to plug into a client's site. Ease of setup is of course VERY important. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX and XML
Dave, thanks for the response. This is exactly the avenue I am pursuing. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, October 10, 2004 10:39 PM To: CF-Talk Subject: RE: CFMX and XML Can anyone point me to a good resource on XML and CFML, specifically on setting up to receive an outside XML transmission? Conceptually I'm a bit confused as to how to go about doing this. I am familiar with sending XML, and parsing the cfhttp.filecontent, and am setting up a page that will parse an incoming outside XML feed. I should be able to just provide a url to someone to post their xml to and be able to parse it without having to have them call a web service or something like that right? I don't know offhand of any specific resources that cover using XML within CFML, other than the CF documentation. That said, there simply isn't that much to it. If you want to receive XML, you receive it like you'd receive anything else - it's just text. You don't need to use a web services standard like SOAP or XML-RPC to do this, either. Usually, when people use HTTP POST to send XML, they send the XML as the HTTP request body, rather than within a form variable. You can access this by using the GetHTTPRequestData function. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF / PHP Forum ?
I set up phpBB very easy on our CF server.The table structure is easy to figure out.I use CF to automatically add users to the phpBB forum app. Marlon On Mon, 11 Oct 2004 09:31:51 -0400, Daniel Farmer [EMAIL PROTECTED] wrote: Looking to implement a public discussion forum... preferably free or low cost solution to plug into a client's site. Ease of setup is of course VERY important. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How to suppress the Header and Footer info when printing from a browser
Got not choice in the matter here.This is the corporate email system that we use and basically as long as it works internally for our employees that's all that matters as far as the tech guys are concerned. BTW:We are running Outlook 2000 SP1. Mario -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, October 10, 2004 2:34 PM To: CF-Talk Subject: Re: How to suppress the Header and Footer info when printing from a browser Mike Kear wrote: Thanks for reminding me Dave.Thanks to GMAIL's wonderful threading, I read and replied to what i thought was the whole discussion, only to find there were another three threads with similar but not exactly the same subject lines, that answered- but by then my post had already gone. That is not caused by Gmail. That is caused by Mario Ciliotta and John D. Burns using email applications that do not adhere to RFC 2822 section 3.6.4. Just placing blame where blame is due :-) Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: New HOTFIX breaks J2EE sessions!
have you filed a bug report? http://www.macromedia.com/support/email/wishform/ -- Hugo Ahlenius - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Bud [mailto:[EMAIL PROTECTED] | Sent: Monday, October 11, 2004 14:37 | To: CF-Talk | Subject: New HOTFIX breaks J2EE sessions! | | Hi. I put this out under a different subject but got no response. | | The new hotfix released on 10/7 does not decode the JSESSIONID cookie. | | 1) If I manually set a JSESSIONID cookie based on a URL | variable or whatnot, which I do when I move from one domain | to another (such as a shared SSL URL when collecting payment | info), it is URL encoded. | | 2) CF reads it but does not decode the value. It must think | it is an invalid ID since the $ become %24. | | The session is sufficiently broken. Until now, as with any | URL Encoded value, CF will decode it before processing it, | comparing it, etc. | | My only workaround is to set the cookie with _javascript_. I | don't want to rely on _javascript_. | | I need to get this to MM. I've got applications breaking all | over the place. | -- | | Bud Schneehagen - Tropical Web Creations, Inc. | | _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ | Web Based Solutions / eCommerce Development Hosting | http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll | Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF / PHP Forum ?
We've used PHPBB and YabbSE (now SMF).All are PHP based.I'd like to find a good CF version.I've thought of writing one, but haven't had time. John -Original Message- From: Daniel Farmer [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 9:32 AM To: CF-Talk Subject: CF / PHP Forum ? Looking to implement a public discussion forum... preferably free or low cost solution to plug into a client's site. Ease of setup is of course VERY important. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How to suppress the Header and Footer info when printing from a browser
What'd I do wrong?I'm just using Outlook 2003.Is there something non-RFC compliant about it? John Burns -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 9:44 AM To: CF-Talk Subject: RE: How to suppress the Header and Footer info when printing from a browser Got not choice in the matter here.This is the corporate email system that we use and basically as long as it works internally for our employees that's all that matters as far as the tech guys are concerned. BTW:We are running Outlook 2000 SP1. Mario -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, October 10, 2004 2:34 PM To: CF-Talk Subject: Re: How to suppress the Header and Footer info when printing from a browser Mike Kear wrote: Thanks for reminding me Dave.Thanks to GMAIL's wonderful threading, I read and replied to what i thought was the whole discussion, only to find there were another three threads with similar but not exactly the same subject lines, that answered- but by then my post had already gone. That is not caused by Gmail. That is caused by Mario Ciliotta and John D. Burns using email applications that do not adhere to RFC 2822 section 3.6.4. Just placing blame where blame is due :-) Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How to suppress the Header and Footer info when printing fr o m a browser
John, Where did you find the stuff on Microsofts site?I cannot find anything under the search, I guess I am using the wrong terms or something. Mario -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 8:56 AM To: CF-Talk Subject: RE: How to suppress the Header and Footer info when printing fr o m a browser There's also some scripting type stuff you can do in IE (search Microsoft's site) but when I looked into it, the time invested to do this far outweighed the benefit.Also, that means IE only...but it is out there. John Burns -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 5:05 AM To: CF-Talk Subject: RE: How to suppress the Header and Footer info when printing fr o m a browser If you want to make the change permanently, you *CAN* suppress the header and footer in IE by changing the following registry keys HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\PageSetup\header HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\PageSetup\footer Paul _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Array Question
Group: I have been trying to learn array's and have a problem that I am unable to solve. I have a 2 Dimension Array that has for this example a length of 5. I am needing to delete POS 3 of the array and then restructure the array with the new length of 4. Any Direction on this issue as I am at a loss. -- [] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How to suppress the Header and Footer info when printing fr o m a browser
Take a look at this link: http://msdn.microsoft.com/library/default.asp?url=""> ing/printpreview/reference/reference.asp I did a search for internet explorer print and it produced that.I think that's what I had gotten into.They're called print templates.I think you may have to download them to the client somehow like an activeX control or something, but I'm not sure.Like I said, I realized it wasn't a meta tag or some sort of header that I could send down from CF easily so I gave up on it.For me, the best option was to produce PDF files for printing. John Burns -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 9:49 AM To: CF-Talk Subject: RE: How to suppress the Header and Footer info when printing fr o m a browser John, Where did you find the stuff on Microsofts site?I cannot find anything under the search, I guess I am using the wrong terms or something. Mario -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 8:56 AM To: CF-Talk Subject: RE: How to suppress the Header and Footer info when printing fr o m a browser There's also some scripting type stuff you can do in IE (search Microsoft's site) but when I looked into it, the time invested to do this far outweighed the benefit.Also, that means IE only...but it is out there. John Burns -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 5:05 AM To: CF-Talk Subject: RE: How to suppress the Header and Footer info when printing fr o m a browser If you want to make the change permanently, you *CAN* suppress the header and footer in IE by changing the following registry keys HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\PageSetup\header HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\PageSetup\footer Paul _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Array Question
I think you're trying to make it too hard. CF automatically closes up arrays if you delete. So, all you need to do is cfset temp arraydeleteat(myarray, 4) - Original Message - From: Graham Pearson I have been trying to learn array's and have a problem that I am unable to solve. I have a 2 Dimension Array that has for this example a length of 5. I am needing to delete POS 3 of the array and then restructure the array with the new length of 4. Any Direction on this issue as I am at a loss. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How to suppress the Header and Footer info when printing from a browser
Burns, John D wrote: What'd I do wrong?I'm just using Outlook 2003.Is there something non-RFC compliant about it? You are not sending a References or In-Reply-To header as defined in RFC 2822 section 3.6.4. And just to make my position on SHOULD vs. MUST clear before debate starts: MS uses the propietary header Thread-id to convey the same information but in a propietary manner, from which I conclude there are no valid reasons per RFC 2119 section 3 to ignore the SHOULD. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How to suppress the Header and Footer info when printing from a browser
Jochem, Ok, I understand.Sorry about that.I'll call my buddy Bill Gates this afternoon and tell him to fix it :-)I wish it was that easy.Sorry if it's causing problems for people.I know that this is contrary to the RFC, but it surprises me that Gmail wouldn't handle the thread-id automatically due to the saturation of microsoft products. John -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 10:22 AM To: CF-Talk Subject: Re: How to suppress the Header and Footer info when printing from a browser Burns, John D wrote: What'd I do wrong?I'm just using Outlook 2003.Is there something non-RFC compliant about it? You are not sending a References or In-Reply-To header as defined in RFC 2822 section 3.6.4. And just to make my position on SHOULD vs. MUST clear before debate starts: MS uses the propietary header Thread-id to convey the same information but in a propietary manner, from which I conclude there are no valid reasons per RFC 2119 section 3 to ignore the SHOULD. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF / PHP Forum ?
I have written one which is located at http://forums.niesc.k12.in.us/index.cfm I am always up for suggestions on how to make it better. At the present time, It is powered by MySQL. At 08:46 AM 10/11/2004, you wrote: We've used PHPBB and YabbSE (now SMF).All are PHP based.I'd like to find a good CF version.I've thought of writing one, but haven't had time. John -Original Message- From: Daniel Farmer [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 9:32 AM To: CF-Talk Subject: CF / PHP Forum ? Looking to implement a public discussion forum... preferably free or low cost solution to plug into a client's site. Ease of setup is of course VERY important. Thanks -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:181159This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=6232.5677.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] [https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusionbusiness=donations%40houseoffusion.comundefined_quantity=cmd=_xclickDonations and Support] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=37 [] -- [] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
IS this an MX issue???
I just started having this problem, and I am not sure why. Normally we do a onsubmit() for manually checking some form variables. This has always worked nicely along with cfform checking. Now it seems that my manual onsubmit is REPLACED with the CF generated onsubmit. Is there some new way to do this or am I missing something? Is there some technique that allows me to use both CFform error checking and my own, or is this just a Monday brain lag while most people have off?? Thanks, Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How to suppress the Header and Footer info when printing from a browser
Burns, John D wrote: Ok, I understand.Sorry about that.I'll call my buddy Bill Gates this afternoon and tell him to fix it :-) Please do. Microsoft may not fix bugs in their products because it is the right thing to do, but it is rumoured they do listen if enough customers complain. Or vote with your feet and just stop using a Microsoft email solution. Sure, it might be convenient for you, but it is inconvenient for a much larger number of people on this list. Sorry if it's causing problems for people.I know that this is contrary to the RFC, but it surprises me that Gmail wouldn't handle the thread-id automatically due to the saturation of microsoft products. No product handles this automatically because there is no way to handle it automatically. You can guess a little bit based on the subject, but that will inevitably fail when people change the subject or use the same subject for a different thread. (Particular common with subjects like 'help' or 'urgent problem'.) Or can you describe an algorithm that will thread correctly without a References or In-Reply-To header? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Array Question
If I just try to do the ArrayDeleteAt(Session.UserCart, 3) within an ArrayLength of 4 I get the following message: The element at Position 1, of Dimension 2, of an array object used as part of an _expression_, cannot be found. Before I tried to delete one of the items from the cart, I had the following in the Array: Element 1 has the Array Header Info which has 7 child elements in it which are ProductID, ProductName, ProductOptionID, ProductOptionName, ProductQuantity, ProductOptionPrice, ProductPrice Element2 has 1, USA Flag Shirt, 0, 0, 1, 0, 0.01 Element3 has 2, 8 Round Wall Clock, 1, w/ Chapter Patch, 2, 0, 19.95 Element4 has 3, 10 Round Wall Clock, 0, 0, 3, 0, 16.95 And when I delete Element 3 which was placed in the Cart by accident, the cfdump shows that element4 has moved up to element3 and then shows element4 as being empty which produces the above error message. At 09:20 AM 10/11/2004, you wrote: I think you're trying to make it too hard. CF automatically closes up arrays if you delete. So, all you need to do is cfset temp arraydeleteat(myarray, 4) - Original Message - From: Graham Pearson I have been trying to learn array's and have a problem that I am unable to solve. I have a 2 Dimension Array that has for this example a length of 5. I am needing to delete POS 3 of the array and then restructure the array with the new length of 4. Any Direction on this issue as I am at a loss. -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:181164This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=6232.5677.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] [https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusionbusiness=donations%40houseoffusion.comundefined_quantity=cmd=_xclickDonations and Support] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=34 [] -- [] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
query of query question
Hi, I have a qoq like so, cfstoredproc procedure=LEO4_ADMIN_DISTINCT_DAILY datasource=#request.matrixDSN# username=#request.matrix# password=#request.neo# cfprocresult name=q_distinctData cfprocparam dbvarname=@customerid value=#attributes.id# cfsqltype=cf_sql_integer type=in cfprocparam dbvarname=@date value=#oneDay# cfsqltype=cf_sql_integer type=in cfprocparam dbvarname=@schname value=#attributes.macro# cfsqltype=cf_sql_varchar type=in /cfstoredproc cfquery dbtype=query name=q_qoq SELECT vehicleid FROM q_distinctData WHERE vehicleid in ('165','564') /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How to suppress the Header and Footer info when printing from a browser
Nope, you got me. :-)I am kinda stuck with the Microsoft solution due to my company using it.I'll try to put a complaint in with Microsoft. John -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 10:41 AM To: CF-Talk Subject: Re: How to suppress the Header and Footer info when printing from a browser Burns, John D wrote: Ok, I understand.Sorry about that.I'll call my buddy Bill Gates this afternoon and tell him to fix it :-) Please do. Microsoft may not fix bugs in their products because it is the right thing to do, but it is rumoured they do listen if enough customers complain. Or vote with your feet and just stop using a Microsoft email solution. Sure, it might be convenient for you, but it is inconvenient for a much larger number of people on this list. Sorry if it's causing problems for people.I know that this is contrary to the RFC, but it surprises me that Gmail wouldn't handle the thread-id automatically due to the saturation of microsoft products. No product handles this automatically because there is no way to handle it automatically. You can guess a little bit based on the subject, but that will inevitably fail when people change the subject or use the same subject for a different thread. (Particular common with subjects like 'help' or 'urgent problem'.) Or can you describe an algorithm that will thread correctly without a References or In-Reply-To header? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF / PHP Forum ?
if you have access to DRK, I remember there was a forum application in some of it previous versions. On Mon, 11 Oct 2004 09:31:51 -0400, Daniel Farmer [EMAIL PROTECTED] wrote: Looking to implement a public discussion forum... preferably free or low cost solution to plug into a client's site. Ease of setup is of course VERY important. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: query of query question
damn, I posted before I could get the rest in, I get this error, Error Executing Database Query. Query Of Queries runtime error. Unsupported type comparison. Is this possible, or is there a work around, for example does hal helms query sim tag support this. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Array Question
If I just try to do the ArrayDeleteAt(Session.UserCart, 3) within an ArrayLength of 4 I get the following message: The element at Position 1, of Dimension 2, of an array object used as part of an _expression_, cannot be found. Before I tried to delete one of the items from the cart, I had the following in the Array: Element 1 has the Array Header Info which has 7 child elements in it which are ProductID, ProductName, ProductOptionID, ProductOptionName, ProductQuantity, ProductOptionPrice, ProductPrice Element2 has 1, USA Flag Shirt, 0, 0, 1, 0, 0.01 Element3 has 2, 8 Round Wall Clock, 1, w/ Chapter Patch, 2, 0, 19.95 Element4 has 3, 10 Round Wall Clock, 0, 0, 3, 0, 16.95 And when I delete Element 3 which was placed in the Cart by accident, the cfdump shows that element4 has moved up to element3 and then shows element4 as being empty which produces the above error message. When you delete something from an array, the array is compressed. This is the correct behavior. I'm not sure why you have metadata in the first element; instead, if you want to track values by name you should use an array of structures: cfset Session.UserCart = ArrayNew(1) cfset Session.UserCart[1] = StructNew() cfset Session.UserCart[1].ProductID = 1 ... Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Access to cfschedule and cfindex/cfcollection listings
Does anyone know of a way via the CF service factory or some other way to be able to list the scheduled tasks that CF has and the collections and indexes that have been created?We're trying to lock down developer access to the CF Administrator and we've already created a tool using the service factory for adding and removing debugging IP addresses.The only other things we really need to set up for developers to access outside of the administrator is the listings of those portions of the administrator.Any help would be greatly appreciated. Thanks! John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF / PHP Forum ?
Qasim Rasheed wrote: if you have access to DRK, I remember there was a forum application in some of it previous versions. On Mon, 11 Oct 2004 09:31:51 -0400, Daniel Farmer [EMAIL PROTECTED] wrote: Looking to implement a public discussion forum... preferably free or low cost solution to plug into a client's site. Ease of setup is of course VERY important. Thanks Has cfmbb.org been mentioned yet? Haven't used it personally though. http://www.cfmbb.org/ -Jordan -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Slightly OT, load testing CF Applications.
What do people you to test their CF Applications/Sites? Any advice on what to avoid/try? Thanks Craig Dudley Senior Developer Netstep Corporate Communications Ltd Direct Line: +44(0) 1422 319712 Phone: +44(0) 1422 200308 Fax: +44(0) 1422 200306 e-mail: [EMAIL PROTECTED] MS Messenger: [EMAIL PROTECTED] www: www.netstep.co.uk [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL stored procedure question
Interesting arguments on parametric query and stored procedure's use with CF.Imho, the facts of the app itself, the developer's comfortness with tools at hand and the environment would be taken into consideration as well. I'll address the specific of the second query here, two points here: 1) I would move cfif px is search sort of logic out of the query itself, else, if the given table has millions of rows you want to return all? the output query MAXROWS attribute is not necessary a desirable practice, and on the other side, what if search condition is met, how does the MAXROWS attribute is going to play here ... in addition to the idea/concept of the separation of logic and query ... 2) it's easy to write a procedure to solve this problem, the KEY word is null, but setting parameter/argument default value to null is a starter but not good enough.Ponder on that, but if you don't want to do that, either follow up here or send me an email. Cheers, Don -Original Message- From: Pratte, Jeff [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 2:06 PM To: CF-Talk Subject: SQL stored procedure question OK, after hearing everybody say don't use Access and an converting my Check Request System to MS SQL Server. And I am trying to use Stored Procedures. However, I am finding it more difficult then I anticipated. For instance, I used to have a query like this: cfquery Name=qrySignoffRequest datasource=#application.SQLDB# blockfactor=100 select crID, SOffUser, SOffNote from qrySignoffRequest where SOffDecision = 'Open' and SOffUser = '#theUser#' order by #sort5# /cfquery My stored procedure attempt was this: CREATE PROCEDURE SignOffCheckRequest_Getx_byDecision_SoffUser @SoffUser varchar(10), @Decision varchar(10), @Sort varchar(10) AS selectcrID, SOffUser, SOffNote from viewSignoffCheckRequest where SOffDecision = @Decision and SOffUser = @SoffUser Order by CASE WHEN @Sort = 'crID' THEN crID WHEN @Sort = 'crDate' THEN crDate WHEN @Sort = 'crVendor' THEN crVendor WHEN @Sort = 'crChkAmt' THEN crChkAmt WHEN @Sort = 'SOffUser' THEN SOffUser END GO It worked for every type of sort except one (crVendor) where it said that it was trying to convert an nvarchar to a float. What's that all about? Then we come to this query: cfquery Name=qryCOA datasource=#application.ChartOfAccountsDB# username=abc password=xyz select * from WEBMASTER.AP_COA where 1=1 cfif px is search cfif isDefined(searchCO) and searchCO gt and ldr_entity_id like '#searchCO#%'/cfif cfif isDefined(searchPRIME) and searchPRIME gt and ull_prime like '#searchPRIME#%'/cfif cfif isDefined(searchCTR) and searchCTR gt and ull_center like '#searchCTR#%'/cfif cfif isDefined(searchSBU) and searchSBU gt and ull_sbu like '#searchSBU#%'/cfif cfif isDefined(searchPROD) and searchPROD gt and ull_product like '#searchPROD#%'/cfif cfif isDefined(searchMIN) and searchMIN gt and ull_minor like '#searchMIN#%'/cfif cfif isDefined(searchCUSTOMER) and searchCUSTOMER gt and ull_customer like '#searchCUSTOMER#%'/cfif cfif isDefined(searchMISC1) and searchMISC1 gt and ull_misc1 like '#searchMISC1#%'/cfif cfif isDefined(searchMISC2) and searchMISC2 gt and ull_misc2 like '#searchMISC2#%'/cfif /cfif /cfquery How do I convert that to a stored procedure? I am about to give up! Thanks for you help, Jeff Notice.This message is intended only for use by the person or entity to which it is addressed.Because it may contain confidential information intended solely for the addressee, you are notified that any disclosing, copying, downloading, distributing or retaining of this message, and any attached files, is prohibited and may be a violation of state or federal law.If you received this message in error, please notify the sender by reply email, and delete the message and all attached files.Thank you. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Verity Problem
So this is the problem ... I have an English collection (custom from db) which contains French words (eg. scurit, prsident).When searching the collection no results are returned even though the word exists. Any work arounds? I also have the same problem with German words with special characters. I can't create collections for French and German as the content is actually stored as part of the English version of the Reed Interactive sites.These are things like company names. Any help out there much appreciated This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be privileged.It is for the exclusive use of the intended recipient(s).If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFCONTENT and PDFs (Re: CFCONTENT and GetPageContext())
You should be able to specify a different name within your CFCONTENT tag: http://www.figleaf.com/demo/mimetest/ Dave Watts, CTO, Fig Leaf Software Dave, I had been using cfheader name=Content-Disposition value=inline; file=#myFormPath#/#myFormName# and have changed it to cfheader name=Content-Disposition value=inline; filename=#myFormName#. Now everything loads correctly in MSIE. Thanks very much. Adrian J. Moreno --- Factors of i, Inc. - http://FactorsOfi.com - Linux Web Hosting: CF/PHP with MySQL --- i Know Kung Foo Consulting - http://iKnowKungFoo.com - ColdFusionMX, Java, JBoss, JSP Struts - XML Database Development - Internationalization (i18n) --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Verity Problem
Apoliogies this was an internal problem mailed to me...here it is again.. I have an English collection (custom from db) which contains French words (eg. scurit, prsident).  When searching the collection no results are returned even though the word exists. Any work arounds? I also have the same problem with German words with special characters. The values it will not return are things like company names etc... Any ideas anyone? From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 11 October 2004 17:02 To: CF-Talk Subject: Verity Problem So this is the problem ... I have an English collection (custom from db) which contains French words (eg. scurit, prsident).  When searching the collection no results are returned even though the word exists. Any work arounds? I also have the same problem with German words with special characters. I can't create collections for French and German as the content is actually stored as part of the English version of the Reed Interactive sites.  These are things like company names. Any help out there much appreciated This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.  It contains information which is confidential and may also be privileged.  It is for the exclusive use of the intended recipient(s).  If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.  If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.  The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: query of query question
Is vehicleid field an integer or a varchar?If it's integer, you don't need the single quotes. WHERE vehicleid in (165,564) From: John mccosker [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 11:35 AM To: CF-Talk Subject: Re: query of query question damn, I posted before I could get the rest in, I get this error, Error Executing Database Query. Query Of Queries runtime error. Unsupported type comparison. Is this possible, or is there a work around, for example does hal helms query sim tag support this. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMX application security issue
OK, I just got our intranet migrated to MX on our development server using the CFLOGIN for user security. However, my managers find it unacceptable that users have to login again if they close the browser window. Does anyone have any suggestions for work arounds? This message has been scanned by the City of Renton's filtering gateway. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
grouping by...
Hi, I want to arrange my data that is being displayed by the database field importance. I want High to be shown first, then Normal, then Low (which are the 3 choices in the importance table). How can i get Normal items to show up before Low items? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX application security issue
Using cookies is the best way around this.As soon as a user logs in, store their authentication information to a cookie and then on the login page, write code to read your cookie and auto-log them in if it exists. From: Rebecca Wells [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 12:43 PM To: CF-Talk Subject: CFMX application security issue OK, I just got our intranet migrated to MX on our development server using the CFLOGIN for user security. However, my managers find it unacceptable that users have to login again if they close the browser window. Does anyone have any suggestions for work arounds? This message has been scanned by the City of Renton's filtering gateway. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX application security issue
OK, I just got our intranet migrated to MX on our development server using the CFLOGIN for user security. However, my managers find it unacceptable that users have to login again if they close the browser window. Does anyone have any suggestions for work arounds? Using cookies is the best way around this.As soon as a user logs in, store their authentication information to a cookie and then on the login page, write code to read your cookie and auto-log them in if it exists. The CFLOGIN tag already sets a cookie. You can simply rewrite this cookie as a persistent cookie using the CFCOOKIE tag. Note that CFLOGIN authentication will still time out after the specified inactivity period. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Sports
What a great time for sports in NY. We have another fall classic.The valiant and pure of heart Yankees defend everything that is good about baseball against the monstrous RedSox who allegedly commit such heinous crimes like ripping the tags off beds before purchase.Boo! The Jets are playing well too but the pleasant surprise are the Giants who have clearly established themselves as the second best team in the NFC east behind The Eagles.Not too bad considering how good the Eagles have been and how low expectations were for the Giants. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: grouping by...
assign another field to the importance table, maybe called priorityID priorityIDPriority 0 Low 1 Normal 2 High Then order by priorityID desc On Mon, 11 Oct 2004 12:30:37 -0400, Phillip Perry [EMAIL PROTECTED] wrote: Hi, I want to arrange my data that is being displayed by the database field importance. I want High to be shown first, then Normal, then Low (which are the 3 choices in the importance table). How can i get Normal items to show up before Low items? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: grouping by...
something like this work for you? select case when importance = 'high' then 1 whenimportance = 'normal' then 2 when importance = 'low' then 3 end as importance_order fromimportance_table order by importance_order -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 12:31 PM To: CF-Talk Subject: grouping by... Hi, I want to arrange my data that is being displayed by the database field importance. I want High to be shown first, then Normal, then Low (which are the 3 choices in the importance table). How can i get Normal items to show up before Low items? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Sports
I was going to comment on this one sometime today myself. Except my version includes the WORLD CHAMPION Patriots and the superbly awesome record-breaking performance that was witnessed yesterday, making them the only team in NFL history to win 19 in a row. As far as the Sox/Yankees, man I have queasy stomach already and the game is still a day and a half away!Bring on the Yanks! All in all, great time to be a sports fan in Boston, too! Valiant and pure of heart - GAG! Blah! At 12:51 PM 10/11/2004, you wrote: What a great time for sports in NY. We have another fall classic.The valiant and pure of heart Yankees defend everything that is good about baseball against the monstrous RedSox who allegedly commit such heinous crimes like ripping the tags off beds before purchase.Boo! The Jets are playing well too but the pleasant surprise are the Giants who have clearly established themselves as the second best team in the NFC east behind The Eagles.Not too bad considering how good the Eagles have been and how low expectations were for the Giants. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF / PHP Forum ?
Jordan Michaels wrote: Has cfmbb.org been mentioned yet? Haven't used it personally though. http://www.cfmbb.org/ Thanks for the mention... I haven't quite released the source yet but it'll happen soon... The forum on the DRK is called Galleon.It requires SQL Server.And you must purchase the DRK to be legally entitled to it, I think. Consider this another vote for phpBB if you need something quick and mature!I use phpBB on a variety of web sites. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: grouping by...
You can also use a CASE _expression_ like this: select ... from .. where .. order by case when priority = 'high' then 1 when priority = 'med' then 2 when priority = 'low' then 3 end The explicit priority table is a good idea too, and if you use it fully, will probably make the whole app cleaner. Mark -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 12:54 PM To: CF-Talk Subject: Re: grouping by... assign another field to the importance table, maybe called priorityID priorityIDPriority 0 Low 1 Normal 2 High Then order by priorityID desc On Mon, 11 Oct 2004 12:30:37 -0400, Phillip Perry [EMAIL PROTECTED] wrote: Hi, I want to arrange my data that is being displayed by the database field importance. I want High to be shown first, then Normal, then Low (which are the 3 choices in the importance table). How can i get Normal items to show up before Low items? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: IS this an MX issue??? Form Validation...
Must have stumped everyone today...Anyone with any clues??? I've spent most of the morning looking through macromedia and and the talk archives with really no luck... How do other people do form validation when they want to check form fields manually and also use CFform validation as well? Both use the onsubmit() _javascript_ function... Thanks, Jeff -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 10:36 AM To: CF-Talk Subject: IS this an MX issue??? I just started having this problem, and I am not sure why. Normally we do a onsubmit() for manually checking some form variables. This has always worked nicely along with cfform checking. Now it seems that my manual onsubmit is REPLACED with the CF generated onsubmit. Is there some new way to do this or am I missing something? Is there some technique that allows me to use both CFform error checking and my own, or is this just a Monday brain lag while most people have off?? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Sports
We have another fall classic.The valiant and pure of heart Yankees defend everything against the monstrous RedSox who allegedly commit such heinous crimes like ripping the tags off beds before purchase. Is this basketball or soccer? I don't know too much about sports teams And what does the inspection tags on beds have to do with sports? Sorry, I'm *really* confused here... -- Les Mizzell [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Slightly OT, load testing CF Applications.
We've been using MS Web Application Stress Tool http://www.microsoft.com/technet/archive/itsolutions/intranet/downloads/webs tres.mspx It's pretty simple to use, but I haven't really been impressed with the features. I, too, would like to see what else people are using out there. Russ _ From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 12:04 PM To: CF-Talk Subject: Slightly OT, load testing CF Applications. What do people you to test their CF Applications/Sites? Any advice on what to avoid/try? Thanks Craig Dudley Senior Developer Netstep Corporate Communications Ltd Direct Line: +44(0) 1422 319712 Phone: +44(0) 1422 200308 Fax: +44(0) 1422 200306 e-mail: [EMAIL PROTECTED] MS Messenger: [EMAIL PROTECTED] www: www.netstep.co.uk _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: grouping by...
If you want to do this in SQL, you can use the DECODE function.Let's say you have a table called TASKS, and you want to prioritize TASK_Name by TASK_Priority, High to Low: SELECT TASK_Name, DECODE(TASK_Priority,'High',1,'Normal',2,'Low',3) AS PriorityOrder FROM TASKS ORDER BY PriorityOrder If you can't use DECODE because of your platform, you could also try the tricky trick of using the third character in the TASK_Priority value, since that works out the way you want it (g-r-w): SELECT TASK_Name, SUBSTR(TASK_Priority,3,1) AS PriorityOrder FROM TASKS ORDER BY PriorityOrder Finally, if you don't have SUBSTR either, you could do this clumsy bit: SELECT TASK_Name, '1' AS PriorityOrder FROM TASKS WHERE TASK_Priority = 'High' UNION SELECT TASK_Name, '2' AS PriorityOrder FROM TASKS WHERE TASK_Priority = 'Normal' UNION SELECT TASK_Name, '3' AS PriorityOrder FROM TASKS WHERE TASK_Priority = 'Low' ORDER BY PriorityOrder HTH, Matthieu -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 12:31 PM To: CF-Talk Subject: grouping by... Hi, I want to arrange my data that is being displayed by the database field importance. I want High to be shown first, then Normal, then Low (which are the 3 choices in the importance table). How can i get Normal items to show up before Low items? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
currentrow is undefined?
Thanks for the info from my last question. Now here is my next issue. I am calling for information from 2 tables. I want to find out which row is even and which is odd from one of them. I'm using. cfif error_table.CurrentRow MOD 2 IS 1but this throws an error saying that currentrow is undefined. Yet if I take out the error_table. part it works, without ever finding the odd and even rows. I'm trying to use this to format the bgcolor and txtcolor of a tr td. The code is below. How do I fix this error. cfquery datasource=#mydbname# name=display SELECT * FROM error_table, importance /cfquery cfoutput query=display cfif error_table.CurrentRow MOD 2 IS 1 cfset bgcolor=white cfset txtcolor=black cfelse cfset bgcolor=black cfset txtcolor=white /cfif tr bgcolor=#bgcolor# style=text-color:#txtcolor#; Thanks for the help Phil [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: currentrow is undefined?
currentrow is local to the query, so all you need is CFIF currentrow mod 2 is 1 mailto:[EMAIL PROTECTED] _ From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 1:24 PM To: CF-Talk Subject: currentrow is undefined? Thanks for the info from my last question. Now here is my next issue. I am calling for information from 2 tables. I want to find out which row is even and which is odd from one of them. I'm using. cfif error_table.CurrentRow MOD 2 IS 1but this throws an error saying that currentrow is undefined. Yet if I take out the error_table. part it works, without ever finding the odd and even rows. I'm trying to use this to format the bgcolor and txtcolor of a tr td. The code is below. How do I fix this error. cfquery datasource=#mydbname# name=display SELECT * FROM error_table, importance /cfquery cfoutput query=display cfif error_table.CurrentRow MOD 2 IS 1 cfset bgcolor=white cfset txtcolor=black cfelse cfset bgcolor=black cfset txtcolor=white /cfif tr bgcolor=#bgcolor# style=text-color:#txtcolor#; Thanks for the help Phil _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: IS this an MX issue??? Form Validation...
On Mon, 11 Oct 2004 13:05:37 -0400, Jeff Wariswrote: How do other people do form validation when they want to check form fields manually and also use CFform validation as well? Both use the onsubmit() _javascript_ function... Simple. I don't use CFForm.I stopped trying to use it (except when teaching a class where it's in the material) back during the 4.5 days, for precisely the problem you're having. I was never very successful at getting my own custom validation to work with a cfform. Unless you're using one of the controls that requires it (cftree, etc.), I don't know of much use for it. Scott -- - Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: currentrow is undefined?
Phillip, In the CFQUERY tag, you define the name of the query as display.So the later CFIF statement should read CFIF Display.CurrentRow... instead.When you took out the error_table part, CF looked through the available variable scopes and found the data somewhere, but it may have been looking in another query.Changing it to explicitly refer to Display.CurrentRow should fix the problem. HTH, Matthieu -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 1:24 PM To: CF-Talk Subject: currentrow is undefined? Thanks for the info from my last question. Now here is my next issue. I am calling for information from 2 tables. I want to find out which row is even and which is odd from one of them. I'm using. cfif error_table.CurrentRow MOD 2 IS 1but this throws an error saying that currentrow is undefined. Yet if I take out the error_table. part it works, without ever finding the odd and even rows. I'm trying to use this to format the bgcolor and txtcolor of a tr td. The code is below. How do I fix this error. cfquery datasource=#mydbname# name=display SELECT * FROM error_table, importance /cfquery cfoutput query=display cfif error_table.CurrentRow MOD 2 IS 1 cfset bgcolor=white cfset txtcolor=black cfelse cfset bgcolor=black cfset txtcolor=white /cfif tr bgcolor=#bgcolor# style=text-color:#txtcolor#; Thanks for the help Phil _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: currentrow is undefined?
Also, your code might be more elegant (just my personal opinion) if you relegate colors to css classes, and keep your server-side processing to a minimum. style tr.row0{ text-color:black; background-color:white; } tr.row1{ text-color:white; background-color:black; } /style Cfoutput query=display trclass=row#(currentrow MOD 2)#content/tr /cfoutput _ From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 1:24 PM To: CF-Talk Subject: currentrow is undefined? Thanks for the info from my last question. Now here is my next issue. I am calling for information from 2 tables. I want to find out which row is even and which is odd from one of them. I'm using. cfif error_table.CurrentRow MOD 2 IS 1but this throws an error saying that currentrow is undefined. Yet if I take out the error_table. part it works, without ever finding the odd and even rows. I'm trying to use this to format the bgcolor and txtcolor of a tr td. The code is below. How do I fix this error. cfquery datasource=#mydbname# name=display SELECT * FROM error_table, importance /cfquery cfoutput query=display cfif error_table.CurrentRow MOD 2 IS 1 cfset bgcolor=white cfset txtcolor=black cfelse cfset bgcolor=black cfset txtcolor=white /cfif tr bgcolor=#bgcolor# style=text-color:#txtcolor#; Thanks for the help Phil _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Server performance article
Here's a really good article for those of you debating server upgrades: http://www.samag.com/documents/s=9408/sam0411b/0411b.htm -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Access to cfschedule and cfindex/cfcollection listings
At 11:42 AM 10/11/2004, you wrote: Does anyone know of a way...to list the scheduled tasks that CF has H, I was just wondering that myself yesterday, but hadn't looked into it yet. Anyone? Anders +===+ |Anders GreenEmail: [EMAIL PROTECTED] | |Home: 919.303.0218| |Off Road Rally Racing Team: http://linaracing.com/ | +===+ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: IS this an MX issue??? Form Validation...
yeah, I usually take the path of not using cfform.I find it fairly limited anyhoo. Jeff, you can look at teh onsubmit and passthrough attributes of cfform to add some of your on code.IIRC, what you put in onsubmit is 'attached' after the CFFORM onsubmit function fires. DK On Mon, 11 Oct 2004 11:27:35 -0600, Scott Brady [EMAIL PROTECTED] wrote: On Mon, 11 Oct 2004 13:05:37 -0400, Jeff Wariswrote: How do other people do form validation when they want to check form fields manually and also use CFform validation as well? Both use the onsubmit() _javascript_ function... Simple. I don't use CFForm.I stopped trying to use it (except when teaching a class where it's in the material) back during the 4.5 days, for precisely the problem you're having. I was never very successful at getting my own custom validation to work with a cfform. Unless you're using one of the controls that requires it (cftree, etc.), I don't know of much use for it. Scott -- - Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Sports
Baseball.Baseball is a big sport in Boston and New York, we are *ahem* heated rivals If you're not part of it right now, you probably won't get it.Much like heroin, baseball payoffs between the Red Sox and Yankees should be avoided by non-fans, as it will suck you in and destroy your life, at least if you become a Red Sox fan. At 12:59 PM 10/11/2004, you wrote: We have another fall classic.The valiant and pure of heart Yankees defend everything against the monstrous RedSox who allegedly commit such heinous crimes like ripping the tags off beds before purchase. Is this basketball or soccer? I don't know too much about sports teams And what does the inspection tags on beds have to do with sports? Sorry, I'm *really* confused here... -- Les Mizzell [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Slightly OT, load testing CF Applications.
pu it in produciton and see what happens!:)I've used the M$ webstress tool also. Craig, you asking about stress testing or unit type testing? Doug On Mon, 11 Oct 2004 13:06:20 -0400, Russ [EMAIL PROTECTED] wrote: We've been using MS Web Application Stress Tool http://www.microsoft.com/technet/archive/itsolutions/intranet/downloads/webs tres.mspx It's pretty simple to use, but I haven't really been impressed with the features. I, too, would like to see what else people are using out there. Russ _ From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 12:04 PM To: CF-Talk Subject: Slightly OT, load testing CF Applications. What do people you to test their CF Applications/Sites? Any advice on what to avoid/try? Thanks Craig Dudley Senior Developer Netstep Corporate Communications Ltd Direct Line: +44(0) 1422 319712 Phone: +44(0) 1422 200308 Fax: +44(0) 1422 200306 e-mail: [EMAIL PROTECTED] MS Messenger: [EMAIL PROTECTED] www: www.netstep.co.uk _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFHTTP 408 Request Time-Out
Hi, For some reason... out of the blue.. CFHTTP would start giving out 408 Request Time-Outs to A https URL... I have tested the URL with wget it works fine.. and telnet to the port 443... can connect from diffrent MX6.1 servers... and I can connect to other SSL URLs fine from the same server.. but not the URL where I get the 408 Request Time-Out untill I restart cold fusion server... any suggestions are very much appreciated.. RedHat As 2.1 Apache 2.0.50 CFMX 6,1,0,63958 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Java 1.5
Ayone using Java 1.5 with CF. Any speed increase noted? Problems? Comments? Is it something that should be upgraded to? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Slightly OT, load testing CF Applications.
I've used OpenSTA in the past with pretty good results. If you want to do some really heavy duty testing and can afford the licenses there are a couple that I'm aware of. When I used to teach the ColdFusion Performance Tuning class a few years back we used Segue SilkPerformer. It was one of the best tools on the market at the time and had a feature set similar to OpenSTA. I haven't used it since about 2000 though and can't comment on what they've done with the prodcut since then. I've also heard good things about Mercury LoadRunner, but I haven't used it myself. Spike Craig Dudley wrote: What do people you to test their CF Applications/Sites? Any advice on what to avoid/try? Thanks Craig Dudley Senior Developer Netstep Corporate Communications Ltd Direct Line: +44(0) 1422 319712 Phone: +44(0) 1422 200308 Fax: +44(0) 1422 200306 e-mail: [EMAIL PROTECTED] MS Messenger: [EMAIL PROTECTED] www: www.netstep.co.uk [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Slightly OT, load testing CF Applications.
Our load testing lab uses e-TEST Suite 7.0 from Empirix, plus a few other tools for generating production scale data, analyzing database internals under load, etc. We provide this as a service, if you're interested. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive Training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! - Original Message - From: Craig Dudley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 11, 2004 11:51 AM Subject: Slightly OT, load testing CF Applications. What do people you to test their CF Applications/Sites? Any advice on what to avoid/try? Thanks Craig Dudley Senior Developer Netstep Corporate Communications Ltd Direct Line: +44(0) 1422 319712 Phone: +44(0) 1422 200308 Fax: +44(0) 1422 200306 e-mail: [EMAIL PROTECTED] MS Messenger: [EMAIL PROTECTED] www: www.netstep.co.uk [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Sports
Please move this to CF-Community as it's off topic for CF-Talk. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
why can't they log in?
I have inherited a rather simple application that has a section where listees of an online directory can add/edit/delete their account info once logging in to the system. I am having a very small percentage of the users telling me that they are having troubles logging in.The system does not allow them to log in using their user/pass combo.Yet, when I look up their account info, I and just about everyone else can log in easily.There is no complicated script, basically we are just using cfapplication and a database to check if they are registered, and if there is a match in the db, then we set their login status to 'logged in'. The weird thing about this is that most ppl (there are over 20,000 listees) can get in fine.Just a handful are having problems.I have verified that they are using the right user/pass, they have cookies turned on, etc.Anybody got any idea what the issue may be?Can firewalls cause this kind of behavior? Stumped, Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: why can't they log in?
We've had similar problems with software firewalls (specifically Norton) and proxy servers. HTH. --Ben Ray Champagne wrote: I have inherited a rather simple application that has a section where listees of an online directory can add/edit/delete their account info once logging in to the system. I am having a very small percentage of the users telling me that they are having troubles logging in.The system does not allow them to log in using their user/pass combo.Yet, when I look up their account info, I and just about everyone else can log in easily.There is no complicated script, basically we are just using cfapplication and a database to check if they are registered, and if there is a match in the db, then we set their login status to 'logged in'. The weird thing about this is that most ppl (there are over 20,000 listees) can get in fine.Just a handful are having problems.I have verified that they are using the right user/pass, they have cookies turned on, etc.Anybody got any idea what the issue may be?Can firewalls cause this kind of behavior? Stumped, Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
ebags
I know ebags.com is written in CF but I'm having major problems with their site and their customer support people.First of all the website didn't calculate my shipping correctly.I noticed this and called them about it without submitting my order.I was told to submit my order and that the incorrect charges would be credited back to me within 3 days. The order was processed very late and my estimated date of delivery has been passed by a week.Further more the bogus charges have not been undone.Now they are telling me it might take up to 2 billing cycles to unwind the over charges.Numerous emails to ebags have be sent back and forth and little has been done. I'm this close to canceling my order on the basis of principle and by principle I mean money. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ebags
At 15:13 10/11/2004 -0400, Won Lee wrote: I know ebags.com is written in CF but I'm having major problems with their site and their customer support people.First of all the website didn't calculate my shipping correctly.I noticed this and called them about it without submitting my order.I was told to submit my order and that the incorrect charges would be credited back to me within 3 days. The order was processed very late and my estimated date of delivery has been passed by a week.Further more the bogus charges have not been undone.Now they are telling me it might take up to 2 billing cycles to unwind the over charges.Numerous emails to ebags have be sent back and forth and little has been done. I'm this close to canceling my order on the basis of principle and by principle I mean money. Please excuse me.I switched the cf-talk and cf-community nickname in my email client. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF / PHP Forum ?
Check this out. http://www.adersoftware.com/index.cfm?page=cfbb The Forums here is free and seems to be good only problem is you have to stick with MSSQL2000 for DB. Ketan Patel _ From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 1:00 PM To: CF-Talk Subject: Re: CF / PHP Forum ? Jordan Michaels wrote: Has cfmbb.org been mentioned yet? Haven't used it personally though. http://www.cfmbb.org/ Thanks for the mention... I haven't quite released the source yet but it'll happen soon... The forum on the DRK is called Galleon.It requires SQL Server.And you must purchase the DRK to be legally entitled to it, I think. Consider this another vote for phpBB if you need something quick and mature!I use phpBB on a variety of web sites. - Rick _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: why can't they log in?
Are you saying you can log into the application from your PC using their username and password, but the user cant log in from their location? Thanks, CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Slightly OT, load testing CF Applications.
On Mon, 11 Oct 2004 16:51:53 +0100, Craig Dudley [EMAIL PROTECTED] wrote: What do people you to test their CF Applications/Sites? Any advice on what to avoid/try? We use Microsoft WAST (free) for simple stuff and Segue SilkPerformer ($$$) for heavy duty testing. -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Got Gmail? -- I have 2 invites If you're not annoying somebody, you're not really alive. -- Margaret Atwood [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: why can't they log in?
100% correct. Ray At 03:48 PM 10/11/2004, you wrote: Are you saying you can log into the application from your PC using their username and password, but the user cant log in from their location? Thanks, CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: DB Design - Bad Case of the Mondays
I've got a db that includes the following tables: Accounts -- AccountID PK Name AccountRepID FK Users -- UserID PK Name Username Password AccountID FK UserType The Users table will be used for logins to the system.In the Users table will be SysAdminssystem administrators AccountRepsaccount sales representatives AccountOwners Account owners AccountUsersAcount editors I have a 1:1 relationship from Accounts to sales reps in the Users.But I'd also like a many:1 relationship from Users who either own accounts or are editors of those accounts.I can't have both relationships. How best to approach this? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Web services in FB3
Hello, I am trying to create a web service that requires may of the same global vars as my FB3 app that it pertains to. Rather than trying to recreate all the vars, I would like to somehow have people call it remotely from other apps, using syntax that would invoke it from inside the FB3 architecture. Do you know if that is that possible? Thank you! the_tree [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: DB Design - Bad Case of the Mondays
I would look at it like this: There's a many:1 relationship users:accounts.Salesrep:account is a subset of this relationship.The 1:1 nature of this is a restraint I'd enforce outside the DB proper. That is, I would check to see if there's a user for the account where the usertype is salesrep before inserting another one. Alternately, there's no reason (that I know of) that you can't have both relationships.Users are related to accounts which are related to their official sales rep.The main problem I see with this is it could get a little confusing. Someone with a deeper knowledge of SQL (or who is smarter than me) might have a better idea. --Ben Jim McAtee wrote: I've got a db that includes the following tables: Accounts -- AccountID PK Name AccountRepID FK Users -- UserID PK Name Username Password AccountID FK UserType The Users table will be used for logins to the system.In the Users table will be SysAdminssystem administrators AccountRepsaccount sales representatives AccountOwners Account owners AccountUsersAcount editors I have a 1:1 relationship from Accounts to sales reps in the Users.But I'd also like a many:1 relationship from Users who either own accounts or are editors of those accounts.I can't have both relationships. How best to approach this? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: DB Design - Bad Case of the Mondays
Perhaps add a third table AuthorizedUsers that allows a many to one between users and accounts. You can maintain the one-one relationship between accounts and Users to represent the primary uber-authorized user. -Patti I've got a db that includes the following tables: Accounts -- AccountID PK Name AccountRepID FK Users -- UserID PK Name Username Password AccountID FK UserType The Users table will be used for logins to the system.In the Users table will be SysAdminssystem administrators AccountRepsaccount sales representatives AccountOwners Account owners AccountUsersAcount editors I have a 1:1 relationship from Accounts to sales reps in the Users.But I'd also like a many:1 relationship from Users who either own accounts or are editors of those accounts.I can't have both relationships. How best to approach this? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Mirroring CFMX Configurations...
Cool ... Thanks for the info. If you don't mind I have another question. Do you use a Hardware Load-Balancer or is it software? Thanks, - Charles On Oct 8, 2004, at 6:31 PM, Josh wrote: Linux!awesome...we run a small farm of linux servers ourselves. Just copy the appropriate xml files and you should be good to go: some of the jrun settings are in here: /opt/coldfusionmx/runtime/servers/default/SERVER-INF/ DSNs: /opt/coldfusionmx/lib/neo-query.xml Mappings: /opt/coldfusionmx/lib/neo-runtime.xml Verity: /opt/coldfusionmx/lib/neo-verity.xml Scheduled Jobs: /opt/coldfusionmx/lib/neo-cron.xml There are morebut you get the idea. Don't forget your JVM settings, and to sync up any JARs in your classpath. Good luck! -Josh -- Exciteworks, Inc Expert Hosting for less! *Ask for a free 30 day trial!* http://exciteworks.com Plans starting at -$12.95- including MS SQL Server! -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Slightly OT, load testing CF Applications.
We use Microsoft WAST (free) for simple stuff ... But Sean, that only runs on Windows! Given the length of a typical load test, I'm surprised you can hold your nose that long. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Mirroring CFMX Configurations...
Charles Heizer wrote: Cool ... Thanks for the info. No prob, glad to help. If you don't mind I have another question. Do you use a Hardware Load-Balancer or is it software? I have used both. I prefer hardware load balancing...but it can be pricey! -- Exciteworks, Inc Expert Hosting for less! *Ask for a free 30 day trial!* http://exciteworks.com Plans starting at -$12.95- including MS SQL Server! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Slightly OT, load testing CF Applications.
too bad OpenSTA has only win GUI.. try Jmeter http://jakarta.apache.org/jmeter/ If you need to get a hold of... system resource data.. etc.. etc.. try Nagios (windows plugins are available) and have the output put into a DB.. and then use CF to graph.. and it won't taint your results.. I think the plugins take.. max 300K mem.. If you are going with Commercial ware.. I would only recommend that course.. if you need to graph out rest of your network performance.. and other hardware... Regards, -- Umer Farooq Octadyne Systems [EMAIL PROTECTED] +1 (519) 772-5424 voice +1 (519) 635-2795 mobile +1 (208) 275-3824 fax LOOKING FOR A USED CAR IN IOWA VISIT: http://www.IowaMotors.com WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not theintended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited.If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. Spike wrote: I've used OpenSTA in the past with pretty good results. If you want to do some really heavy duty testing and can afford the licenses there are a couple that I'm aware of. When I used to teach the ColdFusion Performance Tuning class a few years back we used Segue SilkPerformer. It was one of the best tools on the market at the time and had a feature set similar to OpenSTA. I haven't used it since about 2000 though and can't comment on what they've done with the prodcut since then. I've also heard good things about Mercury LoadRunner, but I haven't used it myself. Spike Craig Dudley wrote: What do people you to test their CF Applications/Sites? Any advice on what to avoid/try? Thanks Craig Dudley Senior Developer Netstep Corporate Communications Ltd Direct Line: +44(0) 1422 319712 Phone: +44(0) 1422 200308 Fax: +44(0) 1422 200306 e-mail: [EMAIL PROTECTED] MS Messenger: [EMAIL PROTECTED] www: www.netstep.co.uk [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Slightly OT, load testing CF Applications.
ROFL That's the funniest thing I've seen on this list in a long time. Dave Watts wrote: We use Microsoft WAST (free) for simple stuff ... But Sean, that only runs on Windows! Given the length of a typical load test, I'm surprised you can hold your nose that long. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Mirroring CFMX Configurations...
I'm using a BigIP 2400 from F5. I was wondering if you have any issues with loadblancing and using Sessions. I have SSL configured and it won't keep or set the session, but if I take one of the two hosts off-line it works fine. Thanks, - Charles On Oct 11, 2004, at 2:13 PM, Josh wrote: Charles Heizer wrote: Cool ... Thanks for the info. No prob, glad to help. If you don't mind I have another question. Do you use a Hardware Load-Balancer or is it software? I have used both. I prefer hardware load balancing...but it can be pricey! -- Exciteworks, Inc Expert Hosting for less! *Ask for a free 30 day trial!* http://exciteworks.com Plans starting at -$12.95- including MS SQL Server! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Slightly OT, load testing CF Applications.
On Mon, 11 Oct 2004 16:47:37 -0400, Dave Watts [EMAIL PROTECTED] wrote: We use Microsoft WAST (free) for simple stuff ... But Sean, that only runs on Windows! Given the length of a typical load test, I'm surprised you can hold your nose that long. LOL!!! I do try to stay out of the QA lab where all the Windows boxes are that run our load tests :) -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Got Gmail? -- I have 2 invites If you're not annoying somebody, you're not really alive. -- Margaret Atwood [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
ot: css ?
is there a way to override a body tag? what the problem is that i have 1 page that i want a white bg on but in my css i have an image bg in my body tag and i need the css file in there and dont really want to add another for validation purposes. so again, is there a way to be able to over ride the css files settings? thank ya [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SQL Query Help Please.
Hello! I am trying to create a join of four tables to get data from a db in the format I want. The Database tables and fields are: Orders (orderid,customerid,Orderdate) OrderDetails(Orderid,UnitPrice,productid,quantity) Customer(Customerid, customername, address) CustomerPayments(orderid,PaymentReceived) My purpose is to track the account status of the customer for each order they have placed. The desired format of result obtained from the query is like this: Customername, Orderid, Orderdate,AmountReceived, AmountDue(this is a calculated column). I am using Access 2000 with CFusion. 1.)Can someonehelp me with the SQL syntax please. I have tried several permutations and combinations of sql (to the best of my knowledge) but without success. 2.) Can someone please suggest a good book on SQL syntax that will clear thing up for me. Many Thanks in Advance, Mark Taylor Admin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ot: css ?
just define a new css body tag for that page.. with transparent image as background...CSS takes the last defined setting... dave wrote: is there a way to override a body tag? what the problem is that i have 1 page that i want a white bg on but in my css i have an image bg in my body tag and i need the css file in there and dont really want to add another for validation purposes. so again, is there a way to be able to over ride the css files settings? thank ya [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Scopes. Which are nested?
I'm looking to cfdump out data as part of an error handler and don't want to repeat myself.Especially since I am storing data in a db with a finite field size.I know the cfcatch scope is contained within the variables scope (so I don't need to cfdump out both to get the cfcatch data) but are there others?Specifically the following: ERROR,ATTRIBUTES,CALLER,THIS,THISTAG Are they also inside of the variables scope?Seems to me Error is not, but the rest I don't have much experience dumping out. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL Query Help Please.
Hi, http://www.techonthenet.com/access/queries/joins1.htm For beginner I would suggest.. SAMS SQL in 21 Days.. and Google.. :-) Nomad wrote: Hello! I am trying to create a join of four tables to get data from a db in the format I want. The Database tables and fields are: Orders (orderid,customerid,Orderdate) OrderDetails(Orderid,UnitPrice,productid,quantity) Customer(Customerid, customername, address) CustomerPayments(orderid,PaymentReceived) My purpose is to track the account status of the customer for each order they have placed. The desired format of result obtained from the query is like this: Customername, Orderid, Orderdate,AmountReceived, AmountDue(this is a calculated column). I am using Access 2000 with CFusion. 1.)Can someonehelp me with the SQL syntax please. I have tried several permutations and combinations of sql (to the best of my knowledge) but without success. 2.) Can someone please suggest a good book on SQL syntax that will clear thing up for me. Many Thanks in Advance, Mark Taylor Admin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ot: css ?
i had already tried something similiar with no success :( -- Original Message -- From: Umer Farooq [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Mon, 11 Oct 2004 18:29:46 -0400 just define a new css body tag for that page.. with transparent image as background...CSS takes the last defined setting... dave wrote: is there a way to override a body tag? what the problem is that i have 1 page that i want a white bg on but in my css i have an image bg in my body tag and i need the css file in there and dont really want to add another for validation purposes. so again, is there a way to be able to over ride the css files settings? thank ya [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ot: css ?
are you sure.. as this works.. in IE and Firefox.. !-- normal css -- link rel=stylesheet type=text/css href=""> !-- overwrite css -- style type=text/css body { background: #FF url(/images/spacer.gif) repeat-x; } /style dave wrote: i had already tried something similiar with no success :( -- Original Message -- From: Umer Farooq [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Mon, 11 Oct 2004 18:29:46 -0400 just define a new css body tag for that page.. with transparent image as background...CSS takes the last defined setting... dave wrote: is there a way to override a body tag? what the problem is that i have 1 page that i want a white bg on but in my css i have an image bg in my body tag and i need the css file in there and dont really want to add another for validation purposes. so again, is there a way to be able to over ride the css files settings? thank ya [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ot: css ?
You just have to be more specific... body { color:red; } html body { color:green; } your text will be green because the 2nd selector is more specific. If you wanted to be even more specific: htmlbody { color:blue; } but the direct descendant selector only works in newer browsers (firefox, etc.). Here's an idea, why not do: body class=#listFirst(listLast(cgi.script_name, /), .)# so if your page is /files/folder/mypage.cfm, it should output body class=mypage, then you just use the class on the selector... body.page { color:pink; } good luck -nathan strutz http://www.dopefly.com/ dave wrote: is there a way to override a body tag? what the problem is that i have 1 page that i want a white bg on but in my css i have an image bg in my body tag and i need the css file in there and dont really want to add another for validation purposes. so again, is there a way to be able to over ride the css files settings? thank ya [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ot: css ?
actually i do think its done, i tried using a color and that didnt work so i followed the other suggestion but instead of a transparent bg i made a white one and wrote that in and that workd. thanks all [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Outputting Structure Key Problem
The following code below can be seen at http://www.tcmtests.com/files/codetest.cfm When I try append the following code to it I get an error that the variable Sleep is not defined cfouput#Score.Sleep#/cfoutput How can I output the structure key value that I want? --- cfquery name=GetAverages select AVG(QuizPercent) as AvgPercent, QuizIDfrom test_board_biomed GROUP BY QuizID /cfquery cfdump var=#GetAverages# label=new cfset Score = StructNew() cfoutput query=GetAverages cfset Result = StructInsert(Score,QuizID,AvgPercent) /cfoutput cfoutputCount: #StructCount(Score)#/cfoutput cfloop collection=#score# item=x cfoutput#x# #Score[x]#/cfoutputbr /cfloop [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Outputting Structure Key Problem
The following code below can be seen at http://www.tcmtests.com/files/codetest.cfm When I try append the following code to it I get an error that the variable Sleep is not defined cfouput#Score.Sleep#/cfoutput How can I output the structure key value that I want? --- cfquery name=GetAverages select AVG(QuizPercent) as AvgPercent, QuizIDfrom test_board_biomed GROUP BY QuizID /cfquery cfdump var=#GetAverages# label=new cfset Score = StructNew() cfoutput query=GetAverages cfset Result = StructInsert(Score,QuizID,AvgPercent) /cfoutput cfoutputCount: #StructCount(Score)#/cfoutput cfloop collection=#score# item=x cfoutput#x# #Score[x]#/cfoutputbr /cfloop [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL Query Help Please.
Here's a start, though you'll have to explain your tables and your calculations further. SELECT c.Customername, a.Orderid, a.Orderdate, ( where is this being stored? AmountReceived maybe this could be d.PaymentReceivedAS AmountReceived ? ), ( put your formula for calculating AmountDue here, possibly a subquery ) FROMOrders a, OrderDetails b, Customer c, CustomerPayments d WHERE a.orderid = b.orderid AND a.orderid = d.orderid AND c.customerid = a.customerid Hope that helps some... I would recomend the SQL book by forta, or just look online for a good tutorial. -Josh -- Exciteworks, Inc Expert Hosting for less! *Ask for a free 30 day trial!* http://exciteworks.com Plans starting at -$12.95- including MS SQL Server! Nomad wrote: Hello! I am trying to create a join of four tables to get data from a db in the format I want. The Database tables and fields are: Orders (orderid,customerid,Orderdate) OrderDetails(Orderid,UnitPrice,productid,quantity) Customer(Customerid, customername, address) CustomerPayments(orderid,PaymentReceived) My purpose is to track the account status of the customer for each order they have placed. The desired format of result obtained from the query is like this: Customername, Orderid, Orderdate,AmountReceived, AmountDue(this is a calculated column). I am using Access 2000 with CFusion. 1.)Can someonehelp me with the SQL syntax please. I have tried several permutations and combinations of sql (to the best of my knowledge) but without success. 2.) Can someone please suggest a good book on SQL syntax that will clear thing up for me. Many Thanks in Advance, Mark Taylor Admin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
locale of the JVM
How do you edit the locale of the JVM? Is there a way of setting this without using SetLocale When I use getLocale on one of my servers I get English US, the other is English Australian Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: locale of the JVM
At a guess it's taken from the OS it's on, not sure if that's any help but! Ade -Original Message- From: Paul Wilson [mailto:[EMAIL PROTECTED] Sent: 12 October 2004 02:31 To: CF-Talk Subject: locale of the JVM How do you edit the locale of the JVM? Is there a way of setting this without using SetLocale When I use getLocale on one of my servers I get English US, the other is English Australian Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]