Re: Getting the value or innerHTML of an FCKEditor field using DO M
What does Firebug show it as? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Andy Matthews To: CF-Talk Sent: Thu Dec 28 19:29:03 2006 Subject: Getting the value or innerHTML of an FCKEditor field using DOM I thought this would be fairly straightforward but it appears to be causing me some distress. I need to get the value of an FCKEditor field for transmission using AJAX. However, when I reference the fields ID, I get a blank result when there is definitely content in it. Can someone shed some light on this for me? Below is the HTML that is generated when I instantiate the FCKEditor. div input type=hidden id=art_article name=art_article value= style=display:none / input type=hidden id=art_article___Config value= style=display:none / iframe id=art_article___Frame src=/admin/includes/fckeditor/editor/fckeditor.html?InstanceName=art_articl eamp;Toolbar=SmallSet width=100% height=250 frameborder=no scrolling=no/iframe /div Any ideas? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: multiple items with qty in form problem
What are the hidden inputs for? Anyway, since you have these: input name=quant_#getItems.xref_inv_id# type=text id=quant=#getItems.xref_inv_id# value=0 size=4 you can loop through them to get each value: cfloop collection=#FORM# item=CurrentFormField cfif CurrentFormField contains quant_ !--- FORM[CurrentFormField] has the value from the form post and the XRefInvID is in the name of the element We can use ListLast() to get that ID id if the ID has no underscores in it --- cfset ThisXrefInvID = ListLast(CurrentFormField,_) !--- make the next var something based on ThisXrefInvID, maybe a struct - I'll leave this up to you --- cfset SomeVariableOrArrayHere = FORM[CurrentFormField] /cfloop On 12/29/06, Gerald Weir [EMAIL PROTECTED] wrote: Hello, We need a form that is a bit different from the examples I've been able to find so far. I am querying the db to get a list of all the products for this page and I want it to look like this to the consumer (some numbers are same for first 4 digits but then change for different size): 4353-H5 - 6-8-10-12-14 Quantity __ 4353-P5 - 12-14-16-18-20 Quantity __ 4354-A - ALL-SIZES Quantity __ 4355-AA - XS-S-M Quantity __ 4355-BB - M-L-XL Quantity __ 4356-H5 - 6-8-10-12-14 Quantity __ etc, etc, Submit Reset The idea is that we want to present a list of 50 or so items to choose from and have the consumer enter ALL quantities at the same time and hit the SUBMIT button once. The consumer in most all cases will choose 20 to 30 items from the page and want to have quantities for each up to 99. Here's my code for presentation of the items but I don't really know how to make the action page write each item separately with it's own quantity to an array or SESSION.CART. In this version I am using the xref_inv_id which is a number such as 1857, 1858, etc. form name=form method=post action=formDump.cfm cfoutput query=getItems tr td #getItems.design#-#getItems.size_code# - #getItems.size_unit# /td td align=center input name=quant_#getItems.xref_inv_id# type=text id=quant=#getItems.xref_inv_id# value=0 size=4 input name=#getItems.xref_inv_id# type=hidden id=#getItems.xref_inv_id# value= /td /tr /cfoutput tr td colspan=2 input name=Submit type=submit class=buttons value=add to cart input name=Clear type=reset class=buttons value=clear numbers /td /tr /table /form If someone can enlighten me as to how I can write the non-zero quantities chosen to an array that I can then display to the user on the next page as a simple list I would appreciate it very much. I also want to have a total of the items in the end so that I can charge them $1.00 per item ordered. So, if a consumer orders 327 items they will see a total amount of $327.00. Regards and thanks, Jerry ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265286 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC vs Customtag performance.
Woah there Johnny Storm - give a guy a chance to do an update. Anyway - I have got to the bottom of things - it was the fact that I had debug turned on (although suppressed) that made the difference to the execution times. With debug now turned off I get: inline execution = 29 milliseconds include execution = 69 milliseconds custom tag execution = 120 milliseconds uninstantiated CFC tag execution = 1244 milliseconds instantiated CFC tag execution = 56 milliseconds Which is very acceptable. I'll update the blog with my findings when I have time, but I didn't want to keep anyone waiting here ;-) Cheers Dan That is not his problem. I bet I know where his problem is but since he is disinclined to share his code and configuration to debug it I am disinclined to share the solution. If you post incomplete questions, you get incomplete answers. Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265287 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC vs Customtag performance.
Dan Singerman wrote: Woah there Johnny Storm - give a guy a chance to do an update. When you post a question to a high volume mailinglist, you make sure that the next few hours you are available to provide follow-up. You don't go off and do something else while other people work on your problem. It is a simple matter of mailinglist etiquette. Anyway - I have got to the bottom of things - it was the fact that I had debug turned on (although suppressed) that made the difference to the execution times. With debug now turned off I get: inline execution = 29 milliseconds include execution = 69 milliseconds custom tag execution = 120 milliseconds uninstantiated CFC tag execution = 1244 milliseconds instantiated CFC tag execution = 56 milliseconds While debugging is indeed the problem I was referring to, I don't think this is the bottom. First, you need to run many more iterations, these timings are well within the range where the resolution of getTickCount() has nasty side-effects. Second, the following code has a problem: cfset testString = testString and another thing With each iteration the string will get longer and the append operation will start to dominate your execution time. You are not measuring the time it takes to call a CFC versus the time it takes to call a customtag, but you are measuring some large append and a little bit off noise. So you need to reset testString every X iterations or even better, make a no-op from this append. Third, if you are using types in your cfarguments, the CFC is doing more then the other versions because it does type checking. You would need an IsSimpleValue() call in all the other code to emulate this (CF doesn't have an IsString()), or remove the types in your cfarguments. You will see some very different timings if you do this. Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265288 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Simple source control
Claude, Even though you don't see the benefits of using full, concurrent, version control, maybe you should consider the the combined wisdom of developers through-out the ages (please study the evolution of version control from rcs and the like up to svn, through cvs, and further - arch, svk etc), and the suggestions and comments you are getting here on the list... ? Even if you don't see the need for SVN now, it would be a good investement in yourself and you developers for the future. Anyways - before I started using CVS (and later SVN), I experimented with a source control system based on CVS predecessor - CS-RCS. This is a non-concurrent (i.e. no merging) revision control system, based on the ancient RCS. It is a long time since I played with it, but you might want to give it a shot. http://www.componentsoftware.com/csrcs/ :) /Hugo -- Hugo Ahlenius - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project OfficerPhone: +46 8 412 1427 UNEP GRID-Arendal Fax:+46 8 723 0348 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no Skype:callto:fraxxinus - ###This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.Formore information, connect to http://www.F-Secure.com/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265289 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Query Problem
OK, so I did not quite understand what I was doing. I thought that I was setting 100 cells, and the year range from 1920 - 2020 was 100 years; you see where I was going. So, then do I put 1920 in there then? I tried 2020 and of course it crated 2020 rows which sucked. Thanks -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, December 28, 2006 9:51 PM To: CF-Talk Subject: Re: Query Problem You have a query with 100 rows and you are trying to set a cell in row 1920. 1920 is greater than 100. On 12/29/06, Bruce Sorge [EMAIL PROTECTED] wrote: Hello. I have these three queries that I am creating below. The first two work great, but the third one gives me the following error: The row number, (1920) is out of bound. This is happening on line 48 which is this one: cfset temp = QuerySetCell(yearQuery, year_num, #yearnumber[year_number]#, #year_number#) What is wrong with it? Seems to me it should work. cfset monthQuery = QueryNew(Month_Number, Month_Name, Integer, varchar) cfset newRow = QueryAddRow(monthQuery, 12) cfloop index=loopcount from=1 to=12 cfset months[loopcount]=MonthAsString(loopcount) cfset monthNumber[loopcount] = loopcount cfset temp = QuerySetCell(monthQuery, Month_Number, #monthNumber[loopcount]#, #loopcount#) cfset temp = QuerySetCell(monthQuery, Month_Name, #months[loopcount]#, #loopcount#) /cfloop cfset dayQuery = QueryNew(Day_Number, Integer) cfset newRow = QueryAddRow(dayQuery, 31) cfloop index=loopcount from=1 to=31 cfset dayNumber[loopcount] = loopcount cfset temp = QuerySetCell(dayQuery, Day_Number, #dayNumber[loopcount]#, #loopcount#) /cfloop cfset yearQuery = QueryNew(year_num, Integer) cfset newRow = QueryAddRow(yearQuery, 100) cfloop index=year_number from=1920 to=2020 cfset yearnumber[year_number] = year_number cfset temp = QuerySetCell(yearQuery, year_num, #yearnumber[year_number]#, #year_number#) /cfloop Thanks, Bruce Sorge ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265290 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Javascript and Dynamic CF Forms
Thanks. Works now. If I wasn't in such a rush, I would have saw the quotes myself. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Thursday, December 28, 2006 5:26 PM To: CF-Talk Subject: Re: Javascript and Dynamic CF Forms sorry. my bad. remove the quotes from the 'this.options[this.selectedIndex].value' i was having you pass that literal string :\ On 12/28/06, Che Vilnonis [EMAIL PROTECTED] wrote: Hmmm. Not working... Does selOpt need another name, dynamic name? -- Charlie Griefer ...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265291 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query Problem
OK, so you have this: cfset yearQuery = QueryNew(year_num, Integer) cfset newRow = QueryAddRow(yearQuery, 100) cfloop index=year_number from=1920 to=2020 cfset yearnumber[year_number] = year_number cfset temp = QuerySetCell(yearQuery,year_num,#yearnumber[year_number]#,#year_number#) /cfloop Based on what you are doing with the other queries and what I think you are trying to do, this will work: cfset yearQuery = QueryNew(year_num, Integer) cfset newRow = QueryAddRow(yearQuery, 100) cfset YearOffset = 1919 cfloop index=year_number from=1 to=100 cfset yearnumber[year_number + YearOffset] = year_number + YearOffset cfset temp = QuerySetCell(yearQuery,year_num,yearnumber[year_number + YearOffset],year_number) /cfloop I got rid of unnecessary # signs too. Why you have a struct of years containing the same data as the struct's key I don't know, but this will give you the result you were after. On 12/29/06, Bruce Sorge [EMAIL PROTECTED] wrote: OK, so I did not quite understand what I was doing. I thought that I was setting 100 cells, and the year range from 1920 - 2020 was 100 years; you see where I was going. So, then do I put 1920 in there then? I tried 2020 and of course it crated 2020 rows which sucked. Thanks -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, December 28, 2006 9:51 PM To: CF-Talk Subject: Re: Query Problem You have a query with 100 rows and you are trying to set a cell in row 1920. 1920 is greater than 100. On 12/29/06, Bruce Sorge [EMAIL PROTECTED] wrote: Hello. I have these three queries that I am creating below. The first two work great, but the third one gives me the following error: The row number, (1920) is out of bound. This is happening on line 48 which is this one: cfset temp = QuerySetCell(yearQuery, year_num, #yearnumber[year_number]#, #year_number#) What is wrong with it? Seems to me it should work. cfset monthQuery = QueryNew(Month_Number, Month_Name, Integer, varchar) cfset newRow = QueryAddRow(monthQuery, 12) cfloop index=loopcount from=1 to=12 cfset months[loopcount]=MonthAsString(loopcount) cfset monthNumber[loopcount] = loopcount cfset temp = QuerySetCell(monthQuery, Month_Number, #monthNumber[loopcount]#, #loopcount#) cfset temp = QuerySetCell(monthQuery, Month_Name, #months[loopcount]#, #loopcount#) /cfloop cfset dayQuery = QueryNew(Day_Number, Integer) cfset newRow = QueryAddRow(dayQuery, 31) cfloop index=loopcount from=1 to=31 cfset dayNumber[loopcount] = loopcount cfset temp = QuerySetCell(dayQuery, Day_Number, #dayNumber[loopcount]#, #loopcount#) /cfloop cfset yearQuery = QueryNew(year_num, Integer) cfset newRow = QueryAddRow(yearQuery, 100) cfloop index=year_number from=1920 to=2020 cfset yearnumber[year_number] = year_number cfset temp = QuerySetCell(yearQuery, year_num, #yearnumber[year_number]#, #year_number#) /cfloop Thanks, Bruce Sorge ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265292 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfqueryparam DECREASES performance?
CFQueryParam can indeed decrease performance. If you look at what happens when you use CFQueryParam versus just passing in variables it makes sense. CFQueryParam transforms any passed variables into bind variables. In MSSQL it is the same as declaring a variable, setting it and then using that in the query. IE SELECT Id, Description FROMProduct WHERE ProductID = 2 VS (with query param ) DECLARE @P1 int SET @P1 = 2 SELECT Id, Description FROMProduct WHERE ProductID = @P1 CF then uses a stored procedure spprepexec to try to force the dbms to precompile the sql statement into an execution plan for faster execution on subsequent calls. This is where you lose performance often. If your database does not have enough memory to store all of the prepared statements you will be essentially running the query 2x every time you call it. Once to generate the execution plan once to actually run it. The same thing happens if the query is not called often enough. IE in the case of reports run infrequently. The database will clear the execution plan for your query since it is not used often to make room for other queries. I would recommend writing a custom tag to replace cfqueryparam when used with infrequent long running reports. A query that takes 100 ms to run, is no big deal if it has to be recompiled once and a while. A query that runs for 3 minutes can be a major problem if it takes 2x as long 50% of the time. I wish Adobe would rewrite this functionality to take an optional parameter to specify whether to use sp prep exec. I've attached a custom tag I wrote to replace cfqueryparam in these cases. User beware it is not fully tested, and not as secure as cfqueryparam. -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Thursday, December 28, 2006 1:01 PM To: CF-Talk Subject: cfqueryparam DECREASES performance? OK, I must have something wrong here. I've only heard good things about cfqueryparam on this list for both security and performance. A client sent me an ugly report that times out for them. I spent an hour going through it and applying cfqueryparams to each variable in the many queries with appropriate datatypes. I threw a cfsetting tag in to increase the request timeout and the report runs in roughly about 512687 ms, restarted MSSQL server and CFMX7, then with the cfqueryparams the same query that was running in 5282ms in the old code, now takes 15094ms. Any ideas? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265293 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfqueryparam DECREASES performance?
Ok so you can't attach files. cfsilent cfparam name=attributes.value / !--- type of bind variable value must equate to --- cfparam name=attributes.cfsqltype default=CF_SQL_CHAR / !--- length of string in value attribute --- cfparam name=attributes.maxlength default=#Len(attributes.value)# / !--- Number of decimal places in parameter. Applies to CF_SQL_NUMERIC and CF_SQL_DECIMAL --- cfparam name=attributes.scale default=0 type=numeric min=0 max=20 / !--- whether to ignore the value passed in and send null --- cfparam name=attributes.null default=no / !--- whether the value is a list or single item --- cfparam name=attributes.list default=no / !--- what seperator to use if using list --- cfparam name=attributes.separator default=, / !--- Before Changing anything in this custom tag run it against the unit tests * For these types, a data value can be converted to a numeric value': CF_SQL_SMALLINT, CF_SQL_INTEGER, CF_SQL_REAL, CF_SQL_FLOAT, CF_SQL_DOUBLE, CF_SQL_TINYINT, CF_SQL_MONEY, CF_SQL_MONEY4, CF_SQL_DECIMAL, CF_SQL_NUMERIC, and CF_SQL_BIGINT * For these types, a data value can be converted to a date supported by the target data source': CF_SQL_DATE, CF_SQL_TIME, CF_SQL_TIMESTAMP * For all other types, if the maxLength attribute is used, a data value cannot exceed the maximum length specified. param type mssql equivilent cf_sql_bigint bigint cf_sql_bit bit cf_sql_char char, nchar cf_sql_date smalldatetime cf_sql_decimal numeric, decimal cf_sql_double double, float cf_sql_floatdouble, float cf_sql_idstamp timestamp cf_sql_integer int cf_sql_longvarchar text cf_sql_moneymoney cf_sql_money4 smallmoney cf_sql_numeric numeric, decimal cf_sql_real real cf_sql_refcursorcursor cf_sql_smallint smallint cf_sql_time cf_sql_timestampdatetime cf_sql_tinyint tinyint cf_sql_varchar varchar, nvarchar,uniqueidentifier --- !--- stupid hack so you can use throw in cfscript --- cffunction name=throw cfargument name=detail type=string required=false / cfargument name=message type=string required=false / cfargument name=errorcode type=string required=false / cfargument name=type type=string required=false / cfthrow detail=#arguments.detail# message=#arguments.message# errorcode=#arguments.errorcode# type=#arguments.type# / /cffunction !--- this custom tag is being written in cfscript in order to speed processing time, since it is called very often on almost every template --- cfscript // clear out any text in between start and end tags thisTag.GeneratedContent = ; // only execute this tag one time if( thisTag.executionMode eq end OR NOT thisTag.HasEndTag) { // variable to hold output string Local.strQueryParameter = ; // check that user does not want to return null value if(NOT attributes.null) { // check maximum length if(Len(attributes.value) GT attributes.maxlength) { throw( message=The cause of this output exception was that': coldfusion.tagext.sql.CF_QueryParamTag$InvalidDataException': Invalid data '#attributes.value#' value exceeds MAXLENGTH setting #attributes.maxlength#., type=APPLICATION, detail=, errorcode=0); } // what type of bind variable are we passing switch(attributes.cfsqltype) { // integer types case 'CF_SQL_INTEGER': case 'CF_SQL_SMALLINT': case 'CF_SQL_TINYINT': case 'CF_SQL_BIGINT': // if we are in a list check each item in the list for(Local.Iterator = 1;Local.Iterator LTE ListLen(attributes.value,attributes.separator);Local.Iterator = Local.Iterator + 1){ Local.CurItem = ListGetAt(attributes.value,Local.Iterator,attributes.separator);
RE: Getting the value or innerHTML of an FCKEditor field using DO M
I ran into the same issue. This is used by a another window that is opened and updates that field. You could probably modify it to work for you. function getEditorContent(instanceName) { editor_frame = opener.document.getElementById(instanceName+'___Frame'); editor_source = editor_frame.contentWindow.document.getElementById('eEditorArea'); if (editor_source!=null) { return editor_source.contentWindow.document.body.innerHTML; } else { return ''; } } function setEditorContent(instanceName,newContent) { editor_frame = opener.document.getElementById(instanceName+'___Frame'); editor_source = editor_frame.contentWindow.document.getElementById('eEditorArea'); if (editor_source!=null) { editor_source.contentWindow.document.body.innerHTML = newContent; } else { return ''; } } -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 2:32 AM To: CF-Talk Subject: Re: Getting the value or innerHTML of an FCKEditor field using DO M What does Firebug show it as? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Andy Matthews To: CF-Talk Sent: Thu Dec 28 19:29:03 2006 Subject: Getting the value or innerHTML of an FCKEditor field using DOM I thought this would be fairly straightforward but it appears to be causing me some distress. I need to get the value of an FCKEditor field for transmission using AJAX. However, when I reference the fields ID, I get a blank result when there is definitely content in it. Can someone shed some light on this for me? Below is the HTML that is generated when I instantiate the FCKEditor. div input type=hidden id=art_article name=art_article value= style=display:none / input type=hidden id=art_article___Config value= style=display:none / iframe id=art_article___Frame src=/admin/includes/fckeditor/editor/fckeditor.html?InstanceName=art_ar ticl eamp;Toolbar=SmallSet width=100% height=250 frameborder=no scrolling=no/iframe /div Any ideas? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265295 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Getting the value or innerHTML of an FCKEditor field using DOM
I ran into the same issue. Here are a couple javascript functions used by another window that is opened and updates that field. You could probably modify it to work for you. function getEditorContent(instanceName) { editor_frame = opener.document.getElementById(instanceName+'___Frame'); editor_source = editor_frame.contentWindow.document.getElementById('eEditorArea'); if (editor_source!=null) { return editor_source.contentWindow.document.body.innerHTML; } else { return ''; } } function setEditorContent(instanceName,newContent) { editor_frame = opener.document.getElementById(instanceName+'___Frame'); editor_source = editor_frame.contentWindow.document.getElementById('eEditorArea'); if (editor_source!=null) { editor_source.contentWindow.document.body.innerHTML = newContent; } else { return ''; } } This email may contain confidential material. If you were not an intended recipient, Please notify the sender and delete all copies. We may monitor email to and from our network. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265296 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Getting the value or innerHTML of an FCKEditor field using DO M
Good thoughtI haven't checked it. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 2:32 AM To: CF-Talk Subject: Re: Getting the value or innerHTML of an FCKEditor field using DO M What does Firebug show it as? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Andy Matthews To: CF-Talk Sent: Thu Dec 28 19:29:03 2006 Subject: Getting the value or innerHTML of an FCKEditor field using DOM I thought this would be fairly straightforward but it appears to be causing me some distress. I need to get the value of an FCKEditor field for transmission using AJAX. However, when I reference the fields ID, I get a blank result when there is definitely content in it. Can someone shed some light on this for me? Below is the HTML that is generated when I instantiate the FCKEditor. div input type=hidden id=art_article name=art_article value= style=display:none / input type=hidden id=art_article___Config value= style=display:none / iframe id=art_article___Frame src=/admin/includes/fckeditor/editor/fckeditor.html?InstanceName=art_articl eamp;Toolbar=SmallSet width=100% height=250 frameborder=no scrolling=no/iframe /div Any ideas? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265297 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam DECREASES performance?
Porter, Benjamin L. wrote: SELECT Id, Description FROM Product WHERE ProductID = 2 VS (with query param ) DECLARE @P1 int SET @P1 = 2 SELECT Id, Description FROM Product WHERE ProductID = @P1 CF then uses a stored procedure spprepexec to try to force the dbms to precompile the sql statement into an execution plan for faster execution on subsequent calls. With which driver did you observe this behaviour? For which version of MS SQL Server was that? ISTM that a more efficient approach would be to use sp_executesql or SQLPrepare and I am surprised that a driver would choose a strategy that would force an execution for every recompile. Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265298 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfqueryparam DECREASES performance? (To be selectable in CF8?)
I thought I saw somewhere that the next version of CF (CF8?) would indeed allow the use of cfqueryparam without forcing the conversion of the sql to a prepared statement, which would also allow it to be used with the cachedwithin option. I don't recall where I read that, so if someone in the know could confirm it Thanks Mark -Original Message- From: Porter, Benjamin L. [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 8:58 AM To: CF-Talk Subject: RE: cfqueryparam DECREASES performance? CFQueryParam can indeed decrease performance. If you look at what happens when you use CFQueryParam versus just passing in variables it makes sense. CFQueryParam transforms any passed variables into bind variables. In MSSQL it is the same as declaring a variable, setting it and then using that in the query. IE SELECT Id, Description FROMProduct WHERE ProductID = 2 VS (with query param ) DECLARE @P1 int SET @P1 = 2 SELECT Id, Description FROMProduct WHERE ProductID = @P1 CF then uses a stored procedure spprepexec to try to force the dbms to precompile the sql statement into an execution plan for faster execution on subsequent calls. This is where you lose performance often. If your database does not have enough memory to store all of the prepared statements you will be essentially running the query 2x every time you call it. Once to generate the execution plan once to actually run it. The same thing happens if the query is not called often enough. IE in the case of reports run infrequently. The database will clear the execution plan for your query since it is not used often to make room for other queries. I would recommend writing a custom tag to replace cfqueryparam when used with infrequent long running reports. A query that takes 100 ms to run, is no big deal if it has to be recompiled once and a while. A query that runs for 3 minutes can be a major problem if it takes 2x as long 50% of the time. I wish Adobe would rewrite this functionality to take an optional parameter to specify whether to use sp prep exec. I've attached a custom tag I wrote to replace cfqueryparam in these cases. User beware it is not fully tested, and not as secure as cfqueryparam. -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Thursday, December 28, 2006 1:01 PM To: CF-Talk Subject: cfqueryparam DECREASES performance? OK, I must have something wrong here. I've only heard good things about cfqueryparam on this list for both security and performance. A client sent me an ugly report that times out for them. I spent an hour going through it and applying cfqueryparams to each variable in the many queries with appropriate datatypes. I threw a cfsetting tag in to increase the request timeout and the report runs in roughly about 512687 ms, restarted MSSQL server and CFMX7, then with the cfqueryparams the same query that was running in 5282ms in the old code, now takes 15094ms. Any ideas? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265299 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfqueryparam DECREASES performance?
MSSQL 2000 Data direct driver 3.4 with the standard jdbc.sqlserver.SQLServerDriver. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 7:33 AM To: CF-Talk Subject: Re: cfqueryparam DECREASES performance? Porter, Benjamin L. wrote: SELECT Id, Description FROM Product WHERE ProductID = 2 VS (with query param ) DECLARE @P1 int SET @P1 = 2 SELECT Id, Description FROM Product WHERE ProductID = @P1 CF then uses a stored procedure spprepexec to try to force the dbms to precompile the sql statement into an execution plan for faster execution on subsequent calls. With which driver did you observe this behaviour? For which version of MS SQL Server was that? ISTM that a more efficient approach would be to use sp_executesql or SQLPrepare and I am surprised that a driver would choose a strategy that would force an execution for every recompile. Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265300 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX on Apache 2.2 on Cygwin?
On 12/28/06 5:22 PM, Adrian Moreno wrote: I've had CFMX 6.1 running on both Apache 2 and JBoss on Cygwin for development. Awesome, just what I wanted to know. If you're going to use Apache 2.2, make sure you read this TechNote as there's a newer connector than the one that ships with the CFMX installer. http://www.mc-kenna.com/articles/coldfusion-mx-61-apache-22-windows/ :-) Thanks, Adrian. -- Damien McKenna - Web Developer [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265301 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMX on Apache 2.2 on Cygwin?
On 12/28/06 8:43 PM, Eric Haskins wrote: I have Dev edition running on XAMPP (apachefriends.org) which runs Apache 2.2 Apache on Windows is different to Apache on Cygwin, but thank you for replying. -- Damien McKenna - Web Developer [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265302 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMX on Apache 2.2 on Cygwin?
On 12/28/06 11:46 PM, Jacob Munson wrote: Ok, I have to ask. Why? Apache runs perfectly well under Windows, why would you want to run it in a Unix emulator? I'm sure you've got a good reason, I'm just curious what it is. I was figuring that it might be easier to manage, given I'll be running other tools under Cygwin. Actually use of Cygwin started from a need for a good way to SSH into the server and to have a full shell environment. It is a good point, though, maybe I should reconsider.. -- Damien McKenna - Web Developer [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265303 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfqueryparam DECREASES performance?
The SQL output by a query using cfqueryparam is a prepared statement. He was suggesting that you compare the execution plan using cfqueryparam vs. not using it to see what the difference is. Maybe I'm looking in the wrong place then. I know I can use MSSQL's SQL Management Studio to place in a SQL query and run it to view the execution plan. How can you run the queries in CF and see the execution plan from MSSQL? Rich Kroll ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265304 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfqueryparam DECREASES performance?
You can use SQL Profiler to view execution plans. -Original Message- From: Richard Kroll [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 10:26 AM To: CF-Talk Subject: RE: cfqueryparam DECREASES performance? The SQL output by a query using cfqueryparam is a prepared statement. He was suggesting that you compare the execution plan using cfqueryparam vs. not using it to see what the difference is. Maybe I'm looking in the wrong place then. I know I can use MSSQL's SQL Management Studio to place in a SQL query and run it to view the execution plan. How can you run the queries in CF and see the execution plan from MSSQL? Rich Kroll ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265305 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMX on Apache 2.2 on Cygwin?
Actually use of Cygwin started from a need for a good way to SSH into the server and to have a full shell environment. It is a good point, though, maybe I should reconsider.. What's wrong with Putty? -- My Sites: http://www.techfeed.net/blog/ http://www.cfquickdocs.com/ http://cfformprotect.riaforge.org/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265306 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMX on Apache 2.2 on Cygwin?
On 12/29/06 10:44 AM, Jacob Munson wrote: Actually use of Cygwin started from a need for a good way to SSH into the server and to have a full shell environment. It is a good point, though, maybe I should reconsider.. What's wrong with Putty? PuTTY is an SSH client, not a server. I need a server. -- Damien McKenna - Web Developer [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265307 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Getting the value or innerHTML of an FCKEditor field using DOM
OK, maybe I shouldn't have said you need to use the FCKeditorAPI, but since it's built-in to FCKeditor and does exactly what you need, it might be easier than writing your own custom functions. See: http://wiki.fckeditor.net/Developer%27s_Guide/Javascript_API There are a number of methods in the API, including getXHMTL() which returns the contents of the editor instance. I'm using the API successfully in a CF/AJAX project - works like a charm. -michael -- michael acadia | [EMAIL PROTECTED] Andy Matthews wrote: I thought this would be fairly straightforward but it appears to be causing me some distress. I need to get the value of an FCKEditor field for transmission using AJAX. However, when I reference the fields ID, I get a blank result when there is definitely content in it. Can someone shed some light on this for me? Below is the HTML that is generated when I instantiate the FCKEditor. div input type=hidden id=art_article name=art_article value= style=display:none / input type=hidden id=art_article___Config value= style=display:none / iframe id=art_article___Frame src=/admin/includes/fckeditor/editor/fckeditor.html?InstanceName=art_articl eamp;Toolbar=SmallSet width=100% height=250 frameborder=no scrolling=no/iframe /div Any ideas? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265308 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFMX on Apache 2.2 on Cygwin?
Have you looked at some of the windows implementations of SSH? A quick google search turned up a lot of options... -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 8:51 AM To: CF-Talk Subject: Re: CFMX on Apache 2.2 on Cygwin? On 12/29/06 10:44 AM, Jacob Munson wrote: Actually use of Cygwin started from a need for a good way to SSH into the server and to have a full shell environment. It is a good point, though, maybe I should reconsider.. What's wrong with Putty? PuTTY is an SSH client, not a server. I need a server. -- Damien McKenna - Web Developer [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265309 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX on Apache 2.2 on Cygwin?
On 12/29/06 11:09 AM, Jeff Garza wrote: Have you looked at some of the windows implementations of SSH? A quick google search turned up a lot of options... Why pay for an ssh service when Cygwin is free? -- Damien McKenna - Web Developer [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265310 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query Problem
That did it. Thanks. On 12/29/06, James Holmes [EMAIL PROTECTED] wrote: OK, so you have this: cfset yearQuery = QueryNew(year_num, Integer) cfset newRow = QueryAddRow(yearQuery, 100) cfloop index=year_number from=1920 to=2020 cfset yearnumber[year_number] = year_number cfset temp = QuerySetCell(yearQuery,year_num,#yearnumber[year_number]#,#year_number#) /cfloop Based on what you are doing with the other queries and what I think you are trying to do, this will work: cfset yearQuery = QueryNew(year_num, Integer) cfset newRow = QueryAddRow(yearQuery, 100) cfset YearOffset = 1919 cfloop index=year_number from=1 to=100 cfset yearnumber[year_number + YearOffset] = year_number + YearOffset cfset temp = QuerySetCell(yearQuery,year_num,yearnumber[year_number + YearOffset],year_number) /cfloop I got rid of unnecessary # signs too. Why you have a struct of years containing the same data as the struct's key I don't know, but this will give you the result you were after. On 12/29/06, Bruce Sorge [EMAIL PROTECTED] wrote: OK, so I did not quite understand what I was doing. I thought that I was setting 100 cells, and the year range from 1920 - 2020 was 100 years; you see where I was going. So, then do I put 1920 in there then? I tried 2020 and of course it crated 2020 rows which sucked. Thanks -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, December 28, 2006 9:51 PM To: CF-Talk Subject: Re: Query Problem You have a query with 100 rows and you are trying to set a cell in row 1920. 1920 is greater than 100. On 12/29/06, Bruce Sorge [EMAIL PROTECTED] wrote: Hello. I have these three queries that I am creating below. The first two work great, but the third one gives me the following error: The row number, (1920) is out of bound. This is happening on line 48 which is this one: cfset temp = QuerySetCell(yearQuery, year_num, #yearnumber[year_number]#, #year_number#) What is wrong with it? Seems to me it should work. cfset monthQuery = QueryNew(Month_Number, Month_Name, Integer, varchar) cfset newRow = QueryAddRow(monthQuery, 12) cfloop index=loopcount from=1 to=12 cfset months[loopcount]=MonthAsString(loopcount) cfset monthNumber[loopcount] = loopcount cfset temp = QuerySetCell(monthQuery, Month_Number, #monthNumber[loopcount]#, #loopcount#) cfset temp = QuerySetCell(monthQuery, Month_Name, #months[loopcount]#, #loopcount#) /cfloop cfset dayQuery = QueryNew(Day_Number, Integer) cfset newRow = QueryAddRow(dayQuery, 31) cfloop index=loopcount from=1 to=31 cfset dayNumber[loopcount] = loopcount cfset temp = QuerySetCell(dayQuery, Day_Number, #dayNumber[loopcount]#, #loopcount#) /cfloop cfset yearQuery = QueryNew(year_num, Integer) cfset newRow = QueryAddRow(yearQuery, 100) cfloop index=year_number from=1920 to=2020 cfset yearnumber[year_number] = year_number cfset temp = QuerySetCell(yearQuery, year_num, #yearnumber[year_number]#, #year_number#) /cfloop Thanks, Bruce Sorge ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265311 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX on Apache 2.2 on Cygwin?
Why pay for an ssh service when Cygwin is free? The reason I bought VShell, Van Dyke Software's SSH server, is because it integrates well with Windows (and Windows security). 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! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265312 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX on Apache 2.2 on Cygwin?
I was figuring that it might be easier to manage, given I'll be running other tools under Cygwin. Actually use of Cygwin started from a need for a good way to SSH into the server and to have a full shell environment. It is a good point, though, maybe I should reconsider.. I think that running a web server through Cygwin is a bad idea when native versions of the same web server are available. 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! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265313 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfqueryparam DECREASES performance? (To be selectable in CF8? )
I thought I saw somewhere that the next version of CF (CF8?) would indeed allow the use of cfqueryparam without forcing the conversion of the sql to a prepared statement, which would also allow it to be used with the cachedwithin option. I don't recall where I read that, so if someone in the know could confirm it I can't say I'm in the know on this specific topic, but I don't see how CFQUERYPARAM would be useful if it didn't build a prepared statement. I also don't see why CF 8 couldn't just cache query results from prepared statements, either, so my guess is that is what will happen. 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! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265314 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: receive/read fax documents via CF
Bryan, It seems as if you were doing something very similar (found this on Google: http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:44779 ) Yep...and if ya caught the part about Adobe LiveCycle costs you'll see why we bailed on it ;-) There are many barcode reading utilities out theremost around a few hundred bucksuse them via CFEXECUTE. I never got that far. HTHand post details of a viable solutionI know I'd like to hear about it ;-) 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: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265315 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX on Apache 2.2 on Cygwin?
What's wrong with Putty? PuTTY is an SSH client, not a server. I need a server. Oh, sorry. I thought you were using Cygwin as an ssh client, not a server. :) -- My Sites: http://www.techfeed.net/blog/ http://www.cfquickdocs.com/ http://cfformprotect.riaforge.org/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265316 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFID and CFToken
Does anyone know of a way to programmatically add the CFID and CFToken variables to every link within a rendered page (if needed)? Links, form actions, etc., via some regex or something. Cutter ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265317 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFID and CFToken
Well not really with CF Code but why not use the Search/Replace function within HomeSite/DW/ or Eclipse and update the pages that way? -Original Message- From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 1:00 PM To: CF-Talk Subject: CFID and CFToken Does anyone know of a way to programmatically add the CFID and CFToken variables to every link within a rendered page (if needed)? Links, form actions, etc., via some regex or something. Cutter ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
HostMySite Issue
I recently moved my site to HostMySite and am now having major problems as a result. Here's the issue: I use a cfcontent tag to send downloaded software down to the client, as is commonly done so the file can be kept in a secure location. The file is around 10 megs so can take anywhere from 10-15 seconds to a minute or two to download. The problem is that HMS is using SeeFusion and has recently set it to end any threads running more than 50 seconds. This is a major problem because it overrides normal ColdFusion behavior that allows tags like cfcontent and cfftp to run to completion. And it even overrides use of a cfsetting tag for pages you expect to take awhile to run so I have no way to override this. So now my customers go to download the software and for many, it keeps timing out on them, and the customer tries again and again until they run out of download attemptsand then of course I get an annoyed email and have to deal with sending them the file another way. HostMySite's suggestion? Use ASPUpload instead! They say they have no problem with the setting causing problems for some people if it keeps the servers running better for everyone else. So this post is for two reasons...to warn anyone that might be considering using HMS shared hosting that they better not ever need a ColdFusion page to run more than 50 seconds. And to see if anyone knows of a way to get the cfcontent to complete faster. Is there any way to get the thread to run to completion without it having to wait for the client to receive the entire file? Any other options I could look at that will integrate into ColdFusion? I hope that when the improved server monitoring with Scorpio comes out that will allow for better handling of things like this. I totally appreciate the need to kill hanging threads and keep the server up and running. But I totally disagree with being able to override normal use of ColdFusion like this. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265319 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFID and CFToken
I'm not sure why you'd want to do that, (and there may be security risks in doing so), but the CFID and CFToken are typically stored in the cookie scope. You could get them from there to add them to all your links. Cheers, Chris Cutter (CFRelated) wrote: Does anyone know of a way to programmatically add the CFID and CFToken variables to every link within a rendered page (if needed)? Links, form actions, etc., via some regex or something. Cutter ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265320 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFID and CFToken
Checkout UrlSessionFormat() Russ -Original Message- From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] Sent: 29 December 2006 18:00 To: CF-Talk Subject: CFID and CFToken Does anyone know of a way to programmatically add the CFID and CFToken variables to every link within a rendered page (if needed)? Links, form actions, etc., via some regex or something. Cutter ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265321 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFID and CFToken
Can you wrap all links in some sort of method call.. Something like: SessionUrl( index.cfm. ) And have that automatically add the CFID / CFTOKEN? Or are you talking about a search / replace like someone else mentioned? .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 1:00 PM To: CF-Talk Subject: CFID and CFToken Does anyone know of a way to programmatically add the CFID and CFToken variables to every link within a rendered page (if needed)? Links, form actions, etc., via some regex or something. Cutter ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265322 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFID and CFToken
Wait... they're in the cookie scope on my box because we're putting them there. They live in the session scope. Cheers, Chris Cutter (CFRelated) wrote: Does anyone know of a way to programmatically add the CFID and CFToken variables to every link within a rendered page (if needed)? Links, form actions, etc., via some regex or something. Cutter ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265323 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HostMySite Issue
Mary Jo, As a work around, you might want to consider copying the file to a random directory (create one on the fly via UUID or something) then CFLocat the user to that directory. Then maybe once a day or something, programmatically go through and delete all those directories??? .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 12:13 PM To: CF-Talk Subject: HostMySite Issue I recently moved my site to HostMySite and am now having major problems as a result. Here's the issue: I use a cfcontent tag to send downloaded software down to the client, as is commonly done so the file can be kept in a secure location. The file is around 10 megs so can take anywhere from 10-15 seconds to a minute or two to download. The problem is that HMS is using SeeFusion and has recently set it to end any threads running more than 50 seconds. This is a major problem because it overrides normal ColdFusion behavior that allows tags like cfcontent and cfftp to run to completion. And it even overrides use of a cfsetting tag for pages you expect to take awhile to run so I have no way to override this. So now my customers go to download the software and for many, it keeps timing out on them, and the customer tries again and again until they run out of download attemptsand then of course I get an annoyed email and have to deal with sending them the file another way. HostMySite's suggestion? Use ASPUpload instead! They say they have no problem with the setting causing problems for some people if it keeps the servers running better for everyone else. So this post is for two reasons...to warn anyone that might be considering using HMS shared hosting that they better not ever need a ColdFusion page to run more than 50 seconds. And to see if anyone knows of a way to get the cfcontent to complete faster. Is there any way to get the thread to run to completion without it having to wait for the client to receive the entire file? Any other options I could look at that will integrate into ColdFusion? I hope that when the improved server monitoring with Scorpio comes out that will allow for better handling of things like this. I totally appreciate the need to kill hanging threads and keep the server up and running. But I totally disagree with being able to override normal use of ColdFusion like this. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265324 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFID and CFToken
Why couldn't you do it with CF Code? Well, I guess if he's creating all his HTML by hand and just using CF for the back end... otherwise, you'd do it when CF is creating the page. CFOutput a href=somepage.cfm?CFID=#Session.CFID#CFTOKEN=#Session.CFToken#MyLink/a /CFOutput What's wrong with something like that? Cheers, Chris Adkins, Randy wrote: Well not really with CF Code but why not use the Search/Replace function within HomeSite/DW/ or Eclipse and update the pages that way? -Original Message- From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 1:00 PM To: CF-Talk Subject: CFID and CFToken Does anyone know of a way to programmatically add the CFID and CFToken variables to every link within a rendered page (if needed)? Links, form actions, etc., via some regex or something. Cutter ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265325 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFID and CFToken
Nothing wrong with it but I got out the message was he was wanting to update all the pages to use the variables. So instead of opening and changing a page one at a time, to do a Search/Replace. -Original Message- From: Christopher Jordan [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 1:28 PM To: CF-Talk Subject: Re: CFID and CFToken Why couldn't you do it with CF Code? Well, I guess if he's creating all his HTML by hand and just using CF for the back end... otherwise, you'd do it when CF is creating the page. CFOutput a href=somepage.cfm?CFID=#Session.CFID#CFTOKEN=#Session.CFToken#MyLink /a /CFOutput What's wrong with something like that? Cheers, Chris Adkins, Randy wrote: Well not really with CF Code but why not use the Search/Replace function within HomeSite/DW/ or Eclipse and update the pages that way? -Original Message- From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 1:00 PM To: CF-Talk Subject: CFID and CFToken Does anyone know of a way to programmatically add the CFID and CFToken variables to every link within a rendered page (if needed)? Links, form actions, etc., via some regex or something. Cutter ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265326 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: HostMySite Issue
Scorpio server monitoring wouldn't necessarily alleviate this. The 50 second rule is something Host my site has decided upon and SeeFusion is simply the tool they are enforcing it with. While can't speak for the business rules of HMS, and I can verify that it is very easy to specify exception templates in the SeeFusion active monitoring rules. I do it myself for reports which I expect to run long. Convincing HMS of that is another story. I am a little surprised they would be so hard headed about it. As far as a solution I agree with what Ben Nadel said. Copy it somewhere with a cryptic file name, and then redirect to it. I would recommend using a JavaScript redirect. If you create the file in a directory which has the cryptic name, then not only would it be hard to guess, but the user won't have to rename the file when they get it downloaded-- I hate that. This way your browser is requesting the file directly. Since SeeFusion runs on the JVM which handles ONLY .cfm, .cfc, etc requests, a request for another file type will be served up by the web server, and SeeFusion will never be any the wiser. And then, of course, clear files over 1 day old out of the directory or something. ~Brad -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 11:13 AM To: CF-Talk Subject: HostMySite Issue I recently moved my site to HostMySite and am now having major problems as a result. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265327 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Cold Fusion for small IntraNet
I've read about a FREE product that is very much like Cold Fusion but I forget the name of it. I'm lookiing for a free peice of software for a small IntraNet. Thanks D ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265328 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cold Fusion for small IntraNet
Its either BlueDragon (www.newatlanta.com) or Ralio (http://www.railo.ch/en/index.cfm). Rey [EMAIL PROTECTED] wrote: I've read about a FREE product that is very much like Cold Fusion but I forget the name of it. I'm lookiing for a free peice of software for a small IntraNet. Thanks D ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265329 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfqueryparam DECREASES performance? (To be selectable in CF8? )
I can think of one *huge* reason where CFQUERYPARAM would be useful... For parameter validation to prevent SQL injection attacks. I would love to be able to tell people that they should *always* use CFQUERYPARAM, but I can't because there are times when it will break existing code (by disabling cachedwithin, which is what happens now, as I understand it). Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 11:49 AM To: CF-Talk Subject: RE: cfqueryparam DECREASES performance? (To be selectable in CF8? ) I thought I saw somewhere that the next version of CF (CF8?) would indeed allow the use of cfqueryparam without forcing the conversion of the sql to a prepared statement, which would also allow it to be used with the cachedwithin option. I don't recall where I read that, so if someone in the know could confirm it I can't say I'm in the know on this specific topic, but I don't see how CFQUERYPARAM would be useful if it didn't build a prepared statement. I also don't see why CF 8 couldn't just cache query results from prepared statements, either, so my guess is that is what will happen. 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! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265330 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cold Fusion for small IntraNet
Also there is the mysterious Smith - some tags aren't supported though. http://www.smithproject.org -- Josh - Original Message - From: Rey Bango [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, December 29, 2006 10:52 AM Subject: Re: Cold Fusion for small IntraNet Its either BlueDragon (www.newatlanta.com) or Ralio (http://www.railo.ch/en/index.cfm). Rey [EMAIL PROTECTED] wrote: I've read about a FREE product that is very much like Cold Fusion but I forget the name of it. I'm lookiing for a free peice of software for a small IntraNet. Thanks D ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265331 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HostMySite Issue
long. Convincing HMS of that is another story. I am a little surprised they would be so hard headed about it. As am I. We finally gave up on our hosting company of 8 years a month or so backwe are now moving ALL of our clients to HostMySite (and out company domain has already moved). They have been AWESOME!! Even last night one of the techs went above and beyond to sort out a mail issue (quite a non-standard setup which made things complex)he ultimately relaxed the SMTP authentication to ensure mail from my app would send no matter what. So if they'll relax a rule like thatI'm sure they'll listen to reason on this one...just make a bit more noise ;-) 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: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265332 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Best book for PostgreSQL?
Anyone have any recommendations for a book to learn PostgreSQL from? I'm thinking intermediate-to-advanced usage, everything from server management to custom datatypes, stored procedures, etc. There's a book due in March that covers usage on Windows (http://mhprofessional.com/product.php?isbn=0071485627) but I really don't need four chapters on languages I won't be using, and I suspect it wouldn't be advanced enough. Thanks. -- Damien McKenna - Web Developer [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265333 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HostMySite Issue
Scorpio server monitoring wouldn't necessarily alleviate this. The 50 second rule is something Host my site has decided upon and SeeFusion is simply the tool they are enforcing it with. I meant more in terms of not *needing* to use something like SeeFusion, which allows the host to be so restrictive and take away some normal tools we have to specify a page to normally run longer. While can't speak for the business rules of HMS, and I can verify that it is very easy to specify exception templates in the SeeFusion active monitoring rules. I do it myself for reports which I expect to run long. Well, that's good to know at least. HMS has been telling me there is no way at all to override the setting. As far as a solution I agree with what Ben Nadel said. Copy it somewhere with a cryptic file name, and then redirect to it. I would recommend using a JavaScript redirect. The problem here is that ideally I would find a solution that will work for people who purchase my software as well. One requirement is the code needs to work without Javascript in case the customer has it turned off. Is there a reason you would use a JS redirect rather than cflocation? Would there be a problem with the directory not being created first? Since cflocation is a 302 redirect to my knowledge, not sure that it would be a problem. If you create the file in a directory which has the cryptic name, then not only would it be hard to guess, but the user won't have to rename the file when they get it downloaded-- I hate that. Yes, I definitely think this would be more secure versus using the same directory each time and a renamed file. But I'll also have to recode some way to present the file, versus the current method that checks for access, calls the cfcontent and starts the download, but never actually relocates the user to a new page. And then, of course, clear files over 1 day old out of the directory or something. The maintenance definitely is an issue as well. To use directories, I'll have to keep a list of directories created and then run a scheduled function every day to clear them. I try to avoid the use of required scheduled tasks since a fair number of my customers really aren't very ColdFusion savvy and even setting up datasources can be confusing for them. ;-) I'll have to see if I can maybe set this method up as an optional way to do downloads so they can use whichever method works best for them. Thanks for the ideas! --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265334 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam DECREASES performance? (To be selectable in CF8?)
Gaulin, Mark wrote: I thought I saw somewhere that the next version of CF (CF8?) would indeed allow the use of cfqueryparam without forcing the conversion of the sql to a prepared statement IIRC JDBC does not support that so I doubt Adobe will add that to CF. But that does not mean that support for the combination of cfqueryparam and query caching is impossible. Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265335 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best book for PostgreSQL?
To answer my own question, I'm probably going to go to a brick-n-mortar book store and compare these two: Beginning Databases with PostgreSQL: From Novice to Professional, Second Edition (ISBN: 1-59059-478-9) http://www.apress.com/book/bookDisplay.html?bID=424 PostgreSQL, Second Edition (ISBN: 0-672-32756-2) http://safari.samspublishing.com/0672327562 -- Damien McKenna - Web Developer [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265336 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFID and CFToken
Here's the issue: Shared code base utilized by 1400+ sites and we're tracking stats (users to sessions, etc). To properly track sessions among those who do not have cookies enabled (and there are many) we would need to pass CFID/CFToken to each page request. This requires us to change 7,000+ templates in a dynamic system (Hence me looking for a regex). Cutter Adkins, Randy wrote: Nothing wrong with it but I got out the message was he was wanting to update all the pages to use the variables. So instead of opening and changing a page one at a time, to do a Search/Replace. -Original Message- From: Christopher Jordan [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 1:28 PM To: CF-Talk Subject: Re: CFID and CFToken Why couldn't you do it with CF Code? Well, I guess if he's creating all his HTML by hand and just using CF for the back end... otherwise, you'd do it when CF is creating the page. CFOutput a href=somepage.cfm?CFID=#Session.CFID#CFTOKEN=#Session.CFToken#MyLink /a /CFOutput What's wrong with something like that? Cheers, Chris Adkins, Randy wrote: Well not really with CF Code but why not use the Search/Replace function within HomeSite/DW/ or Eclipse and update the pages that way? -Original Message- From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 1:00 PM To: CF-Talk Subject: CFID and CFToken Does anyone know of a way to programmatically add the CFID and CFToken variables to every link within a rendered page (if needed)? Links, form actions, etc., via some regex or something. Cutter ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265337 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFID and CFToken
Well then... hm... some sort of search/replace would be good. You could checkout a program called NoteTab Light. It has a powerful search and replace capability which includes the ability to use regular expressions. Chris Cutter (CFRelated) wrote: Here's the issue: Shared code base utilized by 1400+ sites and we're tracking stats (users to sessions, etc). To properly track sessions among those who do not have cookies enabled (and there are many) we would need to pass CFID/CFToken to each page request. This requires us to change 7,000+ templates in a dynamic system (Hence me looking for a regex). Cutter Adkins, Randy wrote: Nothing wrong with it but I got out the message was he was wanting to update all the pages to use the variables. So instead of opening and changing a page one at a time, to do a Search/Replace. -Original Message- From: Christopher Jordan [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 1:28 PM To: CF-Talk Subject: Re: CFID and CFToken Why couldn't you do it with CF Code? Well, I guess if he's creating all his HTML by hand and just using CF for the back end... otherwise, you'd do it when CF is creating the page. CFOutput a href=somepage.cfm?CFID=#Session.CFID#CFTOKEN=#Session.CFToken#MyLink /a /CFOutput What's wrong with something like that? Cheers, Chris Adkins, Randy wrote: Well not really with CF Code but why not use the Search/Replace function within HomeSite/DW/ or Eclipse and update the pages that way? -Original Message- From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 1:00 PM To: CF-Talk Subject: CFID and CFToken Does anyone know of a way to programmatically add the CFID and CFToken variables to every link within a rendered page (if needed)? Links, form actions, etc., via some regex or something. Cutter ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265338 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: HostMySite Issue
Well, that's good to know at least. HMS has been telling me there is no way at all to override the setting. Yeah, that's crap. Ask to speak with a manager if they tell you that again. SeeFusion lets you exclude URL substrings. Here is a quote from the configuration interface: 'A space-delimited list of URL substrings to ignore for this rule. For example, to exclude longreport.cfm and all files in the /batchjobs/ folder, type: longreport.cfm /batchjobs/' a problem with the directory not being created first? Since cflocation is a 302 redirect to my knowledge, not sure that it would be a problem. Well, I guess cflocation would work just as well. For some reason I was thinking it would be part of the same request, but actually you are correct in saying it returns a 302 (temporary redirect) to the browser, and then the browser makes a second http request for to the new location. As far as the directories not being created first... I don't know if you would have any problems with that. Sometimes the cffile tag will quit executing but the file system is still finishing copying the file. Some times waiting for a few seconds BEFORE doing the redirect is enough time for it to be there. The maintenance definitely is an issue as well. To use directories, I'll have to keep a list of directories created and then run a scheduled function every day to clear them. Actually, what I have done in the past here is dirty, but quick. Everytime you go to write a new file, just do a cfdirectory to get a list of all the files/directories, use a query of queries to filter out ones older than a day, and then delete them. That way it cleans itself every time it is used. Of course, that approach does assume that there is fairly regular traffic, since it would only clean up every time it was used. That does eliminate the need for scheduled tasks and such. ~Brad ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265339 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HostMySite Issue
'A space-delimited list of URL substrings to ignore for this rule. For example, to exclude longreport.cfm and all files in the /batchjobs/ folder, type: longreport.cfm /batchjobs/' But can you ignore based on querystrings? My software is Fusebox-based, so pretty much everything runs through the index.cfm file. It would only be for a specific fuseaction that I would need the timeout ignored. As far as the directories not being created first... I don't know if you would have any problems with that. Sometimes the cffile tag will quit executing but the file system is still finishing copying the file. Some times waiting for a few seconds BEFORE doing the redirect is enough time for it to be there. Ah right, I have to copy the file as well. I don't think there really will be an issue though since the only way I'd do this is have a link to the file that the customer would click on...by the time they do *that* it should be finished. But throwing in a short delay would probably be a good idea anyway. Actually, what I have done in the past here is dirty, but quick. Everytime you go to write a new file, just do a cfdirectory to get a list of all the files/directories, use a query of queries to filter out ones older than a day, and then delete them. That way it cleans itself every time it is used. Yes, I've done that as well in the past. Of course, that approach does assume that there is fairly regular traffic, since it would only clean up every time it was used. Right, that is my concern in this case. For my own site, it's not unusual for there to be no downloads for several days, and with other users it may be even longer. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265340 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cold Fusion for small IntraNet
Check out Coral Web Builder at www.pcaonline.com, too. According to information I got from the company, it takes the place of CF server and you can also deploy it on client machines, via CD with your apps, etc. I'm going to give it a try soon. Rick -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 1:52 PM To: CF-Talk Subject: Re: Cold Fusion for small IntraNet Its either BlueDragon (www.newatlanta.com) or Ralio (http://www.railo.ch/en/index.cfm). Rey ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265341 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: HostMySite Issue
'A space-delimited list of URL substrings to ignore for this rule. For example, to exclude longreport.cfm and all files in the /batchjobs/ folder, type: longreport.cfm /batchjobs/' But can you ignore based on querystrings? My software is Fusebox-based, so pretty much everything runs through the index.cfm file. It would only be for a specific fuseaction that I would need the timeout ignored. Yes, it is possible. I use Fusebox, and had to figure out myself how to do it. The trick is to use a method SeeFusion makes available called setRequestName(). This is how it works: cfif listfindnocase(exception list,fusebox.fuseaction) cfset seefusion = createObject(java, com.seefusion.SeeFusion) cfset seefusion.setRequestName(seefusion_rule_exception_ replacenocase(cgi.script_name,/,)) /cfif Now SeeFusion reports the file being requested as seefusion_rule_exception_index.cfm instead of just index.cfm Very handy indeed. Good luck. :-P ~Brad ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265342 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Hey Intermedia, Happy Frickin' New Year!
So we got into the office today to find an email message stating that all FTP and login passwords have been changed for all of our accounts at Intermedia for stronger security. With no prior warning. Yep, thats just effing wonderful, you pricks, now I have applications that are crashing on Friday afternoon on a long holiday weekend. Oh, and the EPA doles out fines for one of those apps when the data isnt publicly available within 24 hours. And the software vendor that needs to change the password on the other end is not available until Tuesday (and why would they, its a holiday!) Yay, job well done! Just wanted to publicly say that Intermedia sucks, and Im so happy that we have move to a dedicated solution. This is not the first complaint that I have from them. If you are thinking about moving to them, run the other direction. I wish there was someone here that represents the company so that they could read this, but alas, their CF knowledge is much less than they profess, and they would never frequent a place like this. Oh yea, the best part is that when we wrote in to ask WTF are they thinking, we got a blasé answer that said, I kid you not: Sorry for the inconvenience. Signed, Support. Pardon my pre-holiday rant. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265343 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hey Intermedia, Happy Frickin' New Year!
That was supposed to go to CF-Comm. Sorry for the OT post. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 4:04 PM To: CF-Talk Subject: Hey Intermedia, Happy Frickin' New Year! So we got into the office today to find an email message stating that all FTP and login passwords have been changed for all of our accounts at Intermedia for stronger security. With no prior warning. Yep, thats just effing wonderful, you pricks, now I have applications that are crashing on Friday afternoon on a long holiday weekend. Oh, and the EPA doles out fines for one of those apps when the data isnt publicly available within 24 hours. And the software vendor that needs to change the password on the other end is not available until Tuesday (and why would they, its a holiday!) Yay, job well done! Just wanted to publicly say that Intermedia sucks, and Im so happy that we have move to a dedicated solution. This is not the first complaint that I have from them. If you are thinking about moving to them, run the other direction. I wish there was someone here that represents the company so that they could read this, but alas, their CF knowledge is much less than they profess, and they would never frequent a place like this. Oh yea, the best part is that when we wrote in to ask WTF are they thinking, we got a blasé answer that said, I kid you not: Sorry for the inconvenience. Signed, Support. Pardon my pre-holiday rant. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265344 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HostMySite Issue
HMS makes *NO* exceptions to the 50 second rule, even for rarely used administrative templates. This basically forces you off their shared server if you ever need any template to run more than 50 seconds. I had to spring for a $1,600 VPS to keep my site alive. While this has been a giant pain in the neck for me I do respect HMS` fanatical commitment to defending the performance of their shared servers. Their shared servers had persistent performance issues before they imposed the 50 second rule. Bob Mack Well, that's good to know at least. HMS has been telling me there is no way at all to override the setting. Yeah, that's crap. Ask to speak with a manager if they tell you that again. SeeFusion lets you exclude URL substrings. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265345 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Hey Intermedia, Happy Frickin' New Year!
That was supposed to go to CF-Comm. Sorry for the OT post. Sounds like this post belongs here too. Will ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265346 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: HostMySite Issue
Well, I suppose it is their prerogative, however to flat out tell a customer that, there is no way to override that setting is lying. I HATE it when customer service tells me they can't doing something when what they really mean is they aren't allowed or choose not to allow for it to happen. Truthfulness is key for me. ~Brad -Original Message- From: Robert Mack [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 2:17 PM To: CF-Talk Subject: Re: HostMySite Issue HMS makes *NO* exceptions to the 50 second rule, even for rarely used administrative templates. This basically forces you off their shared server if you ever need any template to run more than 50 seconds. I had to spring for a $1,600 VPS to keep my site alive. While this has been a giant pain in the neck for me I do respect HMS` fanatical commitment to defending the performance of their shared servers. Their shared servers had persistent performance issues before they imposed the 50 second rule. Bob Mack Well, that's good to know at least. HMS has been telling me there is no way at all to override the setting. Yeah, that's crap. Ask to speak with a manager if they tell you that again. SeeFusion lets you exclude URL substrings. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265347 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hey Intermedia, Happy Frickin' New Year!
Sounds like they got hacked and are trying to cover up/prevent access of compromised accounts. ~Brad -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 3:04 PM To: CF-Talk Subject: Hey Intermedia, Happy Frickin' New Year! So...we got into the office today to find an email message stating that all FTP and login passwords have been changed for all of our accounts at Intermedia for stronger security. With no prior warning. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265348 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HostMySite Issue
$1600 VPS...what the hell is that running??? I assume it's a tad more than the standard $45-$150 VPS is 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: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265349 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HostMySite Issue
HMS makes *NO* exceptions to the 50 second rule, even for rarely used administrative templates. This basically forces you off their shared server if you ever need any template to run more than 50 seconds. I had to spring for a $1,600 VPS to keep my site alive. Sounds like it's not worth my trying to fight it then. I just wish they had this information clearly indicated somewhere on their site, because I would have known not to move my site to them otherwise. Buying a VPS is not an option for me financially, nor would I consider it when there are plenty of other hosts that don't do this. I'll have to debate whether completely recoding my download function is less work than moving the site to another less restrictive host. While this has been a giant pain in the neck for me I do respect HMS` fanatical commitment to defending the performance of their shared servers. Their shared servers had persistent performance issues before they imposed the 50 second rule. This sounds a lot like throwing the baby out with the bathwater to me. Surely there are more reasonable approaches they could take that would not break sites that aren't causing problems. I also worry about my customers on their servers being able to do major software upgrades in the future. These often include a fair amount of code and data migration that can take awhile to run. Normally a simple cfsetting tag will ensure they won't timeout halfway through the upgrade, but HMS users will have to find other ways to upgrade their sites if they have a lot of data to convert and hit this 50 second mark. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265350 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HostMySite Issue
Well, I suppose it is their prerogative, however to flat out tell a customer that, there is no way to override that setting is lying. I HATE it when customer service tells me they can't doing something when what they really mean is they aren't allowed or choose not to allow for it to happen. I agree, their emails to me have definitely implied that setting a timeout is an all-or-nothing situation. Here's the exact message I got: Correct, this will affect any queries for CF and there is not a way to bypass this. We currently do not have it in place to exclude anyone, everyone that runs cold fusion will have to adhere by this rule. Interesting that they didn't even mention using a VPS as an option although I did assume that this only applied to shared hosting. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265351 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HostMySite Issue
Yes, it is possible. I use Fusebox, and had to figure out myself how to do it. The trick is to use a method SeeFusion makes available called setRequestName(). Thanks for sharing the information! At least I have some ammunition to use with them and show that it would be easy for them to allow my page to run without putting their servers majorly at risk. ---Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265352 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best book for PostgreSQL?
Hi Damien, If it wouldn't be too much trouble, would you mind posting what you find? I'm very interested in this as well and just haven't had the opportunity to do my own research. The documentation on the PostgreSQL website is very good, but sometimes it's just nice to have a good book about things. I'm personally very interested in clustering. Thanks in advance! Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Blue Dragon Alliance Member [EMAIL PROTECTED] Damien McKenna wrote: To answer my own question, I'm probably going to go to a brick-n-mortar book store and compare these two: Beginning Databases with PostgreSQL: From Novice to Professional, Second Edition (ISBN: 1-59059-478-9) http://www.apress.com/book/bookDisplay.html?bID=424 PostgreSQL, Second Edition (ISBN: 0-672-32756-2) http://safari.samspublishing.com/0672327562 -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265353 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HostMySite Issue
Robert Mack wrote: I had to spring for a $1,600 VPS to keep my site alive. For $100 more, you could get a Dedicated Server with CFMX for that price. Seems kind of spendy to put that kind of money into a VPS. Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Blue Dragon Alliance Member [EMAIL PROTECTED] ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265354 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Reactor Issues
Good Afternoon, I hope I am not posting something that has been posted a billion times, but here we are. I am not sure why I am having these issues as I have implement ColdSpring and Reactor in my projects together before. I am also using Mach-ii as my OO framework. I am getting the following error when attempting to getAll() from my Service table in my database: The argument REACTOR passed to function init() is not of type reactor.reactorFactory The error occurred in D:\Websites\DigitalEyeon\mladamsins\webroot \model\ServiceListener.cfc: line 5 ServiceListener.cfc: cfcomponent name=ServiceListener extends=MachII.framework.Listener cffunction name=configure access=public returntype=void hint=Configures this listener /cffunction cffunction name=init access=public returntype=void hint=Inits this listener cfargument name=Reactor required=true type=reactor.reactorFactory / cfscript variables.Reactor = arguments.Reactor; /cfscript /cffunction cffunction name=getAll access=remote returntype=query cfreturn variables.Reactor.createGateway('Service').getAll() / /cffunction /cfcomponent Services.xml: ?xml version=1.0 encoding=UTF-8? beans bean id=reactor class=reactor.reactorFactory constructor-arg name=configuration value/config/reactor.xml/value /constructor-arg /bean bean id=serviceListener class=model.ServiceListener / bean id=udf class=model.UDF singleton=true / /beans Mach-ii ColdSpring plugin config: plugin name=ColdspringPlugin type=coldspring.machii.ColdspringPlugin parameters parameter name=configFilePropertyName value=servicesConfig / parameter name=configFilePathIsRelative value=true / parameter name=resolveMachiiDependencies value=true / /parameters /plugin Thanks, Kyle ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265355 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Admin Panel Question
I created an admin panel for a client with the typical add, delete, modify features. My client has a news section on their website along with an archive section for old news. My client wants the old news to be placed in the archive section when it is deleted from the current news page through the admin panel. Is this possible? Any ideas? Steve ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265357 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HostMySite Issue
Let's all remember that the techs giving out the all or nothing statements may very well have been told by upper management that it is not possible. I would not expect them all to look into the validity of that statement. I can completely understand their positionkeep the shared hosting running smooth...and it does. If you need heavier processing...pay for it. I understand it's an inconvenince, but things can slip through the cracks. Their online support pages are lightyears ahead of the host we just left. Mary Joyou were just unlucky in this case.but did you ASK if they had any timeout restrictions?? ;-) I know I asked all kinds of questions before moving (especially our clients). I'm not easily impressed (just ask anyone that works with me...hehe). I can't say enough good things about HostMySite. I have techs CALLING me days after a support request was inititaed with them...just to make sure it was resolved in their absence (like over a weekend or something). They answer the phone fast and the person that picks up in all but 1 case has resolved my issue(s) within 5 minutes. OK...I'm done gushing now ;-) 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: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265356 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Hey Intermedia, Happy Frickin' New Year!
Sounds like they got hacked and are trying to cover up/prevent access of compromised accounts. I bet that's exactly what happened, or maybe they have a disgruntled ex-employee with permissions. They must know they would get a rash of shit from their customers, so it wouldn't be in their benefit to do that without any warning. It must have been a necessity. -- Josh ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265358 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best book for PostgreSQL?
This might sound a little funny but I have found the online docs to be the most useful over all of the books I have bought. Of course maybe I just bought bad books. ;) http://www.postgresql.org/docs/ Dave On Dec 29, 2006, at 1:03 PM, Damien McKenna wrote: Anyone have any recommendations for a book to learn PostgreSQL from? I'm thinking intermediate-to-advanced usage, everything from server management to custom datatypes, stored procedures, etc. There's a book due in March that covers usage on Windows (http://mhprofessional.com/product.php?isbn=0071485627) but I really don't need four chapters on languages I won't be using, and I suspect it wouldn't be advanced enough. Thanks. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265360 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HostMySite Issue
Robert Mack wrote: I had to spring for a $1,600 VPS to keep my site alive. For $100 more, you could get a Dedicated Server with CFMX for that price. Seems kind of spendy to put that kind of money into a VPS. Warm regards, Jordan Michaels OK...you both must be talking yearly costs thendedicated should anly be a few hundred $ per month 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: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Jordan Michaels [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, December 29, 2006 2:04 PM Subject: Re: HostMySite Issue Robert Mack wrote: I had to spring for a $1,600 VPS to keep my site alive. For $100 more, you could get a Dedicated Server with CFMX for that price. Seems kind of spendy to put that kind of money into a VPS. Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Blue Dragon Alliance Member [EMAIL PROTECTED] ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265359 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Admin Panel Question
Sure. When they delete the article I assume you are passing through some unique ID number. Just take that ID number, run an insert query that does a select sub query of the live article and insert it into the archive table, then delete the current one. Make sure to wrap it all in a CFTRANSACTION tag so in case something goes wrong it is not deleted. Bruce On 12/29/06, Steve LaBadie [EMAIL PROTECTED] wrote: I created an admin panel for a client with the typical add, delete, modify features. My client has a news section on their website along with an archive section for old news. My client wants the old news to be placed in the archive section when it is deleted from the current news page through the admin panel. Is this possible? Any ideas? Steve ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265361 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: HostMySite Issue
OMG they misspelled ColdFusion. LOL! There's no space!!! (sorry, it's Friday...) ~Brad -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 2:45 PM To: CF-Talk Subject: Re: HostMySite Issue Well, I suppose it is their prerogative, however to flat out tell a customer that, there is no way to override that setting is lying. I HATE it when customer service tells me they can't doing something when what they really mean is they aren't allowed or choose not to allow for it to happen. I agree, their emails to me have definitely implied that setting a timeout is an all-or-nothing situation. Here's the exact message I got: Correct, this will affect any queries for CF and there is not a way to bypass this. We currently do not have it in place to exclude anyone, everyone that runs cold fusion will have to adhere by this rule. Interesting that they didn't even mention using a VPS as an option although I did assume that this only applied to shared hosting. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265362 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
What do you name your status variable on db calls?
Looking for some ideas here. I'm starting up a new system and am wondering on a naming convention. When you make a call to a db stored proc/query/whatever, and you also return a variable that indicates the status of that call, what do you name that parameter/variable? I like the prefix concept because it's easier to see these special vars and distinguish them from normal fields. Example: dbStatus dbMessage (perhaps to house an error message string, if needed) dbDateTime (maybe holds time of error for outputting to user) Or maybe not restricting the prefix to a database only, but make it more broad: svrStatus svrMessage svrDateTime But is that too broad? Svr (i.e. Server) pretty much applies to everything. I'm interested to see how you folks have handled this. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265363 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HostMySite Issue
I can completely understand their positionkeep the shared hosting running smooth...and it does. If you need heavier processing...pay for it. Yes, but breaking *normal* ColdFusion functions in the process is a bit harsh, IMO. Their online support pages are lightyears ahead of the host we just left. Mary Joyou were just unlucky in this case.but did you ASK if they had any timeout restrictions?? ;-) Sure, I always check things like what the CF timeouts are set to, tag restrictions, etc. The problem is that cfcontent is not normally effected by timeout settings...so it didn't occur to me to ask if they had timeouts outside of ColdFusion set that would override normal functions. And they certainly didn't volunteer that information. Heck, it took 3 emails back and forth to even establish that it was not normal ColdFusion timeouts at issue once I started running into problems. If you are doing something so outside the norm, it shouldn't be something that you have to dig deeply to find out about. But as I said, part of my reason for posting was to make sure other people considering using them *do* know about it. They answer the phone fast and the person that picks up in all but 1 case has resolved my issue(s) within 5 minutes. I agree. That's why I went with them in the first place. But if they refuse to help correct this problem, when I'm doing something perfect reasonably and legitimate, I simply will not be able to recommend them anymore. Just as I would not recommend a host that gives great support, but turns off cffile/cfdirectory tags. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265364 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SPAM-LOW: Re: HostMySite Issue
I can completely understand their positionkeep the shared hosting running smooth...and it does. If you need heavier processing...pay for it. Yes, but breaking *normal* ColdFusion functions in the process is a bit harsh, IMO. Fair enoughbut there is only one way to keep idiots (not lumping you in that group) from writing crappy long running garbage and overriding the timeout with cfsetting and killing performance. Granted they are punishing the innocent on that onebut business is business...sometimes it sucks. Their online support pages are lightyears ahead of the host we just left. Mary Joyou were just unlucky in this case.but did you ASK if they had any timeout restrictions?? ;-) Sure, I always check things like what the CF timeouts are set to, tag restrictions, etc. The problem is that cfcontent is not normally effected by timeout settings...so it didn't occur to me to ask if they had timeouts outside of ColdFusion set that would override normal functions. And they certainly didn't volunteer that information. Heck, it took 3 emails back and forth to even establish that it was not normal ColdFusion timeouts at issue once I started running into problems. If you are doing something so outside the norm, it shouldn't be something that you have to dig deeply to find out about. But as I said, part of my reason for posting was to make sure other people considering using them *do* know about it. Likewise I'm sure it didn't occur to them that certain combinmations of CF code would get fouled due to this change. I'm sure if they could see the future they would be in Vegas ;-) As far as not volunteering infothey ain't all CF gurus there (although most of them at least have some basics covered). and yes...ultimately you've done a good deed and given the rest of us the heads up...thanks!! the Devil is surely in the details... They answer the phone fast and the person that picks up in all but 1 case has resolved my issue(s) within 5 minutes. I agree. That's why I went with them in the first place. But if they refuse to help correct this problem, when I'm doing something perfect reasonably and legitimate, I simply will not be able to recommend them anymore. Just as I would not recommend a host that gives great support, but turns off cffile/cfdirectory tags. Ask for Jamiehe knows his stuff...too bad he's moved to Sales...ugh! Sorry if I'm defending my new found hosting starsperhaps I'm a little defensive because my service has been so good...hehe 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: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265365 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Admin Panel Question
You could also perhaps have a column in your news table that indicates whether an article is old or current. Then all you'd have to change is the value of one column for each article that gets deleted. Or maybe the extra column would just indicate that the article is archived. So the column name could be Archived and the value could be the boolean indicating whether it was archived. How about something like that? Cheers, Chris Bruce Sorge wrote: Sure. When they delete the article I assume you are passing through some unique ID number. Just take that ID number, run an insert query that does a select sub query of the live article and insert it into the archive table, then delete the current one. Make sure to wrap it all in a CFTRANSACTION tag so in case something goes wrong it is not deleted. Bruce On 12/29/06, Steve LaBadie [EMAIL PROTECTED] wrote: I created an admin panel for a client with the typical add, delete, modify features. My client has a news section on their website along with an archive section for old news. My client wants the old news to be placed in the archive section when it is deleted from the current news page through the admin panel. Is this possible? Any ideas? Steve ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265366 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Hey Intermedia, Happy Frickin' New Year!
Sounds like this post belongs here too. Yeah. Necessity or not, if you pull a stunt like that you call the troops back in, pay the overtime, field the support calls and do your best to clean up the mess you caused. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265367 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HostMySite Issue
Fair enoughbut there is only one way to keep idiots (not lumping you in that group) from writing crappy long running garbage and overriding the timeout with cfsetting and killing performance. Granted they are punishing the innocent on that onebut business is business...sometimes it sucks. Granted, and I do appreciate the problem, but then refusing to help me override the setting for a page that is being effected, one that is crucial to my business makes me an awful lot less sympathetic about it. Likewise I'm sure it didn't occur to them that certain combinmations of CF code would get fouled due to this change. I would hate to think their knowledge of ColdFusion is so poor as to not realize this. Certainly the emails I have received indicate that they were aware it would cause issues for some people but proceeded anyway. And they certainly are aware of the issue now and are not working to give us options. It makes me rather reluctant about going to all the extra work of coding around the problem versus moving the site, as that would be a tacit agreement with the policy. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265368 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Hey Intermedia, Happy Frickin' New Year!
Amen to that. On 12/29/06, Matt Robertson [EMAIL PROTECTED] wrote: Sounds like this post belongs here too. Yeah. Necessity or not, if you pull a stunt like that you call the troops back in, pay the overtime, field the support calls and do your best to clean up the mess you caused. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265369 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFID and CFToken
Because no everyone has cookies enabled. -Original Message- From: Christopher Jordan [mailto:[EMAIL PROTECTED] Sent: 29 December 2006 18:23 To: CF-Talk Subject: Re: CFID and CFToken I'm not sure why you'd want to do that, (and there may be security risks in doing so), but the CFID and CFToken are typically stored in the cookie scope. You could get them from there to add them to all your links. Cheers, Chris Cutter (CFRelated) wrote: Does anyone know of a way to programmatically add the CFID and CFToken variables to every link within a rendered page (if needed)? Links, form actions, etc., via some regex or something. Cutter ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265370 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: HostMySite Issue
We also apply max timeouts with fusionreactor that causes similar problems, but if a client has a page that needs to run longer, we ad dit to the exclusion list. Perhaps u can ask HMS to do the same. Russ -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: 29 December 2006 17:13 To: CF-Talk Subject: HostMySite Issue I recently moved my site to HostMySite and am now having major problems as a result. Here's the issue: I use a cfcontent tag to send downloaded software down to the client, as is commonly done so the file can be kept in a secure location. The file is around 10 megs so can take anywhere from 10-15 seconds to a minute or two to download. The problem is that HMS is using SeeFusion and has recently set it to end any threads running more than 50 seconds. This is a major problem because it overrides normal ColdFusion behavior that allows tags like cfcontent and cfftp to run to completion. And it even overrides use of a cfsetting tag for pages you expect to take awhile to run so I have no way to override this. So now my customers go to download the software and for many, it keeps timing out on them, and the customer tries again and again until they run out of download attemptsand then of course I get an annoyed email and have to deal with sending them the file another way. HostMySite's suggestion? Use ASPUpload instead! They say they have no problem with the setting causing problems for some people if it keeps the servers running better for everyone else. So this post is for two reasons...to warn anyone that might be considering using HMS shared hosting that they better not ever need a ColdFusion page to run more than 50 seconds. And to see if anyone knows of a way to get the cfcontent to complete faster. Is there any way to get the thread to run to completion without it having to wait for the client to receive the entire file? Any other options I could look at that will integrate into ColdFusion? I hope that when the improved server monitoring with Scorpio comes out that will allow for better handling of things like this. I totally appreciate the need to kill hanging threads and keep the server up and running. But I totally disagree with being able to override normal use of ColdFusion like this. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265371 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HostMySite Issue
We also apply max timeouts with fusionreactor that causes similar problems, but if a client has a page that needs to run longer, we ad dit to the exclusion list. Perhaps u can ask HMS to do the same. I'm trying! But as others in the thread have mentioned, this seems to be their policy on shared servers, no exceptions or exclusions. Oh, just thought of another instance where my customers will be effected by this...those that use verity searching on their stores, the indexing often will take a couple minutes to run if they have a lot of pages and products. So this will kill that process as well. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265372 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: HostMySite Issue
While I understand their need ot do this (we do it too), 50 seconds is just too low. Russ -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: 29 December 2006 22:13 To: CF-Talk Subject: Re: HostMySite Issue We also apply max timeouts with fusionreactor that causes similar problems, but if a client has a page that needs to run longer, we ad dit to the exclusion list. Perhaps u can ask HMS to do the same. I'm trying! But as others in the thread have mentioned, this seems to be their policy on shared servers, no exceptions or exclusions. Oh, just thought of another instance where my customers will be effected by this...those that use verity searching on their stores, the indexing often will take a couple minutes to run if they have a lot of pages and products. So this will kill that process as well. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265373 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HostMySite Issue
All I can suggest, if they won't make an exception, is to find a different provider that is a better fit for you. I've been at the other end of this problem at HMS, where I've had sites that won't stay up because someone else is taking out the server with long running templates or some other code issue and I've had to move to a different HMS shared server. Even if your need is legit, you must be able to see what their problem is: let's say (for example) there's 10 threads available to CF and someone's downloads take 5 minutes each. That means that we only need 10 people to do those downloads at the same time and the server will be completely unresponsive to anyone else for 5 minutes. Perhaps a VPS or dedicated solution is necessary in this case (or rewrite the code so it doesn't tie up a thread for the whole download). On 12/30/06, Mary Jo Sminkey [EMAIL PROTECTED] wrote: We also apply max timeouts with fusionreactor that causes similar problems, but if a client has a page that needs to run longer, we ad dit to the exclusion list. Perhaps u can ask HMS to do the same. I'm trying! But as others in the thread have mentioned, this seems to be their policy on shared servers, no exceptions or exclusions. Oh, just thought of another instance where my customers will be effected by this...those that use verity searching on their stores, the indexing often will take a couple minutes to run if they have a lot of pages and products. So this will kill that process as well. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265374 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OT: CD Storage and Read Device
Hi, all. I thought perhaps one of you might know of a device like this. I've searched the Internet many times looking for one and can't locate one.not even sure one exists. I'm looking for a CD/DVD storage unit that hooks into a computer and not only allows info to be entered into a database so the device can find the disk desired, but I also want a unit will play the CD/DVD. I've found several that will find the disk based on content searches and then spit it out for me to play in my DVD player, but none that incorporate a playback unit. Anyone know of something like this? Rick ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265375 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HostMySite Issue
I know that there are quite a few HMS users on this list, and I would say they have probably benefited from the recommendations they have received from users here. It might help if users of their service from this list were to inform them of our feelings on this issue...something to the effect of... Dear HostMySite, While I understand and appreciate your need to limit rogue processes through the 50 second timeout in SeeFusion, I also feel that there are exceptions to this rule that should be allowed for proper running of legitimate operations. It has come to my attention that this timeout is affecting the sites of other users, and I am concerned that it may affect my sites now or in the future. I would appreciate it if HostMySite would implement an exception policy where certain processes could be allowed to exceed the 50 second timeout. I understand that this type of exception is possible with SeeFusion. Thank you for your consideration of this issue, and also for the excellent service and support I have come to expect from your organization. Thank you, Jim Wright (list of sites hosted) I'll probably send this on myself, as I am concerned that the 50 second timeout will affect some import scripts I use that resize photos. Feel free to use the text of it for your own message if you feel so inclined. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265376 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HostMySite Issue
Even if your need is legit, you must be able to see what their problem is: let's say (for example) there's 10 threads available to CF and someone's downloads take 5 minutes each. That means that we only need 10 people to do those downloads at the same time and the server will be completely unresponsive to anyone else for 5 minutes. Perhaps a VPS or dedicated solution is necessary in this case (or rewrite the code so it doesn't tie up a thread for the whole download). Isn't that where SeeFusion would come in, so you can see where the excessively running threads are occuring?? Certainly if they set up an exception like I am asking, and then see lots of threads constantly being taken up then it would be totally appropriate to ask that I move to a dedicated or VPS solution. But I have maybe one download occuring a day, if even that. On a really busy day, there might be 3 or 4 people downloading over the course of the day. And this is not that huge a file...I wouldn't be seeing nearly as many issues if the timeout was set to 2 minutes. The users that have had problems have generally been more than 3/4 of the way through downloading the file when it timed out. However, I think I am making some progress in getting them to set up an exception for me, thanks to the information I have gotten here. I still have concerns about other tasks that may run over that time limit but most I should be able to more easily work around. And if I ever do start selling so much of my software as to have tons of downloads a day, I will be more than happy to deal with getting a dedicated server. ;-) --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265377 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: CD Storage and Read Device
Though a funny question to ask on Cf-talk, I have nonetheless found the closest thing to what you are requiring. However, it seems that it requires Linux: http://users.tkk.fi/~shaavist/slink/ There you go, Kyle On Dec 29, 2006, at 4:29 PM, Rick Faircloth wrote: Hi, all. I thought perhaps one of you might know of a device like this. I've searched the Internet many times looking for one and can't locate one.not even sure one exists. I'm looking for a CD/DVD storage unit that hooks into a computer and not only allows info to be entered into a database so the device can find the disk desired, but I also want a unit will play the CD/DVD. I've found several that will find the disk based on content searches and then spit it out for me to play in my DVD player, but none that incorporate a playback unit. Anyone know of something like this? Rick ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265378 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT: CD Storage and Read Device
Strange question... I know... I'm just desperate. Thanks for the info. Rick -Original Message- From: Kyle Hayes [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 8:18 PM To: CF-Talk Subject: Re: OT: CD Storage and Read Device Though a funny question to ask on Cf-talk, I have nonetheless found the closest thing to what you are requiring. However, it seems that it requires Linux: http://users.tkk.fi/~shaavist/slink/ There you go, Kyle ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265379 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFID and CFToken
Does anyone know of a way to programmatically add the CFID and CFToken variables to every link within a rendered page (if needed)? Links, form actions, etc., via some regex or something. I believe URLSessionFormat is what you are looking for. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funca115.htm Maybe not though. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265380 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best book for PostgreSQL?
On 12/29/06 5:09 PM, David Livingston wrote: This might sound a little funny but I have found the online docs to be the most useful over all of the books I have bought. I don't always want to carry around my PowerMac + 19 monitor to read a book, plus its tricky to hold the screen steady while on The Thinking Chamber. -- Damien McKenna - Web Developer [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265381 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4