cant access cf administrator
HI I have just installed CF9 on a Solaris 10 box with weblogic 11g, when i try to log into cf administrator, I get a 500 error, cf itself is running as I can pull the log in pages for all my apps, of course when actually log in i get an error, as expected, because I have not configured anything. anyone have an idea what could be causeing the 500 error? tia jb ~| 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:338320 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cant access cf administrator
I know on windows server you have to set up a virtual directory to C:\inetpub\wwwroot\CFIDE called CFIDE in order for the administrator to be viewed. Paul -Original Message- From: Jay Birdsell [mailto:john_birds...@hotmail.com] Sent: Tuesday, October 19, 2010 11:33 AM To: cf-talk Subject: cant access cf administrator HI I have just installed CF9 on a Solaris 10 box with weblogic 11g, when i try to log into cf administrator, I get a 500 error, cf itself is running as I can pull the log in pages for all my apps, of course when actually log in i get an error, as expected, because I have not configured anything. anyone have an idea what could be causeing the 500 error? tia jb ~| 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:338321 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cant access cf administrator
Have you tried the wsconfig tool? On Tue, Oct 19, 2010 at 11:32 AM, Jay Birdsell john_birds...@hotmail.com wrote: HI I have just installed CF9 on a Solaris 10 box with weblogic 11g, when i try to log into cf administrator, I get a 500 error, cf itself is running as I can pull the log in pages for all my apps, of course when actually log in i get an error, as expected, because I have not configured anything. anyone have an idea what could be causeing the 500 error? tia jb ~| 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:338322 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ORM relationship using EntityLoad issues
Hi, quick question, if anyone can help. below you can see a entity for Campaign model. I want to get all campaign that have a company id of x (1 to many relationship) so i tried this returnobj = EntityLoad(Campaign,{company='1'},#sortColumn# #sort#); however this gives me the following error... You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members. how can i get all the campaign that have a company of x from my realtionship?? Model component output=false persistent=true { property name=camp_id type=numeric ormtype=int fieldtype=id generator=identity sqltype=int; property name=camp_description column=camp_description type=string ormtype=string; /* relationships*/ property name=company fieldtype=many-to-one fkcolumn=com_id cfc=company; ~| 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:338323 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM relationship using EntityLoad issues
Syntax Looks valid to me, perhaps it is just tempremental about the quotes. try returnobj = EntityLoad(Campaign,{company=1},#sortColumn# #sort#); are you sure sortorder and sort are simple variables and not complex variables ? Russ On Tue, Oct 19, 2010 at 6:50 PM, Glyn Jackson glyn.jack...@newebia.co.ukwrote: Hi, quick question, if anyone can help. below you can see a entity for Campaign model. I want to get all campaign that have a company id of x (1 to many relationship) so i tried this returnobj = EntityLoad(Campaign,{company='1'},#sortColumn# #sort#); however this gives me the following error... You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members. how can i get all the campaign that have a company of x from my realtionship?? Model component output=false persistent=true { property name=camp_id type=numeric ormtype=int fieldtype=id generator=identity sqltype=int; property name=camp_description column=camp_description type=string ormtype=string; /* relationships*/ property name=company fieldtype=many-to-one fkcolumn=com_id cfc=company; ~| 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:338324 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Totaling items in a recordet
Hey all. I am pulling prices from a database and want to total them. Is there a function like #total(query.column)# ? Kind Regards, Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca ~| 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:338325 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
totaling items in a recordset
Hey all. I am pulling prices from a database and want to total them. Is there a function like #total(query.column)# ? Kind Regards, Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca ~| 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:338326 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: totaling items in a recordset
SUM() On Tue, Oct 19, 2010 at 2:18 PM, Rick Sanders c...@webenergy.ca wrote: Hey all. I am pulling prices from a database and want to total them. Is there a function like #total(query.column)# ? Kind Regards, Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca ~| 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:338327 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Totaling items in a recordet
I do not believe there is, you can get a total with SQL from the DB, but assuming you also need each individual record that's won't work perfectly. So since there is no built in function that I know to do that, you might want to easily create your own totaling function. If you need help, let me know. Regards, David McGraw http://www.oyova.com Jacksonville, FL - Web Design and Development On Tue, Oct 19, 2010 at 3:16 PM, Rick Sanders r...@webenergy.ca wrote: Hey all. I am pulling prices from a database and want to total them. Is there a function like #total(query.column)# ? Kind Regards, Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca ~| 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:338328 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: totaling items in a recordset
Actually... the best way would be to use a query of queries... cfquery name=priceTotal dbtype=querySELECT SUM(prices) as result FROM query/cfquery cfoutput#priceTotal.result#/cfoutput Again this is all assuming you don't want just the total and still need the individual items from the DB. Regards, David McGraw Oyova Software, LLC http://www.oyova.com On Tue, Oct 19, 2010 at 3:18 PM, Rick Sanders c...@webenergy.ca wrote: Hey all. I am pulling prices from a database and want to total them. Is there a function like #total(query.column)# ? Kind Regards, Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca ~| 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:338329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Totaling items in a recordet
The best way would be to sum() it in the query itself. Failing that you can get the list of values, set it to an array, then sum it. #arraysum(listtoarray(valuelist(query.column)))# On Tue, Oct 19, 2010 at 3:16 PM, Rick Sanders r...@webenergy.ca wrote: Hey all. I am pulling prices from a database and want to total them. Is there a function like #total(query.column)# ? Kind Regards, Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca ~| 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:338330 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: totaling items in a recordset
Thanks! I'm used to another programming language where the db query is actually stored in a temporary array, then I can easily total the array with a built-in function. The example you gave is helpful and I've used it before when totaling something. This works for my current application! Thanks, Rick -Original Message- From: David McGraw [mailto:david.mcg...@gmail.com] Sent: Tuesday, October 19, 2010 4:24 PM To: cf-talk Subject: Re: totaling items in a recordset Actually... the best way would be to use a query of queries... cfquery name=priceTotal dbtype=querySELECT SUM(prices) as result FROM query/cfquery cfoutput#priceTotal.result#/cfoutput Again this is all assuming you don't want just the total and still need the individual items from the DB. Regards, David McGraw Oyova Software, LLC http://www.oyova.com On Tue, Oct 19, 2010 at 3:18 PM, Rick Sanders c...@webenergy.ca wrote: Hey all. I am pulling prices from a database and want to total them. Is there a function like #total(query.column)# ? Kind Regards, Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca ~| 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:338331 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Totaling items in a recordet
This is something along the lines of what I was looking for. Now, is there a way to display the full array and have the totaled column as well? Kind regards, Rick -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Tuesday, October 19, 2010 4:26 PM To: cf-talk Subject: Re: Totaling items in a recordet The best way would be to sum() it in the query itself. Failing that you can get the list of values, set it to an array, then sum it. #arraysum(listtoarray(valuelist(query.column)))# On Tue, Oct 19, 2010 at 3:16 PM, Rick Sanders r...@webenergy.ca wrote: Hey all. I am pulling prices from a database and want to total them. Is there a function like #total(query.column)# ? Kind Regards, Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca ~| 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:338332 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: totaling items in a recordset
I'd have to respectfully disagree. I think you'll find the way I proposed in the other branch of this question is about 5 times faster than using query of query. QoQ is generally a poor choice. Here's a test: cfset qry_test = QueryNew(intValue) cfloop from=1 to=100 index=x cfset QueryAddRow(qry_test) cfset QuerySetCell(qry_test,'intValue',randRange(1,1000)) /cfloop cfoutput cfset start = getTickCount() cfloop from=1 to=5000 index=x cfset temp = arraysum(listtoarray(valuelist(qry_test.intValue))) / /cfloop ArraySum: #getTickCount()-start# br /br / cfset start = getTickCount() cfloop from=1 to=5000 index=x cfquery name=priceTotal dbtype=query SELECT SUM(intValue) as result FROM qry_test /cfquery /cfloop QoQ: #getTickCount()-start# /cfoutput On Tue, Oct 19, 2010 at 3:23 PM, David McGraw david.mcg...@gmail.comwrote: Actually... the best way would be to use a query of queries... cfquery name=priceTotal dbtype=querySELECT SUM(prices) as result FROM query/cfquery cfoutput#priceTotal.result#/cfoutput Again this is all assuming you don't want just the total and still need the individual items from the DB. Regards, David McGraw Oyova Software, LLC http://www.oyova.com On Tue, Oct 19, 2010 at 3:18 PM, Rick Sanders c...@webenergy.ca wrote: Hey all. I am pulling prices from a database and want to total them. Is there a function like #total(query.column)# ? Kind Regards, Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca ~| 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:338333 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Totaling items in a recordet
is there a way to display the full array cfset valueArray = listtoarray(valuelist(query.column)) / cfdump var=#valueArray# / and have the totaled column as well? cfset valueSum = arraysum(valueArray) / cfdump var=#valueSum# ~| 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:338334 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Totaling items in a recordet
Yeah, you need ColdFusion Server version 7+ and then you need to write CF code to do it... ;) Regards, David McGraw http://www.oyova.com On Tue, Oct 19, 2010 at 3:33 PM, Rick Sanders c...@webenergy.ca wrote: This is something along the lines of what I was looking for. Now, is there a way to display the full array and have the totaled column as well? Kind regards, Rick -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Tuesday, October 19, 2010 4:26 PM To: cf-talk Subject: Re: Totaling items in a recordet The best way would be to sum() it in the query itself. Failing that you can get the list of values, set it to an array, then sum it. #arraysum(listtoarray(valuelist(query.column)))# On Tue, Oct 19, 2010 at 3:16 PM, Rick Sanders r...@webenergy.ca wrote: Hey all. I am pulling prices from a database and want to total them. Is there a function like #total(query.column)# ? Kind Regards, Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca ~| 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:338335 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: totaling items in a recordset
Yeah that's fine, yours works too, perhaps faster, but each way should not be noticeable unless your talking larger record sets, and then you should scrap everything and let the DB do it. Considering every time I need to get a total I typically need to loop around and display the items anyways, I usually just create a variable and total them up while I am looping around to display. Regards, David McGraw Oyova Software, LLC http://www.oyova.com On Tue, Oct 19, 2010 at 3:34 PM, Michael Grant mgr...@modus.bz wrote: I'd have to respectfully disagree. I think you'll find the way I proposed in the other branch of this question is about 5 times faster than using query of query. QoQ is generally a poor choice. Here's a test: cfset qry_test = QueryNew(intValue) cfloop from=1 to=100 index=x cfset QueryAddRow(qry_test) cfset QuerySetCell(qry_test,'intValue',randRange(1,1000)) /cfloop cfoutput cfset start = getTickCount() cfloop from=1 to=5000 index=x cfset temp = arraysum(listtoarray(valuelist(qry_test.intValue))) / /cfloop ArraySum: #getTickCount()-start# br /br / cfset start = getTickCount() cfloop from=1 to=5000 index=x cfquery name=priceTotal dbtype=query SELECT SUM(intValue) as result FROM qry_test /cfquery /cfloop QoQ: #getTickCount()-start# /cfoutput On Tue, Oct 19, 2010 at 3:23 PM, David McGraw david.mcg...@gmail.com wrote: Actually... the best way would be to use a query of queries... cfquery name=priceTotal dbtype=querySELECT SUM(prices) as result FROM query/cfquery cfoutput#priceTotal.result#/cfoutput Again this is all assuming you don't want just the total and still need the individual items from the DB. Regards, David McGraw Oyova Software, LLC http://www.oyova.com On Tue, Oct 19, 2010 at 3:18 PM, Rick Sanders c...@webenergy.ca wrote: Hey all. I am pulling prices from a database and want to total them. Is there a function like #total(query.column)# ? Kind Regards, Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca ~| 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:338336 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM relationship using EntityLoad issues
This error occurs when you use a function on a string that is looking for a structure. Dump your variables and see which one has a string value instead of a key value pairs. On Tue, Oct 19, 2010 at 10:50 AM, Glyn Jackson glyn.jack...@newebia.co.uk wrote: Hi, quick question, if anyone can help. below you can see a entity for Campaign model. I want to get all campaign that have a company id of x (1 to many relationship) so i tried this returnobj = EntityLoad(Campaign,{company='1'},#sortColumn# #sort#); however this gives me the following error... You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members. ~| 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:338337 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF (8.0.0) performance vs PHP (5)
This can lead to lots of controvertial posts. I did some performance testing long back between HTML, CF, PHP, ASP.NET and Java. The benchmark was a static HTML page and everything was measured against the performance of HTML. Criteria used in the benchmarking was to generate a datetime stamp, results from 5 queries to DB and a 50K page size The performance results matrix is given below: HTML 100% (static DataTime stamp and no queries to DB) PHP90% of HTML ASP.NET80% of HTML JAVA 75% of HTML CF 40% of HTML [but I can say that CF is slowly improving] These are my findings and may change from time to time. ~| 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:338338 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF (8.0.0) performance vs PHP (5)
This means nothing to me without proper test procedures and full disclosure of the source code and test data for each test and the hardware specifications that were used along with databases and network specs. There's a large number of variables involved and I can attest to the fact that getting even one wrong can adversely affect a test environment. Externals such as networks, file systems, operating systems, performance tuning, the java layer, databases and more can have very large affects on the results for each of the languages you tested. Wil Genovese Sr. Web Application Developer/ Systems Administrator wilg...@trunkful.com www.trunkful.com On Oct 19, 2010, at 3:29 PM, Ketan Jetty wrote: This can lead to lots of controvertial posts. I did some performance testing long back between HTML, CF, PHP, ASP.NET and Java. The benchmark was a static HTML page and everything was measured against the performance of HTML. Criteria used in the benchmarking was to generate a datetime stamp, results from 5 queries to DB and a 50K page size The performance results matrix is given below: HTML 100% (static DataTime stamp and no queries to DB) PHP90% of HTML ASP.NET80% of HTML JAVA 75% of HTML CF 40% of HTML [but I can say that CF is slowly improving] These are my findings and may change from time to time. ~| 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:338339 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF (8.0.0) performance vs PHP (5)
Although I tend to agree with you Will, as a 12 year vet developing CF and for the past 3 years mixing in some PHP, PHP is just simply faster on an average setup every day need basis. I still use CF, and love it, but it's not as fast as PHP. Regards, David McGraw Oyova Software, LLC http://www.oyova.com On Tue, Oct 19, 2010 at 4:46 PM, Wil Genovese jugg...@trunkful.com wrote: This means nothing to me without proper test procedures and full disclosure of the source code and test data for each test and the hardware specifications that were used along with databases and network specs. There's a large number of variables involved and I can attest to the fact that getting even one wrong can adversely affect a test environment. Externals such as networks, file systems, operating systems, performance tuning, the java layer, databases and more can have very large affects on the results for each of the languages you tested. Wil Genovese Sr. Web Application Developer/ Systems Administrator wilg...@trunkful.com www.trunkful.com On Oct 19, 2010, at 3:29 PM, Ketan Jetty wrote: This can lead to lots of controvertial posts. I did some performance testing long back between HTML, CF, PHP, ASP.NET and Java. The benchmark was a static HTML page and everything was measured against the performance of HTML. Criteria used in the benchmarking was to generate a datetime stamp, results from 5 queries to DB and a 50K page size The performance results matrix is given below: HTML 100% (static DataTime stamp and no queries to DB) PHP90% of HTML ASP.NET80% of HTML JAVA 75% of HTML CF 40% of HTML [but I can say that CF is slowly improving] These are my findings and may change from time to time. ~| 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:338340 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF (8.0.0) performance vs PHP (5)
Respectfully Ketanyour tests have nothing to do with the string concatenation performance issue that was the crux of this thread ;-) Cheers On Tue, 2010-10-19 at 16:29 -0400, Ketan Jetty wrote: This can lead to lots of controvertial posts. I did some performance testing long back between HTML, CF, PHP, ASP.NET and Java. The benchmark was a static HTML page and everything was measured against the performance of HTML. Criteria used in the benchmarking was to generate a datetime stamp, results from 5 queries to DB and a 50K page size The performance results matrix is given below: HTML 100% (static DataTime stamp and no queries to DB) PHP90% of HTML ASP.NET80% of HTML JAVA 75% of HTML CF 40% of HTML [but I can say that CF is slowly improving] These are my findings and may change from time to time. ~| 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:338341 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF (8.0.0) performance vs PHP (5)
For giggles, I just tried this on my box and got: HTML 33 milliseconds (static DataTime stamp and no queries to DB) CF 2910 milliseconds (cleared template cache and newly restarted CF service) CF 707 milliseconds (after above run) And here's the code I tested. NOTE: only needed two cfdumps to get to 50K page size: cfset count = 10 cfoutput#Now()#/cfoutput cfquery name=Q_GetData datasource=thedatasource select top #count# * from table1 /cfquery cfdump var=#Q_GetData# cfquery name=Q_GetData datasource=thedatasource select top #count# * from table2 /cfquery cfdump var=#Q_GetData# cfquery name=Q_GetData datasource=thedatasource select top #count# * from table3 /cfquery cfquery name=Q_GetData datasource=thedatasource select top #count# * from table4 /cfquery cfquery name=Q_GetData datasource=thedatasource select top #count# * from table5 /cfquery On Tue, Oct 19, 2010 at 3:29 PM, Ketan Jetty kje...@yahoo.com wrote: This can lead to lots of controvertial posts. I did some performance testing long back between HTML, CF, PHP, ASP.NET and Java. The benchmark was a static HTML page and everything was measured against the performance of HTML. Criteria used in the benchmarking was to generate a datetime stamp, results from 5 queries to DB and a 50K page size The performance results matrix is given below: HTML 100% (static DataTime stamp and no queries to DB) PHP90% of HTML ASP.NET80% of HTML JAVA 75% of HTML CF 40% of HTML [but I can say that CF is slowly improving] These are my findings and may change from time to time. ~| 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:338342 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM relationship using EntityLoad issues
Hi Russ, sort ect are def just simple vars. I have hard coding the sortcolum and sort vars and got the same error. it looks right to me also, company is not a string tho should it be something like this EntityLoad(Campaign,{company.getCom_id(1)},#sortColumn# #sort#); however i know that won't work. if i dump out Campaign this is what I see... camp_id 1 camp_name 1 camp_description 1 camp_startDate{ts '2010-10-10 00:00:00'} camp_endDate {ts '2010-10-17 00:00:00'} camp_active YES company [cfc2] component model.company PROPERTIES com_id 1 com_name Glyn Inc Syntax Looks valid to me, perhaps it is just tempremental about the quotes. try returnobj = EntityLoad(Campaign,{company=1},#sortColumn# #sort#); are you sure sortorder and sort are simple variables and not complex variables ? Russ On Tue, Oct 19, 2010 at 6:50 PM, Glyn Jackson glyn.jack...@newebia.co.ukwrote: ~| 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:338343 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF (8.0.0) performance vs PHP (5)
Again this means nothing. I've worked on very high load high performance ColdFusion based web applications that literally served up 2.5 to 3 million user requests per day and each request took less than 350ms on average. It comes down to performance tuning at all layers. The out-of-the-box install of ColdFusion is not tuned for performance. It's tuned to just run and let you get started. Wil Genovese Sr. Web Application Developer/ Systems Administrator wilg...@trunkful.com www.trunkful.com On Oct 19, 2010, at 4:01 PM, John M Bliss wrote: For giggles, I just tried this on my box and got: HTML 33 milliseconds (static DataTime stamp and no queries to DB) CF 2910 milliseconds (cleared template cache and newly restarted CF service) CF 707 milliseconds (after above run) And here's the code I tested. NOTE: only needed two cfdumps to get to 50K page size: cfset count = 10 cfoutput#Now()#/cfoutput cfquery name=Q_GetData datasource=thedatasource select top #count# * from table1 /cfquery cfdump var=#Q_GetData# cfquery name=Q_GetData datasource=thedatasource select top #count# * from table2 /cfquery cfdump var=#Q_GetData# cfquery name=Q_GetData datasource=thedatasource select top #count# * from table3 /cfquery cfquery name=Q_GetData datasource=thedatasource select top #count# * from table4 /cfquery cfquery name=Q_GetData datasource=thedatasource select top #count# * from table5 /cfquery On Tue, Oct 19, 2010 at 3:29 PM, Ketan Jetty kje...@yahoo.com wrote: This can lead to lots of controvertial posts. I did some performance testing long back between HTML, CF, PHP, ASP.NET and Java. The benchmark was a static HTML page and everything was measured against the performance of HTML. Criteria used in the benchmarking was to generate a datetime stamp, results from 5 queries to DB and a 50K page size The performance results matrix is given below: HTML 100% (static DataTime stamp and no queries to DB) PHP90% of HTML ASP.NET80% of HTML JAVA 75% of HTML CF 40% of HTML [but I can say that CF is slowly improving] These are my findings and may change from time to time. ~| 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:338344 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM relationship using EntityLoad issues
Company is a structure for sure (struct posted above in reply to Russ) I asumed something like this would work, but no joy i.e. company.getcom_id(1) This error occurs when you use a function on a string that is looking for a structure. Dump your variables and see which one has a string value instead of a key value pairs. On Tue, Oct 19, 2010 at 10:50 AM, Glyn Jackson glyn.jack...@newebia.co.uk wrote: Hi, quick question, if anyone can help. below you can see a entity for Campaign model. I want to get all campaign that have a company id of x (1 to many relationship) so i tried this returnobj = EntityLoad(Campaign,{company='1'},#sortColumn# #sort#); however this gives me the following error... You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members. ~| 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:338345 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM relationship using EntityLoad issues
Not clear what variable you are trying to set in campaign but if company is a structure, you possibly could do this: EntityLoad('Campaign',{company_id = company.getCom_id(1)},#sortColumn# #sort#); On Tue, Oct 19, 2010 at 1:58 PM, Glyn Jackson glyn.jack...@newebia.co.uk wrote: Hi Russ, sort ect are def just simple vars. I have hard coding the sortcolum and sort vars and got the same error. it looks right to me also, company is not a string tho should it be something like this EntityLoad(Campaign,{company.getCom_id(1)},#sortColumn# #sort#); however i know that won't work. if i dump out Campaign this is what I see... camp_id 1 camp_name 1 camp_description 1 camp_startDate {ts '2010-10-10 00:00:00'} camp_endDate {ts '2010-10-17 00:00:00'} camp_active YES company [cfc2] component model.company PROPERTIES com_id 1 com_name Glyn Inc Syntax Looks valid to me, perhaps it is just tempremental about the quotes. try returnobj = EntityLoad(Campaign,{company=1},#sortColumn# #sort#); are you sure sortorder and sort are simple variables and not complex variables ? Russ On Tue, Oct 19, 2010 at 6:50 PM, Glyn Jackson glyn.jack...@newebia.co.ukwrote: ~| 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:338346 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Totaling items in a recordet
a query column IS an array - there is no need to convert column to list, then back to array. all you need to get a sum of column values is use array notation: #arraysum(queryname['columnname'])# Azadi On 20/10/2010 03:35 , Michael Grant wrote: is there a way to display the full array cfset valueArray = listtoarray(valuelist(query.column)) / cfdump var=#valueArray# / and have the totaled column as well? cfset valueSum = arraysum(valueArray) / cfdump var=#valueSum# ~| 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:338347 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Totaling items in a recordet
Has this always been so in CF? On Tue, Oct 19, 2010 at 7:40 PM, Azadi Saryev azadi.sar...@gmail.comwrote: a query column IS an array - there is no need to convert column to list, then back to array. all you need to get a sum of column values is use array notation: #arraysum(queryname['columnname'])# Azadi On 20/10/2010 03:35 , Michael Grant wrote: is there a way to display the full array cfset valueArray = listtoarray(valuelist(query.column)) / cfdump var=#valueArray# / and have the totaled column as well? cfset valueSum = arraysum(valueArray) / cfdump var=#valueSum# ~| 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:338348 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Totaling items in a recordet
don't quote me on this, but i think probably since cf was rewritten in java... well, at least since 2006, it seems, whichever cf version that was (7?): http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:46955#247646 http://www.bennadel.com/blog/167-Calling-Array-Functions-on-ColdFusion-Query-Columns.htm Azadi On 20/10/2010 07:44 , Michael Grant wrote: Has this always been so in CF? On Tue, Oct 19, 2010 at 7:40 PM, Azadi Saryevazadi.sar...@gmail.comwrote: a query column IS an array - there is no need to convert column to list, then back to array. all you need to get a sum of column values is use array notation: #arraysum(queryname['columnname'])# Azadi On 20/10/2010 03:35 , Michael Grant wrote: is there a way to display the full array cfset valueArray = listtoarray(valuelist(query.column)) / cfdump var=#valueArray# / and have the totaled column as well? cfset valueSum = arraysum(valueArray) / cfdump var=#valueSum# ~| 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:338349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Totaling items in a recordet
Well that's awesome. I've used it since it had a lightening bolt and never knew this. I can't say this is going to change the way I develop much since I generally get the db server to my db work, but this is really cool. On Tue, Oct 19, 2010 at 8:56 PM, Azadi Saryev azadi.sar...@gmail.comwrote: don't quote me on this, but i think probably since cf was rewritten in java... well, at least since 2006, it seems, whichever cf version that was (7?): http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:46955#247646 http://www.bennadel.com/blog/167-Calling-Array-Functions-on-ColdFusion-Query-Columns.htm Azadi On 20/10/2010 07:44 , Michael Grant wrote: Has this always been so in CF? On Tue, Oct 19, 2010 at 7:40 PM, Azadi Saryevazadi.sar...@gmail.com wrote: a query column IS an array - there is no need to convert column to list, then back to array. all you need to get a sum of column values is use array notation: #arraysum(queryname['columnname'])# Azadi On 20/10/2010 03:35 , Michael Grant wrote: is there a way to display the full array cfset valueArray = listtoarray(valuelist(query.column)) / cfdump var=#valueArray# / and have the totaled column as well? cfset valueSum = arraysum(valueArray) / cfdump var=#valueSum# ~| 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:338350 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm