Re: I just made a new CFC it has to with the classpath
Mark, It does not matter because I can't go back to classloaders. I have java voice apps running, new crazy JDBC embedded java databases running inside the admin on shared hosts uses stealth datasources and the people I work for depend on me to get the job done at runtime and by any means necessary. No way can I go back. I should have another look at that class and see what other people are saying about it but I don't have to wrap any java objects ever again. The days of wrapping are officially over! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247578 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: I just made a new CFC it has to with the classpath
Well I can see you doing some interesting things with this technique, but honestly, I can't see a scenario in which a classloader of some description won't provide you with the same functionality. Also there are definatley places I would prefer to have a ClassLoader - using the latest version of log4j comes to mind for example. If you actually replaced that in the ColdFusion classpath you are quite liable to break aspects of ColdFusion as a whole. Mark On 7/25/06, Dan Plesse [EMAIL PROTECTED] wrote: Mark, It does not matter because I can't go back to classloaders. I have java voice apps running, new crazy JDBC embedded java databases running inside the admin on shared hosts uses stealth datasources and the people I work for depend on me to get the job done at runtime and by any means necessary. No way can I go back. I should have another look at that class and see what other people are saying about it but I don't have to wrap any java objects ever again. The days of wrapping are officially over! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247579 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: execute a DTS package via Stored Proc?
See my reply m8, that worked for me. -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: 24 July 2006 21:33 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? I've tried to do this in the past and just gave up. There are all sorts of issues including permissions and ownership. I couldn't get it to work through CF (although our CF was on a different server then SQL, and no AD). It might work if you have AD, but we ended up just scheduling the DTS and running it every hour. I wonder if you can easily run a SQL server scheduled task through SQL... Russ -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, July 24, 2006 4:22 PM To: CF-Talk Subject: Re: execute a DTS package via Stored Proc? Thanks, Dave. Glad you brought you brought up the access issue, I hadn't thought of that. Dave Watts wrote: Is there an easy way to do this? I'm trying to avoid using the command-line route to do this. Seems like that it would be a standard feature of SQL Server 2K to have this built-in. Everything I'm finding on Google is just damn complicated It's not built in. To the best of my knowledge, you can only execute DTS packages from Enterprise Manager or using the command-line DTSRUN.EXE program. You could, however, use sp_cmdshell to run DTSRUN.EXE, assuming your DBA hasn't denied you access or dropped sp_cmdshell. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247580 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfcdev, cflib, my blog, etc
Ok well this is another difference between a proper mailing list, and what you get with a mail server. We use Merak, and I believe that is configurable as to what appears in the to and from fields. But in most cases I guess they would be classed as a distribution list, you just get a few extra options on some products. -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 03:50 To: CF-Talk Subject: RE: cfcdev, cflib, my blog, etc Snake...there is a difference between a mailing list and a distribution list, apparently. On the forum for hmailserver, a user asked why an email received through hmailserver's distribution list was showing the sender's email address, and why, when the email was responded to, it went only back to the person who sent the message, rather than to everyone. Martin, a developer for hmailserver, said that's the way it's supposed to work because it's a distribution list rather than a mailing list... The MySQL list works that way too, apparently, because mail I get from there always has the sender's address in the From field, rather than the mailing list address like CF-Talk. Rick -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Monday, July 24, 2006 12:19 PM To: CF-Talk Subject: RE: cfcdev, cflib, my blog, etc I dunno, maybe the fact that they have different names has confused her. Not every mail server calls it the same thing. Some call it mailing list, some call it distribution list, some call it MRA (Multi receipient Addresses). But they all do the same thing. You create a List address, and a list of recipients, and any mail sent to the list address gets forwarded to all recipients. If you want a PROPER mailing list management system, then you want to look at some like MAILMAN. The ones that come with mail servers are usually quite basic. Snake -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 24 July 2006 16:41 To: CF-Talk Subject: RE: cfcdev, cflib, my blog, etc You're so witty, Snake! Anyway...what, then, is the nature of Jenny's concern with a Mail list vs Distribution List? Rick -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Monday, July 24, 2006 11:27 AM To: CF-Talk Subject: RE: cfcdev, cflib, my blog, etc http://www.hmailserver.com/documentation/?page=reference_distributionlist If it Looks like a list, sounds like a list. Must be a list. -- Snake -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 24 July 2006 16:03 To: CF-Talk Subject: RE: cfcdev, cflib, my blog, etc So what you're saying, Jenny, is that hMailServer doesn't support mailing lists like CF-Talk? I've been considering starting some lists like this one and was interested in hMailServer until your comment about it not supporting mailing lists... Rick -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: Monday, July 24, 2006 5:28 AM To: CF-Talk Subject: RE: cfcdev, cflib, my blog, etc Just started using it here .. the one thing I wish it had was Maillist support and not the Distribution list included. Also works with Helm control panel :-) Really easy to install and admin. Jenny -Original Message- From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] Sent: 24 July 2006 09:12 To: CF-Talk Subject: RE: cfcdev, cflib, my blog, etc | HMailServer, free, open, windows... | | www.hmailserver.com | | Using it in production now for two years, no complaints yet. | Serving about a 100 domains. I'll echo that, I use it small-scale for my private needs, works very well. /Hugo ###This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.Formore information, connect to http://www.F-Secure.com/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247581 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: WSDL Problem
Can you post the full error? WebServices work just fine on the Developer version. It's the 'DevNet' license that does what Claude described. Cheers. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 July 2006 12:03 PM To: CF-Talk Subject: Re: WSDL Problem Does anyone have any ideas what the problem might be? Check if the server has a full license. If it is only a developer version, it will add some garbage in the headers that will break the XML. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247582 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I just made a new CFC it has to with the classpath
Mark, 95% of my post where scenarios in which the classes where not working using the javaloader.cfc. And I do all my work using this classpath.cfc as a foundation and nothing breaks. Did you at least try to run some of tests and see for yourself that the cfc was not working with the scenarios I listed? I provided you with three examples the forName() test, JDBC and JWS. How did they function on your computer and inside the datasource manager? Those are the scenarios which did not work. They are not small scenarios either. JDBC plays is a big part with Coldfusion. I also found out that the classes persist without scoping. The cfc didn't have any persistance by deault which I think is good thing to have.. Dan ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247583 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfcdev, cflib, my blog, etc
Also, the Distribution list won't handle bounces the way a maillist would in that the bounces from the Dist list emails are sent to the original sender and not to the maillist manager. I had to get around it by running mdaemon on a separate IP to get the maillist functionality. I emailed back and forth with Martin Knafve, the hmail creator, but he seems reluctant to add maillist functionality as he says there's not enough demand from his user base! Jenny -Original Message- From: John C. Bland II [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 06:35 To: CF-Talk Subject: Re: cfcdev, cflib, my blog, etc Typically those lists that have From: User [EMAIL PROTECTED] have Reply To: [EMAIL PROTECTED], like CF-Talk (shows from You, Reply To CF-Talk, and To: CF-Talk). On 7/24/06, Rick Faircloth [EMAIL PROTECTED] wrote: Snake...there is a difference between a mailing list and a distribution list, apparently. -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.4/396 - Release Date: 24/07/2006 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247584 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: I just made a new CFC it has to with the classpath
Honestly, I couldn't understand what you were getting at in your examples, so I didn't read to far into them. In fact, more often than not, I really am not sure what you are trying to communicate. As far your examples that show calling private and protected methods, quite frankly I think that that is a relatively irresponsible way to develop, when you are breaking severe rules of a programming language. You are right, JavaLoader, or any other ClassLoader based system will not work when calling those methods, because they should not work, nor is there any reason for them to. Anyway, this conversation has gone on long enough, I think. Mark On 7/25/06, Dan Plesse [EMAIL PROTECTED] wrote: Mark, 95% of my post where scenarios in which the classes where not working using the javaloader.cfc. And I do all my work using this classpath.cfc as a foundation and nothing breaks. Did you at least try to run some of tests and see for yourself that the cfc was not working with the scenarios I listed? I provided you with three examples the forName() test, JDBC and JWS. How did they function on your computer and inside the datasource manager? Those are the scenarios which did not work. They are not small scenarios either. JDBC plays is a big part with Coldfusion. I also found out that the classes persist without scoping. The cfc didn't have any persistance by deault which I think is good thing to have.. Dan -- E: [EMAIL PROTECTED] W: www.compoundtheory.com ICQ: 3094740 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247585 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: WSDL Problem
As it happens, I managed to fix it now. From what I can tell the calling server had cached the WSDL, and was not letting go of it, even after trying to refresh it repeatedly. A server restart worked. On 7/25/06, Andrew Stevens [EMAIL PROTECTED] wrote: Can you post the full error? WebServices work just fine on the Developer version. It's the 'DevNet' license that does what Claude described. Cheers. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 July 2006 12:03 PM To: CF-Talk Subject: Re: WSDL Problem Does anyone have any ideas what the problem might be? Check if the server has a full license. If it is only a developer version, it will add some garbage in the headers that will break the XML. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247586 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFTHREAD and CFJOIN Proof of Concept Tags Posted
So it must be MX6 compatible then? If it is also in 1.4.2? -- Sent from my BlackBerry Wireless Device 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 -Original Message- From: Steve Brownlee [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Fri Jul 21 21:02:55 2006 Subject: RE: CFTHREAD and CFJOIN Proof of Concept Tags Posted Damien: As all features of CFMX are, this is a Java feature. http://java.sun.com/j2se/1.5.0/docs/api/java/lang/Thread.html http://java.sun.com/j2se/1.4.2/docs/api/java/lang/Thread.html They're writing an interface for it. -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Friday, July 21, 2006 10:46 AM To: CF-Talk Subject: Re: CFTHREAD and CFJOIN Proof of Concept Tags Posted On Jul 21, 2006, at 10:39 AM, [EMAIL PROTECTED] wrote: http://www.dcooper.org Awesome. I was wondering, though, what features of CFMX7 are used to do this that are incompatible with CFMX6? Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247587 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfcontent error - IE6 XP SP2 client and Win 2003 server
You can also get this error when you run out of disk space and ColdFusion cannot physically write the file to disk. -- Sent from my BlackBerry Wireless Device 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 -Original Message- From: michael acadia [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Fri Jul 21 20:30:52 2006 Subject: RE: cfcontent error - IE6 XP SP2 client and Win 2003 server Is the production server using a Cache-Control: no-cache HTTP header? I ran into a similar problem yesterday when opening a Word doc served by cfcontent (Win2k3 server). If MS Word was closed when I tried to open the doc from the web page, the no-cache was deleting the file before Word started up - resulting in Word's 'file not found' error. If, however, Word was already open, the doc displayed with no problem. Never had any trouble saving the file to my desktop. FWIW, this behavior was only occurring in IE6 - Firefox had no problems. Since I need the no-cache in place, my solution was to drop the 'attachment' value from cfheader: cfheader name=Content-Disposition value=filename=#filename# instead of cfheader name=Content-Disposition value=attachment;filename=#filename# IE now displays the Word doc inside the browser (not what I wanted), but at least the user doesn't get an error. hth, -michael Original Message Subject: cfcontent error - IE6 XP SP2 client and Win 2003 server From: Peter Legg [EMAIL PROTECTED] Date: Fri, July 21, 2006 2:56 pm To: CF-Talk cf-talk@houseoffusion.com I've got a page that produces and Excel file for the user to either open or save. Here's the code: cfcontent type=application/msexcel cfheader name=Content-Disposition value=attachment;filename=#filename# This works fine from my Win2000 PC. However, it can't be opened using IE6 on an XP service pack 2 PC when hitting the production site, a Win 2003 server. The file can be saved. When accessing the development site, a Win 2000 server, both open and save work from this PC. Here's an example of the error: C:\Documents and Settings\username\Local Settings\Temporary Internet Files\Content.IE5\89GL2345\filename.xls could not be found It obviously has to do with the ability to read/write to the Content.IE5 directory, which isn't visible, but just haven't been able to figure it out. I've been able to reset the attributes of the folder in order to see it but that hasn't solved the problem either. Any ideas? Thanks, Peter ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247588 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfcdev, cflib, my blog, etc
There are plenty of FREE mailing list managers out there that will do a better job anyway. I use MAILMAN, you can see how it works here http://list.cfdeveloepr.co.uk/ - Snake -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 08:51 To: CF-Talk Subject: RE: cfcdev, cflib, my blog, etc Also, the Distribution list won't handle bounces the way a maillist would in that the bounces from the Dist list emails are sent to the original sender and not to the maillist manager. I had to get around it by running mdaemon on a separate IP to get the maillist functionality. I emailed back and forth with Martin Knafve, the hmail creator, but he seems reluctant to add maillist functionality as he says there's not enough demand from his user base! Jenny -Original Message- From: John C. Bland II [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 06:35 To: CF-Talk Subject: Re: cfcdev, cflib, my blog, etc Typically those lists that have From: User [EMAIL PROTECTED] have Reply To: [EMAIL PROTECTED], like CF-Talk (shows from You, Reply To CF-Talk, and To: CF-Talk). On 7/24/06, Rick Faircloth [EMAIL PROTECTED] wrote: Snake...there is a difference between a mailing list and a distribution list, apparently. -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.4/396 - Release Date: 24/07/2006 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247589 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
WSDL Complex Types and Coldfusion
Hi, I'm having problems trying to consume a web service in Coldfusion. The WSDL document is quite complicated with several import files so I'm never sure if I'm sending the right structures as the variables in my cfinvoke. I keep getting the Web service operation ... could not be found message. Can anyone see what I'm doing wrong? Any help will be much appreciated. (Please excuse my test data, I'm trying to get the structure right before I worry about what values I send!) WSDL: HYPERLINK http://webservices.sabre.com/wsdl_cat/sabreXML1.0.00/usg/SessionCreateRQ.wsdlhttp://webservices.sabre.com/wsdl_cat/sabreXML1.0.00/usg/SessionCreateRQ.wsdl My Code: cfset stc_Security = StructNew() cfset x = StructInsert(stc_Security, UsernameToken, StructNew()) cfset x = StructInsert(stc_Security.UsernameToken, Username, test) cfset x = StructInsert(stc_Security.UsernameToken, Password, test) cfset x = StructInsert(stc_Security.UsernameToken, Organization, test) cfset x = StructInsert(stc_Security.UsernameToken, Domain, test) cfset stc_MessageHeader = StructNew() cfset x = StructInsert(stc_MessageHeader, From, StructNew()) cfset x = StructInsert(stc_MessageHeader.From, PartyId, ArrayNew(1)) cfset stc_MessageHeader.From.PartyId[1] = StructNew() cfset x = StructInsert(stc_MessageHeader.From.PartyId[1], value, test) cfset x = StructInsert(stc_MessageHeader.From.PartyId[1], type, test) cfset x = StructInsert(stc_MessageHeader, To, StructNew()) cfset x = StructInsert(stc_MessageHeader.To, PartyId, ArrayNew(1)) cfset stc_MessageHeader.To.PartyId[1] = StructNew() cfset x = StructInsert(stc_MessageHeader.To.PartyId[1], value, test) cfset x = StructInsert(stc_MessageHeader.To.PartyId[1], type, test) cfset x = StructInsert(stc_MessageHeader, CPAId, test) cfset x = StructInsert(stc_MessageHeader, ConversationId, test) cfset x = StructInsert(stc_MessageHeader, Service, StructNew()) cfset x = StructInsert(stc_MessageHeader.Service, type, test) cfset x = StructInsert(stc_MessageHeader.Service, value, test) cfset x = StructInsert(stc_MessageHeader, Action, test) cfset x = StructInsert(stc_MessageHeader, MessageData, StructNew()) cfset x = StructInsert(stc_MessageHeader.MessageData, MessageId, test) cfset x = StructInsert(stc_MessageHeader.MessageData, Timestamp, test) cfset x = StructInsert(stc_MessageHeader, version, test) cfset stc_Body = StructNew() cfset x = StructInsert(stc_Body, POS, StructNew()) cfset x = StructInsert(stc_Body.POS, Source, StructNew()) cfset x = StructInsert(stc_Body.POS.Source, PseudoCityCode, test) cfinvoke webservice=HYPERLINK http://webservices.sabre.com/wsdl_cat/sabreXML1.0.00/usg/SessionCreateRQ.wsdlhttp://webservices.sabre.com/wsdl_cat/sabreXML1.0.00/usg/SessionCreateRQ.wsdl; method=SessionCreateRQ returnvariable=str_Return timeout=10 cfinvokeargument name=header value=#stc_MessageHeader# cfinvokeargument name=header2 value=#stc_Security# cfinvokeargument name=body value=#stc_Body# /cfinvoke -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.4/396 - Release Date: 24/07/2006 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247590 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Where can I get JIMG from DRK4 released in 2003
Just wondering if there is a way to get the JIMG from the DRK4 (or that DRK4). The DRKs aren't for sale on the Adobe site, and I know that some of the applications have been released to the public. Has this one? As well, are there any free image resizing tools that are of reasonable quality? Part of me has a sneaky suspension that image manipulation may be built-in to the next version of CF (it's a great-awesome wow-bang feature), but that's too far off for my needs. I would like to look at an interim free solution in the meantime Stephen ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247591 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: WSDL Complex Types and Coldfusion
I'd try if I wasn't going out :| It looks like you're dealing with ebXML Web Services. www.ebxml.org. I'd Google around to see if anyone else has done it already. Also dump the web service to see the methods, ala; cfset ws = createobject(webservice, http://webservices.sabre.com/wsdl_cat/sabreXML1.0.00/usg/SessionCreateRQ.wsd l cfdump var=#ws# If you don't see the method you are calling listed in the dump, then you may not be able to call it using cfinvoke. Cheers. -Original Message- From: Daniel Dabner [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 July 2006 7:30 PM To: CF-Talk Subject: WSDL Complex Types and Coldfusion Hi, I'm having problems trying to consume a web service in Coldfusion. The WSDL document is quite complicated with several import files so I'm never sure if I'm sending the right structures as the variables in my cfinvoke. I keep getting the Web service operation ... could not be found message. Can anyone see what I'm doing wrong? Any help will be much appreciated. (Please excuse my test data, I'm trying to get the structure right before I worry about what values I send!) WSDL: HYPERLINK http://webservices.sabre.com/wsdl_cat/sabreXML1.0.00/usg/SessionCreateRQ.ws dlhttp://webservices.sabre.com/wsdl_cat/sabreXML1.0.00/usg/SessionCreateRQ. wsdl My Code: cfset stc_Security = StructNew() cfset x = StructInsert(stc_Security, UsernameToken, StructNew()) cfset x = StructInsert(stc_Security.UsernameToken, Username, test) cfset x = StructInsert(stc_Security.UsernameToken, Password, test) cfset x = StructInsert(stc_Security.UsernameToken, Organization, test) cfset x = StructInsert(stc_Security.UsernameToken, Domain, test) cfset stc_MessageHeader = StructNew() cfset x = StructInsert(stc_MessageHeader, From, StructNew()) cfset x = StructInsert(stc_MessageHeader.From, PartyId, ArrayNew(1)) cfset stc_MessageHeader.From.PartyId[1] = StructNew() cfset x = StructInsert(stc_MessageHeader.From.PartyId[1], value, test) cfset x = StructInsert(stc_MessageHeader.From.PartyId[1], type, test) cfset x = StructInsert(stc_MessageHeader, To, StructNew()) cfset x = StructInsert(stc_MessageHeader.To, PartyId, ArrayNew(1)) cfset stc_MessageHeader.To.PartyId[1] = StructNew() cfset x = StructInsert(stc_MessageHeader.To.PartyId[1], value, test) cfset x = StructInsert(stc_MessageHeader.To.PartyId[1], type, test) cfset x = StructInsert(stc_MessageHeader, CPAId, test) cfset x = StructInsert(stc_MessageHeader, ConversationId, test) cfset x = StructInsert(stc_MessageHeader, Service, StructNew()) cfset x = StructInsert(stc_MessageHeader.Service, type, test) cfset x = StructInsert(stc_MessageHeader.Service, value, test) cfset x = StructInsert(stc_MessageHeader, Action, test) cfset x = StructInsert(stc_MessageHeader, MessageData, StructNew()) cfset x = StructInsert(stc_MessageHeader.MessageData, MessageId, test) cfset x = StructInsert(stc_MessageHeader.MessageData, Timestamp, test) cfset x = StructInsert(stc_MessageHeader, version, test) cfset stc_Body = StructNew() cfset x = StructInsert(stc_Body, POS, StructNew()) cfset x = StructInsert(stc_Body.POS, Source, StructNew()) cfset x = StructInsert(stc_Body.POS.Source, PseudoCityCode, test) cfinvoke webservice=HYPERLINK http://webservices.sabre.com/wsdl_cat/sabreXML1.0.00/usg/SessionCreateRQ.ws dlhttp://webservices.sabre.com/wsdl_cat/sabreXML1.0.00/usg/SessionCreateRQ. wsdl method=SessionCreateRQ returnvariable=str_Return timeout=10 cfinvokeargument name=header value=#stc_MessageHeader# cfinvokeargument name=header2 value=#stc_Security# cfinvokeargument name=body value=#stc_Body# /cfinvoke -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.4/396 - Release Date: 24/07/2006 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247592 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Where can I get JIMG from DRK4 released in 2003
I asked too soon. Found Image CFC http://www.opensourcecf.com/imagecfc/ which looks new and fresh (updated in February). That should work fine for what I need. Sorry for the interruption! Stephen ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247593 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: WSDL Complex Types and Coldfusion
I've tried dumping the service as you suggest but that only tells me the method exists. The problem is with the structures I'm sending as the parameters, I'm probably missing a required element or something, but I can't see what. I will have a look around for info on ebXML as you suggest and see what that turns up. Really I just need a utility that will analyse the WSDL and tell me the CF structures for the data. I've tried the WSDL2Java utility but what's returned there is nearly as complicated as the WSDL, and it hasn't helped much. Cheers -Original Message- From: Andrew Stevens [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 11:23 To: CF-Talk Subject: RE: WSDL Complex Types and Coldfusion I'd try if I wasn't going out :| It looks like you're dealing with ebXML Web Services. www.ebxml.org. I'd Google around to see if anyone else has done it already. Also dump the web service to see the methods, ala; cfset ws = createobject(webservice, http://webservices.sabre.com/wsdl_cat/sabreXML1.0.00/usg/SessionCreateRQ.wsd l cfdump var=#ws# If you don't see the method you are calling listed in the dump, then you may not be able to call it using cfinvoke. Cheers. -Original Message- From: Daniel Dabner [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 July 2006 7:30 PM To: CF-Talk Subject: WSDL Complex Types and Coldfusion Hi, I'm having problems trying to consume a web service in Coldfusion. The WSDL document is quite complicated with several import files so I'm never sure if I'm sending the right structures as the variables in my cfinvoke. I keep getting the Web service operation ... could not be found message. Can anyone see what I'm doing wrong? Any help will be much appreciated. (Please excuse my test data, I'm trying to get the structure right before I worry about what values I send!) WSDL: HYPERLINK http://webservices.sabre.com/wsdl_cat/sabreXML1.0.00/usg/SessionCreateRQ.ws dlhttp://webservices.sabre.com/wsdl_cat/sabreXML1.0.00/usg/SessionCreateRQ. wsdl My Code: cfset stc_Security = StructNew() cfset x = StructInsert(stc_Security, UsernameToken, StructNew()) cfset x = StructInsert(stc_Security.UsernameToken, Username, test) cfset x = StructInsert(stc_Security.UsernameToken, Password, test) cfset x = StructInsert(stc_Security.UsernameToken, Organization, test) cfset x = StructInsert(stc_Security.UsernameToken, Domain, test) cfset stc_MessageHeader = StructNew() cfset x = StructInsert(stc_MessageHeader, From, StructNew()) cfset x = StructInsert(stc_MessageHeader.From, PartyId, ArrayNew(1)) cfset stc_MessageHeader.From.PartyId[1] = StructNew() cfset x = StructInsert(stc_MessageHeader.From.PartyId[1], value, test) cfset x = StructInsert(stc_MessageHeader.From.PartyId[1], type, test) cfset x = StructInsert(stc_MessageHeader, To, StructNew()) cfset x = StructInsert(stc_MessageHeader.To, PartyId, ArrayNew(1)) cfset stc_MessageHeader.To.PartyId[1] = StructNew() cfset x = StructInsert(stc_MessageHeader.To.PartyId[1], value, test) cfset x = StructInsert(stc_MessageHeader.To.PartyId[1], type, test) cfset x = StructInsert(stc_MessageHeader, CPAId, test) cfset x = StructInsert(stc_MessageHeader, ConversationId, test) cfset x = StructInsert(stc_MessageHeader, Service, StructNew()) cfset x = StructInsert(stc_MessageHeader.Service, type, test) cfset x = StructInsert(stc_MessageHeader.Service, value, test) cfset x = StructInsert(stc_MessageHeader, Action, test) cfset x = StructInsert(stc_MessageHeader, MessageData, StructNew()) cfset x = StructInsert(stc_MessageHeader.MessageData, MessageId, test) cfset x = StructInsert(stc_MessageHeader.MessageData, Timestamp, test) cfset x = StructInsert(stc_MessageHeader, version, test) cfset stc_Body = StructNew() cfset x = StructInsert(stc_Body, POS, StructNew()) cfset x = StructInsert(stc_Body.POS, Source, StructNew()) cfset x = StructInsert(stc_Body.POS.Source, PseudoCityCode, test) cfinvoke webservice=HYPERLINK http://webservices.sabre.com/wsdl_cat/sabreXML1.0.00/usg/SessionCreateRQ.ws dlhttp://webservices.sabre.com/wsdl_cat/sabreXML1.0.00/usg/SessionCreateRQ. wsdl method=SessionCreateRQ returnvariable=str_Return timeout=10 cfinvokeargument name=header value=#stc_MessageHeader# cfinvokeargument name=header2 value=#stc_Security# cfinvokeargument name=body value=#stc_Body# /cfinvoke -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.4/396 - Release Date: 24/07/2006 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247594 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe:
Re: WSDL Complex Types and Coldfusion
Have you tried DreamWeaver? On 7/25/06, Daniel Dabner [EMAIL PROTECTED] wrote: Really I just need a utility that will analyse the WSDL and tell me the CF structures for the data. I've tried the WSDL2Java utility but what's returned there is nearly as complicated as the WSDL, and it hasn't helped much. -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247595 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: WSDL Complex Types and Coldfusion
I never considered Dreamweaver... I just had a quick look and didn't see anything that will do the job, but thanks for the suggestion. ebXML isn't getting me anywhere either. I can see in the specification the structure used in the imported schema, but it tells me nothing additional about the end CF structure I need. -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.4/396 - Release Date: 24/07/2006 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247596 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: execute a DTS package via Stored Proc?
All, ColdFusion and SQL Server Permission Integration: Part I ColdFusion Development Journal, September 2003, pp. 8-15. http://coldfusion.sys-con.com/read/42068.htm ColdFusion and SQL Server Permission Integration: Part II ColdFusion Development Journal, October 2003, pp. 26-33 http://coldfusion.sys-con.com/read/42080.htm I hope this helps. -Jim ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247597 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Drag and drop select list with flash forms...
Is it possible to make a select list using flash forms in CFMX that allows users to re-order the items via drag and drop? I've got an HTML solution right now that uses javascript but it's really considerably less friendly than I'd like it to be. Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247598 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: execute a DTS package via Stored Proc?
Holy sh*^seriously long winded when this will do.. DECLARE @execcommand varchar(100) select @execcommand = 'dtsrun /Syourserver /Uusername /Ppassword /Npackagename'' exec master..xp_cmdshell @execcommand :-) -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 13:38 To: CF-Talk Subject: Re: execute a DTS package via Stored Proc? All, ColdFusion and SQL Server Permission Integration: Part I ColdFusion Development Journal, September 2003, pp. 8-15. http://coldfusion.sys-con.com/read/42068.htm ColdFusion and SQL Server Permission Integration: Part II ColdFusion Development Journal, October 2003, pp. 26-33 http://coldfusion.sys-con.com/read/42080.htm I hope this helps. -Jim ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247599 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: execute a DTS package via Stored Proc?
Hi Chaps All the above do seem very lengthy routes, trhe route mentioned by Ravo is by far the best practice. I have used this method and can definatly say it is an excellent method. However make sure you do not remove the 'U' 'P' prefixes in the '/Uusername /Ppassword' I made this mistake once and the errors received were not to helpfull heh ;) Jose Diaz On 7/25/06, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Holy sh*^seriously long winded when this will do.. DECLARE @execcommand varchar(100) select @execcommand = 'dtsrun /Syourserver /Uusername /Ppassword /Npackagename'' exec master..xp_cmdshell @execcommand :-) -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 13:38 To: CF-Talk Subject: Re: execute a DTS package via Stored Proc? All, ColdFusion and SQL Server Permission Integration: Part I ColdFusion Development Journal, September 2003, pp. 8-15. http://coldfusion.sys-con.com/read/42068.htm ColdFusion and SQL Server Permission Integration: Part II ColdFusion Development Journal, October 2003, pp. 26-33 http://coldfusion.sys-con.com/read/42080.htm I hope this helps. -Jim ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247600 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: execute a DTS package via Stored Proc?
If only it were that easy. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 13:40 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? Holy sh*^seriously long winded when this will do.. DECLARE @execcommand varchar(100) select @execcommand = 'dtsrun /Syourserver /Uusername /Ppassword /Npackagename'' exec master..xp_cmdshell @execcommand :-) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247601 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem with cflogoff tag
Sam, Thanks for your response. Hereâs the code for the login. The logoff is simply linking to a page that starts out with the cflogoff tag. Thatâs it. The login works fine. The logoff does not. In order to log off, I have to close the browser. - Lewis CFLOGIN !--- idletimeout=#CreateTimeSpan(0,0,10,0)# --- !--- *** If no form submission send the user to submit the login form. *** --- cfif NOT (IsDefined(Form.username) AND IsDefined(Form.Password)) br br cfinclude TEMPLATE=Grantee_Login2.cfm cfabort !--- *** This Else statement decides whether the username and password are valid. *** --- CFELSE !--- Find record with this UserName/password. *** If no rows returned, password not valid --- cfquery name = GetUser datasource=wdsc SELECT UserID, FirstName, Rights FROM MSFW_Passwords WHERE UserName = '#FORM.UserName#' AND Password = '#FORM.Password#' /cfquery !--- (nested if statement)If the username and password are correct... --- cfif GetUser.REcordCount EQ 1 !--- Tell ColdFusion to consider the user logged in for the NAME attribute, we will provide the user's UserID number and first name, separated by commas Later, we can access the NAME value via GetAuthUser() --- cfloginuser name=#GetUser.UserID#, #GetUser.FirstName# password=#form.password# roles=#GetUser.Rights# !--- cflocation url=admin/GranteeDirAdmin.cfm cfabort --- cfelse br br br strongSorry, that user name and password are not recognized. Please try again./strong cfinclude template=Grantee_Login2.cfm cfabort /cfif /cfif /CFLOGIN Can you provide the code? For both logging in and logging out. Also livedocs provide a good background for this tag: http://livedocs.macromedia. com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp. htm?context=ColdFusion_Documentationfile=0289.htm Cheers, Sam On 7/24/06, Billingsley, Lewis - ETA CTR [EMAIL PROTECTED] wrote: Hi, I'm sort of a low-end intermediate developer. I'm having trouble getting the cflogout tag to work. I read somewhere that it was better to create an application.cfc file rather than an application.cfm file for the login framework, but with either one the logout tag does not work. My book says it takes no attributes. Someone said something about setting a timeout somewhere, but I didn't get which timeout or where - or how. It looks like the THIS scope may have a timeout I can set, but I can't figure it out. I'm not even sure if the login framework actually uses the session scope somehow, either and how I would do that if it did. As you can see, I'm in need of enlightenment. Thank you. Lewis Can you provide the code? For both logging in and logging out. Also livedocs provide a good background for this tag: http://livedocs.macromedia. com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp. htm?context=ColdFusion_Documentationfile=0289.htm Cheers, Sam On 7/24/06, Billingsley, Lewis - ETA CTR [EMAIL PROTECTED] wrote: Hi, I'm sort of a low-end intermediate developer. I'm having trouble getting the cflogout tag to work. I read somewhere that it was better to create an application.cfc file rather than an application.cfm file for the login framework, but with either one the logout tag does not work. My book says it takes no attributes. Someone said something about setting a timeout somewhere, but I didn't get which timeout or where - or how. It looks like the THIS scope may have a timeout I can set, but I can't figure it out. I'm not even sure if the login framework actually uses the session scope somehow, either and how I would do that if it did. As you can see, I'm in need of enlightenment. Thank you. Lewis ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247602 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: execute a DTS package via Stored Proc?
How do you mean? This will work if you have the correct settings in there no worries - granted it does not have any defensive stuff in their but if your DTS is say, a simple import - it will be job done. -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:15 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? If only it were that easy. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 13:40 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? Holy sh*^seriously long winded when this will do.. DECLARE @execcommand varchar(100) select @execcommand = 'dtsrun /Syourserver /Uusername /Ppassword /Npackagename'' exec master..xp_cmdshell @execcommand :-) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247603 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: execute a DTS package via Stored Proc?
Don't you have to be the SA in order to do exec master..xp_cmdshell @execcommand I don't remember the reasons, but I couldn't do it the easy way when I tried. I need to do it as a speciifc user who only had access to his own database. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:03 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? How do you mean? This will work if you have the correct settings in there no worries - granted it does not have any defensive stuff in their but if your DTS is say, a simple import - it will be job done. -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:15 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? If only it were that easy. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 13:40 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? Holy sh*^seriously long winded when this will do.. DECLARE @execcommand varchar(100) select @execcommand = 'dtsrun /Syourserver /Uusername /Ppassword /Npackagename'' exec master..xp_cmdshell @execcommand :-) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247604 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: execute a DTS package via Stored Proc?
Yea, that's been my problem. I am the SA on my dev server, but I'm not going to be when this goes into production. I have about 5 solutions in front of me, all of which require certain degrees of Administrative power. Trying to figure out which is the one that will work when I go live is the hard part. I'll look into all these solutions this week. I certainly appreciate all the choices. Ray Snake wrote: Don't you have to be the SA in order to do exec master..xp_cmdshell @execcommand I don't remember the reasons, but I couldn't do it the easy way when I tried. I need to do it as a speciifc user who only had access to his own database. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:03 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? How do you mean? This will work if you have the correct settings in there no worries - granted it does not have any defensive stuff in their but if your DTS is say, a simple import - it will be job done. -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:15 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? If only it were that easy. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 13:40 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? Holy sh*^seriously long winded when this will do.. DECLARE @execcommand varchar(100) select @execcommand = 'dtsrun /Syourserver /Uusername /Ppassword /Npackagename'' exec master..xp_cmdshell @execcommand :-) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247605 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: execute a DTS package via Stored Proc?
Well the way I did worked for restricted user access. Where the user is DBO of his own database and nothing else. Russ -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:57 To: CF-Talk Subject: Re: execute a DTS package via Stored Proc? Yea, that's been my problem. I am the SA on my dev server, but I'm not going to be when this goes into production. I have about 5 solutions in front of me, all of which require certain degrees of Administrative power. Trying to figure out which is the one that will work when I go live is the hard part. I'll look into all these solutions this week. I certainly appreciate all the choices. Ray Snake wrote: Don't you have to be the SA in order to do exec master..xp_cmdshell @execcommand I don't remember the reasons, but I couldn't do it the easy way when I tried. I need to do it as a speciifc user who only had access to his own database. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:03 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? How do you mean? This will work if you have the correct settings in there no worries - granted it does not have any defensive stuff in their but if your DTS is say, a simple import - it will be job done. -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:15 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? If only it were that easy. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 13:40 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? Holy sh*^seriously long winded when this will do.. DECLARE @execcommand varchar(100) select @execcommand = 'dtsrun /Syourserver /Uusername /Ppassword /Npackagename'' exec master..xp_cmdshell @execcommand :-) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247606 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Automatically Restart ODBC Service?
I have a scheduled task that stops and restarts the CF Services every morning at 4:00 AM. This was implemented to improve stability of CF a lng time ago, and worked flawlessly for a couple of years. After installing SQL Server Express a couple months ago, We have started having problems with the ODBC Service not restarting, even though we attempt to start it twice in our batch file. The end result is that the end users get an error message when they hit the intranet site saying a connection cannot be made to the database (I forget the exact wording). My question is, can I trap this error, and then run a batch file that attempts to start the service automatically? Or, perhaps it is time to remove the stop/restart script if 7.02 would not benefit from the stop/restart that 6.0 apparently benefitted from. CF 7.02 Win2K3 Server ** 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 ** ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247607 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with cflogoff tag
Try putting this in the logout file: cflogin/cflogincflogout I kow it looks strange - just try it. On 7/25/06, Lewis Billingsley [EMAIL PROTECTED] wrote: Sam, Thanks for your response. Here's the code for the login. The logoff is simply linking to a page that starts out with the cflogoff tag. That's it. The login works fine. The logoff does not. In order to log off, I have to close the browser. - Lewis -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247608 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: execute a DTS package via Stored Proc?
Cool...I'll check yours out first. Now, of course, I'm off to fight fires that always pop up at the worst possible times. Grrr... Snake wrote: Well the way I did worked for restricted user access. Where the user is DBO of his own database and nothing else. Russ -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:57 To: CF-Talk Subject: Re: execute a DTS package via Stored Proc? Yea, that's been my problem. I am the SA on my dev server, but I'm not going to be when this goes into production. I have about 5 solutions in front of me, all of which require certain degrees of Administrative power. Trying to figure out which is the one that will work when I go live is the hard part. I'll look into all these solutions this week. I certainly appreciate all the choices. Ray Snake wrote: Don't you have to be the SA in order to do exec master..xp_cmdshell @execcommand I don't remember the reasons, but I couldn't do it the easy way when I tried. I need to do it as a speciifc user who only had access to his own database. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:03 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? How do you mean? This will work if you have the correct settings in there no worries - granted it does not have any defensive stuff in their but if your DTS is say, a simple import - it will be job done. -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:15 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? If only it were that easy. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 13:40 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? Holy sh*^seriously long winded when this will do.. DECLARE @execcommand varchar(100) select @execcommand = 'dtsrun /Syourserver /Uusername /Ppassword /Npackagename'' exec master..xp_cmdshell @execcommand :-) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247609 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cflogoff Problem
Sam, I cleaned up the code, below. The logoff is simply linking to a page that starts out with the cflogout tag. Thatâs it. The login works fine. The logoff does not. In order to log off, I have to close the browser. Hereâs the code for the login. This page is included in application.cfc. - Lewis CFLOGIN cfif NOT (IsDefined(Form.username) AND IsDefined(Form.Password)) cfinclude TEMPLATE=Grantee_Login2.cfm cfabort cfelse cfquery name = GetUser datasource=wdsc SELECT UserID, FirstName, Rights FROM MSFW_Passwords WHERE UserName = '#FORM.UserName#' AND Password = '#FORM.Password#' /cfquery cfif GetUser.REcordCount EQ 1 cfloginuser name=#GetUser.UserID#, #GetUser.FirstName# password=#form.password# roles=#GetUser.Rights# cfelse strongSorry, that user name and password are not recognized. Please try again./strong cfinclude template=Grantee_Login2.cfm cfabort /cfif /cfif /CFLOGIN ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247610 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Automatically Restart ODBC Service?
On Tuesday 25 July 2006 15:23, Claremont, Timothy wrote: My question is, can I trap this error, and then run a batch file that attempts to start the service automatically? With CFTRY/CFCATCH yeah, then cfexecute your start script. Weather this will help or not, rather than finding out what is wrong, I dunno :-) -- Tom Chiverton 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247611 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: copy sql table with indexes
http://www.red-gate.com/products/SQL_Compare/index.htm We use this and works like a charm. Eric J. Hoffman Managing Partner 2081 Industrial Blvd StillwaterMN55082 mail: [EMAIL PROTECTED] www: http://www.ejhassociates.com tel: 651.717.4105 fax: 651.717.4115 mob: 651.245.2717 This message contains confidential information and is intended only for [EMAIL PROTECTED] If you are not cf-talk@houseoffusion.com you should not disseminate, distribute or copy this e-mail. Please notify [EMAIL PROTECTED] immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Eric J. Hoffman therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247612 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with cflogoff tag
Thanks James. I have a cleaned up verson of the file in more recent posting. I replaced my cflogout with your suggestion. Still doesn't work. My application.cfc does not enable session management or specify login storage, as I did when I used application.cfm. Do I need to do either of those? Try putting this in the logout file: cflogin/cflogincflogout I kow it looks strange - just try it. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247613 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Automatically Restart ODBC Service?
There are two things I do not catch: first, why do you need ODBC with CF7, secondly, AFAIK, stopping the CF server does not affect ODBC. So, are you actually meaning JDBC service? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247614 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SOT: Web Host that supports emails aliases that point to multiple email addresses
All: I apologize in advance for the non-CF-related question... I provide technical support, advice, etc. to a local non-profit that uses Earthlink as their current website host. The organization sends a few mass emails a week to its members but Earthlink essentially turns off their ability to send outgoing email for several hours after one of these mass emails are sent (their nod to Spam-blocking). They are either unwilling or unable to deactivate this feature. So, I am looking for a new web/email host for them. The site is 100% HTML, so CF-support is not needed. The big thing that it must support is the ability to create email aliases that can redirect email to multiple recipients (i.e., [EMAIL PROTECTED] would relay the message to all members of the board of directors). And, of course, the basics: FTP access, multiple email accounts, multiple email aliases, etc. Also, being a non-profit, the cheaper the better. But I would rather go with a more expensive but more reliable host than a less expensive but less reliable host. Any suggestions? TIA -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247615 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFeclipse Task List
After reading this article http://www.fusionauthority.com/Reviews/4619-CFEclipse-Features-Task-List.htm I thought I would try this out. I am on 1.2 cfeclipse with RDS plugin and 3.1 eclipse. But I can't get this to work. I create the comment with TODO: and then press save to save to file. I don't see anything show up in the task list. I also tried closing the file and then opening backup, but not luck there either. Any suggestions? David ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247616 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Drag and drop select list with flash forms...
Rick Root wrote: Is it possible to make a select list using flash forms in CFMX that allows users to re-order the items via drag and drop? I've got an HTML solution right now that uses javascript but it's really considerably less friendly than I'd like it to be. I found this blog entry: http://blog.strikefish.com/blog/index.cfm?mode=entryentry=3EEE64B3-1422-201A-55F8F8ACFF40B8E7 (short url: http://url.rexroof.com/5954 ) Which could apply but I can't figure out how to get it to do whatI want to do rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247617 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFReport, IE, and active content problem
Okay, my earlier post about returning CFReport from a CFC came down to it just not working in IE. Silly me--I work on an IE-only app, so that is the first browser I try these days. I have to kind of float the cursor around to find the place to click to activate--to the user it just looks like a blank page. I'm not crazy about the fixes published on Macromedia/Adobe for the automatic execution of active content (this includes PDF and Flashpaper). I see that Flash player execution is fixed in CF7.0.2 (we haven't updated yet). Will this apply to PDF returned as well? Is there another way to fix this without updating? Thanks, Kris ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247618 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFReport, IE, and active content problem
On Tuesday 25 July 2006 16:36, Kris Jones wrote: I see that Flash player execution is fixed in CF7.0.2 (we haven't updated yet). Will this apply to PDF returned as well? Is there another way to fix this without updating? You just need to use a better HTML wrapper. There are CFML and JavaScript solutions out there, depending on what you want. -- Tom Chiverton 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247619 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem with cflogoff tag
yes I would specify the login storage and if you use session then session management must also be enabled. if you do use session after the login use cfdump var=#session#cfabort to see what the cflogin has stored in session scope. if all else fails you can just delete this stuff from session as your logout. personally I prefer to store my own user structure in session and then delete at logout, because I have found that the exact behaviour of cflogin in regards to the logout a bit hard to fathom. in particular the timeout of cflogin vs timeout of a session always seemed to be a problem for me so I stopped using it. probably just me :-) On 7/25/06, Lewis Billingsley [EMAIL PROTECTED] wrote: Thanks James. I have a cleaned up verson of the file in more recent posting. I replaced my cflogout with your suggestion. Still doesn't work. My application.cfc does not enable session management or specify login storage, as I did when I used application.cfm. Do I need to do either of those? Try putting this in the logout file: cflogin/cflogincflogout I kow it looks strange - just try it. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247620 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem with cflogoff tag
Oh well, the suggestion was based on pure superstition rather than science, so I'm not surprised it didn't work. Login storage defaults to Cookie, so neither of the things you mentioned are a must. On 7/25/06, Lewis Billingsley [EMAIL PROTECTED] wrote: Thanks James. I have a cleaned up verson of the file in more recent posting. I replaced my cflogout with your suggestion. Still doesn't work. My application.cfc does not enable session management or specify login storage, as I did when I used application.cfm. Do I need to do either of those? Try putting this in the logout file: cflogin/cflogincflogout I kow it looks strange - just try it. -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247621 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: copy sql table with indexes
We tried using that SQL Compare a few times... It works great, I agree, but just BE CAREFUL. We overwrote a bunch of data table accidentally when we trying to sync things up (and lost table structure changes). So again, it works great... But don't TEST on live data :) ... Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 x 14 212.691.3477 fax www.nylontechnology.com Some people call me the space cowboy. Some people call me the gangster of love. -Original Message- From: Eric J. Hoffman [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 10:44 AM To: CF-Talk Subject: RE: copy sql table with indexes http://www.red-gate.com/products/SQL_Compare/index.htm We use this and works like a charm. Eric J. Hoffman Managing Partner 2081 Industrial Blvd StillwaterMN55082 mail: [EMAIL PROTECTED] www: http://www.ejhassociates.com tel: 651.717.4105 fax: 651.717.4115 mob: 651.245.2717 This message contains confidential information and is intended only for [EMAIL PROTECTED] If you are not cf-talk@houseoffusion.com you should not disseminate, distribute or copy this e-mail. Please notify [EMAIL PROTECTED] immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Eric J. Hoffman therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247622 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFeclipse Task List
so you have a comment in a .cfm file looking like !--- TODO: comment --- right? In the task view there are some filtering options which can mask some comments. its on the top right of tasks view pane On 7/25/06, David Brown [EMAIL PROTECTED] wrote: After reading this article http://www.fusionauthority.com/Reviews/4619-CFEclipse-Features-Task-List.htm I thought I would try this out. I am on 1.2 cfeclipse with RDS plugin and 3.1 eclipse. But I can't get this to work. I create the comment with TODO: and then press save to save to file. I don't see anything show up in the task list. I also tried closing the file and then opening backup, but not luck there either. Any suggestions? David ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247623 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Problems with CFMAIL and Exchange 2003
Good afternoon all. We do not have a TLD at my place of employement. We have a new exchange server that works fine internally for the time being. What I'm having problems with is creating a basic web form and cfmail it via my exchange. It works fine with our public smtp server, but everytime I try to use exchange all the messages end up in the undeliverable folder. I'm stumped. Any help appreciated. Domain: dtc.domain.com (not a tld) Exchange: dtc-exchange.dtc.domain.com Exchange IP: 192.168.1.36 CF Server: 192.168.1.44 Exchange is setup to relay on authentication. I have even added CFServer IP to the allow list and still won't deliver. Email address: [EMAIL PROTECTED] I'm not a CF or Exchange pro, so any help is greatly appreciated. Terry This e-mail message and any attachments may be confidential, proprietary or privileged information. If you are not the intended recipient, or a person responsible for delivering it to an intended recipient, any unauthorized review, disclosure, use or distribution is prohibited. If you are an unintended recipient, please delete this information from your computer and contact Darien Telephone Co., immediately by replying to this message or by sending e-mail to [EMAIL PROTECTED] Thank you. -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.4/396 - Release Date: 7/24/2006 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247624 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with cflogoff tag
Wait, are you using a cflocation after your cflogout tag? If so, the cfauthorization cookie probably isn't being set properly. Swap over to session storage as one of the other posters suggested and you should be ok. On 7/26/06, James Holmes [EMAIL PROTECTED] wrote: Oh well, the suggestion was based on pure superstition rather than science, so I'm not surprised it didn't work. Login storage defaults to Cookie, so neither of the things you mentioned are a must. On 7/25/06, Lewis Billingsley [EMAIL PROTECTED] wrote: Thanks James. I have a cleaned up verson of the file in more recent posting. I replaced my cflogout with your suggestion. Still doesn't work. My application.cfc does not enable session management or specify login storage, as I did when I used application.cfm. Do I need to do either of those? Try putting this in the logout file: cflogin/cflogincflogout I kow it looks strange - just try it. -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247625 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: I just made a new CFC it has to with the classpath
Mark, Before you respond to something to should at least try to read the post and if you don't understand at least try to do the examples, use google or ask questions. Never sit back and throw up your hands. You are only a copy and paste away from trying the examples and you could not even do that. Google is a great place to do research and you showed me you can do it . You really wasted my time and everyone else's by not reading and not following up with questions and not doing the examples. Your grade is F. Get off he private / protected method thing I don't think that is happening anyway. I knew you where not reading anything, that's why I asked. Do the examples! On 7/25/06, Mark Mandel [EMAIL PROTECTED] wrote: Honestly, I couldn't understand what you were getting at in your examples, so I didn't read to far into them. In fact, more often than not, I really am not sure what you are trying to communicate. As far your examples that show calling private and protected methods, quite frankly I think that that is a relatively irresponsible way to develop, when you are breaking severe rules of a programming language. You are right, JavaLoader, or any other ClassLoader based system will not work when calling those methods, because they should not work, nor is there any reason for them to. Anyway, this conversation has gone on long enough, I think. Mark On 7/25/06, Dan Plesse [EMAIL PROTECTED] wrote: Mark, 95% of my post where scenarios in which the classes where not working using the javaloader.cfc. And I do all my work using this classpath.cfcas a foundation and nothing breaks. Did you at least try to run some of tests and see for yourself that the cfc was not working with the scenarios I listed? I provided you with three examples the forName() test, JDBC and JWS. How did they function on your computer and inside the datasource manager? Those are the scenarios which did not work. They are not small scenarios either. JDBC plays is a big part with Coldfusion. I also found out that the classes persist without scoping. The cfc didn't have any persistance by deault which I think is good thing to have.. Dan -- E: [EMAIL PROTECTED] W: www.compoundtheory.com ICQ: 3094740 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247626 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: copy sql table with indexes
I was considering using this: http://www.teratrax.com/tdc/ Terratrax database compare. Has anyone used them in the past? Any opinions vs the red-gate product? Seems to be about half price... Russ -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 12:07 PM To: CF-Talk Subject: RE: copy sql table with indexes We tried using that SQL Compare a few times... It works great, I agree, but just BE CAREFUL. We overwrote a bunch of data table accidentally when we trying to sync things up (and lost table structure changes). So again, it works great... But don't TEST on live data :) ... Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 x 14 212.691.3477 fax www.nylontechnology.com Some people call me the space cowboy. Some people call me the gangster of love. -Original Message- From: Eric J. Hoffman [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 10:44 AM To: CF-Talk Subject: RE: copy sql table with indexes http://www.red-gate.com/products/SQL_Compare/index.htm We use this and works like a charm. Eric J. Hoffman Managing Partner 2081 Industrial Blvd StillwaterMN55082 mail: [EMAIL PROTECTED] www: http://www.ejhassociates.com tel: 651.717.4105 fax: 651.717.4115 mob: 651.245.2717 This message contains confidential information and is intended only for [EMAIL PROTECTED] If you are not cf-talk@houseoffusion.com you should not disseminate, distribute or copy this e-mail. Please notify [EMAIL PROTECTED] immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Eric J. Hoffman therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247627 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFeclipse Task List
Yes I have the TODO and I checked the filters. Right now the options are set to: Enabled Limit visible items to 100 show items of type: cfeclipse TODO task I have tried unchecking enabled, but still no luck. David so you have a comment in a .cfm file looking like !--- TODO: comment --- right? In the task view there are some filtering options which can mask some comments. its on the top right of tasks view pane On 7/25/06, David Brown [EMAIL PROTECTED] wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247628 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with cflogoff tag
Iâm not using cflocation. I just link to a page outside of the directory protected by cflogin. At the top of that page I have cflogout. And also, just for good measure, as a part of my testing, I put a cflogout tag at the sign-in form page, which is also outside of the protected directory. None of it matters. Iâm having another problem that may be not be related. If I have a file in a directory that Iâve bringing up in my browser for testing, then move the file to a different directory, then point my browser to the address of the old location, it brings the file up, even though the file is no longer there. I cleared my browser cache. Another developer tried it from his machine and it came up in his browser too. The server people told me that there was no server cache. Huh? Is that possible? And could it be related to this problem? I had already tried session storage before, but that was when I used application.cfm instead of the componant. Wait, are you using a cflocation after your cflogout tag? If so, the cfauthorization cookie probably isn't being set properly. Swap over to session storage as one of the other posters suggested and you should be ok. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247629 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using SQL profiler with cfqueryparam
I should have seen the solution eariler, or followed Nick's advice. The easy way to track long winded queries is the set the SQL profiler filter to include 'declare%' in the TextData field. The original query will be displayed, under the sp_prepexec, and then executed. So this query will execute exactly like further calls via the sp_exec statement (or dynamic SQL statement). Thanks Nick. --bj For the filter, I'm limiting my search to reads greater or equal to 5000. For the data columns, I'm selecting everything. For the events, I'm selecting Security Audit: Audit login, logout; Sessions: ExistingConnection; Stored Procedures: All; TSQL: SQL:BatchCompleted. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247630 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Problem with cflogoff tag
So does cfapplication still get processed (I'm not sure where it lives in your app architecture) for the page with cflogout? If not, adjust things so that it does and see what happens. :) Josh -Original Message- From: Lewis Billingsley [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 12:40 PM To: CF-Talk Subject: Re: Problem with cflogoff tag Iââ¬â¢m not using cflocation. I just link to a page outside of the directory protected by cflogin. At the top of that page I have cflogout. And also, just for good measure, as a part of my testing, I put a cflogout tag at the sign-in form page, which is also outside of the protected directory. None of it matters. Iââ¬â¢m having another problem that may be not be related. If I have a file in a directory that Iââ¬â¢ve bringing up in my browser for testing, then move the file to a different directory, then point my browser to the address of the old location, it brings the file up, even though the file is no longer there. I cleared my browser cache. Another developer tried it from his machine and it came up in his browser too. The server people told me that there was no server cache. Huh? Is that possible? And could it be related to this problem? I had already tried session storage before, but that was when I used application.cfm instead of the componant. Wait, are you using a cflocation after your cflogout tag? If so, the cfauthorization cookie probably isn't being set properly. Swap over to session storage as one of the other posters suggested and you should be ok. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247631 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Automatically Restart ODBC Service?
You should turn the ODBC service off and never go back to it. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247632 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Odd Query issue
I have a query today that stopped working with an invalid column error. The database did not change. Select statements work on it but not updates. Select * from jobs where job_id = 1 - works fine Update jobs set status = 0 where job_id = 1 - results in Invalid column name 'job_id'. Any ideas what would cause this to just start happening? Thanks, Scott ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247633 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Query issue between MX 6 and MX 7
I ran across an issue with queries in MX 6 and MX7, try this code in MX 6 and MX 7 and you get radically different results. Anyone know of a reason for this or is it a bug. I sent this to Adobe but got no response so maybe someone here can shed some light. Here is the code: cfset q = QueryNew(A,B,C,D,E) / cfloop index=i from=1 to=3 cfset queryaddRow(q, 1) / cfset querysetcell(q, a, 1) / cfset querysetcell(q, b, 2) / cfset querysetcell(q, c, 3) / /cfloop cfset queryaddcolumn(q, bb, arraynew(1)) / cfset qq = QueryNew(A,B,C,D,E) / cfloop index=i from=1 to=3 cfset queryaddRow(qq, 1) / cfset querysetcell(qq, a, 1) / cfset querysetcell(qq, b, 2) / cfset querysetcell(qq, c, 3) / /cfloop cfloop index=i from=1 to=3 cfset querysetcell(q, bb, qq, i) / /cfloop cfdump var=#q# Trevor Orr Summit Projects [EMAIL PROTECTED] 541.387.8883 x213 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247634 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with cflogoff tag
Thanks for responding Josh. This is a thing that confuses me. My book showed me how to set up an application.CFC file, but did not show cfapplication in the file, as it is in application.CFM. I then assumed that I didnât need cfapplication, maybe somehow ColdFusion took care of it. Iâll try it. Lewis So does cfapplication still get processed (I'm not sure where it lives in your app architecture) for the page with cflogout? If not, adjust things so that it does and see what happens. :) Josh ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247635 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query issue between MX 6 and MX 7
I assume what the radically different result you describe is that on CF 7, column C gets reverted to the empty string (from '3') when the second query is injected into column BB? Or is there something else? cheers, barneyb On 7/25/06, Trevor Orr [EMAIL PROTECTED] wrote: I ran across an issue with queries in MX 6 and MX7, try this code in MX 6 and MX 7 and you get radically different results. Anyone know of a reason for this or is it a bug. I sent this to Adobe but got no response so maybe someone here can shed some light. Here is the code: cfset q = QueryNew(A,B,C,D,E) / cfloop index=i from=1 to=3 cfset queryaddRow(q, 1) / cfset querysetcell(q, a, 1) / cfset querysetcell(q, b, 2) / cfset querysetcell(q, c, 3) / /cfloop cfset queryaddcolumn(q, bb, arraynew(1)) / cfset qq = QueryNew(A,B,C,D,E) / cfloop index=i from=1 to=3 cfset queryaddRow(qq, 1) / cfset querysetcell(qq, a, 1) / cfset querysetcell(qq, b, 2) / cfset querysetcell(qq, c, 3) / /cfloop cfloop index=i from=1 to=3 cfset querysetcell(q, bb, qq, i) / /cfloop cfdump var=#q# Trevor Orr -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247636 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problem with cflogoff tag
This is a thing that confuses me. My book showed me how to set up an application.CFC file, but did not show cfapplication in the file, as it is in application.CFM. I then assumed that I didnââ¬â¢t need cfapplication, maybe somehow ColdFusion took care of it. Iââ¬â¢ll try it. Lewis So does cfapplication still get processed (I'm not sure where it\ I'm jumping into the middle of this topic so forgive me if this has been answered before. With application.cfc that functionality of the old cfapplication... tag has been replaced with the 'this' scope of the CFC. Here is an example from one of my application.cfc files. cfcomponent cfscript This.name = Playground; This.clientmanagement = false; This.loginstorage = Session; This.sessionmanagement = True; This.sessiontimeout = #createtimespan(0,0,10,0)#; This.applicationtimeout = #createtimespan(5,0,0,0)#; /cfscript -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247637 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: execute a DTS package via Stored Proc?
Ravo's example works, I've been using that method for quite awhile now with no problems. One thing to note, I couldn't get this working until I set up a Non-SysAdmin job step proxy account. You can do this by selecting the properties of the SQL Server Agent then choosing the Job System tab. You have to un-select the Only users with SysAdmin privelages can execute CmdExec and ActiveScripting job steps and then enter an account. Do some Googling on this though, as it can be a security risk in some envrionments. Cool...I'll check yours out first. Now, of course, I'm off to fight fires that always pop up at the worst possible times. Grrr... Snake wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247638 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Odd Query issue
Maybe someone changed your datasource configuration. -- Joseph Lamoree On 25 Jul 2006, at 10:22, Scott Mulholland wrote: I have a query today that stopped working with an invalid column error. The database did not change. Select statements work on it but not updates. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247639 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ajaxcfc invalid reply from server
Even if no one has a clue what is causing my specific weird problem, I'm hoping someone out there knows how to see what is going on inside of the blasted CFC that ajaxcfc is calling to know what error is happening. You may have tried this, but what I do sometimes is to just call the CFC directly (from the browser). Or, use cfinvoke to call it. - This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247640 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Odd Query issue
Yeah, I checked that as well. Update is still allowed. I also queried the system tables by column name and the table does come back for column = 'job_id'. Very strange. -Original Message- From: Joseph Lamoree [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 2:01 PM To: CF-Talk Subject: Re: Odd Query issue Maybe someone changed your datasource configuration. -- Joseph Lamoree On 25 Jul 2006, at 10:22, Scott Mulholland wrote: I have a query today that stopped working with an invalid column error. The database did not change. Select statements work on it but not updates. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247641 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFReport, IE, and active content problem
I've checked resources at these sites: http://www.adobe.com/devnet/activecontent/ http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/overview/activating_activex.asp By better HTML wrapper do you mean change the way I'm calling the object, e.g., object, vs. embed? Since I am calling a CFReport tag, I don't have control over how that is returned. I'm unsure how I could call it from JS, as suggested on both Adobe and Microsoft, since it is server-side object creation. I do see that CF7.0.2 supposedly fixes the issue, and that there is a 7.0.1 hotfix that addresses it. However, because of config control here, I am not free to implement these updates/hotfixes. (Believe me, I'm asking for 7.0.2) Are there other CF solutions out there that I'm just not finding? Please elaborate. Thanks, Kris You just need to use a better HTML wrapper. There are CFML and JavaScript solutions out there, depending on what you want. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247642 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFeclipse Task List
Which 'resource' radio option is selected on the filters dialog? Mine is set to On any resource. Also, make sure you don't have any text in the Where description [contains|doesn't contain] option. I also have CFE 1.2 and it works for me, but I /don't/ have the RDS plugin installed. Maybe that's the culprit? -Original Message- From: David Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 10:37 AM Yes I have the TODO and I checked the filters. Right now the options are set to: Enabled Limit visible items to 100 show items of type: cfeclipse TODO task I have tried unchecking enabled, but still no luck. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247643 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFeclipse Task List
Same here On any resource and the Where description contains is blank. From what I can tell it should work unless I am missing something. I think I will install cfeclipse on another system without the rds plug in and see what happens. David Which 'resource' radio option is selected on the filters dialog? Mine is set to On any resource. Also, make sure you don't have any text in the Where description [contains|doesn't contain] option. I also have CFE 1.2 and it works for me, but I /don't/ have the RDS plugin installed. Maybe that's the culprit? -Original Message- From: David Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 10:37 AM Yes I have the TODO and I checked the filters. Right now the options are set to: Enabled Limit visible items to 100 show items of type: cfeclipse TODO task I have tried unchecking enabled, but still no luck. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247644 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem with cflogoff tag
Here is my application.cfc file now. Did I leave anything out? cfcomponent output=false cfset this.name=MSFWGrantees cfset this.sessionManagement=True cfset this.loginstorage=Session cfset this.sessiontimeout=createtimespan(0,0,10,0) cfset This.clientmanagement = false cfset This.applicationtimeout=createtimespan(5,0,0,0) cffunction name=onRequestStart returntype=boolean output=true cfset REQUEST.datasource=wdsc !--- Check to see if the user is logged in, if not force them to now --- cfinclude template=ForceUserLogin.cfm cfreturn true /cffunction /cfcomponent ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247645 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Cool feature I didn't know about
Most of you probably know this, but I thought I would share because I will use this all the time. How often do you need to output a total line at the bottom of a report? You probably do one of 2 things: 1) Increment a variable while outputting your query, or b) perform a query of queries. I found this trolling online and needed to share, lets say you have a query called 'getData' and a column named 'rev' and you needed a total. Just do this: #arraySum(getData['rev'])# You can use any array functions (avg, max, min) against a query column referenced like this. This seems a lot easier to read to me too! Chris Peterson ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247646 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: execute a DTS package via Stored Proc?
I know I'm probably barking up the wrong tree, but you could always /not/ use a DTS package. I know a lot of the stuff that DTS does can be done using stored procedures, or other fancy tricks. But it all depends on how complicated your DTS is. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 8:27 AM Cool...I'll check yours out first. Now, of course, I'm off to fight fires that always pop up at the worst possible times. Grrr... Snake wrote: Well the way I did worked for restricted user access. Where the user is DBO of his own database and nothing else. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247647 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ajaxcfc invalid reply from server
Yeah, thanks. I figured that out this morning. That helped a little bit, but now I still have other problems-- but they are my problems, not ajaxcfc issues. In my CFC I cfmodule a Fusebox fuseaction into a savecontent and return it. That works great when I use createobject to call my cfc, but my Fusebox application makes extensive use of cfhtmlhead which is dumping a ton of javascript at the top of the reply, which totally screws up the ajaxcfc engine because there is extra stuff appended to the top of the reply. I already tried cfcontent reset=Yes and that didn't seem to do anything, so I'm kind of stuck again. I also temporarily removed some try/catches in the ajaxcfc engine to see where my errors were occurring. I've noticed IE gives you the line number the error happened on, but if it is an included .js file, you may not realize the line number goes with THAT file. ~Brad -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 1:07 PM To: CF-Talk Subject: RE: ajaxcfc invalid reply from server Even if no one has a clue what is causing my specific weird problem, I'm hoping someone out there knows how to see what is going on inside of the blasted CFC that ajaxcfc is calling to know what error is happening. You may have tried this, but what I do sometimes is to just call the CFC directly (from the browser). Or, use cfinvoke to call it. - This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247649 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Programmically ending a CF application?
How can one 'end' a CF application so that the OnApplicationStart method of an application.cfc will run again? Something better then the two options I've come up with? One, restarting the service. And two setting the application timeout to 0. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247648 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: execute a DTS package via Stored Proc?
In most cases yes an SP will do, but DTS can be pretty complex and any large recordset manipulation should be done in the SQL server as ColdFusion is poor at large recordset processing. 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 -Original Message- From: Munson, Jacob [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tue Jul 25 19:36:12 2006 Subject: RE: execute a DTS package via Stored Proc? I know I'm probably barking up the wrong tree, but you could always /not/ use a DTS package. I know a lot of the stuff that DTS does can be done using stored procedures, or other fancy tricks. But it all depends on how complicated your DTS is. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 8:27 AM Cool...I'll check yours out first. Now, of course, I'm off to fight fires that always pop up at the worst possible times. Grrr... Snake wrote: Well the way I did worked for restricted user access. Where the user is DBO of his own database and nothing else. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247650 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cool feature I didn't know about
Good tip Chrisand using array notation you can avoid Evaluate() and ait makes assigning values to dynamically named variables much nicer 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 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247652 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Ajax and passing a #
I am getting an error Missing argument name.When using named parameters to a function, every parameter must have a name. Whenever one of my parameters contains a # , has anyone come across this and if so how did you get by it? Bob ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247651 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: ajaxcfc invalid reply from server
BTW, have you tried some of the cool developer plugins for Firefox? There's one call Firebug that will show you ajax traffic. Also, I'm not sure if this is part of a plugin I installed, or standard Firefox, but if you bring up the JS console, you can click on your error and it will open the correct file that fired the error, and scroll down and highlight the error (I think that's part of the Web Developer Toolbar). -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 12:36 PM Yeah, thanks. I figured that out this morning. That helped a little bit, but now I still have other problems-- but they are my problems, not ajaxcfc issues. In my CFC I cfmodule a Fusebox fuseaction into a savecontent and return it. That works great when I use createobject to call my cfc, but my Fusebox application makes extensive use of cfhtmlhead which is dumping a ton of javascript at the top of the reply, which totally screws up the ajaxcfc engine because there is extra stuff appended to the top of the reply. I already tried cfcontent reset=Yes and that didn't seem to do anything, so I'm kind of stuck again. I also temporarily removed some try/catches in the ajaxcfc engine to see where my errors were occurring. I've noticed IE gives you the line number the error happened on, but if it is an included .js file, you may not realize the line number goes with THAT file. -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 1:07 PM To: CF-Talk Subject: RE: ajaxcfc invalid reply from server Even if no one has a clue what is causing my specific weird problem, I'm hoping someone out there knows how to see what is going on inside of the blasted CFC that ajaxcfc is calling to know what error is happening. You may have tried this, but what I do sometimes is to just call the CFC directly (from the browser). Or, use cfinvoke to call it. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247653 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF Ajax and passing a #
Let me get this straight...your parameter name has a '#' in it? Won't that cause problems with ColdFusion, unless it's escaped? Or do you mean the value your passing back has a '#'? If that's the case, maybe you need to use jsstringformat(). -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 12:45 PM I am getting an error Missing argument name.When using named parameters to a function, every parameter must have a name. Whenever one of my parameters contains a # , has anyone come across this and if so how did you get by it? This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247654 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cool feature I didn't know about
Also, it's nifty to do this in your SQL query and avoid the overhead in CF entirely, so long as your query is returning the desired rows. In MySQL it would be something like cfquery name=getData SELECT SUM(rev) AS revsum, MAX(rev) AS revmax, MIN(rev) AS revmin, othercolumns FROM table WHERE whereclause /cfquery Then on your cf page, #getData.revsum#, #getData.revmax#, #getData.revmin# will give you the desired output. -- Josh - Original Message - From: Peterson, Chris [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, July 25, 2006 11:34 AM Subject: Cool feature I didn't know about Most of you probably know this, but I thought I would share because I will use this all the time. How often do you need to output a total line at the bottom of a report? You probably do one of 2 things: 1) Increment a variable while outputting your query, or b) perform a query of queries. I found this trolling online and needed to share, lets say you have a query called 'getData' and a column named 'rev' and you needed a total. Just do this: #arraySum(getData['rev'])# You can use any array functions (avg, max, min) against a query column referenced like this. This seems a lot easier to read to me too! Chris Peterson ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247655 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cool feature I didn't know about
Examples? Sometimes I hate using evaluate but I sometimes cannot see a way around it! 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 -Original Message- From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tue Jul 25 19:45:33 2006 Subject: Re: Cool feature I didn't know about Good tip Chrisand using array notation you can avoid Evaluate() and ait makes assigning values to dynamically named variables much nicer 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 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247656 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cool feature I didn't know about
Not true all the time, it can however have overhead in SQL, a SUM function at the DB, on a say a bad index can have huge consquences. 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 -Original Message- From: Josh Nathanson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tue Jul 25 19:53:23 2006 Subject: Re: Cool feature I didn't know about Also, it's nifty to do this in your SQL query and avoid the overhead in CF entirely, so long as your query is returning the desired rows. In MySQL it would be something like cfquery name=getData SELECT SUM(rev) AS revsum, MAX(rev) AS revmax, MIN(rev) AS revmin, othercolumns FROM table WHERE whereclause /cfquery Then on your cf page, #getData.revsum#, #getData.revmax#, #getData.revmin# will give you the desired output. -- Josh - Original Message - From: Peterson, Chris [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, July 25, 2006 11:34 AM Subject: Cool feature I didn't know about Most of you probably know this, but I thought I would share because I will use this all the time. How often do you need to output a total line at the bottom of a report? You probably do one of 2 things: 1) Increment a variable while outputting your query, or b) perform a query of queries. I found this trolling online and needed to share, lets say you have a query called 'getData' and a column named 'rev' and you needed a total. Just do this: #arraySum(getData['rev'])# You can use any array functions (avg, max, min) against a query column referenced like this. This seems a lot easier to read to me too! Chris Peterson ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247657 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cool feature I didn't know about
You probably do one of 2 things: 1) Increment a variable while outputting your query, or b) perform a query of queries. Just do this: #arraySum(getData['rev'])# You can use any array Awesome tip, Chris- thanks for sharing. Already started replacing QofQs I had with SELECT sum(). Definitely a good entry in the CF-cookbook. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247658 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Ajax and passing a #
Do you know the line that is causing the error... Can you post some code? ... Ben Nadel www.bennadel.com -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 2:45 PM To: CF-Talk Subject: CF Ajax and passing a # I am getting an error Missing argument name.When using named parameters to a function, every parameter must have a name. Whenever one of my parameters contains a # , has anyone come across this and if so how did you get by it? Bob ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247659 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Odd Query issue
Can you actually post the CFQuery codes so we can see if maybe there is something you are not seeing. ... Ben Nadel www.bennadel.com -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 1:23 PM To: CF-Talk Subject: Odd Query issue I have a query today that stopped working with an invalid column error. The database did not change. Select statements work on it but not updates. Select * from jobs where job_id = 1 - works fine Update jobs set status = 0 where job_id = 1 - results in Invalid column name 'job_id'. Any ideas what would cause this to just start happening? Thanks, Scott ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247660 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Programmically ending a CF application?
What are you trying to accomplish in the long run? Maybe there is a different route to take? ... Ben Nadel www.bennadel.com -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 2:35 PM To: CF-Talk Subject: Programmically ending a CF application? How can one 'end' a CF application so that the OnApplicationStart method of an application.cfc will run again? Something better then the two options I've come up with? One, restarting the service. And two setting the application timeout to 0. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247661 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Cool feature I didn't know about
Word up, I didn't know that. That is a hi-quality tip :) ... Ben Nadel www.bennadel.com -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 2:34 PM To: CF-Talk Subject: Cool feature I didn't know about Most of you probably know this, but I thought I would share because I will use this all the time. How often do you need to output a total line at the bottom of a report? You probably do one of 2 things: 1) Increment a variable while outputting your query, or b) perform a query of queries. I found this trolling online and needed to share, lets say you have a query called 'getData' and a column named 'rev' and you needed a total. Just do this: #arraySum(getData['rev'])# You can use any array functions (avg, max, min) against a query column referenced like this. This seems a lot easier to read to me too! Chris Peterson ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247662 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Cool feature I didn't know about
Wouldn't these functions be applied to the result set that is already picked (after looking through the index, etc to find the proper rows). In that case, I don't see how the aggregate functions are affected by the index. Russ -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson- [EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 2:37 PM To: CF-Talk Subject: Re: Cool feature I didn't know about Not true all the time, it can however have overhead in SQL, a SUM function at the DB, on a say a bad index can have huge consquences. 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 -Original Message- From: Josh Nathanson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tue Jul 25 19:53:23 2006 Subject: Re: Cool feature I didn't know about Also, it's nifty to do this in your SQL query and avoid the overhead in CF entirely, so long as your query is returning the desired rows. In MySQL it would be something like cfquery name=getData SELECT SUM(rev) AS revsum, MAX(rev) AS revmax, MIN(rev) AS revmin, othercolumns FROM table WHERE whereclause /cfquery Then on your cf page, #getData.revsum#, #getData.revmax#, #getData.revmin# will give you the desired output. -- Josh - Original Message - From: Peterson, Chris [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, July 25, 2006 11:34 AM Subject: Cool feature I didn't know about Most of you probably know this, but I thought I would share because I will use this all the time. How often do you need to output a total line at the bottom of a report? You probably do one of 2 things: 1) Increment a variable while outputting your query, or b) perform a query of queries. I found this trolling online and needed to share, lets say you have a query called 'getData' and a column named 'rev' and you needed a total. Just do this: #arraySum(getData['rev'])# You can use any array functions (avg, max, min) against a query column referenced like this. This seems a lot easier to read to me too! Chris Peterson ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247663 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Ajax and passing a ##
I am passing in a #, for instance it has to do with a teacher inputting an assignment, so she puts in Do #1-9 and then it throws the error I sent. I tried the function you sent but that is not working. Bob ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247665 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cool feature I didn't know about
Examples? Sometimes I hate using evaluate but I sometimes cannot see a way around it! cfset SuffixFieldName = hailNumSuffix_#hailNumPrefix# cfparam name=FORM.#SuffixFieldName# default= input type=text name=#SuffixFieldName# value=#FORM[SuffixFieldName]# 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 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247664 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Programmically ending a CF application?
I think setting your application timeout to 0 is the best. You don't have to do it programmatically through the cfapplication you have in your application.cfm. You could have a endApplication.cfm that simply has a cfapplication tag in it with the timeout set to 0 and that will timeout the app. Then redirect to a normal page and that will trigger the cfapplication in your application.cfm that will set the timeout back to normal. John -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 3:03 PM To: CF-Talk Subject: RE: Programmically ending a CF application? What are you trying to accomplish in the long run? Maybe there is a different route to take? Ben Nadel www.bennadel.com -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 2:35 PM To: CF-Talk Subject: Programmically ending a CF application? How can one 'end' a CF application so that the OnApplicationStart method of an application.cfc will run again? Something better then the two options I've come up with? One, restarting the service. And two setting the application timeout to 0. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247666 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cool feature I didn't know about
Yup, that's true, the db must be in good shape...can you elaborate on what you mean by a bad index? How about if there is no index on the aggregated column, what are the consequences there? Trying to learn more about dbs. Also, forgot to mention that in MySQL at least, you'll need to use GROUP BY on a column if you are using an aggregate function such as SUM. -- Josh - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, July 25, 2006 11:36 AM Subject: Re: Cool feature I didn't know about Not true all the time, it can however have overhead in SQL, a SUM function at the DB, on a say a bad index can have huge consquences. 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 -Original Message- From: Josh Nathanson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tue Jul 25 19:53:23 2006 Subject: Re: Cool feature I didn't know about Also, it's nifty to do this in your SQL query and avoid the overhead in CF entirely, so long as your query is returning the desired rows. In MySQL it would be something like cfquery name=getData SELECT SUM(rev) AS revsum, MAX(rev) AS revmax, MIN(rev) AS revmin, othercolumns FROM table WHERE whereclause /cfquery Then on your cf page, #getData.revsum#, #getData.revmax#, #getData.revmin# will give you the desired output. -- Josh - Original Message - From: Peterson, Chris [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, July 25, 2006 11:34 AM Subject: Cool feature I didn't know about Most of you probably know this, but I thought I would share because I will use this all the time. How often do you need to output a total line at the bottom of a report? You probably do one of 2 things: 1) Increment a variable while outputting your query, or b) perform a query of queries. I found this trolling online and needed to share, lets say you have a query called 'getData' and a column named 'rev' and you needed a total. Just do this: #arraySum(getData['rev'])# You can use any array functions (avg, max, min) against a query column referenced like this. This seems a lot easier to read to me too! Chris Peterson ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247667 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF Ajax and passing a ##
How are you seeing the error? It is a JavaScript error or a ColdFusion error? ... Ben Nadel www.bennadel.com -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 3:05 PM To: CF-Talk Subject: Re: CF Ajax and passing a ## I am passing in a #, for instance it has to do with a teacher inputting an assignment, so she puts in Do #1-9 and then it throws the error I sent. I tried the function you sent but that is not working. Bob ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247668 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF Ajax and passing a ##
I'm assuming you were talking to me. Did you try jsstringformat from CF, or JS? It's a CF function. -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 1:05 PM To: CF-Talk Subject: Re: CF Ajax and passing a ## I am passing in a #, for instance it has to do with a teacher inputting an assignment, so she puts in Do #1-9 and then it throws the error I sent. I tried the function you sent but that is not working. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247669 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: copy sql table with indexes
On 7/25/06, Russ [EMAIL PROTECTED] wrote: I was considering using this: http://www.teratrax.com/tdc/ Terratrax database compare. Has anyone used them in the past? Any opinions vs the red-gate product? Seems to be about half price... It looks like that only does the data portion of the transfer, not the schema. I think that is also the case with Red Gate's Data Compare...you would have to use their SQL Compare tool to do the schema first, or use the SQL Packager to just migrate. At least that is what I remember, it has been a while since I used them, but I do also give a big thumbs up to the Red Gate tools...but as Ben noted, they can be a little more powerful than you meant them to be if you aren't careful. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247670 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Programmically ending a CF application?
What are you trying to accomplish in the long run? Maybe there is a different route to take? During development, when changes have been made to code in the OnApplicationStart to end the current application so that the new code will run with the next request. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247671 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Cool feature I didn't know about
Chris, That is a wicked cool feature and I just did some experimenting with it: http://bennadel.com/index.cfm?dax=blog:167.view Do you have any idea why the [...] notation is required? I get errors when I do QUERY.Column. I draw a comparison to ValueList() which can take QUERY.Column ,but NOT QUERY[Column]. Very strange. Though maybe you would have some insight. Thanks ... Ben Nadel www.bennadel.com - Original Message - From: Peterson, Chris [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, July 25, 2006 11:34 AM Subject: Cool feature I didn't know about Most of you probably know this, but I thought I would share because I will use this all the time. How often do you need to output a total line at the bottom of a report? You probably do one of 2 things: 1) Increment a variable while outputting your query, or b) perform a query of queries. I found this trolling online and needed to share, lets say you have a query called 'getData' and a column named 'rev' and you needed a total. Just do this: #arraySum(getData['rev'])# You can use any array functions (avg, max, min) against a query column referenced like this. This seems a lot easier to read to me too! Chris Peterson ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247672 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Ajax and passing a ####
This is a coldfusion error, jssStringFormat does not fix this issue. Bob ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247673 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Programmically ending a CF application?
To handle such scenarios in my applications, my OnApplicationStart() method just turns around and calls the custom function (inside Application.cfc) called InitApplication()... Then when I make changes to my application, I just call that method directly and it re-initializes the application without actually ending it's session. Then you can send a flag in URLs. cffunction name=OnApplicationStart cfset InitApplication() / /cffunction cffunction name=OnRequestStart cfparam name=URL.InitApplication type=numeric default=0 / cfif URL.InitApplication cfset InitApplication() / /cfif /cffunction Not sure if it is the best way to go... But it works great for my purposes. ... Ben Nadel www.bennadel.com -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 3:37 PM To: CF-Talk Subject: RE: Programmically ending a CF application? What are you trying to accomplish in the long run? Maybe there is a different route to take? During development, when changes have been made to code in the OnApplicationStart to end the current application so that the new code will run with the next request. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247674 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cool feature I didn't know about
When I mean bad index I mean an index which has been left to fragment etc. You have to maintain indexes - simple creating them isn't job done. What could take 2 seconds on a good DB could take 5 mins to run on a shitty index. 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 -Original Message- From: Josh Nathanson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tue Jul 25 20:09:22 2006 Subject: Re: Cool feature I didn't know about Yup, that's true, the db must be in good shape...can you elaborate on what you mean by a bad index? How about if there is no index on the aggregated column, what are the consequences there? Trying to learn more about dbs. Also, forgot to mention that in MySQL at least, you'll need to use GROUP BY on a column if you are using an aggregate function such as SUM. -- Josh - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, July 25, 2006 11:36 AM Subject: Re: Cool feature I didn't know about Not true all the time, it can however have overhead in SQL, a SUM function at the DB, on a say a bad index can have huge consquences. 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 -Original Message- From: Josh Nathanson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tue Jul 25 19:53:23 2006 Subject: Re: Cool feature I didn't know about Also, it's nifty to do this in your SQL query and avoid the overhead in CF entirely, so long as your query is returning the desired rows. In MySQL it would be something like cfquery name=getData SELECT SUM(rev) AS revsum, MAX(rev) AS revmax, MIN(rev) AS revmin, othercolumns FROM table WHERE whereclause /cfquery Then on your cf page, #getData.revsum#, #getData.revmax#, #getData.revmin# will give you the desired output. -- Josh - Original Message - From: Peterson, Chris [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, July 25, 2006 11:34 AM Subject: Cool feature I didn't know about Most of you probably know this, but I thought I would share because I will use this all the time. How often do you need to output a total line at the bottom of a report? You probably do one of 2 things: 1) Increment a variable while outputting your query, or b) perform a query of queries. I found this trolling online and needed to share, lets say you have a query called 'getData' and a column named 'rev' and you needed a total. Just do this: #arraySum(getData['rev'])# You can use any array functions (avg, max, min) against a query column referenced like this. This seems a lot easier to read to me too! Chris Peterson ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247675 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cool feature I didn't know about
This will not work all the time though will it? You will never get rid of evaluate altogether? 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 -Original Message- From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tue Jul 25 20:06:58 2006 Subject: Re: Cool feature I didn't know about Examples? Sometimes I hate using evaluate but I sometimes cannot see a way around it! cfset SuffixFieldName = hailNumSuffix_#hailNumPrefix# cfparam name=FORM.#SuffixFieldName# default= input type=text name=#SuffixFieldName# value=#FORM[SuffixFieldName]# 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 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247676 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Programmically ending a CF application?
How can one 'end' a CF application so that the OnApplicationStart method of an application.cfc will run again? You can directly call onApplicationStart, I think. You could do this from within onRequestStart based on some flag value. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247677 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4