SOT - Multi-dimensional tree diagrams
Has anyone seen anything similar to this that is open source that can be driven from a database and/or XML- thank you!!! http://asterisq.com/ ++ Kevin Parker Advanced Imaging e: webmas...@advancedimaging.com.au w: www.advancedimaging.com.au m: 0418 815 527 ++ http://au.linkedin.com/in/krparker ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347696 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Way OT - Technical Writing
Sorry for the way OT post. But I am going crazy trying to find a good technical writer to write a user guide for our CF web app. I've gone through a few people already. They keep writing stuff that seems to make the topics MORE difficult. I think I would pull my hair out trying to use what they are writing. I suspect the people on this list have had to hire technical writers at one point or another. Does anyone have a good technical writer they use for projects that they want to refer to me??? I would be so grateful. Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347697 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Ecommerce - need it to allow vendors to manage their own inventory sections - any recommendations?
The best test is to try both and see if your app works on them without issue, and then look at their unique features. Of course, there *is* information out there in terms of what they don't support that ACF does, you don't have to go to the trouble of running your app to find that out. Here's some Railo information: http://wiki.getrailo.org/wiki/Tags_Not_Supported Mary Jo ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347698 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Ecommerce - need it to allow vendors to manage their own inventory sections - any recommendations?
The best test is to try both and see if your app works on them without issue, and then look at their unique features. And unsupported functions: http://wiki.getrailo.org/wiki/Functions_Not_Supported Not sure if this is comprehensive, and you'd still want to test your app, but this is a good starting point to see if you are using anything that is known to not work. Mary Jo ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347699 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
coldfusion
We have a server that has 2 urls pointing to it.. If I log in servera.org and then hit some log in required page and then change the url to serverb.org I'm told to log in.. Does CF think it's a different application? different session? And is there an easy way to correct this? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347700 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Does coldfusion see 2 urls as different applications or sessions?
Sorry for the horrible subject before.. I began writing it, wrote the body and before I went back to append the subject I hit send.. On Mon, Sep 26, 2011 at 9:25 AM, Greg Morphis gmorp...@gmail.com wrote: We have a server that has 2 urls pointing to it.. If I log in servera.org and then hit some log in required page and then change the url to serverb.org I'm told to log in.. Does CF think it's a different application? different session? And is there an easy way to correct this? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347701 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Does coldfusion see 2 urls as different applications or sessions?
yes because cookies are domain specific and that is how your session is identified unless you are manually passing cfid and cftoken on the url. On Mon, Sep 26, 2011 at 3:27 PM, Greg Morphis gmorp...@gmail.com wrote: Sorry for the horrible subject before.. I began writing it, wrote the body and before I went back to append the subject I hit send.. On Mon, Sep 26, 2011 at 9:25 AM, Greg Morphis gmorp...@gmail.com wrote: We have a server that has 2 urls pointing to it.. If I log in servera.org and then hit some log in required page and then change the url to serverb.org I'm told to log in.. Does CF think it's a different application? different session? And is there an easy way to correct this? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347702 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Does coldfusion see 2 urls as different applications or sessions?
Just to add on specific point of clarification ColdFusion bases it's decision about Application scopes entirely on the name of the application. So as long as in your Application.cfc this.name is the same no matter what domain name you hit, then CF is referencing the same application variables. ex. cfset this.name = mywebsite_Public_08242011_1311 If you use part of the domain name to set your Application Name, then they have different application scopes. ex cfset this.name = #ListFirst(cgi.server_name, '.')#_Public_08242011_1311 But as Russ pointed out, you are setting domain specific session cookies, so if you jump from domainA.com to domainB.com your browser won't know you are on the same site and will not send your session cookies from A to B. =] -- Alan Rother Manager, Phoenix Cold Fusion User Group, www.AZCFUG.org Twitter: @AlanRother ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347703 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Standard License
Not sure if this is comprehensive, and you'd still want to test your app, but this is a good starting point to see if you are using anything that is known to not work. Oops, sorry about the messed up subject. Didn't realize LastPass was filling that in from the last thread I replied to online. Mary Jo ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347704 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Executing Java in CF
Hi, I'm having no luck finding this documentation, maybe someone know off the top of their head. I have some server sided java code I need to execute in a coldfusion page. That may call either a .war or .jar file. How do I specify in the CF page that a portion of the code is JAVA? Thanks, Robert Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347705 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Does coldfusion see 2 urls as different applications or sessions?
Cool, that's what I was assuming was happening, the domain name difference in the session cookies but wasn't sure how to search for that.. figured asking people would be the best way. Thanks guys! On Mon, Sep 26, 2011 at 9:45 AM, Alan Rother alan.rot...@gmail.com wrote: Just to add on specific point of clarification ColdFusion bases it's decision about Application scopes entirely on the name of the application. So as long as in your Application.cfc this.name is the same no matter what domain name you hit, then CF is referencing the same application variables. ex. cfset this.name = mywebsite_Public_08242011_1311 If you use part of the domain name to set your Application Name, then they have different application scopes. ex cfset this.name = #ListFirst(cgi.server_name, '.')#_Public_08242011_1311 But as Russ pointed out, you are setting domain specific session cookies, so if you jump from domainA.com to domainB.com your browser won't know you are on the same site and will not send your session cookies from A to B. =] -- Alan Rother Manager, Phoenix Cold Fusion User Group, www.AZCFUG.org Twitter: @AlanRother ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347706 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SQL need to return data even if specific where statement isnt matched
've built an extension to a employment application where we can easily add new questions to the form. I need to query to match on both which job they applied to and what application ID it is. I need to return both the answer and the question, the problem is it will return both if both are defined, but I need it to return the question, even if the application isn't defined, but right now it'll only return the question if the answer is defined. Please help! Code: (Note the where uses a Coldfusion variable, so nothing out of the normal) SELECT dbo.mod_employmentAppQuestionAnswers.questionID ,dbo.mod_employmentAppQuestionAnswers.questionDefinitionID ,dbo.mod_employmentAppQuestionAnswers.AppID ,dbo.mod_employmentAppQuestionAnswers.questionText ,dbo.mod_employmentAppQuestionAnswers.questionDate1 ,dbo.mod_employmentAppQuestionAnswers.questionDate2 ,dbo.mod_employmentAppQuestionAnswers.questionBit ,dbo.mod_employmentAppQuestionDefinitions.definitionID ,dbo.mod_employmentAppQuestionDefinitions.jobTitleID ,dbo.mod_employmentAppQuestionDefinitions.title AS QuestionTitle ,dbo.mod_employmentAppQuestionDefinitions.questionTypeID ,dbo.mod_employmentAppQuestionDefinitions.description ,dbo.mod_employmentAppQuestionDefinitions.isActive ,dbo.mod_employmentAppJobTitles.title AS JobTitle ,dbo.mod_employmentAppQuestionTypes.type AS QuestionType FROM dbo.mod_employmentAppQuestionAnswers FULL JOIN dbo.mod_employmentAppQuestionDefinitions ON dbo.mod_employmentAppQuestionAnswers.questionDefinitionID = dbo.mod_employmentAppQuestionDefinitions.definitionID INNER JOIN dbo.mod_employmentAppJobTitles ON dbo.mod_employmentAppQuestionDefinitions.jobTitleID = dbo.mod_employmentAppJobTitles.jobTitleID LEFT JOIN dbo.mod_employmentAppQuestionTypes ON dbo.mod_employmentAppQuestionDefinitions.questionTypeID = dbo.mod_employmentAppQuestionTypes.questionTypeID WHERE (dbo.mod_employmentAppQuestionDefinitions.jobTitleID = cfqueryparam cfsqltype=cf_sql_integer value=#jobTitleID# /) AND (dbo.mod_employmentAppQuestionAnswers.AppID = cfqueryparam cfsqltype=cf_sql_integer value=#applicationID# /) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347707 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Executing Java in CF
make sure the java class files are loaded by CF, stick them in the lib folder for example then restart cf, then check in the cf info page in the cfadmin and see if they loaded, then you will be able to call the functions using CreateObject(java) just as u would any of the built in java functions. On Mon, Sep 26, 2011 at 4:25 PM, Robert Harrison rob...@austin-williams.com wrote: Hi, I'm having no luck finding this documentation, maybe someone know off the top of their head. I have some server sided java code I need to execute in a coldfusion page. That may call either a .war or .jar file. How do I specify in the CF page that a portion of the code is JAVA? Thanks, Robert Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347708 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion
It sure will see them as seperate appsbecause they are ;-) That's all I have until you tell us if: 1) The app on each server is in fact the same (I assume so) 2) You setup load balancing between the 2 servers and expect the app to be seen as the same on each server If the answer to 1 2 is yes, then I'd say you have a problem. Cheers On Mon, 2011-09-26 at 09:25 -0500, Greg Morphis wrote: We have a server that has 2 urls pointing to it.. If I log in servera.org and then hit some log in required page and then change the url to serverb.org I'm told to log in.. Does CF think it's a different application? different session? And is there an easy way to correct this? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347709 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion
This might not apply to your situation, but I have a few domain names that lead to my same website (.com. .org as well as common mispelling). What I do is detect the name used and redirect to the main domain name when they first hit the website At 12:01 PM 9/26/2011, you wrote: It sure will see them as seperate appsbecause they are ;-) That's all I have until you tell us if: 1) The app on each server is in fact the same (I assume so) 2) You setup load balancing between the 2 servers and expect the app to be seen as the same on each server If the answer to 1 2 is yes, then I'd say you have a problem. Cheers On Mon, 2011-09-26 at 09:25 -0500, Greg Morphis wrote: We have a server that has 2 urls pointing to it.. If I log in servera.org and then hit some log in required page and then change the url to serverb.org I'm told to log in.. Does CF think it's a different application? different session? And is there an easy way to correct this? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347710 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SQL grrr
Hi, i know this is probably a simple answer and i probably drunk too much coffee! given the following sql data: ID value 1 A 1 B 1 C 2 A 2 B 3 A 3 B 3 C i need to run a query that says return me the ids that are linked to values A and B and C. so this query on the above data would return IDs 1 and 3 thanks :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347711 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM overhead
to rephrase this question slightly, has there been much take up on the CF9 ORM? i read somewhere it was one of the most welcome enhancements in CF9, but then i also read somewhere else its an overhead too far for many developers Hi, we are looking to restructure our system using ORM but are wondering: firstly, about the general overhead of the CF9 ORM? secondly, the overhead in terms of the following scenario: Our application is generalized and customizes itself and its database around users requirements. The users login to one central application but each client has their own database. So after logging in the system knows which database to use. Therefore, it appears we will have to configure ORM to setup an instance for each individual client. This could obviously spiral into the thousands. Would appreciate your feedback thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347712 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL grrr
Something like... SELECT ID FROM MyTable WHERE value IN (cfqueryparam cfsqltype=cf_sql_varchar value=#myList# list=true /) ; ?? On Mon, Sep 26, 2011 at 12:18 PM, Richard White rich...@j7is.co.uk wrote: Hi, i know this is probably a simple answer and i probably drunk too much coffee! given the following sql data: ID value 1 A 1 B 1 C 2 A 2 B 3 A 3 B 3 C i need to run a query that says return me the ids that are linked to values A and B and C. so this query on the above data would return IDs 1 and 3 thanks :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347713 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL grrr
ids that are linked to values A and B and C. If you mean only ID's linked to all three (3) values? Something like this cfset distinctValues = A,B,C ... SELECT ID, COUNT(Value) AS MatchCount FROM TableName WHERE ID IN ( cfqueryparam value=#distinctValues# list=true cfsqltype=cf_sql_varchar ) HAVING COUNT(Value) = cfqueryparam value=#listLen(distinctValues)# cfsqltype=cf_sql_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347714 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL grrr
Richard, I think this will work (untested, assumes SQL Server): select t.ID from mytable t inner join mytable a on t.id = a.id and a.value = 'A' inner join mytable b on t.id = b.id and b.value = 'B' inner join mytable c on t.id = c.id and c.value = 'C' HTH, Carl ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347715 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL grrr
I'm sure there is a much more efficient way of doing this, but this would work: SELECT distinct ID from table where id in (select ID from table where val = 'A' and id in (select id from table where val = 'B' and ID in (select id from table where val = 'C'))) On Mon, Sep 26, 2011 at 1:18 PM, Richard White rich...@j7is.co.uk wrote: Hi, i know this is probably a simple answer and i probably drunk too much coffee! given the following sql data: ID value 1 A 1 B 1 C 2 A 2 B 3 A 3 B 3 C i need to run a query that says return me the ids that are linked to values A and B and C. so this query on the above data would return IDs 1 and 3 thanks :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347716 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL grrr
Yup, I think Carl's is the best, though you'd probably want to throw a GROUP BY in there so you don't get multiple rows for the same ID. -- Josh On Mon, Sep 26, 2011 at 10:41 AM, Carl Von Stetten vonner.li...@vonner.netwrote: Richard, I think this will work (untested, assumes SQL Server): select t.ID from mytable t inner join mytable a on t.id = a.id and a.value = 'A' inner join mytable b on t.id = b.id and b.value = 'B' inner join mytable c on t.id = c.id and c.value = 'C' HTH, Carl ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347717 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL grrr
Or change the first line to: select distinct t.ID (again assumes SQL Server) Carl On 9/26/2011 10:44 AM, Josh Nathanson wrote: Yup, I think Carl's is the best, though you'd probably want to throw a GROUP BY in there so you don't get multiple rows for the same ID. -- Josh On Mon, Sep 26, 2011 at 10:41 AM, Carl Von Stetten vonner.li...@vonner.netwrote: Richard, I think this will work (untested, assumes SQL Server): select t.ID from mytable t inner join mytable a on t.id = a.id and a.value = 'A' inner join mytable b on t.id = b.id and b.value = 'B' inner join mytable c on t.id = c.id and c.value = 'C' HTH, Carl ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347718 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM overhead
You're not going to get anything other than anecdotal opinions, but everyone I know switched to ORM as soon as it was available. As far as overhead, I'm not sure what you mean. Coding overhead? Performance overhead? On Mon, Sep 26, 2011 at 1:21 PM, Richard White rich...@j7is.co.uk wrote: to rephrase this question slightly, has there been much take up on the CF9 ORM? i read somewhere it was one of the most welcome enhancements in CF9, but then i also read somewhere else its an overhead too far for many developers Hi, we are looking to restructure our system using ORM but are wondering: firstly, about the general overhead of the CF9 ORM? secondly, the overhead in terms of the following scenario: Our application is generalized and customizes itself and its database around users requirements. The users login to one central application but each client has their own database. So after logging in the system knows which database to use. Therefore, it appears we will have to configure ORM to setup an instance for each individual client. This could obviously spiral into the thousands. Would appreciate your feedback thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347719 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL grrr
thanks, works perfect! Hi, i know this is probably a simple answer and i probably drunk too much coffee! given the following sql data: ID value 1 A 1 B 1 C 2 A 2 B 3 A 3 B 3 C i need to run a query that says return me the ids that are linked to values A and B and C. so this query on the above data would return IDs 1 and 3 thanks :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347720 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL grrr
If you mean only ID's linked to all three (3) values? Something like this Duh. Just noticed I left off the GROUP BY... cfset distinctValues = A,B,C ... SELECT ID, COUNT(Value) AS MatchCount FROM TableName WHERE ID IN ( cfqueryparam value=#distinctValues# list=true cfsqltype=cf_sql_varchar ) GROUP BY ID HAVING COUNT(Value) = cfqueryparam value=#listLen(distinctValues)# cfsqltype=cf_sql_integer ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347721 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ORM overhead
Performance overhead, especially in an application that could be linked to thousands of data sources? -Original Message- From: Brian Kotek [mailto:brian...@gmail.com] Sent: 26 September 2011 18:49 To: cf-talk Subject: Re: ORM overhead You're not going to get anything other than anecdotal opinions, but everyone I know switched to ORM as soon as it was available. As far as overhead, I'm not sure what you mean. Coding overhead? Performance overhead? On Mon, Sep 26, 2011 at 1:21 PM, Richard White rich...@j7is.co.uk wrote: to rephrase this question slightly, has there been much take up on the CF9 ORM? i read somewhere it was one of the most welcome enhancements in CF9, but then i also read somewhere else its an overhead too far for many developers Hi, we are looking to restructure our system using ORM but are wondering: firstly, about the general overhead of the CF9 ORM? secondly, the overhead in terms of the following scenario: Our application is generalized and customizes itself and its database around users requirements. The users login to one central application but each client has their own database. So after logging in the system knows which database to use. Therefore, it appears we will have to configure ORM to setup an instance for each individual client. This could obviously spiral into the thousands. Would appreciate your feedback thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347722 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Executing Java in CF
make sure the java class files are loaded by CF, stick them in the lib folder for example then restart cf, then check in the cf info page in the cfadmin and see if they loaded, then you will be able to call the functions using CreateObject(java) just as u would any of the built in java functions. Also don't forget that there is the javaloader cfc. It lets you put the class library wherever you want it without restarting cf. http://www.compoundtheory.com/?action=displayPostID=117 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347723 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfquickdocs.com down?
http://cfquickdocs.com/ seems to be down (since yesterday) I believe. Anybody know who maintained this/can reach out to them? Has proved to be really useful for looking things up. Thanks -- Kumar Shah http://www.coldfusion-ria.com/Blog/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347724 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM overhead
On Mon, Sep 26, 2011 at 8:07 PM, Richard (J7 Group) wrote: Performance overhead, especially in an application that could be linked to thousands of data sources? I think an application with thousands of datasources is so far out of the experience of other users that we will have no way of answering your question. I do have a few questions that may be helpful in finding the right questions and answers yourself. 1. What would you consider an acceptable overhead in terms of GB of RAM? 2. What would you consider an acceptable overhead ni terms of seconds delay of application startup? Once you have answered that, run the following experiment: 1. For one database, generate the CFCs for the tables using a code generator (such as the plugin to CF Builder). 2. Add the database to the orm configuration in application.cfc 3. Add the CFC folder to the orm configuration in application.cfc. 4. Measure startup time. 5. Repeat step 1-3 for 9 more databases. 6. Measure startup time. 7. Extrapolate. With thousands of datasources even a small number of tables per datasource means on startup CF has to compile and process tens or even hundreds of thousands of CFCs to build all the right relations and objects. I expect that to be prohibitively expensive on startup time (question 2) long before you have a problem with RAM (question1), even if you use HBMXML files to store the relations. Since my experience does not go further then close to 200 tables in one application I have no idea what the result will be and am very interested in what your measurements will tell. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347725 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: WSDL 404 Error
Thanks all...it seems to have magically resolved itself after some server maintenance this weekend. I appeciate the help! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347726 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ORM overhead
Thanks for your reply Jochem. This is some excellent advice and we will def look into it. I wonder if I am over complicating this issue. Basically our application is a Software as a Service (SaaS) and each client that accesses it really only needs to connect to their own data source due to the type of data our application processes... and regulations in the industry say their data must be separated. So, the actual objects in the database may vary but only *very* slightly. The only real issue we have here is not that the objects will vary but how do I get ORM to point to purely a different data source name - but use the same set of objects. -Original Message- From: Jochem van Dieten [mailto:joch...@gmail.com] Sent: 26 September 2011 20:22 To: cf-talk Subject: Re: ORM overhead On Mon, Sep 26, 2011 at 8:07 PM, Richard (J7 Group) wrote: Performance overhead, especially in an application that could be linked to thousands of data sources? I think an application with thousands of datasources is so far out of the experience of other users that we will have no way of answering your question. I do have a few questions that may be helpful in finding the right questions and answers yourself. 1. What would you consider an acceptable overhead in terms of GB of RAM? 2. What would you consider an acceptable overhead ni terms of seconds delay of application startup? Once you have answered that, run the following experiment: 1. For one database, generate the CFCs for the tables using a code generator (such as the plugin to CF Builder). 2. Add the database to the orm configuration in application.cfc 3. Add the CFC folder to the orm configuration in application.cfc. 4. Measure startup time. 5. Repeat step 1-3 for 9 more databases. 6. Measure startup time. 7. Extrapolate. With thousands of datasources even a small number of tables per datasource means on startup CF has to compile and process tens or even hundreds of thousands of CFCs to build all the right relations and objects. I expect that to be prohibitively expensive on startup time (question 2) long before you have a problem with RAM (question1), even if you use HBMXML files to store the relations. Since my experience does not go further then close to 200 tables in one application I have no idea what the result will be and am very interested in what your measurements will tell. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347727 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM overhead
It is a pretty easy test. make 2 pages. 1 that uses cfquery 1 that uses ORM get them both to do the same heavy database work compare the execution times. ORM is clearly going to have some overhead by its very nature, so you have to measure whether the convenience and portability outweighs the performance hit. ORM has multiple uses, it is a RAD framework the same as CFML allowing you to do complex tasks easily without underlying knowledge of the database structure, it also creates portability so that the same code will work on multiple database platforms. For many ORM removes too much control as you are limited to the confines of what ORM can do so you may find yourself unable to do certain complex or dynamic queries without dropping back into regular SQL. There is also the fact that you are moving all your data abstraction into the application layer, the stored proc advocates who prefer to keep data abstraction within the database would say this is a bad thing. It is really a case of weighing up the pros and cons of each method and choosing which best suits you and your application. It you are concerned with squeezing every cycle of speed and performance out of your app, then ORM is probably not for you. But overall I would say that most developers use CFML because of its RAD speed and convenience, so ORM is really just an extension of that so the performance hit is acceptable. On Mon, Sep 26, 2011 at 8:50 PM, Richard (J7 Group) rich...@j7is.co.uk wrote: Thanks for your reply Jochem. This is some excellent advice and we will def look into it. I wonder if I am over complicating this issue. Basically our application is a Software as a Service (SaaS) and each client that accesses it really only needs to connect to their own data source due to the type of data our application processes... and regulations in the industry say their data must be separated. So, the actual objects in the database may vary but only *very* slightly. The only real issue we have here is not that the objects will vary but how do I get ORM to point to purely a different data source name - but use the same set of objects. -Original Message- From: Jochem van Dieten [mailto:joch...@gmail.com] Sent: 26 September 2011 20:22 To: cf-talk Subject: Re: ORM overhead On Mon, Sep 26, 2011 at 8:07 PM, Richard (J7 Group) wrote: Performance overhead, especially in an application that could be linked to thousands of data sources? I think an application with thousands of datasources is so far out of the experience of other users that we will have no way of answering your question. I do have a few questions that may be helpful in finding the right questions and answers yourself. 1. What would you consider an acceptable overhead in terms of GB of RAM? 2. What would you consider an acceptable overhead ni terms of seconds delay of application startup? Once you have answered that, run the following experiment: 1. For one database, generate the CFCs for the tables using a code generator (such as the plugin to CF Builder). 2. Add the database to the orm configuration in application.cfc 3. Add the CFC folder to the orm configuration in application.cfc. 4. Measure startup time. 5. Repeat step 1-3 for 9 more databases. 6. Measure startup time. 7. Extrapolate. With thousands of datasources even a small number of tables per datasource means on startup CF has to compile and process tens or even hundreds of thousands of CFCs to build all the right relations and objects. I expect that to be prohibitively expensive on startup time (question 2) long before you have a problem with RAM (question1), even if you use HBMXML files to store the relations. Since my experience does not go further then close to 200 tables in one application I have no idea what the result will be and am very interested in what your measurements will tell. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347728 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Developer Edition License Exception and Windows 7
This just started happening on Friday, so not sure if it's Windows 7-specific or not (I've been on 7 for a couple of months), but now it's getting annoying (4-5 times today already). I'm running across a problem with the Dev edition saying there's a license restriction exception. No one else has been hitting my machine, but it seems like Windows is hitting CF with 3 different IP addresses. The exception lists the one it's trying to use (an IPv4 address) and the two that it's already tied to (two different IPv6 addresses). One of the v6 and the v4 address are tied to my wireless connection, and the other v6 is tied to my ethernet connection. I suppose I could disconnect the wireless (I've never figured out why it seems like Windows gives wireless precedence over a hard-wired connection), but I was wondering if there was something else I could do. I'm getting really tired of restarting CF (my computer isn't exactly over-powered and the app can be slow to start up, so it kills 10-15 minutes of productivity every time). So, short of disabling the wireless connection, is there something else I could do? Scott -- - Scott Brady http://www.scottbrady.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347729 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM overhead
Generally, the performance is perfectly acceptable. In your specific case though, I'm not sure, because a situation where you have thousands of separate databases for the same application is definitely not common. On Mon, Sep 26, 2011 at 2:07 PM, Richard (J7 Group) rich...@j7is.co.ukwrote: Performance overhead, especially in an application that could be linked to thousands of data sources? -Original Message- From: Brian Kotek [mailto:brian...@gmail.com] Sent: 26 September 2011 18:49 To: cf-talk Subject: Re: ORM overhead You're not going to get anything other than anecdotal opinions, but everyone I know switched to ORM as soon as it was available. As far as overhead, I'm not sure what you mean. Coding overhead? Performance overhead? On Mon, Sep 26, 2011 at 1:21 PM, Richard White rich...@j7is.co.uk wrote: to rephrase this question slightly, has there been much take up on the CF9 ORM? i read somewhere it was one of the most welcome enhancements in CF9, but then i also read somewhere else its an overhead too far for many developers Hi, we are looking to restructure our system using ORM but are wondering: firstly, about the general overhead of the CF9 ORM? secondly, the overhead in terms of the following scenario: Our application is generalized and customizes itself and its database around users requirements. The users login to one central application but each client has their own database. So after logging in the system knows which database to use. Therefore, it appears we will have to configure ORM to setup an instance for each individual client. This could obviously spiral into the thousands. Would appreciate your feedback thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347730 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM overhead
There is also the first and second-level cache to consider, as these affect performance tremendously, and aren't reflected in a very basic test like this. On Mon, Sep 26, 2011 at 4:35 PM, Russ Michaels r...@michaels.me.uk wrote: It is a pretty easy test. make 2 pages. 1 that uses cfquery 1 that uses ORM get them both to do the same heavy database work compare the execution times. ORM is clearly going to have some overhead by its very nature, so you have to measure whether the convenience and portability outweighs the performance hit. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347731 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Developer Edition License Exception and Windows 7
just disable IPv6 if your not using it. Also it should work on 127.0.0.1 regardless, so check your hosts file and make sure localhost and all your local dev domains map to 127.0.0.1 On Mon, Sep 26, 2011 at 9:47 PM, Scott Brady dsbr...@gmail.com wrote: This just started happening on Friday, so not sure if it's Windows 7-specific or not (I've been on 7 for a couple of months), but now it's getting annoying (4-5 times today already). I'm running across a problem with the Dev edition saying there's a license restriction exception. No one else has been hitting my machine, but it seems like Windows is hitting CF with 3 different IP addresses. The exception lists the one it's trying to use (an IPv4 address) and the two that it's already tied to (two different IPv6 addresses). One of the v6 and the v4 address are tied to my wireless connection, and the other v6 is tied to my ethernet connection. I suppose I could disconnect the wireless (I've never figured out why it seems like Windows gives wireless precedence over a hard-wired connection), but I was wondering if there was something else I could do. I'm getting really tired of restarting CF (my computer isn't exactly over-powered and the app can be slow to start up, so it kills 10-15 minutes of productivity every time). So, short of disabling the wireless connection, is there something else I could do? Scott -- - Scott Brady http://www.scottbrady.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347732 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfquickdocs.com down?
Through some digging I was able to connect it to Jacob Munson, who I believe is on this list, or at least was at one time. Jake you out there?? We need CFQuickDocs! -- Josh On Mon, Sep 26, 2011 at 11:36 AM, Kumar Shah shahku...@gmail.com wrote: http://cfquickdocs.com/ seems to be down (since yesterday) I believe. Anybody know who maintained this/can reach out to them? Has proved to be really useful for looking things up. Thanks -- Kumar Shah http://www.coldfusion-ria.com/Blog/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347733 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfquickdocs.com down?
If you guys ever get hold of him, I'd be happy to act as a mirror. It would be nice to have a few of those out there... =] On Mon, Sep 26, 2011 at 3:03 PM, Josh Nathanson joshnathan...@gmail.comwrote: Through some digging I was able to connect it to Jacob Munson, who I believe is on this list, or at least was at one time. Jake you out there?? We need CFQuickDocs! -- Josh On Mon, Sep 26, 2011 at 11:36 AM, Kumar Shah shahku...@gmail.com wrote: http://cfquickdocs.com/ seems to be down (since yesterday) I believe. Anybody know who maintained this/can reach out to them? Has proved to be really useful for looking things up. Thanks -- Kumar Shah http://www.coldfusion-ria.com/Blog/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347734 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
