RE: CF Debugger for application scoped CFC
It works just fine for me. Setting break points before or after it's loaded to memory works for me. What I have seen is that sometimes it does not stop on the breakpoint that I have set if I have changed the code once it's in memory or if the debugger finds some issue that it does not tell you about. Try setting the break point in different locations, you'll probably find that it stops on one of them so at least you can look at something. -Original Message- From: Dorioo [mailto:dor...@gmail.com] Sent: Thursday, March 04, 2010 11:11 AM To: cf-talk Subject: Re: CF Debugger for application scoped CFC Don't know if it's supposed to work, but I have experienced it _not_ working once the CFC is in memory. Told myself that the debugger processes files used in the request. Once the CFC is memory, no files are parsed for it and so the debugger does not fire. I'd love to be wrong though. - Gabriel On Thu, Mar 4, 2010 at 11:05 AM, Brook Davies cft...@logiforms.com wrote: Hi Jochem, The debugging service itself starts and is running. The debugger does not break on the breakpoints. Sorry I should have been more clear. I did put the breakpoints in before caching. Should this work? Brook -Original Message- From: Jochem van Dieten [mailto:joch...@gmail.com] Sent: March-03-10 11:50 PM To: cf-talk Subject: Re: CF Debugger for application scoped CFC On 3/4/10, Brook Davies wrote: I just set up the eclipse based CF debugger from adobe. Works fine on a CFM, but doesn't start for an application scoped CFC. What do you mean exactly with doesn't start? Do you mean that th debug server doesn't start? Or do you mean that breakpoints you set are not being triggered? If the latter, did you put the breakpoints in before caching your cfc in the application scope? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331377 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Building Hierarchal Lists using CF
I would do this in a recursive function that takes a depth parameter that will indent the presented data in some form (margin,table cells,tabs) and return the formatted output. I have one that is kind of extensive that builds a hierarchal output of almost any value given to it, kinda like cfdump but it evaluates the objects. I can post it if you like. -Original Message- From: Steve Keator [mailto:skea...@mlinc.com] Sent: Friday, February 26, 2010 9:24 AM To: cf-talk Subject: Building Hierarchal Lists using CF Hello Gang, This one, I have to say, eludes me. There is probably a very easy way of doing this that I just don't see, but a little help would be awesome. I have a list of categories from a query where I have parent-child relationships going on, where my ID can also be associated within a column called 'PARENT'. Something like this: IDNameParent_ID 1 Category A 0 2 Category B 0 3 Category A1 1 4 Category A2 1 5 Category B12 6 Category B22 7 Category A3 1 .. and so on, to be displayed like this: Category A Category A1 Category A2 Category A3 Category B Category B1 Category B2 Anyways, I'm not quite sure how to handle this. Somehow I know a CFLOOP has to come into all of this (or several)? I'd like to be able to make this modular so that even 5 or 6 nests deep that every category in my query would show (without, of course, getting repetitive and redundant in coding). Any thoughts or hints? Cheers, S. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331175 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFStoredProc.StatusCode makes stored proc public
Declaring the result doesn't work, had tried that earlier. What did work was declaring the stored proc like so: cfset var cfstoredproc=StructNew() Thanks for the slap on the back of the head. -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Tuesday, November 24, 2009 1:44 PM To: cf-talk Subject: RE: CFStoredProc.StatusCode makes stored proc public Just a guess, but do you have to declare the stored procedure and result? cfset var foo = -Original Message- From: Dave Phelan [mailto:dphe...@lifepoint.com] Sent: Tuesday, November 24, 2009 12:57 PM To: cf-talk Subject: CFStoredProc.StatusCode makes stored proc public All, I have written a central monitor app in flex that uses CF remote objects to call CF web services for data retrieval. One of the functions in the web service calls a stored function that will return success or failure. The issue is that I am trying to keep everything local to the function, but as soon as I set ReturnCode to true, cfstoredproc becomes a public variable. I have tried using cfprocresult, but it never gets populated. I have tried setting the return variable, but cfstoredproc still goes public. The result variable stays local, so I guess if I never reference cfstoredproc.* I'll be OK, but I'd like to be able to keep it local. Anyone have any suggestions? I am using Flex 3 for the UI, CF 8 for the date retrieval and manipulation, win 2k3 server with IIS, and Intersystems Cache2k8 as the backend. David Phelan Sr. CF Developer LifePoint Informatics 201-447-9991 Ext 318 dphe...@lifepoint.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328745 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFStoredProc.StatusCode makes stored proc public
All, I have written a central monitor app in flex that uses CF remote objects to call CF web services for data retrieval. One of the functions in the web service calls a stored function that will return success or failure. The issue is that I am trying to keep everything local to the function, but as soon as I set ReturnCode to true, cfstoredproc becomes a public variable. I have tried using cfprocresult, but it never gets populated. I have tried setting the return variable, but cfstoredproc still goes public. The result variable stays local, so I guess if I never reference cfstoredproc.* I'll be OK, but I'd like to be able to keep it local. Anyone have any suggestions? I am using Flex 3 for the UI, CF 8 for the date retrieval and manipulation, win 2k3 server with IIS, and Intersystems Cache2k8 as the backend. David Phelan Sr. CF Developer LifePoint Informatics 201-447-9991 Ext 318 dphe...@lifepoint.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328647 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) SQL Question - flattening data
You wrote a pivot query without using pivot. BTW, the aggregate for the pivot query can be Count(). -Original Message- From: Rick Root [mailto:rick.r...@gmail.com] Sent: Friday, November 13, 2009 4:19 PM To: cf-talk Subject: Re: (ot) SQL Question - flattening data From the documentation, pivot tables seem to require aggregate functions... The generic description would seem to work but the examples make it difficult to see how. But... I figured out a solution! Using SQL Server's row_number() over (partition by XXX order by XXX) I can make a subquery that returns data like this entityid,rownum,rectyp And then run this query (tb901 is my primary table) select tb901.entityid, R1.rectypcd as rectype1, r2.rectypcd as rectype2, r3.rectypcd as rectype3, r4.rectypcd as rectype4, r5.rectypcd as rectype5 from tb901 left join ( select row_number() over(partition by entityid order by rectypcd) as rownum, entityid, rectypcd from tb906 ) R1 on tb901.entityid=R1.entityid and R1.rownum=1 left join ( select row_number() over(partition by entityid order by rectypcd) as rownum, entityid, rectypcd from tb906 ) R2 on tb901.entityid=R2.entityid and R2.rownum=2 left join ( select row_number() over(partition by entityid order by rectypcd) as rownum, entityid, rectypcd from tb906 ) R3 on tb901.entityid=R3.entityid and R3.rownum=3 left join ( select row_number() over(partition by entityid order by rectypcd) as rownum, entityid, rectypcd from tb906 ) R4 on tb901.entityid=R4.entityid and R4.rownum=4 left join ( select row_number() over(partition by entityid order by rectypcd) as rownum, entityid, rectypcd from tb906 ) R5 on tb901.entityid=R5.entityid and R5.rownum=5 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328395 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) SQL Question - flattening data
Is there a particular reason to return them in this format? I would think that the straight query output would be simpler to work with. However, you can accomplish this either by using cursors to loop over the query output and build what you are looking for or by building a crosstab query of the data. I haven't built a crosstab query in quite a while and don't remember all the specifics, but the output would be similar to: Entity AL FR TR HS FU FM RickX X X X Joe X X Bob X Crosstab queries can be a little hairy to build. IMHO, go with the cursors. -Original Message- From: Rick Root [mailto:rick.r...@gmail.com] Sent: Friday, November 13, 2009 10:41 AM To: cf-talk Subject: (ot) SQL Question - flattening data I'm trying to flatten out some data using only SQL we currently have a mainframe job that produces a datafeed for me uses cobol to do the work of looping through all the entities and putting up to 5 record types in 5 record type fields in the output file. I'm trying to figure out a way to do it with SQL alone so I can just use a transact-sql job to produced my flattened reporting table. So for example, let's say I've got a table like this: create table entityRecordTypes ( entityid char(10), recordType char(2), primary key (entityid, recordType) ); How do I get from here ... rick,AL rick,FR rick,TR rick,HS joe,AL joe,FU Bob,FM to a view or table that has this structure entityid,rectype1,rectype2,rectype3,rectype4,rectype5 rick,AL,FR,TR,HS,NULL joe,AL,FU,NULL,NULL,NULL bob,FM,NULL,NULL,NULL,NULL using SQL. if an entity had more than 5 record types, only the first 5 would be put into the output table/view. Rick ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CreateObject error on new server
In our application we have a cfc that we instantiate to a variable in certain instances. This has always worked without issue until we got our new server. On the new server, when I call the CreateObject method, it produces the error: The filename, directory name, or volume label syntax is incorrect The new server is running: Server 2003 IIS6 And CF7 The old server runs: Server 2000 IIS5 CF7 The paths on both servers are the same. The call that fails is: cfset LTFunc=CreateObject(component,/xyz/lts/LTFunctions) Any ideas? Please note my new email address. David Phelan Senior CF Developer LifePoint Informatics (Formerly Labtest.com) (201) 447-9991 Ext. 318 [EMAIL PROTECTED]mailto:[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:309324 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CreateObject error on new server
I changed it to the dot notation but still got the same error. We have a map to the root and the xyz/lts directory is directly below the root. Please note my new email address. David Phelan Senior CF Developer LifePoint Informatics (Formerly Labtest.com) (201) 447-9991 Ext. 318 [EMAIL PROTECTED] -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 9:54 AM To: CF-Talk Subject: RE: CreateObject error on new server In our application we have a cfc that we instantiate to a variable in certain instances. This has always worked without issue until we got our new server. On the new server, when I call the CreateObject method, it produces the error: The filename, directory name, or volume label syntax is incorrect The new server is running: Server 2003 IIS6 And CF7 The old server runs: Server 2000 IIS5 CF7 The paths on both servers are the same. The call that fails is: cfset LTFunc=CreateObject(component,/xyz/lts/LTFunctions) Any ideas? Use dots instead of slashes. Dots are the preferred nomenclature for specifying path information of CFCs. Also, make sure you've created the appropriate mapping to the xyz directory within the CF Administrator. 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:309326 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CreateObject error on new server
That did it! Thanks Very Much! Please note my new email address. David Phelan Senior CF Developer LifePoint Informatics (Formerly Labtest.com) (201) 447-9991 Ext. 318 [EMAIL PROTECTED] -Original Message- From: Andrew Tyrone [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 10:50 AM To: CF-Talk Subject: RE: CreateObject error on new server I changed it to the dot notation but still got the same error. We have a map to the root and the xyz/lts directory is directly below the root. I had a problem like this a long time ago. Deleting and re-creating the mapping solved it. ~| 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:309334 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4