RE: IIS Application Pools and ColdFusion

2008-12-02 Thread Gaulin, Mark
Another easy thing to try: Drop and recreate your app pool. It sounds stupid but we had one server where one app pool wasn't stable but all of the other servers we had (running the same app) were fine. Recreating the app pool resolved the issue. BTW, you should be seeing failures in your Event

Re: IIS Application Pools and ColdFusion

2008-12-02 Thread Michael van Leest
Also give recreate wsconfig another try. Remove the cf instance from IIS and add the connection again... This helped me in the past with these weird IIS crashes. Michael 2008/12/2 Gaulin, Mark [EMAIL PROTECTED] Another easy thing to try: Drop and recreate your app pool. It sounds stupid but

Re: display field in autosuggest

2008-12-02 Thread Dominic Watson
You won't be able to do that with the cfautosuggest unless you make your own js to compliment it. If you're willing to go that far, you're probably better off finding a js widget that already does what you're after; ie. there may something on Yahoo UI or perhaps a JQuery plugin. Incidentally,

Re: Verity writing stuff to my text files

2008-12-02 Thread John Drake
Are they always the same number of lines - like 7? If they do come back and you don't want to fool with permissions - I'd just strip the last 7 lines before you display the story. Not elegant but a quick band aid. ~| Adobe®

cfautosuggest copying the CFIDE folder problems

2008-12-02 Thread Boldacious
Hi I'm using cfautosuggest and I want to edit the css to change the default colours. I have done so on my local server copying the CFIDE folder to the current folder then using cfajaximport to point to that folder. This works fine. I then uploaded my local folder CFIDE to my production

RE: SQL between dates problem

2008-12-02 Thread Dawson, Michael
datetime would be your variable or another column to which you would compare the coupon start/end dates. Mike -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2008 7:00 PM To: cf-talk Subject: Re: SQL between dates problem If you are using

Re: SQL between dates problem

2008-12-02 Thread Will Tomlinson
Screw it. I'm just telling my client to enter the day after as the expiration date of the coupon. It works. But one thing I noticed and tested is, you can insert a date like so into SQL server and it accepts it and converts it to the right format. 12/01/2008 10:37 PM So I could have two

charts in pdf's

2008-12-02 Thread Tony
hi there. i am having an issue, and ive googled all i can google. i simply cannot get a png chart to show up in a pdf :( i can def give you code, but the facts are, that it all works well and dandy in a browser on a page, but as soon as i try to cfdocument it, and make it a pdf the chart just

Re: charts in pdf's

2008-12-02 Thread Bryan Stevenson
Any broken image icons? Does anything show? - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including

Re: charts in pdf's

2008-12-02 Thread Shannon Peevey
Hi Tony, Could you please send code? It would be difficult to troubleshoot without seeing how you are inserting the chart. thanks, speeves On Tue, Dec 2, 2008 at 10:23 AM, Tony [EMAIL PROTECTED] wrote: hi there. i am having an issue, and ive googled all i can google. i simply cannot get a

Re: charts in pdf's

2008-12-02 Thread Tony
cfchart format=PNG xaxistitle=Vehicle yaxistitle=Idle time (hrs) !--- title=Idle Report - Graph --- chartheight=250 chartwidth=77600

Re: charts in pdf's

2008-12-02 Thread Tony
hi bry nothing simply blank white space... well, ill put up a screen cap of what it looks like... as there is something that kinda looks like a hr that really isnt there. -- tony Better than a thousand hollow words, is one word that brings peace. -- siddhartha gautama On Tue, Dec 2, 2008

Re: charts in pdf's

2008-12-02 Thread Tony
btw, that 77600 is a typo on my paste... not actually the code im using, and to add to this, im simply wrapping up this code below in a cfdocument tag. -- tony Better than a thousand hollow words, is one word that brings peace. -- siddhartha gautama On Tue, Dec 2, 2008 at 12:09 PM, Tony

Re: charts in pdf's

2008-12-02 Thread Tony
here is what it looks like: http://www.flickr.com/photos/tonyweeg/3077068319/sizes/l/ -- tony Better than a thousand hollow words, is one word that brings peace. -- siddhartha gautama On Tue, Dec 2, 2008 at 12:13 PM, Tony [EMAIL PROTECTED] wrote: btw, that 77600 is a typo on my paste...

IntelliJ CFML Plugin

2008-12-02 Thread Kenton Gray
With all the excitement over Bolt, I thought this would be a good time to let everyone know the smart guys at JetBrains have been working on a CFML plugin. It has only been released for a month, but it is rapidly improving. In my opinion IntelliJ is far superior to Eclipse, and has the most

Re: cfpop using hotmail

2008-12-02 Thread Javier Buzzi
Bump. King. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive:

Re: cfpop using hotmail

2008-12-02 Thread Javier Buzzi
Bump. King. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive:

Date Range Without Year

2008-12-02 Thread Jim McAtee
The DBMS that I'm using is MySQL 5.0. I have a table where I want to store begin and end dates _without_ a year. For example, 'Dec 4' through 'Jun 15'. How can I best represent this in the database? I'll be doing selects of the nature SELECT * FROM mytable WHERE #today# BETWEEN begindate AND

Re: Date Range Without Year

2008-12-02 Thread Barney Boisvert
You could just use numbers to represent the dates. Year runs from 101 to 1231 (thats MDD), and easily create from a date like this: #month(now()) * 100 + day(now())#. Strings would also work instead of numbers: 0101 to 1231, and created via #dateFormat(now(), mmdd)#. cheers, barneyb On Tue,

Re: Date Range Without Year

2008-12-02 Thread Jim McAtee
That representation makes sense, but there needs to be a way to use it to construct SELECT queries using =, =, or BETWEEN. Using expressions with MySQL functions in the SELECT would be ok, if it can be done. - Original Message - From: Barney Boisvert [EMAIL PROTECTED] To: cf-talk

Re: cfpop using hotmail

2008-12-02 Thread C. Hatton Humphrey
Two things: 1) There's no need to bump a message twice in the span of a minute. 2) If you're getting that error message that means a few things: a) the port is correct b) CF is communicating correctly with the MSN Live server c) From the brief Google searches that I did (Hotmail POP3, MSN POP3)

Re: Date Range Without Year

2008-12-02 Thread Barney Boisvert
Select all events between February 12th and June 10th: select * from eventTable where dateCol between 212 and 610 cheers, barneyb On Tue, Dec 2, 2008 at 11:14 AM, Jim McAtee [EMAIL PROTECTED] wrote: That representation makes sense, but there needs to be a way to use it to construct SELECT

Re: Date Range Without Year

2008-12-02 Thread Jim McAtee
That won't work in cases where begindate enddate. This is essentially a seasonal newsletter signup, where the user is given a choice of the date to begin and end the email. They might subscribe from Feb 12 to Jun 10, but they might also subscribe from Nov 10 to Apr 5. The typical query

Re: Date Range Without Year

2008-12-02 Thread Barney Boisvert
You're going to have to do that regardless of your storage format, because in a yearless structure the range 1101 to 301 doesn't make any sense. On the flip side, the ranges 101 to 301 and 1101 to 1231 do make sense, so that might be a better way to describe the subscription (internally, not

Securing Interactive Forms with CFPDF

2008-12-02 Thread Merritt Chapman
Each time I try to add security using the protect action for existing PDFs created in Acrobat Pro, I receive the following error: - An error occurred during PROTECT operation in CFPDF. Error: The password provided is either wrong or does not have sufficient permission to

RE: Date Range Without Year

2008-12-02 Thread brad
If it was me, I would pick an arbitrary, but consistent year to use with the date, but just don't display the year when you format the dates for your view. In your select example #today# would need to have the month and day pulled out and concatenated with your dummy year. That might sound like

Re: Simple ecommerce -- not exactly CF but may be relevant

2008-12-02 Thread Don L
Yeah, I know bank would validate a credit card, thanks though, Wil. Don The company that you will be using to validate and process the card will take care of telling you if the card is accepted or rejected and then you code your user response accordingly. You usually have a large number of

Re: Simple ecommerce -- not exactly CF but may be relevant

2008-12-02 Thread Casey Dougall
On Tue, Dec 2, 2008 at 12:50 AM, Don L [EMAIL PROTECTED] wrote: About a few weeks ago I asked a question related to cc processing, silly me, I forgot the CFform family's CFinput has an attribute of cc validation, so, say, 85% customers provide good card and up front say something like if your

Re: charts in pdf's

2008-12-02 Thread Jim Thomson
Hi Tony I ran into a similar problem and the only way I found around was to write the chart to a file. Then use the reference to the newly created file. I used the name attribute in cfchart i.e. name=tester cfchart showborder=yes chartheight=250 chartwidth=300 yaxistitle= name=tester

Calling a static Java class that requires custom JNDI properties

2008-12-02 Thread David Lakein
I have a sample Java app (java code provided, compiled JAR file provided, custom JNDI properties) that successfully communicates with a remote JBoss middleware server; I need to run similar code within CF. It involves calling a static ServiceFactory class in that jar library to get the service

Re: Simple ecommerce -- not exactly CF but may be relevant

2008-12-02 Thread Don L
On Tue, Dec 2, 2008 at 12:50 AM, Don L [EMAIL PROTECTED] wrote: ... Don Chunshen Li You should do an authorization for an amount. This puts a hold for that amount on the customers credit card but in the end, you know the card is legit. Just passing check sum's on credit cards is not

How to find ColdFusion8 installation date programmatically (Windows OS)?

2008-12-02 Thread Don L
I thought that's possible but can't think of how. thks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive:

Re: How to find ColdFusion8 installation date programmatically (Windows OS)?

2008-12-02 Thread Don L
Ahe, I asked too fast. One solution is to look at the the Adobe_ColdFusion_8_InstallLog.log file's date time stamp under {CF8} installation. I thought that's possible but can't think of how. thks. ~| Adobe® ColdFusion® 8

Excel Workbook Creators

2008-12-02 Thread Craigsell
We currently have a CFMX7 application that uses Jakarta POI HSSF to create excel spreadsheets from a query. We initially chose POI because we wanted a higher degree of control over cell formatting (currency, date, etc) than what we could get in CFReport. The problem is that POI is eating

Re: Excel Workbook Creators

2008-12-02 Thread Barney Boisvert
I do pretty much everything with the XML format anymore. Just send it with an xls extension and you're set. It's a native workbook with full control over everything, it's just not binary. Users will never know the difference. cheers, barneyb On 12/2/08, Craigsell [EMAIL PROTECTED] wrote:

Regex help - matching invalid xhtml

2008-12-02 Thread Will Tomlinson
I've beat my head against the wall on this regex. I want to match variations of invalid xhtml tags. Well, I need to match what's considered to be invalid at my place of work. :) WHat I've got almost works, but not quite. (?i)\input\s[\S\s]+[\s]*[^\s][^\/] It doesn't match this, which is

Re: Regex help - matching invalid xhtml

2008-12-02 Thread Will Tomlinson
I guess it'd be cool if I were to use (meta|input|img) in there, to flag single tags without the trailing [space]/ Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

Re: Excel Workbook Creators

2008-12-02 Thread Mike Chabot
Your POI code could be optimized for memory usage. POI has problems with memory leaks, but these problems are fixable with experimentation. String handling is a place to look for optimization. In my experience, a suboptimal arrangement of the POI code could be the difference between creating a

Re: IntelliJ CFML Plugin

2008-12-02 Thread Adam Haskell
Wow how the hell did I miss this? Thanks for the info Kenton. Adam On Tue, Dec 2, 2008 at 1:26 PM, Kenton Gray [EMAIL PROTECTED] wrote: With all the excitement over Bolt, I thought this would be a good time to let everyone know the smart guys at JetBrains have been working on a CFML plugin.

Why is my CF8 server constantly hanging?

2008-12-02 Thread Philip Kaplan
Hi, I give up. I have a Windows CF8 server running a few moderately popular websites (around 250,000 pageviews/day). I've written code that I think is efficient. But it crashes a few times every day. I can't figure out why. Jrun CPU spiked at 100% and all processes are hung. I've tried

Re: Why is my CF8 server constantly hanging?

2008-12-02 Thread Brad Wood
When jrun is doing the 100% thing, look at the currently running requests in fusion-reactor. How many are there? How long have they been running? What are they doing? (stack trace) I'm more familiar with seefusion than reactor, but the stack trace has the stuff you are the most about on the

Re: Why is my CF8 server constantly hanging?

2008-12-02 Thread Wil Genovese
Hi there, I know the feeling. We've been there before at our company. Have you tried tuning the JVM yet? There are many items to look at in the JVM to help you handle larger amounts of traffic. Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing

Re: IntelliJ CFML Plugin

2008-12-02 Thread Azadi Saryev
hmm... a $250 IDE (personal licence)... no, thanks, i already have DW, which i am happy with... and the free Eclipse+CFEclipse which i am almost happy with... though it does look interesting to play with... i may consider testing it out when i start some open-source project (if i get approved by

Re: IntelliJ CFML Plugin

2008-12-02 Thread Wil Genovese
Let's hope Adobe notices this response when the set pricing for Bolt I had the same response to the price tag. Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. On Dec 3, 2008, at 12:20 AM, Azadi Saryev

Re: Why is my CF8 server constantly hanging?

2008-12-02 Thread Philip Kaplan
When jrun is doing the 100% thing, look at the currently running requests in fusion-reactor Usually when Jrun is doing its 100% thing, FusionReactor won't load. I suppose the server is hogged. But there are never more than 12 requests running at a time (that's the max I set). How long have

Re: Why is my CF8 server constantly hanging?

2008-12-02 Thread Philip Kaplan
Have you tried tuning the JVM yet A little. Not a lot. At risk of sounding like an idiot, is there a way to just figure out WHAT Jrun is working on when it's spiked to 100%? Assume CF Monitor and FusionReactor are unavailable, but I can usually get into the Windows box and mess around. Philip

Re: Why is my CF8 server constantly hanging?

2008-12-02 Thread Wil Genovese
You don't have to worry too much about trying to read the stack trace. Use this tool. http://www.seefusion.com/seestack/seestack.cfm It's called see stack. Dump your stack traces into the seestack tool and it will do the work for you and give you some meaningful information. Usually the

Re: Why is my CF8 server constantly hanging?

2008-12-02 Thread Philip Kaplan
Use this tool. http://www.seefusion.com/seestack/seestack.cfm I will - thank you! Are you maxed out at 12, meaning there are normally threads in the que waiting to be processed? No. Normally there is rarely more than 1 thread running at a time. Except when a crash happens -- then it

Re: Why is my CF8 server constantly hanging?

2008-12-02 Thread Wil Genovese
ok, lets got more basic. CF installation mode? Standard or Multi Can you post the data from the settings summary page here? Can you post your jvm.config file so I can help you tune that? I wrote a blog piece on JVM tuning. http://www.trunkful.com use with caution - editing your jvm.config is

Re: IntelliJ CFML Plugin

2008-12-02 Thread Mark Mandel
Stupid question - where did $250 come from? (I'd be happy with $250) Mark On Wed, Dec 3, 2008 at 5:24 PM, Wil Genovese [EMAIL PROTECTED] wrote: Let's hope Adobe notices this response when the set pricing for Bolt I had the same response to the price tag. Wil Genovese One man with

Re: Why is my CF8 server constantly hanging?

2008-12-02 Thread James Holmes
What are your memory settings for the JVM (e.g. maximum heap, perm and stack)? What does the Fusion Reactor log say about the memory consumption just before the problem? What do the CF logs show for errors before the problem? mxAjax / CFAjax docs and other useful articles:

Re: Why is my CF8 server constantly hanging?

2008-12-02 Thread Brad Wood
I'm not sure about fusion-reactor, but the product SeeFusion does a pretty good job of staying de-coupled from Jrun and CF. Usually it will respond up until the JVM dies. Perhaps fusion reactor has a feature similar to seefusion's active monitor rules. you can have triggers shoot you an

Re: Why is my CF8 server constantly hanging?

2008-12-02 Thread Brad Wood
I look forward to another crash so I can use the SeeStack tool :-] You don't have to wait for a crash-- just pull some thread dumps of long running processes when your server is under load (or just any time really) and play around with looking through the stack to see what that process was

Re: IntelliJ CFML Plugin

2008-12-02 Thread Wil Genovese
From here. http://www.jetbrains.com/idea/buy/index.jsp?top All I'm hoping for is a lower price than that when Bolt is released. Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. On Dec 3, 2008, at 12:58 AM,

Re: Why is my CF8 server constantly hanging?

2008-12-02 Thread Brad Wood
At risk of sounding like an idiot, is there a way to just figure out WHAT Jrun is working on when it's spiked to 100%? Assume CF Monitor and FusionReactor are unavailable, but I can usually get into the Windows box and mess around. It is possible to get a thread dump from your JVM without

Re: IntelliJ CFML Plugin

2008-12-02 Thread Azadi Saryev
check their Licensing Upgrade page: http://www.jetbrains.com/idea/buy/index.jsp Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Mark Mandel wrote: Stupid question - where did $250 come from? (I'd be happy with $250) Mark

Re: Why is my CF8 server constantly hanging?

2008-12-02 Thread Philip Kaplan
Thanks for letting me email you. CF installation mode? Standard or Multi Multi. But I'm not clustering so I might as well have gone single. Can you post the data from the settings summary page here? Here's the top half (i didn't want to show my datasource names and so on). I think this is

Re: Why is my CF8 server constantly hanging?

2008-12-02 Thread Brad Wood
WTF -Xmx200M your permgen space is 192 and I think that comes out of that. Why is your max JVM size so small? ~Brad - Original Message - From: Philip Kaplan [EMAIL PROTECTED] To: cf-talk cf-talk@houseoffusion.com Sent: Wednesday, December 03, 2008 1:10 AM Subject: Re: Why is my CF8

Re: IntelliJ CFML Plugin

2008-12-02 Thread Mark Mandel
Ahhh! $250 for IntelliJ. I thought you meant for Bolt. Makes more sense now. Mark On Wed, Dec 3, 2008 at 6:06 PM, Azadi Saryev [EMAIL PROTECTED] wrote: check their Licensing Upgrade page: http://www.jetbrains.com/idea/buy/index.jsp Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/

Re: Why is my CF8 server constantly hanging?

2008-12-02 Thread Brad Wood
A couple more notes: This probably won't fix your current problems, but I see you have yet to apply updater 1. Also, you are on the default JVM of 1.6. Does your application use CFC's heavily? ~Brad - Original Message - From: Brad Wood [EMAIL PROTECTED] To: cf-talk

Re: Why is my CF8 server constantly hanging?

2008-12-02 Thread Philip Kaplan
Please paste a dump from a single thread that you don't know how to read and we will point out the important pieces. Thanks. Here's a random JRPP thread that's running right now. It seems to have been running for a while, even though the server seems healthy at the moment. I'd love to know

Re: Why is my CF8 server constantly hanging?

2008-12-02 Thread Wil Genovese
JVM 1.6.0_01 - upgrade this to 1.6.0_10 Next your jvm.config needs help. Read what I posted at my blog to get help there. I don't want to re-type all of that here. A few points though. only 200Mb for the jvm heap? How much physical memory is there on this server? Also do you have multiple

Re: IntelliJ CFML Plugin

2008-12-02 Thread Barney Boisvert
$250 is cheap for an commercial IDE. CFEclipse is great and I use it pretty much exclusively, but if a $250 offering can save you 1 minute per day in productivity, it's worth it after only a year at $50/hour. If your time is worth more or your license lasts longer (both quite likely), it only

Re: Why is my CF8 server constantly hanging?

2008-12-02 Thread Philip Kaplan
I just discovered alerts in CF8 Monitor (the monitor that comes with CF8). Setting up crash protection there. On Tue, Dec 2, 2008 at 11:18 PM, Philip Kaplan [EMAIL PROTECTED] wrote: Please paste a dump from a single thread that you don't know how to read and we will point out the important

Re: Why is my CF8 server constantly hanging?

2008-12-02 Thread Brad Wood
Ditto. Wil's suggestion on the JVM version is basically what I was getting at when I asked if you use cfcs a lot. Java 1.6 has a classloader bug that will bring down your server if you have an app creating thousands of components. Updater 10 from Sun finally fixed it. To answer Wil's

Re: Why is my CF8 server constantly hanging?

2008-12-02 Thread Brad Wood
That thread actually isn't doing anything. It is waiting for an incoming request. ~Brad - Original Message - From: Philip Kaplan [EMAIL PROTECTED] To: cf-talk cf-talk@houseoffusion.com Sent: Wednesday, December 03, 2008 1:18 AM Subject: Re: Why is my CF8 server constantly hanging?

Re: I do not understand SeeStack at all

2008-12-02 Thread Barney Boisvert
You running the standalone version of CF, or are you in JEE mode? If the latter, launch the container in debug mode from Eclipse. Or if that's not possible, set up the java debugging port on the JVM, launch it normally, and connect to it with Eclipse. You can easily browse through all the

I do not understand SeeStack at all

2008-12-02 Thread Philip Kaplan
There are a lot of threads running. When I dump the entire stack trace into SeeStack http://www.seefusion.com/seestack/seestack.cfm , this is all it tells me. Clicking next stack does nothing. Am I missing something? Sorry for all my questions tonight - but I'm banging my head against the wall

Re: I do not understand SeeStack at all

2008-12-02 Thread Brad Wood
I have actually never used the seestack tool even though I have used seefusion quite a bit. The thread you posted is the thread handling the flash remoting request that was made when you triggered the snapshot of your server. You see the last file being executed is the servermonitoring.cfc

Re: I do not understand SeeStack at all

2008-12-02 Thread Philip Kaplan
You running the standalone version of CF, or are you in JEE mode? J2EE mode. Launch the container in debug mode from Eclipse. How do I do this? (or do the other thing you mentioned) I swear I'm not as much of a newbie as I sound tonight -- I've been a CF programmer for 12 years. I've just