Cfgrid on CFMX 6.1
I've just moved an app from CF4.5 to CFMX 6.1. All seems fine except for CFGRID. It is displaying fine but when i update the grid im getting the following error message: Error casting an object of type to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way than it was designed This only happens when i change a value. If i don't change anything and hit submit all seems fine. Is it possible to write a SQL update for cfgrid or does it have to go through cfgridupdate? Cheers Andy J www.andyjarrett.co.uk ~| 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:193050 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
Coldfusion VS ASP.NET use
I found this graph a while back, and I am looking to see if there are any other sites that show the graph of technology use that is more up to date? http://news.netcraft.com/archives/2004/03/23/aspnet_overtakes_jsp_and_java_servlets.html I am trying to get some figures on overall usage of CF on websites. Anybody got something like that knocking round? -- Mark Drew coldfusion and cfeclipse blogged: http://cybersonic.blogspot.com/ fusebox plugin for cfeclipse: http://cfopen.org/projects/fusebox3cfe/ ~| 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:193051 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: Cfgrid on CFMX 6.1
Hi there is some Hot fix for CFgrid iuuse in CFmx try install hotfix On Fri, 4 Feb 2005 08:58:25 +, Andy Jarrett [EMAIL PROTECTED] wrote: I've just moved an app from CF4.5 to CFMX 6.1. All seems fine except for CFGRID. It is displaying fine but when i update the grid im getting the following error message: Error casting an object of type to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way than it was designed This only happens when i change a value. If i don't change anything and hit submit all seems fine. Is it possible to write a SQL update for cfgrid or does it have to go through cfgridupdate? Cheers Andy J www.andyjarrett.co.uk ~| 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:193052 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
Server side printing
Can anyone suggest how an Intranet user can send a PDF or text file to be printed on a specific printer from the server side? I'm thinking specifically about printing labels on a Dymo Labelwriter 330 USB which is on a box on the network. This is with CF5 / Win2K3 Thanks -- Regards; Richard Meredith-Hardy - r[dot]mh[at]flymicro[dot]com Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668 ~| 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:193053 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: Cfgrid on CFMX 6.1
Thanks for that, I've found some relating to the certificate on cfform but nothing directly to do with CFMX 6.1 and my error. I was looking at http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17883 Andy On Fri, 4 Feb 2005 17:27:03 +0530, sathya v [EMAIL PROTECTED] wrote: Hi there is some Hot fix for CFgrid iuuse in CFmx try install hotfix On Fri, 4 Feb 2005 08:58:25 +, Andy Jarrett [EMAIL PROTECTED] wrote: I've just moved an app from CF4.5 to CFMX 6.1. All seems fine except for CFGRID. It is displaying fine but when i update the grid im getting the following error message: Error casting an object of type to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way than it was designed This only happens when i change a value. If i don't change anything and hit submit all seems fine. Is it possible to write a SQL update for cfgrid or does it have to go through cfgridupdate? Cheers Andy J www.andyjarrett.co.uk ~| 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:193054 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: CF5 to CFMX - CFUSION_DISABLE_DBCONNECTIONS and MS Excel data sources
Earl, George wrote: Has anyone else figured out how to get from CFMX the same functionality with MS Excel that CFUSION_DISABLE_DBCONNECTIONS provides in CF5? And Jochem replied: Yes, but the process involves undocumented features and even the temporary shutdown of the datasource service. You should really consider all other options before you try it in production: http://www1.oli.tudelft.nl/jochemd/index.cfm?PageID=12 Ouch. That's pretty drastic - I think we need to find another solution. Thanks for your input, you have saved me many more hours of surfing/research . . . Pardon my ignorance, but can we speculate why MM removed the CFUSION_DISABLE_DBCONNECTIONS function (and other related functions) from CFMX? Does it have to do with Java? Or does it have to do with security? cfinsert_cf_community Jochem - I keep wanting to ask how is it that you seem to be so in touch with U.S. television shows when you are over there in .nl? :-) /cfinsert_cf_community George [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:193056 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: Slightly OT: XHTML (was Re: cfset ?)
Actually xHTML works fine in IE provided it is xHTML 1.0 served as text through a mime type of text/html. It's the xhtml served as : application/xhtml+xml, application/xml or text/xml that causes problems in IE.(That's why I can't go to xHTML 1.1 since it has to be served with one of those mime types.) http://www.w3.org/International/articles/serving-xhtml/ Just remember to dump the prolog when serving xHTML (?xml version=1.0 encoding=utf-8?). It throws IE into quirks mode. (Quirks mode = non cross browser rendering compatibility and is not to be desired). cf_northeasternshout Hallelujah! They are listening! /cf_northeasternshout Sandy -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 2:48 AM To: CF-Talk Subject: RE: Slightly OT: XHTML (was Re: cfset ?) XHTML is still unsupported by IE, so if you need to develop for IE, use quirks mode at least, or stick to 4.01 Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: vrijdag 4 februari 2005 3:53 To: CF-Talk Subject: RE: Slightly OT: XHTML (was Re: cfset ?) TinyMCE outputs XHTML, so no problems there... -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Friday, 4 February 2005 10:37 To: CF-Talk Subject: RE: Slightly OT: XHTML (was Re: cfset ?) From: Charlie Griefer [mailto:[EMAIL PROTECTED] cleaning up the deprecated tags like font and the like will also really clean up the code (and by putting all of the presentation code into css, your pages will load that much faster)! /me hears ms. clark shout an amen from up north :) I wonder what will happen to all those nifty WYSIWYG editors... I have never been a fan of the HTML they output. ~| 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:193056 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: cfset ?
On Thu, 3 Feb 2005 21:39:07 -0800, Barney Boisvert [EMAIL PROTECTED] wrote: { snip } It's worth mentioning that you can do all this with HTML as well as XHTML. The difference is that with HTML you can choose to do it this way, but with XHTML you _have_ to do it this way. Which, IMO, is a good thing. There's been so much crap HTML code floating around the web for so long due to lack of standards (or lack of consequences for deviation from what loose standards existed). -- Charlie Griefer Marta was watching the football game with me when she said, You know, most of these sports are based on the idea of one group protecting its territory from invasion by another group. Yeah, I said, trying not to laugh. Girls are funny. ~| 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:193057 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
PreserveSingleQuotes In search page
I have a page for users to search what is in the database. There are a half dozen different things they can search on. Title/Author/Genre/Etc My action page pulls all the chosen criteria together and sends it to a stored procedure. It is not working when a user types in a ' into a title. I've added the PreserveSingleQuotes to the title piece: CFSET TitleSearch=Where (Title Like '#PreserveSingleQuotes(Attributes.Title)#%' I added it to the code that pulls all the criteria together: CFSET SearchThis=#PreserveSingleQuotes(Title)# #Genre# #Grade# #Voice# #Type#) And lastly I added it to the stored procedure. However, the ' still whacks it all out. CFPROCPARAM TYPE=IN CFSQLTYPE=CF_SQL_VARCHAR VALUE=#SearchThis# DBVARNAME=@SearchThis Any ideas? Thanks, J ~| 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:193058 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 VS ASP.NET use
index.cfm: about 17,600,000 index.asp: about 16,600,000 Looks like an open and shut case. :) Cheers Bert ps and after a quick check (google on site:www.mysite.com) i reckon about 4% of those 17 million are mine! On Fri, 4 Feb 2005 10:59:48 +, Mark Drew [EMAIL PROTECTED] wrote: I found this graph a while back, and I am looking to see if there are any other sites that show the graph of technology use that is more up to date? http://news.netcraft.com/archives/2004/03/23/aspnet_overtakes_jsp_and_java_servlets.html I am trying to get some figures on overall usage of CF on websites. Anybody got something like that knocking round? -- Mark Drew coldfusion and cfeclipse blogged: http://cybersonic.blogspot.com/ fusebox plugin for cfeclipse: http://cfopen.org/projects/fusebox3cfe/ ~| 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:193059 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: cfset ?
Well, if it was valid XML then you could, in theory, actually parse a cf document as an xml document Not sure what value that would have though. - Calvin -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, February 03, 2005 6:38 PM To: CF-Talk Subject: Re: cfset ? if its parsed on the server, and it doesnt make it to the browser, anyway, why or how does xhtml compliance matter? -- tony Tony Weeg macromedia certified coldfusion mx developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.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:193060 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: Slightly OT: XHTML (was Re: cfset ?)
Dreamweaver also does XHMTL... - Calvin -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, February 03, 2005 9:53 PM To: CF-Talk Subject: RE: Slightly OT: XHTML (was Re: cfset ?) TinyMCE outputs XHTML, so no problems there... -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Friday, 4 February 2005 10:37 To: CF-Talk Subject: RE: Slightly OT: XHTML (was Re: cfset ?) From: Charlie Griefer [mailto:[EMAIL PROTECTED] cleaning up the deprecated tags like font and the like will also really clean up the code (and by putting all of the presentation code into css, your pages will load that much faster)! /me hears ms. clark shout an amen from up north :) I wonder what will happen to all those nifty WYSIWYG editors... I have never been a fan of the HTML they output. ~| 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:193061 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 VS ASP.NET use
And keep in mind that over 80% of CF use is internal stuff, behind firewalls, stuff Google will never see. --- Ben -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 8:43 AM To: CF-Talk Subject: Re: Coldfusion VS ASP.NET use index.cfm: about 17,600,000 index.asp: about 16,600,000 Looks like an open and shut case. :) Cheers Bert ps and after a quick check (google on site:www.mysite.com) i reckon about 4% of those 17 million are mine! On Fri, 4 Feb 2005 10:59:48 +, Mark Drew [EMAIL PROTECTED] wrote: I found this graph a while back, and I am looking to see if there are any other sites that show the graph of technology use that is more up to date? http://news.netcraft.com/archives/2004/03/23/aspnet_overtakes_jsp_and_ java_servlets.html I am trying to get some figures on overall usage of CF on websites. Anybody got something like that knocking round? -- Mark Drew coldfusion and cfeclipse blogged: http://cybersonic.blogspot.com/ fusebox plugin for cfeclipse: http://cfopen.org/projects/fusebox3cfe/ ~| 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:193062 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 VS ASP.NET use
How about .aspx? -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 8:48 AM To: CF-Talk Subject: RE: Coldfusion VS ASP.NET use And keep in mind that over 80% of CF use is internal stuff, behind firewalls, stuff Google will never see. --- Ben -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 8:43 AM To: CF-Talk Subject: Re: Coldfusion VS ASP.NET use index.cfm: about 17,600,000 index.asp: about 16,600,000 Looks like an open and shut case. :) Cheers Bert ps and after a quick check (google on site:www.mysite.com) i reckon about 4% of those 17 million are mine! On Fri, 4 Feb 2005 10:59:48 +, Mark Drew [EMAIL PROTECTED] wrote: I found this graph a while back, and I am looking to see if there are any other sites that show the graph of technology use that is more up to date? http://news.netcraft.com/archives/2004/03/23/aspnet_overtakes_jsp_and_ java_servlets.html I am trying to get some figures on overall usage of CF on websites. Anybody got something like that knocking round? -- Mark Drew coldfusion and cfeclipse blogged: http://cybersonic.blogspot.com/ fusebox plugin for cfeclipse: http://cfopen.org/projects/fusebox3cfe/ ~| 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:193063 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: PreserveSingleQuotes In search page
I don't know exactly what you're trying to do, but I am pretty sure that the PreserveSingleQuotes function has NO effect when it's not inside a cfquery tag. So there is ZERO difference between this: CFSET TitleSearch=Where (Title Like '#PreserveSingleQuotes(Attributes.Title)#%' and this: CFSET TitleSearch=Where (Title Like '#Attributes.Title#%' It's only purpose is to prevent single quotes from being doubled up inside cfquery. Since you're not inside cfquery when you are running the preserveSingleQuotes() function, it doesn't do anything. - Rick [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I have a page for users to search what is in the database. There are a half dozen different things they can search on. Title/Author/Genre/Etc My action page pulls all the chosen criteria together and sends it to a stored procedure. It is not working when a user types in a ' into a title. I've added the PreserveSingleQuotes to the title piece: CFSET TitleSearch=Where (Title Like '#PreserveSingleQuotes(Attributes.Title)#%' I added it to the code that pulls all the criteria together: CFSET SearchThis=#PreserveSingleQuotes(Title)# #Genre# #Grade# #Voice# #Type#) And lastly I added it to the stored procedure. However, the ' still whacks it all out. CFPROCPARAM TYPE=IN CFSQLTYPE=CF_SQL_VARCHAR VALUE=#SearchThis# DBVARNAME=@SearchThis Any ideas? Thanks, J ~| 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:193064 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: Slightly OT: XHTML (was Re: cfset ?)
XHTML in general has to be served as application/xhtml+xml, application/xml or text/xml to be valid. So serving the files with a mimetype other than the required results in invalid XHTML, although the format looks XHTML valid. More about this on the blog of Anne, who explains everything in detail and written out. www.annevankesteren.nl Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED] Sent: vrijdag 4 februari 2005 14:06 To: CF-Talk Subject: RE: Slightly OT: XHTML (was Re: cfset ?) Actually xHTML works fine in IE provided it is xHTML 1.0 served as text through a mime type of text/html. It's the xhtml served as : application/xhtml+xml, application/xml or text/xml that causes problems in IE.(That's why I can't go to xHTML 1.1 since it has to be served with one of those mime types.) http://www.w3.org/International/articles/serving-xhtml/ Just remember to dump the prolog when serving xHTML (?xml version=1.0 encoding=utf-8?). It throws IE into quirks mode. (Quirks mode = non cross browser rendering compatibility and is not to be desired). cf_northeasternshout Hallelujah! They are listening! /cf_northeasternshout Sandy -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 2:48 AM To: CF-Talk Subject: RE: Slightly OT: XHTML (was Re: cfset ?) XHTML is still unsupported by IE, so if you need to develop for IE, use quirks mode at least, or stick to 4.01 Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: vrijdag 4 februari 2005 3:53 To: CF-Talk Subject: RE: Slightly OT: XHTML (was Re: cfset ?) TinyMCE outputs XHTML, so no problems there... -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Friday, 4 February 2005 10:37 To: CF-Talk Subject: RE: Slightly OT: XHTML (was Re: cfset ?) From: Charlie Griefer [mailto:[EMAIL PROTECTED] cleaning up the deprecated tags like font and the like will also really clean up the code (and by putting all of the presentation code into css, your pages will load that much faster)! /me hears ms. clark shout an amen from up north :) I wonder what will happen to all those nifty WYSIWYG editors... I have never been a fan of the HTML they output. ~| 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:193065 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
500 Internal Server Error
Every now and again I will get a 500 Internal Server Error. This happens when I submit a CF template for processing (i.e. forms). I am developing locally: CFMX 6.1, WinXP Pro / IIS, IE 6. Has anyone encountered this and if so, did you find out what was causing it? My first thought is that it is not CF related, but I have only experienced it when attempting to process CF pages. Any insight is much appreciated. Thanks, Mike. ~| 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:193066 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: 500 Internal Server Error (Update)
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Every now and again I will get a 500 Internal Server Error. This happens when I submit a CF template for processing (i.e. forms). I am developing locally: CFMX 6.1, WinXP Pro / IIS, IE 6. Has anyone encountered this and if so, did you find out what was causing it? My first thought is that it is not CF related, but I have only experienced it when attempting to process CF pages. Any insight is much appreciated. Seems to happen when certain errors are encountered on the page (stepped through the page). The sitewide error handler is not catching them... Not good. ~| 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:193067 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: 500 Internal Server Error (Update)
Michael T. Tangorre wrote: Seems to happen when certain errors are encountered on the page (stepped through the page). The sitewide error handler is not catching them... Not good. I've experienced this as well on CFMX 6.1 Updater 1... makes code debugging extremely difficult. very annoying. - rick ~| 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:193068 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: 500 Internal Server Error (Update)
I have the same issues, and they occur only when I really have put a bug somewhere. But it is a pain in the ass to debug, because you haven't got an idea where to look especially with OO frameworks with a lot of references. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - ~| 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:193069 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 VS ASP.NET use
And the fact the asp uses Default.asp a lot of the time. -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: 04 February 2005 13:51 To: CF-Talk Subject: RE: Coldfusion VS ASP.NET use How about .aspx? -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 8:48 AM To: CF-Talk Subject: RE: Coldfusion VS ASP.NET use And keep in mind that over 80% of CF use is internal stuff, behind firewalls, stuff Google will never see. --- Ben -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 8:43 AM To: CF-Talk Subject: Re: Coldfusion VS ASP.NET use index.cfm: about 17,600,000 index.asp: about 16,600,000 Looks like an open and shut case. :) Cheers Bert ps and after a quick check (google on site:www.mysite.com) i reckon about 4% of those 17 million are mine! On Fri, 4 Feb 2005 10:59:48 +, Mark Drew [EMAIL PROTECTED] wrote: I found this graph a while back, and I am looking to see if there are any other sites that show the graph of technology use that is more up to date? http://news.netcraft.com/archives/2004/03/23/aspnet_overtakes_jsp_and_ java_servlets.html I am trying to get some figures on overall usage of CF on websites. Anybody got something like that knocking round? -- Mark Drew coldfusion and cfeclipse blogged: http://cybersonic.blogspot.com/ fusebox plugin for cfeclipse: http://cfopen.org/projects/fusebox3cfe/ ~| 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:193070 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: 500 Internal Server Error (Update)
From: Micha Schopman [mailto:[EMAIL PROTECTED] I have the same issues, and they occur only when I really have put a bug somewhere. But it is a pain in the ass to debug, because you haven't got an idea where to look especially with OO frameworks with a lot of references. Yeah, PITA is right. I noticed it happens most when the error/exception is database related... This time it was a typo calling a stored procedure. ~| 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:193071 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: 500 Internal Server Error (Update)
When a page generates very little content, IE decides to show the 500 error instead of the actual CF error code. Try the same page in FireFox to see if this is the problem. If so, add a block of dummy HTML output to make IE render the error page while you are developing. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Friday, 4 February 2005 10:39 To: CF-Talk Subject: RE: 500 Internal Server Error (Update) From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Every now and again I will get a 500 Internal Server Error. This happens when I submit a CF template for processing (i.e. forms). I am developing locally: CFMX 6.1, WinXP Pro / IIS, IE 6. Has anyone encountered this and if so, did you find out what was causing it? My first thought is that it is not CF related, but I have only experienced it when attempting to process CF pages. Any insight is much appreciated. Seems to happen when certain errors are encountered on the page (stepped through the page). The sitewide error handler is not catching them... Not good. ~| 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:193072 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: 500 Internal Server Error (Update)
Have you tried going to CF admin and unchecking the Enable HTTP status codes on the settings page? Bert On Fri, 4 Feb 2005 09:47:54 -0500, Michael T. Tangorre [EMAIL PROTECTED] wrote: From: Micha Schopman [mailto:[EMAIL PROTECTED] I have the same issues, and they occur only when I really have put a bug somewhere. But it is a pain in the ass to debug, because you haven't got an idea where to look especially with OO frameworks with a lot of references. Yeah, PITA is right. I noticed it happens most when the error/exception is database related... This time it was a typo calling a stored procedure. ~| 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:193073 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: 500 Internal Server Error
Do you have Enable HTTP status codes turned off in CF Admin? We had the same problem until I saw a post from Ben Forta regarding the setting. Ever since I turned it off, we haven't had a problem. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 8:33 AM To: CF-Talk Subject: 500 Internal Server Error Every now and again I will get a 500 Internal Server Error. This happens when I submit a CF template for processing (i.e. forms). I am developing locally: CFMX 6.1, WinXP Pro / IIS, IE 6. Has anyone encountered this and if so, did you find out what was causing it? My first thought is that it is not CF related, but I have only experienced it when attempting to process CF pages. Any insight is much appreciated. Thanks, Mike. ~| 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:193074 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
Creating Oracle Functions in CFQUERY revisited
Okay... James suggested yesterday that I create my oracle functions inside a CFC, and make sure to put the SQL to create the function all on one line. But it's not helping.. Here is my code: test.cfm cfset DBTYPE = oracle cfset DSN = ADSPRD_blogcfm cfif dbtype contains oracle cfset functions = CreateObject(component,functions) cfset results = functions.createOracleFunctions(DSN) Oracle functions created. p /cfif cfquery name=qry datasource=#DSN# SELECT Year(SYSDATE) FROM DUAL /cfquery cfdump var=#qry# cfquery name=qry datasource=#DSN# SELECT Month(SYSDATE) FROM DUAL /cfquery cfdump var=#qry# test.cfm ---functions.cfc- cfcomponent cffunction name=createOracleFunctions access=public output=yes returnType=void cfargument name=dsn type=string required=yes cfset var qry = cftry cfquery name=qry datasource=#dsn# DEBUGDROP function month/cfquery cfcatch type=any!-- ignore --/cfcatch /cftry cftry cfquery name=qry datasource=#dsn# DEBUGDROP function year/cfquery cfcatch type=any!-- ignore --/cfcatch /cftry cfquery name=qry datasource=#dsn# DEBUGCREATE FUNCTION month (MyDate DATE) RETURN NUMBER IS BEGIN RETURN extract(MONTH FROM MyDate); END month/cfquery cfquery name=qry datasource=#dsn# DEBUGCREATE FUNCTION year (MyDate DATE) RETURN NUMBER AS BEGIN RETURN extract(YEAR FROM MyDate); END year/cfquery Cfreturn /cffunction /cfcomponent ---functions.cfc- All four queries execute fine... no errors... then when I try to access the Year() function, I still get the error: [Macromedia][Oracle JDBC Driver][Oracle]ORA-06575: Package or function YEAR is in an invalid state ARGH! - Rick ~| 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:193075 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: cfset ?
Uhhh, the table tags are part of your content. They are the structure. The presentation are things like headings Well, I was more thinking of the content (text) as opposed to the presentation in a larger sense, including the container as well. For me, the fact that some text must be laid inside a cell inside a table is part of the presentation scheme for the same reason as bold, italic or strong. The perfect example is the b tag in HTML. What does it mean? It means bold the contained text. That's a presentation concern, not part of the content. Exact, this is why I always write B, not b, in order to better separate it from the content generally in lower case. And this is why I do not like XHTML. In XHTML you have the strong tag. What does it mean? The contained text should be 'stronger' than other text. That's a semantic concern, not presentation. The you use CSS to supply the presentation info appropriate for the medium, based on the semantic meaning. I know, this is the philosopy behind SGML and DTDs. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:193076 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: Creating Oracle Functions in CFQUERY revisited
You stil have AS in the Year Fn RETURN NUMBER AS BEGIN Should be IS -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, 4 February 2005 10:55 To: CF-Talk Subject: Creating Oracle Functions in CFQUERY revisited Okay... James suggested yesterday that I create my oracle functions inside a CFC, and make sure to put the SQL to create the function all on one line. But it's not helping.. Here is my code: test.cfm cfset DBTYPE = oracle cfset DSN = ADSPRD_blogcfm cfif dbtype contains oracle cfset functions = CreateObject(component,functions) cfset results = functions.createOracleFunctions(DSN) Oracle functions created. p /cfif cfquery name=qry datasource=#DSN# SELECT Year(SYSDATE) FROM DUAL /cfquery cfdump var=#qry# cfquery name=qry datasource=#DSN# SELECT Month(SYSDATE) FROM DUAL /cfquery cfdump var=#qry# test.cfm ---functions.cfc- cfcomponent cffunction name=createOracleFunctions access=public output=yes returnType=void cfargument name=dsn type=string required=yes cfset var qry = cftry cfquery name=qry datasource=#dsn# DEBUGDROP function month/cfquery cfcatch type=any!-- ignore --/cfcatch /cftry cftry cfquery name=qry datasource=#dsn# DEBUGDROP function year/cfquery cfcatch type=any!-- ignore --/cfcatch /cftry cfquery name=qry datasource=#dsn# DEBUGCREATE FUNCTION month (MyDate DATE) RETURN NUMBER IS BEGIN RETURN extract(MONTH FROM MyDate); END month/cfquery cfquery name=qry datasource=#dsn# DEBUGCREATE FUNCTION year (MyDate DATE) RETURN NUMBER AS BEGIN RETURN extract(YEAR FROM MyDate); END year/cfquery Cfreturn /cffunction /cfcomponent ---functions.cfc- All four queries execute fine... no errors... then when I try to access the Year() function, I still get the error: [Macromedia][Oracle JDBC Driver][Oracle]ORA-06575: Package or function YEAR is in an invalid state ARGH! - Rick ~| 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:193077 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 VS ASP.NET use
Recall that many asp sites use default.asp ... not index.asp, whereas CF's index.cfm is far more standard. -Mark -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 7:48 AM To: CF-Talk Subject: RE: Coldfusion VS ASP.NET use And keep in mind that over 80% of CF use is internal stuff, behind firewalls, stuff Google will never see. --- Ben -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 8:43 AM To: CF-Talk Subject: Re: Coldfusion VS ASP.NET use index.cfm: about 17,600,000 index.asp: about 16,600,000 Looks like an open and shut case. :) Cheers Bert ps and after a quick check (google on site:www.mysite.com) i reckon about 4% of those 17 million are mine! On Fri, 4 Feb 2005 10:59:48 +, Mark Drew [EMAIL PROTECTED] wrote: I found this graph a while back, and I am looking to see if there are any other sites that show the graph of technology use that is more up to date? http://news.netcraft.com/archives/2004/03/23/aspnet_overtakes_jsp_and_ java_servlets.html I am trying to get some figures on overall usage of CF on websites. Anybody got something like that knocking round? -- Mark Drew coldfusion and cfeclipse blogged: http://cybersonic.blogspot.com/ fusebox plugin for cfeclipse: http://cfopen.org/projects/fusebox3cfe/ ~| 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:193078 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: Creating Oracle Functions in CFQUERY revisited
James Holmes wrote: You stil have AS in the Year Fn RETURN NUMBER AS BEGIN Should be IS Changed, still getting the same error. As a side note, why wouldn't invalid syntax cause the create function statement to error? - Rick ~| 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:193079 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: Creating Oracle Functions in CFQUERY revisited
Hmm, does the Month function work? As for the error (or lack of it), it might be some weird driver issue. I'll try your exact code in a sec and post back. -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, 4 February 2005 11:08 To: CF-Talk Subject: Re: Creating Oracle Functions in CFQUERY revisited James Holmes wrote: You stil have AS in the Year Fn RETURN NUMBER AS BEGIN Should be IS Changed, still getting the same error. As a side note, why wouldn't invalid syntax cause the create function statement to error? - Rick ~| 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:193080 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
OT: Visual Source Safe DEV/PROD Setup
I want to do the following for our cf stuff and not sure about the last step: Setup a project in VSS. Check files out to a test server, make changes there. Check files in. (Here is the part I don't know about) Make them automatically copy to the live server How do other people setup a dev/prod environment with VSS? Thanks. Kevin ~| 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:193081 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 VS ASP.NET use
How about a google search just for the file extension? Results 1 - 10 of about 82,700,000 for inurl:.aspx. (0.08 seconds) Results 1 - 10 of about 129,000,000 for inurl:.cfm. (0.28 seconds) -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 10:01 AM To: CF-Talk Subject: RE: Coldfusion VS ASP.NET use Recall that many asp sites use default.asp ... not index.asp, whereas CF's index.cfm is far more standard. -Mark -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 7:48 AM To: CF-Talk Subject: RE: Coldfusion VS ASP.NET use And keep in mind that over 80% of CF use is internal stuff, behind firewalls, stuff Google will never see. --- Ben -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 8:43 AM To: CF-Talk Subject: Re: Coldfusion VS ASP.NET use index.cfm: about 17,600,000 index.asp: about 16,600,000 Looks like an open and shut case. :) Cheers Bert ps and after a quick check (google on site:www.mysite.com) i reckon about 4% of those 17 million are mine! On Fri, 4 Feb 2005 10:59:48 +, Mark Drew [EMAIL PROTECTED] wrote: I found this graph a while back, and I am looking to see if there are any other sites that show the graph of technology use that is more up to date? http://news.netcraft.com/archives/2004/03/23/aspnet_overtakes_jsp_and_ java_servlets.html I am trying to get some figures on overall usage of CF on websites. Anybody got something like that knocking round? -- Mark Drew coldfusion and cfeclipse blogged: http://cybersonic.blogspot.com/ fusebox plugin for cfeclipse: http://cfopen.org/projects/fusebox3cfe/ ~| 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:193082 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 VS ASP.NET use
I know this is a hard metric, and it leads from a Macromedia CF brand re-inforcement excercise I need to play with a client. Not that they are going to go .net is just that .Net gets more press as its the new kid on the block. Any ideas on metrics/re-inforcement apreciated. MD On Fri, 4 Feb 2005 08:57:16 -0600, Mark A Kruger [EMAIL PROTECTED] wrote: Recall that many asp sites use default.asp ... not index.asp, whereas CF's index.cfm is far more standard. -Mark -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 7:48 AM To: CF-Talk Subject: RE: Coldfusion VS ASP.NET use And keep in mind that over 80% of CF use is internal stuff, behind firewalls, stuff Google will never see. --- Ben -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 8:43 AM To: CF-Talk Subject: Re: Coldfusion VS ASP.NET use index.cfm: about 17,600,000 index.asp: about 16,600,000 Looks like an open and shut case. :) Cheers Bert ps and after a quick check (google on site:www.mysite.com) i reckon about 4% of those 17 million are mine! On Fri, 4 Feb 2005 10:59:48 +, Mark Drew [EMAIL PROTECTED] wrote: I found this graph a while back, and I am looking to see if there are any other sites that show the graph of technology use that is more up to date? http://news.netcraft.com/archives/2004/03/23/aspnet_overtakes_jsp_and_ java_servlets.html I am trying to get some figures on overall usage of CF on websites. Anybody got something like that knocking round? -- Mark Drew coldfusion and cfeclipse blogged: http://cybersonic.blogspot.com/ fusebox plugin for cfeclipse: http://cfopen.org/projects/fusebox3cfe/ ~| 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:193083 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 VS ASP.NET use
That means that there are bigger sites for CFM? how about fusebox? each site would be index.cfm and that is pretty much it? On Fri, 4 Feb 2005 10:18:59 -0500, Russ [EMAIL PROTECTED] wrote: How about a google search just for the file extension? Results 1 - 10 of about 82,700,000 for inurl:.aspx. (0.08 seconds) Results 1 - 10 of about 129,000,000 for inurl:.cfm. (0.28 seconds) -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 10:01 AM To: CF-Talk Subject: RE: Coldfusion VS ASP.NET use Recall that many asp sites use default.asp ... not index.asp, whereas CF's index.cfm is far more standard. -Mark -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 7:48 AM To: CF-Talk Subject: RE: Coldfusion VS ASP.NET use And keep in mind that over 80% of CF use is internal stuff, behind firewalls, stuff Google will never see. --- Ben -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 8:43 AM To: CF-Talk Subject: Re: Coldfusion VS ASP.NET use index.cfm: about 17,600,000 index.asp: about 16,600,000 Looks like an open and shut case. :) Cheers Bert ps and after a quick check (google on site:www.mysite.com) i reckon about 4% of those 17 million are mine! On Fri, 4 Feb 2005 10:59:48 +, Mark Drew [EMAIL PROTECTED] wrote: I found this graph a while back, and I am looking to see if there are any other sites that show the graph of technology use that is more up to date? http://news.netcraft.com/archives/2004/03/23/aspnet_overtakes_jsp_and_ java_servlets.html I am trying to get some figures on overall usage of CF on websites. Anybody got something like that knocking round? -- Mark Drew coldfusion and cfeclipse blogged: http://cybersonic.blogspot.com/ fusebox plugin for cfeclipse: http://cfopen.org/projects/fusebox3cfe/ ~| 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:193084 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: new boston CFUG - sort of
Hey Duane, Jim, Robyn: I am 99% sure that the meeting will be virtual. You can get the breeze online meeting URL by going to this page: http://coldfusion.meetup.com/17/events/?eventId=4177446action=detail Now, to figure out some questions to ask.. Nice bubbles, Jim. At first it looked like you were eating ice cream or something. :) Ray At 12:23 AM 2/4/2005, you wrote: -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, February 03, 2005 3:08 PM To: CF-Talk Subject: new boston CFUG - sort of Check it out, sign yourself up! Done and done. I'm a little confused tho' - the first meeting is sending mixed messages. Is it virtual, online or both? It says virtual but then gives a physical address. I can't deal with it when the real and virtual worlds collide... what should I do?! Jim Davis ~| 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:193085 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: Creating Oracle Functions in CFQUERY revisited
As a side note, why wouldn't invalid syntax cause the create function statement to error? you can use both AS and IS, it doesn't seem to have any effect (at least in SQL*Plus): SQL*Plus: Release 9.2.0.1.0 - Production on Fri Feb 4 16:25:07 2005 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production SQL CREATE OR REPLACE FUNCTION c_to_f (in_c NUMBER) 2 RETURN NUMBER 3 IS 4 out_f NUMBER; 5 BEGIN 6 out_f := (in_c * 9 / 5) + 32; 7 RETURN out_f; 8 END c_to_f; 9 / Function created. SQL SELECT SUBSTR (object_name, 1, 25), object_type, status 2FROM user_objects 3 WHERE object_name = 'C_TO_F'; SUBSTR(OBJECT_NAME,1,25) OBJECT_TYPESTATUS - -- --- C_TO_FFUNCTION VALID SQL DROP FUNCTION c_to_f; Function dropped. SQL CREATE OR REPLACE FUNCTION c_to_f (in_c NUMBER) 2 RETURN NUMBER 3 AS 4 out_f NUMBER; 5 BEGIN 6 out_f := (in_c * 9 / 5) + 32; 7 RETURN out_f; 8 END c_to_f; 9 / Function created. SQL SELECT SUBSTR (object_name, 1, 25), object_type, status 2FROM user_objects 3 WHERE object_name = 'C_TO_F'; SUBSTR(OBJECT_NAME,1,25) OBJECT_TYPESTATUS - -- --- C_TO_FFUNCTION VALID SQL -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 4:08 PM To: CF-Talk Subject: Re: Creating Oracle Functions in CFQUERY revisited James Holmes wrote: You stil have AS in the Year Fn RETURN NUMBER AS BEGIN Should be IS Changed, still getting the same error. As a side note, why wouldn't invalid syntax cause the create function statement to error? - Rick ~| 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:193086 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 VS ASP.NET use
Where did you search to get those number? By default, IIS doesn't use index.asp as the default document, but uses default.asp (for legacy ASP) and default.aspx (for ASP.NET). What are the results for those? Vince -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 8:43 AM To: CF-Talk Subject: Re: Coldfusion VS ASP.NET use index.cfm: about 17,600,000 index.asp: about 16,600,000 Looks like an open and shut case. :) Cheers Bert ps and after a quick check (google on site:www.mysite.com) i reckon about 4% of those 17 million are mine! On Fri, 4 Feb 2005 10:59:48 +, Mark Drew [EMAIL PROTECTED] wrote: I found this graph a while back, and I am looking to see if there are any other sites that show the graph of technology use that is more up to date? http://news.netcraft.com/archives/2004/03/23/aspnet_overtakes_jsp_and_ java_servlets.html I am trying to get some figures on overall usage of CF on websites. Anybody got something like that knocking round? -- Mark Drew coldfusion and cfeclipse blogged: http://cybersonic.blogspot.com/ fusebox plugin for cfeclipse: http://cfopen.org/projects/fusebox3cfe/ ~| 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:193087 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: Creating Oracle Functions in CFQUERY revisited
I've got it - you are missing the final semicolon after END month and END year. Running without them leads to this: CREATE FUNCTION month (MyDate DATE) RETURN NUMBER IS BEGIN RETURN extract(MONTH FROM MyDate); END month Warning: Function created with compilation errors Notice that no ORA error was thrown - it was created. It just compiled badly. Hence, CF doesn't error either (I did this with TOAD). Add the semicolons and you'll be OK. It all still needs to be on one line. -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, 4 February 2005 11:08 To: CF-Talk Subject: Re: Creating Oracle Functions in CFQUERY revisited James Holmes wrote: You stil have AS in the Year Fn RETURN NUMBER AS BEGIN Should be IS Changed, still getting the same error. As a side note, why wouldn't invalid syntax cause the create function statement to error? - Rick ~| 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:193088 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: Creating Oracle Functions in CFQUERY revisited
James Holmes wrote: Hmm, does the Month function work? As for the error (or lack of it), it might be some weird driver issue. I'll try your exact code in a sec and post back. Let me know... I'm running CFMX 6.1 Updater 1 on Windows, and using the default Oracle JDBC Driver, connecting to an Oracle 9i database. - Rick ~| 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:193089 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: Creating Oracle Functions in CFQUERY revisited
YEAR is a reserved word in Oracle. Try a different name for the function. Janet. At 09:55 AM 2/4/2005 -0500, you wrote: All four queries execute fine... no errors... then when I try to access the Year() function, I still get the error: [Macromedia][Oracle JDBC Driver][Oracle]ORA-06575: Package or function YEAR is in an invalid state ~| 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:193090 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: Creating Oracle Functions in CFQUERY revisited
It may be, but the function still works anyway. -Original Message- From: Janet Schmitt [mailto:[EMAIL PROTECTED] Sent: Friday, 4 February 2005 11:42 To: CF-Talk Subject: Re: Creating Oracle Functions in CFQUERY revisited YEAR is a reserved word in Oracle. Try a different name for the function. Janet. At 09:55 AM 2/4/2005 -0500, you wrote: All four queries execute fine... no errors... then when I try to access the Year() function, I still get the error: [Macromedia][Oracle JDBC Driver][Oracle]ORA-06575: Package or function YEAR is in an invalid state ~| 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:193091 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 VS ASP.NET use
Searching 'fuseaction' in google turns up 12,700,000. A lot of pages from US Senate and House. The gov't clearly endorses Fusebox and CF. Hmmm, is this a good thing? ;) Mark That means that there are bigger sites for CFM? how about fusebox? each site would be index.cfm and that is pretty much it? ~| 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:193092 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 VS ASP.NET use
Just a dump of dumb numbers index.cfm - 19,200,000 default.cfm - 2,100,000 index.asp - 18,500,000 default.asp - 17,900,000 index.aspx - 3,670,000 default.aspx - 8,740,000 index.php - 29,100,000 default.php - 4,200,000 index.jsp - 10,900,000 default.jsp - 266,000 Ohh.. me scared.. aspx all over the place :) MD On Fri, 4 Feb 2005 10:37:36 -0500, Vince Bonfanti [EMAIL PROTECTED] wrote: Where did you search to get those number? By default, IIS doesn't use index.asp as the default document, but uses default.asp (for legacy ASP) and default.aspx (for ASP.NET). What are the results for those? Vince -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 8:43 AM To: CF-Talk Subject: Re: Coldfusion VS ASP.NET use index.cfm: about 17,600,000 index.asp: about 16,600,000 Looks like an open and shut case. :) Cheers Bert ps and after a quick check (google on site:www.mysite.com) i reckon about 4% of those 17 million are mine! On Fri, 4 Feb 2005 10:59:48 +, Mark Drew [EMAIL PROTECTED] wrote: I found this graph a while back, and I am looking to see if there are any other sites that show the graph of technology use that is more up to date? http://news.netcraft.com/archives/2004/03/23/aspnet_overtakes_jsp_and_ java_servlets.html I am trying to get some figures on overall usage of CF on websites. Anybody got something like that knocking round? -- Mark Drew coldfusion and cfeclipse blogged: http://cybersonic.blogspot.com/ fusebox plugin for cfeclipse: http://cfopen.org/projects/fusebox3cfe/ ~| 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:193093 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 VS ASP.NET use
whoops - looked like i removed the first line - it should have read:... searching google i found: index.cfm: about 17,600,000 index.asp: about 16,600,000 Cheers Bert On Fri, 4 Feb 2005 10:37:36 -0500, Vince Bonfanti [EMAIL PROTECTED] wrote: Where did you search to get those number? {snip} -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 8:43 AM To: CF-Talk Subject: Re: Coldfusion VS ASP.NET use index.cfm: about 17,600,000 index.asp: about 16,600,000 ~| 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:193094 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: Creating Oracle Functions in CFQUERY revisited
James, that did the trick! Crazy, in ALL other SQL queries sent via CFQUERY, if you end them in ;, you get an Invalid Character error... Here's a question, Mr. Oracle Man... Why can't I do this? SELECT *, 'foo' as foo FROM BLOG_CONFIG It's easy enough to work around by specifying the field names, but it's still pretty stupid that not to work. It doesn't work in SQL*Plus or cfquery. SQL select *, 'foo' as foo from BLOG_CONFIG; select *, 'foo' as foo from BLOG_CONFIG * ERROR at line 1: ORA-00923: FROM keyword not found where expected SQL select 'foo' as foo, * from BLOG_CONFIG; select 'foo' as foo, * from BLOG_CONFIG * ERROR at line 1: ORA-00936: missing expression ~| 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:193096 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: Slightly OT: XHTML (was Re: cfset ?)
Micha Schopman [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] XHTML in general has to be served as application/xhtml+xml, application/xml or text/xml to be valid. So serving the files with a mimetype other than the required results in invalid XHTML, although the format looks XHTML valid. I tend to agree (see my CF tools page with a Gekko based browser), but I feel there is more than that. With XHTML you can create compound documents, mixing different XML languages inside the same document, like a XHTML file that contains SVG, MathML or RSS. In such a scenario XHTML may simply act as a container. How about that? What's the correct mime-type for such a kind of beast? I have the feeling a simple mime-type isn't able to express the real nature of a compound XML document... Massimo Foti DW tools: http://www.massimocorner.com CF tools: http://www.olimpo.ch/tmt/ ~| 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:193096 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
Think like an object
A lot of OO books/papers make reference to an article titled Think like an object from the Sept. 1991 Unix Review. This article is not online anywhere and I was wondering if someone here had a copy and could scan/photocopy it for me. I'm writing up a lot of CF-OO stuff and would like to see it. Thanks p.s. some of the .wav files of what I'm writing are here (anyone want to transcribe): http://houseoffusion.com/articles/raw/ ~| 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:193097 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: Creating Oracle Functions in CFQUERY revisited
SELECT BLOG_CONFIG.*, 'foo' as foo FROM BLOG_CONFIG And you thought that would be hard, didn't you... -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Saturday, 5 February 2005 12:04 To: CF-Talk Subject: Re: Creating Oracle Functions in CFQUERY revisited James, that did the trick! Crazy, in ALL other SQL queries sent via CFQUERY, if you end them in ;, you get an Invalid Character error... Here's a question, Mr. Oracle Man... Why can't I do this? SELECT *, 'foo' as foo FROM BLOG_CONFIG It's easy enough to work around by specifying the field names, but it's still pretty stupid that not to work. It doesn't work in SQL*Plus or cfquery. SQL select *, 'foo' as foo from BLOG_CONFIG; select *, 'foo' as foo from BLOG_CONFIG * ERROR at line 1: ORA-00923: FROM keyword not found where expected SQL select 'foo' as foo, * from BLOG_CONFIG; select 'foo' as foo, * from BLOG_CONFIG * ERROR at line 1: ORA-00936: missing expression ~| 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:193098 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: Creating Oracle Functions in CFQUERY revisited
James Holmes wrote: SELECT BLOG_CONFIG.*, 'foo' as foo FROM BLOG_CONFIG And you thought that would be hard, didn't you... Hehheheh.. I'll keep that in mind! You know, making BlogCFM work for 5 different databases has been an interesting exercise. Once it's done, I'm hoping to talk the alumni center here into using it, then at least the work will have been work-related. (Saeed, if you're out there, you be quiet!) - Rick ~| 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:193099 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: new boston CFUG - sort of
Where are you guys meeting? I'm in Nashua. Duane Please refer to my reply to Jim Davis on this list, or see: http://www.talkingtree.com/blog/index.cfm?mode=aliasalias=BostonCFMeetup Thanks ~| 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:193100 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: new boston CFUG - sort of
I'm a little confused tho' - the first meeting is sending mixed messages. Is it virtual, online or both? It says virtual but then gives a physical address. Hi Jim, I see you've added a photo. I've bumped into many times before, but never put the face with the name. Good to meet you. The Meetup.com site has required fields when setting up an event, including the address, city, state etc. I had to choose something for that, so I chose Newton, the Macromedia office. However, in the notes section there is a Breeze URL and a conference number. You can attend from your place of work or at home on that comfy couch. The audio of any presenter is broadcast to all audience members, and we can make anyone a presenter if they have something to share on their desktop. So if all you wish to do is listen, then bring up the Breezo and turn on the computer speakers. On the other hand, if you think you'd like to speak up from time to time, then join the conf call and turn down your speakers. Meetup also seems to want to automatically schedule new meetings on the first Thursday of the month at 8pm by default, so already there is a new event scheduled for March 3rd. That sounds reasonable, but I've changed the time to 6pm. During next weeks online meeting we can address topics such as desired days and times, as well as future topics and possible presenters. Thanks! 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:193101 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
OT:SQL Replace Question
Anyone have any idea why this code will not strip out the spaces in the string N0P 2L0? select Replace(postal_code,' ', '') from location where id = 1009637 when I change the last argument to 'X' it throws two X's in like it should. We are running ms sql 2k in 6.5 compatibility mode, so I dont know if that is the reason why it wont trim the spaces out. If this is why, does anyone have a workaround that would work inside a join clause like oin zipinfo z on Replace(z.zip,' ','') = Replace(l.postal_code,' ','') when running in compatibility mode? TIA John ~| 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:193102 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 VS ASP.NET use
Surely this is abundantly obvious, ASP/.NET has a much larger saturation than CF, you don't need to google to know that...just open your eyes a little. -- Neil http://www.theservicefactory.com Get Firefox - http://www.getfirefox.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:193103 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 VS ASP.NET use
-Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 9:57 AM To: CF-Talk Subject: RE: Coldfusion VS ASP.NET use Recall that many asp sites use default.asp ... not index.asp, whereas CF's index.cfm is far more standard. Although some of us use default.cfm (as at www.nefn.com) as well. Add to that the number of people that mask the extension entirely and the (large number, as Ben said) behind firewalls (and not just for CF) and in the end I don't think any of the numbers available via Google are very useful. I'm not sure how you would get comparative numbers... with CF it's tempting to go by sales (which assumes if somebody buys a product they'll use it) but that cuts out the very large number of shared hosting applications (one purchased license might support dozens of separate applications). It's also impossible to judge ASP via sales. So I'm not sure how to get real numbers... 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:193104 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: cfset ?
No, I used this address. Will send it right now with the subject RE_Extract. Dan On Thu, 03 Feb 2005 23:07:29 -0500, Claude Schneegans [EMAIL PROTECTED] wrote: Did your email address change? I sent a couple emails about RE_extract with no reply. No, it didn't. I changed my message reading soft however, (Thunderbird), and it has a spam filter. I check it every time it sends something to the thrash however, and I never saw something about RE_extract of course. I hope you did not use [EMAIL PROTECTED] it is only a spam trap ;-) Can you try again ? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:193105 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
OT: Trying to make emails bounce correctly, headers problem
Loha. Every week I send out a company newsletter to 2500 subscribers. We get a few hundred bounce messages each time and they currently go back to the From address. Rather than cluttering up that account I created an 'emailerrors' account and am trying to configure the email to go to it instead. Here is an example header list from an email. Microsoft Mail Internet Headers Version 2.0 Received: from websrv ([xx.xxx.xx.xxx]) by mail.thelimucompany.com with Microsoft SMTPSVC(5.0.2195.6713); Fri, 4 Feb 2005 11:51:40 -0500 Return-Path: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] Date: Fri, 4 Feb 2005 11:48:26 -0500 (EST) From: My Comapny [EMAIL PROTECTED] To: Damien McKenna [EMAIL PROTECTED] Subject: Cool News Errors-To: [EMAIL PROTECTED] Mime-Version: 1.0 Content-Type: multipart/related; boundary==_Part_146976_15408636.1107535706406 X-Mailer: ColdFusion MX Application Server X-Mailer: MyCompany Email Sender Sender: [EMAIL PROTECTED] X-Sender: [EMAIL PROTECTED] X-Return-Path: [EMAIL PROTECTED] Envelope-From: [EMAIL PROTECTED] precedence: list importance: high sensitivity: confidential X-OriginalArrivalTime: 04 Feb 2005 16:48:26.0406 (UTC) FILETIME=[58CEDC60:01C50AD9] At first I set it to use the SMTP server (IIS on Win2k) on our hosted server (WEBSRV), and then I tried sending straight through our local server (mail.thelimucompany.com) to see if it made any difference, but the same thing happened. Anyone have a suggestion on what headers I might be missing, or anything else to check? My IT guru co-worker thought that the invalid hostname on the mailserver (WEBSRV) might be causing a problem. I would think that it might cause some of the bounces to occur (some ISPs block invalid hostnames) but it shouldn't explain why the bounces go to the wrong location. Any help would be appreciated. Thanks. -- 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:193106 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: Trying to make emails bounce correctly, headers problem
Every week I send out a company newsletter to 2500 subscribers. We get a few hundred bounce messages each time and they currently go back to the From address. Rather than cluttering up that account I created an 'emailerrors' account and am trying to configure the email to go to it instead. Here is an example header list from an email. Microsoft Mail Internet Headers Version 2.0 Received: from websrv ([xx.xxx.xx.xxx]) by mail.thelimucompany.com with Microsoft SMTPSVC(5.0.2195.6713); Fri, 4 Feb 2005 11:51:40 -0500 Return-Path: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] Date: Fri, 4 Feb 2005 11:48:26 -0500 (EST) From: My Comapny [EMAIL PROTECTED] To: Damien McKenna [EMAIL PROTECTED] Subject: Cool News Errors-To: [EMAIL PROTECTED] Mime-Version: 1.0 Content-Type: multipart/related; boundary==_Part_146976_15408636.1107535706406 X-Mailer: ColdFusion MX Application Server X-Mailer: MyCompany Email Sender Sender: [EMAIL PROTECTED] X-Sender: [EMAIL PROTECTED] X-Return-Path: [EMAIL PROTECTED] Envelope-From: [EMAIL PROTECTED] precedence: list importance: high sensitivity: confidential X-OriginalArrivalTime: 04 Feb 2005 16:48:26.0406 (UTC) FILETIME=[58CEDC60:01C50AD9] I don't see a Reply-To header. That should be used to specify where replies should go. 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:193107 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: Trying to make emails bounce correctly, headers problem
Some email servers return to the FROM header address and ignore the other headers. Try this: cfmail from=My Company [EMAIL PROTECTED] ... HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion applications Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm --- On Friday, February 04, 2005 12:30 PM, Damien McKenna scribed: --- Loha. Every week I send out a company newsletter to 2500 subscribers. We get a few hundred bounce messages each time and they currently go back to the From address. Rather than cluttering up that account I created an 'emailerrors' account and am trying to configure the email to go to it instead. ~| 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:193108 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: Trying to make emails bounce correctly, headers problem
I want regular replies to go to the From: address and error messages to go to the Error-To: address. I didn't think it'd be needed. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] I don't see a Reply-To header. That should be used to specify where replies should go. ~| 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:193109 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: cfset ?
Will send it right now with the subject RE_Extract. Ah ah! Got it! And it is not marked as spam. ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:193110 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 VS ASP.NET use
And keep in mind that over 80% of CF use is internal stuff, behind firewalls, stuff Google will never see. Isn't that equally true for every other web application server technology? 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:193111 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: Server side printing
Can anyone suggest how an Intranet user can send a PDF or text file to be printed on a specific printer from the server side? I'm thinking specifically about printing labels on a Dymo Labelwriter 330 USB which is on a box on the network. This is with CF5 / Win2K3 I haven't tried this with PDFs, but you can just use CFFILE to write to the appropriate UNC path for the printer with text files. 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:193112 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: Visual Source Safe DEV/PROD Setup
I strongly recommend against automatic deployment to your production environment on check-in. You should really have three environments: dev, test, and prod. Build code in dev and check that it all works. Then you can check in your code in dev. Deploy from dev to test and check that it works. Then deploy to prod. How you deploy your code is up to you. We have CF Enterprise at my company and I use the Archive and Deploy features in the CF Admin for production deployments. The technology/method of deployment is secondary. The key is good process. Kevin wrote: Setup a project in VSS. Check files out to a test server, make changes there. Check files in. (Here is the part I don't know about) Make them automatically copy to the live server How do other people setup a dev/prod environment with VSS? ~| 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:193113 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: CF5 to CFMX - CFUSION_DISABLE_DBCONNECTIONS and MS Excel data sources
Pardon my ignorance, but can we speculate why MM removed the CFUSION_DISABLE_DBCONNECTIONS function (and other related functions) from CFMX? Does it have to do with Java? Or does it have to do with security? Presumably because the entire product was rewritten, and uses JDBC database drivers instead of ODBC? 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! ~| 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:193114 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: Trying to make emails bounce correctly, headers problem
Use the failto attribute of the cfmail tag. Russ -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 12:45 PM To: CF-Talk Subject: RE: Trying to make emails bounce correctly, headers problem I want regular replies to go to the From: address and error messages to go to the Error-To: address. I didn't think it'd be needed. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] I don't see a Reply-To header. That should be used to specify where replies should go. ~| 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:193116 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
Another little tip
I just moved an application that was coded a couple of years ago from a CF5 server to a CFMX 6.1 server. I just figured out why my cfserver was pegging 100% CPU when it would hit a certain page. There was a CFFile statement where the output attribute didn't have ending quotes. It didn't throw an error, and surprisingly, it would work if the variable that it was outputting wasn't too large. If the variable was large, it would hang on the template and send the CPU sky high. More surprisingly, CF5 never complained about it. -- G-mail must not realize I'm and anti-social nerd, it keeps telling me to Invite 8 friends to Gmail ~| 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:193115 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
Blog app
At 12:01 PM -0500 2/3/05, CF-Talk wrote: Y'know, I use Oracle as the DBMS for my blog. Isn't that kinda overkill? Yeah, but your should hear the server growl whenever somebody pulls up pictures of my cat! yeah it is probably overkill, but it's what the University supports and I use it whether I need to scale later or not. It's good to hear that it might not be too hard. It looked nice. -- 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:193117 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: Trying to make emails bounce correctly, headers problem
My mails are generally set up as follows... cfmail from=[EMAIL PROTECTED] replyto=[EMAIL PROTECTED] failto=[EMAIL PROTECTED] ... This works for the most part except with MTA's like MS Exchange that will accept mails for any address and then bounce them after receiving the full mail... This means that the failto address is lost because it is only used in the SMTP conversation and is not included in the headers of the mail... Even with the replyto set to bounce@ as well, we still receive some bounce messages back to the newsletters mailbox because of the poor implementations of some mail servers... I guess what I'm saying is that you can't completely fix this with code because it's not your code that is necessarily broken Paul ~| 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:193118 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: SQL Replace Question
Well, I tested this and it works fine on a 2k db NOT running in compatability mode, so that is the issue. Now to find a workaround. -Original Message- From: John Stanley Sent: Friday, February 04, 2005 11:35 AM To: CF-Talk Subject: OT:SQL Replace Question Anyone have any idea why this code will not strip out the spaces in the string N0P 2L0? select Replace(postal_code,' ', '') from location where id = 1009637 when I change the last argument to 'X' it throws two X's in like it should. We are running ms sql 2k in 6.5 compatibility mode, so I dont know if that is the reason why it wont trim the spaces out. If this is why, does anyone have a workaround that would work inside a join clause like oin zipinfo z on Replace(z.zip,' ','') = Replace(l.postal_code,' ','') when running in compatibility mode? TIA John ~| 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:193119 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: Blog app
Daniel Kessler wrote: It's good to hear that it might not be too hard. It looked nice. BlogCFM 0.93b includes full support for Oracle and SQL Server. I also fixed quite a lot of major and minor bugs, and finished some features that weren't done (like requiring account confirmation before posting comments) You can download it from www.blogcfm.org =) - Rick ~| 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:193120 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 VS ASP.NET use
Dave, honestly, I don't think anyone really knows the answer to that one. But it is clear that some technologies tend to be used less in internal corporate development (PHP is a perfect example of this) meaning that proportionally there is more of them public facing and that skews any extrapolation of total use based on public facing use. --- Ben -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 12:57 PM To: CF-Talk Subject: RE: Coldfusion VS ASP.NET use And keep in mind that over 80% of CF use is internal stuff, behind firewalls, stuff Google will never see. Isn't that equally true for every other web application server technology? 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! ~| 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:193121 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
Migrate Lotus Notes Apps to Coldfusion
our group maybe getting the fun challange of migrating about 50-80 Lotus/Domino apps to Coldfusion. I was curious if anyone has done this and/or if anyone had any pointers or suggestions on wherre to start. Right now we have an ODBC connection and are able to read some data but we're concerned about datamigration and also getting a non-odbc driver to work on MX. Adam 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:193122 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: Migrate Lotus Notes Apps to Coldfusion
our group maybe getting the fun challange of migrating about 50-80 Lotus/Domino apps to Coldfusion. I was curious if anyone has done this and/or if anyone had any pointers or suggestions on wherre to start. Right now we have an ODBC connection and are able to read some data but we're concerned about datamigration and also getting a non-odbc driver to work on MX. Adam H We're at the same point you are with this very thing at my company Adam--we're using the Notes SQL driver (which isn't especially pretty since Notes isn't relational), and we're getting some data back but it's a bit weird. Lots of issues to work through. This is going to be more or less my life over the next few months so as I work through this I'll definitely share my pain. If you come up with any good tidbits of knowledge please share them! Thanks, Matt ~| 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:193123 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: Trying to make emails bounce correctly, headers problem
-Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] My mails are generally set up as follows... cfmail from=[EMAIL PROTECTED] replyto=[EMAIL PROTECTED] failto=[EMAIL PROTECTED] ... Perfect! That was it! Thanks Paul. -- 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:193124 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
A brief question about lists
Hello, I was wondering if there are any guidelines, or limits in how many items can be in a list in a CF variable. Anyone? 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:193125 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: Slightly OT: XHTML (was Re: cfset ?)
I believe that it's still the XHTML MIME type, because that's what the document acutally, is regardless of what other stuff it might have embedded in it. But you're right, the MIME type is utterly insufficient for describing a compound XML document. cheers, barneyb On Fri, 4 Feb 2005 17:03:18 +0100, Massimo, Tiziana e Federica [EMAIL PROTECTED] wrote: Micha Schopman [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] XHTML in general has to be served as application/xhtml+xml, application/xml or text/xml to be valid. So serving the files with a mimetype other than the required results in invalid XHTML, although the format looks XHTML valid. I tend to agree (see my CF tools page with a Gekko based browser), but I feel there is more than that. With XHTML you can create compound documents, mixing different XML languages inside the same document, like a XHTML file that contains SVG, MathML or RSS. In such a scenario XHTML may simply act as a container. How about that? What's the correct mime-type for such a kind of beast? I have the feeling a simple mime-type isn't able to express the real nature of a compound XML document... Massimo Foti DW tools: http://www.massimocorner.com CF tools: http://www.olimpo.ch/tmt/ ~| 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:193126 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: A brief question about lists
I was wondering if there are any guidelines, or limits in how many items can be in a list in a CF variable. There's no specific list data type in CF; lists are just strings. So, my guess is that a list can only contain as many characters (including delimiters) as any other string. Of course, that doesn't really help you with how many items can be in a list if you don't know the length of all items beforehand. 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:193127 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: A brief question about lists
None other than the fact that a list is a delimited text string that has to be parsed to get out the value. Too long and it takes a lot of processing to deal with it. Personally, I don't use lists longer than 100 items unless there's a really good reason for it. Hello, I was wondering if there are any guidelines, or limits in how many items can be in a list in a CF variable. Anyone? 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:193128 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: A brief question about lists
-Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 2:43 PM To: CF-Talk Subject: A brief question about lists Hello, I was wondering if there are any guidelines, or limits in how many items can be in a list in a CF variable. I don't believe there is a limit (beyond hardware system limits) for size. I once ran a code challenge to tally the number of words in an arbitrary piece of text (for example the appears 35 times, We appears 3 times, etc) This was in CF 4.5/5.0 at the time (but I don't think it mattered) but one of the entries treated the text as a space-delimited list and looped over it. It worked just fine (and was actually one of the fastest entries) with text strings as large as the full novel Call of the Wild. I've also successfully done log file parsing in CF treating log files (even large ones) as carriage-return-delimited lists. In other words list can be very, very large. ;^) 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:193129 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
OT: Sql question
I have a question about how a relationship would be best modeled in SQL. Currently I have a hiking website, which hosts trail reviews. People can add their own comments which are associated with the hike. For instance maybe I hiked snow lake on 12/1/05 and also 6/1/05. However, the user review gets associated with the instance of the hike either on 12/1/05. or 6/1/05. I want to combine these reviews so that they are associated with both. I think a group ID could be assigned so this could be accomplished. However... The real problem however is how to model something like this where one hike is a subset or superset of another. Take for instance this example. TrailHead---3miles--Snowlake2milesGemlake---1mile---WrightMountain. I would like the Snow lake reviews to be shown when either GemLake is viewed or Wright Mountain. However, I wouldn't want reviews for Gem Lake when the user is only intending to go to Snowlake. Thus the problem is how one would handle this superset/subset association of reviews. If anyone has any thoughts about how this would be handled I would be grateful for the advice. Thanks, John ~| 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:193130 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: Slightly OT: XHTML (was Re: cfset ?)
you need to create a DTD to encompass all these.. W3C has a good example.. [XHTMLMOD] http://www.w3.org/TR/2002/WD-XHTMLplusMathMLplusSVG-20020809/#ref-xhtmlmodschema frankly I think.. until the XHTML MOD Schema is finalized(working draft now) stuff like this gonna be.. a pain.. unless you are a fan of DTD's Massimo, Tiziana e Federica wrote: Micha Schopman [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] XHTML in general has to be served as application/xhtml+xml, application/xml or text/xml to be valid. So serving the files with a mimetype other than the required results in invalid XHTML, although the format looks XHTML valid. I tend to agree (see my CF tools page with a Gekko based browser), but I feel there is more than that. With XHTML you can create compound documents, mixing different XML languages inside the same document, like a XHTML file that contains SVG, MathML or RSS. In such a scenario XHTML may simply act as a container. How about that? What's the correct mime-type for such a kind of beast? I have the feeling a simple mime-type isn't able to express the real nature of a compound XML document... Massimo Foti DW tools: http://www.massimocorner.com CF tools: http://www.olimpo.ch/tmt/ ~| 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:193131 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: cfset ?
This all translates to tens of thousands of extra keystrokes for me. And being the lazy coder that I am, I'll deem them unecessary! :) Will ~| 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:193132 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: A brief question about lists
Thank you all who answered! This list would probably be up to 350 items.. so I was thinking that might be a bit much. I suspect if I dig around with the SQL a bit more, I can get the results I desire... Yves On Fri, 4 Feb 2005 14:54:08 -0500, Jim Davis [EMAIL PROTECTED] wrote: -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 2:43 PM To: CF-Talk Subject: A brief question about lists Hello, I was wondering if there are any guidelines, or limits in how many items can be in a list in a CF variable. I don't believe there is a limit (beyond hardware system limits) for size. I once ran a code challenge to tally the number of words in an arbitrary piece of text (for example the appears 35 times, We appears 3 times, etc) This was in CF 4.5/5.0 at the time (but I don't think it mattered) but one of the entries treated the text as a space-delimited list and looped over it. It worked just fine (and was actually one of the fastest entries) with text strings as large as the full novel Call of the Wild. I've also successfully done log file parsing in CF treating log files (even large ones) as carriage-return-delimited lists. In other words list can be very, very large. ;^) Jim Davis ~| 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:193133 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
OT: CFQuery SQL Scope of return?
MS SQL CFMX 6.1 How do you limit the score of info returned? or The equivalent of MySQL LIMIT #StartRow#, #NumberRows# Thanks, Nick ~| 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:193134 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
Errors not catched
I am creating a XML tree. The childs[i].lastversionid element is not available, and I am aware of. But, instead of executing the cfcatch part (which creates XML data with the error data in it to show in a treeview) CFMX just throws the error. Anybody happen to have same issues before with cftry/cfcatch ? The relevant code is posted below :) Maybe I have triggered a known issue? The code resides in a cfm file, not in a cfc. cfset dataset = createObject(component,server.io.getCFCPath(shared,getchildren)) cfset dataset.init(parentid=url.parentid) cfset childs = dataset.getAsObjects() cftry cfloop from=1 to=#ArrayLen(childs)# index=i cfif childs[i][objectName] EQ LibraryCategory AND childs[i][forObject] EQ Request.Object.object_Article.type cfoutput tree label=#childs[i][objectlabel]# src=object.cfm?object=articleamp;template=treenodesamp;parentid=#childs[i][instanceid]# icon=styles/blue/gfx/workset.gif iconopen=styles/blue/gfx/workset.gif instanceid=#childs[i][instanceid]# lastversionid=#childs[i][lastversionid]# parentid=#childs[i][parentid]# joininstanceid=#childs[i][joininstanceid]# objecttype=#childs[i][objecttype]# objectname=#childs[i][objectname]# basedir=#evaluate('request.application.object.object_' childs[i]['objectname'] '.location')# / /cfoutput /cfif /cfloop cfcatch cfoutput tree label=error:#xmlFormat(cfcatch.message)# cfloop collection=#cfcatch# item=cfcatchAttribute cfif isSimpleValue(cfcatch[cfcatchAttribute]) #cfcatchAttribute#=#xmlFormat(cfcatch[cfcatchAttribute])# cfelseif isArray(cfcatch[cfcatchAttribute]) cfloop from=1 to=#ArrayLen(cfcatch[cfcatchAttribute])# index=i cfif isStruct(cfcatch[cfcatchAttribute][i]) cfloop collection=#cfcatch[cfcatchAttribute][i]# item=cfcatchSubAttribute #cfcatchAttribute#_#i#_#cfcatchSubAttribute#=#xmlFormat(cfcatch[cfcatchAttribute][i][cfcatchSubAttribute])# /cfloop cfelseif isSimpleValue(cfcatch[cfcatchAttribute][i]) #cfcatchAttribute#_#i#=#xmlFormat(cfcatch[cfcatchAttribute][i])# /cfif /cfloop /cfif /cfloop icon=styles/blue/gfx/error.gif iconopen=styles/blue/gfx/error.gif iserror=true onloadevent=new function(){alert('expand this node automatically, = node.expand()')}/ /cfoutput /cfcatch /cftry ~| 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:193136 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: A brief question about lists
Hi Jim, And the results processed fairly quickly? Even with the log files? Thanks, Yves On Fri, 4 Feb 2005 14:54:08 -0500, Jim Davis [EMAIL PROTECTED] wrote: -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 2:43 PM To: CF-Talk Subject: A brief question about lists Hello, I was wondering if there are any guidelines, or limits in how many items can be in a list in a CF variable. I don't believe there is a limit (beyond hardware system limits) for size. I once ran a code challenge to tally the number of words in an arbitrary piece of text (for example the appears 35 times, We appears 3 times, etc) This was in CF 4.5/5.0 at the time (but I don't think it mattered) but one of the entries treated the text as a space-delimited list and looped over it. It worked just fine (and was actually one of the fastest entries) with text strings as large as the full novel Call of the Wild. I've also successfully done log file parsing in CF treating log files (even large ones) as carriage-return-delimited lists. In other words list can be very, very large. ;^) 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:193135 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 VS ASP.NET use
I'm gonna be a good boy and stay out of this one! :) Will ~| 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:193137 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 VS ASP.NET use
Good idea ;) Rey... - Original Message - From: Will Tomlinson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, February 04, 2005 2:33 PM Subject: Re: Coldfusion VS ASP.NET use I'm gonna be a good boy and stay out of this one! :) Will ~| 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:193138 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: Sql question
John Munyan wrote: I have a question about how a relationship would be best modeled in SQL. Currently I have a hiking website, which hosts trail reviews. People can add their own comments which are associated with the hike. For instance maybe I hiked snow lake on 12/1/05 and also 6/1/05. However, the user review gets associated with the instance of the hike either on 12/1/05. or 6/1/05. I want to combine these reviews so that they are associated with both. I think a group ID could be assigned so this could be accomplished. Hmm.. wouldn't just querying to figure out if there is another review from the same user.. for a same trail.. take care of that.. am I missing something here.. However... The real problem however is how to model something like this where one hike is a subset or superset of another. Take for instance this example. TrailHead---3miles--Snowlake2milesGemlake---1mile---WrightMountain. I would like the Snow lake reviews to be shown when either GemLake is viewed or Wright Mountain. However, I wouldn't want reviews for Gem Lake when the user is only intending to go to Snowlake. Thus the problem is how one would handle this superset/subset association of reviews. If anyone has any thoughts about how this would be handled I would be grateful for the advice. Simplest thing that comes to my mind is to create a another table.. which holds... review relationship between the trails.. snowLake : gemlake: snowLake,trailHead wrightMountain : snowLake trailHead : gemLake -- Umer Farooq Octadyne Systems +1 (519) 489-1119 voice +1 (519) 635-2795 mobile +1 (530) 326-3586 fax WEB SOLUTIONS FOR NON-PROFIT ORGANIZATION: http://www.Non-ProfitSites.biz WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| 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:193139 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: cfset ?
actually .net will (haha) its really easy to do in dreamweaver! set the default document type to be xhtml compliant in the preferences and then when done with page under commands select fix xhtml. u have to do a few things like adding alt text to images but u should be doing that anyway. a few simple steps really helps cross browser support, if now we could only get m$ to do the right thing and build ie right, it would be awesome! kinda screwwy how msn is now building cssp sites but yet refuse to have their own browser support it properly. hopefully they will get sick of having to hack their code to get it to work in their own browser but not holding my breath. overall, u really should be coding in xhtml! it is really sweet:) so much cleaner, leanerĀ faster! html is pretty forgiving on crappy, sloppy coding but xhtml is not, so if the browser isnt guessing what to do and can run straight through it, makes it much faster! kinda like calling a key in a structure or array instead of pulling it out of a list, in other words, it knows exactly whats its doing instead of searching, so speed is WHOO HOO! would be hilarious is the net switched to it today! can u see all them frontpage sites take a big ole dooky! on some other boards we were trying to help this guy make his code compliant but he refused to leave frontpage, its was totally amazing that u can not make that code compliant, no matter what u do! good stuff ms! keep up the good work haha From: Will Tomlinson [EMAIL PROTECTED] Sent: Friday, February 04, 2005 3:28 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: cfset ? This all translates to tens of thousands of extra keystrokes for me. And being the lazy coder that I am, I'll deem them unecessary! :) Will ~| 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:193140 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 VS ASP.NET use
he he me 2! that damn glorified frontpage junk! hahaha From: Will Tomlinson [EMAIL PROTECTED] Sent: Friday, February 04, 2005 3:33 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: Coldfusion VS ASP.NET use I'm gonna be a good boy and stay out of this one! :) Will ~| 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:193141 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: cfset ?
No no no!! I was a bit vague with my response there I guess. I AM coding everything xhtml, except those DAMN cfforms are still screwing me!! Friggin FORM in uppercase! Who's the idget that did that anyway?? In speaking of extra keystrokes, I'm talkin about cfset blah=blah / That's useless to me! I'm used to looking at the regular way, which in my mind, keeps consistency. Sorry super dave! THE GAME! ~| 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:193142 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: Sql question
Yes, the crux of the question is how to handle the subset question. In the below example a review left for SnowLake would be availble for the Snowlake Hike only. If I user left a review for Gem lake, then the review should be available for SnowLake or Gemlake since you pass by Snow lake on your way to Gem lake. Similiarly, Wright Mountain, would show reviews left for Wright Mountain, but also for Gem Lake and Snow lake since you pass by them en route to Wright Mountain. Thus how do you handle nesting of these elements where one is a subset of another... Thanks, John From: Umer Farooq [mailto:[EMAIL PROTECTED] Sent: Fri 2/4/2005 12:54 PM To: CF-Talk Subject: Re: OT: Sql question John Munyan wrote: I have a question about how a relationship would be best modeled in SQL. Currently I have a hiking website, which hosts trail reviews. People can add their own comments which are associated with the hike. For instance maybe I hiked snow lake on 12/1/05 and also 6/1/05. However, the user review gets associated with the instance of the hike either on 12/1/05. or 6/1/05. I want to combine these reviews so that they are associated with both. I think a group ID could be assigned so this could be accomplished. Hmm.. wouldn't just querying to figure out if there is another review from the same user.. for a same trail.. take care of that.. am I missing something here.. However... The real problem however is how to model something like this where one hike is a subset or superset of another. Take for instance this example. TrailHead---3miles--Snowlake2milesGemlake---1mile---WrightMountain. I would like the Snow lake reviews to be shown when either GemLake is viewed or Wright Mountain. However, I wouldn't want reviews for Gem Lake when the user is only intending to go to Snowlake. Thus the problem is how one would handle this superset/subset association of reviews. If anyone has any thoughts about how this would be handled I would be grateful for the advice. Simplest thing that comes to my mind is to create a another table.. which holds... review relationship between the trails.. snowLake : gemlake: snowLake,trailHead wrightMountain : snowLake trailHead : gemLake -- Umer Farooq Octadyne Systems +1 (519) 489-1119 voice +1 (519) 635-2795 mobile +1 (530) 326-3586 fax WEB SOLUTIONS FOR NON-PROFIT ORGANIZATION: http://www.Non-ProfitSites.biz WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| 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:193143 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: CFQuery SQL Scope of return?
MS SQL CFMX 6.1 How do you limit the score of info returned? or The equivalent of MySQL LIMIT #StartRow#, #NumberRows# To get the first 5 rows: SELECT TOP 5 ... To get the second 5 rows: SELECT TOP 5 ... FROM ... WHERE field NOT IN (SELECT TOP 5 ...) 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:193145 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: CFQuery SQL Scope of return?
SELECT TOP x.. However.. MS SQL Server does not support select range type quries. If your table does not contain lot of data.. look at CFOUTPUT controls.. otherwise.. SQL StoredProc would give you good results.. Nick Baker wrote: MS SQL CFMX 6.1 How do you limit the score of info returned? or The equivalent of MySQL LIMIT #StartRow#, #NumberRows# Thanks, Nick -- Umer Farooq Octadyne Systems +1 (519) 489-1119 voice +1 (519) 635-2795 mobile +1 (530) 326-3586 fax WEB SOLUTIONS FOR NON-PROFIT ORGANIZATION: http://www.Non-ProfitSites.biz WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| 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:193144 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 VS ASP.NET use
I'd agree with that. The Apache web server is probably in the same category--used more in public hosting environments and less behind corporate firewalls, so surveys that only measure public web servers (such as Netcraft) tend to be skewed. Vince -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 1:47 PM To: CF-Talk Subject: RE: Coldfusion VS ASP.NET use Dave, honestly, I don't think anyone really knows the answer to that one. But it is clear that some technologies tend to be used less in internal corporate development (PHP is a perfect example of this) meaning that proportionally there is more of them public facing and that skews any extrapolation of total use based on public facing use. --- Ben -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 12:57 PM To: CF-Talk Subject: RE: Coldfusion VS ASP.NET use And keep in mind that over 80% of CF use is internal stuff, behind firewalls, stuff Google will never see. Isn't that equally true for every other web application server technology? 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! ~| 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:193146 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: cfset ?
yeah i know just given ya a hard time ;) actually i thought u meant xhtml, sorry i gots a hottie on my mind! From: Will Tomlinson [EMAIL PROTECTED] Sent: Friday, February 04, 2005 4:10 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: cfset ? No no no!! I was a bit vague with my response there I guess. I AM coding everything xhtml, except those DAMN cfforms are still screwing me!! Friggin in uppercase! Who's the idget that did that anyway?? In speaking of extra keystrokes, I'm talkin about That's useless to me! I'm used to looking at the regular way, which in my mind, keeps consistency. Sorry super dave! THE GAME! ~| 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:193147 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: A brief question about lists
-Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 3:32 PM To: CF-Talk Subject: Re: A brief question about lists Hi Jim, And the results processed fairly quickly? Even with the log files? Well - the log file stuff I only did in CF 4.5. They were quick enough, but the processing was vastly more complicated than just looping over the list (the logs were made up of many values, some of which where WDDX packets that had to be dealt with and each row could result in several database writes). But still - the performance was acceptable (and by that I mean a big file could take 10 or 20 minutes to process). CFMX is, on average, about 2-4 times faster than CF 4.5 (sometimes less, but mostly more). Also since list management code was some of the oldest in CF (even in CF 5.0 some of that code dated back to CF 2.0) it got a lot of attention in CFMX - it's actually PDQ right now. Depending on your lit contents 350 items really shouldn't be a problem for most apps. You'd probably be able to do things quicker, but sometimes fast enough is good enough. ;^) What matters more, to me, is how often the code is run and how visible it is. A log-file processor that (like mine) ran once a day at 2AM as an automated process doesn't really need to be super-optimized. But a process that runs every request or could cause a user to wait for a while should be looked at seriously. I would try out a sample and time it using getTickCount() - my guess is that you'll be pleasantly surprised. Jim Davis ~| 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:193148 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 VS ASP.NET use
too me its like this, ms has a tendency to drop things everytime someone has something new (look no futher than asp or google type searches or anti-spyware, which is hilarious because their browser installs the spyware then u gotta pay them to buy their ani-spyware to get rid of it and make them look like saviors, same as aol) and their problem is they cant come up with really anything original on their own, they just wait for someone to do it then they try to dup it then run the original ppl under. coldfusion has been around and keeps growing and getting better and it has a solid history, its never just been dumped. maybe .net is todays flava but in a way im not sure what will happen down the line, maybe im just ignorant. but i see things really going down the compliancy highway and even .net code has to be pretty well tweaked to get there. which may seem like a small thing but u add the rising of alt browsers and the growing trends of validation, it really sets up 2 sides, those that follow (most everyone) and those that dont (ms) at some point i think ppl are just gunna flat get sick of the patching and hacking to get things to work right and ms is gunna fall outta favor with a lot of ppl. and i would imagine if their patching gets any worse more ppl will be switching to linux servers and well ms has messed that up too by trying to make .net only run on windows (imagine that) and not talking bout cfm.net(bd) cause im sure that pisses ms to off to hell and back!. so when i see their vp saying hes not worried about firefox and that whole movement, i have to wonder and its a much bigger deal than just the browsers. but anyways, with their history, i can see .net go up a bit more then fall. at some point they gotta put some money and effort in fixing there os systems instead of putting it towards (so called free) stuff like .net or they will be in big trouble and thats where .net is gunna tumble. not trying to diss ms, just my thoughts :) ~| 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:193149 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