Re: Odd MySQL error...
Are your database and CF server on different networks? We saw this problem before our launch when we were just hitting the database (on a host) while developing locally. When the code and the database are on the same network, that problem went away for us. On Wed, Jun 23, 2010 at 1:34 PM, Mallory Woods mallory.wo...@gmail.comwrote: We have been dealing with a MySQL error for a little while and can't seem to figure out what is causing it. This error appears on our production server: Red Hat Linux Enterprise 64 bit MySQL 5.0.77 CF 9 This error happens any time, day or night and sometimes in multiple occurrences and from different pages. I am guessing that normal site operations continues after the user gets this error and refreshes their browser as we don't hear any complaints from users about it. The error appears in our logs and we would love to get rid of it. The main error is: * **Error Executing Database Query. Communications link failure Last packet sent to the server was 0 ms ago. brThe error occurred on line 6. * -- - Scott Brady http://www.scottbrady.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334798 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is it time for Adobe to Rebrand Cold Fusion?
Of course, one downside to that (from the company's standpoint) is once they announce the name, they're kind of locked into a timeline. So, they may release a buggier version of ColdFusion 2011 just to get it out before the end of 2011 rather than having to release CF2011 in 2012 or having to rename it. Scott On Tue, Jun 22, 2010 at 7:47 AM, Raymond Camden rcam...@gmail.com wrote: Ok, I'm now straying into OT area, but I must be the only who liked the idea of PRODUCT YEAR as a brand. Ie, Windows 95, Windows 98, Windows 2000. To me it was a very clear way to know the release of the version you are using. -- - Scott Brady http://www.scottbrady.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334797 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfdot.net
I don't know if I totally agree with that. Does the C# code follow best practices for C#? When doing a comparison between two languages you should use best practices for both languages. After all for good code we should all use best practices. I was taught that when using Java (not entirely different) that I should never assume that a package is included and to manually include it. Also that the direct method you used earlier should also be avoided unless absolutely necessary. Steve -Original Message- From: Matthew Small [mailto:chestypul...@beachbum.net] Sent: Wednesday, June 23, 2010 3:46 PM To: cf-talk Subject: Re: cfdot.net Actually, the siute is dishonest, not necessarily the person. Apologies for the harsh wording. My judgment still stands. It doesn't matter why it's wrong, it's still misrepresenting one side. No flame wars needed. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334803 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Array of struct into ORACLE using stored procedures
In Cold Fusion I have a large array of struct I'm trying to pass into ORACLE 10g using stored procedures. I am hitting a performance wall inside ORACLE (probably self inflicted). I don't know of a way to transfer a complex array directly to ORACLE -- if there is, I'd love to hear it. So what I've done is translate the array into a CLOB of delimited values where each array element is separated by a semicolon and each property value by a comma like: Prop1,prop2,prop3;Prop1,prop2,prop3;Prop1,prop2,prop3;Prop1,prop2,prop3; I can then pass the CLOB into ORACLE where I wrote a little parsing procedure that pulls the data elements out into a Global Temporary table which I then can merge into other data tables. The issue seems to be on the ORACLE end. It is taking too long to parse when the array gets large (10k rows takes about 4 mins). What I need is either a different method to move the array into ORACLE or to improve my parsing routine (see attached). Ideas? Warren Koch 314-323-2298 PROCEDURE get_items IS /* This routine extracts the item values from the input string into a global temporary table RENT_IMPORT_ITEMS It uses two delimiters: ; to separate items , to separate values */ instringCLOB; data_string VARCHAR2(2000); data_item VARCHAR2(100); data_type VARCHAR2(100); data_revVARCHAR2(100); data_shtVARCHAR2(100); data_location INTEGER; BEGIN instring := UPPER(TRIM(in_list_items)) || ';'; data_location := INSTR(instring, ';'); EXECUTE IMMEDIATE 'TRUNCATE TABLE RENT_IMPORT_ITEMS '; WHILE data_location 0 LOOP data_string := SUBSTR(instring, 1, data_location - 1); data_string := REPLACE(data_string || '', ',', ' ,'); BEGIN SELECT SUBSTR(TRIM(REGEXP_SUBSTR(data_string, '[^,]+', 1, 1)), 1, 35) INTO data_item FROM DUAL; SELECT SUBSTR(TRIM(REGEXP_SUBSTR(data_string, '[^,]+', 1, 2)), 1, 5) INTO data_type FROM DUAL; SELECT SUBSTR(TRIM(REGEXP_SUBSTR(data_string, '[^,]+', 1, 3)), 1, 4) INTO data_rev FROM DUAL; SELECT SUBSTR(TRIM(REGEXP_SUBSTR(data_string, '[^,]+', 1, 4)), 1, 20) INTO data_sht FROM DUAL; INSERT INTO rent_import_items (item, item_type, item_rev, item_sht ) VALUES (data_item, data_type, data_rev, data_sht ); EXCEPTION WHEN OTHERS THEN NULL; END; instring := SUBSTR(instring, data_location + 1); data_location := INSTR(instring, ';'); END LOOP; EXCEPTION WHEN OTHERS THEN RAISE; END; ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334807 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfdot.net
@Paul you have hit the nail on the head that is exactly the purpose of the site. @Matthew - The site is NOT dishonest every example provides a solution that is viable. I think you have some misguided deeper issues and appear to see this as some sort of 'Coldfusion is better that .Net' battle, it;s not! You are entitled to your opinion but I cannot just stand by and have you say the site is dishonest when it is not. Maybe instead of being obstructive you should be a bit more constructive, On Wed, Jun 23, 2010 at 10:40 PM, Bobby Hartsfield bo...@acoderslife.comwrote: Well put. .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Eric Cobb [mailto:cft...@ecartech.com] Sent: Wednesday, June 23, 2010 3:28 PM To: cf-talk Subject: Re: cfdot.net Calling him dishonest is very short sighted on your part (to say the least!). Has the thought occurred to you that perhaps the reason there was so much extra code in the .Net example was because he's not a seasoned .Net developer? I know I certainly wouldn't know the absolute best way to do something when just transferring over to a new language. I'm willing to bet there are many seasoned .Net developers who would make plenty of rookie mistakes when just starting out with CF. Perhaps instead of jumping to conclusions and making accusations, you should offer to help him clean up his examples so they are more accurate. Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com Matthew Small wrote: All language religion aside - it's not a fair comparison, it's biased towards CF. You should be more honest in your comparisons if you expect anyone to take it seriously. Example: CFEXECUTE: CF: cfexecute name=C:\WinNT\System32\netstat.exe /cfexecute ASP.NET http://asp.net/ 01.using System; 02.using System.Drawing; 03.using System.Collections; 04.using System.ComponentModel; 05.using System.Windows.Forms; 06.using System.Data; 07.using System.Diagnostics; 08. 09.... 10. 11.//Declare and instantiate a new process component. 12.System.Diagnostics.Process process1; 13.process1= new System.Diagnostics.Process(); 14. 15.//Do not receive an event when the process exits. 16.process1.EnableRaisingEvents = false; 17. 18. 19.//The /C Tells Windows to Run The Command then Terminate 20.string strCmdLine; 21.strCmdLine = /C netstat ; 22.System.Diagnostics.Process.Start(CMD.exe,strCmdLine); 23.process1.Close(); All that is actually needed is: System.Diagnostics.Process.Start(netstat.exe); All of the other stuff is extraneous. The need for the using statements is negated by the fully-qualified name for the method. The object process1 isn't used at all for the actual execution. Passing the netstat.exe executable to the cmd.exe process is ridiculous - you could do the same with CFEXECUTE. Adding in extra string arguments just builds up the amount of code you want to display. And FYI: this one line of code can be executed in the .aspx page: % System.Diagnostics.Process.Start(netstat.exe) % There are numerous similar examples on your website. It's a dishonest misrepresentation. - Matt Small This is pretty sweet Jose. Thanks for taking the time to create this site! An excellent resource indeed. Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Railo Community Distributions On 06/22/2010 06:47 AM, Jose Diaz wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334802 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is it time for Adobe to Rebrand Cold Fusion?
With the limitations on budget in today's economic, few companies can afford money for both. I'd much rather the money be spent on development. Frankly, if I get another overpriced glossy marketing packet from Abode when they are cutting staff in product development, I'm gonna barf. On Wed, Jun 23, 2010 at 4:05 PM, Dorioo dor...@gmail.com wrote: Maureen, can't both be done? They're not mutually exclusive. Especially when marketing and development are not that dependent on each other. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334800 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How can you GetFileInfo for a datasource?
correct me if i am wrong (i am not a .Net developer in any way), but doesn't your .Net code expect you to provide the path to the db as well? or is Session(DBpath) some variable automatically created by .Net? Azadi On 24/06/2010 05:43, John Pullam wrote: This info is not made readily available unless you unlock it. You need access to the database... Open the database Go to tools--Options Check the box under *show* that says *system Objects*. You will notice that several new tables appear in table view with the prefix MSys - MSysAccessObjects, MSysAces, MSysObjects, MSysQueries, MSysRelationships, and there may be a few others depending on your version of Access. Now Go to Tools--Security--User and Group Permissions Select the MSysObjects table and check the box that says Read Data Then... The database is created in a 3rd party application and a copy is sent to my website every 15 minutes, so it isn't practical to change the database itself. I dislike .Net but it certainly was simple there. It took 3 lines: db = Session(DBpath) myDB.mdb Dim myFile as FileInfo = New FileInfo(db) Dim ModDate as Date = myFile.LastWriteTime SELECT UpdateDate FROM MSysObjects /CFQUERY cfdump var=#getSysData# Jim Eisenhauer ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334799 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Odd MySQL error...
Thanks for the suggestions. I will follow up on both tomorrow in the office. I will see if there are any other networking issues when this happens. Thanks again and if there are any other suggestions, please keep them coming. On Wed, Jun 23, 2010 at 4:01 PM, Matthew Small chestypul...@beachbum.netwrote: It sounds like a networking error more than an app error. You might try running Wireshark with a limited-size looping buffer to try to capture a trace of the problem. Also, do you have any other network issues during the time of the issue? We have been dealing with a MySQL error for a little while and can't seem to figure out what is causing it. This error appears on our production server: Red Hat Linux Enterprise 64 bit MySQL 5.0.77 CF 9 This error happens any time, day or night and sometimes in multiple occurrences and from different pages. I am guessing that normal site operations continues after the user gets this error and refreshes their browser as we don't hear any complaints from users about it. The error appears in our logs and we would love to get rid of it. The main error is: * **Error Executing Database Query. Communications link failure Last packet sent to the server was 0 ms ago. brThe error occurred on line 6. * Stack Trace: Message Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. StackTrace java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2455) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2906) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2895) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3438) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement. java:1761) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement. java:1021) at coldfusion.server.j2ee.sql.JRunPreparedStatement. execute(JRunPreparedStatement.java:91) at coldfusion.sql.Executive.executeQuery(Executive.java:1245) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533) at cfaction2epage2edefault2ecfm19563856._factor4(/var/www/html/action. page.default.cfm:6) at cfaction2epage2edefault2ecfm19563856.runPage(/var/www/html/action.page. default.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfindex2ecfm500695976.runPage(/var/www/html/index.cfm:56) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:363) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter. java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:87) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter. invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet. java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter. doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter. java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher. java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService. java:543) at
Re: cfdot.net
To help people even further I also started a video series for each example - only one of the examples currently shows this but if people like them I am more than happy to provide them for all of the examples. http://www.cfdot.net/cfdot/Pages/CodeDetail.aspx?id=70 Jose Diaz :) On Thu, Jun 24, 2010 at 7:26 AM, Jose Diaz bleached...@gmail.com wrote: @Paul you have hit the nail on the head that is exactly the purpose of the site. @Matthew - The site is NOT dishonest every example provides a solution that is viable. I think you have some misguided deeper issues and appear to see this as some sort of 'Coldfusion is better that .Net' battle, it;s not! You are entitled to your opinion but I cannot just stand by and have you say the site is dishonest when it is not. Maybe instead of being obstructive you should be a bit more constructive, On Wed, Jun 23, 2010 at 10:40 PM, Bobby Hartsfield bo...@acoderslife.comwrote: Well put. .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Eric Cobb [mailto:cft...@ecartech.com] Sent: Wednesday, June 23, 2010 3:28 PM To: cf-talk Subject: Re: cfdot.net Calling him dishonest is very short sighted on your part (to say the least!). Has the thought occurred to you that perhaps the reason there was so much extra code in the .Net example was because he's not a seasoned .Net developer? I know I certainly wouldn't know the absolute best way to do something when just transferring over to a new language. I'm willing to bet there are many seasoned .Net developers who would make plenty of rookie mistakes when just starting out with CF. Perhaps instead of jumping to conclusions and making accusations, you should offer to help him clean up his examples so they are more accurate. Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com Matthew Small wrote: All language religion aside - it's not a fair comparison, it's biased towards CF. You should be more honest in your comparisons if you expect anyone to take it seriously. Example: CFEXECUTE: CF: cfexecute name=C:\WinNT\System32\netstat.exe /cfexecute ASP.NET http://asp.net/ 01.using System; 02.using System.Drawing; 03.using System.Collections; 04.using System.ComponentModel; 05.using System.Windows.Forms; 06.using System.Data; 07.using System.Diagnostics; 08. 09.... 10. 11.//Declare and instantiate a new process component. 12.System.Diagnostics.Process process1; 13.process1= new System.Diagnostics.Process(); 14. 15.//Do not receive an event when the process exits. 16.process1.EnableRaisingEvents = false; 17. 18. 19.//The /C Tells Windows to Run The Command then Terminate 20.string strCmdLine; 21.strCmdLine = /C netstat ; 22.System.Diagnostics.Process.Start(CMD.exe,strCmdLine); 23.process1.Close(); All that is actually needed is: System.Diagnostics.Process.Start(netstat.exe); All of the other stuff is extraneous. The need for the using statements is negated by the fully-qualified name for the method. The object process1 isn't used at all for the actual execution. Passing the netstat.exe executable to the cmd.exe process is ridiculous - you could do the same with CFEXECUTE. Adding in extra string arguments just builds up the amount of code you want to display. And FYI: this one line of code can be executed in the .aspx page: % System.Diagnostics.Process.Start(netstat.exe) % There are numerous similar examples on your website. It's a dishonest misrepresentation. - Matt Small This is pretty sweet Jose. Thanks for taking the time to create this site! An excellent resource indeed. Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Railo Community Distributions On 06/22/2010 06:47 AM, Jose Diaz wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334804 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How can you GetFileInfo for a datasource?
I have a datasource that points to an Access database (no editorializing please, I didn't create it). I need to do a GetFileInfo on it to obtain the last modified date. This was pretty easy in .Net (I'm converting it from .Net to CF) but I can't figure out how to do it in CF. GetFileInfo requires an absolute path ... is there a simple way to get the absolute path for a datasource? If it's a registered CF datasource, you can probably get that sort of info using the CF Admin API. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334808 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How can you GetFileInfo for a datasource?
I dislike .Net but it certainly was simple there. It took 3 lines: db = Session(DBpath) myDB.mdb Dim myFile as FileInfo = New FileInfo(db) Dim ModDate as Date = myFile.LastWriteTime That makes it look like the path was really just in a Session var in .NET; is that the case? If so, then just do the same in CF: !--- this could be set in Application.cfc or wherever --- cfset session.DBpath = path to the directory / ... cfset db = myDB.mdb / !--- note there's no path info here --- cfdirectory action=LIST directory=#session.DBpath# filter=#db# name=myFile / cfset ModDate = myFile.dateLastModified / ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Odd MySQL error...
On Wednesday 23 Jun 2010 21:27:06 you wrote: If looks like your server is getting random intermittent connection drops from your MySQL server (I'm assuming it's remote) You could turn off persistent connections too. -- Tom Chiverton Helping to evangelistically innovate eigth-generation interfaces as part of the IT team of the year 2010, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334806 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ScriptProtect error replacing insecure tag in scope CGI ??
Hi cftalk: We are running CF8. I am seeing a strange application error ScriptProtect error replacing insecure tag in scope CGI. The error occurred on line -1.. Strangely, there are very few google references to this error, and absolutely no explanations / solutions that I can find. We use ScriptProtect = ALL, and most of the time URL/FORM substitution works fine. It converts script to INVALIDTAG as expected, etc. However, we get this ScriptProtect error if we pass in the URL: http://www.SERVER.com/search.cfm?querystring=javascript:alert%28412898284482%29 Clearly this has nothing to do with the CGI scope, so I'm a little confused at why an error is being thrown. Our neo-security.xml file contains this bit, which deals with javascript: var name=javascript: stringjava-script:/string /var Thanks for any help! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334810 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How can you GetFileInfo for a datasource?
You are correct. I made an assumption that was incorrect and now realize that it was the same issue in .Net. For what its worth, I have decided to base the file location on the relative location from my website root. That is not likely to change while the ISP could always reqyuire me to move the entire website. My final code is: cfset LastUpdated=GetFileInfo(ExpandPath(/) App_Data\MyDatabase.mdb).LastModified ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334809 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Shopping carts
cw is the biggest clusterfuck-o-code ever.. be sure to bring lots of spaghetti sauce for that spaghetti coded buffet ;) Have you checked out Cartweaver yet? https://www.cartweaver.com/store/detail/?id=cw3cfm It's a cheap $300 and is licensed per developer, not per site. Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Railo Community Distributions On 06/18/2010 09:26 PM, Eric Roberts wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334811 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfdot.net
Wait - so now I have psychological issues? I didn't attack you, I attacked the site based on the fact that *you* said it shows how 1 line of CF code equates to 10 lines of ASP.NET and how it was a jab at .NET: Unfortunatly the company I work for decided to move away from CF :( and proceeded to get shot of all the cf devs we had. I was one of two survivors who they see as legacy application developers grr even thou I decided to become an MCPD, they still see us a just CF devs. Anyhoo I did build the following site: www.cfdot.net which shows code comparisons for most of the common langauge syntax tasks. If anything it will show how CF achieves in one line what .net does in 10 ;) (my little dig back heh) Now you say it's something else. You should stick to one argument and you might make sense. The fact is, your site is dishonest based on your own comments and I explained how I thought it so. Nobody yet has shown how my analysis was wrong, they just kept saying that I called you a dishonest person and set about defending you because you might not be very good at programming .NET when you wrote the site and then told me that I need to fix your site. I have no desire to be constructive to fix some random site on the internet. My purpose was to call BS when I saw it because it feels good to do that. This is the very definition of an ad hominem attack. @Paul you have hit the nail on the head that is exactly the purpose of the site. @Matthew - The site is NOT dishonest every example provides a solution that is viable. I think you have some misguided deeper issues and appear to see this as some sort of 'Coldfusion is better that .Net' battle, it;s not! You are entitled to your opinion but I cannot just stand by and have you say the site is dishonest when it is not. Maybe instead of being obstructive you should be a bit more constructive, On Wed, Jun 23, 2010 at 10:40 PM, Bobby Hartsfield bo...@acoderslife.comwrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334812 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfdot.net
...and I dare anyone to define said best practicesthere in lies the problem with this debate ;-) best is far too subjectivethere are shades of grey (and there is no spoon) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. Please consider the environment before printing this e-mail ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334813 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is it time for Adobe to Rebrand Cold Fusion?
Ok, I'm now straying into OT area, but I must be the only who liked the idea of PRODUCT YEAR as a brand. Ie, Windows 95, Windows 98, Windows 2000. To me it was a very clear way to know the release of the version you are using. This sounds perfect for Rick. Where's dave when we need'em?? :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334814 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How can you GetFileInfo for a datasource?
You are correct. I made an assumption that was incorrect and now realize that it was the same issue in .Net. For what it's worth, I have decided to base the file location on the relative location from my website root. That is not likely to change, but the ISP could always require me to move the entire website. My final code is: cfset LastUpdated=GetFileInfo(ExpandPath(/) App_Data\MyDatabase.mdb).LastModified ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334815 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is it time for Adobe to Rebrand Cold Fusion?
With the limitations on budget in today's economic, few companies can afford money for both. I'd much rather the money be spent on development. Frankly, if I get another overpriced glossy marketing packet from Abode when they are cutting staff in product development, I'm gonna barf. As someone that is in software development and sales myself I can say that you won't HAVE any money for development UNLESS you have sales. So you absolutely need to be putting resources into both. Sure, as a developer in CF I'd prefer that the bulk of resources go to development but that's just not reasonable to expect that all of it would. If in a bad economy that means cutting back some on development, that's understandable. If Adobe feels rebranding will help increase exposure and/or interest in the product, then it certainly should be looked at. I'm dubious that it would make much difference and can't imagine after all these years having to refer to it as anything but ColdFusion but if it might help uptake among certain markets, I can live with that. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334816 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ScriptProtect error replacing insecure tag in scope CGI ??
However, we get this ScriptProtect error if we pass in the URL: http://www.SERVER.com/search.cfm?querystring=javascript:alert%28412898284482%29 Clearly this has nothing to do with the CGI scope, so I'm a little confused at why an error is being thrown. It does, in fact, have something to do with the CGI scope. All the data sent by the browser as part of the request header, including the query string, are in the CGI scope. And allowing a JavaScript command to be passed in the query string is probably not such a good idea anyway. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334817 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Seriously PO'd - cfqueryparam and/or struct dereference flakes out
The function below was written literally MONTHS ago. Worked fine the whole time, even today... then suddenly it's throwing the error: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER. The error points to the line in the WHERE clause, referencing a.articleId. Next, I purposely set the output=true on this function, and did a cfdump of #a.articleId# -- it's definitely a valid integer. but it's now choking on it for some reason. as a test, i hard coded an article id into the where clause, removing the cfqueryparam. with a hard coded number, it chokes on the next cfqueryparam up. if i reference #a.articleId# directly (outside of cfqueryparam), I also get the same error. how can a.articleId suddenly become '' right after dumping it and successfully showing it to be an integer?? I've restarted both the cf server and the database server, wondering if there was some sort of strange hangup there... no joy. I'm losing my mind... help!! cffunction name=updateArticle returntype=void access=private output=true cfargument name=structArticle required=true type=Struct hint=A structure containing all fields of an article, and the values to be saved. cfset var a = arguments.structArticle cfset var qUpdateArticle = !--- uncommenting this line gives me a valid integer on screen --- !--- cfdump var=#a.articleId#cfabort --- cfquery name=qUpdateArticle datasource=#request.dsn# UPDATE Article SET categoryId = cfqueryparam value=#a.categoryId# cfsqltype=cf_sql_integer /, title = cfqueryparam value=#a.title# cfsqltype=cf_sql_varchar /, byLine = cfqueryparam value=#a.byLine# cfsqltype=cf_sql_varchar /, imageId = cfqueryparam value=#a.imageId# cfsqltype=cf_sql_integer /, imageCaption = cfqueryparam value=#a.imageCaption# cfsqltype=cf_sql_varchar /, abstract = cfqueryparam value=#a.abstract# cfsqltype=cf_sql_varchar /, body = cfqueryparam value=#a.body# cfsqltype=cf_sql_varchar /, isLead = cfqueryparam value=#a.isLead# cfsqltype=cf_sql_bit /, publishDateTime = cfqueryparam value=#a.publishDateTime# cfsqltype=cf_sql_timestamp / WHERE articleId = cfqueryparam value=#a.articleId# cfsqltype=cf_sql_integer / /cfquery /cffunction ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334818 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfdot.net
Nobody yet has shown how my analysis was wrong, they just kept saying that I called you a dishonest person and set about defending you because you might not be very good at programming .NET when you wrote the site and then told me that I need to fix your site. I have no desire to be constructive to fix some random site on the internet. My purpose was to call BS when I saw it because it feels good to do that. Without getting into motives or honesty or any of that, I have to say I agree with Matthew. If you want to provide a side-by-side code comparison, the two snippets should be analogous in functionality. I've only looked at the CFEXECUTE example, but those two snippets clearly aren't entirely analogous in functionality - there are a lot of dead lines in the .NET example. There are two problems with that. One problem is that it looks like advocacy when maybe that's not your intent. I don't really care too much about that, but it doesn't help your argument if that's the argument you're trying to make. The other problem, and the one that is more serious in my opinion, is that it doesn't tell the CF developer what is really needed. Do I really need to import all these libraries? Why? What happens if I don't import them? (Fortunately, I know enough C# to know which ones I need for that example, but if I actually used that snippet as-is in VS.NET, I'd expect that it would tag those lines with warnings that they're not used by the code. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334819 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Is it time for Adobe to Rebrand Cold Fusion?
Not really...they do what they have been doing...until the final release is ready call it names like Scorpio. -Original Message- From: Scott Brady [mailto:dsbr...@gmail.com] Sent: Wednesday, June 23, 2010 9:03 PM To: cf-talk Subject: Re: Is it time for Adobe to Rebrand Cold Fusion? Of course, one downside to that (from the company's standpoint) is once they announce the name, they're kind of locked into a timeline. So, they may release a buggier version of ColdFusion 2011 just to get it out before the end of 2011 rather than having to release CF2011 in 2012 or having to rename it. Scott On Tue, Jun 22, 2010 at 7:47 AM, Raymond Camden rcam...@gmail.com wrote: Ok, I'm now straying into OT area, but I must be the only who liked the idea of PRODUCT YEAR as a brand. Ie, Windows 95, Windows 98, Windows 2000. To me it was a very clear way to know the release of the version you are using. -- - Scott Brady http://www.scottbrady.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334820 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Seriously PO'd - cfqueryparam and/or struct dereference flakes out
When CF throws an error on a stored proc, it will usually reference the last line of the stored proc, not necessarily which line has bad data. If I were you, I would dump the values that are being sent into the stored proc and review to see if any of it is null or blank (or string) going into any of the integer declared procparams. Hope this helps, William -- William E. Seiter On Jun 24, 2010, Marc Funaro subscripti...@advantex.net wrote: The function below was written literally MONTHS ago. Worked fine the whole time, even today... then suddenly it's throwing the error: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER. The error points to the line in the WHERE clause, referencing a.articleId. Next, I purposely set the output=true on this function, and did a cfdump of #a.articleId# -- it's definitely a valid integer. but it's now choking on it for some reason. as a test, i hard coded an article id into the where clause, removing the cfqueryparam. with a hard coded number, it chokes on the next cfqueryparam up. if i reference #a.articleId# directly (outside of cfqueryparam), I also get the same error. how can a.articleId suddenly become '' right after dumping it and successfully showing it to be an integer?? I've restarted both the cf server and the database server, wondering if there was some sort of strange hangup there... no joy. I'm losing my mind... help!! cffunction name=updateArticle returntype=void access=private output=true cfargument name=structArticle required=true type=Struct hint=A structure containing all fields of an article, and the values to be saved. cfset var a = arguments.structArticle cfset var qUpdateArticle = !--- uncommenting this line gives me a valid integer on screen --- !--- cfdump var=#a.articleId#cfabort --- cfquery name=qUpdateArticle datasource=#request.dsn# UPDATE Article SET categoryId = cfqueryparam value=#a.categoryId# cfsqltype=cf_sql_integer /, title = cfqueryparam value=#a.title# cfsqltype=cf_sql_varchar /, byLine = cfqueryparam value=#a.byLine# cfsqltype=cf_sql_varchar /, imageId = cfqueryparam value=#a.imageId# cfsqltype=cf_sql_integer /, imageCaption = cfqueryparam value=#a.imageCaption# cfsqltype=cf_sql_varchar /, abstract = cfqueryparam value=#a.abstract# cfsqltype=cf_sql_varchar /, body = cfqueryparam value=#a.body# cfsqltype=cf_sql_varchar /, isLead = cfqueryparam value=#a.isLead# cfsqltype=cf_sql_bit /, publishDateTime = cfqueryparam value=#a.publishDateTime# cfsqltype=cf_sql_timestamp / WHERE articleId = cfqueryparam value=#a.articleId# cfsqltype=cf_sql_integer / /cfquery /cffunction ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334821 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Shopping carts
I feel that this is one area that is completely overlooked in the CF world-- Especially since OO was introduced to CF in MX. CF would be such a great platform to develop a awesome open source shopping cart/administration system. It would be easy to modularize with add-ons components etc... Ii'll bet most of what a OS CF commerce system requires already exists in the wild, but just needs to be put together in a cohesive platform. A lot of components could actually be modeled off other systems like Magento or OsCommerce I would be willing to dedicate financial ($$) resources and time in something like this if the community was in need and willing to participate. It is something we should all consider; When searching the web for PHP carts there are hundreds-- in the CF world there are just a meager few, and like @Dave mentioned about cw, every CF cart I have seen is procedural spaghetti at best, or not FOSS. I written some half-baked code years ago for a cart, some has been re factored into OO. But it is no way ready for prime time and was build specific for existing internal systems so it is very limited in administration ability. But it has been used on several sites for many years with no issues, so I know it can be done. I think if a open source CF commerce system was approached from the CF community mind-set it may turn into something that could be used in any framework/engine. I have seen what the CF community is capable of-- and it is nothing short of astounding, so I am 100% confident it could be done. What does everyone else think about this? Would this be something that the community could use and would participate? If I get a decent response I will set up hosting, a .org, a git repo and consult with my people about the legalese involved. I would also be willing pay some of the more prominent CFr's for consulting/code/advice on this-- as I know some peoples advice/code/talent is worth every penny. Please chime in everyone, no matter your ability's-- this is something that does not exist yet, and we as a group have the ability to make it happen. -- /Kevin Pepperman They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. - Benjamin Franklin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334822 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF Shopping carts
I think that would be great. My expdereince with Able Commerce was horrible. That made spaghetti code look like textbook OO code. Mary Jo's CFWebstore was much better...just a bit too pricey for most of my client's budgets. I did use it once with a client and it was pretty good. I haven't really dug into others, but we are looking. If this does go through, we should also keep in mind server restrictions as many people are on shared hosting...or at least have a safe cersion of it that would either get around these restrictions or avoid them completely. Cost and server restrictions have been my main obstacles at this juncture of my search. Eric -Original Message- From: Kevin Pepperman [mailto:chorno...@gmail.com] Sent: Thursday, June 24, 2010 6:42 PM To: cf-talk Subject: Re: CF Shopping carts I feel that this is one area that is completely overlooked in the CF world-- Especially since OO was introduced to CF in MX. CF would be such a great platform to develop a awesome open source shopping cart/administration system. It would be easy to modularize with add-ons components etc... Ii'll bet most of what a OS CF commerce system requires already exists in the wild, but just needs to be put together in a cohesive platform. A lot of components could actually be modeled off other systems like Magento or OsCommerce I would be willing to dedicate financial ($$) resources and time in something like this if the community was in need and willing to participate. It is something we should all consider; When searching the web for PHP carts there are hundreds-- in the CF world there are just a meager few, and like @Dave mentioned about cw, every CF cart I have seen is procedural spaghetti at best, or not FOSS. I written some half-baked code years ago for a cart, some has been re factored into OO. But it is no way ready for prime time and was build specific for existing internal systems so it is very limited in administration ability. But it has been used on several sites for many years with no issues, so I know it can be done. I think if a open source CF commerce system was approached from the CF community mind-set it may turn into something that could be used in any framework/engine. I have seen what the CF community is capable of-- and it is nothing short of astounding, so I am 100% confident it could be done. What does everyone else think about this? Would this be something that the community could use and would participate? If I get a decent response I will set up hosting, a .org, a git repo and consult with my people about the legalese involved. I would also be willing pay some of the more prominent CFr's for consulting/code/advice on this-- as I know some peoples advice/code/talent is worth every penny. Please chime in everyone, no matter your ability's-- this is something that does not exist yet, and we as a group have the ability to make it happen. -- /Kevin Pepperman They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. - Benjamin Franklin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334823 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Seriously PO'd - cfqueryparam and/or struct dereference flakes out
The line number given is always the last line of the query. Make sure all the other values are what they are supposed to be. Wil Genovese Sr. Web Application Developer/ Systems Administrator Wil Genovese Consulting wilg...@trunkful.com www.trunkful.com On Jun 24, 2010, at 5:43 PM, Marc Funaro wrote: The function below was written literally MONTHS ago. Worked fine the whole time, even today... then suddenly it's throwing the error: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER. The error points to the line in the WHERE clause, referencing a.articleId. Next, I purposely set the output=true on this function, and did a cfdump of #a.articleId# -- it's definitely a valid integer. but it's now choking on it for some reason. as a test, i hard coded an article id into the where clause, removing the cfqueryparam. with a hard coded number, it chokes on the next cfqueryparam up. if i reference #a.articleId# directly (outside of cfqueryparam), I also get the same error. how can a.articleId suddenly become '' right after dumping it and successfully showing it to be an integer?? I've restarted both the cf server and the database server, wondering if there was some sort of strange hangup there... no joy. I'm losing my mind... help!! cffunction name=updateArticle returntype=void access=private output=true cfargument name=structArticle required=true type=Struct hint=A structure containing all fields of an article, and the values to be saved. cfset var a = arguments.structArticle cfset var qUpdateArticle = !--- uncommenting this line gives me a valid integer on screen --- !--- cfdump var=#a.articleId#cfabort --- cfquery name=qUpdateArticle datasource=#request.dsn# UPDATE Article SET categoryId = cfqueryparam value=#a.categoryId# cfsqltype=cf_sql_integer /, title = cfqueryparam value=#a.title# cfsqltype=cf_sql_varchar /, byLine = cfqueryparam value=#a.byLine# cfsqltype=cf_sql_varchar /, imageId = cfqueryparam value=#a.imageId# cfsqltype=cf_sql_integer /, imageCaption = cfqueryparam value=#a.imageCaption# cfsqltype=cf_sql_varchar /, abstract = cfqueryparam value=#a.abstract# cfsqltype=cf_sql_varchar /, body = cfqueryparam value=#a.body# cfsqltype=cf_sql_varchar /, isLead = cfqueryparam value=#a.isLead# cfsqltype=cf_sql_bit /, publishDateTime = cfqueryparam value=#a.publishDateTime# cfsqltype=cf_sql_timestamp / WHERE articleId = cfqueryparam value=#a.articleId# cfsqltype=cf_sql_integer / /cfquery /cffunction ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334824 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is it time for Adobe to Rebrand Cold Fusion?
A Rose by any other name is still a Rose. And so is a turd a turd. Microsoft is one of the industry kings of rebranding. ASP -- .NET = still a turd IMHO Windows nn - Windows nn = still sucks. Although I hear Windows 7 sucks less :) Only the uninformed fall for the rebranding. The rest can smell the rose or turd as the case may be. My belief is Adobe really needs to get into the schools and teach the new programmers about CF. At the same time focus on managers that make the tech decisions and show them ColdFusion can fill their needs. Then show case very high volume/traffic ColdFusion powered sites and dispel the myths about ColdFusion with live case studies. Wil Genovese Sr. Web Application Developer/ Systems Administrator Wil Genovese Consulting wilg...@trunkful.com www.trunkful.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334825 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Seriously PO'd - cfqueryparam and/or struct dereference flakes out
Dump #a# and look at the other values that your query expects to be integers (a.categoryid and a.imageid). CF only knows your query had an error. The reported line number when errors fall between cfquery tags is rarely the line with the actual issue. .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Marc Funaro [mailto:subscripti...@advantex.net] Sent: Thursday, June 24, 2010 6:43 PM To: cf-talk Subject: Seriously PO'd - cfqueryparam and/or struct dereference flakes out The function below was written literally MONTHS ago. Worked fine the whole time, even today... then suddenly it's throwing the error: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER. The error points to the line in the WHERE clause, referencing a.articleId. Next, I purposely set the output=true on this function, and did a cfdump of #a.articleId# -- it's definitely a valid integer. but it's now choking on it for some reason. as a test, i hard coded an article id into the where clause, removing the cfqueryparam. with a hard coded number, it chokes on the next cfqueryparam up. if i reference #a.articleId# directly (outside of cfqueryparam), I also get the same error. how can a.articleId suddenly become '' right after dumping it and successfully showing it to be an integer?? I've restarted both the cf server and the database server, wondering if there was some sort of strange hangup there... no joy. I'm losing my mind... help!! cffunction name=updateArticle returntype=void access=private output=true cfargument name=structArticle required=true type=Struct hint=A structure containing all fields of an article, and the values to be saved. cfset var a = arguments.structArticle cfset var qUpdateArticle = !--- uncommenting this line gives me a valid integer on screen --- !--- cfdump var=#a.articleId#cfabort --- cfquery name=qUpdateArticle datasource=#request.dsn# UPDATE Article SET categoryId = cfqueryparam value=#a.categoryId# cfsqltype=cf_sql_integer /, title = cfqueryparam value=#a.title# cfsqltype=cf_sql_varchar /, byLine = cfqueryparam value=#a.byLine# cfsqltype=cf_sql_varchar /, imageId = cfqueryparam value=#a.imageId# cfsqltype=cf_sql_integer /, imageCaption = cfqueryparam value=#a.imageCaption# cfsqltype=cf_sql_varchar /, abstract = cfqueryparam value=#a.abstract# cfsqltype=cf_sql_varchar /, body = cfqueryparam value=#a.body# cfsqltype=cf_sql_varchar /, isLead = cfqueryparam value=#a.isLead# cfsqltype=cf_sql_bit /, publishDateTime = cfqueryparam value=#a.publishDateTime# cfsqltype=cf_sql_timestamp / WHERE articleId = cfqueryparam value=#a.articleId# cfsqltype=cf_sql_integer / /cfquery /cffunction ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334826 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Shopping carts
@Eric Roberts * * Yea, that has been my experience with all the carts I have used as well. I have used OsCommerce, as well as the various flavors-- ZEN cart, CRE Loaded etc.. and they all have big requirements-- some hosts just will not run them. Although I have been successful using them, they all have their shortcomings-- convoluted code structures being the worst part. -- /Kevin Pepperman They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. - Benjamin Franklin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334827 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is it time for Adobe to Rebrand Cold Fusion?
Windows nn - Windows nn = still sucks. Although I hear Windows 7 sucks less :) Nah. That's crazy talk. My belief is Adobe really needs to get into the schools and teach the new programmers about CF. Agree 100%. I have a bit of a history with educational systems, and talking with some of my past colleagues the other day they indicated they've stopped teaching the majority of Adobe technologies (Flash, Dreamweaver, etc - they still teach Photoshop) because it was too dang expensive to buy even the educational licenses to do so. Many states have made huge cuts in education budgets trying to balance the state budget - so schools are cutting back on software spending to help compensate right now. They *WANT* to teach Adobe technologies, CF could be included with that, but it's just too expensive for them to do so. I don't think Adobe should give software away, even to schools (we all gotta pay the bills, right?) but easing up a little would yield excellent long-term results (and customers!) IMHO. Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Railo Community Distributions On 06/24/2010 05:12 PM, Wil Genovese wrote: A Rose by any other name is still a Rose. And so is a turd a turd. Microsoft is one of the industry kings of rebranding. ASP -- .NET = still a turd IMHO Windows nn - Windows nn = still sucks. Although I hear Windows 7 sucks less :) Only the uninformed fall for the rebranding. The rest can smell the rose or turd as the case may be. My belief is Adobe really needs to get into the schools and teach the new programmers about CF. At the same time focus on managers that make the tech decisions and show them ColdFusion can fill their needs. Then show case very high volume/traffic ColdFusion powered sites and dispel the myths about ColdFusion with live case studies. Wil Genovese Sr. Web Application Developer/ Systems Administrator Wil Genovese Consulting wilg...@trunkful.com www.trunkful.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334828 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Shopping carts
Eric, Take a look at this site: https://store.apolisactivism.com/ It's running a ecommerce engine I wrote - it's live on some other sites now and am just getting ready to roll it out publicly. Let me know if it might fit your needs. That list of restrictions your host puts on ColdFusion seems pretty harsh, is moving hosts a possibility? Cheers, .jonah ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334829 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is it time for Adobe to Rebrand Cold Fusion?
Of course Adobe does in fact give away ColdFusion free to education for exactly this reason: https://freeriatools.adobe.com/ https://freeriatools.adobe.com/ -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 25 June 2010 08:54, Jordan Michaels jor...@viviotech.net wrote: They *WANT* to teach Adobe technologies, CF could be included with that, but it's just too expensive for them to do so. I don't think Adobe should give software away, even to schools (we all gotta pay the bills, right?) but easing up a little would yield excellent long-term results (and customers!) IMHO. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334830 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is it time for Adobe to Rebrand Cold Fusion?
On Thu, Jun 24, 2010 at 5:54 PM, Jordan Michaels jor...@viviotech.net wrote: I don't think Adobe should give software away, even to schools (we all gotta pay the bills, right?) but easing up a little would yield excellent long-term results (and customers!) IMHO. ColdFusion, ColdFusion Builder and Flash Builder are all free to educational institutions for teaching purposes. https://freeriatools.adobe.com/ -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334831 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Shopping carts
@Kevin, I feel that this is one area that is completely overlooked in the CF world-- Especially since OO was introduced to CF in MX. So true. When I was looking for a ecommerce solution several years ago, I evaluated all the current offerings and joined the CFCommerce google group, etc. I wasn't finding anything remotely like what I needed, so wrote a solution. I'm now at the point of opening it up for others to use and am evaluating business model and licensing options. (Here's a live example: https://store.apolisactivism.com/) If you'd like to talk more here or offline let me know. Cheers, .jonah ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334832 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfdot.net
I think the video demos are a nice touch. On Thu, Jun 24, 2010 at 2:48 AM, Jose Diaz bleached...@gmail.com wrote: To help people even further I also started a video series for each example - only one of the examples currently shows this but if people like them I am more than happy to provide them for all of the examples. http://www.cfdot.net/cfdot/Pages/CodeDetail.aspx?id=70 Jose Diaz :) On Thu, Jun 24, 2010 at 7:26 AM, Jose Diaz bleached...@gmail.com wrote: @Paul you have hit the nail on the head that is exactly the purpose of the site. @Matthew - The site is NOT dishonest every example provides a solution that is viable. I think you have some misguided deeper issues and appear to see this as some sort of 'Coldfusion is better that .Net' battle, it;s not! You are entitled to your opinion but I cannot just stand by and have you say the site is dishonest when it is not. Maybe instead of being obstructive you should be a bit more constructive, On Wed, Jun 23, 2010 at 10:40 PM, Bobby Hartsfield bo...@acoderslife.comwrote: Well put. .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Eric Cobb [mailto:cft...@ecartech.com] Sent: Wednesday, June 23, 2010 3:28 PM To: cf-talk Subject: Re: cfdot.net Calling him dishonest is very short sighted on your part (to say the least!). Has the thought occurred to you that perhaps the reason there was so much extra code in the .Net example was because he's not a seasoned .Net developer? I know I certainly wouldn't know the absolute best way to do something when just transferring over to a new language. I'm willing to bet there are many seasoned .Net developers who would make plenty of rookie mistakes when just starting out with CF. Perhaps instead of jumping to conclusions and making accusations, you should offer to help him clean up his examples so they are more accurate. Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com Matthew Small wrote: All language religion aside - it's not a fair comparison, it's biased towards CF. You should be more honest in your comparisons if you expect anyone to take it seriously. Example: CFEXECUTE: CF: cfexecute name=C:\WinNT\System32\netstat.exe /cfexecute ASP.NET http://asp.net/ 01.using System; 02.using System.Drawing; 03.using System.Collections; 04.using System.ComponentModel; 05.using System.Windows.Forms; 06.using System.Data; 07.using System.Diagnostics; 08. 09.... 10. 11.//Declare and instantiate a new process component. 12.System.Diagnostics.Process process1; 13.process1= new System.Diagnostics.Process(); 14. 15.//Do not receive an event when the process exits. 16.process1.EnableRaisingEvents = false; 17. 18. 19.//The /C Tells Windows to Run The Command then Terminate 20.string strCmdLine; 21.strCmdLine = /C netstat ; 22.System.Diagnostics.Process.Start(CMD.exe,strCmdLine); 23.process1.Close(); All that is actually needed is: System.Diagnostics.Process.Start(netstat.exe); All of the other stuff is extraneous. The need for the using statements is negated by the fully-qualified name for the method. The object process1 isn't used at all for the actual execution. Passing the netstat.exe executable to the cmd.exe process is ridiculous - you could do the same with CFEXECUTE. Adding in extra string arguments just builds up the amount of code you want to display. And FYI: this one line of code can be executed in the .aspx page: % System.Diagnostics.Process.Start(netstat.exe) % There are numerous similar examples on your website. It's a dishonest misrepresentation. - Matt Small This is pretty sweet Jose. Thanks for taking the time to create this site! An excellent resource indeed. Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Railo Community Distributions On 06/22/2010 06:47 AM, Jose Diaz wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334833 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Seriously PO'd - cfqueryparam and/or struct dereference flakes out
It's a bit more code, but if you switch to having a cfargument tag for each parameter and enforce the type there, you can pass in your struct as an argument collection. You'll get a more meaningful error that way. Sent from my HTC on the Now Network from Sprint! - Reply message - From: Marc Funaro subscripti...@advantex.net Date: Thu, Jun 24, 2010 5:43 pm Subject: Seriously PO'd - cfqueryparam and/or struct dereference flakes out To: cf-talk cf-talk@houseoffusion.com The function below was written literally MONTHS ago. Worked fine the whole time, even today... then suddenly it's throwing the error: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER. The error points to the line in the WHERE clause, referencing a.articleId. Next, I purposely set the output=true on this function, and did a cfdump of #a.articleId# -- it's definitely a valid integer. but it's now choking on it for some reason. as a test, i hard coded an article id into the where clause, removing the cfqueryparam. with a hard coded number, it chokes on the next cfqueryparam up. if i reference #a.articleId# directly (outside of cfqueryparam), I also get the same error. how can a.articleId suddenly become '' right after dumping it and successfully showing it to be an integer?? I've restarted both the cf server and the database server, wondering if there was some sort of strange hangup there... no joy. I'm losing my mind... help!! cffunction name=updateArticle returntype=void access=private output=true cfargument name=structArticle required=true type=Struct hint=A structure containing all fields of an article, and the values to be saved. cfset var a = arguments.structArticle cfset var qUpdateArticle = !--- uncommenting this line gives me a valid integer on screen --- !--- cfdump var=#a.articleId#cfabort --- cfquery name=qUpdateArticle datasource=#request.dsn# UPDATE Article SET categoryId = cfqueryparam value=#a.categoryId# cfsqltype=cf_sql_integer /, title = cfqueryparam value=#a.title# cfsqltype=cf_sql_varchar /, byLine = cfqueryparam value=#a.byLine# cfsqltype=cf_sql_varchar /, imageId = cfqueryparam value=#a.imageId# cfsqltype=cf_sql_integer /, imageCaption = cfqueryparam value=#a.imageCaption# cfsqltype=cf_sql_varchar /, abstract = cfqueryparam value=#a.abstract# cfsqltype=cf_sql_varchar /, body = cfqueryparam value=#a.body# cfsqltype=cf_sql_varchar /, isLead = cfqueryparam value=#a.isLead# cfsqltype=cf_sql_bit /, publishDateTime = cfqueryparam value=#a.publishDateTime# cfsqltype=cf_sql_timestamp / WHERE articleId = cfqueryparam value=#a.articleId# cfsqltype=cf_sql_integer / /cfquery /cffunction ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334834 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is it time for Adobe to Rebrand Cold Fusion?
I knew Adobe had free educational licenses now, my point was more that I think Adobe really needs to market to the college computer science programs and even send people in to teach them how to setup and configure ColdFusion for high performance. Nothing will turn them off of ColdFusion faster than having a poorly configured CF server that crashes routinely. I would love to get into the various schools around MN to help them get ColdFusion servers up and running. Besides the small paycheck involved, I'd really love spreading the ColdFusion goodness. I've already done this for one college in MN. Cheers, Wil Genovese Sr. Web Application Developer/ Systems Administrator Wil Genovese Consulting wilg...@trunkful.com www.trunkful.com On Jun 24, 2010, at 8:28 PM, Sean Corfield wrote: On Thu, Jun 24, 2010 at 5:54 PM, Jordan Michaels jor...@viviotech.net wrote: I don't think Adobe should give software away, even to schools (we all gotta pay the bills, right?) but easing up a little would yield excellent long-term results (and customers!) IMHO. ColdFusion, ColdFusion Builder and Flash Builder are all free to educational institutions for teaching purposes. https://freeriatools.adobe.com/ -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334835 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm