Re: OT: Developers little helper
On Wednesday 22 June 2005 05:28, Duncan wrote: These would be really cool if you could connect to another machine and do the same thing. s/cool/dangerous and badly designed/ -- Tom Chiverton Advanced ColdFusion Programmer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210184 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Opening CFDocuments data at a later time...
Damon, This is exactly what I'm looking for. Thanks so much! CF7 is very cool by the way. Thanks again, Al Allen Manning Technical Director Prismix Ltd t +44 (0)870 749 1100 f +44 (0)870 749 1200 w http://www.prismix.com/ -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 21 June 2005 18:49 To: CF-Talk Subject: Opening CFDocuments data at a later time... And (to finally answer your original question :), you can use cfcontent var= to stream out later. IE: === cfdocument name=mydocument format=PDF pagetype=letter orientation=portrait unit=in encryption=none fontembed=No backgroundvisible=Yes Hello World! /cfdocument cfcontent type=application/pdf variable=#mydocument# Sorry, just read the subsequent post...yes, the name attribute is the variable name containing the output of the CFDOCUMENT tag. You should be able to use that, I believe. HTH Damon ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210185 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Mac Widgets
Hi guys, Probably a very stupid question but... Does anyone know whether it's possible to make a widget out of a CF app using CF7? Thanks, Stuart ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210186 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Mac Widgets
Widgets are basically HTML + Javascript. They could connect to a page that is run CF7 for more info on making widgets check here: http://developer.apple.com/macosx/dashboard.html HTH Mark Drew On 22/06/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi guys, Probably a very stupid question but... Does anyone know whether it's possible to make a widget out of a CF app using CF7? Thanks, Stuart ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210187 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: coldfusion and asp.net
Agreed - you can run both on the same box without any issues. And you can pass variables (if you ever needed to) by simply writing a webservice that passes them back and both to each other as parameters and results. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: SStewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 21, 2005 4:44 PM To: CF-Talk Subject: RE: coldfusion and asp.net We've been running both for a while, I haven't seen any performance issues. Shoot.. Blue Dragon even runs with and can take advantage of .net You can't easily pass variables between the two, except in the case of BD. But they can coexist on the same box. Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Jon Scherdin [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 21, 2005 04:38 pm To: CF-Talk Subject: coldfusion and asp.net Importance: Low I need some help. Is anyone out there using asp.net and coldfusion on the same server in a production environment? The reason I ask is that my company has multiple servers, a dev server running iis, .net, and cf, an app server running iis and cf, and a .net server running iis and .net. I really want to consolidate things and bring all the servers together but I am getting resistance from some people who say that coldfusion and asp.net do not play well together and that there are performance issues when they are on the same box. Does anyone have any data that supports either side of this argument? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210188 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CWS Anyone?
Did anyone watch the end of the two elimination games in the College World Series yesterday??? Absolutely amazing high drama! Two of the best finishes to baseball games i've ever seen, at any level. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210189 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CWS Anyone? - IGNORE
Obviously, this email was not intended to be sent to this list. Please accept my apologies. BG Did anyone watch the end of the two elimination games in the College World Series yesterday??? Absolutely amazing high drama! Two of the best finishes to baseball games i've ever seen, at any level ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210190 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF + FCKeditor
Hello, I was wondering if anyone has had problems in setting up the image browsing and file upload connector with CF 6.1 and FCKeditor... I've been trying to set this up for a little bit and I seem to be going round and round... I have set APPLICATION.userFilesPath to the full path and to the url path... I am unclear on what to try next... I've also changed the permissions on the folder to 777.. Any ideas? Thanks, -- Yves Arsenault ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210191 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF + FCKeditor
Yves: I just did this and had a little bit of trouble, Did you change the connector to be a .cfm connector? This setting is in your fckconfig.js file. Also if the connector is in a directory such as /fckeditor/ off of the root then your application.userFilesPath must be setup in this same application scope, otherwise it will default to the directory /UserFiles/ Ask if you have more question this might not be clear. On 6/22/05, Yves Arsenault [EMAIL PROTECTED] wrote: Hello, I was wondering if anyone has had problems in setting up the image browsing and file upload connector with CF 6.1 and FCKeditor... I've been trying to set this up for a little bit and I seem to be going round and round... I have set APPLICATION.userFilesPath to the full path and to the url path... I am unclear on what to try next... I've also changed the permissions on the folder to 777.. Any ideas? Thanks, -- Yves Arsenault ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210192 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
query help
I've got one of those problems where I've looked at a query too long and now I can't see anything clearly any more. I've put the table layout below of the columns in question (there are more, but they're not important here). ENTITY +ID +LOCATION +PARENT_ID ENTITY_NAME +ID +ENTITY_ID +ENTITY_NAME +START_DATE +END_DATE So, an entity can change names over time, but can only ever have one currently active name determined by the start and end dates. It's very easy to get the entity's current name. I've no problem with that. The issue I'm having is trying to get the PARENT ENTITY'S name. It's easy to get the currently active parent's name as well, but where I'm messing up is that I'm leaving out those records which DO NOT HAVE a parent entity assigned to them. My query: SELECT A.ID , B.ENTITY_NAME, C.ENTITY_NAME AS PARENT_NAME FROMENTITY A, ENTITY_NAME B, (SELECT entity_name, entity_id from entity_name where ((NOW() BETWEEN START_DATE AND END_DATE) OR (now() START_DATE AND END_DATE is NULL))) as C WHERE A.ID = B.ENTITY_ID AND A.PARENT_ID = C.ENTITY_ID AND ( ((NOW() BETWEEN B.START_DATE AND B.END_DATE) OR (now() B.START_DATE AND B.END_DATE is NULL)) ) DATA RETURNED --- ID ENTITY_NAME PARENT_NAME --- 5 Shipper B Shipper A-2 4 Shipper A-2 Shipper B 8 TestVector US Pipeline --- DATA THAT SHOULD BE RETURNED --- ID ENTITY_NAME PARENT_NAME --- 3 Vector US Pipeline 5 Shipper B Shipper A-2 6 Agent 1 4 Shipper A-2 Shipper B 8 TestVector US Pipeline --- I started out using a join, but then switched to the subquery... Like I said, it shouldn't be all that difficult, but I just keep messing with it and not getting it right. Thanks, Ferg ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210193 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Registrar that does DNS management?
Damien, I'm replying a little late but GoDaddy let me setup all of my A, CNAME and MX records for my domains and just point them to my server. Worked like a charm. And they didn't charge me extra. Rey... Damien McKenna wrote: To answer my own question, Domain Direct (Tucow's OpenSRS company) does this for $14.99 per year, or $12.99 for a transfer (inc one year). -- http://www.ReyBango.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210194 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
How do you tell ColdFusion to execute .html files?
Google says at http://www.google.com/webmasters/2.html that We're able to index dynamically generated pages. However, because our web crawler could overwhelm and crash sites that serve dynamic content, we limit the number of dynamic pages we index. This suggests that a site with a very large number of pages would be better off using the .html file extension rather than .cfm so as to not trigger any limitation by Google on its indexing and thereby possibly improve search engine optimization. I want to set up a server to test this and see if it really makes any difference. Can someone tell me where and how exactly to change the Registry of a Windows 2003 server to tell ColdFusion to process .html files? Your informed opinions as to whether or not it really would make much difference to Google would also be appreciated. For example it might be that Google's threshold for imposing limits on the number of dynamic pages they index is 50,000 pages or more, and that's far more than I intend to be building for any one web site. My sites I'm talking about will be in the range of around 1,000 to 5,000 individual CF templates. Is anybody already running sites having that range of individual .cfm files without any problems getting them all crawled by Google? Thanks, Karl S. [In] my era everybody smoked and everybody drank and there was no drug use DEA Chief Thomas Constantine, July 1, 1998 -- Internal Virus Database is out-of-date. Checked by AVG Anti-Virus. Version: 7.0.322 / Virus Database: 267.6.8 - Release Date: 6/11/05 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210195 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF + FCKeditor
Hey Dustin, Yes, I did modify the fckconfig.js file And I was just reading a post on sourceforge.net on the application var I had set the application var and still get an internal error (500) Hmm.. Thanks, Yves On 6/22/05, Dustin Tinney [EMAIL PROTECTED] wrote: Yves: I just did this and had a little bit of trouble, Did you change the connector to be a .cfm connector? This setting is in your fckconfig.js file. Also if the connector is in a directory such as /fckeditor/ off of the root then your application.userFilesPath must be setup in this same application scope, otherwise it will default to the directory /UserFiles/ Ask if you have more question this might not be clear. On 6/22/05, Yves Arsenault [EMAIL PROTECTED] wrote: Hello, I was wondering if anyone has had problems in setting up the image browsing and file upload connector with CF 6.1 and FCKeditor... I've been trying to set this up for a little bit and I seem to be going round and round... I have set APPLICATION.userFilesPath to the full path and to the url path... I am unclear on what to try next... I've also changed the permissions on the folder to 777.. Any ideas? Thanks, -- Yves Arsenault ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210196 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
testing for undefined
I'm returning data back from a database and want to populate
variables the same way as columns are named. I have this working
fine (though any suggested improvements are welcome), but when the
values are undefined, in this case at least, I'd like to make the
variable have a '' (empty quotes) instead for repopulating form
fields. I'm not sure how to test for undefined.
Here's the code:
cfset the_db = StructNew()
cfoutput query=#the_db_name#
cfloop list=#evaluate('#the_db_name#.columnlist')# index=col
cfset the_db_info[col] =
evaluate('#the_db_name#[col][currentRow]')
!--- attempting to make undefined an empty string ---
cfif the_db_info[col] EQ undefined
cfset the_db_info[col] = ''
/cfif
#col#:#the_db_info[col]#br
/cfloop
/cfoutput
--
Daniel Kessler
Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD 20742-2611
301-405-2545 Phone
www.phi.umd.edu
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210197
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Paradox Database
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Many years ago, we built an online store application for a client in which all product data for the store is pulled from a Paradox database that the client uploads to our server. We recently upgraded to MX (6.1 running on windows 2003 server to be exact) which does not have built-in support for Paradox datasources. So I believe what I need is a paradox JDBC driver for coldfusion to communicate with the client's database (right?). Preferably. If you can not find a suitable driver you could also work with an ODBC driver and the JDBC-ODBC bridge. Does anyone know where I might be able to find one? There should be one packaged wit Paradox 9. But else: http://developers.sun.com/product/jdbc/drivers Jochem ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210198 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How do you tell ColdFusion to execute .html files?
I don't think Google limits based on the file extension. I believe they limit based on whether the content is actually static or not. I could be wrong and I'm certainly not an expert in the way these things work, but I would be very much surprised if they'd allow it to be circumvented this easily. The change you need to make in order to get CF to process files with alternate extensions depends on which version of CF you are running, but it's not a registry change. I'm sure someone will pipe in shortly with more details, but what version of CF are you using? --Ferg Karl Simanonok wrote: Google says at http://www.google.com/webmasters/2.html that We're able to index dynamically generated pages. However, because our web crawler could overwhelm and crash sites that serve dynamic content, we limit the number of dynamic pages we index. This suggests that a site with a very large number of pages would be better off using the .html file extension rather than .cfm so as to not trigger any limitation by Google on its indexing and thereby possibly improve search engine optimization. I want to set up a server to test this and see if it really makes any difference. Can someone tell me where and how exactly to change the Registry of a Windows 2003 server to tell ColdFusion to process .html files? Your informed opinions as to whether or not it really would make much difference to Google would also be appreciated. For example it might be that Google's threshold for imposing limits on the number of dynamic pages they index is 50,000 pages or more, and that's far more than I intend to be building for any one web site. My sites I'm talking about will be in the range of around 1,000 to 5,000 individual CF templates. Is anybody already running sites having that range of individual .cfm files without any problems getting them all crawled by Google? Thanks, Karl S. [In] my era everybody smoked and everybody drank and there was no drug use DEA Chief Thomas Constantine, July 1, 1998 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210199 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Flash Forms Question
I'm working on an app with flash forms in it. I need a way to specify a value for a checkbox. In an HTML or CF Form you can specify any value for a check box, it appears that flash checkboxes are only true or false. Is there a way to specify a value or can I use the bind attribute and a hidden field to return a value if the checkbox is checked? Thanks, Daron Smith ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210200 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF + FCKeditor
Yves, To debug open up your connector.cfm file and do a cfDump var=#application# make sure tthat the variable is being set. you should be able to see in the top of the connector file the default directories if it's not being set. /Dustin On 6/22/05, Yves Arsenault [EMAIL PROTECTED] wrote: Hey Dustin, Yes, I did modify the fckconfig.js file And I was just reading a post on sourceforge.net on the application var I had set the application var and still get an internal error (500) Hmm.. Thanks, Yves On 6/22/05, Dustin Tinney [EMAIL PROTECTED] wrote: Yves: I just did this and had a little bit of trouble, Did you change the connector to be a .cfm connector? This setting is in your fckconfig.js file. Also if the connector is in a directory such as /fckeditor/ off of the root then your application.userFilesPath must be setup in this same application scope, otherwise it will default to the directory /UserFiles/ Ask if you have more question this might not be clear. On 6/22/05, Yves Arsenault [EMAIL PROTECTED] wrote: Hello, I was wondering if anyone has had problems in setting up the image browsing and file upload connector with CF 6.1 and FCKeditor... I've been trying to set this up for a little bit and I seem to be going round and round... I have set APPLICATION.userFilesPath to the full path and to the url path... I am unclear on what to try next... I've also changed the permissions on the folder to 777.. Any ideas? Thanks, -- Yves Arsenault ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210201 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Can CFMX 6.1 and CFMX 7 co-exist?
Can CFMX 6.1 and CFMX 7 co-exist? If so, are there any articles that can point me in the right direction? Rey... -- http://www.ReyBango.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210202 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF + FCKeditor
Hey Dustin... Well, I couldn't get it to work at all with the application var... So instead, I just hardcoded the userfiles path in the connector.cfm and it works great now.. ;-) Thanks for the help, Yves On 6/22/05, Dustin Tinney [EMAIL PROTECTED] wrote: Yves, To debug open up your connector.cfm file and do a cfDump var=#application# make sure tthat the variable is being set. you should be able to see in the top of the connector file the default directories if it's not being set. /Dustin On 6/22/05, Yves Arsenault [EMAIL PROTECTED] wrote: Hey Dustin, Yes, I did modify the fckconfig.js file And I was just reading a post on sourceforge.net on the application var I had set the application var and still get an internal error (500) Hmm.. Thanks, Yves On 6/22/05, Dustin Tinney [EMAIL PROTECTED] wrote: Yves: I just did this and had a little bit of trouble, Did you change the connector to be a .cfm connector? This setting is in your fckconfig.js file. Also if the connector is in a directory such as /fckeditor/ off of the root then your application.userFilesPath must be setup in this same application scope, otherwise it will default to the directory /UserFiles/ Ask if you have more question this might not be clear. On 6/22/05, Yves Arsenault [EMAIL PROTECTED] wrote: Hello, I was wondering if anyone has had problems in setting up the image browsing and file upload connector with CF 6.1 and FCKeditor... I've been trying to set this up for a little bit and I seem to be going round and round... I have set APPLICATION.userFilesPath to the full path and to the url path... I am unclear on what to try next... I've also changed the permissions on the folder to 777.. Any ideas? Thanks, -- Yves Arsenault ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210203 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: How do you tell ColdFusion to execute .html files?
Google does not index based on file extension - that would be insane - as you could create a .karl file extenstion quite easily in IIS or even ..iamafileextension and so on and so forth. -Original Message- From: Karl Simanonok [mailto:[EMAIL PROTECTED] Sent: 22 June 2005 14:41 To: CF-Talk Subject: How do you tell ColdFusion to execute .html files? Google says at http://www.google.com/webmasters/2.html that We're able to index dynamically generated pages. However, because our web crawler could overwhelm and crash sites that serve dynamic content, we limit the number of dynamic pages we index. This suggests that a site with a very large number of pages would be better off using the .html file extension rather than .cfm so as to not trigger any limitation by Google on its indexing and thereby possibly improve search engine optimization. I want to set up a server to test this and see if it really makes any difference. Can someone tell me where and how exactly to change the Registry of a Windows 2003 server to tell ColdFusion to process .html files? Your informed opinions as to whether or not it really would make much difference to Google would also be appreciated. For example it might be that Google's threshold for imposing limits on the number of dynamic pages they index is 50,000 pages or more, and that's far more than I intend to be building for any one web site. My sites I'm talking about will be in the range of around 1,000 to 5,000 individual CF templates. Is anybody already running sites having that range of individual .cfm files without any problems getting them all crawled by Google? Thanks, Karl S. [In] my era everybody smoked and everybody drank and there was no drug use DEA Chief Thomas Constantine, July 1, 1998 -- Internal Virus Database is out-of-date. Checked by AVG Anti-Virus. Version: 7.0.322 / Virus Database: 267.6.8 - Release Date: 6/11/05 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210204 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How do you tell ColdFusion to execute .html files?
No need to change the registry. Assuming you are running IIS on win2K3, you just need to add an application mapping. (I think, I've never tested this though) 1. View the properties of the IIS site 2. On the Home Directory tab, select 'Configure' 3. On the App Mappings tab, select 'Add' 4. Browse for the executable and point it to the same jrun.dll that you .cfm pages map to. 5. Add .html as the extension. That should do it. Although I second what Ken said. This isn't going to help your google ranking and indexing at all. Look at sites like Reuters.com or other news sites. They are dynamic, not serving .html extensions, yet google indexes all thier stories, all the time. -Adam On 6/22/05, Karl Simanonok [EMAIL PROTECTED] wrote: Google says at http://www.google.com/webmasters/2.html that We're able to index dynamically generated pages. However, because our web crawler could overwhelm and crash sites that serve dynamic content, we limit the number of dynamic pages we index. This suggests that a site with a very large number of pages would be better off using the .html file extension rather than .cfm so as to not trigger any limitation by Google on its indexing and thereby possibly improve search engine optimization. I want to set up a server to test this and see if it really makes any difference. Can someone tell me where and how exactly to change the Registry of a Windows 2003 server to tell ColdFusion to process .html files? Your informed opinions as to whether or not it really would make much difference to Google would also be appreciated. For example it might be that Google's threshold for imposing limits on the number of dynamic pages they index is 50,000 pages or more, and that's far more than I intend to be building for any one web site. My sites I'm talking about will be in the range of around 1,000 to 5,000 individual CF templates. Is anybody already running sites having that range of individual .cfm files without any problems getting them all crawled by Google? Thanks, Karl S. [In] my era everybody smoked and everybody drank and there was no drug use DEA Chief Thomas Constantine, July 1, 1998 -- Internal Virus Database is out-of-date. Checked by AVG Anti-Virus. Version: 7.0.322 / Virus Database: 267.6.8 - Release Date: 6/11/05 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210205 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How do you tell ColdFusion to execute .html files?
The change you need to make in order to get CF to process files with alternate extensions depends on which version of CF you are running, but it's not a registry change. I'm sure someone will pipe in shortly with more details, but what version of CF are you using? I was under the impression it was purely a webserver setting, so it would depend on your webserver. I know how to accomplish it in the proerties for an IIS site, although I don't have IIS installed on this machine, so I can't walk through the steps right now... I want to say it's in the directories tab ... there's an advanced button or the like near the lower-right corner that brings up another dialog with a list of file extensions with .cfm and .cfc pointed to /cfusionmx/lib/servers/1/jrun.dll or somesuch... Look up Charlie Areharts article on running cf5, cfmx and bluedragon on one machine, iirc it has all the steps in the article because you have to use that technique to make that work. Or at least you used to if you weren't using the J2EE deployment of CF. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210206 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: How do you tell ColdFusion to execute .html files?
Google does not index based on file extension - that would be insane - as you could create a .karl file extenstion quite easily in IIS or even ..iamafileextension and so on and so forth. For a long time I've vaguely contemplated using .ike files to serve my site. :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210207 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: query help
Below is what I came up with. It seems to work pretty well, but I'd still welcome any advice on improvement. --Ferg SELECTdistinct A.ID , B.ENTITY_NAME, case when A.parent_id is null then '' else C.ENTITY_NAME end AS PARENT_NAME FROM ENTITY A, ENTITY_NAME B, (SELECT entity_name, entity_id from entity_name where ((NOW() BETWEEN START_DATE AND END_DATE) OR (now() START_DATE AND END_DATE is NULL))) as C WHERE A.ID = B.ENTITY_ID AND IF(A.parent_id is not null, A.PARENT_ID = C.ENTITY_ID,1=1) AND ((NOW() BETWEEN B.START_DATE AND B.END_DATE) OR (now() B.START_DATE AND B.END_DATE is NULL)) Ken Ferguson wrote: I've got one of those problems where I've looked at a query too long and now I can't see anything clearly any more. I've put the table layout below of the columns in question (there are more, but they're not important here). ENTITY +ID +LOCATION +PARENT_ID ENTITY_NAME +ID +ENTITY_ID +ENTITY_NAME +START_DATE +END_DATE So, an entity can change names over time, but can only ever have one currently active name determined by the start and end dates. It's very easy to get the entity's current name. I've no problem with that. The issue I'm having is trying to get the PARENT ENTITY'S name. It's easy to get the currently active parent's name as well, but where I'm messing up is that I'm leaving out those records which DO NOT HAVE a parent entity assigned to them. My query: SELECT A.ID , B.ENTITY_NAME, C.ENTITY_NAME AS PARENT_NAME FROM ENTITY A, ENTITY_NAME B, (SELECT entity_name, entity_id from entity_name where ((NOW() BETWEEN START_DATE AND END_DATE) OR (now() START_DATE AND END_DATE is NULL))) as C WHERE A.ID = B.ENTITY_ID AND A.PARENT_ID = C.ENTITY_ID AND ( ((NOW() BETWEEN B.START_DATE AND B.END_DATE) OR (now() B.START_DATE AND B.END_DATE is NULL)) ) DATA RETURNED --- ID ENTITY_NAME PARENT_NAME --- 5 Shipper B Shipper A-2 4 Shipper A-2 Shipper B 8 TestVector US Pipeline --- DATA THAT SHOULD BE RETURNED --- ID ENTITY_NAME PARENT_NAME --- 3 Vector US Pipeline 5 Shipper B Shipper A-2 6 Agent 1 4 Shipper A-2 Shipper B 8 TestVector US Pipeline --- I started out using a join, but then switched to the subquery... Like I said, it shouldn't be all that difficult, but I just keep messing with it and not getting it right. Thanks, Ferg ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210208 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can CFMX 6.1 and CFMX 7 co-exist?
If you are running J2EE, then the answer is yes. You can deploy each version into thier own instance without any problems at all. -Adam On 6/22/05, Rey Bango [EMAIL PROTECTED] wrote: Can CFMX 6.1 and CFMX 7 co-exist? If so, are there any articles that can point me in the right direction? Rey... -- http://www.ReyBango.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210209 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Can CFMX 6.1 and CFMX 7 co-exist?
Yes, CFMX7 was designed to co-exist peacefully with CFMX 6.1 and CF5.
When you install CFMX7, if asked (UNIX), just point to your previous config and
we'll copy/migrate your CF5 or CFMX6.1 settings into the new CFMX7 installation
for you (the post-install wizard that runs the first time you log into the CF
Administrator does this work).
The one caveat is with the web server connectors. When installing and
co-existence with a previous version is your goal, it's probably a good idea to
chose the integrated development web server option during installation so
your previous version's web server connectors are not replaced and still route
.CFM calls to the older version. Unless, of course, you know you want to
configure-and-go with CFMX7 right away.
You can always run wsconfig (Web Server config utility) from the
{cfusion}\bin directory later and configure your web servers, and use the
integrated web server (on default port 8500) for development and testing until
you're ready to configure your web server with CFMX7.
HTH
Damon
Can CFMX 6.1 and CFMX 7 co-exist? If so, are there any articles that can
point me in the right direction?
Rey...
--
http://www.ReyBango.com
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210210
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How do you tell ColdFusion to execute .html files?
Back in pre-MX days, I used to do clients' sites in file extensions that were unique to their business. It was a dumb little thing that helped me sell a ton of projects, as they were so thrilled with something that was so personalized. index.gwpc for the Groundwater Protection Council. index.inh for Argonne Nat'l Labs on the Indiana Harbor project index.love for a chicago dating site index.pga for a PGA media site People used to eat that stuff up and thought it was the coolest thing in the world that I could name all of their files something they liked and something they came up with. It may be a very sill and simple thing, but so is sending your customers a birthday card or something like that. You'd be hard-pressed to argue against the effectiveness of those small and silly things! --Ferg .. S. Isaac Dealey wrote: Google does not index based on file extension - that would be insane - as you could create a .karl file extenstion quite easily in IIS or even ..iamafileextension and so on and so forth. For a long time I've vaguely contemplated using .ike files to serve my site. :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210211 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: application.cfm includes
It's the former. I get most of what you're saying. Are you saying that I should just have a sessiontimeout in the timeout in the application.cfm file: other info cfapplication sessionmanagement=yes setclientcookies=yes name=db_storage sessiontimeout=#CreateTimeSpan(0,0,30,0)# then include that file into another one and just have the same line in the new file with a new timeout? cfapplication sessiontimeout=#CreateTimeSpan(0,1,0,0)# and it'll overwrite the previous timeout for that directory? Are you talking about within a single application, or for multiple applications on the same server? If the former, just have each directory's Application.cfm set a sessionTimeout variable, and CFINCLUDE the parent directory's Application.cfm. The top-level one will have all the actual code, including the CFAPPLICATION tag, which will CFPARAM the sessionTimeout variable to some default, and then use that for the sessionTimeout attribute. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210212 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfgrid flash form
Not sure if this is clear or not, but here goes. Is there a way to create a cfgrid in a flash form with one of the columns populated by database table values. For example: We have a cfgrid where users can add rows when needed to enter task for a project. One user may have 3 task and the other 10 task. Being able to add and remove rows on the fly is perfect. But we would like for users have a drop down in the grid to choose data driven values in one the columns. To insure what they enter will be consistent values instead of free text. Or if not possible is there a way to use action scripting to loop over 4 cfinput type=text boxes based on the value of a cfselect box above the input statements. A user might select 10 in the drop down and on change the action script would loop over the input fields 10 times to expand the flash form with 10 rows. I hope this is clear. David ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210213 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Can CFMX 6.1 and CFMX 7 co-exist?
If you have an Enterprise version of any of cf's you can deploy both versions in the same Jrun without problems I guess. David Manriquez [EMAIL PROTECTED] (+56-2) 43 00 155 -Mensaje original- De: Rey Bango [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 22 de Junio de 2005 9:56 Para: CF-Talk Asunto: Can CFMX 6.1 and CFMX 7 co-exist? Can CFMX 6.1 and CFMX 7 co-exist? If so, are there any articles that can point me in the right direction? Rey... -- http://www.ReyBango.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210214 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing for undefined
-Original Message-
From: Daniel Kessler [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 22, 2005 9:47 AM
To: CF-Talk
Subject: testing for undefined
I'm returning data back from a database and want to populate
variables the same way as columns are named. I have this working
fine (though any suggested improvements are welcome), but when the
values are undefined, in this case at least, I'd like to make the
variable have a '' (empty quotes) instead for repopulating form
fields. I'm not sure how to test for undefined.
Here's the code:
cfset the_db = StructNew()
cfoutput query=#the_db_name#
cfloop list=#evaluate('#the_db_name#.columnlist')# index=col
cfset the_db_info[col] =
evaluate('#the_db_name#[col][currentRow]')
!--- attempting to make undefined an empty string ---
cfif the_db_info[col] EQ undefined
cfset the_db_info[col] = ''
/cfif
#col#:#the_db_info[col]#br
/cfloop
/cfoutput
Well - first off you don't need the evaluates in there - you can use normal
notation. Something like this.
cfset the_db = StructNew()
cfoutput query=#CurQuery#
cfloop list=#the_db_name.columnlist# index=col
cfset the_db_info[col] = the_db_name[col][currentRow]
/cfloop
/cfoutput
Once that's set I'm confused... you're looping over a known column list so
how could any be column name be undefined?
I guess I'm confused with the_db_info variable and what it does... as it
is in your current code it's being used as an indexed object, but it's never
declared as one... even if it were it would end up overwritten with the last
of row of data in any multi-row recordset.
To convert a one-row recordset to a struct (which is sorta what your code is
doing) I would do this (this will also work for multi-row record sets but
will only convert the first row):
cfset MyStruct = StructNew() /
cfloop list=#CurQuery.columnlist# index=CurCol
cfset MyStruct[CurCol] = CurQuery[CurCol][1] /
/cfloop
By the same token to convert just the last row you modify it to do this:
cfset MyStruct = StructNew() /
cfloop list=#CurQuery.columnlist# index=CurCol
cfset MyStruct[CurCol] = CurQuery[CurCol][CurQuery.RecordCount] /
/cfloop
Now, to convert multi-record queries you need to have something in the
structkey to hold multiple values. (This is where you're original code
confuses me since it doesn't seem to do that.)
For example a logical form is a struct of Arrays (which is, in fact, what a
query object is). To do that conversion you'd do something like this:
cfset MyStruct = StructNew() /
cfloop list=#CurQuery.columnlist# index=CurCol
cfset MyStruct[CurCol] = ArrayNew(1) /
cfloop from=1 to=#CurQuery.RecordCount# index=Cnt
cfset ArrayAppend(MyStruct[CurCol], CurQuery[CurCol][Cnt]) /
/cfloop
/cfloop
Now there's a nifty simplification that comes into play here. Since Query
columns are already arrays (and can be accessed as such you should also be
able to do (more simply) something like this:
cfset MyStruct = StructNew() /
cfloop list=#CurQuery.columnlist# index=CurCol
cfset MyStruct[CurCol] = ArrayNew(1) /
cfset MyStruct[CurCol] = CurQuery[CurCol] /
/cfloop
Those two blocks of code (barring any coding in email email errors should
work identically).
It's also useful in other ways. Let's say you don't want a struct of
arrays, let's say you want a struct of lists (with each list representing
the column of data values). You can do that even more simply like this:
cfset MyStruct = StructNew() /
cfloop list=#CurQuery.columnlist# index=CurCol
cfset MyStruct[CurCol] = ArrayToList(CurQuery[CurCol]) /
/cfloop
Neat, uh?
I'm not sure if any of that actually addresses your problem... but I hope it
does!
Jim Davis
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210215
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Registrar that does DNS management?
On Tuesday 21 June 2005 17:56, Damien McKenna wrote: service than two separate ones. Any suggestions? Thanks. I use Gandi. Cheap, control panel for free. -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210216 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
About CFform and Flash format
Hi list: I need to know if i need something extra to run CFform in Flash format... When i desing a simple form in a flash format i don't get nothing in the cfm page when i run it.. I'm using CF 7 Regards, -- M.Sc. Hassan Arteaga RodrÃguez Microsoft Certified System Engineer IT Specialist. WEB Programmer. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210217 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: query help
Hey Ken, I've had those days... try this: SELECT A.ID , B.ENTITY_NAME, C.ENTITY_NAME AS PARENT_NAME FROM ENTITY A INNER JOIN ENTITY_NAME B ON (b.entity_id = a.id and now() b.start_date and (b.end_date is null or b.end_date now())) LEFT JOIN ENTITY_NAME C ON (c.entity_id = a.parent_id and now() c.start_date and (c.end_date is null or c.end_date now())) Though... this is Access isn't it? ... you may have some difficulty getting access to accept the parenthesis in that order, since I think the inner and left join statements need to be nested... With this one I might start with the visual query builder in Access first to get the left join syntax and then add the date filters. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210218 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
How do you tell ColdFusion to execute .html files?
Google considers a page to be dynamic if it has a query string. Read my blog entry about sidestepping this issue here: http://www.chrispetersweb.com/blog/view.cfm/id/13 My blog entry actually just adds to ideas Ben Forta presented in a CFDJ article, but I never miss the chance to pimp my blog. :) - Chris Peters Google says at http://www.google.com/webmasters/2.html that We're able to index dynamically generated pages. However, because our web crawler could overwhelm and crash sites that serve dynamic content, we limit the number of dynamic pages we index. This suggests that a site with a very large number of pages would be better off using the .html file extension rather than .cfm so as to not trigger any limitation by Google on its indexing and thereby possibly improve search engine optimization. I want to set up a server to test this and see if it really makes any difference. Can someone tell me where and how exactly to change the Registry of a Windows 2003 server to tell ColdFusion to process .html files? Your informed opinions as to whether or not it really would make much difference to Google would also be appreciated. For example it might be that Google's threshold for imposing limits on the number of dynamic pages they index is 50,000 pages or more, and that's far more than I intend to be building for any one web site. My sites I'm talking about will be in the range of around 1,000 to 5,000 individual CF templates. Is anybody already running sites having that range of individual .cfm files without any problems getting them all crawled by Google? Thanks, Karl S. [In] my era everybody smoked and everybody drank and there was no drug use DEA Chief Thomas Constantine, July 1, 1998 -- Internal Virus Database is out-of-date. Checked by AVG Anti-Virus. Version: 7.0.322 / Virus Database: 267.6.8 - Release Date: 6/11/05 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210219 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Registrar that does DNS management?
I know Network Solutions costs more for registration..., but I still like using them. I really like the account manager there. It's so easy to use in my opinion and I've absolutely never had any problems with them. I don't need to save 10 or 15 bucks a year and go with someone I'm not really sure about. --Ferg Thomas Chiverton wrote: On Tuesday 21 June 2005 17:56, Damien McKenna wrote: service than two separate ones. Any suggestions? Thanks. I use Gandi. Cheap, control panel for free. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210220 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: query help
Isaac, thanks man, that works too and looks better than my case statements. Shame on you for thinking I'd even have Access installed on my machine though! It's MySQL. --Ferg S. Isaac Dealey wrote: Hey Ken, I've had those days... try this: SELECT A.ID , B.ENTITY_NAME, C.ENTITY_NAME AS PARENT_NAME FROM ENTITY A INNER JOIN ENTITY_NAME B ON (b.entity_id = a.id and now() b.start_date and (b.end_date is null or b.end_date now())) LEFT JOIN ENTITY_NAME C ON (c.entity_id = a.parent_id and now() c.start_date and (c.end_date is null or c.end_date now())) Though... this is Access isn't it? ... you may have some difficulty getting access to accept the parenthesis in that order, since I think the inner and left join statements need to be nested... With this one I might start with the visual query builder in Access first to get the left join syntax and then add the date filters. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210221 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How do you tell ColdFusion to execute .html files?
People used to eat that stuff up and thought it was the coolest thing in the world that I could name all of their files something they liked and something they came up with. It may be a very sill and simple thing, but so is sending your customers a birthday card or something like that. You'd be hard-pressed to argue against the effectiveness of those small and silly things! I find context is important in their impact tho... for example, one of the small and silly things I really like about my onTap framework tools is the way it builds checkboxes and radio buttons in forms... Ever notice how in a desktop application, when there's text next to one of those controls, the text is usually clickable to select or deselect the input? I did the same thing with the framework's radio buttons and checkboxes, so you can click anywhere on the label... This is a common practice of desktop application usability that's just been dropped completely from web-apps and likely contributes subliminally to people's feeling that web-apps are clunky... Though it seems I'm the only person who cares. :P But you're right, people are often impressed by simple things. --Ferg .. S. Isaac Dealey wrote: Google does not index based on file extension - that would be insane - as you could create a .karl file extenstion quite easily in IIS or even ..iamafileextension and so on and so forth. For a long time I've vaguely contemplated using .ike files to serve my site. :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210222 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How do you tell ColdFusion to execute .html files?
This was true prior to MX, but I think I remember some changes needing to be made in one of CF's xml config files to get it to work. I'm fairly certain that only making the webserver change will not work. When GWPC upgraded from CF5 to 6.1, I had to make some changes for this. I'll try to dive back into my notes to see what they were. --Ferg S. Isaac Dealey wrote: The change you need to make in order to get CF to process files with alternate extensions depends on which version of CF you are running, but it's not a registry change. I'm sure someone will pipe in shortly with more details, but what version of CF are you using? I was under the impression it was purely a webserver setting, so it would depend on your webserver. I know how to accomplish it in the proerties for an IIS site, although I don't have IIS installed on this machine, so I can't walk through the steps right now... I want to say it's in the directories tab ... there's an advanced button or the like near the lower-right corner that brings up another dialog with a list of file extensions with .cfm and .cfc pointed to /cfusionmx/lib/servers/1/jrun.dll or somesuch... Look up Charlie Areharts article on running cf5, cfmx and bluedragon on one machine, iirc it has all the steps in the article because you have to use that technique to make that work. Or at least you used to if you weren't using the J2EE deployment of CF. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210223 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How do you tell ColdFusion to execute .html files?
I knew I was right about that. Here are the links you'll need to get it working in either pre or post MX CF installations. Pre-mx: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18214 Post-mx http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18289 --Ferg Ken Ferguson wrote: This was true prior to MX, but I think I remember some changes needing to be made in one of CF's xml config files to get it to work. I'm fairly certain that only making the webserver change will not work. When GWPC upgraded from CF5 to 6.1, I had to make some changes for this. I'll try to dive back into my notes to see what they were. --Ferg S. Isaac Dealey wrote: The change you need to make in order to get CF to process files with alternate extensions depends on which version of CF you are running, but it's not a registry change. I'm sure someone will pipe in shortly with more details, but what version of CF are you using? I was under the impression it was purely a webserver setting, so it would depend on your webserver. I know how to accomplish it in the proerties for an IIS site, although I don't have IIS installed on this machine, so I can't walk through the steps right now... I want to say it's in the directories tab ... there's an advanced button or the like near the lower-right corner that brings up another dialog with a list of file extensions with .cfm and .cfc pointed to /cfusionmx/lib/servers/1/jrun.dll or somesuch... Look up Charlie Areharts article on running cf5, cfmx and bluedragon on one machine, iirc it has all the steps in the article because you have to use that technique to make that work. Or at least you used to if you weren't using the J2EE deployment of CF. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210224 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Syncing Data between Websites
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am creating an application which will have 2 separate websites with one being a Live Server with MySQL and the other one being a Tablet PC with CF and Access. The Idea at present time is if the Tablet had a connection to the Internet via Wireless while in the classroom, then the data would be stored on the Live Server under MySQL. If the tablet was not connect to the network then it would store the info to access until the time the tablet had Internet connection. I figure I would use cfhttp to check the Live Server and test to make sure I get a 200 Response code back but not sure after I get the 200 Response from the table to save the data to the MySQL server. Does anyone have experience with this? Or has anyone done something like this who is willing to share their experiences. - -- Graham Pearson, System Administrator / Webmaster Northern Indiana Educational Services Center 56535 Magnetic Drive - Mishawaka, IN 46544 Voice (866) 254-5322 / Fax (574) 254-0148 http://www.niesc.k12.in.us -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) iD8DBQFCuYAyAsX4F3fHDngRAis8AKCRbNfjOPuyi6GTUG1jfx3TxMjXOACdGJyS VEoyWWGRmJAHyofvNvUtH5U= =S9Lq -END PGP SIGNATURE- ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210225 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Developers little helper
Ah then I'm not the only lazy developer around :) -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 21, 2005 11:11 PM To: CF-Talk Subject: Re: OT: Developers little helper Here is a similar tool. Pretty handy and useful http://www.shlomygantz.com/blog/index.cfm?mode=entryentry=C7D 6FEE1-40CA-7F8D-8E76EF91F5737896 On 6/21/05, Steven Brownlee [EMAIL PROTECTED] wrote: This is not a CF tool, but a good tool for CF programmers. I've received a lot of positive feedback on it, so I thought I'd share it with CF-Talk. Basically, it's a small utility that sits in your system tray that allows you to have one-click access to either single system services, or user-defined groups of services. Here's the link to a more descriptive post on my Blog. The link for downloading is there. http://www.orbwave.com/cfjboss/2005/06/system-manager-10-released.html Hope you find it useful. - Steve ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210227 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
J2EE Session Sharing without Cluster? -- more frustration
Is it possible to share sessions without clustering? (I'd like to be able to know that when I'm hitting Server A, that the application I'm seeing is coming from Server A. This is for hardware load-balancing and fail-over reasons.) Here's a real world example: Sometimes, I need to reload my applications, which I do via a url parameter that clears cached queries, application variables, etc. Normally (without a cluster), I have a separate domains that hit each individual server on my load-balanced farm, and I can reload the application on each server. However, since CFMX is clustered, I've got no idea whether I'm reloading the application on Machine A, Machine B, or Machine C. Is there a solution for this? Am I the only one who is attempting J2EE session sharing? Ack!! Thanks, Jamie ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210226 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can CFMX 6.1 and CFMX 7 co-exist?
Even without J2EE... I use the standalone versions at home, connect them both to IIS with no problems... I had some issues getting the webserver connector to work with 6/6.1 when it came out... I discovered later they were due to my firewall ([EMAIL PROTECTED]) -- the damn thing was turned off when I installed it, but apparently I just can't even install the firewall and still have that stuff work ... anyway... I create a separate website in IIS for cf7 (and use the hosts file to tell the machine that it can find bs at 127.0.0.1) and during the install I just tell it to connect to that site instead of to the default website or to all sites. If you are running J2EE, then the answer is yes. You can deploy each version into thier own instance without any problems at all. -Adam On 6/22/05, Rey Bango [EMAIL PROTECTED] wrote: Can CFMX 6.1 and CFMX 7 co-exist? If so, are there any articles that can point me in the right direction? Rey... s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210228 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: query help
Isaac, thanks man, that works too and looks better than my case statements. Shame on you for thinking I'd even have Access installed on my machine though! It's MySQL. lol... Well it was a random guess based on the use of now() and ID as a column name because that's real common with Access due to it prepopulating the column name with ID if you get the would you like to create a primary key? alert. I was guessing it was a client DB you inherited, since I didn't think you would be creating ID columns. Glad to help. :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210229 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing for undefined
Well - first off you don't need the evaluates in there - you can use normal
notation.
I'll try that, thanks. I try to not use it when I can('t).
Something like this.
cfset the_db = StructNew()
this should've been:
cfset the_db = StructNew()
for it's use below.
cfoutput query=#CurQuery#
cfloop list=#the_db_name.columnlist# index=col
cfset the_db_info[col] = the_db_name[col][currentRow]
/cfloop
/cfoutput
Once that's set I'm confused... you're looping over a known column list so
how could any be column name be undefined?
It's not the column name that's undefined, but it's contents; in other words,
empty, but not an empty quotes. It's the right side of cfset the_db_info[col]
= the_db_name[col][currentRow]
I guess I'm confused with the_db_info variable and what it does... as it
is in your current code it's being used as an indexed object, but it's never
declared as one...
yeah, I meant it to be defined by the structNew on the first line.
even if it were it would end up overwritten with the last
of row of data in any multi-row recordset.
That's ok. This is just going to loop through the recordset and display the
data so I use the same struct for each record, display it and then go on.
To convert a one-row recordset to a struct (which is sorta what your code is
doing) I would do this (this will also work for multi-row record sets but
will only convert the first row):
cfset MyStruct = StructNew() /
cfloop list=#CurQuery.columnlist# index=CurCol
cfset MyStruct[CurCol] = CurQuery[CurCol][1] /
/cfloop
Mine looks like this except for the evaluates and the currentrow that I use.
I'm going to loop through several records so I think my currentrow use is
correct.
I have eliminated the evaluates. They were there because I was using the
database name as a string. I realized I should set the val to the database
instead.
I think I still need to use the string though for the cfoutput
query=#the_db_name# but I should probably take that out of the included file
and just do the variable setting there.
Neat, uh?
yep, very much so. It's making my life much simpler to implement this.
I still have the original problem of testing for undefined.
I'm not sure if any of that actually addresses your problem... but I hope it
does!
thanks for answerin'!
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210230
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How do you tell ColdFusion to execute .html files?
I knew I was right about that. Here are the links you'll need to get it working in either pre or post MX CF installations. Pre-mx: http://www.macromedia.com/cfusion/knowledgebase/index.cfm? id=tn_18214 Post-mx http://www.macromedia.com/cfusion/knowledgebase/index.cfm? id=tn_18289 Ahh... I mised the need for the extra servlet mapping in web.xml because I've never actually assigned something other than .cfm and ..cfc in the iis properties... Good to know for future reference... Thanks Ken. :) I take it from the 2nd mapping in the example having the url-pattern *.dbm/* that you need a mapping like this in order to have url's with query strings that don't start with a question-mark like /index.cfm/thing/3/ instead of /index.cfm?x=thingy=3 ? s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210231 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Paradox Database
So I believe what I need is a paradox JDBC driver for coldfusion to communicate with the client's database (right?). Does anyone know where I might be able to find one? HXTT Paradox, a type 4 JDBC driver, is at www.hxtt.net . ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210232 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Should we support Access?
The original gig was rewriting a couple of templates for them every week or so. I pointed out the issues with Access and made some recommendations and now this is going to be a major part of what is very likely going to be -- slowly but surely -- a rewrite of their entire system. Maybe HXTT Access, a type 4 JDBC driver for MS Access, can help your ColdFusion project since HXTT DBF can cooperate with ColdFusion MX. Those drivers are availabbe at www.hxtt.net . ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210233 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing for undefined
-Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 22, 2005 11:24 AM To: CF-Talk Subject: RE: testing for undefined That's ok. This is just going to loop through the recordset and display the data so I use the same struct for each record, display it and then go on. Now I'm really confused - why do this at all? Is there processing that's not shown? You can display everything as you want using just the query - why waste the time to convert the query to something else to do this? I still have the original problem of testing for undefined. Well - sort of. Queries aren't sparse arrays - their values should always be empty space (although I think exceptions can arise when you build the queries from scratch). I think that cfif MyQuery.Col[Row] NEQ ... defined ... cfelse ... not defined ... /cfif Should do it. However this really isn't defined but empty - CF treats nulls and empty spaces the same in queries. Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210234 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: query help
Yeah, I'm working with a guy who has, as part of his coding guidelines, the requirement that every table in the database have a column named ID that is set as an auto-increment. That's only one of the many fun little guidelines to which we're strictly adhering. As a developer used to working alone or in very small groups most of the time, I'm finding it interesting to work with someone who's formulated some of his own guidelines like this. It's the first time in some years though that I'm not the one responsible for making the guidelines and I'm finding it's a welcome relief. I'm sure It'll get old at some point, but for now it's much less stressful to be the worker bee instead of the manager and main dev lead. I was going to send you this reply off-list, but I realized that this is a good illustration of the reason we need to be flexible with our ability to switch between different methodologies or coding styles. It's an argument, or at least a topic, that comes up pretty often on the list about the best way to do things. Maybe sometimes the more important thing is to be able to adapt to any given set of guidelines or practices and use them efficiently. I'd be in a bad way right now if I didn't have the ability to set aside some of my preconceived notions and adhere to the standards in place. --Ferg S. Isaac Dealey wrote: Isaac, thanks man, that works too and looks better than my case statements. Shame on you for thinking I'd even have Access installed on my machine though! It's MySQL. lol... Well it was a random guess based on the use of now() and ID as a column name because that's real common with Access due to it prepopulating the column name with ID if you get the would you like to create a primary key? alert. I was guessing it was a client DB you inherited, since I didn't think you would be creating ID columns. Glad to help. :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210235 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing for undefined
Is there any way to set a header item in an outgoing CFHTTP request? I'm working with an API that needs a custom header item inserted in a GET request. I'm thinking something like: CFHTTP url=http://server1/xmlnotify.asp; method=GET HTTP_AUTHORIZATION: Digest userName=cseibert nonce=a1faa6e2b8a21722a845926368b4f2f1 /CFHTTP or CFHTTP url=http://sync1.bh-bos2.bullhorn.com/xmlnotify.asp?folderType=1folderName=Contacts; method=GET CFHEADER name=HTTP_AUTHORIZATION value=Digest userName=cseibert nonce=a1faa6e2b8a21722a845926368b4f2f1 /CFHTTP Neither of which seem to work. I know that CFHEADER is used to return headers to the browser, I'm just illustrating the syntax I would like to exists, hehe. Ideas? -Chase Chase Seibert | Network and Systems Engineer | Bullhorn Inc. | 617.464.2440 x119 | www.bullhorn.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210236 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
set headers in CFHTTP?
Sorry for the double-post. I meant to start a new thread. Is there any way to set a header item in an outgoing CFHTTP request? I'm working with an API that needs a custom header item inserted in a GET request. I'm thinking something like: CFHTTP url=http://server1/xmlnotify.asp; method=GET HTTP_AUTHORIZATION: Digest userName=cseibert nonce=a1faa6e2b8a21722a845926368b4f2f1 /CFHTTP or CFHTTP url=http://sync1.bh-bos2.bullhorn.com/xmlnotify.asp?folderType=1folderName=Contacts; method=GET CFHEADER name=HTTP_AUTHORIZATION value=Digest userName=cseibert nonce=a1faa6e2b8a21722a845926368b4f2f1 /CFHTTP Neither of which seem to work. I know that CFHEADER is used to return headers to the browser, I'm just illustrating the syntax I would like to exists, hehe. Ideas? -Chase Chase Seibert | Network and Systems Engineer | Bullhorn Inc. | 617.464.2440 x119 | www.bullhorn.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210237 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: query help
That is an interesting requirement although when I look back I think almost every system I ever worked with had a column named ID in each table. Here at work the inhouse framework they make use us, pretty much requires the PK of a table be just ID and numeric. There are ways around it but they are never used and probably not even known by most. On 6/22/05, Ken Ferguson [EMAIL PROTECTED] wrote: Yeah, I'm working with a guy who has, as part of his coding guidelines, the requirement that every table in the database have a column named ID that is set as an auto-increment. That's only one of the many fun little guidelines to which we're strictly adhering. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210238 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: set headers in CFHTTP?
Is there any way to set a header item in an outgoing CFHTTP request? I'm working with an API that needs a custom header item inserted in a GET request. I'm thinking something like: CFHTTP url=http://server1/xmlnotify.asp; method=GET HTTP_AUTHORIZATION: Digest userName=cseibert nonce=a1faa6e2b8a21722a845926368b4f2f1 /CFHTTP or CFHTTP url=http://sync1.bh-bos2.bullhorn.com/xmlnotify.asp?folderTyp e=1folderName=Contacts method=GET CFHEADER name=HTTP_AUTHORIZATION value=Digest userName=cseibert nonce=a1faa6e2b8a21722a845926368b4f2f1 /CFHTTP Neither of which seem to work. I know that CFHEADER is used to return headers to the browser, I'm just illustrating the syntax I would like to exists, hehe. Ideas? You can use the CFHTTPPARAM tag to set headers, among other things: cfhttp ... cfhttpparam type=header name=AUTHORIZATION value=... /cfhttp 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! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210239 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: set headers in CFHTTP?
On 22 Jun 2005 11:51:01 -0400, Chase Seibert [EMAIL PROTECTED] wrote: Sorry for the double-post. I meant to start a new thread. Is there any way to set a header item in an outgoing CFHTTP request? I'm working with an API that needs a custom header item inserted in a GET request. I'm thinking something like: CFHTTP url=http://server1/xmlnotify.asp; method=GET HTTP_AUTHORIZATION: Digest userName=cseibert nonce=a1faa6e2b8a21722a845926368b4f2f1 /CFHTTP or CFHTTP url=http://sync1.bh-bos2.bullhorn.com/xmlnotify.asp?folderType=1folderName=Contacts; method=GET CFHEADER name=HTTP_AUTHORIZATION value=Digest userName=cseibert nonce=a1faa6e2b8a21722a845926368b4f2f1 /CFHTTP Neither of which seem to work. I know that CFHEADER is used to return headers to the browser, I'm just illustrating the syntax I would like to exists, hehe. Ideas? Does method=HEAD get you where you need to be? Check this page out for more information: http://livedocs.macromedia.com/coldfusion/7/htmldocs/0272.htm Regards, Dave. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210240 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: set headers in CFHTTP?
Does method=HEAD get you where you need to be? I don't see how that would help - that won't automatically add HTTP request headers, it'll simply ask for information about the page instead of asking for the page itself. 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! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210241 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: query help
It's the first time in some years though that I'm not the one responsible for making the guidelines and I'm finding it's a welcome relief. I'm sure It'll get old at some point, but for now it's much less stressful to be the worker bee instead of the manager and main dev lead. I'm trying to move the other direction. :) Are you still managing Fitz and Floyd? I was going to send you this reply off-list, but I realized that this is a good illustration of the reason we need to be flexible with our ability to switch between different methodologies or coding styles. It's an argument, or at least a topic, that comes up pretty often on the list about the best way to do things. Maybe sometimes the more important thing is to be able to adapt to any given set of guidelines or practices and use them efficiently. I'd be in a bad way right now if I didn't have the ability to set aside some of my preconceived notions and adhere to the standards in place. Yeah, the idea that a bad standard is better than no standard... Sometimes it's difficult to find a good balance, though in general I think the reasoning is sound. Html/CSS box models for instance - MS interpretation was better, but it's still better to have one box model to deal with even if that box model isn't as good. And since nobody's advocating a doctype that will force other browsers to use the IE box model I use the doctype that forces IE to use the W3C model. And I still find the variations quite frustrating ... The biggest one for me is centering -- I can't seem for the life of me to get things to center properly in any of hte Mozilla browsers... IE's a dream for this, but I really wish they both behaved the same way, even if it made it more difficult to manage centering, the ability to identify a singular technique that works, even if difficult, would be fantastic... But then adaptation is often at the heart of my work, like in writing the sql abstraction layer for my framework, so that I can have a singular standard for database access. Which ties back into the comment about being able to adapt to a different environment and work with it efficiently, because without that ability to adapt you can't build those sorts of abstractions either. Though I don't get to use my own programming methods in my day job either -- we use other techniques that aren't as flexible but that are getting the job done, so I don't complain (even though could get a lot of this work done faster with a sql abstraction layer for instance) unless I'm being asked for advice on a new technique. :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210242 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing for undefined
You can display everything as you want using just the query - why waste the time to convert the query to something else to do this? I'm trying to make it reusable so that I can include it wherever I need it. If I use the same name everywhere, db_info and then use that in all my queries, then I can repopulate them easily. But that is certainly the way I may end up doing it. I still have the original problem of testing for undefined. Well - sort of. Queries aren't sparse arrays - their values should always be empty space (although I think exceptions can arise when you build the queries from scratch). when I populate that struct, when I set the info to whatever is in the db, the first time it comes to a variable in a form (value='#db_info.blah#') that was populated by an empty column seems to be undefined and I receive an error stating so, on the line that contains the form element. Of course, I won't know that until I can test for undefined and set it to something else. I think that cfif MyQuery.Col[Row] NEQ ... defined ... cfelse ... not defined ... /cfif Should do it. However this really isn't defined but empty - CF treats nulls and empty spaces the same in queries. Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210243 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: comments on HostNexus? DAMIEN
fyi~ you can get imap at hms Thanks, Dave. Yes, I worked out a deal with them for IMAP mail itself (which they normally charge $10/mo for), but they don't provide a version of PHP with IMAP support compiled in without paying $50/mo for a VPS. So far I'm very happy with HostNexus. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210245 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: set headers in CFHTTP?
On 6/22/05, Dave Watts [EMAIL PROTECTED] wrote: Does method=HEAD get you where you need to be? I don't see how that would help - that won't automatically add HTTP request headers, it'll simply ask for information about the page instead of asking for the page itself. Yeah, I was too quick to reply. I saw headers in the message and thought method=HEAD. Sorry about that. Regards, Dave. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210244 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: set headers in CFHTTP?
Yeah, I was too quick to reply. I saw headers in the message and thought method=HEAD. Sorry about that. No need to apologize, we all make mistakes. 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! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210246 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: application.cfm includes
Do it the other way. In your subdirectory have this: cfset sessionTimeout = createTimeSpan(0, 1, 0, 0) / cfinclude template=../Application.cfm / and then in your root have this: cfparam name=sessionTimeout default=#CreateTimeSpan(0,0,30,0)# / cfapplication ... sessionTimeout=#sessionTimeout# / Sorry, I was't very clear with whether I was talking about 'sessionTimeout' the variable, or 'sessionTimeout' the CFAPPLICATION attribute. That make more sense now? I believe the multiple CFAPPLICATION tags will work without issue, but it seems wrong to do it that way (because you're effectively declaring your application multiple times). cheers, barneyb On 6/22/05, daniel kessler [EMAIL PROTECTED] wrote: It's the former. I get most of what you're saying. Are you saying that I should just have a sessiontimeout in the timeout in the application.cfm file: other info cfapplication sessionmanagement=yes setclientcookies=yes name=db_storage sessiontimeout=#CreateTimeSpan(0,0,30,0)# then include that file into another one and just have the same line in the new file with a new timeout? cfapplication sessiontimeout=#CreateTimeSpan(0,1,0,0)# and it'll overwrite the previous timeout for that directory? -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210247 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing for undefined
-Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 22, 2005 12:48 PM To: CF-Talk Subject: RE: testing for undefined You can display everything as you want using just the query - why waste the time to convert the query to something else to do this? I'm trying to make it reusable so that I can include it wherever I need it. If I use the same name everywhere, db_info and then use that in all my queries, then I can repopulate them easily. But that is certainly the way I may end up doing it. I think you're better off - you can still make a generic query displayer using the indexed notation without conversion. I still have the original problem of testing for undefined. Well - sort of. Queries aren't sparse arrays - their values should always be empty space (although I think exceptions can arise when you build the queries from scratch). when I populate that struct, when I set the info to whatever is in the db, the first time it comes to a variable in a form (value='#db_info.blah#') that was populated by an empty column seems to be undefined and I receive an error stating so, on the line that contains the form element. Of course, I won't know that until I can test for undefined and set it to something else. Weird. Are you talking about an empty column or cell? If a column then wouldn't the whole query be empty? If a cell then it should be empty string not undefined... It's probably worth exploring, but since I really don't think you need the conversion at all it's probably a moot point. Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210248 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
JRUNSVC + coldfusion 6.1 Mx + mysql 4.0.24 CPU 100%
Hello every body, I need help, I've a big problem under my configuration about jrunsvc (jrun service). Every 1 hour since 15 minutes the jrunsvc takes 100% cpu time. I've try lot of things to fix like update (updater 5 from macromedia, j2se 1.4.2, etc .) but the problem persiste. An other thing, I've try to put the mysql version 4.1.12 (I think the last release) I have import all my databases in the new version of mysql .. All was okay, but When I've restarted coldfusion 6.1 MX msql-nt service takes 100% CPU Time... I've a big problem and no solution . Maybe someone have an idea Thanx a lot ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210249 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
ColdFusion server crashes every few days
Can someone tell me what would make a coldfusion server to crash every few days or so. It seems the CF server memory utilization on the server keeps increasing and we need to restart the coldFusion server before anything would work. I do have a coldFusion scheduled job that runs every 5 minutes to call a .NET web service. This web service runs very quick. Less then one minute. I also have another application that uses session variables. Could these be causing me the grief? Any help/comments on this would be greatly appreciated. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210250 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
ColdFusion server crashes every few days
Are you caching any information or the webservice connection? Can someone tell me what would make a coldfusion server to crash every few days or so. It seems the CF server memory utilization on the server keeps increasing and we need to restart the coldFusion server before anything would work. I do have a coldFusion scheduled job that runs every 5 minutes to call a .NET web service. This web service runs very quick. Less then one minute. I also have another application that uses session variables. Could these be causing me the grief? Any help/comments on this would be greatly appreciated. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210251 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
ColdFusion Error Messages
Maybe its just my printer, but when I try and print out a page with a ColdFusion generated error on it, I get the HTML not the message... has anyone else noticed this? If a user gets an error message, they usually either take a screenshot or print it out- but printing it out yields some ugly results. --Bob -- Need Web Hosting or Internet Services? Visit http://www.jaguNET.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210252 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion Error Messages
If a user gets an error message, they usually either take a screenshot or print it out- but printing it out yields some ugly results. I have the same problem here - but only with IE. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210253 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: JRUNSVC + coldfusion 6.1 Mx + mysql 4.0.24 CPU 100%
does it spike before requests come in? Or after? Is it spiking under heavy load or light load? Have you turned on 'log slow pages taking x seconds?? Turn this on and set to say 10 to 20 seconds and see what pages are hogging up CF. DK On 6/22/05, Jean-Michel DE FILIPPI [EMAIL PROTECTED] wrote: Hello every body, I need help, I've a big problem under my configuration about jrunsvc (jrun service). Every 1 hour since 15 minutes the jrunsvc takes 100% cpu time. I've try lot of things to fix like update (updater 5 from macromedia, j2se 1.4.2, etc .) but the problem persiste. An other thing, I've try to put the mysql version 4.1.12 (I think the last release) I have import all my databases in the new version of mysql .. All was okay, but When I've restarted coldfusion 6.1 MX msql-nt service takes 100% CPU Time... I've a big problem and no solution . Maybe someone have an idea Thanx a lot ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210254 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Query of Queries error
I am trying to join two sets of data using query of queries. I've read the livedocs and search the HoF archives and haven't been able to figure out a way to handle this. My problem is that I run the query at the end of this massage and get the following error: Query Of Queries runtime error. Can't convert the string 13207A to java type LONG QoQ is making the column be the wrong type. I need to to be a string type, but the first record has a numeric value as the order ID. Any suggestions on how to force the type in QoQ? One data set is coming from a database and another is a query built from a csv file. I could write the csv data to a database table first and then work on it from there, but I'd rather avoid that if possible. I have a CF5 server and a 6.1 server on which I can run this process. Thanks! -Jeff cfquery dbtype=query name=combineOrderData SELECT getOrders.OrderDetail_ID, getOrders.Order_ID, getOrders.Qty, getOrders.ProductTitle, getOrders.OptTitles, getOrders.realPartNumber, shippedOrderData.whsorderno, shippedOrderData.shipdate, shippedOrderData.trackno, shippedOrderData.ordered, shippedOrderData.shipped, shippedOrderData.line, shippedOrderData.freightcharge FROMgetOrders, shippedOrderData WHERE getOrders.Order_ID = shippedOrderData.Order_ID AND getOrders.realPartNumber = shippedOrderData.product ORDER BY getOrders.Order_ID /cfquery ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210255 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: J2EE Session Sharing without Cluster? -- more frustration
by CFMX cluster you are speaking of SOFTWARE based clustering in JRun, not a load balancer correct? Try this code below, it will tell you what instance you are on. I use this. Its a real PITA though to make sure you are on instance foo or goo. !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN html head titleUntitled/title /head body cfobject action=create type=java class=jrunx.kernel.JRun name=jr / cfset servername = jr.getServerName() / pcfoutputJRun Server Name: #servername#/cfoutput/p /body /html Now, another solution, one I am getting ready to use: In my JRun cluster, I have the internal webserver turned on for each instance. You need to do this anyway to get at the CFAdmin tool per instance. I am planning on dropping code in the internal server web root for each instance to refresh app scopes and such. DK On 6/22/05, jacksonj @ calib. com jacksonj @ calib. com [EMAIL PROTECTED] wrote: Is it possible to share sessions without clustering? (I'd like to be able to know that when I'm hitting Server A, that the application I'm seeing is coming from Server A. This is for hardware load-balancing and fail-over reasons.) Here's a real world example: Sometimes, I need to reload my applications, which I do via a url parameter that clears cached queries, application variables, etc. Normally (without a cluster), I have a separate domains that hit each individual server on my load-balanced farm, and I can reload the application on each server. However, since CFMX is clustered, I've got no idea whether I'm reloading the application on Machine A, Machine B, or Machine C. Is there a solution for this? Am I the only one who is attempting J2EE session sharing? Ack!! Thanks, Jamie ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210256 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query of Queries error
Upgrade to CFMX 7? I know, that is not really an answer, but this is one of the many improvements in MX 7, the ability to type QofQ columns which did not exist in previous versions. Assuming this is not an option, you are going to have to do something to force the issue, can you possible sort one of the original queries so that the first row is clearly a string? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning -Original Message- From: Jeff Langevin [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 22, 2005 10:59 AM To: CF-Talk Subject: Query of Queries error I am trying to join two sets of data using query of queries. I've read the livedocs and search the HoF archives and haven't been able to figure out a way to handle this. My problem is that I run the query at the end of this massage and get the following error: Query Of Queries runtime error. Can't convert the string 13207A to java type LONG QoQ is making the column be the wrong type. I need to to be a string type, but the first record has a numeric value as the order ID. Any suggestions on how to force the type in QoQ? One data set is coming from a database and another is a query built from a csv file. I could write the csv data to a database table first and then work on it from there, but I'd rather avoid that if possible. I have a CF5 server and a 6.1 server on which I can run this process. Thanks! -Jeff cfquery dbtype=query name=combineOrderData SELECT getOrders.OrderDetail_ID, getOrders.Order_ID, getOrders.Qty, getOrders.ProductTitle, getOrders.OptTitles, getOrders.realPartNumber, shippedOrderData.whsorderno, shippedOrderData.shipdate, shippedOrderData.trackno, shippedOrderData.ordered, shippedOrderData.shipped, shippedOrderData.line, shippedOrderData.freightcharge FROMgetOrders, shippedOrderData WHERE getOrders.Order_ID = shippedOrderData.Order_ID AND getOrders.realPartNumber = shippedOrderData.product ORDER BY getOrders.Order_ID /cfquery ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210257 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query of Queries error
Jeff, One of your original queries (that pull from the DB) sees the join column as a numeric type. re-cast it as a string type in the original query. Here's an MS SQL example. cast(realPartNumber AS varchar(12)) AS realPartnumber What DB are you using? This should cause the recordset object to see it as a string. -mark Mark A. Kruger, CFG, MCSE www.cfwebtools.com www.necfug.com http://mkruger.cfwebtools.com -Original Message- From: Jeff Langevin [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 22, 2005 12:59 PM To: CF-Talk Subject: Query of Queries error I am trying to join two sets of data using query of queries. I've read the livedocs and search the HoF archives and haven't been able to figure out a way to handle this. My problem is that I run the query at the end of this massage and get the following error: Query Of Queries runtime error. Can't convert the string 13207A to java type LONG QoQ is making the column be the wrong type. I need to to be a string type, but the first record has a numeric value as the order ID. Any suggestions on how to force the type in QoQ? One data set is coming from a database and another is a query built from a csv file. I could write the csv data to a database table first and then work on it from there, but I'd rather avoid that if possible. I have a CF5 server and a 6.1 server on which I can run this process. Thanks! -Jeff cfquery dbtype=query name=combineOrderData SELECT getOrders.OrderDetail_ID, getOrders.Order_ID, getOrders.Qty, getOrders.ProductTitle, getOrders.OptTitles, getOrders.realPartNumber, shippedOrderData.whsorderno, shippedOrderData.shipdate, shippedOrderData.trackno, shippedOrderData.ordered, shippedOrderData.shipped, shippedOrderData.line, shippedOrderData.freightcharge FROMgetOrders, shippedOrderData WHERE getOrders.Order_ID = shippedOrderData.Order_ID AND getOrders.realPartNumber = shippedOrderData.product ORDER BY getOrders.Order_ID /cfquery ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210258 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: J2EE Session Sharing without Cluster? -- more frustration
by CFMX cluster you are speaking of SOFTWARE based clustering in JRun, not a load balancer correct? Try this code below, it will tell you what instance you are on. I use this. Its a real PITA though to make sure you are on instance foo or goo. cfobject action=create type=java class=jrunx.kernel.JRun name=jr / cfset servername = jr.getServerName() / pcfoutputJRun Server Name: #servername#/cfoutput/p Yes, I'm currently using that code to tell me *which* machine I'm actually updating; However I just have to keep hitting the page until I have eventually hit both Machine A and Machine B (it's luck of the draw, since I can *know* which machine I'm on, but I can't *specify* which machine to be on). This is obviously not ideal, but is my current, temporary workaround. Now, another solution, one I am getting ready to use: In my JRun cluster, I have the internal webserver turned on for each instance. You need to do this anyway to get at the CFAdmin tool per instance. I am planning on dropping code in the internal server web root for each instance to refresh app scopes and such. DK We were thinking of going that route, too, since that's the only way we can think of to hit a specific instance. It's a pain to have to do this for app-specific (not general CFMX) reloading, though. (Some of my apps have different interpretations for what reloading the application means: some purge app-specific files, or do other fine-grained things.) Since I already have a hardware load balancer, it would be ideal if I could keep sharing J2EE *sessions* but not the application themselves. I'd sure like a definitive answer, if anybody knows it. If this isn't possible, is there some other way to achieve the same overall goal? Thanks for your reply, Douglas, it's nice to know that somebody else is giving this J2EE session sharing thing a shot. BTW, were you surprised to see your Machine A serving up Machine B's code when you first enabled session sharing? I sure was. :-/ Thanks, Jamie ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210259 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion Error Messages
Sounds like a bug then. If a user gets an error message, they usually either take a screenshot or print it out- but printing it out yields some ugly results. I have the same problem here - but only with IE. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210260 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: J2EE Session Sharing without Cluster? -- more frustration
I actually have session sharing off now, using sticky sessions. Yeah, it was pretty kewl when I had it enabled. The issue we had was with the charting engine and we had one app where the developer stored CFCs in the session scope. The charting engine will not work with session sharing on and sticky sessions off. You can work around it by using the NAME attribute of the chart tag and cffile I suppose, but we had no resources to change the code around here. Either way, its really a neato thing to have setup. Now, if I was only lucky enought to have CF7 nowlong storysetting up an instance and cluster is point and click easy in CF7. DK On 6/22/05, jacksonj @ calib. com jacksonj @ calib. com [EMAIL PROTECTED] wrote: by CFMX cluster you are speaking of SOFTWARE based clustering in JRun, not a load balancer correct? Try this code below, it will tell you what instance you are on. I use this. Its a real PITA though to make sure you are on instance foo or goo. cfobject action=create type=java class=jrunx.kernel.JRun name=jr / cfset servername = jr.getServerName() / pcfoutputJRun Server Name: #servername#/cfoutput/p Yes, I'm currently using that code to tell me *which* machine I'm actually updating; However I just have to keep hitting the page until I have eventually hit both Machine A and Machine B (it's luck of the draw, since I can *know* which machine I'm on, but I can't *specify* which machine to be on). This is obviously not ideal, but is my current, temporary workaround. Now, another solution, one I am getting ready to use: In my JRun cluster, I have the internal webserver turned on for each instance. You need to do this anyway to get at the CFAdmin tool per instance. I am planning on dropping code in the internal server web root for each instance to refresh app scopes and such. DK We were thinking of going that route, too, since that's the only way we can think of to hit a specific instance. It's a pain to have to do this for app-specific (not general CFMX) reloading, though. (Some of my apps have different interpretations for what reloading the application means: some purge app-specific files, or do other fine-grained things.) Since I already have a hardware load balancer, it would be ideal if I could keep sharing J2EE *sessions* but not the application themselves. I'd sure like a definitive answer, if anybody knows it. If this isn't possible, is there some other way to achieve the same overall goal? Thanks for your reply, Douglas, it's nice to know that somebody else is giving this J2EE session sharing thing a shot. BTW, were you surprised to see your Machine A serving up Machine B's code when you first enabled session sharing? I sure was. :-/ Thanks, Jamie ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210261 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Getting CFMX7 code sample access
I have CFMX 7 sitting on a development server and I purposely installed the samples and docs so I could have internal access to them. This is not a production server, solely for development. When I try to hit the url for the Getting Started Experience, it halts saying that I'm trying to access the pages from something other than 127.0.0.1 or localhost. Is there a way to get around this? Rey... -- http://www.ReyBango.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210262 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
ColdFusion server crashes every few days
Try this out: http://www.robisen.com/index.cfm?mode=entryentry=FD4BE2FC-55DC-F2B1-FED0717CC1C7E0AF ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210263 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Getting CFMX7 code sample access
I think this is controlled in the application.cfm/cfc file. M!ke -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 22, 2005 2:10 PM To: CF-Talk Subject: Getting CFMX7 code sample access I have CFMX 7 sitting on a development server and I purposely installed the samples and docs so I could have internal access to them. This is not a production server, solely for development. When I try to hit the url for the Getting Started Experience, it halts saying that I'm trying to access the pages from something other than 127.0.0.1 or localhost. Is there a way to get around this? Rey... ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210264 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Getting CFMX7 code sample access
I have CFMX 7 sitting on a development server and I purposely installed the samples and docs so I could have internal access to them. This is not a production server, solely for development. When I try to hit the url for the Getting Started Experience, it halts saying that I'm trying to access the pages from something other than 127.0.0.1 or localhost. Is there a way to get around this? I think unfortunately if you're using the developer edition of CF the only way around that is to work directly on the server... hrm... wait... they added a 2nd ip address in 7 didn't they? It's probably documented somewhere, but offhand I don't know where... but I believe you can configure a 2nd ip address now. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210265 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Getting CFMX7 code sample access
Hi Issac. This is a fully licensed server and not a developer edition. Would you happen to know if in the full version there's a way to get around this limitation? It was implemented in CF 5.0 to prevent access to sample code after a big security issue cropped up. Rey... S. Isaac Dealey wrote: I have CFMX 7 sitting on a development server and I purposely installed the samples and docs so I could have internal access to them. This is not a production server, solely for development. When I try to hit the url for the Getting Started Experience, it halts saying that I'm trying to access the pages from something other than 127.0.0.1 or localhost. Is there a way to get around this? I think unfortunately if you're using the developer edition of CF the only way around that is to work directly on the server... hrm... wait... they added a 2nd ip address in 7 didn't they? It's probably documented somewhere, but offhand I don't know where... but I believe you can configure a 2nd ip address now. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210266 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion Error Messages
Figures- just tried to report it as such and the email bounced back- their bug reporting form points to a invalid email address. Sounds like a bug then. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210267 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion Error Messages
I have had the same problem - with several versions of CF - CF4.5, CF5.0, CF6.1, they all do it. I thought it was some kind of functionality thing that I didn't understand the point of, but was necessary for some reason or another. I would think that if it were a bug, then it would have been fixed long ago Ray Damien McKenna wrote: If a user gets an error message, they usually either take a screenshot or print it out- but printing it out yields some ugly results. I have the same problem here - but only with IE. -- = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210268 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: JRUNSVC + coldfusion 6.1 Mx + mysql 4.0.24 CPU 100%
The hourly nature of the high CPU sounds like client variable purging. You could try turning off client variable purge for a few hours to see if that changes the behavior. If it does, then that means that your client variable entries in the datebase (or registry, ugh) might be extremely high, so might want to write a custom script to purge a bunch of the older ones instead of letting CF skim the top off them. See also: CFMX 6.1 http://www.macromedia.com/go/tn_19279 CFMX 6.1 Updater 1 http://www.macromedia.com/go/tn_19590 -Steven Erat On 6/22/05, Jean-Michel DE FILIPPI [EMAIL PROTECTED] wrote: Hello every body, I need help, I've a big problem under my configuration about jrunsvc (jrun service). Every 1 hour since 15 minutes the jrunsvc takes 100% cpu time. I've try lot of things to fix like update (updater 5 from macromedia, j2se 1.4.2, etc .) but the problem persiste. An other thing, I've try to put the mysql version 4.1.12 (I think the last release) I have import all my databases in the new version of mysql .. All was okay, but When I've restarted coldfusion 6.1 MX msql-nt service takes 100% CPU Time... I've a big problem and no solution . ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210269 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfform_flash in shared hosting environment cfform_flash: invalid xhtml
Hi, I just started releasing my application, got some problems that I didn't expect (like dsnUser,dsnPass..), mostly because it's running in a shared hosting-environment.. Well, I googled about some things, but I've still two questions, maybe someone knows.. My flashForms are not generated, I think, the problem is because /CFIDE cannot be accessed/isn't mapped in my account on the server. So, as I sayed, my site is in a shared hosting env., does it solve the problem to create a mapping by the administrator?? any experiences? heres the beta-release (all flash forms, none showing:) http://www.friendcom.de/index.cfm?lang=2 (just a private project, still releasing..) The second problem is that the code generated by cfform is not xhtml-valid. I read something in the macromedia-livedocs from Sean Corfield (http://livedocs.macromedia.com/wtg/public/coding_standards/style.html -- near the bottom) SeanCorfield said on Jul 22, 2004 at 10:14 AM : The non-compliance of code generated by CFFORM is a known issue that will be addressed in a future release. Is there anything I can do against? :) -- Sebastian Mork [EMAIL PROTECTED] ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210270 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion Error Messages
I have had the same problem - with several versions of CF - CF4.5, CF5.0, CF6.1, they all do it. I thought it was some kind of functionality thing that I didn't understand the point of, but was necessary for some reason or another. I would think that if it were a bug, then it would have been fixed long ago I don't think they antiscipate a lot of people will be printing the error messages actually, so if it were a bug it might have just been ignored. Personally I don't find printing them very useful. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210271 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Getting CFMX7 code sample access
Hi Issac. This is a fully licensed server and not a developer edition. Would you happen to know if in the full version there's a way to get around this limitation? It was implemented in CF 5.0 to prevent access to sample code after a big security issue cropped up. Oh okay... I hadn't heard about that... so the closest thing that came to my mind was the IP address limitation with developer editions... no, I don't have any thoughts... sorry... s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210272 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfform_flash in shared hosting environment cfform_flash: invalid xhtml
The quick and dirty solution for you in this case is to upload the scripts directory from your cf admin. Then use the scriptsrc attribute on your cfform to point it at it locally. Then you dont have to worry about the admin and what they will map. I use this on my servers and it works great. Good luck simeon On 6/22/05, Sebastian Mork [EMAIL PROTECTED] wrote: Hi, I just started releasing my application, got some problems that I didn't expect (like dsnUser,dsnPass..), mostly because it's running in a shared hosting-environment.. Well, I googled about some things, but I've still two questions, maybe someone knows.. My flashForms are not generated, I think, the problem is because /CFIDE cannot be accessed/isn't mapped in my account on the server. So, as I sayed, my site is in a shared hosting env., does it solve the problem to create a mapping by the administrator?? any experiences? heres the beta-release (all flash forms, none showing:) http://www.friendcom.de/index.cfm?lang=2 (just a private project, still releasing..) The second problem is that the code generated by cfform is not xhtml-valid. I read something in the macromedia-livedocs from Sean Corfield (http://livedocs.macromedia.com/wtg/public/coding_standards/style.html -- near the bottom) SeanCorfield said on Jul 22, 2004 at 10:14 AM : The non-compliance of code generated by CFFORM is a known issue that will be addressed in a future release. Is there anything I can do against? :) -- Sebastian Mork [EMAIL PROTECTED] ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210273 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
search broken on house of fusion?
Anyone else notice that the search on this site doesnt seem to work anymore? Search for previous posts that you've been tracking or posting to doesnt work even with quotes. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210274 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF linux questions
I was involved in a discussion earlier today about the feasibility of building a control panel like solution to allow for users to maintain items like domains, emails, etc. (think cpanel) on the linux platform. Not being a linux person myself I was trying to find resources speaking to the following: -Is there a way for cold fusion to have root level access without being run under the root user? i.e. some way to mimic the permissions. -If no, what are the explicit security concerns, if any, of allowing cold fusion to run under root -Are these items things that can actually be accessed and scripted via cold fusion. Anyone have any good articles that would address this, google isn't coming back with much for me. Thanks, Scott --- [This E-mail scanned for viruses by Declude Virus. Service provided by Accurate Imaging, Inc.] ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210275 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion Error Messages
I don't either, but back in the day (..cringe..) before I knew better, before learning about error handling, my clients would print and fax the error to me when they came across one. It was a nightmare to decipher what was going on. And, since I sucked, there were a lot of faxes coming in. Now, though, the error just gets emailed to me. Much better! :) S. Isaac Dealey wrote: I have had the same problem - with several versions of CF - CF4.5, CF5.0, CF6.1, they all do it. I thought it was some kind of functionality thing that I didn't understand the point of, but was necessary for some reason or another. I would think that if it were a bug, then it would have been fixed long ago I don't think they antiscipate a lot of people will be printing the error messages actually, so if it were a bug it might have just been ignored. Personally I don't find printing them very useful. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210276 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: search broken on house of fusion?
Can you send me an exact example of what your searching for? The search is based on Google and it might be that the code going to Google is broken. Thanks Anyone else notice that the search on this site doesnt seem to work anymore? Search for previous posts that you've been tracking or posting to doesnt work even with quotes. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210277 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: JRUNSVC + coldfusion 6.1 Mx + mysql 4.0.24 CPU 100%
That brings up a good point, Doug. The best way to troubleshoot a stalled CF server is to take a thread dump/stack trace. You do this by starting CF from command line, something like this on windows: c:/ cfusionmx\bin\cfstart.bat c:\cf_output_log.txt Take a normal dump (ctrl+break) when the server is working and serving pages. Examine the output text file, then, when it stalls, take another one. You should be able to look into every thread to find exactly what's running. When you finally find the stalled thread(s), you should be able to pinpoint the problem -nathan strutz Douglas Knudsen wrote: does it spike before requests come in? Or after? Is it spiking under heavy load or light load? Have you turned on 'log slow pages taking x seconds?? Turn this on and set to say 10 to 20 seconds and see what pages are hogging up CF. DK On 6/22/05, Jean-Michel DE FILIPPI [EMAIL PROTECTED] wrote: Hello every body, I need help, I've a big problem under my configuration about jrunsvc (jrun service). Every 1 hour since 15 minutes the jrunsvc takes 100% cpu time. I've try lot of things to fix like update (updater 5 from macromedia, j2se 1.4.2, etc .) but the problem persiste. An other thing, I've try to put the mysql version 4.1.12 (I think the last release) I have import all my databases in the new version of mysql .. All was okay, but When I've restarted coldfusion 6.1 MX msql-nt service takes 100% CPU Time... I've a big problem and no solution . Maybe someone have an idea Thanx a lot ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210279 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion Error Messages
Personally I don't find printing them very useful. Me either, but most people feel they have to print something or forward you an entire email (the original of which you already received) to say I agree or make it so. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210278 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Getting CFMX7 code sample access
Did you try removing the conditional logic in the application.cfm/cfc file? In earlier versions, that is where this was controlled. I haven't tried it with CF7 yet, however. M!ke -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 22, 2005 2:44 PM To: CF-Talk Subject: Re: Getting CFMX7 code sample access Hi Issac. This is a fully licensed server and not a developer edition. Would you happen to know if in the full version there's a way to get around this limitation? It was implemented in CF 5.0 to prevent access to sample code after a big security issue cropped up. Oh okay... I hadn't heard about that... so the closest thing that came to my mind was the IP address limitation with developer editions... no, I don't have any thoughts... sorry... ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210280 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF linux questions
Scott Mulholland wrote: I was involved in a discussion earlier today about the feasibility of building a control panel like solution to allow for users to maintain items like domains, emails, etc. (think cpanel) on the linux platform. Not being a linux person myself I was trying to find resources speaking to the following: -Is there a way for cold fusion to have root level access without being run under the root user? i.e. some way to mimic the permissions. yes, cold fusion has the ability to create files even as a non root user. On Linux systems, could fusion could be used to write Linux shell scripts. From there, you can have a root cron job that runs the shell scripts as root. -If no, what are the explicit security concerns, if any, of allowing cold fusion to run under root There are always security concerns when running anything as root, but if the project is seen by several people, and evaluated for security issues by several, knowledgeable developers, the chances of a security hole diminish. -Are these items things that can actually be accessed and scripted via cold fusion. yes. Cold fusion can be programmed to filter dangerous content. Many CFers already do this with user input, so it's nothing new. Anyone have any good articles that would address this, google isn't coming back with much for me. You've probably just accessed the best resource for this... (A CF-based mailing list) where do you think google gets half it's useful content. ;) Thanks, Scott I like the idea of a Cold Fusion based control panel, and I made one using the strategy outlined above before I worked for Vivio. The project was developed for the Community College I was working for, and was made open source here: https://sourceforge.net/projects/wwccwebmanager/ Unfortunately, the site only hosts version 1.1 and 1.0. There was a 1.2 which was vastly more user friendly, etc, but I was unable to get that on SF before I quit to join Vivio. The project was released under the GPL, so you're welcome to take a look at it. -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210281 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query of Queries error
The problem is that the offending data is in the csv file which is being turned into a query result using QuerySetCell(). That doesn't support setting a type. If I do the cast in the other query, QoQ throws an error saying that the comparison of the two different data types is not supported... Oh if only we could move to 7. But that is not an option. --Jeff On 6/22/2005 2:06 PM, Mark A Kruger wrote: Jeff, One of your original queries (that pull from the DB) sees the join column as a numeric type. re-cast it as a string type in the original query. Here's an MS SQL example. cast(realPartNumber AS varchar(12)) AS realPartnumber What DB are you using? This should cause the recordset object to see it as a string. -mark Mark A. Kruger, CFG, MCSE www.cfwebtools.com www.necfug.com http://mkruger.cfwebtools.com -Original Message- From: Jeff Langevin [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 22, 2005 12:59 PM To: CF-Talk Subject: Query of Queries error I am trying to join two sets of data using query of queries. I've read the livedocs and search the HoF archives and haven't been able to figure out a way to handle this. My problem is that I run the query at the end of this massage and get the following error: Query Of Queries runtime error. Can't convert the string 13207A to java type LONG QoQ is making the column be the wrong type. I need to to be a string type, but the first record has a numeric value as the order ID. Any suggestions on how to force the type in QoQ? One data set is coming from a database and another is a query built from a csv file. I could write the csv data to a database table first and then work on it from there, but I'd rather avoid that if possible. I have a CF5 server and a 6.1 server on which I can run this process. Thanks! -Jeff cfquery dbtype=query name=combineOrderData SELECT getOrders.OrderDetail_ID, getOrders.Order_ID, getOrders.Qty, getOrders.ProductTitle, getOrders.OptTitles, getOrders.realPartNumber, shippedOrderData.whsorderno, shippedOrderData.shipdate, shippedOrderData.trackno, shippedOrderData.ordered, shippedOrderData.shipped, shippedOrderData.line, shippedOrderData.freightcharge FROMgetOrders, shippedOrderData WHERE getOrders.Order_ID = shippedOrderData.Order_ID AND getOrders.realPartNumber = shippedOrderData.product ORDER BY getOrders.Order_ID /cfquery ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210282 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Getting CFMX7 code sample access
That did it bud. Don't know why I didn't bother to look. I just assumed they were encrypted. duh! Rey,,, Dawson, Michael wrote: Did you try removing the conditional logic in the application.cfm/cfc file? In earlier versions, that is where this was controlled. I haven't tried it with CF7 yet, however. M!ke -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 22, 2005 2:44 PM To: CF-Talk Subject: Re: Getting CFMX7 code sample access Hi Issac. This is a fully licensed server and not a developer edition. Would you happen to know if in the full version there's a way to get around this limitation? It was implemented in CF 5.0 to prevent access to sample code after a big security issue cropped up. Oh okay... I hadn't heard about that... so the closest thing that came to my mind was the IP address limitation with developer editions... no, I don't have any thoughts... sorry... ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210283 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
