Re: Installing CFMX 7
Have you tried netstat to see what's using that port? systernals also has a tcp port monitoring utility you can try out as well... Phill B wrote: > Well I'm sad to say that this didn't work. Why would they make a > product that is so hard to install? I'm starting to regret the > upgrade. > > On 7/23/06, Mike Soultanian <[EMAIL PROTECTED]> wrote: >> I had that exact same problem. I'm not exactly sure what I did, but I >> know that the silent install helps things out... so... >> >> Uninstall your current version and do a silent install as described here: >> >> http://tinyurl.com/8g3dr >> >> then run the web connector. >> >> mike.. >> >> >> Phill B wrote: >>> So I got my upgrade to MX 7 and a new development server. Well I'm >>> trying to install it and Im having some trouble. >>> >>> I'm installing on a Windows 2003 server and IIS. The first issue is >>> the message that it installed but "the web server connectors did not >>> install successfully. One possible reason is that port 51011 is >>> blocked" >>> >>> Then when I try to use the "Web Server Configuration Tool" I get the >>> error "Could not connect to and jrun/coldfusion servers on host >>> localhost." >>> >>> Great. >>> >>> So, I found this on the adobe site >>> http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19575 >>> >>> Does this look like the right thing to do to fix the problem? I would >>> hate to go through all of that to find out it was the wrong path. Any >>> advice will be appreciated. >>> >>> Thanks guys >>> >> > > ~| 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:247728 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, The one of the areas in which classloaders don't work is JDBC and more importantly JDBC drivers types I - lV. Another area in which classloaders don't work is using JWS to create new classes at runtime. for example creating a new java embedded databases class using HSQLDB which is the default database for the other J2EE servers BEA and IBM WebSphere. The other issue is class persistence i.e. Classloader classes only exist on the page that loaded the class. The other issue was saving objects to disk. Did you try to work out any of these issues during your initial testing? Is this better? Which part confuses you? How can I help you understand? Please write down your questions below this line. Thank you. I thought we could just code talk but I guess not :( ~| 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:247727 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Installing CFMX 7
Well I'm sad to say that this didn't work. Why would they make a product that is so hard to install? I'm starting to regret the upgrade. On 7/23/06, Mike Soultanian <[EMAIL PROTECTED]> wrote: > I had that exact same problem. I'm not exactly sure what I did, but I > know that the silent install helps things out... so... > > Uninstall your current version and do a silent install as described here: > > http://tinyurl.com/8g3dr > > then run the web connector. > > mike.. > > > Phill B wrote: > > So I got my upgrade to MX 7 and a new development server. Well I'm > > trying to install it and Im having some trouble. > > > > I'm installing on a Windows 2003 server and IIS. The first issue is > > the message that it installed but "the web server connectors did not > > install successfully. One possible reason is that port 51011 is > > blocked" > > > > Then when I try to use the "Web Server Configuration Tool" I get the > > error "Could not connect to and jrun/coldfusion servers on host > > localhost." > > > > Great. > > > > So, I found this on the adobe site > > http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19575 > > > > Does this look like the right thing to do to fix the problem? I would > > hate to go through all of that to find out it was the wrong path. Any > > advice will be appreciated. > > > > Thanks guys > > > > ~| 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:247726 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 SQL Express datasource on CFMX 7
Wow, I posted this like a week ago! I figured it out... it had to do with SQL Express running on a random port rather than the standard 1433. Rick Steve Brownlee wrote: > Rick: > > Check out > http://www.orbwave.com/cfjboss/2006/04/connecting-coldfusion-to-sql-server.h > tml > > Walks you through step-by-step > > - Steve > >> -Original Message- >> From: Rick Root [mailto:[EMAIL PROTECTED] >> Sent: Monday, July 17, 2006 7:54 AM >> To: CF-Talk >> Subject: Problem with SQL Express datasource on CFMX 7 >> >> I'm running CFMX 7 Development edition on my local windows XP >> box with SQL Server 2005 Express Edition installed. >> >> I have enabled TCP/IP connectivity and mixed-mode >> authentication, but I can't seem to get a datasource set up. >> >> I've tried various versions of the "Server" in the DSN setup.. >> >> My computer's hostname is "RICK200607" >> >> using "RICK200607\SQLEXPRESS" causes: >> >> Connection verification failed for data source: cfmbb_mssql >> java.sql.SQLException: [Macromedia][SQLServer JDBC >> Driver][Macromedia][SQLServer JDBC Driver]The requested >> instance is either invalid or not running. >> The root cause was that: java.sql.SQLException: >> [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer >> JDBC Driver]The requested instance is either invalid or not running >> >> Using just "RICK200607" causes: >> >> Connection verification failed for data source: cfmbb_mssql >> java.sql.SQLException: [Macromedia][SQLServer JDBC >> Driver]Error establishing socket. Connection refused: connect >> The root cause was that: java.sql.SQLException: >> [Macromedia][SQLServer JDBC Driver]Error establishing socket. >> Connection refused: connect >> >> >> What's going on here? What am I doing wrong? >> >> Thanks! >> >> 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:247725 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 ####
You need to apply this fix : http://www.opensourcecf.com/1/2006/02/Security-Flaw-in-CFAJAX.cfm On 7/26/06, Robert Everland III <[EMAIL PROTECTED]> wrote: > 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:247724 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 SQL Express datasource on CFMX 7
Rick: Check out http://www.orbwave.com/cfjboss/2006/04/connecting-coldfusion-to-sql-server.h tml Walks you through step-by-step - Steve > -Original Message- > From: Rick Root [mailto:[EMAIL PROTECTED] > Sent: Monday, July 17, 2006 7:54 AM > To: CF-Talk > Subject: Problem with SQL Express datasource on CFMX 7 > > I'm running CFMX 7 Development edition on my local windows XP > box with SQL Server 2005 Express Edition installed. > > I have enabled TCP/IP connectivity and mixed-mode > authentication, but I can't seem to get a datasource set up. > > I've tried various versions of the "Server" in the DSN setup.. > > My computer's hostname is "RICK200607" > > using "RICK200607\SQLEXPRESS" causes: > > Connection verification failed for data source: cfmbb_mssql > java.sql.SQLException: [Macromedia][SQLServer JDBC > Driver][Macromedia][SQLServer JDBC Driver]The requested > instance is either invalid or not running. > The root cause was that: java.sql.SQLException: > [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer > JDBC Driver]The requested instance is either invalid or not running > > Using just "RICK200607" causes: > > Connection verification failed for data source: cfmbb_mssql > java.sql.SQLException: [Macromedia][SQLServer JDBC > Driver]Error establishing socket. Connection refused: connect > The root cause was that: java.sql.SQLException: > [Macromedia][SQLServer JDBC Driver]Error establishing socket. > Connection refused: connect > > > What's going on here? What am I doing wrong? > > Thanks! > > 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:247723 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 tag
If it's a CF page it's possible but not necessarily related to this issue. It means that the related java file is still in the cfclasses folder and is being served up. Which browser are you using and how is is set to check for new content in the page? If you clear your cache and revisit the page after logging out, do you still appear logged in? If you try a protected page, are you actually still logged in? On 7/26/06, Lewis Billingsley <[EMAIL PROTECTED]> wrote: > I'm not using . I just link to a page outside of the directory > protected by . At the top of that page I have . And > also, just for good measure, as a part of my testing, I put a 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:247722 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Able Commerce
The reason was that AC treats the two as distinct domains, instead of 2 subdomains from the same domain. The store key only works for one unless you have one specially made that works with both. Eric -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: Monday, 24 July 2006 12:35 To: CF-Talk Subject: Re: Able Commerce > They both point to the same directory. I didn't st it up, but I have > to work with it. The previous cart worked just fine with this. Ah, then you're right, there's no reason why that should not work. --- Mary Jo ~| 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:247721 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Able Commerce
Unfortunately we are stuck with what we have *grrr* I am having so much fun customizing this*grr* Eric -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Monday, 24 July 2006 12:30 To: CF-Talk Subject: Re: Able Commerce I'll back this up again. You could got with CFWebstore right now and save money, EVEN INCLUDING what you've already wasted on AC, after accounting for man-hours and what not. Make your argument to the powers that be. * Ken Ferguson 214.636.6126 * Josh Nathanson wrote: > Able Commerce CFMX version is basically a java app with some cfscript > tags wrapped around it. I think that was probably the easiest way for > them to push out a CF version of their "product". I took a look at it > (luckily they had a trial version) and dumped it immediately. It > sounds like you may be stuck with it, but let the powers that be know > you could probably have CFWebstore up and customized (it's $300) in > less time that you will be able to untangle the mess you're in with Able Commerce. > > -- Josh > > > > > - Original Message - > From: "Snake" <[EMAIL PROTECTED]> > To: "CF-Talk" > Sent: Monday, July 24, 2006 7:15 AM > Subject: RE: Able Commerce > > > >> I tend to agree. My brief look at it didn't give me a very good >> opinion either. I decided to steer well clear. >> >> >> >> -Original Message- >> From: Ken Ferguson [mailto:[EMAIL PROTECTED] >> Sent: 24 July 2006 15:02 >> To: CF-Talk >> Subject: Re: Able Commerce >> >> My only advice for working with AC is to run away, terribly fast. It >> is a total piece. I know you're looking for advice, so I will give you some. >> Chalk up what you've spent on it as a loss and ditch it immediately. >> If you really want a CF-based off-the-shelf packaged cart >> application, look into Cartweaver or CFWebstore... Getting out of bed >> with AC now is going to save you more money and frustration in the >> long run than it's going to cost you to write it off and go with >> something worth using. >> >> This is that one product that was SO BAD that I promised not only >> never to work with it again, but to make sure that every time I heard >> someone talk about it I would make absolutely sure that they knew how >> low my opinions of the software and the company actually are. The >> single year-long project I was on working with AC was a complete >> nightmare filled with hours of talking to the least helpful and least >> professional support personnel with whom I've ever had the bad >> fortune to speak. >> >> Of course, that's just my opinion... >> >> * >> Ken Ferguson >> 214.636.6126 >> * >> >> >> >> >> >> >> Eric Roberts wrote: >> >>> Anyone here ever customize an Able Commerce shopping cart? I am >>> installing this so that it can be inserted within the context of the >>> existing site (using the headers and left side navigation features >>> already present on the site, with that cart being the body of the >>> store section of the site) This site uses another package as a >>> content manager(not a very good one at that), but, unfortunately, we >>> need to work with what we have as they are not allowing us to do a >>> complete redo on the site. Any help on this would be >>> appreciated...or at >>> >> least if someone could point me to a good resource. >> >>> Able Commerce's tech support system sucks. Once you have it >>> installed (regardless if you have installed in the context of you >>> site or not), you are on your own, unless you want to pay 150/hr for >>> customization >>> >> support. >> >>> Needless to say, we won't be purchasing this ever again. When I >>> complained about this to their customer service, all I got was >>> attitude and how that is how their model is and that they are not >>> changing it. I have also had this same question on their forums for >>> the past 2-3 days and have not received a response from anyone. >>> Thanks in >>> >> advance! >> >>> Eric >>> >>> >>> >>> >> >> >> > > ~| 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:247720 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CLASSPATH CFC Verses ClassLoading summary
Bryan, Ok so classloaders can use createObject() and wrote: > > Brain, > > The debate ended last night and these are results of my tests. These > are facts! > > No debate, just facts. > > Dan > > > > On 7/24/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > > > > > CLASSPATH CFC Verses ClassLoading > > > > > > 1. You can use createObject() or > > 2. You can use new JDBC drivers for datasource administrator > > > 3. You can use JWS or dynamic classes at runtime > > > 4. You can deserialize objects from disk after serialization > > > 5. Works just like classes or jars on the classpath with no > > exceptions. > > > > > > > > > CLASSPATH CFC > > > http://www.cfide.org/add_jar_at_runtime.html > > > > Sorry Danbut are you asking anything in that postor just > > starting a > > debate? ;-) > > > > 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:247719 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 SQL Express datasource on CFMX 7
What does your JDBC URL look like? I think you have that part wrong. ~| 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:247718 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
Dan, I was trying to avoid saying this, but the reason I didn't look into you posts that deeply was because either (a) the English was so bad it was like having to solve a cryptic crossword or (b) you only half explained what your examples where and what the issue was behind it. I'm not saying you don't have a valid point, I just actually have no idea what it is because you convey yourself so poorly. The only reason I was able to find the java forum post that I posted was because I managed to piece together some small part of what you were trying to achieve from 10 or so emails you posted, and even then it was a challenge. Several times I stated I really didn't understand what you were saying: (1) 'I dunno if I'm missing some context -' (2) '> Clear? Not in the slightest.' (3) 'I'm sorry, but unless you can explain yourself better, this isn't making any sense to me at all.' (4) 'Yup, still no idea at all what you are talking about. Sorry. Can anyone else point out to me what I am missing?' (5) In fact, more often than not, I really am not sure what you are trying to communicate. So as you can see, more than once I have asked you to clarify your position, and every time that I have stated this I either get (a) ignored, (b) restated in the original format that made very little in the way of sense in the first place. As to the rest - from what I have been able to work out from your posts is that (a) they can be done via a different method, i.e. a ClassLoader (which several people have pointed out to you), or are such edge cases I've yet to see how you even reached them. This is why I ended up saying 'I think this conversation has gone on long enough'.. and now I've gone and added more to it. Regards, Mark On 7/26/06, Dan Plesse <[EMAIL PROTECTED]> wrote: > 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 -- 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:247717 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?
Well, that's kinda f'ed up, huh? Worked like a charm. Thanks for the heads-up. Snake wrote: > Login to the physical SQL server machine and run enterprise manager from > there. > And make sure the user your connecting with and setting up the DTS as is > the database user. > Even doing it as the SA I found it didn't work. > > > -Original Message- > From: Crow T. Robot [mailto:[EMAIL PROTECTED] > Sent: 25 July 2006 23:28 > To: CF-Talk > Subject: Re: execute a DTS package via Stored Proc? > > I saw that. Can you expand a little bit on what you mean? > > I guess I don't quite understand what you mean when you say: > > login as the DBO of the database I want to install the DTS on and do it from > there. Otherwise it will not run. > > I'm logged on as the DBO on my workstation, but? > > This seems simple, but I swear, I'm losing something in the translation. > > Snake wrote: >> U could be having the problem I mentioned in my blog post, where you >> have to login to remote server and set it all up from there. >> This was the problem I had initially. I used enterprise manager >> remotely to connect to the SQL server and setup the DTS, and it just did > nothing. >> -Original Message- >> From: Ray Champagne [mailto:[EMAIL PROTECTED] >> Sent: 25 July 2006 22:37 >> To: CF-Talk >> Subject: Re: execute a DTS package via Stored Proc? >> >> OK. So, I got Snake/PengoWorks' solution to work. Kind of. The >> script runs with no errors, but the DTS package doesn't actually do > anything. >> When I run the DTS from Enterprise Manager, it runs fine. But when I >> run the script from CF, no errors, nothing. >> >> Anybody have any pointers as to where to look next? I've checked my >> permissions, and they all seem to be fine, and no matter, I was under >> the impression that the SP would throw an error if there were permission > errors. >> ??? >> >> 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:247716 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Web Host that supports emails aliases that point to multiple email addresses
Typically 'aliases' are used forward to one email address and 'lists' are one to many. Is it possible that you used the wrong term with your host? Phil -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 10:03 AM To: CF-Talk Subject: 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:247715 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?
Login to the physical SQL server machine and run enterprise manager from there. And make sure the user your connecting with and setting up the DTS as is the database user. Even doing it as the SA I found it didn't work. -Original Message- From: Crow T. Robot [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 23:28 To: CF-Talk Subject: Re: execute a DTS package via Stored Proc? I saw that. Can you expand a little bit on what you mean? I guess I don't quite understand what you mean when you say: login as the DBO of the database I want to install the DTS on and do it from there. Otherwise it will not run. I'm logged on as the DBO on my workstation, but? This seems simple, but I swear, I'm losing something in the translation. Snake wrote: > U could be having the problem I mentioned in my blog post, where you > have to login to remote server and set it all up from there. > This was the problem I had initially. I used enterprise manager > remotely to connect to the SQL server and setup the DTS, and it just did nothing. > > -Original Message- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: 25 July 2006 22:37 > To: CF-Talk > Subject: Re: execute a DTS package via Stored Proc? > > OK. So, I got Snake/PengoWorks' solution to work. Kind of. The > script runs with no errors, but the DTS package doesn't actually do anything. > When I run the DTS from Enterprise Manager, it runs fine. But when I > run the script from CF, no errors, nothing. > > Anybody have any pointers as to where to look next? I've checked my > permissions, and they all seem to be fine, and no matter, I was under > the impression that the SP would throw an error if there were permission errors. > > ??? > > 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:247714 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?
I saw that. Can you expand a little bit on what you mean? I guess I don't quite understand what you mean when you say: login as the DBO of the database I want to install the DTS on and do it from there. Otherwise it will not run. I'm logged on as the DBO on my workstation, but? This seems simple, but I swear, I'm losing something in the translation. Snake wrote: > U could be having the problem I mentioned in my blog post, where you have to > login to remote server and set it all up from there. > This was the problem I had initially. I used enterprise manager remotely to > connect to the SQL server and setup the DTS, and it just did nothing. > > -Original Message- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: 25 July 2006 22:37 > To: CF-Talk > Subject: Re: execute a DTS package via Stored Proc? > > OK. So, I got Snake/PengoWorks' solution to work. Kind of. The script > runs with no errors, but the DTS package doesn't actually do anything. > When I run the DTS from Enterprise Manager, it runs fine. But when I run > the script from CF, no errors, nothing. > > Anybody have any pointers as to where to look next? I've checked my > permissions, and they all seem to be fine, and no matter, I was under the > impression that the SP would throw an error if there were permission errors. > > ??? > > 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:247712 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 saw that. Can you expand a little bit on what you mean? I guess I don't quite understand what you mean when you say: login as the DBO of the database I want to install the DTS on and do it from there. Otherwise it will not run. I'm logged on as the DBO on my workstation, but? This seems simple, but I swear, I'm losing something in the translation. Snake wrote: > U could be having the problem I mentioned in my blog post, where you have to > login to remote server and set it all up from there. > This was the problem I had initially. I used enterprise manager remotely to > connect to the SQL server and setup the DTS, and it just did nothing. > > -Original Message- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: 25 July 2006 22:37 > To: CF-Talk > Subject: Re: execute a DTS package via Stored Proc? > > OK. So, I got Snake/PengoWorks' solution to work. Kind of. The script > runs with no errors, but the DTS package doesn't actually do anything. > When I run the DTS from Enterprise Manager, it runs fine. But when I run > the script from CF, no errors, nothing. > > Anybody have any pointers as to where to look next? I've checked my > permissions, and they all seem to be fine, and no matter, I was under the > impression that the SP would throw an error if there were permission errors. > > ??? > > 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:247713 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?
Indeed, one of the quirks of it is it has to be all setup locally to the host server. "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: Snake <[EMAIL PROTECTED]> To: CF-Talk Sent: Tue Jul 25 23:11:56 2006 Subject: RE: execute a DTS package via Stored Proc? U could be having the problem I mentioned in my blog post, where you have to login to remote server and set it all up from there. This was the problem I had initially. I used enterprise manager remotely to connect to the SQL server and setup the DTS, and it just did nothing. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 22:37 To: CF-Talk Subject: Re: execute a DTS package via Stored Proc? OK. So, I got Snake/PengoWorks' solution to work. Kind of. The script runs with no errors, but the DTS package doesn't actually do anything. When I run the DTS from Enterprise Manager, it runs fine. But when I run the script from CF, no errors, nothing. Anybody have any pointers as to where to look next? I've checked my permissions, and they all seem to be fine, and no matter, I was under the impression that the SP would throw an error if there were permission errors. ??? 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:247711 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?
U could be having the problem I mentioned in my blog post, where you have to login to remote server and set it all up from there. This was the problem I had initially. I used enterprise manager remotely to connect to the SQL server and setup the DTS, and it just did nothing. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 22:37 To: CF-Talk Subject: Re: execute a DTS package via Stored Proc? OK. So, I got Snake/PengoWorks' solution to work. Kind of. The script runs with no errors, but the DTS package doesn't actually do anything. When I run the DTS from Enterprise Manager, it runs fine. But when I run the script from CF, no errors, nothing. Anybody have any pointers as to where to look next? I've checked my permissions, and they all seem to be fine, and no matter, I was under the impression that the SP would throw an error if there were permission errors. ??? 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:247710 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: Web Host that supports emails aliases that point to multiple email addresses
We call those MRA - multiple recipient accounts on our system. You can have up to a hundred of them, each wtih up to a hundred addresses. You can set them up yourself through the control panel and there's no need for any reference to support people for them. Have a look at http://afpwebworks.com click on hosting. Oh and you get CFMX7 along with it whether you like it or not. Also ..asp and php4 and php5 Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 7/26/06, Mosh Teitelbaum <[EMAIL PROTECTED]> wrote: > 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:247709 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?
Ok, so maybe I should have run it in Query Analyzer first. it's failing for some reason, so please ignore the last post(s). Ray Champagne wrote: > Yea, the procedure that is explained here: > > http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS > > traps any errors. I am using this exact code, pretty much cut and > pasted, with the server and password changed. > > > > Robertson-Ravo, Neil (RX) wrote: >> Are you error trapping in your SP? Try/catch in the SQL? >> >> What code are you using? >> -- ~~~ Ray Champagne :: [EMAIL PROTECTED] ~~~ ~| 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:247708 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?
Yea, the procedure that is explained here: http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS traps any errors. I am using this exact code, pretty much cut and pasted, with the server and password changed. Robertson-Ravo, Neil (RX) wrote: > Are you error trapping in your SP? Try/catch in the SQL? > > What code are you using? > > > > > > > > "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: Ray Champagne <[EMAIL PROTECTED]> > To: CF-Talk > Sent: Tue Jul 25 22:37:07 2006 > Subject: Re: execute a DTS package via Stored Proc? > > OK. So, I got Snake/PengoWorks' solution to work. Kind of. The script > runs with no errors, but the DTS package doesn't actually do anything. > When I run the DTS from Enterprise Manager, it runs fine. But when I > run the script from CF, no errors, nothing. > > Anybody have any pointers as to where to look next? I've checked my > permissions, and they all seem to be fine, and no matter, I was under > the impression that the SP would throw an error if there were permission > errors. > > ??? > > 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:247707 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?
Are you error trapping in your SP? Try/catch in the SQL? What code are you using? "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: Ray Champagne <[EMAIL PROTECTED]> To: CF-Talk Sent: Tue Jul 25 22:37:07 2006 Subject: Re: execute a DTS package via Stored Proc? OK. So, I got Snake/PengoWorks' solution to work. Kind of. The script runs with no errors, but the DTS package doesn't actually do anything. When I run the DTS from Enterprise Manager, it runs fine. But when I run the script from CF, no errors, nothing. Anybody have any pointers as to where to look next? I've checked my permissions, and they all seem to be fine, and no matter, I was under the impression that the SP would throw an error if there were permission errors. ??? 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:247706 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?
OK. So, I got Snake/PengoWorks' solution to work. Kind of. The script runs with no errors, but the DTS package doesn't actually do anything. When I run the DTS from Enterprise Manager, it runs fine. But when I run the script from CF, no errors, nothing. Anybody have any pointers as to where to look next? I've checked my permissions, and they all seem to be fine, and no matter, I was under the impression that the SP would throw an error if there were permission errors. ??? 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:247705 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
Yes, I know what you were showing and it makes perfect sense for that example. I was just trying to show other ways to avoid the function that might be the best option for different scenarios. On 7/25/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > > > That way will work 99% of the time, there is almost always a way to > avoid > > using Evaluate() and SetVariable(). You can also do things like > > #Form["blah_#i#"]# only point that out since the > prior > > example might imply you would have to first do something like = > > "Blah_#I#" /> and then #Form[foo]# > > Well Aaron my example properly inits the value of the dynamically named > var...so > the way you go about things or what you're trying to accomplish will > determine > what you do with it. > > Ultimately the point is #Form["blah_#i#"]# replaces Evaluate() > > ~| 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:247704 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
So, I just tried doing this for fun... #qGirls.weight.getClass()# #qGirls["weight"].getClass()# Both output "class coldfusion.sql.QueryColumn" It looks like on the Java side of things, they are the same thing. It must be something on the CF side??? ... Ben Nadel www.bennadel.com -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 4:47 PM To: CF-Talk Subject: Re: Cool feature I didn't know about Sounds right as he is using Hungarian notation to notify a Query value. "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 Sent: Tue Jul 25 22:03:02 2006 Subject: Re: Cool feature I didn't know about Hey Ben, I'm not entirely sure, but this: qData.value is not an array and thus I suspect that's why it errors 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:247703 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
Sounds right as he is using Hungarian notation to notify a Query value. "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 Sent: Tue Jul 25 22:03:02 2006 Subject: Re: Cool feature I didn't know about Hey Ben, I'm not entirely sure, but this: qData.value is not an array and thus I suspect that's why it errors 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:247702 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
LOL, we luckily do not use the Euro :-) We are still good old pound sterling notes and pound sterling coins. Thread finished... How about that cool feature eh? "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: Ian Skinner <[EMAIL PROTECTED]> To: CF-Talk Sent: Tue Jul 25 21:54:18 2006 Subject: RE: Cool feature I didn't know about This is a pound: £ You yanks and your abuse of the Queens English :-) Now is that a pound as in a measure of weight (which is what we in the US mean by #. As in I would like to buy a 5# pot roast for dinner.) Or is it just the monetary pound you Brits supposedly don't use anymore, being part of the EU and all that. Ok, this is getting into CF-Community territory. -- 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:247701 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
Hey Ben, I'm not entirely sure, but this: qData.value is not an array and thus I suspect that's why it errors 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:247700 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 is a pound: £ You yanks and your abuse of the Queens English :-) Now is that a pound as in a measure of weight (which is what we in the US mean by #. As in I would like to buy a 5# pot roast for dinner.) Or is it just the monetary pound you Brits supposedly don't use anymore, being part of the EU and all that. Ok, this is getting into CF-Community territory. -- 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:247699 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
It's pretty interesting. I am happy that I know the difference exists... But I can image if I did not, it might lead to hours of head-wall-pounding :) ... Ben Nadel www.bennadel.com -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 4:44 PM To: CF-Talk Subject: RE: Cool feature I didn't know about .. But this Throws errors: They appear to be the same thing, but throw error simply on syntax?? I do not know the underpinnings of ColdFusion to know for sure, but I would guess it depends on the functions. These are functions after all, and functions except certain kinds of parameters. The funky thing here is that qData.value VS qData["value"] are parts of a complex variable a recordset. They are not the entire recordset which is qData, but they are not an individual datum in the recordset either, which would require a row designate, such as qData.value[1] or qData["value"][2]. I do not believe that a column of a recordset is an array in and of itself. So I suspect these functions have been written to read or convert a column into an array, but each one does it differently. -- 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:247698 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
Indeed, we had a discussion on this and I was for not using evaluate (others were) - though I am not 100% against it, I have never seen bad performance with it all in all. I believe back in the pre-Java/MX days there was more of a performance hit with evaluate when under heavy load. I've heard that this is not so as much in the current generation. But then I don't usually work with heavy user load applications. My work tends to be creating heavy system load large complex reports / applications for a few users rather then the other way around. -- 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:247697 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
Don't worry about the method, it is more the call within the arguments...
Anyway, cheers guys, I hear my Xbox calling
:)
"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: Aaron Rouse <[EMAIL PROTECTED]>
To: CF-Talk
Sent: Tue Jul 25 21:12:56 2006
Subject: Re: Cool feature I didn't know about
I have not messed with GetMetaDAta much but I'd imagine
GetMetaData(Instance[Arguments.MethodName]) would work. I ran into a case
not too long ago when I had to use evalutate for some method calls but it
was because I was trying to stay in cfscript, had I been using a cfinvoke I
am pretty sure I could have avoided it.
Typically anytime you are doing Evaluate("something." & somethingelse) you
can avoid Evaluate() via using what I always refered to as the structure
bracket notation. Of course this could get into a long drawn out debate on
whether avoiding Evaluate() is even worth it now days in MX. I just avoid
it out of habbit and style choice more than anything else these days.
On 7/25/06, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]>
wrote:
>
> Will have to dig in my code - I suppose the question to the gurus etc is
> can you 100% dispose of using evaluate?
>
> One example I think I have is
>
> GetMetaData(evaluate('instance.' & arguments.methodName))
>
> Or
>
> evaluate('attributesStruct.#attributeName#')
>
>
>
>
>
>
>
>
>
>
>
> "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: Aaron Rouse <[EMAIL PROTECTED]>
> To: CF-Talk
> Sent: Tue Jul 25 20:50:39 2006
> Subject: Re: Cool feature I didn't know about
>
> Any examples of where you could not see a way around it?
>
>
> That is a neat trick with the ArraySum although I'd guess the number would
> be all out of whack if you are doing grouped(CF not SQL) output.
>
>
> On 7/25/06, Robertson-Ravo, Neil (RX) <
> [EMAIL PROTECTED]>
> wrote:
> >
> > Examples? Sometimes I hate using evaluate but I sometimes cannot see a
> way
> > around 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:247696
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
Yup, that is what I mean, the columns getting an empty string. -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 10:35 AM To: CF-Talk Subject: 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: > > > > > > > > > > > > > > > > > > > > > > > > > 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:247695 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
I think you mean hash symbols (or gates) This is a pound: £ You yanks and your abuse of the Queens English :-) "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: Ian Skinner <[EMAIL PROTECTED]> To: CF-Talk Sent: Tue Jul 25 21:38:51 2006 Subject: RE: Cool feature I didn't know about Ultimately the point is #Form["blah_#i#"]# replaces Evaluate() And #form["blah_" & i]# cleans up the extra pound signs. :-) -- 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:247694 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
. But this Throws errors: They appear to be the same thing, but throw error simply on syntax?? I do not know the underpinnings of ColdFusion to know for sure, but I would guess it depends on the functions. These are functions after all, and functions except certain kinds of parameters. The funky thing here is that qData.value VS qData["value"] are parts of a complex variable a recordset. They are not the entire recordset which is qData, but they are not an individual datum in the recordset either, which would require a row designate, such as qData.value[1] or qData["value"][2]. I do not believe that a column of a recordset is an array in and of itself. So I suspect these functions have been written to read or convert a column into an array, but each one does it differently. -- 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:247693 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
Indeed, we had a discussion on this and I was for not using evaluate (others
were) - though I am not 100% against it, I have never seen bad performance
with it all in all.
"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: Aaron Rouse <[EMAIL PROTECTED]>
To: CF-Talk
Sent: Tue Jul 25 21:12:56 2006
Subject: Re: Cool feature I didn't know about
I have not messed with GetMetaDAta much but I'd imagine
GetMetaData(Instance[Arguments.MethodName]) would work. I ran into a case
not too long ago when I had to use evalutate for some method calls but it
was because I was trying to stay in cfscript, had I been using a cfinvoke I
am pretty sure I could have avoided it.
Typically anytime you are doing Evaluate("something." & somethingelse) you
can avoid Evaluate() via using what I always refered to as the structure
bracket notation. Of course this could get into a long drawn out debate on
whether avoiding Evaluate() is even worth it now days in MX. I just avoid
it out of habbit and style choice more than anything else these days.
On 7/25/06, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]>
wrote:
>
> Will have to dig in my code - I suppose the question to the gurus etc is
> can you 100% dispose of using evaluate?
>
> One example I think I have is
>
> GetMetaData(evaluate('instance.' & arguments.methodName))
>
> Or
>
> evaluate('attributesStruct.#attributeName#')
>
>
>
>
>
>
>
>
>
>
>
> "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: Aaron Rouse <[EMAIL PROTECTED]>
> To: CF-Talk
> Sent: Tue Jul 25 20:50:39 2006
> Subject: Re: Cool feature I didn't know about
>
> Any examples of where you could not see a way around it?
>
>
> That is a neat trick with the ArraySum although I'd guess the number would
> be all out of whack if you are doing grouped(CF not SQL) output.
>
>
> On 7/25/06, Robertson-Ravo, Neil (RX) <
> [EMAIL PROTECTED]>
> wrote:
> >
> > Examples? Sometimes I hate using evaluate but I sometimes cannot see a
> way
> > around 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:247692
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
Ultimately the point is #Form["blah_#i#"]# replaces Evaluate() And #form["blah_" & i]# cleans up the extra pound signs. :-) -- 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:247691 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
Bryan, its cool, I get that part... What I don't follow is why this works: But this Throws errors: They appear to be the same thing, but throw error simply on syntax?? ... Ben Nadel www.bennadel.com -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 4:18 PM To: CF-Talk Subject: Re: Cool feature I didn't know about Ben...you can go as far as referencing a column in a specific row of a query using the array notation 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:247690 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
> That way will work 99% of the time, there is almost always a way to avoid > using Evaluate() and SetVariable(). You can also do things like > #Form["blah_#i#"]# only point that out since the prior > example might imply you would have to first do something like "Blah_#I#" /> and then #Form[foo]# Well Aaron my example properly inits the value of the dynamically named var...so the way you go about things or what you're trying to accomplish will determine what you do with it. Ultimately the point is #Form["blah_#i#"]# replaces Evaluate() 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:247689 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
Well all I can say is I no longer use Evaluate() ...there may be some circumstances where it fails...but I haven't found it yet 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:247688 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
Ben...you can go as far as referencing a column in a specific row of a query using the array notation 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:247687 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
I have not messed with GetMetaDAta much but I'd imagine
GetMetaData(Instance[Arguments.MethodName]) would work. I ran into a case
not too long ago when I had to use evalutate for some method calls but it
was because I was trying to stay in cfscript, had I been using a cfinvoke I
am pretty sure I could have avoided it.
Typically anytime you are doing Evaluate("something." & somethingelse) you
can avoid Evaluate() via using what I always refered to as the structure
bracket notation. Of course this could get into a long drawn out debate on
whether avoiding Evaluate() is even worth it now days in MX. I just avoid
it out of habbit and style choice more than anything else these days.
On 7/25/06, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]>
wrote:
>
> Will have to dig in my code - I suppose the question to the gurus etc is
> can you 100% dispose of using evaluate?
>
> One example I think I have is
>
> GetMetaData(evaluate('instance.' & arguments.methodName))
>
> Or
>
> evaluate('attributesStruct.#attributeName#')
>
>
>
>
>
>
>
>
>
>
>
> "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: Aaron Rouse <[EMAIL PROTECTED]>
> To: CF-Talk
> Sent: Tue Jul 25 20:50:39 2006
> Subject: Re: Cool feature I didn't know about
>
> Any examples of where you could not see a way around it?
>
>
> That is a neat trick with the ArraySum although I'd guess the number would
> be all out of whack if you are doing grouped(CF not SQL) output.
>
>
> On 7/25/06, Robertson-Ravo, Neil (RX) <
> [EMAIL PROTECTED]>
> wrote:
> >
> > Examples? Sometimes I hate using evaluate but I sometimes cannot see a
> way
> > around 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:247686
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
One example I think I have is
GetMetaData(evaluate('instance.' & arguments.methodName))
Or
evaluate('attributesStruct.#attributeName#')
I would guess, but have not tested, that something like these would maybe
equivalent.
GetMetaData(instance[arguments.methodName])
attributesStruct[attributeName]
--
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:247685
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 sure about the GetMetaData() question, but the
evaluate('attributesStruct.#attributeName#') would be
scopeName['attributesStruct.' & attributeName] (where scopeName is
obviously whatever scope the variable resides in) :)
On 7/25/06, Robertson-Ravo, Neil (RX)
<[EMAIL PROTECTED]> wrote:
> Will have to dig in my code - I suppose the question to the gurus etc is
> can you 100% dispose of using evaluate?
>
> One example I think I have is
>
> GetMetaData(evaluate('instance.' & arguments.methodName))
>
> Or
>
> evaluate('attributesStruct.#attributeName#')
>
>
>
>
>
>
>
>
>
>
>
> "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: Aaron Rouse <[EMAIL PROTECTED]>
> To: CF-Talk
> Sent: Tue Jul 25 20:50:39 2006
> Subject: Re: Cool feature I didn't know about
>
> Any examples of where you could not see a way around it?
>
>
> That is a neat trick with the ArraySum although I'd guess the number would
> be all out of whack if you are doing grouped(CF not SQL) output.
>
>
> On 7/25/06, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]>
> wrote:
> >
> > Examples? Sometimes I hate using evaluate but I sometimes cannot see a way
> > around 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:247684
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
I suggest you get the 1.3 beta, seems to work there as well as the Web Standards Tools Which I belive if you go to Help > Software update > New Software > Callisto you should see it there HTH -Original Message- From: David Brown [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 19:24 To: CF-Talk Subject: 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:247683 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? Not altogether, but it is used much more often then necessary. The only occurrence I have not been able to eliminate it from is something like this. #evaluate(compareSTring)# -- 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:247682 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 can also do #attributesStruct[attributeName]# in a lot of cases.
> -Original Message-
> From: Robertson-Ravo, Neil (RX)
> Sent: Tuesday, July 25, 2006 1:43 PM
>
> Will have to dig in my code - I suppose the question to the
> gurus etc is
> can you 100% dispose of using evaluate?
>
> One example I think I have is
>
> GetMetaData(evaluate('instance.' & arguments.methodName))
>
> Or
>
> evaluate('attributesStruct.#attributeName#')
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:247681
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
Will have to dig in my code - I suppose the question to the gurus etc is
can you 100% dispose of using evaluate?
One example I think I have is
GetMetaData(evaluate('instance.' & arguments.methodName))
Or
evaluate('attributesStruct.#attributeName#')
"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: Aaron Rouse <[EMAIL PROTECTED]>
To: CF-Talk
Sent: Tue Jul 25 20:50:39 2006
Subject: Re: Cool feature I didn't know about
Any examples of where you could not see a way around it?
That is a neat trick with the ArraySum although I'd guess the number would
be all out of whack if you are doing grouped(CF not SQL) output.
On 7/25/06, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]>
wrote:
>
> Examples? Sometimes I hate using evaluate but I sometimes cannot see a way
> around 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:247680
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
That way will work 99% of the time, there is almost always a way to avoid using Evaluate() and SetVariable(). You can also do things like #Form["blah_#i#"]# only point that out since the prior example might imply you would have to first do something like and then #Form[foo]# On 7/25/06, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > > 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 > 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! > > > > > 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:247679 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
Any examples of where you could not see a way around it? That is a neat trick with the ArraySum although I'd guess the number would be all out of whack if you are doing grouped(CF not SQL) output. On 7/25/06, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > > Examples? Sometimes I hate using evaluate but I sometimes cannot see a way > around 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:247678 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
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 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! 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: 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 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" 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 > 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 > > > SELECT SUM(rev) AS revsum, MAX(rev) AS revmax, MIN(rev) AS revmin, > othercolumns FROM table WHERE whereclause > > > 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" > 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: 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. 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: 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: 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" > 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: 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: 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: 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: 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: 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" 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 > 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 > > > SELECT SUM(rev) AS revsum, MAX(rev) AS revmax, MIN(rev) AS revmin, > othercolumns FROM table WHERE whereclause > > > 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" > 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: 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 you have in your application.cfm. You could have a "endApplication.cfm" that simply has a 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 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: 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! 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: 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 > 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 > > > SELECT SUM(rev) AS revsum, MAX(rev) AS revmax, MIN(rev) AS revmin, > othercolumns FROM table WHERE whereclause > > > 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" > 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: 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: 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: 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: 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: 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 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 SELECT SUM(rev) AS revsum, MAX(rev) AS revmax, MIN(rev) AS revmin, othercolumns FROM table WHERE whereclause 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" 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
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 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
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 SELECT SUM(rev) AS revsum, MAX(rev) AS revmax, MIN(rev) AS revmin, othercolumns FROM table WHERE whereclause 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" 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: 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: 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 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
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: 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
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 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
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: 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 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
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
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: Problem with tag
Here is my application.cfc file now. Did I leave anything out? ~| 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
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: 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: 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: 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: 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
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: 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: Problem with tag
This is a thing that confuses me. My book showed me how to set up an application.CFC file, but did not show in the file, as it is in application.CFM. I then assumed that I didnââ¬â¢t need , maybe somehow ColdFusion took care of it. Iââ¬â¢ll try it. Lewis > So does 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 tag has been replaced with the 'this' scope of the CFC. Here is an example from one of my application.cfc files. 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)#"; -- 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: 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: > > > > > > > > > > > > > > > > > > > > > > > > > > > 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 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 in the file, as it is in application.CFM. I then assumed that I didnât need , maybe somehow ColdFusion took care of it. Iâll try it. Lewis > So does still get processed (I'm not sure where it > lives in your app architecture) for the page with ? 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
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: 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
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
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
RE: Problem with tag
So does still get processed (I'm not sure where it lives in your app architecture) for the page with ? 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 tag Iââ¬â¢m not using . I just link to a page outside of the directory protected by . At the top of that page I have . And also, just for good measure, as a part of my testing, I put a 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: 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 tag
Iâm not using . I just link to a page outside of the directory protected by . At the top of that page I have . And also, just for good measure, as a part of my testing, I put a 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
