JFreeChart with CF

2010-04-05 Thread Arsalan Tariq Keen
Hi Experts, Does anyone have any idea of using JFreeChart with CF. I am using the custom tage provided by Dave Gilbert, but I also want to display the ItemLabel on each bar of my barchart I.e, the value of each bar. Can anyone help. I am really fed up of trying and failing Regards, Arsalan

Re: JFreeChart with CF [spamtrap bayes][spamtrap heur]

2010-04-05 Thread Paul Hastings
On 4/5/2010 5:51 PM, Arsalan Tariq Keen wrote: Does anyone have any idea of using JFreeChart with CF. I am using the custom tage provided by Dave Gilbert, but I also want to display the ItemLabel on each bar of my barchart I.e, the value of each bar. Can anyone help. I am really fed up of

Re: JFreeChart with CF [spamtrap bayes][spamtrap heur]

2010-04-05 Thread Arsalan Tariq Keen
Oh my God ... I am so happy to see this reply :D Well the problem is ... I have managed to create Bar3D graph. Now, what I want is, the value of each bar, should be displayed on top of it. For example if a bar is denoting magnitude '4', then '4' should be written on top of it. How can I do

http header

2010-04-05 Thread Rick Sanders
I need to assign the http header to export a document to excel from the web. Here's an example from another programming language. I assign a variable called httpHeader and it changes the http header to an excel document. How can I do the same thing in Cold Fusion? HTTP/1.0 200

Re: http header

2010-04-05 Thread John M Bliss
http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7aea.html On Mon, Apr 5, 2010 at 8:33 AM, Rick Sanders c...@webenergy.ca wrote: I need to assign the http header to export a document to excel from the web. Here's an example from another programming

Re: http header

2010-04-05 Thread Dave Watts
I need to assign the http header to export a document to excel from the web. Here's an example from another programming language. I assign a variable called httpHeader and it changes the http header to an excel document. How can I do the same thing in Cold Fusion? HTTP/1.0 200

Best Way to use AJAX in MachII

2010-04-05 Thread sandeep saini
What is best way to use Ajax in MachII? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

default for numeric argument

2010-04-05 Thread Matthew Smith
cfargument name=app_user_id type=numeric required=no default= I am not passing it in. I am getting: The APP_USER_ID argument passed to the check_item_quantities function is not of type numeric. Should I make the default 0? ~|

RE: default for numeric argument

2010-04-05 Thread Andy Matthews
Yes. -Original Message- From: Matthew Smith [mailto:chedders...@gmail.com] Sent: Monday, April 05, 2010 9:10 AM To: cf-talk Subject: default for numeric argument cfargument name=app_user_id type=numeric required=no default= I am not passing it in. I am getting: The APP_USER_ID

Re: Best Way to use AJAX in MachII

2010-04-05 Thread Matt Williams
What is best way to use Ajax in MachII? I won't claim it is the best, but I like using jQuery to simply call index.cfm?event=myAjaxEvent. You can do it as a POST or a GET. The event is then just like any other Mach-II event with a call to a listener and ending in a view. The view page can

Re: default for numeric argument

2010-04-05 Thread Eric Cobb
yep. thanks, eric cobb http://www.cfgears.com Matthew Smith wrote: cfargument name=app_user_id type=numeric required=no default= I am not passing it in. I am getting: The APP_USER_ID argument passed to the check_item_quantities function is not of type numeric. Should I make the

Re: Best Way to use AJAX in MachII

2010-04-05 Thread sandeep saini
Thank you Matt for your reply. Can you provide some links to start with? I am a novice in Jquery. Thanks What is best way to use Ajax in MachII? I won't claim it is the best, but I like using jQuery to simply call index.cfm?event=myAjaxEvent. You can do it as a POST or a GET. The event

return recordset from stored procedure

2010-04-05 Thread Matthew Smith
Can I do it like this? cffunction access=public name=qry_cart_check_item_quantities output=no returntype=void hint=Verifies that items in user's cart are still available. cfargument name=cf_user_id type=string required=no default= cfargument name=app_user_id type=numeric required=no default=0

Re: return recordset from stored procedure

2010-04-05 Thread Dave Watts
Can I do it like this? ... Or do I need to use CFSTOREDPROC? In my own experience, this depends on the database and/or database drivers. I've been able to consistently invoke stored procedures against SQL Server this way. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/

Re: Best Way to use AJAX in MachII

2010-04-05 Thread Matt Williams
Thank you Matt for your reply. Can you provide some links to start with? I am a novice in Jquery. I don't know of any links specifically demonstrating jQuery AJAX with M2. I would start with the jQuery docs: http://api.jquery.com/category/ajax/. The info there and the examples near the

Re: return recordset from stored procedure

2010-04-05 Thread Matthew Smith
Thank you. I was trying to return a result set and forgot SET NOCOUNT OFF. It works now. On Mon, Apr 5, 2010 at 9:41 AM, Dave Watts dwa...@figleaf.com wrote: Can I do it like this? ... Or do I need to use CFSTOREDPROC? In my own experience, this depends on the database and/or

Re: http header

2010-04-05 Thread Wil Genovese
I normally push MP3 files including sending the filesize so the browser knows how much there is to download and can display the status correctly. So I just swapped out the values for your excel file and this should work for you. cfset filename = mydoc.xls cfset foldername = [path to

RE: http header

2010-04-05 Thread Rick Sanders
Thank you! This was very helpful for me to get the proper syntax! -Original Message- From: Wil Genovese [mailto:jugg...@visi.com] Sent: Monday, April 05, 2010 11:59 AM To: cf-talk Subject: Re: http header I normally push MP3 files including sending the filesize so the browser knows

re: default for numeric argument

2010-04-05 Thread Jason Fisher
Well, depends on what your data needs to be. Sometimes 0 is not the same as no answer given. If you're allowing NULL in that data column and NULL means something different than 0, then you will want to *not* use default=0. Often in those cases, I do something like the following, where I set

recordcount from stored procedure call

2010-04-05 Thread Matthew Smith
cfobject component=redhotkittiescfcs.cart name=cart / cfset cart_check_item_quantities = cart.check_item_quantities( cf_user_id=#cfid#_#cftoken#) / cfif cart_check_item_quantities.recordcount cfobject component=redhotkittiescfcs.qry name=qry / cfset qry_cart_adjustments_get =

Code Assist and Code Coloring in Coldfusion Builder

2010-04-05 Thread David Mineer Jr
Code Assist and Code Coloring are not working in my workspace. However, they do work in the default workspace setup by the installation. Any ideas on how to remedy this? -- David Mineer Jr - The critical ingredient is getting off your butt and doing something. It's as

Re: Code Assist and Code Coloring in Coldfusion Builder

2010-04-05 Thread Dave Watts
Code Assist and Code Coloring are not working in my workspace. However, they do work in the default workspace setup by the installation. Any ideas on how to remedy this? These settings are per-workspace settings, I think. By default, when you create a new workspace, it won't carry over the

Re: JFreeChart with CF [spamtrap bayes][spamtrap heur]

2010-04-05 Thread Paul Hastings
On 4/5/2010 8:01 PM, Arsalan Tariq Keen wrote: How can I do that? what ver of jfreechart are you using? this works with the latest (1.0.13): cfscript color=createObject(java,java.awt.Color); plotOrientation=createObject(java,org.jfree.chart.plot.PlotOrientation);

recursive XML reader...

2010-04-05 Thread Brian Thornton
While striving for a recursive XML function to read valid XML I came up short... I seem to have a issue this_parent = ; delim = |; //this recursive function for n children function recurseXML(xmlElem) { var ii = 0;

Re: Code Assist and Code Coloring in Coldfusion Builder

2010-04-05 Thread David Mineer Jr
this is an already existing workspace, so I guess that wouldn't apply as I switch between the two and I did try it but it did not work. Creating a new workspace, even with out checking that option works fine. All code assist and coloring works when doing this. I guess I could move everything,

ColdFusion8 and fckeditor

2010-04-05 Thread Christine Olson
When our provider updated ColdFusion, our FCKeditor filebrowser ceased working. When we go to browse for a file or image we get the following error. The server didn't send back a proper XML response. Please contact your system administrator. XML request error: Access denied. (403)

Re: recursive XML reader...

2010-04-05 Thread Tony Bentley
I had a similar problem with the xml structure. If I remember correctly, XML is not actually an array and so I couldn't use arraylen(). I might be wrong but I tried this once and failed so I decided to bail out and loop through the known levels of the xml structure. I'm curious of this as

Re: recursive XML reader...

2010-04-05 Thread denstar
On Mon, Apr 5, 2010 at 11:44 AM, Brian Thornton wrote: While striving for a recursive XML function to read valid XML I came up short... ... When it get's to child 2, grandchild2 it cannot keep track of where it belongs... Any ideas? When doing *any* type of recursion, it's *super*

java.lang.String as a structure with members

2010-04-05 Thread Rick Sanders
I've done this a dozen times before, and now the following code gives me this error: You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members. This is the line throwing the error: cfset logo1 = #Trim(t1.Logo)# The logo being pulled

Re: java.lang.String as a structure with members

2010-04-05 Thread Barney Boisvert
cfset t1 = #Trim(t1.Team)# you're setting t1 equal to a string, so it's no longer a recordset. cheers, barneyb On Mon, Apr 5, 2010 at 12:33 PM, Rick Sanders c...@webenergy.ca wrote: I've done this a dozen times before, and now the following code gives me this error: You have attempted to

Re: java.lang.String as a structure with members

2010-04-05 Thread Tony Bentley
Your query assumes that there is only one row expected. What happens when you put the cfset inside of a cfoutput query tag? How many records are there? See my modified markup below. cfquery name=Games datasource=hockey SELECT Team1, Team2, GameDate, GameTime, Location, Comments FROM Games

Re: return recordset from stored procedure

2010-04-05 Thread Nicholas Stein
Yes, the NOCOUNT may give you trouble. However, I noticed something else in your sample code. You are using #request.datasources# as your datasource for the query. If you are referring to the http request, you could run into a problem if you decide to put your function into a cfc. The cfc,

Re: return recordset from stored procedure

2010-04-05 Thread Dave Watts
Yes, the NOCOUNT may give you trouble.  However, I noticed something else in your sample code. You are using #request.datasources# as your datasource for the query.  If you are referring to the http request, you could run into a problem if you decide to put your function into a cfc.  The

PDF alternate to cfdocument

2010-04-05 Thread Shaun Webster
Hi. Does anyone know of an easy alternate to create dynamic pdf that does not use cfdocument? We have gotten into a situation on our server that use CF7 standard (not multi thread) where some 2-5 page pdfs w/ a few images block up the thread que and eventually crash jrun. This happens

Re: PDF alternate to cfdocument

2010-04-05 Thread Mike Chabot
http://www.activepdf.com/ Keep in mind that there are different PDF types. There are nicely formatted reports that export as a PDF, then there PDFs that have a less-defined structure. It is the difference between cfreport and cfdocument. A number of options open up to you if you are able to deal

Re: recordcount from stored procedure call

2010-04-05 Thread Matthew Smith
Still stumped on this. It seems that cart_check_item_quantities is somehow stopping the second recordset from existing. What is going on here? This: cfcase value=start !--- cfobject component=redhotkittiescfcs.cart name=cart / cfset cart_check_item_quantities = cart.check_item_quantities(

Re: java.lang.String as a structure with members

2010-04-05 Thread Maureen
You are using t1 as the name of a query: cfquery name=t1 datasource=hockey then you set it to a string cfset t1 = #Trim(t1.Team)# then you try to use it again as a query name. cfset logo1 = #Trim(t1.Logo)# Also, you don't need the quotes around the string on the right of the = sign change

Re: recordcount from stored procedure call

2010-04-05 Thread Matthew Smith
I fail at cfabort. disregard. Sorry. On Mon, Apr 5, 2010 at 5:56 PM, Matthew Smith chedders...@gmail.com wrote: Still stumped on this. It seems that cart_check_item_quantities is somehow stopping the second recordset from existing. What is going on here? This: cfcase value=start !---

Best way to return generated html from cfc

2010-04-05 Thread Matthew Smith
I have a cfc that will generate some html to be displayed inline. I was just going to reuturn a string rather than have it output directly. Is this the proper way to do that? How do I save generated html from cf code into a variable to be returned as a string? Thanks.

Re: Best way to return generated html from cfc

2010-04-05 Thread Barney Boisvert
Yep, that's exactly the way to do it. cffunction returntype=string cfset var stuff = / cfsavecontent variable=stuff ... blah bla blah ... /cfsavecontent cfreturn stuff / /cffunction cheers, barneyb On Mon, Apr 5, 2010 at 4:22 PM, Matthew Smith chedders...@gmail.com wrote: I have a cfc

Re: Best way to return generated html from cfc

2010-04-05 Thread Matt Quackenbush
Take a look at cfsavecontent Sent from my iPhone On Apr 5, 2010, at 18:22, Matthew Smith chedders...@gmail.com wrote: I have a cfc that will generate some html to be displayed inline. I was just going to reuturn a string rather than have it output directly. Is this the proper way

RE: Best way to return generated html from cfc

2010-04-05 Thread brad
use cfsavecontent in the CFC to put the generated HTML into a variable. Don't forget to var the cfsavecontent variable first. ~Brad Original Message Subject: Best way to return generated html from cfc From: Matthew Smith chedders...@gmail.com Date: Mon, April 05, 2010 6:22

RE: java.lang.String as a structure with members

2010-04-05 Thread Rick Sanders
Thanks, I realized it after I saw I didn't have the cfoutput tags after the queries! Rick -Original Message- From: Tony Bentley [mailto:cascadefreehee...@gmail.com] Sent: Monday, April 05, 2010 4:34 PM To: cf-talk Subject: Re: java.lang.String as a structure with members Your query

Re: Best way to return generated html from cfc

2010-04-05 Thread Matthew Smith
That's what I was looking for. Couldn't remember the tag. Thanks all. On Mon, Apr 5, 2010 at 6:25 PM, Barney Boisvert bboisv...@gmail.com wrote: Yep, that's exactly the way to do it. cffunction returntype=string cfset var stuff = / cfsavecontent variable=stuff ... blah bla blah ...

Re: JFreeChart with CF [spamtrap bayes][spamtrap heur]

2010-04-05 Thread Arsalan Tariq Keen
Paul, your code works... its showing labels! However, its showing 'php sucks1!' and 'php sucks 2!' in the label. Whereas, I want to display the actual value of each bar, which in your example would be 1,5,3,2,3,2. What shall I change in this code? Regards, Arsalan

Re: Decrypt CF scheduled job password?

2010-04-05 Thread Qing Xia
Thanks to all who replied! Your suggestions on Googling coldfusion decrypt datasource password were most helpful. I just switched jobs where my new job practices Agile Programming (a.k.a. paired programming). While this practice is so far interesting and rewarding, it has definitely reduced my

Re: Code Assist and Code Coloring in Coldfusion Builder

2010-04-05 Thread Sean Corfield
On Mon, Apr 5, 2010 at 11:06 AM, David Mineer Jr min...@gmail.com wrote: this is an already existing workspace, so I guess that wouldn't apply as I switch between the two and I did try it but it did not work. So it was a workspace created by something other than ColdFusion Builder? That's

Re: JFreeChart with CF [spamtrap bayes][spamtrap heur]

2010-04-05 Thread Arsalan Tariq Keen
Thanks Paul... I made the changes myself. Now I have what I wanted. Thanks man. Couldn't have done it without your help. Regards, Arsalan -- From: Arsalan Tariq Keen arsalk...@hotmail.com Sent: Tuesday, April 06, 2010 6:45 AM To: cf-talk

ColdFusion dateDiff() function?

2010-04-05 Thread Qing Xia
Okay, I am probably splitting hairs over here, but I ran into an icky situation with the native ColdFusion function DateDiff() today and just thought I'd check whether anyone else has experienced this before. Basically, I wrote a CF Scheduled Task that is supposed to go to a directory and delete

Re: Best way to return generated html from cfc

2010-04-05 Thread Qing Xia
I have a cfc that will generate some html to be displayed inline. I was just going to reuturn a string rather than have it output directly. Is this the proper way to do that? I've been struggling to draw a clear line between the usage of CFCs and Custom Tags, but one general trend I see

Re: ColdFusion dateDiff() function?

2010-04-05 Thread Brad Wood
Nope, it's working as designed. Here is an excerpt from the docs: The DateDiff function determines the number of complete datepart units between the two dates; for example, if the datepart parameter is m and the dates differ by 55 days, the function returns 1. So basically, using date diff is

Re: ColdFusion dateDiff() function?

2010-04-05 Thread Mike Chabot
If only two minutes separate timestamps, that is less than a day from my perspective, so the value should be 0. If 24 hours separate the two timestamps, that would be a one day difference. There are plenty of solutions to the problem. One is to remove the time element before doing the

Re: ColdFusion dateDiff() function?

2010-04-05 Thread Qing Xia
Hmm... thanks Brad and Mike for your quick replies. I have thought about your answers deeply and decided they do make sense. :-) I read the CF Docs too quickly and made the assumption (never good to assume!) that the CF dateDiff() function works the same way as the SQL dateDiff() function, which

Re: PDF alternate to cfdocument

2010-04-05 Thread Al Musella, DPM
LocalURL came into being with coldfusion 8,, and he said he is using cf7 Make sure to read the optimization notes related to cfdocument. There are tricks you can do which speed up embedding of images, which are documented in a number of places, including the online help. If cfdocument is

Re: Best way to return generated html from cfc

2010-04-05 Thread Matthew Smith
We are selling unique items. When the user looks at their cart or right before the last step in placing an order, I verify that no one has bought the item or it has been removed from inventory for some other reason. So I want a cfc that will check to see if adjustments need to be made, and if

Re: ColdFusion dateDiff() function?

2010-04-05 Thread Andrew Scott
The easiest solution would be to remove the time stamp of the compare. On Tue, Apr 6, 2010 at 12:50 PM, Qing Xia txiasum...@gmail.com wrote: Hmm... thanks Brad and Mike for your quick replies. I have thought about your answers deeply and decided they do make sense. :-) I read the CF Docs

Re: PDF alternate to cfdocument

2010-04-05 Thread Craigsell
I would use iText (http://itextpdf.com/). It's the same code that runs behind CFPDF. I gave up on CFdocumnat about a month ago and haven't looked back. The amount of control I have is great, all my layout issues went away, and it runs faster. CF7/8 ships with version 2 but I used version 5

Re: PDF alternate to cfdocument [spamtrap bayes][spamtrap heur][auto-ip]

2010-04-05 Thread Paul Hastings
On 4/6/2010 10:52 AM, Craigsell wrote: I would use iText (http://itextpdf.com/). It's the same code that runs i think he specified easy ;-) ~| Want to reach the ColdFusion community with something they want? Let them know

Re: JFreeChart with CF [spamtrap bayes][spamtrap heur]

2010-04-05 Thread Paul Hastings
On 4/6/2010 8:45 AM, Arsalan Tariq Keen wrote: Paul, your code works... its showing labels! However, its showing 'php sucks1!' and 'php sucks 2!' in the label. Whereas, I want to display the actual value of each bar, which in your example would be 1,5,3,2,3,2. What shall I change in this