Re: Port 51011
Try CacheBox http://wiki.coldbox.org/wiki/CacheBox.cfm On Tue, Aug 14, 2012 at 1:29 PM, Steve LaBadie slaba...@po-box.esu.eduwrote: Cameron, the libraries are coming from Google. Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edu -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Tuesday, August 14, 2012 1:02 PM To: cf-talk Subject: Re: Port 51011 On Tue, Aug 14, 2012 at 12:49 PM, Steve LaBadie slaba...@po-box.esu.eduwrote: We deployed a new website several weeks ago. The average number of jqueries served before July-19 was ~2000 a day; now we are serving ~45,000. 10x more traffic? Yeah that will hit you where it hurts for sure. The first advise I would give is to look at changing you code to use the Google hosted version of these libraries: http://encosia.com/3-reasons-why-you-should-let-google-host-jquery-for-y ou/ Also, the rich format of the new website is taxing the ColdFusion engine. Yes, 10x traffic will do that. :) When the website seems to stop, the number of connections to CF's port 51011 increase from about 5 (average normal) to about 500. This smells like CF is getting hung and IIS continues to send it requests. This leads to a dogpile effect on CF where it's still receiving new requests from IIS but can no longer respond. This is usually due to a problem with something getting hung up in your CF code, or with SQL. For example, a SQL call that never comes back from the database, or some CFHTTP calls that never hear back from their servers, or a CFLOCK tag that's in a deadlock. If this is in fact the problem - the best way to troubleshoot this is install something like FusionReactor on the server and get a stack trace while the error is occurring. This will quite literally give you the exact line of ColdFusion code causing the problem. I'd bet a dollar that it's one of the three things I mentioned above. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352155 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
simple RegEx?
This should be simple for all you RegEx Gurus. I have a textarea field that may contain list numbers such as : (i) (ii). What I want to do is convert those to LI statements. I know you have to escape the parathesis but it produces: LIi) and LIii) How can I change it just to an LI statement (regardless on the list number, since it can be i, ii, iii, iv) I tried: rereplace(myTextField,'\(*\)','ALL') TIA! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321211 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: Form Fields
easy: cfquery name=qData blah blah/cfquery select name=selList size=1 cfoutput query=qDataoption value=#qData.someFieldName1##qData.someFIeldName2#/option /select Or cfselect name = employeeid size = 15 required = Yes message = Select one of these query = qData display =someFieldName2 value =someFieldName1 /cfselect Might want to look through the CF Docs. http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=splash.html CFSelect Tag: http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_r-s_14.html From: Pranathi Reddy rk.prana...@gmail.com Sent: Wednesday, March 04, 2009 9:25 PM To: cf-talk cf-talk@houseoffusion.com Subject: Form Fields Hi All, I have an issue and my brain is not working Actually I am trying to pull the data back to the formfield from sql database when there is a selection in dropdownlist. I am really not sure of how I could realy implement it. Any Help??? Thanks, Pranathi ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320128 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: CF / Javascript question
Why not place a checkbox on the page (after the textarea) indicating: [ ] I have read the prescribed text. If the box is checked, fire off a JS to enable the Continue button, else keep it disabled. Just a thought! From: Jenny Gavin-Wear jenn...@fasttrackonline.co.uk Sent: Wednesday, December 17, 2008 6:54 AM To: cf-talk cf-talk@houseoffusion.com Subject: CF / Javascript question Hi all, In a registration procedure, I need to do a verification that the person registering has read a large piece of text. The way I thought about doing is is with a scrolling div area which enables a continue to next page option when the user has scrolled to the bottom of the text. How could I best go about this using CF and/or javascript, please? Grateful for any ideas ... Jenny ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316865 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam and LIKE operator error
It is as Dave suggested, you can not use CFQUERYPARAM as part of the actual SQL query. You are writting the WHERE clause as a variable, remove the queryparam from that since you are declaring the variable. From: JediHomer jediho...@gmail.com Sent: Wednesday, December 17, 2008 3:17 AM To: cf-talk cf-talk@houseoffusion.com Subject: Re: cfqueryparam and LIKE operator error Try wrapping the QueryParams... i.e. Change (P.product_code LIKE value=%tents%) to (P.product_code LIKE (value=%tents%)) HTH 2008/12/16 Mike Little : hi guys, getting an error using the following syntax... WHERE ((P.product_code LIKE ) OR (PD.product_title LIKE ) OR (PD.product_description LIKE )) the error i get is... You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') OR (PD.product_title ' at line 9 this was working fine till i added the cfqueryparams. mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Job Market
I hope neither of you are making that a stereotype. I have 10 years as a CF developer, and EVERYTHING I do is OO, and I have a fundamental understanding of it, and use the usual OO frameworks like Mach-ii, ColdSpring, and Transfer (although I have developed OO apps without a front controller, too), and even built my own (closed, sorry) framework to solve specialized problems that the standard frameworks didn't. I have architected high-traffic, high-volume and high-revenue enterprise applications. Would you see 10 years on my resume and throw it out? I hope not. I didn't post this looking for work, as I have a fulltime job (parttime freelance OK). I just wanted to respond to this thread. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4113 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: Why won't this query run in MySQL 5?
Try the following: (I think MySQL 5 uses the ( ) within the inner join statements when using multiple conditions ) ** I could be wrong but can't hurt to try CFQUERY Name=Get_Client Datasource=#DSN# Select C.*, FG.*, E.* fromclients C inner join family_groups FG, employers E on ( C.Family_ID = FG.Family_ID and C.Employer_ID = E.Employer_ID ) where C.Family_ID = (Select Family_ID from clients where Client_ID = '#Session.Client_ID#') and C.Employer_ID = (Select Employer_ID from clients where Client_ID = '#Session.Client_ID#') and C.Client_ID = '#URL.Client_ID#' /CFQUERY On Mon, Sep 8, 2008 at 8:26 AM, Will Tomlinson [EMAIL PROTECTED] wrote: Hi, all... I've just moved a website from a server running MySQL 4.1 to a server running MySQL 5 and now this query is giving me problems. I think the problem is in your uppercase CFQUERY tags. Heehhehe...:) Seriously though, I've encountered the same kind of problems between MySQL versions. Sorry I can't help with your syntax problem. Just letting you know this isn't uncommon. Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312171 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfinvoke webservice
are you sure the method that you are calling exists in the CFC file? On 8/25/08, Bosky, Dave [EMAIL PROTECTED] wrote: Trying to invoke a webservice using CF but it keeps failing due to some error. Is there a common problem related to this error msg? Cannot perform web service invocation myMethodName. The fault returned when invoking the web service operation is: AxisFault faultCode: {http://xml.apache.org/axis/}HTTP faultSubcode: faultString: (500)Internal Server Error faultActor: faultNode: faultDetail: {}:return code: 500 Thanks, Dave ** HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ** ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311496 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) Stupid HTML Question
Okay, I must be having a brain fart today - I'm trying to get a cell in a table to NOT wrap. I actually want the text that doesn't fit to be hidden. What am I missing? (btw, I'm coding only for IE for an internal app). I've done this before, just can't remember what I did. I want the second cell to NOT wrap. Here's some test code: table border=1 cellspacing=0 cellpadding=0 width=150 style=table-layout: fixed; col width=50/ col width=50/ col width=50/ tr tdnbsp;/td tdTest Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test /td tdnbsp;/td /tr /table What am I missing? Dave Phillips ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309507 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) Stupid HTML Question
Wim, This didn't work for me. I still get the following: http://www.zarts.com/test.cfm Dave -Original Message- From: Wim Lemmens [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2008 8:04 AM To: CF-Talk Subject: Re: (ot) Stupid HTML Question td style=width: 100px; overflow: hidden; nowrapTest Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test /td On Wed, Jul 23, 2008 at 3:00 PM, Experienced CF Developer [EMAIL PROTECTED] wrote: Okay, I must be having a brain fart today - I'm trying to get a cell in a table to NOT wrap. I actually want the text that doesn't fit to be hidden. What am I missing? (btw, I'm coding only for IE for an internal app). I've done this before, just can't remember what I did. I want the second cell to NOT wrap. Here's some test code: table border=1 cellspacing=0 cellpadding=0 width=150 style=table-layout: fixed; col width=50/ col width=50/ col width=50/ tr tdnbsp;/td tdTest Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test /td tdnbsp;/td /tr /table What am I missing? Dave Phillips ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309513 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) Stupid HTML Question
This did exactly what I want. Thanks! That's not how I did it before because I didn't even know about this tag. LOL. But hey, I'm not complaining. :) Thanks! Dave -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2008 8:13 AM To: CF-Talk Subject: RE: (ot) Stupid HTML Question You could also wrap the contents in the nobrwill not wrap/nobr tag. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . -Original Message- From: Experienced CF Developer [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2008 9:00 AM To: CF-Talk Subject: (ot) Stupid HTML Question Okay, I must be having a brain fart today - I'm trying to get a cell in a table to NOT wrap. I actually want the text that doesn't fit to be hidden. What am I missing? (btw, I'm coding only for IE for an internal app). I've done this before, just can't remember what I did. I want the second cell to NOT wrap. Here's some test code: Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309507 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=28801.20441.4 __ NOD32 3290 (20080723) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309514 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) Stupid HTML Question
Wim, The nobr tag did what I wanted. The code below did not work as you would think it should (I had already tried those options myself). If you look at the page at http://www.zarts.com/test.cfm you will see the code you gave me below but you will also see that the cell still wraps. Thanks though! Dave -Original Message- From: Wim Lemmens [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2008 8:52 AM To: CF-Talk Subject: Re: (ot) Stupid HTML Question That's what you wanted, no? You say I actually want the text that doesn't fit to be hidden. That's what you get. Please explain correctly what you want. Wim. On Wed, Jul 23, 2008 at 3:49 PM, Experienced CF Developer [EMAIL PROTECTED] wrote: Wim, This didn't work for me. I still get the following: http://www.zarts.com/test.cfm Dave -Original Message- From: Wim Lemmens [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2008 8:04 AM To: CF-Talk Subject: Re: (ot) Stupid HTML Question td style=width: 100px; overflow: hidden; nowrapTest Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test /td On Wed, Jul 23, 2008 at 3:00 PM, Experienced CF Developer [EMAIL PROTECTED] wrote: Okay, I must be having a brain fart today - I'm trying to get a cell in a table to NOT wrap. I actually want the text that doesn't fit to be hidden. What am I missing? (btw, I'm coding only for IE for an internal app). I've done this before, just can't remember what I did. I want the second cell to NOT wrap. Here's some test code: table border=1 cellspacing=0 cellpadding=0 width=150 style=table-layout: fixed; col width=50/ col width=50/ col width=50/ tr tdnbsp;/td tdTest Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test /td tdnbsp;/td /tr /table What am I missing? Dave Phillips ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309517 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) Stupid HTML Question
Ah, that's it. I'm only developing for IE for an internal app. Dave -Original Message- From: Wim Lemmens [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2008 9:00 AM To: CF-Talk Subject: Re: (ot) Stupid HTML Question I only checked in FireFox. There it works correctly. IE messes it up... On Wed, Jul 23, 2008 at 3:56 PM, Experienced CF Developer [EMAIL PROTECTED] wrote: Wim, The nobr tag did what I wanted. The code below did not work as you would think it should (I had already tried those options myself). If you look at the page at http://www.zarts.com/test.cfm you will see the code you gave me below but you will also see that the cell still wraps. Thanks though! Dave -Original Message- From: Wim Lemmens [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2008 8:52 AM To: CF-Talk Subject: Re: (ot) Stupid HTML Question That's what you wanted, no? You say I actually want the text that doesn't fit to be hidden. That's what you get. Please explain correctly what you want. Wim. On Wed, Jul 23, 2008 at 3:49 PM, Experienced CF Developer [EMAIL PROTECTED] wrote: Wim, This didn't work for me. I still get the following: http://www.zarts.com/test.cfm Dave -Original Message- From: Wim Lemmens [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2008 8:04 AM To: CF-Talk Subject: Re: (ot) Stupid HTML Question td style=width: 100px; overflow: hidden; nowrapTest Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test /td On Wed, Jul 23, 2008 at 3:00 PM, Experienced CF Developer [EMAIL PROTECTED] wrote: Okay, I must be having a brain fart today - I'm trying to get a cell in a table to NOT wrap. I actually want the text that doesn't fit to be hidden. What am I missing? (btw, I'm coding only for IE for an internal app). I've done this before, just can't remember what I did. I want the second cell to NOT wrap. Here's some test code: table border=1 cellspacing=0 cellpadding=0 width=150 style=table-layout: fixed; col width=50/ col width=50/ col width=50/ tr tdnbsp;/td tdTest Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test /td tdnbsp;/td /tr /table What am I missing? Dave Phillips ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309521 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Consuming a Web Service with CF8
Steve, Try hitting it with CFHTTP and see what you get: cfhttp url=https://devurl.asmx?method=ZNAPing;/cfhttp cfdump var=#cfhttp# See what you get. Maybe it's not written as a 'real' web service and simply just returns xml? Dave -Original Message- From: Steve Sequenzia [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2008 1:41 PM To: CF-Talk Subject: Consuming a Web Service with CF8 Just to get this out of the way. I am pretty much brand new to web services so please excuse my lack of knowledge. I have been working on a real small web app that allows the customer to input an invoice then it kicks out a csv of the invoices. My problem is that the vendor just added an additional step that requires that I check the invoice against a web service that will tell me if it is valid. The vendor gave me a basic document that lays out the web services. There are 2 web services one is just a ping and the other actually checks the invoice. I cannot get either of them to work and I am not sure why. Here is the info for the ping web service that they sent: ZNAPing Purpose:This web service was created to give an external customer an opportunity to verify availability of the ZNA Claims Web Services before calling in with actual request. Signature:string ZNAPing( void ); Input:NONE Result:string. Note:Successful return will contain an XML fragment with the following information ZNAPingResult timeStamp9/24/2004 8:24:58 AM/timeStamp Version0.61/Version /ZNAPingResult Client can parse this string to extract some information - timeStamp element contains date and time of the call, Version element ââ¬â contains the version of the web services. I have been trying to consume it using cfinvoke like this: cfinvoke webservice = https://devurl.asmx; method = ZNAPing returnVariable = getBack username=username password=password cfoutput#getBack#/cfoutput I am getting this error when I run it: Unable to parse WSDL as an XML document. Parsing error: Fatal Error: URI=null Line=69: The element type p must be terminated by the matching end-tag Again, I am very new to web services so I am sure I am doing something wrong. If anyone could help point me in the right direction that would be very helpful. Thanks in advance for any help. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309540 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DataSource Events like Before Commit?
Joseph, I don't think what you are trying to do is possible. Can you give us some more details of what you are trying to accomplish to see if we can help you come up with an alternative solution? Sincerely, Dave Phillips -Original Message- From: Joseph Bugeja [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2008 4:50 AM To: CF-Talk Subject: DataSource Events like Before Commit? Dear ColdFusion Users, Is there a way that I can attach to a datasource through an event like before_commit or before_update? So, if I have a cfquery tag, and I would ColdFusion to automatically, before ColdFusion executes the code found in the cfquery I would like it to automatically execute another query for example to set the user id to the database? In this way I do not need to make any modification to the existing code except that of creating new code to do something before executing my main query? Thanks in advance for your assistance. Regards, Joseph. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309432 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DataSource Events like Before Commit?
Joseph, I think Gert's suggestion earlier could work for you. You could design a trigger to fire the stored procedure prior to any Inserts or Updates. Check out this page on oracle site for some direction: http://tinyurl.com/5sjhlg I haven't done anything with triggers myself. But if you want to avoid re-coding your CFML, I think this is your route to go. Of course, this will only work for you if the only thing changing your tables is your CF app. Any manual changes to the database, or any other application accessing the same database would fire the triggers as well, unless you can figure out a way to make them fire only when your app accesses the database. Hope this helps, Dave Phillips -Original Message- From: Joseph Bugeja [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2008 6:51 AM To: CF-Talk Subject: Re: DataSource Events like Before Commit? Thanks for your reply. Let me explain our scenario. We have a number of cfquery tags that insert, update and delete data from our Oracle database. Basically, before each query is run I need to execute a stored procedure. This stored procedure sets the userid (the user currently logged in) in the database for auditing purposes. We have hundreds of queries and it is not good from a design perspective to rewrite each query to call the same central piece of code before each query gets executed. So my original query should be: Original Query: cfquery DML Operation /cfquery New requirement should be: cftransaction cfstoredproc Set the user id /cfstoredproc cfquery DML Operation /cfquery /cftransaction As shown above, I need to call the cfstoredproc before each query is executed. Personally, I would prefer if I keep my original design and before the original query is run the ColdFusion engine automatically injects the new call in a transaction to set the clientid. Do you have any suggestions? Joseph, I don't think what you are trying to do is possible. Can you give us some more details of what you are trying to accomplish to see if we can help you come up with an alternative solution? Sincerely, Dave Phillips Dear ColdFusion Users, Is there a way that I can attach to a datasource through an event like before_commit or before_update? So, if I have a cfquery tag, and I would ColdFusion to automatically, before ColdFusion executes the code found in the cfquery I would like it to automatically execute another query for example to set the user id to the database? In this way I do not need to make any modification to the existing code except that of creating new code to do something before executing my main query? Thanks in advance for your assistance. Regards, Joseph. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309439 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: DataSource Events like Before Commit?
Got it. Now I understand better. You want to pass the userid of your 'logged in user' to track the change in the database instead of using the user id that the datasource is logged in as. I don't see any way for you to do this without changing your code. Maybe someone else can come up with something, but I just don't see any way around it. Whether you change it to implement the idea you had below or do it some other way, bottom line is, you will need to change your code to make Oracle aware of each individual user's ID. You might still be able to find a way to use the triggers, but I still think you'll need a code change. Sorry, no help. Dave -Original Message- From: Joseph Bugeja [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2008 7:28 AM To: CF-Talk Subject: Re: DataSource Events like Before Commit? Thanks again for your reply. Unfortunately, I need to pass the userid prior to executing each query as otherwise the auditing function would not know the userid. We have triggers on tables but triggers need the read the userid apriori. ColdFusion does not allow us to build our connection string dynamically or to dynamically inject connection string variables (such as the userid), as is the case with VB.NET and C#. This is why I am looking for an alternative. Joseph, I think Gert's suggestion earlier could work for you. You could design a trigger to fire the stored procedure prior to any Inserts or Updates. Check out this page on oracle site for some direction: http://tinyurl.com/5sjhlg I haven't done anything with triggers myself. But if you want to avoid re-coding your CFML, I think this is your route to go. Of course, this will only work for you if the only thing changing your tables is your CF app. Any manual changes to the database, or any other application accessing the same database would fire the triggers as well, unless you can figure out a way to make them fire only when your app accesses the database. Hope this helps, Dave Phillips Thanks for your reply. Let me explain our scenario. We have a number of cfquery tags that insert, update and delete data from our Oracle database. Basically, before each query is run I need to execute a stored procedure. This stored procedure sets the userid (the user currently logged in) in the database for auditing purposes. We have hundreds of queries and it is not good from a design perspective to rewrite each query to call the same central piece of code before each query gets executed. So my original query should be: Original Query: cfquery DML Operation /cfquery New requirement should be: cftransaction cfstoredproc Set the user id /cfstoredproc cfquery DML Operation /cfquery /cftransaction As shown above, I need to call the cfstoredproc before each query is executed. Personally, I would prefer if I keep my original design and before the original query is run the ColdFusion engine automatically injects the new call in a transaction to set the clientid. Do you have any suggestions? before ColdFusion executes the code found in the cfquery I would like it to automatically execute another query for example to set the user id to the database? In this way I do not need to make any modification to the existing code except that of creating new code to do something before executing my main query? Thanks in advance for your assistance. Regards, Joseph. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309445 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: DataSource Events like Before Commit?
Joseph, I did some googling and found that Oracle has 'proxy user authentication'. See this Ask Tom article (someone wanting to do the same thing as you are, but in java): http://tinyurl.com/6qe8xk Although I don't know if you can do it with the ColdFusion setup directly, but maybe you can access some underlying java component to do it. Hopefully this might give you another alternative. Let me know how it turns out. Dave -Original Message- From: Joseph Bugeja [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2008 7:57 AM To: CF-Talk Subject: Re: DataSource Events like Before Commit? Exactly! You perfectly understood my concern. If ColdFusion supported dynamic connection parameter injection or proxy authentication then we can identify the connection pool users but there is no straightforward solution to this. Through pooling we are connected through one db user which for security complaince (PCI) we need to remove this hole while keeping the benefits of pooling. Triggers can help certainly help us for auditing but again at db level I do not want have the same user showing up in my logs. Got it. Now I understand better. You want to pass the userid of your 'logged in user' to track the change in the database instead of using the user id that the datasource is logged in as. I don't see any way for you to do this without changing your code. Maybe someone else can come up with something, but I just don't see any way around it. Whether you change it to implement the idea you had below or do it some other way, bottom line is, you will need to change your code to make Oracle aware of each individual user's ID. You might still be able to find a way to use the triggers, but I still think you'll need a code change. Sorry, no help. Dave Thanks again for your reply. Unfortunately, I need to pass the userid prior to executing each query as otherwise the auditing function would not know the userid. We have triggers on tables but triggers need the read the userid apriori. ColdFusion does not allow us to build our connection string dynamically or to dynamically inject connection string variables (such as the userid), as is the case with VB.NET and C#. This is why I am looking for an alternative. Joseph, I think Gert's suggestion earlier could work for you. You could design a trigger to fire the stored procedure prior to any Inserts or Updates. Check a before ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309453 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) URL Hack Attempt Leaves Me Scractching My Head... For Mark Kruger
Okay, stupidly, I clicked on rent.com (? Used to avoid perpetuation) to see what Brian was talking about and now I see the reference to a .js file on one of the pages. I didn't just infect my pc with something, did I? I surely hope that we are not perpetuating some virus with these e-mails. Also, Brian, IMHO, I think your comment would have been more appropriate to make off-list. Sincerely, Dave Phillips ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309469 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: ('1,1') * 1 = 39448
Looked like it could be a ColdFusion date value to me. So I did a dateFormat() on that and came up with 01/01/2008: cfset nValue = 1,1 * 1 cfoutput#dateFormat(nValue,mm/dd/)#brbr/cfoutput It's assuming 1,1 is the current month and year. I did the same for 5,23 * 1 and got 05/23/2008. What's really fun is if you do 1,1 * 2.. Go ahead... see what you get. 10/15/2116 Now go figure THAT one out! Dave Phillips -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2008 5:08 PM To: CF-Talk Subject: ('1,1') * 1 = 39448 I tracked down a defect to a piece of code which basically did the following: total = form.quantity * form.itemamount In some cases, form.quantity is commong through as *1,1* which is presumably due to an HTML issue with duplicate form fields with the same name. But rather than getting a CF error cos 1,1 isn't a number, it evaluates to 39448! i.e. cfoutput'1,1' * 1 = #'1,1' * 1#/cfoutput produces: '1,1' * 1 = 39448 I'm not worried about the original problem with the form.quantity coming though as *1,1* rather than the expected *1* since I can fix that, but i'm curious as to any reason for this odd result. It looks like (x,y) * 1 is the same as (y,x) * 1 In other words cfoutput#'5,23' * 1# = #'23,5' * 1# = 39591/cfoutput As i say, i'm not worried about fixing the defect, but i'm just curious if there is an underlying explanation for the apparently wierd behaviour. Or is it just a bug in the way CF does the conversion? Cheers Bert p.s. FWIW here's a snippet which will create a 101 square grid of all the combinations: table border=1 cfloop from=0 to=100 index=i tr cfloop from=0 to=100 index=j td nowrap=true#wtf(i,j)#/td /cfloop /tr /cfloop /table cfscript function wtf(a,b) { var x = '#a#,#b#'; try { return '#x#*1 = ' x*1; } catch(Any E) { return '#x#*1 pukes'; } } /cfscript ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309490 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Mystery Character
Robert, Can't see the character, but check out http://www.asciitable.com and see if you can find it there. Dave -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 3:17 PM To: CF-Talk Subject: Mystery Character Does anyone know the character code for this character: . My Mac users are uploading files with this character and it does not work in a URL string... I'd kill it but I don't know what character it is. Using . in a regex replace does not work. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309392 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Mystery Character
Doesn't asc('x') do that? Or am I missing something? Dave -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 3:53 PM To: CF-Talk Subject: RE: Mystery Character I've ran into things like this before. Is there a CF function (or even a way in Java) to take a character and return the ASCII code for it? (Or whatever is appropriate, I don't know if ASCII is really the right term) ~Brad -Original Message- From: morgan l [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 3:49 PM To: CF-Talk Subject: Re: Mystery Character Try here: http://www.miniguidez.com/macosx/keystrokesguide/specialcharacters/speci alcharacters.html It lists decimal and hex values for corresponding mac keystrokes. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309403 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Mystery Character
Actually, I just looked it up: http://livedocs.adobe.com/coldfusion/6/CFML_Reference/functions-pt121.htm According to this page, starting in MX 6, asc() supports values up to 65536, so it should work for you. Output your character value to the screen with asc(sFunkyCharacter) and you'll find out the value of it. Another thing you could do, if you really wanted to, was check all asc() values if each character in your string and if they exceed 255, then leave them out. That will ensure it works properly on Windows File System (which I'm assuming is the issue you are having). Dave -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 3:53 PM To: CF-Talk Subject: RE: Mystery Character I've ran into things like this before. Is there a CF function (or even a way in Java) to take a character and return the ASCII code for it? (Or whatever is appropriate, I don't know if ASCII is really the right term) ~Brad -Original Message- From: morgan l [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 3:49 PM To: CF-Talk Subject: Re: Mystery Character Try here: http://www.miniguidez.com/macosx/keystrokesguide/specialcharacters/speci alcharacters.html It lists decimal and hex values for corresponding mac keystrokes. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309404 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) URL Hack Attempt Leaves Me Scractching My Head...
And for those of you who take this advice and DO use cfqueryparam ***always*** make sure you NEVER use SELECT * (which you shouldn't do anyway). I inherited an application that had a ton of SELECT * all over it and no cfqueryparam tags. Over the years I added cfqueryparam tags as I worked on the application, adding new features, and updated old ones/fixing bugs. Then I ran into a situation. If I didn't update the SELECT * to include actual column names, and one of the column names got dropped from the table I was referencing in my SELECT query with a cfqueryparam, then BAM, the application would break. Two hard and fast rules to live by: 1. Use cfqueryparam - ALWAYS 2. Use SELECT * - NEVER I'm sure someone will now provide some comment as when generalizations are usually made, someone has a dissenting opinion (to which, of course, you are fully entitled!) :) Sincerely, Dave Phillips -Original Message- From: Matt Quackenbush [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 4:21 PM To: CF-Talk Subject: Re: (ot) URL Hack Attempt Leaves Me Scractching My Head... Did I really just read that? Please, someone, anyone, tell me that I didn't. Claude, you're certainly free to do what you wish to do in your own applications, so this comment is not directed to you at all. For those of you who are actually trying to learn and become better programmers/developers, please, do yourselves, your bosses, your fellow developers, and your clients a HUGE favor and completely ignore the advice of anyone that tells you not to use cfqueryparam. If you have read this thread, or any thread like it and you're not using it, you deserve what you get. Bottom line: ***always*** use cfqueryparam. Period. There are no acceptable exceptions to the rule. On Mon, Jul 21, 2008 at 3:54 PM, Claude Schneegans wrote: CFQUERYPARAM is a nice and powerful feature, but it makes SQL code more difficult to read, so the best is to use it only when it is really necessary. For me, using CFQUERYPARAM systematically for every parameter is as stupid as never using it at all. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309411 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: unoffical ahphosting thread
I am not going to blame Greg for SWSoft's F-up Is AHP just one guy? What were you guys expecting? Greg chose to use SWSoft software. They may be at fault but he is responsible. Also if he makes an upgrade and doesn't have enough help if things go wrong, that is also his fault. SWSoft isn't to blame for over a week of downtime. That was Greg. Subject: re: unoffical ahphosting thread From: [EMAIL PROTECTED] To: cf-talk@houseoffusion.com Date: Wed, 27 Feb 2008 11:14:04 -0600 I a have been with them for a while and don't plan on leaving anytime soon. While this is a major ouch...I too have enjoyed the one on one relationship with greg and the speed at which he normally gets things done. My sites are all still down as of last night. He is normally very quick to address problems when they occur. Much like I don't blame MS for hardware manufacturer's failings, I am not going to blame Greg for SWSoft's F-up ;-). THough I do agree with some of theother comments...it would be nice to have emails sent out periodically even if just to say it's still broke, but I am working on it. Doing that would provide a good diversion from trying to fix the code...sometimes that helps get it done faster. Eric ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300101 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
re: Getting the data time from an unfamiliar returned value
Initial thought is the date /time would be: 11/21/2007 @ 7:35 (PM) ( 28 seconds as well). The 000Z would probable reference the date/time is in a Zulu Time. Now using CF to format it, if you can use RegEx and parse the T and .000Z and see if it validates as a date/time object. Other than that, may have to parse it more. My 2 cents. Maybe someone else has already done this or something easier From: Che Vilnonis [EMAIL PROTECTED] Sent: Wednesday, November 28, 2007 11:38 AM To: CF-Talk cf-talk@houseoffusion.com Subject: Getting the data time from an unfamiliar returned value Here is the value: 2007-11-21T19:35:28.000Z It comes from the eBay REST API. It is in a format I have not seen. What can I do (with CF) to pull a valid date and time? Thanks, Che ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293927 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Is FigLeaf down?
Is the FigLeaf site down? I can't seem to get to any of their sites? _ Discover the new Windows Vista http://search.msn.com/results.aspx?q=windows+vistamkt=en-USform=QBRE ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293363 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Is FigLeaf down?
It's still up for me here (offsite) so maybe there's something else going on. My guess is some DNS problem earlier today. Maybe so, one of your dns servers seems to be down right now and the other is throwing errors. http://www.dnsreport.com/tools/dnsreport.ch?domain=figleaf.com _ Windows Live Hotmail and Microsoft Office Outlook together at last. Get it now. http://office.microsoft.com/en-us/outlook/HA102225181033.aspx?pid=CL100626971033 ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293436 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: CFEclipse / SVN problem
ok I can deal with that, however, do you have a link or something I can look at how to setup the host name to be mapped to a directory (client code)? TIA! From: Tom Chiverton [EMAIL PROTECTED] Sent: Tuesday, November 13, 2007 11:23 AM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: OT: CFEclipse / SVN problem On Tuesday 13 Nov 2007, ColdFusion wrote: That way I can always use: http://localhost for each client as a top level domain. Unrelated aside: most* people normally* setup http://projectname.localdomain or something, so each project has a different host name. -- Tom Chiverton Helping to biannually exploit out-of-the-box infrastructures on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293232 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: CFEclipse / SVN problem
Disregard: I found the following link to work like a charm: http://devlicio.us/blogs/ziemowit_skowronski/archive/2007/03/01/multiple-sites-and-host-headers-on-localhost-with-iis7.aspx From: CF Developer [EMAIL PROTECTED] Sent: Tuesday, November 13, 2007 12:16 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: OT: CFEclipse / SVN problem ok I can deal with that, however, do you have a link or something I can look at how to setup the host name to be mapped to a directory (client code)? TIA! From: Tom Chiverton Sent: Tuesday, November 13, 2007 11:23 AM To: CF-Talk Subject: Re: OT: CFEclipse / SVN problem On Tuesday 13 Nov 2007, ColdFusion wrote: That way I can always use: http://localhost for each client as a top level domain. Unrelated aside: most* people normally* setup http://projectname.localdomain or something, so each project has a different host name. -- Tom Chiverton Helping to biannually exploit out-of-the-box infrastructures on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293238 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFStoredProc
This should have been simple as making a PBJ. I am calling a SP (SQL Server 2005) using the CFStoredProc function and to get the result set returned as nextval. Basically it should return an interget value. cfstoredproc datasource=#application.datasource# procedure=usp_select_nextval cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=DataTrack_Block cfprocresult name = nextval /cfstoredproc Now if I try to use CFDump to dump the results set nextval it indicates the variable does not exist. What is it I am missing? It has ot be something I can say DOH about. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293036 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFStoredProc
The storedProc only returns a single interget value not a database object or field. It runs a Query, gets a value, increments the value, updates the table and returns the new calculated value. such as: database table as a field called: thisVal and that field is set to 1 It will increment it to 2, updates the table and set to return 2 as: return @nextVal I thought the dbvarname is used to specify the FIELD that you would want to be returned. From: Bruce Sorge [EMAIL PROTECTED] Sent: Friday, November 09, 2007 8:24 AM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: CFStoredProc It looks like you are missing the DBVAR name. CF Developer wrote: This should have been simple as making a PBJ. I am calling a SP (SQL Server 2005) using the CFStoredProc function and to get the result set returned as nextval. Basically it should return an interget value. Now if I try to use CFDump to dump the results set nextval it indicates the variable does not exist. What is it I am missing? It has ot be something I can say DOH about. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293043 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFGrid issue
I am having an issue with using a CFGRID. I am display the grid with maybe 4 columns of data. My first column is an ID column. My goal is to click on a row and it will send the user to a new page with the ID value being part of the URL. such as: onClick url would be: test.cfm?id=1 or 2 whichever the ID value is. Any idea why this will not work and will just add a # to the existing URL? cfgrid name=datatrack format=HTML query=qGetAllDataTracks selectmode=row onchange=getURL('test.cfm?ID=' + datatrack.dataProvider[datatrack.selectedIndex]['ID']); ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292572 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Fusebox session wackiness in WWW.domainname.com and domainname.com
I have a problem that I've never seen before concerning fusebox sessions and wondered if anyone has any input/advice. My application is built using Fusebox 5. Several session variables are set when a user first visits the site (in fusebox.init.cfm), after a check is performed to see if they already exist or not, including a persistent shopping cart. Sessions work fine when someone is on http://www.domainname.com. However, the Flash developer added a link to an ad on the home page that uses http://domainname.com (without the WWW). When someone clicks that link, sessions get completely hosed. I dumped all the session vars on that particular page under both WWW.domainname.com and domainname.com. WWW.domainname.com shows a session ID and URLtoken. domainname.com does not. It's like sessions are not even being created when someone is on domainname.com. Also, I'm using fusebox.appinit.cfm to set some app variables. I have a URL string I use to reload the app vars whenever I make a change to appinit. I've noticed that if I make a change, upload appinit, and reload the app on WWW.domainname.com, the vars are reset just fine. However, they are NOT reset on domainname.com -- I'll click the link in the Flash ad, view source, and the app vars have not been reloaded. The DNS set up looks fine. The hosting administrator doesn't have a clue. They're sure both domains are on the same server. I've tried using the persistent session var methods (setting them as client vars) described in the tech docs with no luck (same thing). Has anyone run across this before? TIA! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Fusebox session wackiness in WWW.domainname.com and domainname.com
Yes, I tried that as well. No dice. I think this issue can be addressed by setting setdomaincookies = true in your cfapplication tag. -- Josh ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Fusebox session wackiness in WWW.domainname.com and domainname.com
Or, I guess I should say, it works to a point ... when I go to the page via the domainname.com link, the session is not apparent ... I have to refresh the page to get the session information to display -- it doesn't require this on any other page under WWW.domainname.com Yes, I tried that as well. No dice. I think this issue can be addressed by setting setdomaincookies = true in your cfapplication tag. -- Josh ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269052 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Fusebox session wackiness in WWW.domainname.com and domainname.com
Yes, there's a dns record for both. Are you sure that there is a dns record for both or a wildcard * ? Dan Vega http://www.danvega.org/blog/ On 2/7/07, CF Developer [EMAIL PROTECTED] wrote: ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269053 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
webroot level?
i know there is a way, just not coming to mind. what I want to be able to do is specify the root level of an application w/o having to set a request variable. such as: request.images = images/ or if i am one folder down: request.images = ../images/ isn't there a way to specify something like: img src=""> and it point to the root of the web app regardless of how many folders down you are within the application??? TIA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: webroot level?
will that work for cfincludes? such as:cfinclude template=/includes/thisfile.cfm since this is a shared hosting, i do not have access to establish cf mappings - Original Message - From: Jason L. West, Sr. [EMAIL PROTECTED] Date: Thu, 22 Jul 2004 11:11:16 -0400 Subject: Re: webroot level? To: CF-Talk [EMAIL PROTECTED] isn't there a way to specify something like: img src=""> Yes this does pull from the root of your url: ex: http://www.site.com/images/image.gif [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]