Unable to update cfGrid
I am trying to work on the sample in livedoces but I am unable to update the database and also I am unable to display the updated contents. Can any one help me with it. I have appended the columns to reduce the content. Grid2.cfm cfquery name=empdata datasource=CompanyInfo SELECT * FROM Employee /cfquery cfform name=GridForm action=handle_grid.cfm cfgrid name=employee_grid height=425 width=300 vspace=10 selectmode=edit query=empdata insert=Yes delete=Yes cfgridcolumn name=Emp_ID header=Emp ID width=50 headeralign=center headerbold=Yes select=No /cfgrid br input type=Submit value=Submit /cfform handle_grid.cfm cfgridupdate grid=Brand_Grid datasource=BankInfo tablename=tblWebSiteContent Click a href=grid2.cfmhere/a to display updated grid. Thanks, Pranathi. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Chrome now higher traffic than IE on some of my sites
On Tuesday 03 Mar 2009, Mike Kear wrote: All I was saying is it's the first time I've seen IE as not the top browser.(one swallow does not a summer make!) I've got one where 'wget' is top :-) -- Tom Chiverton Helping to administratively engineer fourth-generation relationships as part of the IT team of the year, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320092 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Chrome now higher traffic than IE on some of my sites
I've got one where 'wget' is top :-) I really don't put much into browser stats. They are all over the place. Now if the guy that did the fivethirtyeight.com did a meta analysis I would pay it some mind. G! On Wed, Mar 4, 2009 at 8:27 AM, Tom Chiverton tom.chiver...@halliwells.comwrote: On Tuesday 03 Mar 2009, Mike Kear wrote: All I was saying is it's the first time I've seen IE as not the top browser.(one swallow does not a summer make!) -- Tom Chiverton Helping to administratively engineer fourth-generation relationships as part of the IT team of the year, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320093 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: displaying a tree structure
I have data in a table like this: IDParentIDName 1 0 Top 2 1 Level1 3 1 Level2 4 2 Child1 Of Level2 5 2 Child2 Of Level2 6 3 Child1 Of Level2 So the tree would look like this: Top Level1 Child1 Of Level1 Child2 Of Level1 Level2 Child1 Of Level2 Hopefully the tabs in the email will format when I send this so it is easy to read. How do I loop over this data to display the tree dynamically? I have used Loops with queries to get each levels childs, but the way I wrote it I have to have a loop for each level. What if I have unlimited childs? My loops will only display as many childs as I have loops. Maybe there is a better way to structure the data in the first place. Thanks! If you are using SLQ Server 2005 or higher, use can use recursive queries using CTEs. There are several examples out there. The one I use is like the following. WITH TreeCTE(cte_code, cte_name, cte_parent, cte_level, cte_sortCol) AS ( SELECT code, name, parent, 0, CAST(name + ' - ' + CAST(code AS VARCHAR(10)) AS VARBINARY(900)) FROM TreeNodes WHERE parent IS NULL GROUP BY code, name, parent UNION ALL SELECT code, name, parent, cte_level + 1, CAST(cte_sortCol + CAST(name + ' - ' + CAST(code AS VARCHAR(10)) AS VARBINARY(900)) AS VARBINARY(900)) FROM TreeNodes INNER JOIN TreeCTE ON parent = cte_code ) SELECT cte_code AS code, cte_name AS name, cte_level FROM TreeCTE ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320094 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CSV File Upload. best way?
Hi everyone, I have a CSV file I need to take the values out of and update a database with them. Any suggestion or best ways to do this? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320095 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfdocument putting part of the row on the bottom of page 1 and the other on the top of page 2. Please help!
Hello everybody, I'm new to cfdocument. I'm using it to create pdf documents from data returned by a query with ColdFusion8. The problem is that cfdocument is putting part of the data contained in the table row at the bottom of page 1 and the other on the top of page 2. I know that there is a cfdocumentitem tpye pagebreak attribute (cfdocumentitem type = pagebreak/) which I could use but how do I know when to use this given that the data is dynamic. Can anyone help? Regards, John ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320096 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: displaying a tree structure
I found Doug Boude's blog post on Recursive Functions in CF. Great post and explanation of how it works. My head was hurting trying to do it myself, but his explanation was priceless. http://www.dougboude.com/blog/1/2006/06/Recursive-Functions-in-ColdFusion.cfm -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Tuesday, March 03, 2009 8:05 PM To: cf-talk Subject: displaying a tree structure I have data in a table like this: IDParentIDName 1 0 Top 2 1 Level1 3 1 Level2 4 2 Child1 Of Level2 5 2 Child2 Of Level2 6 3 Child1 Of Level2 So the tree would look like this: Top Level1 Child1 Of Level1 Child2 Of Level1 Level2 Child1 Of Level2 Hopefully the tabs in the email will format when I send this so it is easy to read. How do I loop over this data to display the tree dynamically? I have used Loops with queries to get each levels childs, but the way I wrote it I have to have a loop for each level. What if I have unlimited childs? My loops will only display as many childs as I have loops. Maybe there is a better way to structure the data in the first place. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320097 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: displaying a tree structure
Oh... interesting. Would be nice to do it in SQL. I will study this. Thanks Donnie! -Original Message- From: Donnie Carvajal [mailto:donnie.carva...@transformyx.com] Sent: Wednesday, March 04, 2009 9:52 AM To: cf-talk Subject: Re: displaying a tree structure I have data in a table like this: ID ParentIDName 1 0 Top 2 1 Level1 3 1 Level2 4 2 Child1 Of Level2 5 2 Child2 Of Level2 6 3 Child1 Of Level2 So the tree would look like this: Top Level1 Child1 Of Level1 Child2 Of Level1 Level2 Child1 Of Level2 Hopefully the tabs in the email will format when I send this so it is easy to read. How do I loop over this data to display the tree dynamically? I have used Loops with queries to get each levels childs, but the way I wrote it I have to have a loop for each level. What if I have unlimited childs? My loops will only display as many childs as I have loops. Maybe there is a better way to structure the data in the first place. Thanks! If you are using SLQ Server 2005 or higher, use can use recursive queries using CTEs. There are several examples out there. The one I use is like the following. WITH TreeCTE(cte_code, cte_name, cte_parent, cte_level, cte_sortCol) AS ( SELECT code, name, parent, 0, CAST(name + ' - ' + CAST(code AS VARCHAR(10)) AS VARBINARY(900)) FROM TreeNodes WHERE parent IS NULL GROUP BY code, name, parent UNION ALL SELECT code, name, parent, cte_level + 1, CAST(cte_sortCol + CAST(name + ' - ' + CAST(code AS VARCHAR(10)) AS VARBINARY(900)) AS VARBINARY(900)) FROM TreeNodes INNER JOIN TreeCTE ON parent = cte_code ) SELECT cte_code AS code, cte_name AS name, cte_level FROM TreeCTE ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320098 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: order query object
Something to note is that you cannot, of course, queryparam the sortorder column that will be supplied. If the sort order field is passed to your cfc from either get or post data, you may want to do the sorting in a QoQ after the database query to get rid of the sql injection threat. Ie. cfquery name=qfoo datasource=#_dsn# SELECT stuff FROM stuff /cfquery cfquery name=qfoo dbtype=query SELECT * FROM qfoo ORDER BY #arguments.order# /cfquery cfreturn qfoo / Dominic 2009/3/3 Chad Gray cg...@careyweb.com: Ok... and I can set the argument in the cfc to default to a order that is common for the data. Then if I need a different order I will pass it to the CFC. Makes sense. Guess I was getting lazy here at the end of the day. Thanks Charlie! -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: Tuesday, March 03, 2009 4:19 PM To: cf-talk Subject: Re: order query object On Tue, Mar 3, 2009 at 1:10 PM, Chad Gray cg...@careyweb.com wrote: Say I have a CFC that returns a query object. When I go to output the data can I sort the query object on the display page? This way I don't have to have an ORDER BY in the SQL in the CFC. I could do the order by or sort when I go to display the query results instead. why not pass the sort order in as an argument to the CFC method? if you really wanted to, you could do a QoQ on the display page to sort. But I'd think that returning the query in the proper order (the order in which the display page wants to use it) would be preferable. -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320099 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Populate form field based on query run after another form field is set
Hi, You guys prolly do this every day. Say I've got a form with two fields. When a user enters the value in field a, I'd like to query the db and populate field b with the result of the query whose where clause is based on the value set in field A. I could do this after the form is submitted, but that is sooo web 1.0. A link to a tutorial or other suggestions to get me pointed in the right direction is greatly appreciated. TIA Andy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320100 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Populate form field based on query run after another form field is set
Must not recommend jQuery, I must not recommend jQuery, I must not recommend
jQuery, I must not recommend jQuery, I must not recommend jQuery.
Use jQuery! :OD
script type=text/javascript src=PATH TO JQUERY/script
script type=text/javascript
$(function() {
$(button).click(function() {
var firstValue = $(#field1).val();
$.post(the CFM page that returns the value,
{value1: firstValue}, function(data) {
$(#field2).val(data);
});
return false;
});
});
/script
form action=#CGI.SCRIPT_NAME# method=post
input type=text id=field1 /
input type=text id=field2 /
buttonDo something/button
/form
If you want quick and dirty this is about as simple as it gets. The CFM page
you post to on clicking the button needs to return the value you want for
the second field. That's the basic concept, then you can move into returning
JSON and XML instead of raw strings.
I loves me some jQuery :OD
Oh, and that script is untested.
Adrian
-Original Message-
From: Andrew Peterson [mailto:webmas...@mail.ioc.state.il.us]
Sent: 04 March 2009 17:07
To: cf-talk
Subject: Populate form field based on query run after another form
field is set
Hi,
You guys prolly do this every day. Say I've got a form with two fields.
When a user enters the value in field a, I'd like to query the db and
populate field b with the result of the query whose where clause is
based on the value set in field A. I could do this after the form is
submitted, but that is sooo web 1.0. A link to a tutorial or other
suggestions to get me pointed in the right direction is greatly
appreciated. TIA
Andy
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320101
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Populate form field based on query run after another form field is set
Must not recommend jQuery, I must not recommend jQuery, I must not recommend jQuery, I must not recommend jQuery, I must not recommend jQuery. Use jQuery! :OD I KNEW you were going to recommend jQuery! Been following Ray's posts about jQuery as of late, and this is just the thing I needed to dive in. Thanks. -Andy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320102 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: order query object
Dominic makes a good point. To this end, I often find it useful to use my 'sortBy' params as aliases rather than as direct SQL, so something like this: cfargument name=sortBy type=string default=name / cfset var order = / cfswitch expresssion=#arguments.sortBy# cfcase value=id cfset order = personID / /cfcase cfcase value=title cfset order = title, lastName, firstName / /cfcase cfdefaultcase !--- this handles 'name' and any attempts to send in garbage --- cfset order = lastName, firstName / /cfdefaultcase /cfswitch cfquery name=qfoo datasource=#_dsn# SELECT personID, firstName, lastName, title FROM person ORDER BY #order# /cfquery cfreturn qfoo / Note that not only is my query now safe from injection, but I can easily change my sort criteria. Say I call this from multiple places in my code, because I need different user lists in different places. Then, if I need to change from sorting (Last name, First name) sorting to (First name Last name), my sortBy=name remains the same throughout my application, and I only have to change this: cfset order = firstName, lastName / ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320103 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Oracle 11G CLOBs\BLOBs yielding non-standard characters with CF7
Our development environment was just upgraded from Oracle 10G to Oracle 11G (which is not officially supported by ColdFusion, but it's not our decision). We're on ColdFusion 7 Enterprise and we're using the supplied Data Direct drivers. We are getting some unexpected non-standard special characters spread through our output that is pulled from Oracle 11G CLOBs\BLOBs that we were not getting with Oracle 10G. If we run this query: Select value from SYS.NLS_DATABASE_PARAMETERS where PARAMETER = 'NLS_CHARACTERSET' to determine the character sets that are being used by Oracle we find: Oracle 10G - US7ASCII Oracle 11G - UTF8 We are accepting the ColdFusion 7 default use of UTF-8 in our application and we do not override it anywhere in our application. Any ideas why we wouldn't get non-standard characters in our output with Oracle 10G set up to use US7ASCII but we DO get these non-standard characters with Oracle 11G set up to use UTF-8? Thanks! George ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320104 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Apache Configuration Question.
Barney Boisvert wrote: ServerName sets the name for the server (as you'd expect). There can be only one per server. ServerAlias sets up additional non-canonical names for the server that it will pay attention to. There can be any number per server. You have to have a Listen for every ip/port you want to respond to. You'll have to have a NameVirtualHost for every ip/port that you want to serve multiple vhosts from, based on host headers. cheers, barneyb We have tried to implement this and we are not getting the desired results. Our goal is to have 5 virtual hosts on our server located at 134.186.118.85 we would like each virtual host to respond to an ip:port as well as a DSN host header. All the IP:Ports are working and the proper web site is returned but none of the host headers get us anywhere, they just turn up the default apache web server page. I.E. http://134.186.118.85:10050/ and http://apps.cdpr.ca.gov/ should return the same page which the IP:Port correctly does. IP:PORT to DSN Host Header relationship 134.186.118.85:10010 appprod-admin 134.186.118.85:10020 calpip-staging 134.186.118.85:10030 calpip.cdpr.ca.gov [*NOTE*: this domain name is actually in use and point to another server at this time] 134.186.118.85:10040 stagesite 134.186.118.85:10050 apps.cdpr.ca.gov Here are some highlights for our httpd.conf file that I believe are relevant, let me know if any other piece would help. Listen 134.186.118.85:10010 Listen 134.186.118.85:10020 Listen 134.186.118.85:10030 Listen 134.186.118.85:10040 Listen 134.186.118.85:10050 ServerName 134.186.118.85 NameVirtualHost apps.cdpr.ca.gov NameVirtualHost stagestie NameVirtualHost calpip-staging NameVirtualHost appprod-admin VirtualHost 134.186.118.85:10010 ServerName appprod-admin.cdpr.ca.gov ServerAlias appprod-admin VirtualHost 134.186.118.85:10020 ServerName calpip-staging.cdpr.ca.gov ServerAlias calpip-staging VirtualHost 134.186.118.85:10030 ServerName calpip.cdpr.ca.gov ServerAlias alpip.cdpr.ca.gov VirtualHost 134.186.118.85:10040 ServerName stagesite.cdpr.ca.gov ServerAlias stagesite VirtualHost 134.186.118.85:10050 ServerName apps.cdpr.ca.gov ServerAlias apps.cdpr.ca.gov TIA Ian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320105 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CSV File Upload. best way?
You basically have a couple of options (there are obviously many more ways, these are the two approaches that I would take): 1) if it's a small file, just read it into memory and loop through the contents of the file 2) if it's a large file, set up a Microsoft Access database to use an external file (the .csv file) for its data. Performance will be MUCH better than read and parse with CF, and gives you the advantage of working with the data just like you would with any other recordset. I use this for a regular 35,000 record data import and it takes minutes compared to hours using the other approach. Pete On Wed, Mar 4, 2009 at 5:54 AM, Glyn Jackson glyn.jack...@newebia.co.ukwrote: Hi everyone, I have a CSV file I need to take the values out of and update a database with them. Any suggestion or best ways to do this? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320106 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Apache Configuration Question.
Listen 1.2.3.4:80 NameVirtualHost 1.2.3.4:80 VirtualHost 1.2.3.4:80 ServerName my.domain.com /VirtualHost VirtualHost 1.2.3.4:80 ServerName other.domain.com /VirtualHost On Wed, Mar 4, 2009 at 10:57 AM, Ian Skinner h...@ilsweb.com wrote: Barney Boisvert wrote: ServerName sets the name for the server (as you'd expect). There can be only one per server. ServerAlias sets up additional non-canonical names for the server that it will pay attention to. There can be any number per server. You have to have a Listen for every ip/port you want to respond to. You'll have to have a NameVirtualHost for every ip/port that you want to serve multiple vhosts from, based on host headers. cheers, barneyb We have tried to implement this and we are not getting the desired results. Our goal is to have 5 virtual hosts on our server located at 134.186.118.85 we would like each virtual host to respond to an ip:port as well as a DSN host header. All the IP:Ports are working and the proper web site is returned but none of the host headers get us anywhere, they just turn up the default apache web server page. I.E. http://134.186.118.85:10050/ and http://apps.cdpr.ca.gov/ should return the same page which the IP:Port correctly does. IP:PORT to DSN Host Header relationship 134.186.118.85:10010 appprod-admin 134.186.118.85:10020 calpip-staging 134.186.118.85:10030 calpip.cdpr.ca.gov [*NOTE*: this domain name is actually in use and point to another server at this time] 134.186.118.85:10040 stagesite 134.186.118.85:10050 apps.cdpr.ca.gov Here are some highlights for our httpd.conf file that I believe are relevant, let me know if any other piece would help. Listen 134.186.118.85:10010 Listen 134.186.118.85:10020 Listen 134.186.118.85:10030 Listen 134.186.118.85:10040 Listen 134.186.118.85:10050 ServerName 134.186.118.85 NameVirtualHost apps.cdpr.ca.gov NameVirtualHost stagestie NameVirtualHost calpip-staging NameVirtualHost appprod-admin VirtualHost 134.186.118.85:10010 ServerName appprod-admin.cdpr.ca.gov ServerAlias appprod-admin VirtualHost 134.186.118.85:10020 ServerName calpip-staging.cdpr.ca.gov ServerAlias calpip-staging VirtualHost 134.186.118.85:10030 ServerName calpip.cdpr.ca.gov ServerAlias alpip.cdpr.ca.gov VirtualHost 134.186.118.85:10040 ServerName stagesite.cdpr.ca.gov ServerAlias stagesite VirtualHost 134.186.118.85:10050 ServerName apps.cdpr.ca.gov ServerAlias apps.cdpr.ca.gov TIA Ian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320107 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Sessions timing out too soon
In my Application.cfc I have the following code: cfcomponent displayname=Application output=true hint=Handle the application. !--- Set up the application. --- cfset THIS.Name = [app name] / cfset THIS.ApplicationTimeout = CreateTimeSpan(2,0,0,0) / cfset THIS.SessionManagement = true / cfset THIS.SessionTimeout = CreateTimeSpan(0,1,0,0) / cfset THIS.SetClientCookies = false / In the CF Admin the max timeout is 4-hours, and yet session don't last longer than 20-minutes or so. Any ideas what's going on? Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer http://www.aftershockweb.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320108 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Moving a ColdFusion server.
Is there anything about moving a ColdFusion server to a new IP address that affects Jrun and|or ColdFusion. We just moved a new production box from within our firewall to our external DMZ which gives it new IP address. When we did this two or our five ColdFusion instances continued to work correctly. Three others started to fail, returning 500 internal server errors and error messages in the Apache log about bad serverstore and bootstrap something or other. TIA Ian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320109 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Apache Configuration Question.
Barney Boisvert wrote: Listen 1.2.3.4:80 NameVirtualHost 1.2.3.4:80 VirtualHost 1.2.3.4:80 ServerName my.domain.com /VirtualHost VirtualHost 1.2.3.4:80 ServerName other.domain.com /VirtualHost To extrapolate this to our situation where we have different ports, does this make sense? Listen 1.2.3.4: Listen 1.2.3.4: NameVirtualHost 1.2.3.4: NameVirtualHost 1.2.3.4: VirtualHost 1.2.3.4: ServerName my.domain.com /VirtualHost VirtualHost 1.2.3.4: ServerName other.domain.com /VirtualHost ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320110 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Apache Configuration Question.
If you're doing that, you don't need name hosts, because each host is on a different Listen. Go read the docs. Really. It'll make your job a lot easier. On Wed, Mar 4, 2009 at 11:39 AM, Ian Skinner h...@ilsweb.com wrote: Barney Boisvert wrote: Listen 1.2.3.4:80 NameVirtualHost 1.2.3.4:80 VirtualHost 1.2.3.4:80 ServerName my.domain.com /VirtualHost VirtualHost 1.2.3.4:80 ServerName other.domain.com /VirtualHost To extrapolate this to our situation where we have different ports, does this make sense? Listen 1.2.3.4: Listen 1.2.3.4: NameVirtualHost 1.2.3.4: NameVirtualHost 1.2.3.4: VirtualHost 1.2.3.4: ServerName my.domain.com /VirtualHost VirtualHost 1.2.3.4: ServerName other.domain.com /VirtualHost ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320111 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Apache Configuration Question.
Barney Boisvert wrote: If you're doing that, you don't need name hosts, because each host is on a different Listen. Go read the docs. Really. It'll make your job a lot easier. I know I don't need them, I just want them. I'm trying to read as much documentation as I can, but I'm trying to put out so many fires that I haven't gotten to this one yet. Those I was hoping for the quick fix here, until such a time as I can get more in depth into the docs. Ian. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320112 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Ajax cfgrid bind problem
hi there, was there an actual hot fix released for this issue? i'm experiencing the exact same problem. thanks. scott scott.wel...@gmail.com I am trying to use the cfgrid CFC binding feature in CF8 but I am having trouble getting the CFC to populate the Ajax grid. URL: http://site/ Folder: c:\inetpub\wwwroot URL: http://site/projects/ (virtual directory) Folder: c:\projects\ This folder has a cfc called myCFC My bind attribute starts with cfc:projects.myCFC.function The page gets compiled and sent to the browser successfully, meaning ColdFusion finds the CFC initially. However, looking at the source code I see that the Ajax request is looking for /myCFC.cfc instead of /projects/myCFC.cfc. The predicable result is that the Ajax grid doesn't get populated and a missing file error is logged in Application.log. What do I need to do to get this Ajax call to look in the correct location? Thanks, Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320113 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Apache Configuration Question.
I know I don't need them, I just want them. No, you don't! The point of host headers is to let you use a single socket (IP address and port) for multiple virtual servers. If you don't use the same port, host headers aren't used to determine how to dispatch requests. 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320114 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Apache Configuration Question.
Dave Watts wrote: I know I don't need them, I just want them. No, you don't! Yes I do, I know it is really weird, but I was just trying to make something that would work now and someday in the future. Right now, we do not have DNS names set up for all these sites. All we can do until they are set up is use ports. But someday the DNS will be set up and then host headers will be used. I was just hoping to set up the file so that it would work as things are now and how they will be then. Without having to go back and change the http.conf file. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320115 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Moving a ColdFusion server.
Did you restart apache? On 3/4/09, Ian Skinner h...@ilsweb.com wrote: Is there anything about moving a ColdFusion server to a new IP address that affects Jrun and|or ColdFusion. We just moved a new production box from within our firewall to our external DMZ which gives it new IP address. When we did this two or our five ColdFusion instances continued to work correctly. Three others started to fail, returning 500 internal server errors and error messages in the Apache log about bad serverstore and bootstrap something or other. TIA Ian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320116 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ANNOUNCE: Shrinkadoo, a jQuery powered URL shortening AIR application
On Tue, Mar 3, 2009 at 2:11 PM, Andy Matthews li...@commadelimited.com wrote: Nice. Didn't even know about that one. Note that this app doesn't shrink the URLs itself, it just accesses the APIs of other services. yup, same thing mine did, except I just used url.rickroot.com that's cool that snurl has an api -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320117 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
FCKeditor not retaining format when used in CF CMS
I am running a CF based CMS that uses FCKeditor. Everytime I put content into a textarea it loses its line breaks and formatting. Does anyone know how to configure the FCKconfig.js to correct this issue? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320118 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Max Simultaneous Requests - in a vertical cluster
I've read in various places that the recommended starting point for determining the Max Simultaneous Requests (MSR) value is 3-4 per CPU. But I'm not seeing how this works in a vertical cluster. Say I have a box with 4 CPUs, and 4 instances on that box. How would that suss-out? Do you set each instance to use only it's share of the MSR, or a full MSR? What about a box where the CPUs don't evenly match the number of instances? 4 CPUs, 3 instances, as an example. Does this matter? Cheers, Kris ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320119 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Moving a ColdFusion server.
Depending on how your jvm is configured you will need to restart all
of them because of dns cache and ttl values.
Also I guess it would depend on how you are configuring your jrun
connection. If you are using something like JRunConfig Bootstrap
127.0.0.1:{port} and connecting to your localhost you're ok; if you
are using a specific IP an dport you would have to change them to
reflect your change. There are also security settings that you can
muck with internal the jrun config but I would try that first. It's in
your apache conf.
On Wed, Mar 4, 2009 at 14:29, Ian Skinner h...@ilsweb.com wrote:
Is there anything about moving a ColdFusion server to a new IP address
that affects Jrun and|or ColdFusion.
We just moved a new production box from within our firewall to our
external DMZ which gives it new IP address.
When we did this two or our five ColdFusion instances continued to work
correctly. Three others started to fail, returning 500 internal server
errors and error messages in the Apache log about bad serverstore and
bootstrap something or other.
TIA
Ian
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320120
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Max Simultaneous Requests - in a vertical cluster
That's a starting point, and needs to be tuned for your specific application, so it's kind of irrelevant how good of an estimate it is. I'd say each instance gets (4 * CPUs / instances) to start with, and then do your tuning from there. And make sure if your instances are sharing hardware resources that you're loading all the instances that share the hardware when you test or you'll skew your results. That last app I tuned like this we settled on 20 concurrent requests. We ran one instance per physical machine, and each machine had a single CPU. About 6 month later we updated the application, retuned, and optimized to 8 concurrent requests. Then we started doing secure media delivery and jacked it way up to 50 concurrent requests. So it's REALLY application specific. cheers, barneyb On Wed, Mar 4, 2009 at 3:29 PM, Kris Jones kris.jon...@verizon.net wrote: I've read in various places that the recommended starting point for determining the Max Simultaneous Requests (MSR) value is 3-4 per CPU. But I'm not seeing how this works in a vertical cluster. Say I have a box with 4 CPUs, and 4 instances on that box. How would that suss-out? Do you set each instance to use only it's share of the MSR, or a full MSR? What about a box where the CPUs don't evenly match the number of instances? 4 CPUs, 3 instances, as an example. Does this matter? Cheers, Kris ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320121 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Sessions timing out too soon
Did you change the JRrun session timeout to match? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/3/5 Stan Winchester s...@aftershockweb.com: In my Application.cfc I have the following code: cfcomponent displayname=Application output=true hint=Handle the application. !--- Set up the application. --- cfset THIS.Name = [app name] / cfset THIS.ApplicationTimeout = CreateTimeSpan(2,0,0,0) / cfset THIS.SessionManagement = true / cfset THIS.SessionTimeout = CreateTimeSpan(0,1,0,0) / cfset THIS.SetClientCookies = false / In the CF Admin the max timeout is 4-hours, and yet session don't last longer than 20-minutes or so. Any ideas what's going on? Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer http://www.aftershockweb.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320122 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Oracle 11G CLOBs\BLOBs yielding non-standard characters with CF7
I can't answer your question since we are still on 10G but I would suggest you check/update the drivers. We were running the drivers that came with CF7 -- certain things in 10G wouldn't work at all. We are now running 3.50 on CF7 and 3.6 on CF8. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320123 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Max Simultaneous Requests - in a vertical cluster
Exactly what Barney said. It's app and hardware specific. On our servers we run one CF8 instance per server and we're set to handle up to 100 simultaneous requests. Once in a while we hit that limit. Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. On Mar 4, 2009, at 5:35 PM, Barney Boisvert wrote: That's a starting point, and needs to be tuned for your specific application, so it's kind of irrelevant how good of an estimate it is. I'd say each instance gets (4 * CPUs / instances) to start with, and then do your tuning from there. And make sure if your instances are sharing hardware resources that you're loading all the instances that share the hardware when you test or you'll skew your results. That last app I tuned like this we settled on 20 concurrent requests. We ran one instance per physical machine, and each machine had a single CPU. About 6 month later we updated the application, retuned, and optimized to 8 concurrent requests. Then we started doing secure media delivery and jacked it way up to 50 concurrent requests. So it's REALLY application specific. cheers, barneyb On Wed, Mar 4, 2009 at 3:29 PM, Kris Jones kris.jon...@verizon.net wrote: I've read in various places that the recommended starting point for determining the Max Simultaneous Requests (MSR) value is 3-4 per CPU. But I'm not seeing how this works in a vertical cluster. Say I have a box with 4 CPUs, and 4 instances on that box. How would that suss- out? Do you set each instance to use only it's share of the MSR, or a full MSR? What about a box where the CPUs don't evenly match the number of instances? 4 CPUs, 3 instances, as an example. Does this matter? Cheers, Kris ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320124 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Form Fields
Hi All, I have an issue and my brain is not working Actually I am trying to pull the data back to the formfield from sql database when there is a selection in dropdownlist. I am really not sure of how I could realy implement it. Any Help??? Thanks, Pranathi ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320125 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Form Fields
Hi All, I have an issue and my brain is not working Actually I am trying to pull the data back to the formfield from sql database when there is a selection in dropdownlist. I am really not sure of how I could realy implement it. Any Help??? Thanks, Pranathi ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320126 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
