Re: Including App.cfc in App.cfc
Will... In your first application.cfc you're going to create application.dsn, right? Along with this.name http://this.name, yes? So your second application.cfc is going to have this.name http://this.nameas well, yes? And if it's the same string as the name in the first application.cfc, it's going to be looking at the same application space as the first one. So, in your first application.cfc you create application.dsn = mydsn... so long as they're running on the same server it's going to see the same values under the same names in the application scope. In other words you join the data in memory by the name specified in the space inside the cfcomponent tag and outside any of the cffunction tags... by giving them the same name you join them logically in the server's memory. It's effectively the exact same thing as cfincluding an Application.cfmfile, but different in implementation. HTH, J On 7/7/05, Will Tomlinson [EMAIL PROTECTED] wrote: If I have an Application.cfc in the site root, and it contains an APPLICATION.DSN variable, and there's an admin folder with its own App.cfc, how would I include the root's APP.DSN inside the admin folder's app.cfc? When I used App.cfm I just included the root App.cfm. Thanks, Will ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211409 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: XML xmlText or Attributes
When it comes to using things like XSLT, XPath, and other things, using attributes becomes important. Really, in general you want attributes to describe the data that the xmlText contains, and you want to use your attributes to help you sort, filter, and extract your data. For instance, in an XSL transform, you can use xsl:sort select=[EMAIL PROTECTED] / as a valid expression... in other words, it'll sort by an attribute of an element, but it won't sort by xmlText (at least that I know of... I could be way wrong.) So you describe the data with your attributes and you deliver the data with xmlText. Laterz, J On 7/7/05, Andy [EMAIL PROTECTED] wrote: When would I use an attribute to hold a value versus xmlText? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211410 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Including App.cfc in App.cfc
So your second application.cfc is going to have this.name http://this.nameas well, yes? And if it's the same string as the name in the first application.cfc, it's going to be looking at the same application space as the first one. A yes! I THOUGHT that might be a possibility, but haven't had time to test it. Thankgya J! Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211411 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Noob: getting a total from some CFOUTPUTted fields
Here's another way to do it: total: cfoutput#arraysum(yourqueryname[order_value])#/cfoutput Remember that query columns can be treated as arrays and you can use any array function on them. On 7/7/05, Chris Kavanagh [EMAIL PROTECTED] wrote: Hey list! How's it going? My first app is running now. I couldn't have done it without everybody's help! Thanks to all. Perhaps I will eventually become a useful member myself. Now, in my app I have a CFOUTPUT that displays table rows like this: CUSTOMER PRODUCT ORDER VALUE #customer##product##order_value# I'd like to have a TOTAL field at the bottom of the table, that displays the sum of all the CFOUTPUTted #order_values#. Is this very difficult? This is what I'd like to see: CUSTOMERPRODUCTORDER VALUE Tom Apple 100 Dick Banana 200 -- TOTAL 300 How do I calculate the total? Thanks in advance, CK. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211412 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Including App.cfc in App.cfc
-Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 10:44 PM To: CF-Talk Subject: Including App.cfc in App.cfc If I have an Application.cfc in the site root, and it contains an APPLICATION.DSN variable, and there's an admin folder with its own App.cfc, how would I include the root's APP.DSN inside the admin folder's app.cfc? When I used App.cfm I just included the root App.cfm. Well... it is just a CFC. Can't you just CFINVOKE the other Application.cfc methods in the child one? You could do that, or Tim recommended using a separate template and using cfinclude in each applicaiton.cfc to set them... You would just put the cfinclude tag in the onApplicationStart method. He also suggested using the same application name in both cfc's which is fine, but you still have to set or param the variable in both, so you would still need the cfinclude template. Alternately you could design something _like_ the onTap framework's tiered request stages where you have a single Application.cfc which sets the variables in the onApplicationStart method and variations between the root application and the admin application are handled by including code in multiple templates or directories in the onRequestStart method. cffunction name=onRequestStart cfset var x = 0 cfset var local = structnew() cfset local.approot = getDirectoryFromPath(getCurrentTemplatePath()) cfset local.targetpath = getDirectoryFromPath(getBaseTemplatePath()) cfset local.target = listtoarray(replace(local.targetpath,local.approot,),/\) cfset local.path = cfset arrayprepend(local.target,) cfloop index=x from=1 to=#arraylen(local.target)# cfset local.path = listappend(local.path,local.target[x]) cfif FileExists(local.approot local.path /settings.cfm) cfinclude template=#local.path#/settings.cfm /cfif /cfloop /cffunction I've never considered this very complicated... although some people have... anyway, this method (or something like it) would allow you to have the equivalent of something like the old app_locals.cfm concept without the need to include a template in each base template (like the nested Application.cfm templates), since the single Application.cfc would handle it for as many nested directories as you need. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211413 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Including App.cfc in App.cfc
The Application.cfc in the nested directory will omit the Application.cfc code in the parent directory... this means that much of the code to set these variables would need to be duplicated in both cfc's. What I read (and I could be misinterpreting) is that he wanted a way to eliminate the need to duplicate that code. Will... In your first application.cfc you're going to create application.dsn, right? Along with this.name http://this.name, yes? So your second application.cfc is going to have this.name http://this.nameas well, yes? And if it's the same string as the name in the first application.cfc, it's going to be looking at the same application space as the first one. So, in your first application.cfc you create application.dsn = mydsn... so long as they're running on the same server it's going to see the same values under the same names in the application scope. In other words you join the data in memory by the name specified in the space inside the cfcomponent tag and outside any of the cffunction tags... by giving them the same name you join them logically in the server's memory. It's effectively the exact same thing as cfincluding an Application.cfmfile, but different in implementation. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211414 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Coldfusion Crashing!
Thanks a lot for all your help guys. After struggling two days/nights and done all the audit etc. I sort of gave up and upgraded to MX6.1. It hasn't really fixed the problem as such but the number of crashes has been significantly reduced. I've found out in the application, some third party calls to Visual Fox pro (ODBC) and pages using OPENQUERY 've been causing the crash at peak hours when the server running that Fox Pro application is quite busy and not responding in timely fashion. Coldfusion5.0 was just hanging in there and waiting probably forever for that thread to respond - result ofcourse crash after few minutes. However MX is taking care of that side and takes a significant amount of unresponsive threads before it crashes (3 or 4 times) a day. Now I am going through the code and trying to avoid the OPENQUERY and also unnecessary calls to the fox pro DB. 've a great weekend!! Shaz -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: 05 July 2005 22:16 To: CF-Talk Subject: Re: Coldfusion Crashing! The issues Jennifer and Steven brought up were pretty much spot on. If you have something hanging a request and you pile on simultaneous requests that will do nothing to address the bottleneck. I would do things a little differently but the same basic principles apply. First of all, I'm going to assume this is a crisis situation, and you need at least a resemblence of stability first and diagnosis/correction can follow, so long as you stop the system from dying. First, REDUCE the number of simultaneous threads to as low of a number as you can, with one being the minimum and the most stable setting. Just because its more likely to be stable doesn't mean it will perform 'well'. This will indeed introduce a performance bottleneck, but its meant to. When in crisis mode this is often the way to stabilize a server in an emergency, letting it run long enough to work towards a fix while users get to keep using it. Be careful (i.e. watch it while this is going on to make sure you have not created a new problem). Still, only the busiest box will time threads out that are queued as the result of this. Next enable a CF restart after X threads have hung, where the restart value is one LESS than the value set in the first step above. Set the hung thread count higher than the simultaneous request count and it will never fire. In an emergency situation I would set this to one (1) thread. Again, pay close attention to what is going on because the only thing worse than a CF box that keeps dying is one that restarts itself every 15 seconds. Yes, this is aggressive but if you get even one hung thread chances are by the time the second one arrives CF will be done for and no longer able to restart itself without human intervention. Next, enable the tracking of long-running page requests. If the above two steps have stabilized your server enough so it can run (bearing in mind that each or the two in tandem can make things worse for a heavy-traffic box), this remains an excellent tool for debugging, despite its noted weaknesses. lastly, be sure to check your mail spool file. What is being described sounds a lot like that problem. I ran into it on a CF5 box a few months back and CF was dying and as soon as it got started up again it instantly croaked until I remembered this problem, checked for it and deleted the offending file (you have to stop the CF service first or the file will be locked and is undeletable. HtH, -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211415 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: XML xmlText or Attributes
Thanks. This is consistent with how I've seen XML formed. Andy -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 4:40 PM To: CF-Talk Subject: RE: XML xmlText or Attributes I read an Eric Meyer, of CSS fame, quote on this that makes some sense to me. As a general rule of thumb i.e. not a hard and fast rule. Use xmlText for values you mean to be output and viewed by the user. Use attributes for values used to sort, filter or select the above. Make sense. Otherwise I will have to go dig up the quote, and I am so bad at that. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211416 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: SQL count of rows from a union query
I just solved it using an ugly workaround. Indeed, unless you really need the count to occur in the query, it should be more efficient to make two separate queries and just add their record counts in CF. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211417 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Application Planning
I just got the e-mail too. As I mentioned in my earlier post, I've already been using Fusebuilder. I'm just wondering if there may be anything else out there that's better. What do you think is missing from FuseBuilder? -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211418 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: SQL count of rows from a union query
Hey George, AFAIK, derived tables in T-SQL need an alias...try this: SELECT count(*) FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) tblDerived (note the tblDerived as the alias) -Joe -- Get Glued! The Model-Glue ColdFusion Framework http://www.model-glue.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211419 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: URL String and cfsavecontent
Try it directly (make sure it exists). -mk cfsavecontent variable=showApprovalAlert var myvar = _root.lid; var myClickHandler = function (evt) { if (evt.detail == mx.controls.Alert.YES) { getUrl('Detail.cfm?task=1LID=' + _root.lid, GET); } } //create the alert var myAlert = mx.controls.Alert.show(Are you sure you want to approve this request, Warning, mx.controls.Alert.YES | mx.controls.Alert.CANCEL, this, myClickHandler); /cfsavecontent -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 8:18 PM To: CF-Talk Subject: Re: URL String and cfsavecontent A ha! That's a COMPLETELY different question, and I have no idea how to solve, since I don't use CF7 for anything. Any set of flash docs should give you the anwser though. You're form is just a movie, so it has the same access to the page it's embedded in's URL scope as a normal Flash IDE-created movie. cheers, barneyb On 7/7/05, Michael Hohnecker [EMAIL PROTECTED] wrote: Here is a better example of what i'm doing. I have an alert box in flash forms. I would like the getURL to run with the current URL string which looks like http://www.test.com?lid=4. Is this the proper way to bring in a URL string variable: var myvar = _root.lid; cfsavecontent variable=showApprovalAlert var myvar = _root.lid; var myClickHandler = function (evt) { if (evt.detail == mx.controls.Alert.YES) { getUrl('Detail.cfm?task=1LID=' +myvar); } } //create the alert var myAlert = mx.controls.Alert.show(Are you sure you want to approve this request, Warning, mx.controls.Alert.YES | mx.controls.Alert.CANCEL, this, myClickHandler); /cfsavecontent cfform format=flash action=#cgi.SCRIPT_NAME# method=post name=Approve width=400 height=200 cfformgroup type=horizontal visible=yes enabled=yes cfinput type=button name=btnApproval label=test value=Approve Request onClick=#ShowApprovalAlert# cfinput type=button name=btnDecline label=test value=Decline Request /cfformgroup /cfform -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211420 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Calling Parent Page in IFRAME - Cross Domai
Sorry for the OT. I have a problem where I have a page say on www.xyz.com , this page contains an iframe which has loaded a site www.abc.com. Is there anyway I can reference the parent page from the iframe (and from within the www.abc.com pages) without the Permission Denied error due to JS Security Restrictions? Is there anyway I can allow/trust the domain to allow me to cover it all? Thanks Neil This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, 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 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211421 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Flash Forms Newbie Question
I am using the following code on my very first Flash Form: cfform action=Submit.cfm method=POST format=Flash skin=haloBlue table width=66% border=1 tr td width=50% strongemStaff Member/em/strongbr /td td width=50% cfselect name=StaffMember size=1 message=You did not select a staff member! width=200 visible=Yes enabled=Yes required=Yes option value=Jane Doe selectedJane Doe/option /cfselect /td /tr /table input type=submit name=Submit value=Submitinput type=reset name=Reset value=Reset /cfform When I view the form, the drop drown box appears (even with only one item) but the text Staff Member does not show up, nor does the border of the table, etc. The ONLY thing that shows up is the drop down box. What am I doing wrong? TIA, Tim ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211422 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF and SQL Server DTS - Dynamically
Has anyone done this before? I am using CFMX6.1 and MS SQL Server 7. I have a DTS package that exports data out of a table to a CSV file. Basically it uses a SQL query based on a datecreated field. This allows me to take anything that is 30 days or older and make a CSV out of it. Now, the big question. Is there a way to dynamically set the date in the datecreated portion of the query and have it save as a different file name? The saved DTS packages seem uneditable. Any way to do this from a CF page? Thanks. Jeff ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211423 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Flash Forms Newbie Question
To use flash forms with the format of flash you will have to use the cfgroupitem and other tags to get you HTML to show up. Remember, it generates a flash movie so you can't just mingle html and cfinput tags like you used to. -mk -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 10:20 AM To: CF-Talk Subject: Flash Forms Newbie Question I am using the following code on my very first Flash Form: cfform action=Submit.cfm method=POST format=Flash skin=haloBlue table width=66% border=1 tr td width=50% strongemStaff Member/em/strongbr /td td width=50% cfselect name=StaffMember size=1 message=You did not select a staff member! width=200 visible=Yes enabled=Yes required=Yes option value=Jane Doe selectedJane Doe/option /cfselect /td /tr /table input type=submit name=Submit value=Submitinput type=reset name=Reset value=Reset /cfform When I view the form, the drop drown box appears (even with only one item) but the text Staff Member does not show up, nor does the border of the table, etc. The ONLY thing that shows up is the drop down box. What am I doing wrong? TIA, Tim ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211424 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
load balancing
Hi all, We are thinking of scaling our servers and are looking into load balancing. We have had load balancing done through a dedicated switch at one of the companies for a client earlier, but for various reasons we don't want to use them for this client. What are our options? Can we do load balacing through windows load balancing? Is it compatible with coldfusion or will people keep losing their sessions? I heard someone mention having ColdFusion pass requests over to another server when it gets busy, load balancing things that way. We're currently with crystaltech right now and as far as I know they don't support hardware load balancing. If none of the software solutions work out, we'll have to move vendors. Can someone recommend a reliable host that supports hardware load balancing? We only need something simple to start with (2 web servers, one db) Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211425 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: load balancing
We've recently gone live using Windows Load balancing on Windows 2003 Server and CFMX7 for out Intranet and about to go live with the same but CFMX7 Enterprise for our internet sites. It works just fine with CFMX - you're only load balancing port 80 at the end of the day. We're using client variables stored in cookies for maintaining state - yeah yeah I know client vars are the spawn of satan. CF Enterprise allows you to pass sync sessions across instances etc etc if you use them. We have it setup none sticky so requests alernate between either node in the farm. so far so good, jb. On 7/8/05, Russ [EMAIL PROTECTED] wrote: Hi all, We are thinking of scaling our servers and are looking into load balancing. We have had load balancing done through a dedicated switch at one of the companies for a client earlier, but for various reasons we don't want to use them for this client. What are our options? Can we do load balacing through windows load balancing? Is it compatible with coldfusion or will people keep losing their sessions? I heard someone mention having ColdFusion pass requests over to another server when it gets busy, load balancing things that way. We're currently with crystaltech right now and as far as I know they don't support hardware load balancing. If none of the software solutions work out, we'll have to move vendors. Can someone recommend a reliable host that supports hardware load balancing? We only need something simple to start with (2 web servers, one db) Russ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211426 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: load balancing
We're on MX 6.1 right now. Is this possible with MX or do I need 7? Also do I need the enterprise version? Russ -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 12:18 PM To: CF-Talk Subject: Re: load balancing We've recently gone live using Windows Load balancing on Windows 2003 Server and CFMX7 for out Intranet and about to go live with the same but CFMX7 Enterprise for our internet sites. It works just fine with CFMX - you're only load balancing port 80 at the end of the day. We're using client variables stored in cookies for maintaining state - yeah yeah I know client vars are the spawn of satan. CF Enterprise allows you to pass sync sessions across instances etc etc if you use them. We have it setup none sticky so requests alernate between either node in the farm. so far so good, jb. On 7/8/05, Russ [EMAIL PROTECTED] wrote: Hi all, We are thinking of scaling our servers and are looking into load balancing. We have had load balancing done through a dedicated switch at one of the companies for a client earlier, but for various reasons we don't want to use them for this client. What are our options? Can we do load balacing through windows load balancing? Is it compatible with coldfusion or will people keep losing their sessions? I heard someone mention having ColdFusion pass requests over to another server when it gets busy, load balancing things that way. We're currently with crystaltech right now and as far as I know they don't support hardware load balancing. If none of the software solutions work out, we'll have to move vendors. Can someone recommend a reliable host that supports hardware load balancing? We only need something simple to start with (2 web servers, one db) Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211427 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Flash Forms Newbie Question
just use the label attribute in the cfselect to output Staff Member Claremont, Timothy wrote: I am using the following code on my very first Flash Form: cfform action=Submit.cfm method=POST format=Flash skin=haloBlue table width=66% border=1 tr td width=50% strongemStaff Member/em/strongbr /td td width=50% cfselect name=StaffMember size=1 message=You did not select a staff member! width=200 visible=Yes enabled=Yes required=Yes option value=Jane Doe selectedJane Doe/option /cfselect /td /tr /table input type=submit name=Submit value=Submitinput type=reset name=Reset value=Reset /cfform When I view the form, the drop drown box appears (even with only one item) but the text Staff Member does not show up, nor does the border of the table, etc. The ONLY thing that shows up is the drop down box. What am I doing wrong? TIA, Tim ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211428 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Coldfusion Switch Error - Hex Characters
Hello, I have an odd error with a piece of code I'm migrating from CF5 to MX6.1. It is a simple switch statement that takes Hex7 values as a string and spits out the ascii equivilent as a string. Problem is, it is reading hex value '00' and '0A' as the same thing, and returns a duplicate value error for 0.0. I've tried chr codes, changing it to IF statements, and more. I was hoping an expert could look at it and give me a hint to a fix. Below is a small snippet of the overall code. Thanks. cfscript function Hex7toStr(Char){ switch (Char) { case 00: newchar = NUL; break; case 0A: newchar = LF; break; case 30: newchar = 0; break; case 41: newchar = A; break; case EB: newchar = a; break; } return Trim(newchar); } /cfscript cfset hexChar1 = 00 cfset hexChar2 = 0A cfset hexChar3 = 30 cfset hexChar4 = 41 cfset hexChar5 = E1 CFSET hexStr1 = #Hex7toStr(hexChar1)# CFSET hexStr2 = #Hex7toStr(hexChar2)# CFSET hexStr3 = #Hex7toStr(hexChar3)# CFSET hexStr4 = #Hex7toStr(hexChar4)# CFSET hexStr5 = #Hex7toStr(hexChar5)# cfoutput table trtd#hexChar1#/tdtd#hexStr1#/td/tr trtd#hexChar2#/tdtd#hexStr2#/td/tr trtd#hexChar3#/tdtd#hexStr3#/td/tr trtd#hexChar4#/tdtd#hexStr4#/td/tr trtd#hexChar5#/tdtd#hexStr5#/td/tr /table /cfoutput ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211429 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: PreserveSingleQuotes Woes - Possible Bug?
Thanks for the prompt reply. I truncated my code a bit, consquently removing the cfquery. In this example, envision that the oringal example adhered to rule 1; however rule 2 is wee bit of a conundrum. The macromedia site states: ---Start clip--- http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functa53.htm#wp1110445 PreserveSingleQuotes(variable) ColdFusion MX: Changed behavior: ColdFusion automatically escapes simple-variable, array-variable, and structure-variable references within a cfquery tag body or block. (Earlier releases did not automatically escape array-variable references.) --End clip--- Yet, PreserveSingleQuotes only accepts a simple-variable, as per rule 2. Is there any explanation as to what MM means by automatically escapes simple-variable, array-variable, and structure-variable references? For example: cfset tes = testa[1] cfquery datasource=data name=wha Select * from datafeed Where ID = #preservesinglequotes(tes)# /cfquery is valid, but cfquery datasource=livedata name=wha Select * from datafeed Where ID = #preservesinglequotes(testa[1])# /cfquery is not. Is it just the way the function is written? Is this fixed in CF 7? --j All what it does it telling the CF precessor NOT to automatically escape single quotes while building an SQL expression, then: rule 1 = you cannot use Preservesinglequote () outside some CFQUERY construct, rule 2 = you cannot use as a parameter anything else than a variable. Preservesinglequote () is a weird object in CF and is NOT really a function. All what it does it telling the CF precessor NOT to automatically escape single quotes while building an SQL expression, then: rule 1 = you cannot use Preservesinglequote () outside some CFQUERY construct, rule 2 = you cannot use as a parameter anything else than a variable. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211430 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Forms Advice
Hi, my website has a series of pictures that make up a hike - a photo gallery essentially. The photo's themselves should have two attributes 1) caption and 2) an available bit. Typically there are from 10 to 100 photos per hike instance. My previous way of handling things was to loop over each picture and create a form for each. The user could then update the attributes of any picture which was good, but doing so caused the whole page to repost, which was bad. I am wondering what a better approach would be. I have identified a couple ways to go. 1) output a page (say 10 photos) into one form and let the user edit all the attributes of those photos as one action and then let them post once. I am unsure of how this would be best accomplished with Coldfusion. If this is a preferred approach does anyone have any pointers to info that would help me figure out how this would be done? 2) Use iframes one for each picture, containing an individual form and then let users edit pictures one off. If this would be preferred as above is there any info someone can point me to that would help me understand how this would best be done? 3) Maybe there is some alternate preferred way someone would like to share? Thanks much, John Interested in Hiking in Washington State? Check out http://www.attrition.ws ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211431 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Forms Advice
Couple other ideas: 1) make your page one large form, with field names like caption#imageId#, and then process them all when you submit. Going this route, I'd still probably page the gallery into batches of ten or so, just to make it more managable. 2) keep the per-image forms, but use JS Remoting to send the updates to the server asynchronously per-form. You still get your persistance, at a per-image level, but you don't have to deal with reloading the page. cheers, barneyb On 7/8/05, John Munyan [EMAIL PROTECTED] wrote: Hi, my website has a series of pictures that make up a hike - a photo gallery essentially. The photo's themselves should have two attributes 1) caption and 2) an available bit. Typically there are from 10 to 100 photos per hike instance. My previous way of handling things was to loop over each picture and create a form for each. The user could then update the attributes of any picture which was good, but doing so caused the whole page to repost, which was bad. I am wondering what a better approach would be. I have identified a couple ways to go. 1) output a page (say 10 photos) into one form and let the user edit all the attributes of those photos as one action and then let them post once. I am unsure of how this would be best accomplished with Coldfusion. If this is a preferred approach does anyone have any pointers to info that would help me figure out how this would be done? 2) Use iframes one for each picture, containing an individual form and then let users edit pictures one off. If this would be preferred as above is there any info someone can point me to that would help me understand how this would best be done? 3) Maybe there is some alternate preferred way someone would like to share? Thanks much, John Interested in Hiking in Washington State? Check out http://www.attrition.ws ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211432 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: SQL count of rows from a union query
I think it's light years better than the union query There is still a union, and if the subqueries generate a long list, it must be pretty unefficient. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211433 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: PreserveSingleQuotes Woes - Possible Bug?
Is it just the way the function is written? Is this fixed in CF 7? I don't know, are you sure your application is run by CFMX ? I still write applications compatible with CF 5, because I like to reuse my code anywhere, and I still have customers under CF 5, so I always use the first form in the samples you gave. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211434 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Data Binding on Forms
I have a form where the ultimate objective is to store the client number. So, I have a CFINPUT named txtClientNum and a CFSELECT named ClientNum Therefore, the data entry operator can enter EITHER the client number (into the CFINPUT) or choose the client name from a drop down list (CFSELECT). I want to make use of data binding so that if the client number is entered into the text box, the cfselect moves to the appropriate client name automatically. I can't seem to make the example in the WACK work for me. Can anyone give me an example of how to make this work? ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211435 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: load balancing
I ran a set of 4 Win 2k servers with CF 5 and Windows NLB. It's fine except for one thing If one CF instance crashes, port 80 on that server goes idle... The NLB load balancing is not application aware and therefore thinks that the idle server can stand some more load and so redirects all the incoming requests to that dead server... Port 80 is alive but CF has crashed and therefore doesn't respond. At this point, your entire site appears down because one server in your farm has gone down... :( I've seen this happen many times with CF5 and below. With CFMX 6 and above I have much more confidence that this is less likely to happen as CFMX is so much more stable than CF 5 ever was. That said, if you are looking to restart a CF server, its best to take it out of the load balancing group, restart it and then add it back in to the load balancer to make sure your site stays up for the duration... Paul ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211436 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: load balancing
Isn't there some way to configure the NLB to hit a page (a cf page) to test if the server is up? -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 1:21 PM To: CF-Talk Subject: RE: load balancing I ran a set of 4 Win 2k servers with CF 5 and Windows NLB. It's fine except for one thing If one CF instance crashes, port 80 on that server goes idle... The NLB load balancing is not application aware and therefore thinks that the idle server can stand some more load and so redirects all the incoming requests to that dead server... Port 80 is alive but CF has crashed and therefore doesn't respond. At this point, your entire site appears down because one server in your farm has gone down... :( I've seen this happen many times with CF5 and below. With CFMX 6 and above I have much more confidence that this is less likely to happen as CFMX is so much more stable than CF 5 ever was. That said, if you are looking to restart a CF server, its best to take it out of the load balancing group, restart it and then add it back in to the load balancer to make sure your site stays up for the duration... Paul ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211437 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: PreserveSingleQuotes Woes - Possible Bug?
I don't know, are you sure your application is run by CFMX ? Yes, I'm running CFMX 6.1. I still write applications compatible with CF 5, because I like to reuse my code anywhere, and I still have customers under CF 5, so I always use the first form in the samples you gave. I appreciate your help, and your rules were very straightforward. I ended up re-writing the code to work around this issue. For future reference, is there anyone else here who has experience with this function in CF7? --j ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211438 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: load balancing
John, What was your reason for not using client over j2ee session vars? -Adam On 7/8/05, John Beynon [EMAIL PROTECTED] wrote: We've recently gone live using Windows Load balancing on Windows 2003 Server and CFMX7 for out Intranet and about to go live with the same but CFMX7 Enterprise for our internet sites. It works just fine with CFMX - you're only load balancing port 80 at the end of the day. We're using client variables stored in cookies for maintaining state - yeah yeah I know client vars are the spawn of satan. CF Enterprise allows you to pass sync sessions across instances etc etc if you use them. We have it setup none sticky so requests alernate between either node in the farm. so far so good, jb. On 7/8/05, Russ [EMAIL PROTECTED] wrote: Hi all, We are thinking of scaling our servers and are looking into load balancing. We have had load balancing done through a dedicated switch at one of the companies for a client earlier, but for various reasons we don't want to use them for this client. What are our options? Can we do load balacing through windows load balancing? Is it compatible with coldfusion or will people keep losing their sessions? I heard someone mention having ColdFusion pass requests over to another server when it gets busy, load balancing things that way. We're currently with crystaltech right now and as far as I know they don't support hardware load balancing. If none of the software solutions work out, we'll have to move vendors. Can someone recommend a reliable host that supports hardware load balancing? We only need something simple to start with (2 web servers, one db) Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211439 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: SQL count of rows from a union query
Well, I'll be! It worked. This is the second time that this has happened to me where the absence of an alias has screwed things up. Thanks Joe! George On 7/8/05, Joe Rinehart [EMAIL PROTECTED] wrote: Hey George, AFAIK, derived tables in T-SQL need an alias...try this: SELECT count(*) FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) tblDerived (note the tblDerived as the alias) -Joe -- Get Glued! The Model-Glue ColdFusion Framework http://www.model-glue.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211440 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Parsing XML problem
How do you parse out this kind of XML string? I need to find the value of aAccountNumber and bAddress: Parameter ParameterNameaAccountNumber/ParameterName ParameterValueX/ParameterValue /Parameter Parameter ParameterNamebAddress/ParameterName ParameterValueX/ParameterValue /Parameter I suppose if I could depend on the order of the Parameters, I could refer to the values like so: Parameter[1].ParameterValue.xmlText Parameter[2].ParameterValue.xmlText Does that work or is there a better way? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211441 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Including App.cfc in App.cfc
On 7/8/05, S. Isaac Dealey [EMAIL PROTECTED] wrote: The Application.cfc in the nested directory will omit the Application.cfc code in the parent directory... this means that much of the code to set these variables would need to be duplicated in both cfc's. What I read (and I could be misinterpreting) is that he wanted a way to eliminate the need to duplicate that code. Why not make the Application.cfc in the subfolder inherit (extend) the Application.cfc in the root folder? This will eliminate duplication. Here is a quote from a CF technote about extending the ColdFusion MX 7 application framework: You can set/implement everything that applies to all your applications at the top level, and then inherit from it as many levels deep as you need to. If you need to override something in a lower level Application.cfc, you have that ability as well. Read the whole technote here: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=9ce734f4 -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211442 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Including App.cfc in App.cfc
I read that he wanted a way to insure that app-scope vars would exist at the right names across several separate folders. Or, you could do what Sean Corfield blogged about a while ago: /appProxy.cfc /Application.cfc extends=appProxy /admin/Application.cfc extends=appProxy That would, from a CFC development standpoint be EXACTLY the same as cfincluding Application.cfm, except for the fact that with CFCs and the extends attribute you can do things like calling super.onSessionEnd() in your onSessionEnd() method (which means your calling the parent's version from the child version...)(that was for others, Isaac, not you *g*) So you code appProxy.cfc as you normally would your Applicaiton.cfc and use it for the base class for your other Application.cfcs. And for that matter, if you REALLY wanted, you could write an application.cfc that looks like this: cfinclude template=/application.cfc / But that's pretty darned messy. HTH, J On 7/8/05, S. Isaac Dealey [EMAIL PROTECTED] wrote: The Application.cfc in the nested directory will omit the Application.cfc code in the parent directory... this means that much of the code to set these variables would need to be duplicated in both cfc's. What I read (and I could be misinterpreting) is that he wanted a way to eliminate the need to duplicate that code. Will... In your first application.cfc you're going to create application.dsn, right? Along with this.name http://this.name http://this.name, yes? So your second application.cfc is going to have this.namehttp://this.name http://this.nameas well, yes? And if it's the same string as the name in the first application.cfc, it's going to be looking at the same application space as the first one. So, in your first application.cfc you create application.dsn = mydsn... so long as they're running on the same server it's going to see the same values under the same names in the application scope. In other words you join the data in memory by the name specified in the space inside the cfcomponent tag and outside any of the cffunction tags... by giving them the same name you join them logically in the server's memory. It's effectively the exact same thing as cfincluding an Application.cfmfile, but different in implementation. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211443 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Application Planning
My only real beef with it is in regard to large application development. Once an application reaches a certain size, making changes can be a bit of a bear. In general though, I do like it and it is pretty solid. At the moment though, I'm curious to see what else is out there. Adalon, at face value, seems to be a pretty solid piece of software. But I'm currently awaiting an evaluation license to see if it offers any significant advantages over Fusebuilder. --Anne Damien McKenna wrote: I just got the e-mail too. As I mentioned in my earlier post, I've already been using Fusebuilder. I'm just wondering if there may be anything else out there that's better. What do you think is missing from FuseBuilder? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211444 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Application Planning
From: Anne Girardeau [mailto:[EMAIL PROTECTED] Adalon, at face value, seems to be a pretty solid piece of software. But I'm currently awaiting an evaluation license to see if it offers any significant advantages over Fusebuilder. Anne, Contact Andrew J. Ibbotson over at Synthis. His email is: [EMAIL PROTECTED] He is my contact there and has been very quick with eval keys and info, etc... Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211445 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Parsing XML problem
On 7/8/05, Rebecca Wells [EMAIL PROTECTED] wrote: How do you parse out this kind of XML string? I need to find the value of aAccountNumber and bAddress: Parameter ParameterNameaAccountNumber/ParameterName ParameterValueX/ParameterValue /Parameter Parameter ParameterNamebAddress/ParameterName ParameterValueX/ParameterValue /Parameter xPath to the rescue: cfxml variable=myDOM doc Parameter ParameterNameaAccountNumber/ParameterName ParameterValue12345/ParameterValue /Parameter Parameter ParameterNamebAddress/ParameterName ParameterValueUSA/ParameterValue /Parameter /doc /cfxml cfset accountNumber = xmlSearch(myDOM,doc/Parameter[./ParameterName='aAccountNumber']/ParameterValue) cfset address = xmlSearch(myDOM,doc/Parameter[./ParameterName='bAddress']/ParameterValue) cfoutput Account Number: #accountNumber[1].xmlText#br Address: #address[1].xmlText#br /cfoutput If you have multiple account number nodes, you would need to loop over the array accountNumber[]. Same applies to the array address[]. HTH -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211446 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Application Planning
Thanks! Actually I left a message on his voicemail earlier. Hopefully he'll get back to me before the end of the day. --Anne Michael T. Tangorre wrote: From: Anne Girardeau [mailto:[EMAIL PROTECTED] Adalon, at face value, seems to be a pretty solid piece of software. But I'm currently awaiting an evaluation license to see if it offers any significant advantages over Fusebuilder. Anne, Contact Andrew J. Ibbotson over at Synthis. His email is: [EMAIL PROTECTED] He is my contact there and has been very quick with eval keys and info, etc... Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211447 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: load balancing
Isn't there some way to configure the NLB to hit a page (a cf page) to test if the server is up? Nope :( The native CF5 Ent load balancing software had that facility but MS NLB doesn't It is the major drawback of the MS NLB implementation... Paul ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211448 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Application Planning
Good luck. I've been waiting since Tuesday. My guess is that the 4th has morphed into a vacation week at Synthis. I'm hoping to hear something Monday. On 7/8/05, Anne Girardeau [EMAIL PROTECTED] wrote: Thanks! Actually I left a message on his voicemail earlier. Hopefully he'll get back to me before the end of the day. --Anne Michael T. Tangorre wrote: From: Anne Girardeau [mailto:[EMAIL PROTECTED] Adalon, at face value, seems to be a pretty solid piece of software. But I'm currently awaiting an evaluation license to see if it offers any significant advantages over Fusebuilder. Anne, Contact Andrew J. Ibbotson over at Synthis. His email is: [EMAIL PROTECTED] He is my contact there and has been very quick with eval keys and info, etc... Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211449 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Including App.cfc in App.cfc
Yeah, I was pretty much giving a basic example, using a DSN variable. I'll just need it to simply be available throughout the site and its directories. Thanks guys! Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211450 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Application Planning
Lol, thanks for letting me know. I thought it seemed unusually difficult to get a hold of anyone there. --Anne Deanna Schneider wrote: Good luck. I've been waiting since Tuesday. My guess is that the 4th has morphed into a vacation week at Synthis. I'm hoping to hear something Monday. On 7/8/05, Anne Girardeau [EMAIL PROTECTED] wrote: Thanks! Actually I left a message on his voicemail earlier. Hopefully he'll get back to me before the end of the day. --Anne Michael T. Tangorre wrote: From: Anne Girardeau [mailto:[EMAIL PROTECTED] Adalon, at face value, seems to be a pretty solid piece of software. But I'm currently awaiting an evaluation license to see if it offers any significant advantages over Fusebuilder. Anne, Contact Andrew J. Ibbotson over at Synthis. His email is: [EMAIL PROTECTED] He is my contact there and has been very quick with eval keys and info, etc... Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211451 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Poor performing Oracle Query
What would be a good checklist to try and figure out why a query built by one of our Oracle DBAs runs in about 30 seconds when he runs it through the SQL+ tool in the Oracle development suite? But when that same query is placed in a cfquery tag set, it takes 18 minutes to run! -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211452 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Application Planning
I was wondering if most of the US took the week offlist is kinda quiet this week ;-) 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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211453 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Poor performing Oracle Query
Ian Skinner wrote: What would be a good checklist to try and figure out why a query built by one of our Oracle DBAs runs in about 30 seconds when he runs it through the SQL+ tool in the Oracle development suite? But when that same query is placed in a cfquery tag set, it takes 18 minutes to run! How many records does it return? Jochem ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211454 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Remote forms
I have a client who wants to provide their clients access to a parts finder using data from their site but not hosting it. So I guess it would need to be platform independent. Any recommendations? It's nothing too complicated, just a series of drill down menus of about 5 items (multiple-select: select first displays matching in second, select second and so on) My first thought was flash. Any other ideas? Thanks for any help. Doug ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211455 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Application Planning
W00t! I just got a call back from Andy Ibbotson. Apparently they're having a promotion right now and are offering Adalon for $750 per seat. --Anne Deanna Schneider wrote: Good luck. I've been waiting since Tuesday. My guess is that the 4th has morphed into a vacation week at Synthis. I'm hoping to hear something Monday. On 7/8/05, Anne Girardeau [EMAIL PROTECTED] wrote: Thanks! Actually I left a message on his voicemail earlier. Hopefully he'll get back to me before the end of the day. --Anne Michael T. Tangorre wrote: From: Anne Girardeau [mailto:[EMAIL PROTECTED] Adalon, at face value, seems to be a pretty solid piece of software. But I'm currently awaiting an evaluation license to see if it offers any significant advantages over Fusebuilder. Anne, Contact Andrew J. Ibbotson over at Synthis. His email is: [EMAIL PROTECTED] He is my contact there and has been very quick with eval keys and info, etc... Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211456 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Remote forms
AJAX. -Adam On 7/8/05, Doug Bedient [EMAIL PROTECTED] wrote: I have a client who wants to provide their clients access to a parts finder using data from their site but not hosting it. So I guess it would need to be platform independent. Any recommendations? It's nothing too complicated, just a series of drill down menus of about 5 items (multiple-select: select first displays matching in second, select second and so on) My first thought was flash. Any other ideas? Thanks for any help. Doug ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211457 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Remote forms
Okay. I've heard of it. Any good tutorials around? AJAX. -Adam On 7/8/05, Doug Bedient [EMAIL PROTECTED] wrote: I have a client who wants to provide their clients access to a parts finder using data from their site but not hosting it. So I guess it would need to be platform independent. Any recommendations? It's nothing too complicated, just a series of drill down menus of about 5 items (multiple-select: select first displays matching in second, select second and so on) My first thought was flash. Any other ideas? Thanks for any help. Doug ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211458 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Including App.cfc in App.cfc
In retrospect, Jared Eddie's suggestions are better for general consumption. :) Although I will say that for a new app, using the onTap framework makes the issue moot due to its nested directory execution. :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211459 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Poor performing Oracle Query
I'm told about 10, but those ten are summations of a lot of data from some very large (100,000's of records) tables. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 1:39 PM To: CF-Talk Subject: Re: Poor performing Oracle Query Ian Skinner wrote: What would be a good checklist to try and figure out why a query built by one of our Oracle DBAs runs in about 30 seconds when he runs it through the SQL+ tool in the Oracle development suite? But when that same query is placed in a cfquery tag set, it takes 18 minutes to run! How many records does it return? Jochem ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211460 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Poor performing Oracle Query
Does it run slow from SQLPlus when executed from the web server itself? For perhaps a quick fix I'd probably try throwing it into an SP and calling that to see if the delay in executing goes away. On 7/8/05, Ian Skinner [EMAIL PROTECTED] wrote: I'm told about 10, but those ten are summations of a lot of data from some very large (100,000's of records) tables. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org http://www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 1:39 PM To: CF-Talk Subject: Re: Poor performing Oracle Query Ian Skinner wrote: What would be a good checklist to try and figure out why a query built by one of our Oracle DBAs runs in about 30 seconds when he runs it through the SQL+ tool in the Oracle development suite? But when that same query is placed in a cfquery tag set, it takes 18 minutes to run! How many records does it return? Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211461 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Poor performing Oracle Query
We're working on the SP version to see if that help. No it does not take nearly as long to run in SQLPlus, about 20 seconds, versus 18 minutes when run from a CF page. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 2:50 PM To: CF-Talk Subject: Re: Poor performing Oracle Query Does it run slow from SQLPlus when executed from the web server itself? For perhaps a quick fix I'd probably try throwing it into an SP and calling that to see if the delay in executing goes away. On 7/8/05, Ian Skinner [EMAIL PROTECTED] wrote: I'm told about 10, but those ten are summations of a lot of data from some very large (100,000's of records) tables. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org http://www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 1:39 PM To: CF-Talk Subject: Re: Poor performing Oracle Query Ian Skinner wrote: What would be a good checklist to try and figure out why a query built by one of our Oracle DBAs runs in about 30 seconds when he runs it through the SQL+ tool in the Oracle development suite? But when that same query is placed in a cfquery tag set, it takes 18 minutes to run! How many records does it return? Jochem ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211462 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Calling Parent Page in IFRAME - Cross Domai
Neil, I have a problem where I have a page say on www.xyz.com , this page contains an iframe which has loaded a site www.abc.com. Is there anyway I can reference the parent page from the iframe (and from within the www.abc.com pages) without the Permission Denied error due to JS Security Restrictions? Is there anyway I can allow/trust the domain to allow me to cover it all? In IE you can use the document.domain to set up a trust between two pages: http://msdn.microsoft.com/workshop/author/dhtml/reference/properties/domain. asp However, it will not let you talk to two sites from two completely different suffixes. It allows abc.company.com to talk with xyz.company.com, but not abc.com to talk with xyz.com. About the only one I can think of to get around this would be to have site abc.com reference some URL on xyz.com and then have a hidden frame on xyz.com that looks to see if abc.com has sent any messages sent. You could use JS's Image() object to send a command back to XYZ and then have XYZ continually pole for some message. This would be very slow and inefficient though. - Dan ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211463 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Poor performing Oracle Query
Well we have more information on the problem. The query that was running fairly well at 30 seconds or so was being run against a validation database where the data is static. The query that was performing poorly at 18 minutes was being run against the production server where the data is very active. Apparently every time data was being added to the main tables, this query would be started over. So depending on the traffic sometime it performs relatively well other times it performs very poorly. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 1:39 PM To: CF-Talk Subject: Re: Poor performing Oracle Query Ian Skinner wrote: What would be a good checklist to try and figure out why a query built by one of our Oracle DBAs runs in about 30 seconds when he runs it through the SQL+ tool in the Oracle development suite? But when that same query is placed in a cfquery tag set, it takes 18 minutes to run! How many records does it return? Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211464 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
detect flash player 7 with CF?
Hi, Is there a way to detect flash Player 7 using CF? I want to use cfform, but so many of my customers don't have flash player 7 and don't have permissions to install them. So I want to detect if they have flash player 7. If they do, I would set format=flash. If they don't, I would set format=xml and skin equals to something else. Johnny ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211465 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Parsing XML problem
Thank you, Eddie. That helped me figure it out, but it turned out that I didn't need to use cfxml as I was already using xmlparse, but the rest of your code was spot on. Have a good weekend, if you haven't already started. On 7/8/05, Eddie Awad wrote: xPath to the rescue: cfxml variable=myDOM doc Parameter ParameterNameaAccountNumber/ParameterName ParameterValue12345/ParameterValue /Parameter Parameter ParameterNamebAddress/ParameterName ParameterValueUSA/ParameterValue /Parameter /doc /cfxml cfset accountNumber = xmlSearch(myDOM,doc/Parameter[./ParameterName='aAccountNumber']/ParameterValue) cfset address = xmlSearch(myDOM,doc/Parameter[./ParameterName='bAddress']/ParameterValue) cfoutput Account Number: #accountNumber[1].xmlText#br Address: #address[1].xmlText#br /cfoutput If you have multiple account number nodes, you would need to loop over the array accountNumber[]. Same applies to the array address[]. HTH -- Eddie Awad. http://awads.net/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211466 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
detect flash player 7 with CF?
Hi, Is there a way to detect flash Player 7 using CF? I want to use cfform, but so many of my customers don't have flash player 7 and don't have permissions to install them. So I want to detect if they have flash player 7. If they do, I would set format=flash. If they don't, I would set format=xml and skin equals to something else. Johnny ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211467 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: detect flash player 7 with CF?
As you worded it, no, you can't do that, but you can do it with other ways: Use javascript to set a cookie with the value (JS-based flash sniffing is cake; there's a million scripts around), and then you can check the value of the cookie with CF when you're rendering your forms. If you need failover for cookie-less users, have your JS instead use JS remoting to submit a simple GET request with the value to the server, and then store it in the session scope for the user. cheers, barneyb On 7/8/05, Johnny Le [EMAIL PROTECTED] wrote: Hi, Is there a way to detect flash Player 7 using CF? I want to use cfform, but so many of my customers don't have flash player 7 and don't have permissions to install them. So I want to detect if they have flash player 7. If they do, I would set format=flash. If they don't, I would set format=xml and skin equals to something else. Johnny -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211468 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Poor performing Oracle Query
The query that was performing poorly at 18 minutes was being run against the production server where the data is very active. Apparently every time data was being added to the main tables, this query would be started over. So depending on the traffic sometime it performs relatively well other times it performs very poorly. Sounds like some SQL tuning may be required here! Ya all have a good weekend ... -- Eddie Awad. http://awads.net/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211469 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Poor performing Oracle Query
Does oracle have something similar to with (nolock) that SQL server has? This would just run the query and not wait if it can get a lock on all the tables.. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 7:15 PM To: CF-Talk Subject: RE: Poor performing Oracle Query Well we have more information on the problem. The query that was running fairly well at 30 seconds or so was being run against a validation database where the data is static. The query that was performing poorly at 18 minutes was being run against the production server where the data is very active. Apparently every time data was being added to the main tables, this query would be started over. So depending on the traffic sometime it performs relatively well other times it performs very poorly. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning .-Original Message- .From: Jochem van Dieten [mailto:[EMAIL PROTECTED] .Sent: Friday, July 08, 2005 1:39 PM .To: CF-Talk .Subject: Re: Poor performing Oracle Query . .Ian Skinner wrote: . What would be a good checklist to try and figure out why a query built .by one of our Oracle DBAs runs in about 30 seconds when he runs it .through the SQL+ tool in the Oracle development suite? But when that .same query is placed in a cfquery tag set, it takes 18 minutes to run! . .How many records does it return? . .Jochem . . ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211470 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Parsing XML problem
Thank you, Eddie. That helped me figure it out, but it turned out that I didn't need to use cfxml as I was already using xmlparse, but the rest of your code was spot on. Have a good weekend, if you haven't already started. I used cfxml only to test my code. I'm glad it was helpful. Have a nice weekend. -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211471 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Poor performing Oracle Query
Does oracle have something similar to with (nolock) that SQL server has? This would just run the query and not wait if it can get a lock on all the tables.. In Oracle, If you're just selecting rows from tables, there should not be any locks issued on the rows unless you explicitly say for update of followed by a list of columns. -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211472 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cf mx exception error messages
Can anyone explain below why you get a SQL query error for a page that is possibly missing??? I am confused.Any help would be appreciated. Error,jrpp-260,07/06/05,12:18:04,,Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near ','. The specific sequence of files included or processed is: D:\sites\test\mission.cfm coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:495) at cfsecurity2ecfm950639948.runPage(D:\sites\test\admin\security.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfApplication2ecfm2106905353.runPage(D:\sites\test\Application.cfm:14) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:30) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:93) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Error,jrpp-268,07/06/05,13:06:25,,Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near ','. The specific sequence of files included or processed is: D:\sites\test\admin\logout.cfm coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:495) at cfsecurity2ecfm950639948.runPage(D:\sites\test\admin\security.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfApplication2ecfm2106905353.runPage(D:\sites\test\Application.cfm:14) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:30) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:93) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at
Re: load balancing
out of curisoity, are you using cfcharting at all? DK On 7/8/05, John Beynon [EMAIL PROTECTED] wrote: We've recently gone live using Windows Load balancing on Windows 2003 Server and CFMX7 for out Intranet and about to go live with the same but CFMX7 Enterprise for our internet sites. It works just fine with CFMX - you're only load balancing port 80 at the end of the day. We're using client variables stored in cookies for maintaining state - yeah yeah I know client vars are the spawn of satan. CF Enterprise allows you to pass sync sessions across instances etc etc if you use them. We have it setup none sticky so requests alernate between either node in the farm. so far so good, jb. On 7/8/05, Russ [EMAIL PROTECTED] wrote: Hi all, We are thinking of scaling our servers and are looking into load balancing. We have had load balancing done through a dedicated switch at one of the companies for a client earlier, but for various reasons we don't want to use them for this client. What are our options? Can we do load balacing through windows load balancing? Is it compatible with coldfusion or will people keep losing their sessions? I heard someone mention having ColdFusion pass requests over to another server when it gets busy, load balancing things that way. We're currently with crystaltech right now and as far as I know they don't support hardware load balancing. If none of the software solutions work out, we'll have to move vendors. Can someone recommend a reliable host that supports hardware load balancing? We only need something simple to start with (2 web servers, one db) Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211475 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cf mx exception error messages
Can anyone explain below why you get a SQL query error for a page that is possibly missing??? I am confused.Any help would be appreciated. Error,jrpp-260,07/06/05,12:18:04,,Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near ','. The specific sequence of files included or processed is: D:\sites\test\mission.cfm coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:495) at cfsecurity2ecfm950639948.runPage(D:\sites\test\admin\security.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfApplication2ecfm2106905353.runPage(D:\sites\test\Application.cfm:14) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:30) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:93) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Error,jrpp-268,07/06/05,13:06:25,,Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near ','. The specific sequence of files included or processed is: D:\sites\test\admin\logout.cfm coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:495) at cfsecurity2ecfm950639948.runPage(D:\sites\test\admin\security.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfApplication2ecfm2106905353.runPage(D:\sites\test\Application.cfm:14) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:30) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:93) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at
RE: cf mx exception error messages
What do you mean the page is missing? -Original Message- From: Dave Nixon [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 7:59 PM To: CF-Talk Subject: cf mx exception error messages Can anyone explain below why you get a SQL query error for a page that is possibly missing??? I am confused.Any help would be appreciated. Error,jrpp-260,07/06/05,12:18:04,,Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near ','. The specific sequence of files included or processed is: D:\sites\test\mission.cfm coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:495) at cfsecurity2ecfm950639948.runPage(D:\sites\test\admin\security.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfApplication2ecfm2106905353.runPage(D:\sites\test\Application.cfm:14) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:30) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:93) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Error,jrpp-268,07/06/05,13:06:25,,Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near ','. The specific sequence of files included or processed is: D:\sites\test\admin\logout.cfm coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:495) at cfsecurity2ecfm950639948.runPage(D:\sites\test\admin\security.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfApplication2ecfm2106905353.runPage(D:\sites\test\Application.cfm:14) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:30) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:93) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at
RE: Poor performing Oracle Query
There must be some way to tell oracle you want to read 'dirty' data. Are you using a cftransaction? Perhaps you need something like cftransaction isolation=READ_UNCOMMITTED? Russ -Original Message- From: Eddie Awad [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 7:41 PM To: CF-Talk Subject: Re: Poor performing Oracle Query Does oracle have something similar to with (nolock) that SQL server has? This would just run the query and not wait if it can get a lock on all the tables.. In Oracle, If you're just selecting rows from tables, there should not be any locks issued on the rows unless you explicitly say for update of followed by a list of columns. -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211477 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Including App.cfc in App.cfc
On 7/8/05, Jared Rypka-Hauer - CMG, LLC [EMAIL PROTECTED] wrote: Or, you could do what Sean Corfield blogged about a while ago: /appProxy.cfc /Application.cfc extends=appProxy /admin/Application.cfc extends=appProxy Almost... Check my blog: http://corfield.org/blog/index.cfm?do=blog.entryentry=C8AF0DA4-0E78-FC9E-6975A16624A1E3C1 /Application.cfc /AppProxy.cfc extends=Application /admin/Application.cfc extends=AppProxy And don't forget to call super() as appropriate in any methods you override (in admin.Application). -- Sean A Corfield -- http://corfield.org/ Team Fusebox -- http://fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211478 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Remote forms
Rob Rohan's Neuromancer is a great AJAX implementation that pre-existed the AJAX terminology (other than the cleaning product, anyway). He's got tutorials and examples here: http://www.robrohan.com/projects/neuromancer/ Hope that helps... J On 7/8/05, Doug Bedient [EMAIL PROTECTED] wrote: Okay. I've heard of it. Any good tutorials around? AJAX. -Adam On 7/8/05, Doug Bedient [EMAIL PROTECTED] wrote: I have a client who wants to provide their clients access to a parts finder using data from their site but not hosting it. So I guess it would need to be platform independent. Any recommendations? It's nothing too complicated, just a series of drill down menus of about 5 items (multiple-select: select first displays matching in second, select second and so on) My first thought was flash. Any other ideas? Thanks for any help. Doug ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211479 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Including App.cfc in App.cfc
I suppose, depending on the needs of the specific application you could go either way. If your Application.cfc's all inherited from a specific ApplicationProxy.cfcthen you could make global changes easily without being forced to change the Application.cfc in your root. But, if you have one Application.cfc that needs to be the parent of all of them, having your proxy inherit from it would also make sense. But since I was working from memory I'm glad I got close... and thanks for the correction. Laterz, J On 7/8/05, Sean Corfield [EMAIL PROTECTED] wrote: On 7/8/05, Jared Rypka-Hauer - CMG, LLC [EMAIL PROTECTED] wrote: Or, you could do what Sean Corfield blogged about a while ago: /appProxy.cfc /Application.cfc extends=appProxy /admin/Application.cfc extends=appProxy Almost... Check my blog: http://corfield.org/blog/index.cfm?do=blog.entryentry=C8AF0DA4-0E78-FC9E-6975A16624A1E3C1 /Application.cfc /AppProxy.cfc extends=Application /admin/Application.cfc extends=AppProxy And don't forget to call super() as appropriate in any methods you override (in admin.Application). -- Sean A Corfield -- http://corfield.org/ Team Fusebox -- http://fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211480 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Including App.cfc in App.cfc
I like the appProxy.cfc, but take a step further an put all those constants in an xml file that appProxy can parse. That way whoever is deploying your app or managing the server (even if its you) won't have to mess around with cf code. Then you can have seperate xml files for your different deployments but a single build or the application. -Adam On 7/8/05, Jared Rypka-Hauer - CMG, LLC [EMAIL PROTECTED] wrote: I suppose, depending on the needs of the specific application you could go either way. If your Application.cfc's all inherited from a specific ApplicationProxy.cfcthen you could make global changes easily without being forced to change the Application.cfc in your root. But, if you have one Application.cfc that needs to be the parent of all of them, having your proxy inherit from it would also make sense. But since I was working from memory I'm glad I got close... and thanks for the correction. Laterz, J On 7/8/05, Sean Corfield [EMAIL PROTECTED] wrote: On 7/8/05, Jared Rypka-Hauer - CMG, LLC [EMAIL PROTECTED] wrote: Or, you could do what Sean Corfield blogged about a while ago: /appProxy.cfc /Application.cfc extends=appProxy /admin/Application.cfc extends=appProxy Almost... Check my blog: http://corfield.org/blog/index.cfm?do=blog.entryentry=C8AF0DA4-0E78-FC9E-6975A16624A1E3C1 /Application.cfc /AppProxy.cfc extends=Application /admin/Application.cfc extends=AppProxy And don't forget to call super() as appropriate in any methods you override (in admin.Application). -- Sean A Corfield -- http://corfield.org/ Team Fusebox -- http://fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211481 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf mx exception error messages
What do you mean the page is missing? -Original Message- From: Dave Nixon [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 7:59 PM To: CF-Talk Subject: cf mx exception error messages Can anyone explain below why you get a SQL query error for a page that is possibly missing??? I am confused.Any help would be appreciated. Error,jrpp-260,07/06/05,12:18:04,,Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near ','. The specific sequence of files included or processed is: D:\sites\test\mission.cfm coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:495) at cfsecurity2ecfm950639948.runPage(D:\sites\test\admin\security.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfApplication2ecfm2106905353.runPage(D:\sites\test\Application.cfm:14) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:30) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:93) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Error,jrpp-268,07/06/05,13:06:25,,Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near ','. The specific sequence of files included or processed is: D:\sites\test\admin\logout.cfm coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:495) at cfsecurity2ecfm950639948.runPage(D:\sites\test\admin\security.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfApplication2ecfm2106905353.runPage(D:\sites\test\Application.cfm:14) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:30) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:93) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at
RE: cf mx exception error messages
I know that those pages are not there yet Thanks Dave What do you mean the page is missing? -Original Message- From: Dave Nixon [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 7:59 PM To: CF-Talk Subject: cf mx exception error messages Can anyone explain below why you get a SQL query error for a page that is possibly missing??? I am confused.Any help would be appreciated. Error,jrpp-260,07/06/05,12:18:04,,Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near ','. The specific sequence of files included or processed is: D:\sites\test\mission.cfm coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:495) at cfsecurity2ecfm950639948.runPage(D:\sites\test\admin\security.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfApplication2ecfm2106905353.runPage(D:\sites\test\Application.cfm:14) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:30) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:93) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Error,jrpp-268,07/06/05,13:06:25,,Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near ','. The specific sequence of files included or processed is: D:\sites\test\admin\logout.cfm coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:495) at cfsecurity2ecfm950639948.runPage(D:\sites\test\admin\security.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfApplication2ecfm2106905353.runPage(D:\sites\test\Application.cfm:14) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:30) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:93) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at
Re: cf mx exception error messages
CF sometimes gets a little weird with templates that once existed, but no longer exist. This is by design if you have the template cache enabled, but it can happen even with it off. Clear your cfclasses directory (inside WEB-INF) and restart and it'll probably go away. cheers, barneyb On 7/8/05, Dave Nixon [EMAIL PROTECTED] wrote: Can anyone explain below why you get a SQL query error for a page that is possibly missing??? I am confused.Any help would be appreciated. Error,jrpp-260,07/06/05,12:18:04,,Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near ','. The specific sequence of files included or processed is: D:\sites\test\mission.cfm coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:495) at cfsecurity2ecfm950639948.runPage(D:\sites\test\admin\security.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfApplication2ecfm2106905353.runPage(D:\sites\test\Application.cfm:14) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211484 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Including App.cfc in App.cfc
On 7/8/05, Adrocknaphobia [EMAIL PROTECTED] wrote: I like the appProxy.cfc, but take a step further an put all those constants in an xml file that appProxy can parse. Or use ColdSpring and have its bean factory manage the configuration based on XML files! -- Sean A Corfield -- http://corfield.org/ Team Fusebox -- http://fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211485 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Methods of contact
I was just curious how many times people end up getting contacted by recruiters via methods you never have given out. My specific question is based around a recruiter calling me at work about a job here in town. I know for a fact I have never given that phone number to a recruiter, I actually could count on one hand how many people/places outside of work I have given the number to. Did not dawn on me during the phone call to ask how they got it, did email the person though asking them but never got a response. -- Aaron Rouse http://www.happyhacker.com/ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:11:2727 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/11 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:11 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Methods of contact
Recruiters are [sometimes] slime. Have you had contact with this recruiter through other means, or was this his first contact w/ you? Apparently I must have given my work number out to some recruiters (Back when I worked for someone else). I was less smart then. After I left there, someone called up to ask for me. He no longer works here. Oh, can I speak to his replacement. In a big company, I doubt that would raise eyebrows. But, in the small company it did. The call got routed to the development head (AKA my ex-boss). The theory is, of course, that the person who replaced me probably has similar qualifications, and might be suitable for the job they are trying to fill. At 11:13 AM 7/8/2005, you wrote: I was just curious how many times people end up getting contacted by recruiters via methods you never have given out. My specific question is based around a recruiter calling me at work about a job here in town. I know for a fact I have never given that phone number to a recruiter, I actually could count on one hand how many people/places outside of work I have given the number to. Did not dawn on me during the phone call to ask how they got it, did email the person though asking them but never got a response. -- Aaron Rouse http://www.happyhacker.com/ -- Jeffry Houser, Software Developer, Writer, Songwriter, Recording Engineer AIM: Reboog711 | Phone: 1-203-379-0773 -- My Company: http://www.dot-com-it.com My Books: http://www.instantcoldfusion.com My Recording Studio: http://www.fcfstudios.com Connecticut Macromedia User Group: http://www.ctmug.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:11:2728 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/11 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:11 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Methods of contact
No, I did know his name though because saw an email fwd to our user group that was from him with a job description. My only guess is he got the number via calling around the company searching for either people by name or for people with specific skillsets. That is just the first time it has ever happened to me which catches me a little offguard but after talking to some people it appears to happen somewhat often. When I was younger I'd made the mistake of giving my home phone number out a lot of times for recruiters/jobs/etc. It actually got so bad over time I finally just had the number changed. I do not mind maybe contact attempts about things here in town but when I get contacts about jobs thousands of miles away it and from 7-10 people per job,it begins to get annoying. On 7/8/05, Jeffry Houser [EMAIL PROTECTED] wrote: Recruiters are [sometimes] slime. Have you had contact with this recruiter through other means, or was this his first contact w/ you? Apparently I must have given my work number out to some recruiters (Back when I worked for someone else). I was less smart then. After I left there, someone called up to ask for me. He no longer works here. Oh, can I speak to his replacement. In a big company, I doubt that would raise eyebrows. But, in the small company it did. The call got routed to the development head (AKA my ex-boss). The theory is, of course, that the person who replaced me probably has similar qualifications, and might be suitable for the job they are trying to fill. At 11:13 AM 7/8/2005, you wrote: I was just curious how many times people end up getting contacted by recruiters via methods you never have given out. My specific question is based around a recruiter calling me at work about a job here in town. I know for a fact I have never given that phone number to a recruiter, I actually could count on one hand how many people/places outside of work I have given the number to. Did not dawn on me during the phone call to ask how they got it, did email the person though asking them but never got a response. -- Aaron Rouse http://www.happyhacker.com/ -- Jeffry Houser, Software Developer, Writer, Songwriter, Recording Engineer AIM: Reboog711 | Phone: 1-203-379-0773 -- My Company: http://www.dot-com-it.com My Books: http://www.instantcoldfusion.com My Recording Studio: http://www.fcfstudios.com Connecticut Macromedia User Group: http://www.ctmug.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:11:2729 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/11 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:11 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Methods of contact
Another tactic sometimes used... just call your company's front desk and ask to be transferred. During one particular job hunt, way back when, I had posted my resume to a personal website. The resume included the name of my employer-at-the-time (a fairly large company). A recruiter called me one day by calling the front desk and asking to be transferred to me. Then he made his pitch. I don't think he ever had my direct number. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 12:01 PM To: CF-Jobs-Talk Subject: Re: Methods of contact Recruiters are [sometimes] slime. Have you had contact with this recruiter through other means, or was this his first contact w/ you? Apparently I must have given my work number out to some recruiters (Back when I worked for someone else). I was less smart then. After I left there, someone called up to ask for me. He no longer works here. Oh, can I speak to his replacement. In a big company, I doubt that would raise eyebrows. But, in the small company it did. The call got routed to the development head (AKA my ex-boss). The theory is, of course, that the person who replaced me probably has similar qualifications, and might be suitable for the job they are trying to fill. At 11:13 AM 7/8/2005, you wrote: I was just curious how many times people end up getting contacted by recruiters via methods you never have given out. My specific question is based around a recruiter calling me at work about a job here in town. I know for a fact I have never given that phone number to a recruiter, I actually could count on one hand how many people/places outside of work I have given the number to. Did not dawn on me during the phone call to ask how they got it, did email the person though asking them but never got a response. -- Aaron Rouse http://www.happyhacker.com/ -- Jeffry Houser, Software Developer, Writer, Songwriter, Recording Engineer AIM: Reboog711 | Phone: 1-203-379-0773 -- My Company: http://www.dot-com-it.com My Books: http://www.instantcoldfusion.com My Recording Studio: http://www.fcfstudios.com Connecticut Macromedia User Group: http://www.ctmug.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:11:2730 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/11 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:11 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Methods of contact
A good way to deal with this, is provide a number you want to be used for such things; rather than not giving out anything. I give out my cell number, and keep it off in the mornings so I can get some real work done. I just let messages stack all morning, and get back to everyone right after lunch. I don't like using company resources for personal matters, anyway. Recruiters generally understand this concept. Louis Mezo LogicSynthesis Tel: 240.498.8951 [EMAIL PROTECTED] http://www.logicsynthesis.com -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 11:13 AM To: CF-Jobs-Talk Subject: Methods of contact I was just curious how many times people end up getting contacted by recruiters via methods you never have given out. My specific question is based around a recruiter calling me at work about a job here in town. I know for a fact I have never given that phone number to a recruiter, I actually could count on one hand how many people/places outside of work I have given the number to. Did not dawn on me during the phone call to ask how they got it, did email the person though asking them but never got a response. -- Aaron Rouse http://www.happyhacker.com/ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:11:2731 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/11 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:11 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Methods of contact
Actually that is what I do more or less. I only provide my cell phone and usually chances are I will only answer it during the day if I know the number. I actually have had someone try calling me everyday this week from some long distance number and they never bother to leave a message pretty much assuming that is a recruiter. On 7/8/05, Louis Mezo [EMAIL PROTECTED] wrote: A good way to deal with this, is provide a number you want to be used for such things; rather than not giving out anything. I give out my cell number, and keep it off in the mornings so I can get some real work done. I just let messages stack all morning, and get back to everyone right after lunch. I don't like using company resources for personal matters, anyway. Recruiters generally understand this concept. Louis Mezo LogicSynthesis Tel: 240.498.8951 [EMAIL PROTECTED] http://www.logicsynthesis.com -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 11:13 AM To: CF-Jobs-Talk Subject: Methods of contact I was just curious how many times people end up getting contacted by recruiters via methods you never have given out. My specific question is based around a recruiter calling me at work about a job here in town. I know for a fact I have never given that phone number to a recruiter, I actually could count on one hand how many people/places outside of work I have given the number to. Did not dawn on me during the phone call to ask how they got it, did email the person though asking them but never got a response. -- Aaron Rouse http://www.happyhacker.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:11:2732 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/11 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:11 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11 Donations Support: http://www.houseoffusion.com/tiny.cfm/54