Re: Coldfusion 8 on Linux Installation ( Linus ver. ie. Aspire One laptop )
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have CF8 running on Debian 4 on a P3-800 MHz 512MB RAM, 12GB HDD I have 256MB assigned to the JVM, and it works fine for a small app. I'm sure you'll run into memory issues, though, if your app needs it. Don wrote: Anyone else? thoughts or opinions? I looked at it and it seems to come with 512MB, now about a week ago I tried to Install ColdFusion on one of my old desktops and it would not start till i put 1.5GB of ram. The Jrun just gives memory errors so..., I know on Adobe it says Minimum of 512MB but I never was able to install. It was on a CentOS box. laptop ) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311552 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Centering text written on an image
I think you have to figure out the offset, and start from there. So, you'll need to determine the approximate width in pixels of your text string, But the quetion is how? How can I find the width of the string? I tried making a table of widths and that does not work really. For example with the strings AWA and HWH with Arial font the A is wider than H the kerning means that HWH is wider. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311553 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Centering text written on an image
Is there a way to add an extra step or two and make an image of just your text, determine that width which gives you your string width, then with that info in hand, write your text onto your image? Rick -Original Message- From: Kevin Roche [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 6:04 AM To: CF-Talk Subject: Re: Centering text written on an image I think you have to figure out the offset, and start from there. So, you'll need to determine the approximate width in pixels of your text string, But the quetion is how? How can I find the width of the string? I tried making a table of widths and that does not work really. For example with the strings AWA and HWH with Arial font the A is wider than H the kerning means that HWH is wider. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311554 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Centering text written on an image
that's exactly what i am doing for my client who wants to create custom ads for their products (tours). my situation is easier in a way that the ads are pre-st size and i have a transparent .png of same size to put text on, add shadows etc, and then overlay it over the product image. easy as pie with cf8 and imageUtils.cfc from Ray/Ben Co. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Rick Faircloth wrote: Is there a way to add an extra step or two and make an image of just your text, determine that width which gives you your string width, then with that info in hand, write your text onto your image? Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311555 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL injection attack on House of Fusion
Just got nailed myself - dammit - 15 years of knowledge. Have code reviewed and wasn't my CFML (at this stage) so maybe a new IIS vulnerability? My attack occured recently - possibly in the last 24 hours or so. Have disabled the database and CFABORTed any code that interacts with the database until I can solve the disastrous problem (apparently the attack came from China). Sigh! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311556 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Centering text written on an image
You will also find related functions in ImageUtils as well. If I remember right we (CFC was made by Ben Nadel, myself, and others) also have a generic 'getSize' func for text as well. Either way though, the CFC makes this operation trivial. On Fri, Aug 22, 2008 at 1:03 PM, Chris Blackwell [EMAIL PROTECTED] wrote: Hi, I want to add some text to an image but have it centered rather than left justified. Does anyone know how to do that? Kevin Roche http://imageutils.riaforge.org/ - getCenteredTextPosition() ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311557 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Centering text written on an image
Is there a way to add an extra step or two and make an image of just your text, determine that width which gives you your string width I have no Idea how to do that. Can you tell me how to find the width of the text? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311558 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFHTTP and SSL
Is your cert self-signed or was it purchased from a place like Thawte? I ran into this a few years back... CFHTTP flat out failed with a self signed cert. I feel your pain. Took me better part of a day to figure out wft was going on. You have to register the cert with CF some how. I forgot what I did to get it to work but I found the solution in the docs. HTH G -- If everything seems under control, you're not going fast enough -- Mario Andretti ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311559 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Centering text written on an image
Yes, again, the CFC has a way to get the height/width of _just_ a textual component. On Tue, Aug 26, 2008 at 7:42 AM, Kevin Roche [EMAIL PROTECTED] wrote: Is there a way to add an extra step or two and make an image of just your text, determine that width which gives you your string width I have no Idea how to do that. Can you tell me how to find the width of the text? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311560 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Centering text written on an image
What I'm thinking is trying to avoid determining the text width by creating an image of just the text and measuring that. Once you have that width information, you can use it to determine how to center the text when you apply it to the background image. Such as: Here's your text: MyText Create an image of just that text: |MyText| and determine width: 220px Here's your background: - | | - Background image width: 540px Difference: 540px - 220px = 320px Half that is left offset: 160px Use that info (160px) as the basis for centering your text. Does that make sense? I know you can get the width of an image using javascript (jQuery recommended), but the others have also pointed to some other potential resources... CFC's, etc. Hope this helps...I'm going to need a solution to this at some point, too! (Realize I haven't worked with applying text to images, yet, so my approach may be totally off-base. Just thinking out loud...which may be a bad idea before coffee :o) Rick -Original Message- From: Kevin Roche [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 8:43 AM To: CF-Talk Subject: Re: Centering text written on an image Is there a way to add an extra step or two and make an image of just your text, determine that width which gives you your string width I have no Idea how to do that. Can you tell me how to find the width of the text? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311561 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL injection attack on House of Fusion
Have code reviewed and wasn't my CFML (at this stage) so maybe a new IIS vulnerability? I seriously doubt this has anything to do with IIS, since IIS can't interact directly with your database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311562 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PID errors - much simpler
James, if the JVM crashes, it will certainly create a hs_err_pid file, but how do you know that the OP's problem is related to hotspot optimization? I'm pretty sure that hs_err_pid files are only generated for Hot Spot errors specifically. Other JVM crashes don't create them. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311563 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Centering text written on an image
Ray's approach is the best way to go. It's going to be better for the long run. It's good to know that CFC is there, Ray. I'm sure I'll be making using of it, too! By the way...if it can be explained without taking too much of your time...how does the CFC measure the height and width of text without resorting to an image, given all the variables in font, size, etc. Rick -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 9:17 AM To: CF-Talk Subject: Re: Centering text written on an image Yes, again, the CFC has a way to get the height/width of _just_ a textual component. On Tue, Aug 26, 2008 at 7:42 AM, Kevin Roche [EMAIL PROTECTED] wrote: Is there a way to add an extra step or two and make an image of just your text, determine that width which gives you your string width I have no Idea how to do that. Can you tell me how to find the width of the text? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311564 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfhttp and Google Search Appliance
Thanks for your help Dave. Yes, the URL is http://IP:8000/EnterpriseController I don't expect you to do my job for me, but I have included my initial script below. Does anything jump out as being wrong? My code is probably not the best since I am still learning coldfusion. I don't really see anything that jumps out at me. I'm out of the office until Thursday, and don't have non-SSL access to a Google Search Appliance right now, but will run it against one of our GSAs as soon as I can. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311565 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Centering text written on an image
how does the CFC measure the height and width of text without resorting to an image Any decent text/Image processing library will provide some function to calculate the physical length of a string given a specific font and size. And I'm pretty sure Ray's CFC is using a decent library. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311566 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Centering text written on an image
What I'm thinking is trying to avoid determining the text width by creating an image of just the text and measuring that. Yes but how? When you create an image in ColdFusion you have to give it a width and a height. If you don't you get an error when you try and use it: The image on which the operation was executed is undefined. An image must have some non-zero positive dimensions for image operations to be applicable. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311567 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Centering text written on an image
It's using a bunch of Java code from an Adobe blogger (used with permission). I forget the name, but it should be credited in the CFC itself. I definitely can't take credit for the code, although I think I handled the wrapping up in the method. That counts for something, right? ;) Anyway, that URL again: http://imageutils.riaforge.org -Raymond On Tue, Aug 26, 2008 at 8:56 AM, Claude Schneegans [EMAIL PROTECTED] wrote: how does the CFC measure the height and width of text without resorting to an image Any decent text/Image processing library will provide some function to calculate the physical length of a string given a specific font and size. And I'm pretty sure Ray's CFC is using a decent library. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311568 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Centering text written on an image
Thanks, Claude. I figured I could look at the CFC code, but it would most likely take wy too long for me to figure out what was happening. Good stuff to know. Rick -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 9:57 AM To: CF-Talk Subject: Re: Centering text written on an image how does the CFC measure the height and width of text without resorting to an image Any decent text/Image processing library will provide some function to calculate the physical length of a string given a specific font and size. And I'm pretty sure Ray's CFC is using a decent library. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311569 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PID errors - much simpler
Dave, I believe that you are correct. I'm fairly certain that the prefix hs_ is indicating that it was a HotSpot error. - James # Java VM: Java HotSpot(TM) Server VM (10.0-b19 mixed mode windows-x86) James, if the JVM crashes, it will certainly create a hs_err_pid file, but how do you know that the OP's problem is related to hotspot optimization? I'm pretty sure that hs_err_pid files are only generated for Hot Spot errors specifically. Other JVM crashes don't create them. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311570 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PID errors - much simpler
Brad, Do you know what it WAS related to? Do you make extensive use of CFTHREAD ? - James Yes, I've gotten them when JRUN had a hard crash, but it was never related to image manipulation. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311571 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PID errors - much simpler
Our JVM is fully updated. No love. We have the new CFImage patch from Adobe. No love. I am curious what you meant about this being a classic sign of the problem. We can often go through 7,000 images without one error and then we'll get two errors within 20 images of each other and then go another 5,000 without issue. I dont know if that is a classic sign of the problem but I am interested in learning more about what you mean and how to debug it if you are correct. - James Because the OP says they get the crash once in every ~10,000 attempts which is probably the limit at which the hotspot compiler decided to compile the given class to native code. After the auto restart the same code works fine. It's a classic sign of this problem. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311572 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Multiserver Step Debugging with CF8
I'm new to step debugging and new to Eclipse. I'm desperate to use the step debugging feature to track down a problem. My hangup is turning on the debugging in a multiserver environment. Our site has two instances running. I've found instructions to edit the jrun/bin/jvm.config file with the following line -Xdebug -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=5005 Unfortunately when I choose the RDS server name under debug as, I get the following error: Error connecting to JVM for debugging at localhost:5005. Could not attach to the VM at port 5005 You must specify this debugger port in the JVM settings of your application server, for example: -Xdebug -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=5005 You will also need to make sure that another debugger is not currently connected to the CF JVM at the same port (5005) Root cause - Connection refused: connect So what am I doing wrong? I'm the only one working with debugging on this server, so that's not the problem. Also, I want to use this on both servers. Do I need to set up separate ports for them? Do they need separate jvm.config files? Thanks, Laura ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311573 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Multiserver Step Debugging with CF8
I'm new to step debugging and new to Eclipse. I'm desperate to use the step debugging feature to track down a problem. My hangup is turning on the debugging in a multiserver environment. Our site has two instances running. I've found instructions to edit the jrun/bin/jvm.config file with the following line -Xdebug -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=5005 Unfortunately when I choose the RDS server name under debug as, I get the following error: Error connecting to JVM for debugging at localhost:5005. Could not attach to the VM at port 5005 You must specify this debugger port in the JVM settings of your application server, for example: -Xdebug -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=5005 You will also need to make sure that another debugger is not currently connected to the CF JVM at the same port (5005) Root cause - Connection refused: connect So what am I doing wrong? I'm the only one working with debugging on this server, so that's not the problem. Also, I want to use this on both servers. Do I need to set up separate ports for them? Do they need separate jvm.config files? Thanks, Laura ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311575 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL injection attack on House of Fusion
Open the website log with word and do a search for DECLARE you will find a lot of entries.. Look for a filename that is in a different directory than what you expected.. I think I got hit from a template that was in an old, unused directory from many years ago. I recently went through the server and deleted all of my old unused directories.. Also look for any ASP pages that are being hit.. At 06:46 AM 8/26/2008, you wrote: Just got nailed myself - dammit - 15 years of knowledge. Have code reviewed and wasn't my CFML (at this stage) so maybe a new IIS vulnerability? My attack occured recently - possibly in the last 24 hours or so. Have disabled the database and CFABORTed any code that interacts with the database until I can solve the disastrous problem (apparently the attack came from China). Sigh! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311574 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiserver Step Debugging with CF8
Laura, what I usually do is to assign a different JVM config file to each instance and then assign different port numbers for each one of them. You can follow this instructions to assign a specific config to each instance: http://mkruger.cfwebtools.com/index.cfm/2006/4/17/multiserver Then, you'll just have to assign the same port number in the administration page. -- João Fernandes Adobe Community Expert http://www.onflexwithcf.org http://www.riapt.org Portugal Adobe User Group (http://aug.riapt.org) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311576 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Multiserver Step Debugging with CF8
what are good port numbers to use? Laura Laura, what I usually do is to assign a different JVM config file to each instance and then assign different port numbers for each one of them. You can follow this instructions to assign a specific config to each instance: http://mkruger.cfwebtools.com/index.cfm/2006/4/17/multiserver Then, you'll just have to assign the same port number in the administration page. -- João Fernandes Adobe Community Expert http://www.onflexwithcf.org http://www.riapt.org Portugal Adobe User Group (http://aug.riapt.org) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311577 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PID errors - much simpler
Our JVM is fully updated. No love. We have the new CFImage patch from Adobe. No love. I am curious what you meant about this being a classic sign of the problem. We can often go through 7,000 images without one error and then we'll get two errors within 20 images of each other and then go another 5,000 without issue. I dont know if that is a classic sign of the problem but I am interested in learning more about what you mean and how to debug it if you are correct. The HotSpot compiler only kicks in if the JVM thinks it will take less time to compile to native code and run than to just compile to bytecode and run that. So, repeated operations are one place you see this a lot. After some number of repetitions, the JVM invokes the HotSpot compiler. If there's no other way to prevent this, you can simply disable HotSpot, although that will generally make a lot of things a LOT slower. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311578 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Print Page Controls
Hi -- I am working on an application where the user will need to print different reports to different printers. I.E. a receipt printer and a dcoument printer. I read an older post in this list that somone was using MeadCo's ScriptX, Active X Control to do this -- are there any other ways to specify which printer a page can be sent to? I am using CF8. Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311579 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ODBC Connection to Microsoft SQL DB Stored Proc
My Microsoft SQL database contains multiple stored procedures with access to these stored procedures secured by SQL Authenticated Login Accounts (i.e. Manager, User, Auditor). I am setting two session variables, session.UserName and session.Password, to the SQL Authenticated Login account for the level the person is authenticated (i.e. Manager) . I then pass this information through the âcfstoredprocâ tag by username=Session.UserName and password=Session.Password. My question is when setting up an ODBC connection to this database, do I have to setup a separate odbc connection for each one (User, Manager, Auditor) and set the username and password in the ODBC connection to each of their user name and password (In my case causing me to have 3 ODBC connections)? Because it seems as though my current ODBC connection via the CF Administrator overwrites any of the cfstoredproc settings. In other words, if I were to create my DSN in ColdFusion with the sa username and password, then it doesnât matter what username and password the cfstoredproc passes in â it will run because it is using SA â the DSN account, to run it. Do you know of any documents available that explains how the ODBC connections and SQL Security tie together? Thank you in advance for all of your help. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311580 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
XML rendering issue
Hi all,
I have this pain in the rear issue with cf generated xml. I have a
flex app that is sending inputted text to cf, this is then sent to a
database and then runs a query to generate xml from the data in the
database.
cffunction name=updateXMLStream access=remote
cfset var stream = ''
cfset var qTemplate = ''
cfquery name=qTemplate
datasource=#application.dsn#
... query stuff ...
/cfquery
cfsavecontent variable=stream?xml version=1.0
encoding=utf-8?
documents
cfoutput query=qTemplate
group=test
test name=#qTemplate.test#
cfoutput
example
body_text![CDATA[#qTemplate.txt_body#]]/body_text
/example
/cfoutput
/test
/cfoutput
/documents
/cfsavecontent
cfif FileExists(ExpandPath('../xml/myXML.xml'))
cffile action=delete file=#ExpandPath('../xml/
myXML.xml')#
/cfif
cffile action=write
file=#ExpandPath('../xml/')#myXML.xml
output=#stream#
/cffunction
This still generates problems with certain characters such as '
and I was wondering if people had any tips or advise on this at all?
Any help would be greatly appreciated,
Simon
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311581
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: XML rendering issue
This still generates problems with certain characters such as ' and I was wondering if people had any tips or advise on this at all? While you're using a CDATA block in body_text, and that will take care of the problem there, you also have to escape XML character entities in attribute values: test name=#XMLEncodedFormat(qTemplate.test)# Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311582 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML rendering issue
XMLFormat() takes care of escaping those characters and making them XML safe. On Tue, Aug 26, 2008 at 11:35 PM, Simon Bailey [EMAIL PROTECTED] wrote: Hi all, I have this pain in the rear issue with cf generated xml... [snip] This still generates problems with certain characters such as ' and I was wondering if people had any tips or advise on this at all? -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311583 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: XML rendering issue
test name=#XMLEncodedFormat(qTemplate.test)# I think that should be XmlFormat(), not XmlEncodedFormat() ;) Dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311584 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ODBC Connection to Microsoft SQL DB Stored Proc
First, keep in mind that this is going to be JDBC, not ODBC (2 different animals). Second, you should be able to set up a datasource without any credentials (no username and password). In which case your stored proc code will require a username password to work. If you are going to set up separate DSNs (which you might want to do to consolidate all the settings into one file) I would simply add them with the appropriate credentials in the CF admin and the use the correct datasource in your code. This would keep you from storing database level permissions in the session (which seems like maybe a bad idea :). -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 10:34 AM To: CF-Talk Subject: ODBC Connection to Microsoft SQL DB Stored Proc My Microsoft SQL database contains multiple stored procedures with access to these stored procedures secured by SQL Authenticated Login Accounts (i.e. Manager, User, Auditor). I am setting two session variables, session.UserName and session.Password, to the SQL Authenticated Login account for the level the person is authenticated (i.e. Manager) . I then pass this information through the ââ¬Åcfstoredprocââ¬Â tag by username=Session.UserName and password=Session.Password. My question is when setting up an ODBC connection to this database, do I have to setup a separate odbc connection for each one (User, Manager, Auditor) and set the username and password in the ODBC connection to each of their user name and password (In my case causing me to have 3 ODBC connections)? Because it seems as though my current ODBC connection via the CF Administrator overwrites any of the cfstoredproc settings. In other words, if I were to create my DSN in ColdFusion with the sa username and password, then it doesnââ¬â¢t matter what username and password the cfstoredproc passes in ââ¬â it will run because it is using SA ââ¬â the DSN account, to run it. Do you know of any documents available that explains how the ODBC connections and SQL Security tie together? Thank you in advance for all of your help. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311585 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML rendering issue
Ahhh ok so I can implement the XMLFormat method as opposed to the XMLEncodedFormat, wicked thanks! Is there a way of avoiding having to utilise that method on each xml node i.e. use it higher up the xml generation method? Cheers, Simon On 26 Aug 2008, at 16:43, Dominic Watson wrote: test name=#XMLEncodedFormat(qTemplate.test)# I think that should be XmlFormat(), not XmlEncodedFormat() ;) Dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311586 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: XML rendering issue
test name=#XMLEncodedFormat(qTemplate.test)# I think that should be XmlFormat(), not XmlEncodedFormat() ;) Yes, it should! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311587 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML rendering issue
Sweet thanks Dave and all :-) On 26 Aug 2008, at 16:43, Dave Watts wrote: This still generates problems with certain characters such as ' and I was wondering if people had any tips or advise on this at all? While you're using a CDATA block in body_text, and that will take care of the problem there, you also have to escape XML character entities in attribute values: test name=#XMLEncodedFormat(qTemplate.test)# Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311588 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PID errors - much simpler
No. Usually, I have only gotten errors like that just after a botched install CF, or when I am screwing around with stuff. (Fiddling with core JAR files and such for experiments) I can't remember the last time I got an error like that under a normal usage scenario. ~Brad - Original Message - From: James Wolfe [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, August 26, 2008 9:44 AM Subject: Re: PID errors - much simpler Brad, Do you know what it WAS related to? Do you make extensive use of CFTHREAD ? - James Yes, I've gotten them when JRUN had a hard crash, but it was never related to image manipulation. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311589 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Centering text written on an image
This just shows my ignorance about text overlay. I was hoping there was a way with CF 8 to just tell it what font, size, and text and it would calculate the rest. But, apparently not. CF 9 should definitely incorporate that. Ray's approach seems to be the best solution of all. It's the only one I know of that integrated into CF and can take only the font, size, and text and provide you with dimensions, from the description we've gotten. I'd definitely check into that. http://imageutils.riaforge.org Rick -Original Message- From: Kevin Roche [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 10:07 AM To: CF-Talk Subject: Re: Centering text written on an image What I'm thinking is trying to avoid determining the text width by creating an image of just the text and measuring that. Yes but how? When you create an image in ColdFusion you have to give it a width and a height. If you don't you get an error when you try and use it: The image on which the operation was executed is undefined. An image must have some non-zero positive dimensions for image operations to be applicable. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311590 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PID errors - much simpler
What the other James and Dave said actually makes some sense now that I think about it. Read http://java.sun.com/javase/technologies/hotspot/index.jsp-- it explains what hotspot optimization does. Basically, your JVM will actually change how it is compiling code after your server had been running for a while and warmed up. It keeps track of pieces of code that run A LOT. Those are hot spots in your application and could use a little extra boost of performance. Therefore, the hotspot compiler will compile those parts down to optimized machine instructions. It is costly to do that, but if that code is called enough, it could be worth it because the is much faster. What we are suggesting is that after your server has been up for a while, the HotSpot compiler finds some code it thinks it can optimize, but it crashes instead. Perhaps, if you examine the content of the error file you can get some info. Generally, it's not too awful useful though. As far as how to debug, I don't know. If you provide the proper arguments to your JVM, the hotspot compiler will be disabled. That will at least allow you to confirm if it fixes the problem. Your overall performance will probably suffer though. ~Brad - Original Message - From: James Wolfe [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, August 26, 2008 9:47 AM Subject: Re: PID errors - much simpler Our JVM is fully updated. No love. We have the new CFImage patch from Adobe. No love. I am curious what you meant about this being a classic sign of the problem. We can often go through 7,000 images without one error and then we'll get two errors within 20 images of each other and then go another 5,000 without issue. I dont know if that is a classic sign of the problem but I am interested in learning more about what you mean and how to debug it if you are correct. - James ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311591 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Here's an interesting little problem...
I need to order query results by class desc. Classes are typically AA, A, B, C, D, etc. Order by class desc puts the AA, A in the correct order, but when all are ordered, I get: D C B AA A The only double letters involved in classes are AA, and AAA. I need a conditional order by statement... Order by class desc where class is AA or AAA, otherwise order by class asc Suggestions? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311592 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Here's an interesting little problem...
Rick,
What database are you using?
One thought that comes to mind is to do TWO selects with a UNION and give
each their own ORDER BY clause. Something like this:
Select . where class NOT in ('A','AA','AAA') ORDER BY class DESC
UNION ALL
Select . where class in ('A','AA','AAA') ORDER BY class ASC
You might need some parenthesis around the queries to make it work, not sure
which DB you're using.
At least that might get you on the right track.
I don't think a CASE statement would work in this 'case' (no pun intended),
but I've never tried one in an ORDER BY. Might be worth a shot.
Dave
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2008 11:31 AM
To: CF-Talk
Subject: Here's an interesting little problem...
I need to order query results by class desc.
Classes are typically AA, A, B, C, D, etc.
Order by class desc puts the AA, A in the correct order,
but when all are ordered, I get:
D
C
B
AA
A
The only double letters involved in classes are AA, and AAA.
I need a conditional order by statement...
Order by class desc where class is AA or AAA,
otherwise order by class asc
Suggestions?
Thanks,
Rick
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311593
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiserver Step Debugging with CF8
so, trying to get the custom jvm file to work completely hosed the instance i tried it on. any other suggestions? Thanks, Laura Laura, what I usually do is to assign a different JVM config file to each instance and then assign different port numbers for each one of them. You can follow this instructions to assign a specific config to each instance: http://mkruger.cfwebtools.com/index.cfm/2006/4/17/multiserver Then, you'll just have to assign the same port number in the administration page. -- João Fernandes Adobe Community Expert http://www.onflexwithcf.org http://www.riapt.org Portugal Adobe User Group (http://aug.riapt.org) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311594 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Multiserver Step Debugging with CF8
so, trying to create a separate jvm file completely hosed the instance i was working with. any other suggestions? Thanks, Laura Laura, what I usually do is to assign a different JVM config file to each instance and then assign different port numbers for each one of them. You can follow this instructions to assign a specific config to each instance: http://mkruger.cfwebtools.com/index.cfm/2006/4/17/multiserver Then, you'll just have to assign the same port number in the administration page. -- João Fernandes Adobe Community Expert http://www.onflexwithcf.org http://www.riapt.org Portugal Adobe User Group (http://aug.riapt.org) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311595 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Here's an interesting little problem...
Rick, Could you add an additional column to the database table to store a numeric sorting value? Or a second character column with spaces prepended to the single character and double character values (like A, B, AA, AAA)? Carl Rick Faircloth wrote: I need to order query results by class desc. Classes are typically AA, A, B, C, D, etc. Order by class desc puts the AA, A in the correct order, but when all are ordered, I get: D C B AA A The only double letters involved in classes are AA, and AAA. I need a conditional order by statement... Order by class desc where class is AA or AAA, otherwise order by class asc Suggestions? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311596 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multiserver Step Debugging with CF8
so, trying to create a separate jvm file completely hosed the instance i was working with. any other suggestions? I suggest you more clearly define completely hosed. What happens if you attempt to start the instance from the command line? What do you see in your JRun log files, if anything? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311597 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cftimer does not work
Oh boy, thanks a TON RAY... somehow some IP's got in the IP restrictions, so that was the cause... MANY MANY thanks, this has 'bugged' me for 1/2 a year! Matts Check the IP restrictions for db output in the admin. Hi all, CF 8.01 Standard Windows 2003 I cannot get cftimer to display anything -- dont think it is even running. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311598 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Here's an interesting little problem...
Sounds like a good idea to me.
I'll give it a shot.
Thanks,
Rick
-Original Message-
From: Dave Phillips [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2008 12:44 PM
To: CF-Talk
Subject: RE: Here's an interesting little problem...
Rick,
What database are you using?
One thought that comes to mind is to do TWO selects with a UNION and give
each their own ORDER BY clause. Something like this:
Select . where class NOT in ('A','AA','AAA') ORDER BY class DESC
UNION ALL
Select . where class in ('A','AA','AAA') ORDER BY class ASC
You might need some parenthesis around the queries to make it work, not sure
which DB you're using.
At least that might get you on the right track.
I don't think a CASE statement would work in this 'case' (no pun intended),
but I've never tried one in an ORDER BY. Might be worth a shot.
Dave
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2008 11:31 AM
To: CF-Talk
Subject: Here's an interesting little problem...
I need to order query results by class desc.
Classes are typically AA, A, B, C, D, etc.
Order by class desc puts the AA, A in the correct order,
but when all are ordered, I get:
D
C
B
AA
A
The only double letters involved in classes are AA, and AAA.
I need a conditional order by statement...
Order by class desc where class is AA or AAA,
otherwise order by class asc
Suggestions?
Thanks,
Rick
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311599
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Here's an interesting little problem...
Oh, sorry... MySQL 5.
-Original Message-
From: Dave Phillips [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2008 12:44 PM
To: CF-Talk
Subject: RE: Here's an interesting little problem...
Rick,
What database are you using?
One thought that comes to mind is to do TWO selects with a UNION and give
each their own ORDER BY clause. Something like this:
Select . where class NOT in ('A','AA','AAA') ORDER BY class DESC
UNION ALL
Select . where class in ('A','AA','AAA') ORDER BY class ASC
You might need some parenthesis around the queries to make it work, not sure
which DB you're using.
At least that might get you on the right track.
I don't think a CASE statement would work in this 'case' (no pun intended),
but I've never tried one in an ORDER BY. Might be worth a shot.
Dave
AM
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311600
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Here's an interesting little problem...
I'd rather avoid the extra column for numeric sorting. My client is terribly lazy and would see that as just one more thing to do to maintain the app. G... Prepending the spaces sounds interesting. I may try that. I can do that on the fly, with concat(A, ), etc... Well actually concat won't work since that will append instead of prepend the spaces. I'll have to check. Maybe concat( , A) would work. Thanks, Rick -Original Message- From: Carl Von Stetten [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 12:53 PM To: CF-Talk Subject: Re: Here's an interesting little problem... Rick, Could you add an additional column to the database table to store a numeric sorting value? Or a second character column with spaces prepended to the single character and double character values (like A, B, AA, AAA)? Carl Rick Faircloth wrote: I need to order query results by class desc. Classes are typically AA, A, B, C, D, etc. Order by class desc puts the AA, A in the correct order, but when all are ordered, I get: D C B AA A The only double letters involved in classes are AA, and AAA. I need a conditional order by statement... Order by class desc where class is AA or AAA, otherwise order by class asc Suggestions? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311601 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cftimer does not work
Wow can I send a check for my services for half a year? ;) On Tue, Aug 26, 2008 at 12:18 PM, Developer MediaDoc [EMAIL PROTECTED] wrote: Oh boy, thanks a TON RAY... somehow some IP's got in the IP restrictions, so that was the cause... MANY MANY thanks, this has 'bugged' me for 1/2 a year! Matts Check the IP restrictions for db output in the admin. Hi all, ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311602 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Here's an interesting little problem...
Rick, did you want to see
AA
D
C
B
A
or
D
C
B
A
AA
?
On Tue, Aug 26, 2008 at 12:25 PM, Rick Faircloth
[EMAIL PROTECTED] wrote:
Sounds like a good idea to me.
I'll give it a shot.
Thanks,
Rick
-Original Message-
From: Dave Phillips [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2008 12:44 PM
To: CF-Talk
Subject: RE: Here's an interesting little problem...
Rick,
What database are you using?
One thought that comes to mind is to do TWO selects with a UNION and give
each their own ORDER BY clause. Something like this:
Select . where class NOT in ('A','AA','AAA') ORDER BY class DESC
UNION ALL
Select . where class in ('A','AA','AAA') ORDER BY class ASC
You might need some parenthesis around the queries to make it work, not sure
which DB you're using.
At least that might get you on the right track.
I don't think a CASE statement would work in this 'case' (no pun intended),
but I've never tried one in an ORDER BY. Might be worth a shot.
Dave
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2008 11:31 AM
To: CF-Talk
Subject: Here's an interesting little problem...
I need to order query results by class desc.
Classes are typically AA, A, B, C, D, etc.
Order by class desc puts the AA, A in the correct order,
but when all are ordered, I get:
D
C
B
AA
A
The only double letters involved in classes are AA, and AAA.
I need a conditional order by statement...
Order by class desc where class is AA or AAA,
otherwise order by class asc
Suggestions?
Thanks,
Rick
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311603
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfscript question
Is it possible to do a query output loop in cfscript using something other than WriteOutput? -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research amp; Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311604 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiserver Step Debugging with CF8
ok, i got the instance working again, but i still get the same error when i try to go into debugging in eclipse i get the same error, except with the new port number i used. so, trying to create a separate jvm file completely hosed the instance i was working with. any other suggestions? I suggest you more clearly define completely hosed. What happens if you attempt to start the instance from the command line? What do you see in your JRun log files, if anything? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311605 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfscript question
On Tue, Aug 26, 2008 at 10:45 AM, Scott Stewart [EMAIL PROTECTED]wrote:
Is it possible to do a query output loop in cfscript using something
other than WriteOutput?
obvious question is... why? :)
for (i=1; i lt queryname.recordcount; i=i+1) { // you can pretty that up a
bit if you're on CF8
writeOutput(queryname.columnName[i] br /);
}
why won't writeOutput work for you? what are you trying to do that
writeoutput isn't the solution?
--
A byte walks into a bar and orders a pint. Bartender asks him What's
wrong? Byte says Parity error. Bartender nods and says Yeah, I thought
you looked a bit off.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311606
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Here's an interesting little problem...
AA
A
B
C
D
E
etc.
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2008 1:41 PM
To: CF-Talk
Subject: Re: Here's an interesting little problem...
Rick, did you want to see
AA
D
C
B
A
or
D
C
B
A
AA
?
On Tue, Aug 26, 2008 at 12:25 PM, Rick Faircloth
[EMAIL PROTECTED] wrote:
Sounds like a good idea to me.
I'll give it a shot.
Thanks,
Rick
-Original Message-
From: Dave Phillips [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2008 12:44 PM
To: CF-Talk
Subject: RE: Here's an interesting little problem...
Rick,
What database are you using?
One thought that comes to mind is to do TWO selects with a UNION and give
each their own ORDER BY clause. Something like this:
Select . where class NOT in ('A','AA','AAA') ORDER BY class DESC
UNION ALL
Select . where class in ('A','AA','AAA') ORDER BY class ASC
You might need some parenthesis around the queries to make it work, not
sure
which DB you're using.
At least that might get you on the right track.
I don't think a CASE statement would work in this 'case' (no pun intended),
but I've never tried one in an ORDER BY. Might be worth a shot.
Dave
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2008 11:31 AM
To: CF-Talk
Subject: Here's an interesting little problem...
I need to order query results by class desc.
Classes are typically AA, A, B, C, D, etc.
Order by class desc puts the AA, A in the correct order,
but when all are ordered, I get:
D
C
B
AA
A
The only double letters involved in classes are AA, and AAA.
I need a conditional order by statement...
Order by class desc where class is AA or AAA,
otherwise order by class asc
Suggestions?
Thanks,
Rick
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311607
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfscript question
Are you wishing for your function to return the generated content as a return variable as opposed to directly outputting to the page buffer? If so, you can concatenate strings together and then return the string at the end of the function. I'm not really sure where you are going with this though. If I am writing code that is outputting HTML etc, I usually do it in tags because that is what makes the most sense. I generally reserve cfscript for logic that doesn't involve output. ~Brad - Original Message - From: Scott Stewart [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, August 26, 2008 12:45 PM Subject: cfscript question Is it possible to do a query output loop in cfscript using something other than WriteOutput? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311608 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfscript question
trying to make sense out of some screwy logic that someone else did
although I'm about ready to rewrite it with tags...
Charlie Griefer wrote:
On Tue, Aug 26, 2008 at 10:45 AM, Scott Stewart [EMAIL PROTECTED]wrote:
Is it possible to do a query output loop in cfscript using something
other than WriteOutput?
obvious question is... why? :)
for (i=1; i lt queryname.recordcount; i=i+1) { // you can pretty that up a
bit if you're on CF8
writeOutput(queryname.columnName[i] br /);
}
why won't writeOutput work for you? what are you trying to do that
writeoutput isn't the solution?
--
Scott Stewart
ColdFusion Developer
Office of Research Information Systems
Research amp; Economic Development
University of North Carolina at Chapel Hill
Phone:(919)843-2408
Fax: (919)962-3600
Email: [EMAIL PROTECTED]
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311609
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Here's an interesting little problem...
Hmmm... why would I get this error: (MySQL 5)
Unknown column 'lower_shooter_class' in 'order clause'
from this query:
cfquery name=get_results datasource=#application.dsn#
select t.name, t.date, t.time,
s.firstname, s.lastname, s.state, s.nsca,
r.con, r.class as top_shooter_class, r.shot, r.broke as
top_broke
from tournaments t, shooters s, registrations r
where r.shooter_id = s.shooter_id
andr.class in ('A', 'AA', 'AAA')
andr.tournament_id = t.tournament_id
andt.tournament_id = cfqueryparam cfsqltype=integer
value=#url.tournament_id#
union all
select t.name, t.date, t.time,
s.firstname, s.lastname, s.state, s.nsca,
r.con, r.class as lower_shooter_class, r.shot, r.broke as
lower_broke
from tournaments t, shooters s, registrations r
where r.shooter_id = s.shooter_id
andr.class not in ('A', 'AA', 'AAA')
andr.tournament_id = t.tournament_id
andt.tournament_id = cfqueryparam cfsqltype=integer
value=#url.tournament_id#
order by top_shooter_class desc, top_broke desc, lower_shooter_class,
lower_broke desc
/cfquery
-Original Message-
From: Dave Phillips [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2008 12:44 PM
To: CF-Talk
Subject: RE: Here's an interesting little problem...
Rick,
What database are you using?
One thought that comes to mind is to do TWO selects with a UNION and give
each their own ORDER BY clause. Something like this:
Select . where class NOT in ('A','AA','AAA') ORDER BY class DESC
UNION ALL
Select . where class in ('A','AA','AAA') ORDER BY class ASC
You might need some parenthesis around the queries to make it work, not sure
which DB you're using.
At least that might get you on the right track.
I don't think a CASE statement would work in this 'case' (no pun intended),
but I've never tried one in an ORDER BY. Might be worth a shot.
Dave
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2008 11:31 AM
To: CF-Talk
Subject: Here's an interesting little problem...
I need to order query results by class desc.
Classes are typically AA, A, B, C, D, etc.
Order by class desc puts the AA, A in the correct order,
but when all are ordered, I get:
D
C
B
AA
A
The only double letters involved in classes are AA, and AAA.
I need a conditional order by statement...
Order by class desc where class is AA or AAA,
otherwise order by class asc
Suggestions?
Thanks,
Rick
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311610
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Here's an interesting little problem...
How about this: order by len(class) desc, class ? Steve From: Rick Faircloth [EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 2:00 PM To: CF-Talk Subject: RE: Here's an interesting little problem... AA A B C D E etc. -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 1:41 PM To: CF-Talk Subject: Re: Here's an interesting little problem... Rick, did you want to see AA D C B A or D C B A AA ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311611 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Here's an interesting little problem...
ORDER BY
CASE class
WHEN 'AA' THEN 10
WHEN 'A' THEN 20
WHEN 'B' THEN 30
WHEN 'C' THEN 40
WHEN 'D' THEN 50
WHEN 'E' THEN 60
END
incremented by 10 so you can add 'AAA' etc later :)
On Tue, Aug 26, 2008 at 11:00 AM, Rick Faircloth
[EMAIL PROTECTED]wrote:
AA
A
B
C
D
E
etc.
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2008 1:41 PM
To: CF-Talk
Subject: Re: Here's an interesting little problem...
Rick, did you want to see
AA
D
C
B
A
or
D
C
B
A
AA
?
On Tue, Aug 26, 2008 at 12:25 PM, Rick Faircloth
[EMAIL PROTECTED] wrote:
Sounds like a good idea to me.
I'll give it a shot.
Thanks,
Rick
-Original Message-
From: Dave Phillips [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2008 12:44 PM
To: CF-Talk
Subject: RE: Here's an interesting little problem...
Rick,
What database are you using?
One thought that comes to mind is to do TWO selects with a UNION and
give
each their own ORDER BY clause. Something like this:
Select . where class NOT in ('A','AA','AAA') ORDER BY class DESC
UNION ALL
Select . where class in ('A','AA','AAA') ORDER BY class ASC
You might need some parenthesis around the queries to make it work,
not sure
which DB you're using.
At least that might get you on the right track.
I don't think a CASE statement would work in this 'case' (no pun
intended),
but I've never tried one in an ORDER BY. Might be worth a shot.
Dave
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2008 11:31 AM
To: CF-Talk
Subject: Here's an interesting little problem...
I need to order query results by class desc.
Classes are typically AA, A, B, C, D, etc.
Order by class desc puts the AA, A in the correct order,
but when all are ordered, I get:
D
C
B
AA
A
The only double letters involved in classes are AA, and AAA.
I need a conditional order by statement...
Order by class desc where class is AA or AAA,
otherwise order by class asc
Suggestions?
Thanks,
Rick
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311612
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfscript question
nope, I need to populate a function call based on another query Brad Wood wrote: Are you wishing for your function to return the generated content as a return variable as opposed to directly outputting to the page buffer? If so, you can concatenate strings together and then return the string at the end of the function. I'm not really sure where you are going with this though. If I am writing code that is outputting HTML etc, I usually do it in tags because that is what makes the most sense. I generally reserve cfscript for logic that doesn't involve output. ~Brad - Original Message - From: Scott Stewart [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, August 26, 2008 12:45 PM Subject: cfscript question Is it possible to do a query output loop in cfscript using something other than WriteOutput? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311613 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Here's an interesting little problem...
Because the column name will be represented by whatever the FIRST select is,
and in this case, that is 'top_shooter_class'. Try this:
cfquery name=get_results datasource=#application.dsn#
select t.name, t.date, t.time,
s.firstname, s.lastname, s.state, s.nsca,
r.con, r.class, r.shot, r.broke
from tournaments t, shooters s, registrations r
where r.shooter_id = s.shooter_id
andr.class in ('A', 'AA', 'AAA')
andr.tournament_id = t.tournament_id
andt.tournament_id = cfqueryparam cfsqltype=integer
value=#url.tournament_id#
order by class, broke desc
union all
select t.name, t.date, t.time,
s.firstname, s.lastname, s.state, s.nsca,
r.con, r.class, r.shot, r.broke
from tournaments t, shooters s, registrations r
where r.shooter_id = s.shooter_id
andr.class not in ('A', 'AA', 'AAA')
andr.tournament_id = t.tournament_id
andt.tournament_id = cfqueryparam cfsqltype=integer
value=#url.tournament_id#
order by class desc, broke desc
/cfquery
If that doesn't work, try some parentheses around each of the selects. If
that still doesn't work, last resort you can do this:
cfquery name=get_results1 datasource=#application.dsn#
select t.name, t.date, t.time,
s.firstname, s.lastname, s.state, s.nsca,
r.con, r.class, r.shot, r.broke
from tournaments t, shooters s, registrations r
where r.shooter_id = s.shooter_id
andr.class in ('A', 'AA', 'AAA')
andr.tournament_id = t.tournament_id
andt.tournament_id = cfqueryparam cfsqltype=integer
value=#url.tournament_id#
order by class, broke desc
/cfquery
cfquery name=get_results2 datasource=#application.dsn#
select t.name, t.date, t.time,
s.firstname, s.lastname, s.state, s.nsca,
r.con, r.class, r.shot, r.broke
from tournaments t, shooters s, registrations r
where r.shooter_id = s.shooter_id
andr.class not in ('A', 'AA', 'AAA')
andr.tournament_id = t.tournament_id
andt.tournament_id = cfqueryparam cfsqltype=integer
value=#url.tournament_id#
order by class desc, broke desc
/cfquery
cfquery dbtype=query name=get_results
Select * from get_results1
Union all
Select * from get_results2
/cfquery
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311614
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Here's an interesting little problem...
Sorry, I just saw the post where you stated you are using MySQL. len is not a MySQL function, but length is. try this: order by length(class) desc, class. Steve From: Milburn, Steve [EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 2:07 PM To: CF-Talk Subject: RE: Here's an interesting little problem... How about this: order by len(class) desc, class ? Steve From: Rick Faircloth [EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 2:00 PM To: CF-Talk Subject: RE: Here's an interesting little problem... AA A B C D E etc. -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 1:41 PM To: CF-Talk Subject: Re: Here's an interesting little problem... Rick, did you want to see AA D C B A or D C B A AA ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311615 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Here's an interesting little problem...
We have a winner! Charlie! Solution: cfquery name=get_results datasource=#application.dsn# select t.name, t.date, t.time, s.firstname, s.lastname, s.state, s.nsca, r.con, r.class, r.shot, r.broke from tournaments t, shooters s, registrations r where r.shooter_id = s.shooter_id andr.tournament_id = t.tournament_id andt.tournament_id = cfqueryparam cfsqltype=integer value=#url.tournament_id# order by case class when 'AAA' then 10 when 'AA' then 20 when 'A' then 30 when 'B' then 40 when 'C' then 50 when 'D' then 60 when 'E' then 70 when 'F' then 80 when 'G' then 90 when 'H' then 100 when 'I' then 110 when 'J' then 120 when 'K' then 130 end, r.broke desc /cfquery Thanks, Charlie and everyone! Rick -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 2:12 PM To: CF-Talk Subject: Re: Here's an interesting little problem... ORDER BY CASE class WHEN 'AA' THEN 10 WHEN 'A' THEN 20 WHEN 'B' THEN 30 WHEN 'C' THEN 40 WHEN 'D' THEN 50 WHEN 'E' THEN 60 END incremented by 10 so you can add 'AAA' etc later :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311616 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfscript question
Is it possible to do a query output loop in cfscript using something other than WriteOutput? The only way to write any output directly from CFSCRIPT is to use WriteOutput. You can, of course, invoke functions written in CFML from CFSCRIPT. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311617 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Here's an interesting little problem...
Thanks, Dave!
Rick
-Original Message-
From: Dave Phillips [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2008 2:16 PM
To: CF-Talk
Subject: RE: Here's an interesting little problem...
Because the column name will be represented by whatever the FIRST select is,
and in this case, that is 'top_shooter_class'. Try this:
cfquery name=get_results datasource=#application.dsn#
select t.name, t.date, t.time,
s.firstname, s.lastname, s.state, s.nsca,
r.con, r.class, r.shot, r.broke
from tournaments t, shooters s, registrations r
where r.shooter_id = s.shooter_id
andr.class in ('A', 'AA', 'AAA')
andr.tournament_id = t.tournament_id
andt.tournament_id = cfqueryparam cfsqltype=integer
value=#url.tournament_id#
order by class, broke desc
union all
select t.name, t.date, t.time,
s.firstname, s.lastname, s.state, s.nsca,
r.con, r.class, r.shot, r.broke
from tournaments t, shooters s, registrations r
where r.shooter_id = s.shooter_id
andr.class not in ('A', 'AA', 'AAA')
andr.tournament_id = t.tournament_id
andt.tournament_id = cfqueryparam cfsqltype=integer
value=#url.tournament_id#
order byclass desc, broke desc
/cfquery
If that doesn't work, try some parentheses around each of the selects. If
that still doesn't work, last resort you can do this:
cfquery name=get_results1 datasource=#application.dsn#
select t.name, t.date, t.time,
s.firstname, s.lastname, s.state, s.nsca,
r.con, r.class, r.shot, r.broke
from tournaments t, shooters s, registrations r
where r.shooter_id = s.shooter_id
andr.class in ('A', 'AA', 'AAA')
andr.tournament_id = t.tournament_id
andt.tournament_id = cfqueryparam cfsqltype=integer
value=#url.tournament_id#
order by class, broke desc
/cfquery
cfquery name=get_results2 datasource=#application.dsn#
select t.name, t.date, t.time,
s.firstname, s.lastname, s.state, s.nsca,
r.con, r.class, r.shot, r.broke
from tournaments t, shooters s, registrations r
where r.shooter_id = s.shooter_id
andr.class not in ('A', 'AA', 'AAA')
andr.tournament_id = t.tournament_id
andt.tournament_id = cfqueryparam cfsqltype=integer
value=#url.tournament_id#
order byclass desc, broke desc
/cfquery
cfquery dbtype=query name=get_results
Select * from get_results1
Union all
Select * from get_results2
/cfquery
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311618
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfscript question
lemme rephrase...
I'm trying to populate a function call, by looping over the record count
of a query
to end up with something like this:
function(sunday_0, mon_0, tues_0)
function(sunday_1, monday_1, tues_1)
etc.
the number is dynamic based on the record count of a query..
code:
if(IsDefined(url.edit)){
For (i=1;i LTE get_category.Recordcount; i=i+1)
category_id = get_category.id[i];
sunday = session.tmp_sunday_get_category.id[i];
monday = session.tmp_monday_get_category.id[i];
tuesday = session.tmp_tuesday_get_category.id[i];
wednesday= session.tmp_wednesday_get_category.id[i];
thursday = session.tmp_thursday_get_category.id[i];
friday = session.tmp_friday_get_category.id[i];
saturday = session.tmp_saturday_get_category.id[i];
update_time =
application.studySYS.timetrex_updateStudyTime(study_id,category_id,sunday,,monday,tuesday,wednesday,thursday,friday,saturday);
}else{
For (i=1;i LTE get_category.Recordcount; i=i+1)
category_id = get_category.id[i];
sunday = session.tmp_sunday_get_category.id[i];
monday = session.tmp_monday_get_category.id[i];
tuesday = session.tmp_tuesday_get_category.id[i];
wednesday= session.tmp_wednesday_get_category.id[i];
thursday = session.tmp_thursday_get_category.id[i];
friday = session.tmp_friday_get_category.id[i];
saturday = session.tmp_saturday_get_category.id[i];
insert_time =
application.studySYS.timetrex_insertStudyTime(study_id,category_id,sunday,,monday,tuesday,wednesday,thursday,friday,saturday);
}
Dave Watts wrote:
Is it possible to do a query output loop in cfscript using
something other than WriteOutput?
The only way to write any output directly from CFSCRIPT is to use
WriteOutput. You can, of course, invoke functions written in CFML from
CFSCRIPT.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311619
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Here's an interesting little problem...
And we have another winner! Steve! With an even faster way to skin the cat. (My apologies to my cat, Maggie...) cfquery name=get_results datasource=#application.dsn# select t.name, t.date, t.time, s.firstname, s.lastname, s.state, s.nsca, r.con, r.class, r.shot, r.broke from tournaments t, shooters s, registrations r where r.shooter_id = s.shooter_id andr.tournament_id = t.tournament_id andt.tournament_id = cfqueryparam cfsqltype=integer value=#url.tournament_id# order by length(class) desc, class /cfquery -Original Message- From: Milburn, Steve [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 2:15 PM To: CF-Talk Subject: RE: Here's an interesting little problem... Sorry, I just saw the post where you stated you are using MySQL. len is not a MySQL function, but length is. try this: order by length(class) desc, class. Steve From: Milburn, Steve [EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 2:07 PM To: CF-Talk Subject: RE: Here's an interesting little problem... How about this: order by len(class) desc, class ? Steve From: Rick Faircloth [EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 2:00 PM To: CF-Talk Subject: RE: Here's an interesting little problem... AA A B C D E etc. -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 1:41 PM To: CF-Talk Subject: Re: Here's an interesting little problem... Rick, did you want to see AA D C B A or D C B A AA ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311620 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Here's an interesting little problem...
i'm not givin' back my prize. On Tue, Aug 26, 2008 at 11:38 AM, Rick Faircloth [EMAIL PROTECTED]wrote: And we have another winner! Steve! With an even faster way to skin the cat. (My apologies to my cat, Maggie...) cfquery name=get_results datasource=#application.dsn# select t.name, t.date, t.time, s.firstname, s.lastname, s.state, s.nsca, r.con, r.class, r.shot, r.broke from tournaments t, shooters s, registrations r where r.shooter_id = s.shooter_id andr.tournament_id = t.tournament_id andt.tournament_id = cfqueryparam cfsqltype=integer value=#url.tournament_id# order by length(class) desc, class /cfquery -Original Message- From: Milburn, Steve [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 2:15 PM To: CF-Talk Subject: RE: Here's an interesting little problem... Sorry, I just saw the post where you stated you are using MySQL. len is not a MySQL function, but length is. try this: order by length(class) desc, class. Steve From: Milburn, Steve [EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 2:07 PM To: CF-Talk Subject: RE: Here's an interesting little problem... How about this: order by len(class) desc, class ? Steve From: Rick Faircloth [EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 2:00 PM To: CF-Talk Subject: RE: Here's an interesting little problem... AA A B C D E etc. -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 1:41 PM To: CF-Talk Subject: Re: Here's an interesting little problem... Rick, did you want to see AA D C B A or D C B A AA ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311621 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfscript question
yea but...function calls shouldn't have dynamic number of arguments. perhaps u mean to create a list of arguments and pass it in as 1 argument? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311622 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfscript question
yea but...function calls shouldn't have dynamic number of arguments. Why not? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311623 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfscript question
I'm trying to populate a function call, by looping over the record count of a query What you have looks fine to me. What's the problem, exactly? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311624 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Here's an interesting little problem...
It's already in the mail! :o) I definitely put yours and Steve's solutions in my snippets. Steve's will work when value length is a determinant, but yours will work in any case. :o) Rick -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 2:44 PM To: CF-Talk Subject: Re: Here's an interesting little problem... i'm not givin' back my prize. On Tue, Aug 26, 2008 at 11:38 AM, Rick Faircloth [EMAIL PROTECTED]wrote: And we have another winner! Steve! With an even faster way to skin the cat. (My apologies to my cat, Maggie...) cfquery name=get_results datasource=#application.dsn# select t.name, t.date, t.time, s.firstname, s.lastname, s.state, s.nsca, r.con, r.class, r.shot, r.broke from tournaments t, shooters s, registrations r where r.shooter_id = s.shooter_id andr.tournament_id = t.tournament_id andt.tournament_id = cfqueryparam cfsqltype=integer value=#url.tournament_id# order by length(class) desc, class /cfquery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311625 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL injection attack on House of Fusion
On Tue, Aug 26, 2008 at 4:46 AM, Peter Tilbrook wrote: Just got nailed myself - dammit - 15 years of knowledge. There are at least 2 tools available that will search through your code looking for unparamed variables, and I think Larry posted a simple regex that you could use from within Eclipse. Those will help. I actually got a little nutty and wrote my own tool, that does a bit of database introspection, rewrites the query using the correct cfsqldatatypes, and then tests the query. Kinda cool, wasn't too hard, conceptually-- you have the DSN right there. It doesn't work with stored procedures (which shouldn't matter, 'cause I think they are type-checked by the DB first anyways), although, I was thinking (about something Jochem said about the difficulty of introspecting stored procedures and whatnot, sorta) that since I think the DB will give you the source for the procedure or function, you could use /that/ to introspect them, and create ORM type deals. RIght? You would have to code stuff for each DB (or at least the most popular at first), which is a little sucky, but I think unavoidable. There are certainly similarities between DBs tho, which would make it a tad easier. Probably just pie-in-the-sky type thinking, ignoring some fundamental problem, but it sounds kind of plausible. Anyways, half-way through coding my thing, I was like, damn, this would have been a perfect use for ANTLR! There are even grammar files for SQL, which would make parsing that easier. Oh well. Maybe the next version. LOL. After I finish this one. I'm still messing with the UI for it- uses dojo (of course) with a nice split screen, the top half has a tree control for browsing the files and folders with unparamed queries, and the bottom half actually shows you the source that would change, assuming the query passes the test. Still need to add de-select, so you can ignore directories, files, or individual queries, and then I'll probably post a link to it. I started getting a little excited while coding it, thinking about the... what was it called? Ah, yes- coding standards/review. I remember Will had posted a tool, and I had been toying with creating a tool for managing the attributes (hint, access, etc..) of functions/CFCs myself... wouldn't it be nice to have a tool that would do everything (format code, check for unvared variables, maybe even allow for drag-and-drop moving of functions/refactoring? (Ok, that's kinda extreme, but it was an exciting thought.)). Maybe tie it into the SVN stuff, even? Heh. I began thinking about getting all wiggy with it, because I wrote the code in a pretty sloppy manner (switching between camelCase and all lowercase, cutting/pasting functions and not changing the hint attribute, etc.), and was like, hell, I could tweak this tool to tweak itself. And then every time I switched between styles, I was, like, hey, I'm creating a test-case! LOL. Something like that. It would be pretty easy, as it currently is, to have the tool replace queries like SELECT * FROM sometable with the actual column names, for instance, or even do things like refactor queries, changing column or table names... I grab the DSN metadata, and parse the SQL into table names and column names, so it's all there. I need a bunch more bad query test cases, for various DB dialects, but I'm thinking I'll link up with the group I saw at some point (maybe it was just a blog post, now that I think about it), that's specifically targeting the prevention of injection attacks, and see if we can't get a nice set of cross-database testcases to use for tools like this. So, in the end I hope to have a source-code maintenance type tool, as I think it sounds kind of cool. Over time, it looks like it would become a freaking web-based IDE. :-)p Heh... I started thinking about how I could pull off some cool DB/query stuff within CFEclipse again, while messing around with this stuff. But I digress... LOL. :)e|\| -- Haste is of the Devil. St. Jerome ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311626 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Here's an interesting little problem...
There is also a way in Oracle(just for reference)...you can used decode() to do this (not sure if any of the other db's have this or a similar function). You would add decode(class,'aa',1,'a',2,'b',3...,/default value/) as sort_order in the select statement then in the order by, order by sort_order Eric /*-Original Message- /*From: Rick Faircloth [mailto:[EMAIL PROTECTED] /*Sent: Tuesday, August 26, 2008 2:10 PM /*To: CF-Talk /*Subject: RE: Here's an interesting little problem... /* /*It's already in the mail! :o) /* /*I definitely put yours and Steve's solutions /*in my snippets. Steve's will work when value length /*is a determinant, but yours will work in any case. :o) /* /*Rick /* /* /* -Original Message- /* From: Charlie Griefer [mailto:[EMAIL PROTECTED] /* Sent: Tuesday, August 26, 2008 2:44 PM /* To: CF-Talk /* Subject: Re: Here's an interesting little problem... /* /* i'm not givin' back my prize. /* /* On Tue, Aug 26, 2008 at 11:38 AM, Rick Faircloth /* [EMAIL PROTECTED]wrote: /* /* And we have another winner! Steve! /* With an even faster way to skin the cat. (My apologies /* to my cat, Maggie...) /* /* cfquery name=get_results datasource=#application.dsn# /* /* select t.name, t.date, t.time, /* s.firstname, s.lastname, s.state, s.nsca, /* r.con, r.class, r.shot, r.broke /* from tournaments t, shooters s, registrations r /* where r.shooter_id = s.shooter_id /* andr.tournament_id = t.tournament_id /* andt.tournament_id = cfqueryparam cfsqltype=integer /* value=#url.tournament_id# /* order by length(class) desc, class /* /* /cfquery /* /* /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311627 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Here's an interesting little problem...
Yeah but you can do the same with a case statement... which was introduced in Oracle 9i.. Plus there's no reason to select it unless you intend on using it later. Just do select class from classes order by decode(lower(class),'aa',1,'a',2,...) just FYI On Tue, Aug 26, 2008 at 2:31 PM, Eric Roberts [EMAIL PROTECTED] wrote: There is also a way in Oracle(just for reference)...you can used decode() to do this (not sure if any of the other db's have this or a similar function). You would add decode(class,'aa',1,'a',2,'b',3...,/default value/) as sort_order in the select statement then in the order by, order by sort_order Eric /*-Original Message- /*From: Rick Faircloth [mailto:[EMAIL PROTECTED] /*Sent: Tuesday, August 26, 2008 2:10 PM /*To: CF-Talk /*Subject: RE: Here's an interesting little problem... /* /*It's already in the mail! :o) /* /*I definitely put yours and Steve's solutions /*in my snippets. Steve's will work when value length /*is a determinant, but yours will work in any case. :o) /* /*Rick /* /* /* -Original Message- /* From: Charlie Griefer [mailto:[EMAIL PROTECTED] /* Sent: Tuesday, August 26, 2008 2:44 PM /* To: CF-Talk /* Subject: Re: Here's an interesting little problem... /* /* i'm not givin' back my prize. /* /* On Tue, Aug 26, 2008 at 11:38 AM, Rick Faircloth /* [EMAIL PROTECTED]wrote: /* /* And we have another winner! Steve! /* With an even faster way to skin the cat. (My apologies /* to my cat, Maggie...) /* /* cfquery name=get_results datasource=#application.dsn# /* /* select t.name, t.date, t.time, /* s.firstname, s.lastname, s.state, s.nsca, /* r.con, r.class, r.shot, r.broke /* from tournaments t, shooters s, registrations r /* where r.shooter_id = s.shooter_id /* andr.tournament_id = t.tournament_id /* andt.tournament_id = cfqueryparam cfsqltype=integer /* value=#url.tournament_id# /* order by length(class) desc, class /* /* /cfquery /* /* /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311628 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Here's an interesting little problem...
i know i'm a little late to this party but... SELECT `class`, concat(left(`class`, 1),100-length(`class`)) AS `sort` FROM myTable ORDER BY `sort` ASC will give you AAA AA A B CC C D etc ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311629 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL injection attack on House of Fusion
It doesn't work with stored procedures (which shouldn't matter, 'cause I think they are type-checked by the DB first anyways) Well, not necessarily. As Mark pointed out when this thread started - it feels like it was long, long ago - if you're calling a stored procedure from CFQUERY you have to check your variables there too. If you're using CFSTOREDPROC, that builds a prepared statement that calls the stored procedure for you, and you don't have to worry about it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311630 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Here's an interesting little problem...
Guess you can do that too ;-) I like it better in some ways than the case (it's easier to create a dynamic list), though the case statement would be easier to read... /*-Original Message- /*From: Greg Morphis [mailto:[EMAIL PROTECTED] /*Sent: Tuesday, August 26, 2008 2:42 PM /*To: CF-Talk /*Subject: Re: Here's an interesting little problem... /* /*Yeah but you can do the same with a case statement... which was /*introduced in Oracle 9i.. /*Plus there's no reason to select it unless you intend on using it later. /*Just do /* /*select class from classes /*order by decode(lower(class),'aa',1,'a',2,...) /* /*just FYI /* /*On Tue, Aug 26, 2008 at 2:31 PM, Eric Roberts /*[EMAIL PROTECTED] wrote: /* There is also a way in Oracle(just for reference)...you can used /*decode() to /* do this (not sure if any of the other db's have this or a similar /*function). /* /* You would add decode(class,'aa',1,'a',2,'b',3...,/default value/) as /* sort_order in the select statement then in the order by, order by /*sort_order /* /* Eric /* /* /*-Original Message- /* /*From: Rick Faircloth [mailto:[EMAIL PROTECTED] /* /*Sent: Tuesday, August 26, 2008 2:10 PM /* /*To: CF-Talk /* /*Subject: RE: Here's an interesting little problem... /* /* /* /*It's already in the mail! :o) /* /* /* /*I definitely put yours and Steve's solutions /* /*in my snippets. Steve's will work when value length /* /*is a determinant, but yours will work in any case. :o) /* /* /* /*Rick /* /* /* /* /* /* -Original Message- /* /* From: Charlie Griefer [mailto:[EMAIL PROTECTED] /* /* Sent: Tuesday, August 26, 2008 2:44 PM /* /* To: CF-Talk /* /* Subject: Re: Here's an interesting little problem... /* /* /* /* i'm not givin' back my prize. /* /* /* /* On Tue, Aug 26, 2008 at 11:38 AM, Rick Faircloth /* /* [EMAIL PROTECTED]wrote: /* /* /* /* And we have another winner! Steve! /* /* With an even faster way to skin the cat. (My apologies /* /* to my cat, Maggie...) /* /* /* /* cfquery name=get_results datasource=#application.dsn# /* /* /* /* select t.name, t.date, t.time, /* /* s.firstname, s.lastname, s.state, s.nsca, /* /* r.con, r.class, r.shot, r.broke /* /* from tournaments t, shooters s, registrations r /* /* where r.shooter_id = s.shooter_id /* /* andr.tournament_id = t.tournament_id /* /* andt.tournament_id = cfqueryparam cfsqltype=integer /* /* value=#url.tournament_id# /* /* order by length(class) desc, class /* /* /* /* /cfquery /* /* /* /* /* /* /* /* /* /* /* /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311631 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Something other than SQL injection attack on House of Fusion
Can someone PLEASE change the title of this thread??? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 3:01 PM To: CF-Talk Subject: RE: SQL injection attack on House of Fusion It doesn't work with stored procedures (which shouldn't matter, 'cause I think they are type-checked by the DB first anyways) Well, not necessarily. As Mark pointed out when this thread started - it feels like it was long, long ago - if you're calling a stored procedure from CFQUERY you have to check your variables there too. If you're using CFSTOREDPROC, that builds a prepared statement that calls the stored procedure for you, and you don't have to worry about it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311632 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Andy Matthews has too much free time - was... SQL injection attack on House of Fusion
Sorry Andy, I couldn't resist. =] On Tue, Aug 26, 2008 at 1:46 PM, Andy Matthews [EMAIL PROTECTED]wrote: Can someone PLEASE change the title of this thread??? -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311633 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Increasing Max Memory
Thanks for the ideas. It appears the Request Throttle Memory setting was the limiting factor. Once upped, I can successfully upload files to that limit. Steve ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311634 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Andy Matthews has too much free time - was... SQL injection attack on House of Fusion
:P -Original Message- From: Alan Rother [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 3:57 PM To: CF-Talk Subject: Andy Matthews has too much free time - was... SQL injection attack on House of Fusion Sorry Andy, I couldn't resist. =] On Tue, Aug 26, 2008 at 1:46 PM, Andy Matthews [EMAIL PROTECTED]wrote: Can someone PLEASE change the title of this thread??? -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311635 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Uninstall ColdFusion 8 seems to be frozen.
I'm uninstalling CF8 to do a clean re-install and it seems to be frozen near the end of the 'Folders' section. What type of pain am I in for if I abort the uninstaller at this point? Windows 2003 server FYI ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311636 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cybersource Gateway Solution Found For ColdFusion
Hey Philip, Was searching through my archives here. I'd love to know if you are using the SOAP api do do this as java version is just driving me nuts. We were using the ASP/COM version and that worked well but we're setting up a new site on a BlueDragon server and you can't use COM objects in BD.Net... of course not, that would be too easy. so I was plugging around with their soap api and I'm not getting anywhere with it. I just need to know how to send a test order over. I shouldn't have a problem witht he rest, I just can never get my initial requests running with soap. Thanks Casey On Sun, Dec 30, 2007 at 10:10 PM, Philip Hayes [EMAIL PROTECTED] wrote: If anybody is interested I did find information on how to use ColdFusion to access the CyberSource Credit Card Gateway. I'll be happy to send you my sample code if you need it. Works like a charm. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311637 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Increasing Max Memory
Just a note to be careful with this. Each upload is going to use up a CF thread for the entire duration of the upload, which means that if you have 10 threads allocated to CF and 10 people upload large files, you've used up all of your CF threads for quite a long time. On Tue, Aug 26, 2008 at 5:23 PM, Steve Moore [EMAIL PROTECTED] wrote: Thanks for the ideas. It appears the Request Throttle Memory setting was the limiting factor. Once upped, I can successfully upload files to that limit. Steve ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311638 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Solution to xmlFormat() and Restricting String Length
I have a project where I'm sending an XML string to an interface, and I'm performing xmlFormat() on the XML text values that I'm sending up. The XML elements have maximum field lengths so I'm using the left() function to constrain the values. My concern was that the left() function may cut my string in the middle of an XML entity, and thus make the text value invalid. I've written a simple solution and wanted to share it in case someone else ever ran into the same problem: reReplace(left(xmlFormat(Test '' text), 34), [^;]*$, ) This will only modify the string in the situation that there's an incomplete XML entity at the end of it. This same solution should work for htmlEditFormat() as well. Edward A Savage Jr - Sonny Senior Software Engineer Creditdiscovery, LLC I believe in getting into hot water; it keeps you clean. ~ GK Chesterton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311639 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Manually uninstalling ColdFusion 8
Does the technote describing how to manually uninstall CF 6 and 7 still apply to CF 8? http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19187 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311640 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Strange ColdFusion folder
E:\JRun4\servers\general\cfusion.ear\cfusion.war\WEB-INF\cfusion\tmpCache\CFFileServlet\_cfreport\ What does this folder do and what would these virtX files be. There are so many on our server that I can not delete with the recycle bin. I as because this was a server that was having alot of problems when using the cfreport... tag. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311641 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL injection attack on House of Fusion
On Tue, Aug 26, 2008 at 2:01 PM, Dave Watts wrote: It doesn't work with stored procedures (which shouldn't matter, 'cause I think they are type-checked by the DB first anyways) Well, not necessarily. As Mark pointed out when this thread started - it feels like it was long, long ago - if you're calling a stored procedure from CFQUERY you have to check your variables there too. If you're using CFSTOREDPROC, that builds a prepared statement that calls the stored procedure for you, and you don't have to worry about it. Ah, thank you Dave! I was thinking of cfstoredproc, I reckon. /tips hat :Denny -- Marriage is good for those who are afraid to sleep alone at night. St. Jerome ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311642 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL injection attack on House of Fusion
That is, unless you concatenate SQL in your stored procedure. http://www.codersrevolution.com/index.cfm/2008/7/22/When-will-cfqueryparam-NOT-protect-me ~Brad - Original Message - From: denstar [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, August 26, 2008 6:26 PM Subject: Re: SQL injection attack on House of Fusion On Tue, Aug 26, 2008 at 2:01 PM, Dave Watts wrote: It doesn't work with stored procedures (which shouldn't matter, 'cause I think they are type-checked by the DB first anyways) Well, not necessarily. As Mark pointed out when this thread started - it feels like it was long, long ago - if you're calling a stored procedure from CFQUERY you have to check your variables there too. If you're using CFSTOREDPROC, that builds a prepared statement that calls the stored procedure for you, and you don't have to worry about it. Ah, thank you Dave! I was thinking of cfstoredproc, I reckon. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311643 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
The thread formally known as the SQL injection attack on House of Fusion
I hereby decree, in the name of all that doesn't suck, that from this day forth this thread will be hereby named The thread formally known as the SQL injection attack on House of Fusion . ~G~ On Tue, Aug 26, 2008 at 4:46 PM, Andy Matthews [EMAIL PROTECTED]wrote: Can someone PLEASE change the title of this thread??? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 3:01 PM To: CF-Talk Subject: RE: SQL injection attack on House of Fusion It doesn't work with stored procedures (which shouldn't matter, 'cause I think they are type-checked by the DB first anyways) Well, not necessarily. As Mark pointed out when this thread started - it feels like it was long, long ago - if you're calling a stored procedure from CFQUERY you have to check your variables there too. If you're using CFSTOREDPROC, that builds a prepared statement that calls the stored procedure for you, and you don't have to worry about it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311644 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Weird Time Issue Between Linux and Windows Server
Hello,
The following code displays different dates whether it is ran on a
windows machine or a linux machine.
form.thedates are javascript times that get passed in.
cfset
form.thedates=122050080|122110560|122171040|122231520|
cfloop list=#form.theDates# index=i DELIMITERS=|
cfset theDate = DateAdd(s,i/1000,DateConvert(utc2Local, January 1
1970 00:00))
cfoutput
#thedate# br
/cfoutput
/cfloop
On linux here is what it displays:
{ts '2008-09-03 23:00:00'}
{ts '2008-09-10 23:00:00'}
{ts '2008-09-17 23:00:00'}
{ts '2008-09-24 23:00:00'}
On windows here is what it displays (Which is correct)
{ts '2008-09-04 00:00:00'}
{ts '2008-09-11 00:00:00'}
{ts '2008-09-18 00:00:00'}
{ts '2008-09-25 00:00:00'}
Any ideas on what is going on? I cannot seem to find anything that
indicates what is going on.
I have tested this on
Coldfusion 8 on Windows / Linux
BD 7 on Linux
and on both linux tests the dates are off by 1 day, well actually it
looks like 1 hour.
-Randy
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311645
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Weird Time Issue Between Linux and Windows Server
Randy,
Looks like a DST issue on Linux.
Carl
Randy Johnson - CFConcepts wrote:
Hello,
The following code displays different dates whether it is ran on a
windows machine or a linux machine.
form.thedates are javascript times that get passed in.
cfset
form.thedates=122050080|122110560|122171040|122231520|
cfloop list=#form.theDates# index=i DELIMITERS=|
cfset theDate = DateAdd(s,i/1000,DateConvert(utc2Local, January 1
1970 00:00))
cfoutput
#thedate# br
/cfoutput
/cfloop
On linux here is what it displays:
{ts '2008-09-03 23:00:00'}
{ts '2008-09-10 23:00:00'}
{ts '2008-09-17 23:00:00'}
{ts '2008-09-24 23:00:00'}
On windows here is what it displays (Which is correct)
{ts '2008-09-04 00:00:00'}
{ts '2008-09-11 00:00:00'}
{ts '2008-09-18 00:00:00'}
{ts '2008-09-25 00:00:00'}
Any ideas on what is going on? I cannot seem to find anything that
indicates what is going on.
I have tested this on
Coldfusion 8 on Windows / Linux
BD 7 on Linux
and on both linux tests the dates are off by 1 day, well actually it
looks like 1 hour.
-Randy
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311646
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Weird Time Issue Between Linux and Windows Server
Here is the out of a command I found to show you the DST dates:
zdump -v /etc/localtime | grep
2008
/etc/localtime Sun Mar 9 06:59:59 2008 UTC = Sun Mar 9 01:59:59 2008
EST isdst=0 gmtoff=-18000
/etc/localtime Sun Mar 9 07:00:00 2008 UTC = Sun Mar 9 03:00:00 2008
EDT isdst=1 gmtoff=-14400
/etc/localtime Sun Nov 2 05:59:59 2008 UTC = Sun Nov 2 01:59:59 2008
EDT isdst=1 gmtoff=-14400
/etc/localtime Sun Nov 2 06:00:00 2008 UTC = Sun Nov 2 01:00:00 2008
EST isdst=0 gmtoff=-18000
zdump -v /etc/localtime | grep 2007
/etc/localtime Sun Mar 11 06:59:59 2007 UTC = Sun Mar 11 01:59:59 2007
EST isdst=0 gmtoff=-18000
/etc/localtime Sun Mar 11 07:00:00 2007 UTC = Sun Mar 11 03:00:00 2007
EDT isdst=1 gmtoff=-14400
/etc/localtime Sun Nov 4 05:59:59 2007 UTC = Sun Nov 4 01:59:59 2007
EDT isdst=1 gmtoff=-14400
/etc/localtime Sun Nov 4 06:00:00 2007 UTC = Sun Nov 4 01:00:00 2007
EST isdst=0 gmtoff=-18000
-Randy
Carl Von Stetten wrote:
Randy,
Looks like a DST issue on Linux.
Carl
Randy Johnson - CFConcepts wrote:
Hello,
The following code displays different dates whether it is ran on a
windows machine or a linux machine.
form.thedates are javascript times that get passed in.
cfset
form.thedates=122050080|122110560|122171040|122231520|
cfloop list=#form.theDates# index=i DELIMITERS=|
cfset theDate = DateAdd(s,i/1000,DateConvert(utc2Local, January 1
1970 00:00))
cfoutput
#thedate# br
/cfoutput
/cfloop
On linux here is what it displays:
{ts '2008-09-03 23:00:00'}
{ts '2008-09-10 23:00:00'}
{ts '2008-09-17 23:00:00'}
{ts '2008-09-24 23:00:00'}
On windows here is what it displays (Which is correct)
{ts '2008-09-04 00:00:00'}
{ts '2008-09-11 00:00:00'}
{ts '2008-09-18 00:00:00'}
{ts '2008-09-25 00:00:00'}
Any ideas on what is going on? I cannot seem to find anything that
indicates what is going on.
I have tested this on
Coldfusion 8 on Windows / Linux
BD 7 on Linux
and on both linux tests the dates are off by 1 day, well actually it
looks like 1 hour.
-Randy
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311647
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Something other than SQL injection attack on House of Fusion
Why? So everyone can create more filters? ..:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 4:47 PM To: CF-Talk Subject: RE: Something other than SQL injection attack on House of Fusion Can someone PLEASE change the title of this thread??? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 3:01 PM To: CF-Talk Subject: RE: SQL injection attack on House of Fusion It doesn't work with stored procedures (which shouldn't matter, 'cause I think they are type-checked by the DB first anyways) Well, not necessarily. As Mark pointed out when this thread started - it feels like it was long, long ago - if you're calling a stored procedure from CFQUERY you have to check your variables there too. If you're using CFSTOREDPROC, that builds a prepared statement that calls the stored procedure for you, and you don't have to worry about it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311648 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Weird Time Issue Between Linux and Windows Server
Randy Johnson - CFConcepts wrote: Any ideas on what is going on? I cannot seem to find anything that indicates what is going on. are both boxes in the same timezone (tz)? what tz is the linux box in? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311649 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL injection attack on House of Fusion
On Tue, Aug 26, 2008 at 5:42 PM, Brad Wood wrote: That is, unless you concatenate SQL in your stored procedure. http://www.codersrevolution.com/index.cfm/2008/7/22/When-will-cfqueryparam-NOT-protect-me Perfect example, thanks! Yeah, dunno what I was thinking... parsing that stuff would be not un-hard. =] Ah, yes, not impossible... but screw that idea. I'll stick to cleaning up simple queries and whatnot. :op -- The scars of others should teach us caution. St. Jerome ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311650 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Something other than SQL injection attack on House of Fusion
On Tue, Aug 26, 2008 at 7:18 PM, Bobby Hartsfield wrote: Why? So everyone can create more filters? Filters?!?! If you've been filtering, you've been missing out! There's been action, adventure, intrigue! We've been working on it this whole time. Has a nice little narrative... a beginning, middle, and end... some friends become enemies, some enemies become friends... at the end, we are all richer from the experience. -- They talk like angels but they live like men. St. Jerome ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311651 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
