RE: Las record
You also have the option.. of @@IDENTITY.. if you are SQL Server... and it autmatically incremented...can remember what it is on Oracle. Cfquery... insert into... whatever select @@IDENTITY as MAXID from tableName Joe -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 6:49 PM To: CF-Talk Subject: RE: Las record Different DB's provide different ways of doing this, but the only universal way I know of is this: Assuming the key is numeric and increments ascending: cftransaction cfquery... do the insert /cfquery cfquery... SELECT MAX(whateverID) as maxID FROM tablename /cfquery /cftransaction The transaction tags prevent another thread from doing an insert between the two queries and screwing up the SELECT MAX... statement. If the key is random then you likely are generating it in the code and already know it before the query is even run. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 2:49 PM To: CF-Talk Subject: Las record How do I get the Unique ID from the last field I inserted? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Link Buttons That I Control
Wouldn't it be easier to just make the link go to a page on your website that can then record the click, figure out where to go and then redirect to whereever you want to go? The downside to using the idea below is that it will slow down the original page from loading especially when your site gets busy. Al At 04:28 PM 9/18/2002 +0100, you wrote: I have just found this... and this is the kind of thing I am looking for a way of using Javascript to call a cfm file http://fuselets.com/cftips/index.html __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Jsp Vs Cfm (CFMX) -- Test Code
On Wednesday, September 18, 2002, at 07:44 PM, Joe Eugene wrote: instead of atypical test cases like looping a million times. I think it's more than equal in its competitiveness with other web application servers. The fact is, most business apps aren't doing the sorts of calculations that you're testing I think the point that Joe (and I) am trying to make is that while looping a million times is unrealistic, it does illustrate a problem -- the code is up to 80 times slower. Yes, you won't have any 1 - 1,000,000 loops in a typical cfm template, but you may have 100 concurrent users doing 1- 100 loops. So, every bit that you save on 1 user is multiplied 100 times (in this example). I think that Matt would agree that this can be a very important determination if an application, nay web site, scales well. Say for example, Victoria's Secret had a loop (or equivalent inefficient code) in their main cfm page -- when they do one of their Angel TV specials this (optimization) could make the difference whether the site could handle 100 concurrent hits or 10,000 -- or whether it reaches the point` where it is on the wrong side of the power curve and just eats itself up! Joe's point, and mine is that this is a factor that can contribute to the overall performance and scalability of a CF web site -- not the only factor, maybe not the most important factor, but an important factor, nonetheless! Geeze! I promised myself I wouldn't do this anymore! Dick __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Jsp Vs Cfm (CFMX) -- Test Code
Aw, 'cmon Ben, one of the great advantages of CF is it can address a broad range of applications -- all Joe wants do to is extend the range help MM sell into a broader range of solutions. Will MM get them all? --Never!.Can MM get more? All of us certainly hope so! What if optimizing the code made CF a viable option to 20% more of the market than they already have -- anyone of could sell the advantages of CF over JSP into that marketplace! Geeze, I did it again! Dick On Wednesday, September 18, 2002, at 07:47 PM, Ben Forta wrote: Some parts of your app should not be written in CF, no one has ever said otherwise. Similarly parts of your app should not be written in Java. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Jsp Vs Cfm (CFMX) -- Test Code
Dick, Oh, I agree. CF should keep getting better (and I believe it has been doing just that). My only point is that they'll always be a better way to do something, whether it is a small piece of code or a complex process, and whenever that is the case the solution is to use the right add-on or extension technology. Fact of the matter is that CF has supported extensions ever since the CFX API was added way back in CF2. Then came COM, CORBA, Java, etc. All along there has been an understanding - CF cannot be the best at everything, nor can any other language or technology or platform. So, yep, suggestions on how to improve CF are useful, and we'll keep doing just that. Just don't expect CF to do it all, it can't and frankly it shouldn't. --- Ben -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 11:14 PM To: CF-Talk Subject: Re: Jsp Vs Cfm (CFMX) -- Test Code Aw, 'cmon Ben, one of the great advantages of CF is it can address a broad range of applications -- all Joe wants do to is extend the range help MM sell into a broader range of solutions. Will MM get them all? --Never!.Can MM get more? All of us certainly hope so! What if optimizing the code made CF a viable option to 20% more of the market than they already have -- anyone of could sell the advantages of CF over JSP into that marketplace! Geeze, I did it again! Dick On Wednesday, September 18, 2002, at 07:47 PM, Ben Forta wrote: Some parts of your app should not be written in CF, no one has ever said otherwise. Similarly parts of your app should not be written in Java. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Returning columns with null values when specific columns are unknown at runtime
Issac, I hope you understand that CURSORS are not the FASTEST thing in SQL Server.. i have personally written many cursors apps to do BATCH Processing.. but i wouldnt recommend SQL Server Cursors for a REAL TIME processing.. Well in Oracle its a different Story... Depends on the DB. I agree T-SQL in cfquery doesnt look clean.. but for this situation... i think it will run faster. The other option would an SP that takes a string of columns names and do while loop constructing the query and then run it with Exec/sp_executeSql(@sqlStmt) or some like that... (Dynamic query SP's .. i like them) Joe -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:08 PM To: CF-Talk Subject: Re: Returning columns with null values when specific columns are unknown at runtime Why do u have to do the below... u can contruct the SQL in CF and just pass it. select * from TableName where 1=0 This gives you Query.ColumnList.. now.. all you got to do is loop through the Query.ColumnList and Dynamically build the CASE Statement for the Query cfquery ... declare @fields varchar(200) set @fields=''; select cfloop index=x list=#Query.ColumnList# delimiter=, @fields=@fields + CASE WHEN #x# IS NULL THEN '#x#' END, /cfloop from TableName select @fields as ColumnName /cfquery Havent tested this.. but something of this sort might be easier. Joe It encapsulates the function so that if she needs to use it elsewhere in the app or on another table, it's faster and easier to implement than cutting and pasting ... more portable, etc... I suspect it's also more efficient and generally speaking I dislike using multiple t-sql statements in cfqueries... although this last is probably just a personal prejudice -- it just looks bad to me... Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Jsp Vs Cfm (CFMX) -- Test Code
At 11:17 PM 9/18/2002 -0400, Ben Forta wrote: So, yep, suggestions on how to improve CF are useful, and we'll keep doing just that. Just don't expect CF to do it all, it can't and frankly it shouldn't. --- Ben Yet C'mon Ben! :) ~Todd Todd Rafferty ([EMAIL PROTECTED]) http://www.web-rat.com/ Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ Moderator @ FlashCFM.com - http://www.flashCFM.com/ Back-end Moderator @ Ultrashock.com - http://www.ultrashock.com/ __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Jsp Vs Cfm (CFMX) -- Test Code
Yea!!! thanks a lot Ben . We are looking forward to any improvements...and will defnitely brag on it.. when its out... Oh, I agree. CF should keep getting better (and I believe it has been doing just that). So, yep, suggestions on how to improve CF are useful, and we'll keep doing just that. Just don't expect CF to do it all, it can't and frankly it shouldn't. Dick, thanks again on your support... Joe -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 11:17 PM To: CF-Talk Subject: RE: Jsp Vs Cfm (CFMX) -- Test Code Dick, My only point is that they'll always be a better way to do something, whether it is a small piece of code or a complex process, and whenever that is the case the solution is to use the right add-on or extension technology. Fact of the matter is that CF has supported extensions ever since the CFX API was added way back in CF2. Then came COM, CORBA, Java, etc. All along there has been an understanding - CF cannot be the best at everything, nor can any other language or technology or platform. --- Ben -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 11:14 PM To: CF-Talk Subject: Re: Jsp Vs Cfm (CFMX) -- Test Code Aw, 'cmon Ben, one of the great advantages of CF is it can address a broad range of applications -- all Joe wants do to is extend the range help MM sell into a broader range of solutions. Will MM get them all? --Never!.Can MM get more? All of us certainly hope so! What if optimizing the code made CF a viable option to 20% more of the market than they already have -- anyone of could sell the advantages of CF over JSP into that marketplace! Geeze, I did it again! Dick On Wednesday, September 18, 2002, at 07:47 PM, Ben Forta wrote: Some parts of your app should not be written in CF, no one has ever said otherwise. Similarly parts of your app should not be written in Java. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Returning columns with null values when specific columns are unknown at runtime
Issac, Isaac actually... I hope you understand that CURSORS are not the FASTEST thing in SQL Server.. Absolutely... i use them ever so sparingly... i have personally written many cursors apps to do BATCH Processing.. but i wouldnt recommend SQL Server Cursors for a REAL TIME processing.. Well in Oracle its a different Story... Depends on the DB. I agree T-SQL in cfquery doesnt look clean.. but for this situation... i think it will run faster. I'd be willing to bet money that the cursor in this stored procedure, run against a local temp table generated from a simple select statement on the information_schema.views table with no more than about 30 iterations ( I shudder to imagine the db table with more columns than this ) is faster and more efficient than 2 separate queries in CF server with a loop and ColdFusion conditional login in the 2nd query... Reason being that my understanding is that SQL Server engine internally doesn't have to wait for info to go out to another server, run a process and then come back, etc ... I've heard a lot of people say that db servers are generally faster than CF for a lot of things. We're also not talking about tables that are going to be particularly large -- admittedly, the sysobjects table has a few entries even in a new database, but you don't usually see a single db getting number of tables and or columns in the millions or billions like you sometimes do with rows in data tables. But then, to know for sure, we'd have to load test both. :) Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Package of Crystal Reports Required for CF?
We combine CF and ASP for processing and use Recrystallize as a productivity tool. It generates the web pages. We only use the asp processing pages. The input forms which need, in our case, to be very dynamic and based on other systems with varying security are done with CF. Note that we have alot of reports and is cost effective for us. http://www.recrystallize.com - Original Message - From: Joel Nath [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 8:39 PM Subject: RE: Package of Crystal Reports Required for CF? Hi, i meant the actual tag cfreport.. not crystal report itself.. i found it a bit hard to get it working.. and once i did.. i found it abit lacking in functionality you can write a module or component yourself that works alot better... just take the ASP examples that come with the software and covert it to CF... or interface CF form with an ASP page that calls the crystal report (*.RPT) file.. search the MM CF forums.. for issues ppl have come across... hth joel -Original Message- From: Jocelyn Isidro [mailto:[EMAIL PROTECTED]] Sent: Thursday, 19 September 2002 10:15 To: CF-Talk Subject: Re: Package of Crystal Reports Required for CF? Really, why? I've done a lot of hand-grown reports, but for a demo for a client, I want to use the widgets that come with crystal. Thanks. - Original Message - From: Joel Nath [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 5:18 PM Subject: RE: Package of Crystal Reports Required for CF? I have used Developer version... not sure about the standard version... plus i would stay away from cfreport... IMO..:) cheers Joel -Original Message- From: Jocelyn Isidro [mailto:[EMAIL PROTECTED]] Sent: Thursday, 19 September 2002 2:41 To: CF-Talk Subject: Package of Crystal Reports Required for CF? Does anyone know if Crystal Reports Standard can be used to develop a Crystal Report that can be invoked by Cold Fusion's CFReport tag, or do I need to get the Crystal Report Developer or Professional version? Thanks. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Jsp Vs Cfm (CFMX) -- Test Code
On Wednesday, September 18, 2002, at 08:17 PM, Ben Forta wrote: Dick, Oh, I agree. CF should keep getting better (and I believe it has been doing just that). I've been on board since 3.0 and I totally agree -- the books are getting so big (and the type so small) I can hardly lift or read them! My only point is that they'll always be a better way to do something, whether it is a small piece of code or a complex process, and whenever that is the case the solution is to use the right add-on or extension technology. I agree with that too. But, the less often you have to do that (leave CF), the greater the appeal of CF, from a business standpoint. Jesse made a good point that to support OS X, MM would have to get new machines, training, yadda, yadda, yadda -- 99% the same CF code, but a totally different environment. The same is true for MM's customers (and CF developers' clients) the costs tend to go up significantly (if not exponentially) if you have to introduce external components into a site (custom tags, objects, JSP code, etc -- they all have a cost) What about shared hosts -- you likely aren't allowed to do any of these things -- so you have to develop a CF-only solution? But you know all this! Fact of the matter is that CF has supported extensions ever since the CFX API was added way back in CF2. Then came COM, CORBA, Java, etc. All along there has been an understanding - CF cannot be the best at everything, nor can any other language or technology or platform. So, yep, suggestions on how to improve CF are useful, and we'll keep doing just that. Just don't expect CF to do it all, it can't and frankly it shouldn't. I believe you (MM) will continue to improve CF -- and I strongly support your efforts to do so! Dick --- Ben -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 11:14 PM To: CF-Talk Subject: Re: Jsp Vs Cfm (CFMX) -- Test Code Aw, 'cmon Ben, one of the great advantages of CF is it can address a broad range of applications -- all Joe wants do to is extend the range help MM sell into a broader range of solutions. Will MM get them all? --Never!.Can MM get more? All of us certainly hope so! What if optimizing the code made CF a viable option to 20% more of the market than they already have -- anyone of could sell the advantages of CF over JSP into that marketplace! Geeze, I did it again! Dick On Wednesday, September 18, 2002, at 07:47 PM, Ben Forta wrote: Some parts of your app should not be written in CF, no one has ever said otherwise. Similarly parts of your app should not be written in Java. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Returning columns with null values when specific columns are unknown at runtime
But then, to know for sure, we'd have to load test both. :) Am getting Brain Farted with all the testing am doing... Nah..NOT Another One :) Joe -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 11:41 PM To: CF-Talk Subject: RE: Returning columns with null values when specific columns are unknown at runtime Issac, Isaac actually... I hope you understand that CURSORS are not the FASTEST thing in SQL Server.. Absolutely... i use them ever so sparingly... i have personally written many cursors apps to do BATCH Processing.. but i wouldnt recommend SQL Server Cursors for a REAL TIME processing.. Well in Oracle its a different Story... Depends on the DB. I agree T-SQL in cfquery doesnt look clean.. but for this situation... i think it will run faster. I'd be willing to bet money that the cursor in this stored procedure, run against a local temp table generated from a simple select statement on the information_schema.views table with no more than about 30 iterations ( I shudder to imagine the db table with more columns than this ) is faster and more efficient than 2 separate queries in CF server with a loop and ColdFusion conditional login in the 2nd query... Reason being that my understanding is that SQL Server engine internally doesn't have to wait for info to go out to another server, run a process and then come back, etc ... I've heard a lot of people say that db servers are generally faster than CF for a lot of things. We're also not talking about tables that are going to be particularly large -- admittedly, the sysobjects table has a few entries even in a new database, but you don't usually see a single db getting number of tables and or columns in the millions or billions like you sometimes do with rows in data tables. Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Jsp Vs Cfm (CFMX) -- Test Code
What makes this so compelling (and so frustrating) is that we all are on the same side! Dick On Wednesday, September 18, 2002, at 08:34 PM, Joe Eugene wrote: Yea!!! thanks a lot Ben . We are looking forward to any improvements...and will defnitely brag on it.. when its out... Oh, I agree. CF should keep getting better (and I believe it has been doing just that). So, yep, suggestions on how to improve CF are useful, and we'll keep doing just that. Just don't expect CF to do it all, it can't and frankly it shouldn't. Dick, thanks again on your support... Joe -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 11:17 PM To: CF-Talk Subject: RE: Jsp Vs Cfm (CFMX) -- Test Code Dick, My only point is that they'll always be a better way to do something, whether it is a small piece of code or a complex process, and whenever that is the case the solution is to use the right add-on or extension technology. Fact of the matter is that CF has supported extensions ever since the CFX API was added way back in CF2. Then came COM, CORBA, Java, etc. All along there has been an understanding - CF cannot be the best at everything, nor can any other language or technology or platform. --- Ben -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 11:14 PM To: CF-Talk Subject: Re: Jsp Vs Cfm (CFMX) -- Test Code Aw, 'cmon Ben, one of the great advantages of CF is it can address a broad range of applications -- all Joe wants do to is extend the range help MM sell into a broader range of solutions. Will MM get them all? --Never!.Can MM get more? All of us certainly hope so! What if optimizing the code made CF a viable option to 20% more of the market than they already have -- anyone of could sell the advantages of CF over JSP into that marketplace! Geeze, I did it again! Dick On Wednesday, September 18, 2002, at 07:47 PM, Ben Forta wrote: Some parts of your app should not be written in CF, no one has ever said otherwise. Similarly parts of your app should not be written in Java. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Returning columns with null values when specific columns are unknown at runtime
No particular wisdom to impart -- I just wanted to post to this thread that is using so much bandwith that could otherwise be devoted to the Re: Jsp Vs Cfm (CFMX) -- Test Code thread-- %-0) Apologize in advance! Dick __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Jsp Vs Cfm (CFMX) -- Test Code
I hope MM DOESNT need a better reasoning to impove CFMX than the below. Gosh, we are trying to help improve CFMX..! Well said Dick.. I've been on board since 3.0 and I totally agree -- the books are getting so big (and the ***type so small) I can hardly lift or read them! The same is true for MM's customers (and CF developers' clients) the costs tend to go up significantly (if not exponentially) if you have to introduce external components into a site (custom tags, objects, JSP code, etc -- they all have a cost) Joe -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 11:47 PM To: CF-Talk Subject: Re: Jsp Vs Cfm (CFMX) -- Test Code On Wednesday, September 18, 2002, at 08:17 PM, Ben Forta wrote: Dick, Oh, I agree. CF should keep getting better (and I believe it has been doing just that). My only point is that they'll always be a better way to do something, whether it is a small piece of code or a complex process, and whenever that is the case the solution is to use the right add-on or extension technology. I agree with that too. But, the less often you have to do that (leave CF), the greater the appeal of CF, from a business standpoint. Jesse made a good point that to support OS X, MM would have to get new machines, training, yadda, yadda, yadda -- 99% the same CF code, but a totally different environment. What about shared hosts -- you likely aren't allowed to do any of these things -- so you have to develop a CF-only solution? But you know all this! Fact of the matter is that CF has supported extensions ever since the CFX API was added way back in CF2. Then came COM, CORBA, Java, etc. All along there has been an understanding - CF cannot be the best at everything, nor can any other language or technology or platform. So, yep, suggestions on how to improve CF are useful, and we'll keep doing just that. Just don't expect CF to do it all, it can't and frankly it shouldn't. I believe you (MM) will continue to improve CF -- and I strongly support your efforts to do so! Dick --- Ben -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 11:14 PM To: CF-Talk Subject: Re: Jsp Vs Cfm (CFMX) -- Test Code Aw, 'cmon Ben, one of the great advantages of CF is it can address a broad range of applications -- all Joe wants do to is extend the range help MM sell into a broader range of solutions. Will MM get them all? --Never!.Can MM get more? All of us certainly hope so! What if optimizing the code made CF a viable option to 20% more of the market than they already have -- anyone of could sell the advantages of CF over JSP into that marketplace! Geeze, I did it again! Dick On Wednesday, September 18, 2002, at 07:47 PM, Ben Forta wrote: Some parts of your app should not be written in CF, no one has ever said otherwise. Similarly parts of your app should not be written in Java. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Log reporting error - No actual error
Well... I think I've gone through all of my ask these first questions. The only other thing I can think of is a code review of the complete code. Dunno. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 8:50 PM To: CF-Talk Subject: Re: Log reporting error - No actual error If you try to CFOUTPUT FORM.FormFields, what does it give you? And, if it gives you a list as you would expect, try iterating over that list, evaluating each one as in: I displayed the list and the values for each item in the list. The list/values output as it should. And, it gave me an error saying Element FIELDNAMES is undefined in FORM. brThe error occurred on line 17. Line 17 is where I output Form.fieldnames (and it displayed ok). Mind boggling, isn't it? Scott --- Scott Brady http://www.scottbrady.net __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Flash Movies // https // WTF
On Wednesday, September 18, 2002, at 05:26 , Tony Weeg wrote: no dice, flash movie just doesn't load, only get broken image looking thing. guess it cant find the codebase on the server that is referenced in the flash-html code when using https:// Sorry... we're fixing it! My team is looking into this, along with the Unix network group. We'll enable SSL Flash Player downloads 'soon', hopefully within a week or so. I have always wished that my computer would be as easy to use as my telephone. My wish has come true - I no longer know how to use my telephone. -- Bjarne Stroustrup __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: FW: Jsp Vs Cfm (CFMX) -- Test Code
On Wednesday, September 18, 2002, at 01:12 , Jochem van Dieten wrote: That would make ColdFusion quite a different language! :) Would it? Doesn't for instance cfparam do type checking? As Matt correctly pointed out, cfparam is runtime validation not compile-time type checking. It turns out that there are bigger optimizations than type checking (I'm not saying what :) and that whilst type checking would provide some (noticeable) benefits, the effort would be pretty big to implement it. If you're at DevCon, chat to Edwin about this sort of stuff... :) Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Keeping formatting from a textarea
Hi All Our site users are entering text into a Textarea field and we are finding that if they hit enter twice they get a new paragraph but if they only hit enter once it looks like a new line (in the textarea box) but when it is displayed on another page within a #ParagraphFormat()# tag the single linebreaks do not appear ie. Text entered into a textarea as: Line1 Line2 Line3 Would appear (within a #ParagraphFormat()# on another page) as: Line 1 Line 2 Line3 Does anyone know how to get around this? I gather I am going to have to replace a special character with a br before outputting it - but I am having no luck... Thanks for any help. David - www.red5.com.au Level 4, 9-13 Bronte Rd Bondi Junction NSW Australia 2022 Tel: 61 2 9387 6955 Fax: 61 2 9387 8355 - FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Keeping formatting from a textarea
I use this (that I got from this list some months ago) This before UPDATE or INSERT: cfset my_text = #ReplaceList(my_text,#Chr(10)#,#Chr(10)##Chr(13)#, BR,P)# This before showing in FORM and/or final page: cfset my_text = #ReplaceList(my_text,BR,P,#Chr(10)#,#Chr(10)##Chr(13)#)# Seamus At 03:55 pm 19/09/2002 , you wrote: Hi All Our site users are entering text into a Textarea field and we are finding that if they hit enter twice they get a new paragraph but if they only hit enter once it looks like a new line (in the textarea box) but when it is displayed on another page within a #ParagraphFormat()# tag the single linebreaks do not appear ie. Text entered into a textarea as: Line1 Line2 Line3 Would appear (within a #ParagraphFormat()# on another page) as: Line 1 Line 2 Line3 Does anyone know how to get around this? I gather I am going to have to replace a special character with a br before outputting it - but I am having no luck... Thanks for any help. David __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FW: Jsp Vs Cfm (CFMX) -- Test Code
Sean, I would love to see this happen... an option to declare Types... same a locksnothing is enforced.. kinda deal.. Yes, it's certainly one possible approach, allowing the user to declare variables with a type (and extending the CF types to include integer would also be a useful enhancement, instead of just numeric and binary ). Joe -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 12:56 AM To: CF-Talk Subject: Re: FW: Jsp Vs Cfm (CFMX) -- Test Code On Tuesday, September 17, 2002, at 09:41 , Dick Applebaum wrote: Rather I suggest that CFMX allow us to tell it a variable's type (optionally) so that it can use that to generate efficient code, That would make ColdFusion quite a different language! :) I actually prefer the code analysis approach since it allows CFMX's compiler to evolve without requiring users to change their code and could substantially speed up certain constructs in legacy code. If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Jsp Vs Cfm (CFMX) -- Test Code
Would the below be an easy change in CFMX? cfset int foobar = 1 or cfscript int foobar = 1; /cfscript Would declare a coldfusion.runtime.Integer instead of the following. cfset foobar = 1 or cfscript foobar = 1; /cfscript Would declare a coldfusion.runtime.Variable. Joe -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 1:12 AM To: CF-Talk Subject: RE: FW: Jsp Vs Cfm (CFMX) -- Test Code Well CF could use the same technique that VB did. VB optionally allows variables to be declared as a type. If no type is declared then the variable is considered of type variant. For example, the following could work with CF. cfset int foobar = 1 or cfscript int foobar = 1; /cfscript Would declare a coldfusion.runtime.Integer instead of the following. cfset foobar = 1 or cfscript foobar = 1; /cfscript Would declare a coldfusion.runtime.Variable. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 9:56 PM To: CF-Talk Subject: Re: FW: Jsp Vs Cfm (CFMX) -- Test Code On Tuesday, September 17, 2002, at 09:41 , Dick Applebaum wrote: Rather I suggest that CFMX allow us to tell it a variable's type (optionally) so that it can use that to generate efficient code, That would make ColdFusion quite a different language! :) Yes, it's certainly one possible approach, allowing the user to declare variables with a type (and extending the CF types to include integer would also be a useful enhancement, instead of just numeric and binary ). I actually prefer the code analysis approach since it allows CFMX's compiler to evolve without requiring users to change their code and could substantially speed up certain constructs in legacy code. If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Log reporting error - No actual error
Jeez. Well, I can't see any problems in the code that you posted. If you try to CFOUTPUT FORM.FormFields, what does it give you? And, if it gives you a list as you would expect, try iterating over that list, evaluating each one as in: CFIF IsDefined(FORM.FormFields) FORM.FormFields = CFOUTPUT#FORM.FormFields#/CFOUTPUTBRBR CFLOOP LIST=#FORM.FormFields# INDEX=CurrEle CFOUTPUTFORM.#CurrEle# = #Evaluate(FORM.#CurrEle#)#/CFOUTPUT /CFLOOP CFELSE FORM.FormFields is Not Defined /CFIF -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 3:12 PM To: CF-Talk Subject: RE: Log reporting error - No actual error I can give you the relevant parts, without posting all of the actual code: !--- replace hack attempts --- cfif isDefined(form.firstname) cfset form.firstname = replacenocase(form.firstname, cf, _HACK, all) cfset form.firstname = replacenocase(form.firstname, script, _HACK, all) /cfif CFQUERY name=popOrder DATASOURCE=#DSN# INSERT INTO Orders ( FirstName ) VALUES ( '#form.FirstName#' ) /cfquery .. and then it displays the next page. (That page has a form on it, as well, which does the same thing with submissions). It appears to happen with every field in the form (so, if you were to cfparam FORM.firstname, then the error would report for FORM.lastname [the next field]). Scott Brady http://www.scottbrady.net/ __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: run CF from db
I am not sure that is entirely correct. I use evaluate() and de() and it works fine. cfoutput#evaluate(de(getContentTypes.CTEmailTemplate))#/cfoutput It is not fast but definetly works. evaluate() and de() together are really slow, but they work even with HTML tags in the database. example: cfset myVar = Shlomy cfset dynText =hello my name is ##myVar## dynText: cfoutput#dynText#/cfoutputhr cfset dynOut =evaluate(de(dynText)) dynOut: cfoutput#dynOut#/cfoutput Shlomy -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 3:17 PM To: CF-Talk Subject: RE: run CF from db Generally this won't work. It would only work if you were storing a cf expression, e.g int(3.1415). It won't handle cf tags or expressions mixed with html. -Original Message- From: Jesse Houwing [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 18 September 2002 10:17 a.m. To: CF-Talk Subject: Re: run CF from db Nick Varner wrote: Is there a way to evaluate Coldfusion after it is pulled from a db instead of CF thinking its text? That would be the use of evaluate... but I would not reccomend it... Jesse __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: run CF from db
Hal Helms wrote: I haven't tried this trick with CFMX, but 18 months ago or so, Rick Moon and I were faced with this problem: the situation required a LOT of code to be stored in the DB and then executed dynamically. That meant writing and then reading a file, which I was very concerned with for performance reasons. We ended up creating a RAM disk and using that. We got excellent performance. Now, that may all be different with CFMX, but may be worth a look still. http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Challenge/CombineSortQuery/Solution-Intro.cfm Jochem __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Timezones and CF
Use a database. SELECT Now() AT TIME ZONE '#your_time_zone#' AS MyTime It is part of SQL-92 and it handles DST and dates correctly. IRL YMMV Jochem __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: FW: Jsp Vs Cfm (CFMX) -- Test Code
Sean A Corfield wrote: On Tuesday, September 17, 2002, at 09:41 , Dick Applebaum wrote: Rather I suggest that CFMX allow us to tell it a variable's type (optionally) so that it can use that to generate efficient code, That would make ColdFusion quite a different language! :) Would it? Doesn't for instance cfparam do type checking? Besides, I don't see much difference with using var to declare a non typed variable to be local inside a function and to use int to declare a variable to be an integer. I am not sure how much of an impact adding int, double would have on the compiler, but adding them, even if just to be used next to var inside functions, would be on my research list. Jochem __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: code optimization (was RE: Jsp Vs Cfm (CFMX) -- Test Code)
Matt Liotta wrote: Every idea/technique that has been suggested thus far for code optimization is a waste of time for almost all applications. Sure some of these ideas/techniques code save a few milliseconds here and there, but they offer very small gains in scalability. There are much simpler ways to achieve greater scalability in less time than code optimization e.g. caching. I suggest people spend their time seeking out these ways instead of spending time on code optimization. As you said it yourself (it was you, right?) there is a difference between performance and scalability. And I think most people are discussing performance here. You should only spend time on code optimization after every other performance enhancement has been tried. Remember the example I gave where switching from treating a long Base64 string as a string to treating it as an array gave a performance increase of a factor 4000. I have helped somebody else convert from using ListDeleteAt() to ArrayDeleteAt() and get a 100 fold performance increase. Sometimes code optimization is what you need. But I have to admit, compared to those code optimizations, the quality of some of the SQL, and some of the ridiculous algorithms I see, a factor 8 between JSP and CFML in the generated java is peanuts. Jochem __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX updater - service pack?
It really sounds like an intelligent, well-thought-out concept It sounds like a service pack with a different name. Thomas Chiverton __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: more cfstoredproc issues -- ARGH!!
S. Isaac Dealey wrote: Yea, it turned out to be the cf_sql_date that was causing the wrong number of parameters error message... so changing that to cf_sql_timestamp solved the problem... Better support for cfstoredproc ( naming and better error handling in particular. ) would be _great_ to see from the folks at MM... I'll probably toy with it some once I start working with it on MX just to see if any improvements came with the new J2EE platform. my biggest peve with the cf query/stored proc param support is that there is no null=AUTO option... z __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Timezones and CF
What DB are you using? -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 4:08 AM To: CF-Talk Subject: Re: Timezones and CF Use a database. SELECT Now() AT TIME ZONE '#your_time_zone#' AS MyTime It is part of SQL-92 and it handles DST and dates correctly. IRL YMMV Jochem __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: run CF from db
I have to say I've never grasped what de() actually does! :-( - Original Message - From: Shlomy Gantz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 10:47 PM Subject: RE: run CF from db I am not sure that is entirely correct. I use evaluate() and de() and it works fine. cfoutput#evaluate(de(getContentTypes.CTEmailTemplate))#/cfoutput It is not fast but definetly works. evaluate() and de() together are really slow, but they work even with HTML tags in the database. example: cfset myVar = Shlomy cfset dynText =hello my name is ##myVar## dynText: cfoutput#dynText#/cfoutputhr cfset dynOut =evaluate(de(dynText)) dynOut: cfoutput#dynOut#/cfoutput Shlomy -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 3:17 PM To: CF-Talk Subject: RE: run CF from db Generally this won't work. It would only work if you were storing a cf expression, e.g int(3.1415). It won't handle cf tags or expressions mixed with html. -Original Message- From: Jesse Houwing [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 18 September 2002 10:17 a.m. To: CF-Talk Subject: Re: run CF from db Nick Varner wrote: Is there a way to evaluate Coldfusion after it is pulled from a db instead of CF thinking its text? That would be the use of evaluate... but I would not reccomend it... Jesse __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Mac/Linux (Was For Jesse)
Just curious, has anybody tried mac-on-linux(http://maconlinux.org)...it supports OSX. -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 12:01 AM To: CF-Talk Subject: Re: For Jesse Absolutely--- Not! I once ragged a contemporary for sloshing around in the Bowels of BSD -- not a pretty thought! My only prior 'Nix experience is Quinx on PC (pre windows) and Yellow Dog Linux on the Mac -- both were more trouble than they were worth. I ran across the quote in a column by Tim O'Reilly http://www.macdevcenter.com/pub/a/mac/2002/09/17/switcher.html?page=3 The attribution is to Steven Champeon, a contributor to Unix Power Tools, 3rd Edition writes that OS X is for people who love Unix and the Mac I laughed out loud when I read it thought of Jesse -- could just as easily been for Matt! Nothing meant here, except to try and share a laugh -- it is funny (at least to me). Dick Dick On Tuesday, September 17, 2002, at 08:22 PM, Steve Foster wrote: I take it you were a BSD fan before OSX? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: run CF from db
It's main use is within IF and Evaluate, preventing them from treating strings as expressions and trying to evaluate them (hence the name : delay evaluation).ColdFusion will try to evaluate anything within pound signs first, using DE() allows you to have it evaluate the internal parts surrounded by pound signs later, rather than trying to evaluate the whole thing as an expression. I use evaluate() and de() mostly for dynamic logical processing (implementing rules and complex data filters) but I find the writing dynamic code using CFFILE and including it is much faster for large/high-volume or complex applications. After reading this explanation I wonder if I truly understand it as well... Shlomy -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 4:34 AM To: CF-Talk Subject: Re: run CF from db I have to say I've never grasped what de() actually does! :-( - Original Message - From: Shlomy Gantz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 10:47 PM Subject: RE: run CF from db I am not sure that is entirely correct. I use evaluate() and de() and it works fine. cfoutput#evaluate(de(getContentTypes.CTEmailTemplate))#/cfoutput It is not fast but definetly works. evaluate() and de() together are really slow, but they work even with HTML tags in the database. example: cfset myVar = Shlomy cfset dynText =hello my name is ##myVar## dynText: cfoutput#dynText#/cfoutputhr cfset dynOut =evaluate(de(dynText)) dynOut: cfoutput#dynOut#/cfoutput Shlomy -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 3:17 PM To: CF-Talk Subject: RE: run CF from db Generally this won't work. It would only work if you were storing a cf expression, e.g int(3.1415). It won't handle cf tags or expressions mixed with html. -Original Message- From: Jesse Houwing [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 18 September 2002 10:17 a.m. To: CF-Talk Subject: Re: run CF from db Nick Varner wrote: Is there a way to evaluate Coldfusion after it is pulled from a db instead of CF thinking its text? That would be the use of evaluate... but I would not reccomend it... Jesse __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: run CF from db
Thanks Shlomy. - Original Message - From: Shlomy Gantz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 19, 2002 3:25 AM Subject: RE: run CF from db It's main use is within IF and Evaluate, preventing them from treating strings as expressions and trying to evaluate them (hence the name : delay evaluation).ColdFusion will try to evaluate anything within pound signs first, using DE() allows you to have it evaluate the internal parts surrounded by pound signs later, rather than trying to evaluate the whole thing as an expression. I use evaluate() and de() mostly for dynamic logical processing (implementing rules and complex data filters) but I find the writing dynamic code using CFFILE and including it is much faster for large/high-volume or complex applications. After reading this explanation I wonder if I truly understand it as well... Shlomy -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 4:34 AM To: CF-Talk Subject: Re: run CF from db I have to say I've never grasped what de() actually does! :-( - Original Message - From: Shlomy Gantz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 10:47 PM Subject: RE: run CF from db I am not sure that is entirely correct. I use evaluate() and de() and it works fine. cfoutput#evaluate(de(getContentTypes.CTEmailTemplate))#/cfoutput It is not fast but definetly works. evaluate() and de() together are really slow, but they work even with HTML tags in the database. example: cfset myVar = Shlomy cfset dynText =hello my name is ##myVar## dynText: cfoutput#dynText#/cfoutputhr cfset dynOut =evaluate(de(dynText)) dynOut: cfoutput#dynOut#/cfoutput Shlomy -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 3:17 PM To: CF-Talk Subject: RE: run CF from db Generally this won't work. It would only work if you were storing a cf expression, e.g int(3.1415). It won't handle cf tags or expressions mixed with html. -Original Message- From: Jesse Houwing [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 18 September 2002 10:17 a.m. To: CF-Talk Subject: Re: run CF from db Nick Varner wrote: Is there a way to evaluate Coldfusion after it is pulled from a db instead of CF thinking its text? That would be the use of evaluate... but I would not reccomend it... Jesse __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Flash Movies // https // WTF
ok. uninstall flash player, go back to page https://www.navtrak.net/login.html no dice, flash movie just doesn't load, only get broken image looking thing. guess it cant find the codebase on the server that is referenced in the flash-html code when using https:// so, what the F! microsoft is really shafting us here.after installing sp1 to xp, and using ie6, we cant embed flash movies in pages that are referenced in https:// protected pages without having to bother the heck out of our visitors with nagging boxes that pop up? ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 12:14 AM To: CF-Talk Subject: Re: Flash Movies // https // WTF On Tuesday, September 17, 2002, at 08:01 , Tony Weeg wrote: cant figger out how to remove the flash player, i already tried that how doth i do that? I searched mm.com for uninstall flash player and found this technote: http://www.macromedia.com/support/flash/ts/documents/remove_player.htm Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: For Jesse
I don't like or hate any of them, does that just make me an l-user? Use the right tool for the job. -jesse -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 8:39 PM To: CF-Talk Subject: For Jesse BSD is for people who love Unix. Linux is for people who hate Microsoft. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Help troubleshooting MX freezing up each day
Hey all! Just wondering if anyone might have any suggestions on what to look for in troubleshooting why my MX server freezes up each day. (Win 2K, 1 GB RAM, tons of free HD space - a brand new system.) It's a dedicated server, only this one application running. It is a kind of Enterprise monitoring system. Ten templates each contain various tests, like HTTP requests, directory counts, etc. The results of each test are saved to a large 2-d Application.array. The results are also appended to a log file. All templates are scheduled tasks which run every five minutes, rarely simultaneously as their schedules are offset by a minute. Users request another template which just loops through that Application.array to output all the test results in one place. This page also has javascript to refresh every 4 minutes. Not using CFAdmin scheduler because too unstable. Instead, Windows 2000 Scheduled tasks HTTP requests all templates through Netscape (because Netscape permits Javascript to close window on pageload). No datasources - all just Application variables and reading and writing to files. Very little traffic - less than an average of 5 requests a minute. There are a couple client variables to toggle alarm on and off and other preferences. No session variables. Whole system works great but just freezes up an average of once every other day (never at the same time) - Restarting the MX server is all I can do. I am not locking Application variables because I thought it was unnecessary in MX. The only thing I can think of is that every once in a while, two templates just happen to append to the same log file at the same time? Or maybe you do have to lock Application variables? I know there are probably a million things to look at - perhaps someone could direct me to some good documentation on the subject? I've looked everywhere I can think of... Thank you so much for any help anyone can provide! -Jason __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help troubleshooting MX freezing up each day
While locking the applications doesn't hurt, I think you should lock the cffile process (with named locks) when writing to the log file. This way you are single threading access to the file. Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: Blum, Jason (SAA) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 8:33 AM Subject: Help troubleshooting MX freezing up each day Hey all! Just wondering if anyone might have any suggestions on what to look for in troubleshooting why my MX server freezes up each day. (Win 2K, 1 GB RAM, tons of free HD space - a brand new system.) It's a dedicated server, only this one application running. It is a kind of Enterprise monitoring system. Ten templates each contain various tests, like HTTP requests, directory counts, etc. The results of each test are saved to a large 2-d Application.array. The results are also appended to a log file. All templates are scheduled tasks which run every five minutes, rarely simultaneously as their schedules are offset by a minute. Users request another template which just loops through that Application.array to output all the test results in one place. This page also has javascript to refresh every 4 minutes. Not using CFAdmin scheduler because too unstable. Instead, Windows 2000 Scheduled tasks HTTP requests all templates through Netscape (because Netscape permits Javascript to close window on pageload). No datasources - all just Application variables and reading and writing to files. Very little traffic - less than an average of 5 requests a minute. There are a couple client variables to toggle alarm on and off and other preferences. No session variables. Whole system works great but just freezes up an average of once every other day (never at the same time) - Restarting the MX server is all I can do. I am not locking Application variables because I thought it was unnecessary in MX. The only thing I can think of is that every once in a while, two templates just happen to append to the same log file at the same time? Or maybe you do have to lock Application variables? I know there are probably a million things to look at - perhaps someone could direct me to some good documentation on the subject? I've looked everywhere I can think of... Thank you so much for any help anyone can provide! -Jason __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Jsp Vs Cfm (CFMX) -- Test Code
Perhaps you should start doing some testing... and come with some numbers. Would it? Doesn't for instance cfparam do type checking? Besides, I don't see much difference with using var to declare a non typed variable to be local inside a function and to use int to declare a variable to be an integer. Joe - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 4:12 AM Subject: Re: FW: Jsp Vs Cfm (CFMX) -- Test Code Sean A Corfield wrote: On Tuesday, September 17, 2002, at 09:41 , Dick Applebaum wrote: Rather I suggest that CFMX allow us to tell it a variable's type (optionally) so that it can use that to generate efficient code, That would make ColdFusion quite a different language! :) Would it? Doesn't for instance cfparam do type checking? Besides, I don't see much difference with using var to declare a non typed variable to be local inside a function and to use int to declare a variable to be an integer. I am not sure how much of an impact adding int, double would have on the compiler, but adding them, even if just to be used next to var inside functions, would be on my research list. Jochem __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: For Jesse
Sorry Jesse I apologize! No offense meant! You have been a strong advocate of Linux on this list, and I hoped you would get a laugh out of the quote -- as I did! Dick On Wednesday, September 18, 2002, at 05:28 AM, Jesse Noller wrote: I don't like or hate any of them, does that just make me an l-user? Use the right tool for the job. -jesse -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 8:39 PM To: CF-Talk Subject: For Jesse BSD is for people who love Unix. Linux is for people who hate Microsoft. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: For Jesse
Obviously I shouldn't send emails before my morning dosage. I was joking with ya Dick, no offense taken. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy But I ned tacos! I need them or I will explode! That happens to me sometimes! -GIR -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 9:36 AM To: CF-Talk Subject: Re: For Jesse Sorry Jesse I apologize! No offense meant! You have been a strong advocate of Linux on this list, and I hoped you would get a laugh out of the quote -- as I did! Dick On Wednesday, September 18, 2002, at 05:28 AM, Jesse Noller wrote: I don't like or hate any of them, does that just make me an l-user? Use the right tool for the job. -jesse -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 8:39 PM To: CF-Talk Subject: For Jesse BSD is for people who love Unix. Linux is for people who hate Microsoft. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFmail inside of CF error page
I am wondering if there is a way to put a CFMail inside of the error page that CF generates? That way we can be notified if an error occurs on the web site, and email the exact error. Is the error page a CF template? Is it encrypted? We tried wrapping all of the pages with cftry/cfcatch in application.cfm, and onendrequest.com, but CF does not like the tag broken up like that. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFmail inside of CF error page
I have a few sites that do this... In your application.cfm file put something like cfapplication name=Builda clientmanagement=Yes sessionmanagement=Yes setclientcookies=Yes !--- cferror type=REQUEST template=ALLERRORS.cfm cferror type=EXCEPTION template=ALLERRORS.cfm cferror type=MONITOR template=ALLERRORS.cfm cferror type=VALIDATION template=ALLERRORS.cfm --- Then when an error occurs the ALLERRORS.cfm page runs. Put whatever you like in this Mark Stephenson New Media Director Evolution Internet T: 0870 757 1631 F: 0870 757 1632 W: www.evolutioninternet.co.uk E: [EMAIL PROTECTED] This email, together with any attachments, is for the exclusive and confidential use of the addressee(s). Any other distribution, use or reproduction without the sender's prior consent is unauthorised and strictly prohibited. If you have received this message in error, please notify the sender by email immediately and delete the message from your computer without making any copies. -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: 18 September 2002 14:44 To: CF-Talk Subject: CFmail inside of CF error page I am wondering if there is a way to put a CFMail inside of the error page that CF generates? That way we can be notified if an error occurs on the web site, and email the exact error. Is the error page a CF template? Is it encrypted? We tried wrapping all of the pages with cftry/cfcatch in application.cfm, and onendrequest.com, but CF does not like the tag broken up like that. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFmail inside of CF error page
Hi Chad, This works well for us in CF 5. Just make absolutely sure that this code is error free after you edit it - otherwise it loops and getting 2,000 error e-mails is no fun :) : cfset errorto = your e-mail here cfset errorfrom = replyto here cfset errorsubject = DB error cfset errortourl = errortemplate.html cfmail to=#errorto# from=#errorfrom# subject=#errorsubject# type=HTML !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN html head titleDessy - After Six/title /head body Diagnostics: #error.diagnostics#br br Date: #error.dateTime#br br Browser: #error.browser# br Remote Address: #error.remoteAddress#br br Referrer: #error.HTTPReferer# br br Template: #error.template# br br Query String: #error.queryString# /body /html /cfmail cflocation url=#errortourl# -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 6:44 AM To: CF-Talk Subject: CFmail inside of CF error page I am wondering if there is a way to put a CFMail inside of the error page that CF generates? That way we can be notified if an error occurs on the web site, and email the exact error. Is the error page a CF template? Is it encrypted? We tried wrapping all of the pages with cftry/cfcatch in application.cfm, and onendrequest.com, but CF does not like the tag broken up like that. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX: CFLDAP x LDAP/JNDI
Hi Stace, thanks for your input and offer to help testing this. I'll need one week or so before sharing it. I'll keep you posted. Regards, Marcello. Well one thing I can tell ya...dunno if it applies in your case but CFLDAP does not function properly against an Active Directory under SSL (non-SSL works fine). I was told it's M$ fault by not adhering to the LDAP protocol properly (MM tech support) but I'd expect CFMX to compensate as in previous versions of CF. If you're willing to share ur wrapper class I'd be more than happy to help test! Stace -Original Message- From: Marcello Frutig [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 11:11 AM To: CF-Talk Subject: CFMX: CFLDAP x LDAP/JNDI Hi! I'm wondering if anyone has experience with CFLDAP in a high demand application and would like to share. I've been reading about using LDAP via JNDI and how to construct a LDAP manager Java class that supports connection sharing via singleton pattern. In fact I've already developed a prototype of a CFC wrapper that uses such a Java class. My first test indicates that this approach has a better performance. I'm also expecting a better scalability. Thanks, Marcello Frutig. -- Astrolábio __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Query of query examples
Can soemeone send me a query of a query examples... I need to write one and I cant remember the syntax (working off site today so I don't have any of my code handy. Thanks!! Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: code optimization (was RE: Jsp Vs Cfm (CFMX) -- Test Code)
But Matt's point is extremely valid and I think a technique way to many developers overlook too consider with keeping the code dynamic. Caching can mean many things, on a heavily trafficked site, cache portions of content for seconds can increase performance of the box tenfold, without losing the benefits of dynamic content. Also, I can't count the times I've heard someone complain about a page taking 30-60 seconds to come up and after looking at it, it's some page doing monthly reporting over achieved data. Granted, you can almost always find ways to knock down processing time like that, but by simply running the script one time in the middle of the night when the archived data is needed and caching the page as a static page, you'll save you safe tons of processing time and look like a genius. And if you're saying, well you can't always cache content to a static page, they want to be able to dynamically manipulate the data. Well then cache the data instead of the output. There are a number of ways you can cache CF code, but if its db results, then store everything in archived tables that contain the content post-calculations. The bottom line is caching is one of the few ways to make even bad code perform well, and it just makes good code perform better. -Dan -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 4:21 AM To: CF-Talk Subject: Re: code optimization (was RE: Jsp Vs Cfm (CFMX) -- Test Code) Matt Liotta wrote: Every idea/technique that has been suggested thus far for code optimization is a waste of time for almost all applications. Sure some of these ideas/techniques code save a few milliseconds here and there, but they offer very small gains in scalability. There are much simpler ways to achieve greater scalability in less time than code optimization e.g. caching. I suggest people spend their time seeking out these ways instead of spending time on code optimization. As you said it yourself (it was you, right?) there is a difference between performance and scalability. And I think most people are discussing performance here. You should only spend time on code optimization after every other performance enhancement has been tried. Remember the example I gave where switching from treating a long Base64 string as a string to treating it as an array gave a performance increase of a factor 4000. I have helped somebody else convert from using ListDeleteAt() to ArrayDeleteAt() and get a 100 fold performance increase. Sometimes code optimization is what you need. But I have to admit, compared to those code optimizations, the quality of some of the SQL, and some of the ridiculous algorithms I see, a factor 8 between JSP and CFML in the generated java is peanuts. Jochem __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: setCredentials() cflogin
Beware: cfloginuser does not work outside cflogin! It seems to for the page you are on but it does not maintain the information beyond that single page invocation. That might be part of your problem. I intentionally set the cfloginuser / outside the cflogin because I want the user authenticated on each Flash Remoting request. It works well that way because the session won't timeout because the authorization code persists in the Flash Remoting headers. That part is working ok. So the session information has timed out...? Well, that's the thing. I really don't need to use the ColdFusion sessions because I authenticate the user on each call. The problem seems to be that I do a setCredentials() and make a call, but the server spits back the CFID CFTOKEN, which I can only assume erases my current Flash Remoting headers. I can figure out a workaround so I guess I'm looking for somebody to simply confirm that this is suppose to happen or if I'm suppose to submit a bug report. Thanks. Ben Johnson Information Architect www.architekture.com [p] 720.934.2179 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMX installation nightmare
Ok, I have installed CFMX on 5 or 6 systems, all without a hitch. Now I go out to a client location today and attempt to install CFMX on an NT4(6a)/IIS4 system and everything goes totally haywire. Problem one: During installation, after choosing all the options, entering the serials etc, it goes into the install. Right as it is about to start copying files, I get error 1303 something to the effect that permissions do not allow the installer to access e:/inetpub/wwwroot/cfide, please login as an administrator and try the install again. Well, I am logged in using the domain admin account, and the permissions on E: are set to allow Domain admins permissions to that directory - and all directories for that matter, there are no special permissions on that volume AFAIK. Problem two: I finally get past this problem after trying the install about 5 times by choosing to install the cfide on c:. No problem, install goes fine... The admin opens, and I think I'm in business... Wrong... None of the other .cfm pages will load. I read an article or two on changing a setting for a multi-homed server (which this is not). Try the suggestions anyway, no help. I really am very frustrated at this point and am sure I'm not considering something right under my nose. It's not like I've never installed CF, or CFMX, this install is just going horribly wrong, and I don't know why... Suggestions? -Cameron - Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query of query examples
cfquery dbtype=query name=subQuery -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: 18 September 2002 14:51 To: CF-Talk Subject: Query of query examples Can soemeone send me a query of a query examples... I need to write one and I cant remember the syntax (working off site today so I don't have any of my code handy. Thanks!! Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFmail inside of CF error page
This works well for us in CF 5. Just make absolutely sure that this code is error free after you edit it - otherwise it loops and getting 2,000 error e-mails is no fun :) : Just add cfif cgi.CF_TEMPLATE_PATH does not contain error.cfm to the top and a /cfif to the bottom :-) __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFmail inside of CF error page
I wondered how the code ran. :) -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 9:09 AM To: CF-Talk Subject: RE: CFmail inside of CF error page This works well for us in CF 5. Just make absolutely sure that this code is error free after you edit it - otherwise it loops and getting 2,000 error e-mails is no fun :) : Just add cfif cgi.CF_TEMPLATE_PATH does not contain error.cfm to the top and a /cfif to the bottom :-) __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT problem with Javascript..
The error is:
error expected ';'
If I try top run it I get:
a.temp1 is not defined
Here is the code:
CFQUERY NAME=search DATASOURCE=brinventory
SELECT DISTINCT lookup.type
FROMsteel, lookup
WHERE steel.type_id = lookup.type_id
/CFQUERY
CFQUERY NAME=search2 DATASOURCE=brinventory
SELECT DISTINCT steel.length
FROMsteel, lookup
WHERE steel.type_id = lookup.type_id
/CFQUERY
CFQUERY NAME=search3 DATASOURCE=brinventory
SELECT DISTINCT steel.width
FROMsteel, lookup
WHERE steel.type_id = lookup.type_id
/CFQUERY
cfset i = 0
script language=JavaScript1.2
aTemp1 = new Array();
cfoutput query=search
aTemp1[#i#] = #type#;
cfset i = i + 1
/cfoutput
/script
cfset i = 0
script language=JavaScript1.2
aTemp2 = new Array();
cfoutput query=search2
aTemp2[#i#] = #length#;
cfset i = i + 1
/cfoutput
/script
script language=JavaScript1.2
function foo()
{
document.forms[0].one.length = aTemp1.length;
for(i=0;iaTemp1.length;i++)
{
document.forms[0].one.options[i].text = aTemp1[i];
document.forms[0].one.options[i].value = aTemp1[i];
}
}
function bar()
{
document.forms[0].two.length = aTemp2.length;
for(i=0;iaTemp2.length;i++)
{
document.forms[0].two.options[i].text = aTemp2[i];
document.forms[0].two.options[i].value = aTemp2[i];
}
}
/script
form
input type=button name=test value=test onclick=foo()
select name=one onblur=bar()
/select
select name=two
/select
/form
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFmail inside of CF error page
I wondered how the code ran. :) Just add cfif cgi.CF_TEMPLATE_PATH does not contain error.cfm Of course, use cgi.http_referer if you don't cfinclude but cflocate your error pages ;-) __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT problem with Javascript..
The error is: error expected ';' From which line ? What happens if you save the output as a html page and view that - I find that a useful way of debugging CF generated javascript. ? Thomas Chiverton __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFmail inside of CF error page
Wow. Sometimes it's staring you right in the face... Thanks for the help! -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 7:17 AM To: CF-Talk Subject: RE: CFmail inside of CF error page I wondered how the code ran. :) -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 9:09 AM To: CF-Talk Subject: RE: CFmail inside of CF error page This works well for us in CF 5. Just make absolutely sure that this code is error free after you edit it - otherwise it loops and getting 2,000 error e-mails is no fun :) : Just add cfif cgi.CF_TEMPLATE_PATH does not contain error.cfm to the top and a /cfif to the bottom :-) __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Just Curious (Redirects)
Curious as to what everyone is using for IIS 5 and a error-redirect processor? IEP was something many of us used for redirecting 404 (and other) errors in Website Pro. But with IIS.. What are y'all using? TTAIA __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT problem with Javascript..
line 5 char 22 -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 9:24 AM To: CF-Talk Subject: RE: OT problem with Javascript.. The error is: error expected ';' From which line ? What happens if you save the output as a html page and view that - I find that a useful way of debugging CF generated javascript. ? Thomas Chiverton __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
does StructNew() destroy old structure completely?
I've got a structure in the Application scope that I use to store different types of information, depending on circumstances. When the structure's contents need replacing, I just initiate the process with cfset myStruct = StructNew() My question is: if 'myStruct' already contains a set of key-value pairs, will StructNew() clear it completely, allowing for totally new key-value pairs? Or could there be problems along the way? My tests seem to indicate the former, but I keep wondering whether StructClear() is necessary here or not. - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Using array syntax with a query
Hi - I could really use some help getting at a query result in round about ways. Someone suggested to me that I could use array syntax to do this. Something along the line of: cfquery name=foo .../cfquery cfoutput query=foo #foo[1]# /cfoutput This doesn't work (just an example of what I'm hoping CF supports if the syntax is right). Is there any way to this? That is, address the data in foo without using any of the contents of columnlist? What's causing the problem is a DB2 stored procedure that is returning numbers for the column names. i.e. the column list is 1,2,3,4. The variable foo.1 is illegal in ColdFusion. It appears I can invoke the procedure just fine, I just can't get at any of the returned data! Thanks, Brian __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Jsp Vs Cfm (CFMX) -- Test Code
I doubt anyone outside of Macromedia can answer that. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 11:41 PM To: CF-Talk Subject: RE: Jsp Vs Cfm (CFMX) -- Test Code Would the below be an easy change in CFMX? cfset int foobar = 1 or cfscript int foobar = 1; /cfscript Would declare a coldfusion.runtime.Integer instead of the following. cfset foobar = 1 or cfscript foobar = 1; /cfscript Would declare a coldfusion.runtime.Variable. Joe -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 1:12 AM To: CF-Talk Subject: RE: FW: Jsp Vs Cfm (CFMX) -- Test Code Well CF could use the same technique that VB did. VB optionally allows variables to be declared as a type. If no type is declared then the variable is considered of type variant. For example, the following could work with CF. cfset int foobar = 1 or cfscript int foobar = 1; /cfscript Would declare a coldfusion.runtime.Integer instead of the following. cfset foobar = 1 or cfscript foobar = 1; /cfscript Would declare a coldfusion.runtime.Variable. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 9:56 PM To: CF-Talk Subject: Re: FW: Jsp Vs Cfm (CFMX) -- Test Code On Tuesday, September 17, 2002, at 09:41 , Dick Applebaum wrote: Rather I suggest that CFMX allow us to tell it a variable's type (optionally) so that it can use that to generate efficient code, That would make ColdFusion quite a different language! :) Yes, it's certainly one possible approach, allowing the user to declare variables with a type (and extending the CF types to include integer would also be a useful enhancement, instead of just numeric and binary ). I actually prefer the code analysis approach since it allows CFMX's compiler to evolve without requiring users to change their code and could substantially speed up certain constructs in legacy code. If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FW: Jsp Vs Cfm (CFMX) -- Test Code
Would it? Doesn't for instance cfparam do type checking? But it doesn't do type checking; it does type validation. This was discussed a while back during a CFC thread where I explained why CFCs don't do type checking either. -Matt __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using array syntax with a query
Use bracket notation: cfset col = 1 cfoutput#foo[col][1]#/cfoutput === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Brian Fox [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:31 AM To: CF-Talk Subject: Using array syntax with a query Hi - I could really use some help getting at a query result in round about ways. Someone suggested to me that I could use array syntax to do this. Something along the line of: cfquery name=foo .../cfquery cfoutput query=foo #foo[1]# /cfoutput This doesn't work (just an example of what I'm hoping CF supports if the syntax is right). Is there any way to this? That is, address the data in foo without using any of the contents of columnlist? What's causing the problem is a DB2 stored procedure that is returning numbers for the column names. i.e. the column list is 1,2,3,4. The variable foo.1 is illegal in ColdFusion. It appears I can invoke the procedure just fine, I just can't get at any of the returned data! Thanks, Brian __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Calculating Shipping charges...
I'm developing a shopping cart. Can anyone give me some ideas as to how to calculate shipping? I know the first question is going to be Who is doing the shipping?. The answer to that is I don't know. Whoever the owner of the shopping cart wants. It could be UPS, Fed Ex, USPS...If there are ways to calculate all of these (based on some criteria), I would love to know. I appreciate any and all help on this. Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: does StructNew() destroy old structure completely?
structNew will kill the old data. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 9:50 AM To: CF-Talk Subject: does StructNew() destroy old structure completely? I've got a structure in the Application scope that I use to store different types of information, depending on circumstances. When the structure's contents need replacing, I just initiate the process with cfset myStruct = StructNew() My question is: if 'myStruct' already contains a set of key-value pairs, will StructNew() clear it completely, allowing for totally new key-value pairs? Or could there be problems along the way? My tests seem to indicate the former, but I keep wondering whether StructClear() is necessary here or not. - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT problem with Javascript..
Replace this #type# with #trim(jsstringformat(type))# That may solve the problem -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:36 AM To: CF-Talk Subject: RE: OT problem with Javascript.. line 5 char 22 -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 9:24 AM To: CF-Talk Subject: RE: OT problem with Javascript.. The error is: error expected ';' From which line ? What happens if you save the output as a html page and view that - I find that a useful way of debugging CF generated javascript. ? Thomas Chiverton __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Cached Stored Procedure Errors?
In working with our MX development server (Win2K w/.NET framework), I've noticed a problem with cached errors with stored procedures (oracle db). Here's what I've determined so far: 1. If I run a .cfm page that calls a sp, and an error is returned (usually due to some programming error, like sending wrong datatypes) that error seems to get cached. I can go in and correct the coldfusion page and/or the sp, re-run the page but error continues. 2. If I create a new sp (new name) with the corrected code and call it from my corrected cfm page, everything works fine. 3. If I drop the original sp, and call it from the cfm page, I receive the standard does not exist error. If I then create an sp with the original name and corrected code, and then run it from the cfm page, the original error message is returned. 4. The only other solution I've discovered for clearing the error is stopping/restarting the CF service. However, the only server access I have is to the CF admin and the directory for my site files, so this is far from a convenient solution. Anyone else run into this? Is there a setting in CF administrator that might be causing this? Any suggestion on how stop this from happening (or at least clear the error without having to restart the service)? Thanks! Erica Lomax __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT problem with Javascript..
line 5 char 22 Which is ? With some context ? Thomas Chiverton __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: code optimization (was RE: Jsp Vs Cfm (CFMX) -- Test Code)
As you said it yourself (it was you, right?) there is a difference between performance and scalability. And I think most people are discussing performance here. There is a difference between performance and scalability and most people are discussing performance, which is my point. If people would attack scalability at an application level they would likely end up with better performance than trying to optimize individual CF pages. Remember the example I gave where switching from treating a long Base64 string as a string to treating it as an array gave a performance increase of a factor 4000. I have helped somebody else convert from using ListDeleteAt() to ArrayDeleteAt() and get a 100 fold performance increase. Sometimes code optimization is what you need. If the page in question was cached then it wouldn't matter what technique you used. The idea is to attack scalability at a high level. Code optimization is low level and takes significantly more time. -Matt __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using array syntax with a query
The variable foo.1 is illegal in ColdFusion. cfset foo.1 =rar cfoutput#foo.1#/cfoutput Works fine here on MX. The syntax you want is like qQuery.columname[index] i.e. qList.1[1] Thomas Chiverton __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Jsp Vs Cfm (CFMX) -- Test Code
You are giving reasons that it would be hard to do it right -- admittedly true! However the question should be: is it worth doing? Not today or tomorrow, but whenever it makes sense for competitive, sales and technical reasons! Good Point.. We all love CF and CF has come a long way to a standard Web Application Server and today... even taken further J2EE Compatible...and the goodies. Well.. CF will be in the same pool competing against all the other Web Application Servers Bea's WebLogic IBM's Websphere MS .NET and some of the others.. I personally think it would be great for a CFMX(RAD) to be able to achieve some of the performance like other competitiors in the market. The combination of RAD and Performance like any of its competitors will take CFMX to No 1 Web Application Server. Joe - Original Message - From: Dick Applebaum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 2:03 AM Subject: Re: Jsp Vs Cfm (CFMX) -- Test Code On Tuesday, September 17, 2002, at 10:10 PM, Sean A Corfield wrote: On Tuesday, September 17, 2002, at 09:18 , Dick Applebaum wrote: But, if the problem is caused by lack of typing, it seems to me that this is something MM can fix rather easily by allowing type definition by those who want to do it, and generating efficient code if it is present or use the current generation if it is not. Not easily, no. Adding type specifications to a type-less language - especially *optional* type specifications - complicates the compiler to quite a degree. Every reference to a variable has to be checked for known type information and, if present, either generate the appropriate code or warn of inappropriate usage. (If not present, it generates the same code as now). Read that carefully: *every* reference. That potentially impacts a lot of places in the code generator. Sean, even I can write a pre-compile scan that builds a table of any variables that are defined and typed -- and the a post-compile scan that replaces the currently generated code with optimal code for any variables that are defined. It'd be a kludge, but it would work. (where is that old Pascal book that with the compiler example?) I think that CF would lose little and gain quite a lot if it allowed an optional type definition. I agree that being able to declare types in CF would be a nice enhancement. But it would be a major change to the language. Yes it would -- but being optional it would be transparent to those who did not use it. Think of it as extending the reach of CF to places it could not go before. And then folks will want bitwise operations and full Java expression syntax inside cfscript! :) If these operations were justified, why not (although, really, how much demand is there for it -- we aren't using CF to write compilers, file systems or db engines -- just how often does one use bitmaps? ). BTW, nulls should also be allowed in CF! Hah! Adding 'null' to a language that doesn't currently support it is a *major* change and it's mostly a run-time change. It would cause a huge ripple through the CF language to add null because the semantics need to be defined (in documentation!) and it could impact every single expression in the language. Consider isStruct() - should isStruct( null ) return false or should it just fail with a null pointer exception (which is what happens now if you manage to feed it a null). What about isDefined()? Right now, if you manage to create a struct key entry with a null value, isDefined( str.key ) is false but structKeyExists( str, key ) is true. In fact isDefined( v ) is false whenever either 'v' is not declared *or* it has a null value. Hah, I knew that would get you! OK, I'll drop down to Java just to get a null. But the ability to pass a null only in cfobject would be a start -- yes it would apply to all variable types (oh, there *are* variable types), but the changes would be localized to the cfobject tag, and an IsNull function that are sensitive to all variable types. But, null is something that CF eventually must address -- surprised that they didn't do it in CFMX. Just remember that these are not meant as criticisms, but as ways to make one of the best systems even better -- If we didn't care, we wouldn't bother! Dick All the woulda, coulda, shouldas lyin' in the sun... ..talkin' 'bout what they woulda, coulda, shoulda done. All those woulda, coulda, shouldas went out and hid .. from one little did! - Shel Silverstein Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community.
RE: Calculating Shipping charges...
Check these links out. http://www.ec.ups.com/ecommerce/solutions/c1.html#tools https://www.fedex.com/solutions/go/Overview?link=4#shipping http://164.109.64.180/front2.asp --- usps -Original Message- From: Yager, Brian T Contractor/Sverdrup [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:36 AM To: CF-Talk Subject: Calculating Shipping charges... I'm developing a shopping cart. Can anyone give me some ideas as to how to calculate shipping? I know the first question is going to be Who is doing the shipping?. The answer to that is I don't know. Whoever the owner of the shopping cart wants. It could be UPS, Fed Ex, USPS...If there are ways to calculate all of these (based on some criteria), I would love to know. I appreciate any and all help on this. Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Jsp Vs Cfm (CFMX) -- Test Code
Try javacast, which is a new function in cfmx cfscript x = 1; y = javacast(int,x); /cfscript -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:30 AM To: CF-Talk Subject: RE: Jsp Vs Cfm (CFMX) -- Test Code I doubt anyone outside of Macromedia can answer that. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 11:41 PM To: CF-Talk Subject: RE: Jsp Vs Cfm (CFMX) -- Test Code Would the below be an easy change in CFMX? cfset int foobar = 1 or cfscript int foobar = 1; /cfscript Would declare a coldfusion.runtime.Integer instead of the following. cfset foobar = 1 or cfscript foobar = 1; /cfscript Would declare a coldfusion.runtime.Variable. Joe -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 1:12 AM To: CF-Talk Subject: RE: FW: Jsp Vs Cfm (CFMX) -- Test Code Well CF could use the same technique that VB did. VB optionally allows variables to be declared as a type. If no type is declared then the variable is considered of type variant. For example, the following could work with CF. cfset int foobar = 1 or cfscript int foobar = 1; /cfscript Would declare a coldfusion.runtime.Integer instead of the following. cfset foobar = 1 or cfscript foobar = 1; /cfscript Would declare a coldfusion.runtime.Variable. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 9:56 PM To: CF-Talk Subject: Re: FW: Jsp Vs Cfm (CFMX) -- Test Code On Tuesday, September 17, 2002, at 09:41 , Dick Applebaum wrote: Rather I suggest that CFMX allow us to tell it a variable's type (optionally) so that it can use that to generate efficient code, That would make ColdFusion quite a different language! :) Yes, it's certainly one possible approach, allowing the user to declare variables with a type (and extending the CF types to include integer would also be a useful enhancement, instead of just numeric and binary ). I actually prefer the code analysis approach since it allows CFMX's compiler to evolve without requiring users to change their code and could substantially speed up certain constructs in legacy code. If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cached Stored Procedure Errors?
It sounds like you are having the same problem I had yesterday. Make sure that your Trusted Cache is turned off in the CF admin. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:18 AM To: CF-Talk Subject: Cached Stored Procedure Errors? In working with our MX development server (Win2K w/.NET framework), I've noticed a problem with cached errors with stored procedures (oracle db). Here's what I've determined so far: 1. If I run a .cfm page that calls a sp, and an error is returned (usually due to some programming error, like sending wrong datatypes) that error seems to get cached. I can go in and correct the coldfusion page and/or the sp, re-run the page but error continues. 2. If I create a new sp (new name) with the corrected code and call it from my corrected cfm page, everything works fine. 3. If I drop the original sp, and call it from the cfm page, I receive the standard does not exist error. If I then create an sp with the original name and corrected code, and then run it from the cfm page, the original error message is returned. 4. The only other solution I've discovered for clearing the error is stopping/restarting the CF service. However, the only server access I have is to the CF admin and the directory for my site files, so this is far from a convenient solution. Anyone else run into this? Is there a setting in CF administrator that might be causing this? Any suggestion on how stop this from happening (or at least clear the error without having to restart the service)? Thanks! Erica Lomax __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Calculating Shipping charges...
There are many ways to create shipping modules and methods for calculating shipping. Take a look at a few different shopping cart programs and see how they are implementing shipping. SiteDirector has a pretty robust amont of choices in our v2.0 and even more in v3.0... We came up with various ways from what various customers were looking for. I think at this point (v3.0) we have covered almost all the bases. Best is to look around at what everyone else is doing. Paul Giesenhagen QuillDesign - Original Message - From: Yager, Brian T Contractor/Sverdrup [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 9:35 AM Subject: Calculating Shipping charges... I'm developing a shopping cart. Can anyone give me some ideas as to how to calculate shipping? I know the first question is going to be Who is doing the shipping?. The answer to that is I don't know. Whoever the owner of the shopping cart wants. It could be UPS, Fed Ex, USPS...If there are ways to calculate all of these (based on some criteria), I would love to know. I appreciate any and all help on this. Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Calculating Shipping charges...
I know that UPS bases shipping charges on shipping type (overnight, ground, etc), destination (in the US based on zip), weight, whether the destination is commercial or residential, and box size. Generally, if the box is not defined as oversize, you can ignore it. So, if you know the zips of the sender and reciever, wieght, and how you want to send it, you can calc the UPS rate. http://wwwapps.ups.com/servlet/QCCServlet?iso_language=eniso_country=US lets you do it online, and I think there's a web service for it as well. I'd guess the other services are similar. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Yager, Brian T Contractor/Sverdrup : [mailto:[EMAIL PROTECTED]] : Sent: Wednesday, September 18, 2002 10:36 AM : To: CF-Talk : Subject: Calculating Shipping charges... : : : I'm developing a shopping cart. Can anyone give me some ideas as : to how to : calculate shipping? I know the first question is going to be : Who is doing the : shipping?. The answer to that is I don't know. Whoever the : owner of the : shopping cart wants. It could be UPS, Fed Ex, USPS...If there are ways to : calculate all of these (based on some criteria), I would love to know. I : appreciate any and all help on this. : : Thanks, : : Brian Yager : President - North AL Cold Fusion Users Group : http://www.nacfug.com : Sr. Systems Analyst : Sverdrup/CIC : [EMAIL PROTECTED] : (256) 842-8342 : : __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using array syntax with a query
cfset foo.1 =rar cfoutput#foo.1#/cfoutput The same code breaks CF5. It's cool that it works on CFMX. I haven't had a chance to use MX yet, but it sounds like the parser is a little more forgiving. Thanks for the correct syntax (and also from the earlier post from Raymond)! -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 7:41 AM To: CF-Talk Subject: RE: Using array syntax with a query The variable foo.1 is illegal in ColdFusion. cfset foo.1 =rar cfoutput#foo.1#/cfoutput Works fine here on MX. The syntax you want is like qQuery.columname[index] i.e. qList.1[1] Thomas Chiverton __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL: Returning columns with null values when specific columns are unknown at runtime
Is there a way to write a MSSQL 2k query that will return a result set that contains only columns with null values when you don't know explicitly which columns those will be? So if I have this data pk | col 1 | col 2 | col 3 | col 4| 1 1 2nullnull 2null4 nullnull I'd like a query that would return col 3 and col 4 where pk = 1 or col 1, col 3 and col 4 where pk=2. Is this possible? -Patti __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Calculating Shipping charges...
We've used the CFINTERSHIPPER tag from Michael Sheldon before. The Intershipper service is a supports UPS, FedEx, US Postal Service, Airborne, Bax Global, DHL, Emery, and Airnet.. The service seemed to be down quite a bit during the three years we used it, but it was nice. We could let the customers see all the options and choose the one they wanted. Check out http://www.intershipper.com and download the tags there. Dave - Original Message - From: Yager, Brian T Contractor/Sverdrup [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 10:35 AM Subject: Calculating Shipping charges... I'm developing a shopping cart. Can anyone give me some ideas as to how to calculate shipping? I know the first question is going to be Who is doing the shipping?. The answer to that is I don't know. Whoever the owner of the shopping cart wants. It could be UPS, Fed Ex, USPS...If there are ways to calculate all of these (based on some criteria), I would love to know. I appreciate any and all help on this. Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Timezones and CF
I use... don't hate me Acesss! For the scale of things it's fine.. I used the code... cfset austime= #now()# + #createTimeSpan(0,8,0,0)# from Michael Kear... and it's worked fine... with the time dunno about the day yet... but he says it works. What DB are you using? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Get path to CFModule called custom tag
Is there any way to get the directory that a custom tag is in and use that info IN the custom tag itself when called with CFmodule? I have a tag that plays two roles- first its a custom tag that generates some code in the calling template second it is an html page that gats called into a popup window by the code that was generated in the first role. So if I call this tag using cfmodule I want the tag itself to know where it resides without having to pass it as another attibute manually. --Any ideas? Thanks, David Murphy www.cfugcny.org ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Returning columns with null values when specific columns are unknown at runtime
The only thing I can think to do is create a bunch of OR statements i.e.: WHERE colA IS NULL OR colB IS NULL OR colN IS NULL ~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion 5 Developer Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:54 To: CF-Talk Subject: SQL: Returning columns with null values when specific columns are unknown at runtime Is there a way to write a MSSQL 2k query that will return a result set that contains only columns with null values when you don't know explicitly which columns those will be? So if I have this data pk | col 1 | col 2 | col 3 | col 4| 1 1 2nullnull 2null4 nullnull I'd like a query that would return col 3 and col 4 where pk = 1 or col 1, col 3 and col 4 where pk=2. Is this possible? -Patti __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Jsp Vs Cfm (CFMX) -- Test Code
JavaCast isn't new for CFMX as it has been around since CF 4.5. Its purpose is for helping CF determine which method to call in Java classes that have overloaded methods. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Michael Corbridge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 7:44 AM To: CF-Talk Subject: RE: Jsp Vs Cfm (CFMX) -- Test Code Try javacast, which is a new function in cfmx cfscript x = 1; y = javacast(int,x); /cfscript -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:30 AM To: CF-Talk Subject: RE: Jsp Vs Cfm (CFMX) -- Test Code I doubt anyone outside of Macromedia can answer that. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 11:41 PM To: CF-Talk Subject: RE: Jsp Vs Cfm (CFMX) -- Test Code Would the below be an easy change in CFMX? cfset int foobar = 1 or cfscript int foobar = 1; /cfscript Would declare a coldfusion.runtime.Integer instead of the following. cfset foobar = 1 or cfscript foobar = 1; /cfscript Would declare a coldfusion.runtime.Variable. Joe -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 1:12 AM To: CF-Talk Subject: RE: FW: Jsp Vs Cfm (CFMX) -- Test Code Well CF could use the same technique that VB did. VB optionally allows variables to be declared as a type. If no type is declared then the variable is considered of type variant. For example, the following could work with CF. cfset int foobar = 1 or cfscript int foobar = 1; /cfscript Would declare a coldfusion.runtime.Integer instead of the following. cfset foobar = 1 or cfscript foobar = 1; /cfscript Would declare a coldfusion.runtime.Variable. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 9:56 PM To: CF-Talk Subject: Re: FW: Jsp Vs Cfm (CFMX) -- Test Code On Tuesday, September 17, 2002, at 09:41 , Dick Applebaum wrote: Rather I suggest that CFMX allow us to tell it a variable's type (optionally) so that it can use that to generate efficient code, That would make ColdFusion quite a different language! :) Yes, it's certainly one possible approach, allowing the user to declare variables with a type (and extending the CF types to include integer would also be a useful enhancement, instead of just numeric and binary ). I actually prefer the code analysis approach since it allows CFMX's compiler to evolve without requiring users to change their code and could substantially speed up certain constructs in legacy code. If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX installation nightmare
When you say none of the other pages will load, what error are you getting? Also this an ugrade or clean install? Were all other installtions the same - upgrade or clean install? - Original Message - From: Cameron Childress [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 9:59 AM Subject: CFMX installation nightmare Ok, I have installed CFMX on 5 or 6 systems, all without a hitch. Now I go out to a client location today and attempt to install CFMX on an NT4(6a)/IIS4 system and everything goes totally haywire. Problem one: During installation, after choosing all the options, entering the serials etc, it goes into the install. Right as it is about to start copying files, I get error 1303 something to the effect that permissions do not allow the installer to access e:/inetpub/wwwroot/cfide, please login as an administrator and try the install again. Well, I am logged in using the domain admin account, and the permissions on E: are set to allow Domain admins permissions to that directory - and all directories for that matter, there are no special permissions on that volume AFAIK. Problem two: I finally get past this problem after trying the install about 5 times by choosing to install the cfide on c:. No problem, install goes fine... The admin opens, and I think I'm in business... Wrong... None of the other .cfm pages will load. I read an article or two on changing a setting for a multi-homed server (which this is not). Try the suggestions anyway, no help. I really am very frustrated at this point and am sure I'm not considering something right under my nose. It's not like I've never installed CF, or CFMX, this install is just going horribly wrong, and I don't know why... Suggestions? -Cameron - Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFmail inside of CF error page
How do you send the email? I am not sure if this is a MX thing, but the ALLERRORS.cfm page in your example cannot run any CF code. It ignores tags like CFMail. -Original Message- From: Mark Stephenson - Evolution Internet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 8:19 AM To: CF-Talk Subject: RE: CFmail inside of CF error page I have a few sites that do this... In your application.cfm file put something like cfapplication name=Builda clientmanagement=Yes sessionmanagement=Yes setclientcookies=Yes !--- cferror type=REQUEST template=ALLERRORS.cfm cferror type=EXCEPTION template=ALLERRORS.cfm cferror type=MONITOR template=ALLERRORS.cfm cferror type=VALIDATION template=ALLERRORS.cfm --- Then when an error occurs the ALLERRORS.cfm page runs. Put whatever you like in this Mark Stephenson New Media Director Evolution Internet T: 0870 757 1631 F: 0870 757 1632 W: www.evolutioninternet.co.uk E: [EMAIL PROTECTED] This email, together with any attachments, is for the exclusive and confidential use of the addressee(s). Any other distribution, use or reproduction without the sender's prior consent is unauthorised and strictly prohibited. If you have received this message in error, please notify the sender by email immediately and delete the message from your computer without making any copies. -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: 18 September 2002 14:44 To: CF-Talk Subject: CFmail inside of CF error page I am wondering if there is a way to put a CFMail inside of the error page that CF generates? That way we can be notified if an error occurs on the web site, and email the exact error. Is the error page a CF template? Is it encrypted? We tried wrapping all of the pages with cftry/cfcatch in application.cfm, and onendrequest.com, but CF does not like the tag broken up like that. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Linux vs. Windows
Hey everybody The boss wants to know what the advantages are for running CFMX on Win2K vs. Linux and vise-versa. Any good websites, or is this one of those Check the archives you fool questions? ;) (lol) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Returning columns with null values when specific columns are unknown at runtime
Thanks, but that doesn't get me where I want. I ONLY want to return the columns that ARE null, and I never know which ones those are when I run this query... so what I need is something for the select statement. -Patti - Original Message - The only thing I can think to do is create a bunch of OR statements i.e.: WHERE colA IS NULL OR colB IS NULL OR colN IS NULL ~Simon -Original Message- Is there a way to write a MSSQL 2k query that will return a result set that contains only columns with null values when you don't know explicitly which columns those will be? So if I have this data pk | col 1 | col 2 | col 3 | col 4| 1 1 2nullnull 2null4 nullnull I'd like a query that would return col 3 and col 4 where pk = 1 or col 1, col 3 and col 4 where pk=2. Is this possible? -Patti __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Link Buttons That I Control
Hi I have a client who wants other poeple to like to their site - but I want to be able to control it to a certain degree - because once they have copied and pasted the link I have little control apart from atering the graphic - is there a way I can embed some javascript or something - that will call a coldfusion page on my server and return the up-to-date button code to the webpage of the linker - also possibility of using somesort of referer to track the best buttons? Take a look at what I have already done. http://www.acrossthetrax.co.uk/links/ this should be in a popup... so don't worry about the layout.. Cheers Mark __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Get path to CFModule called custom tag
GetCurrentTemplatePath(), or a similar CF function? Chris Norloff -- Original Message -- from: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Wed, 18 Sep 2002 10:58:11 -0400 Is there any way to get the directory that a custom tag is in and use that info IN the custom tag itself when called with CFmodule? I have a tag that plays two roles- first its a custom tag that generates some code in the calling template second it is an html page that gats called into a popup window by the code that was generated in the first role. So if I call this tag using cfmodule I want the tag itself to know where it resides without having to pass it as another attibute manually. --Any ideas? Thanks, David Murphy www.cfugcny.org ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Using array syntax with a query
Why does this work? Variables and structure names have never been able to start with number before. Is CF looking at the number and making foo an array or what? I don't have an MX box handy right now or I would test it... -- jon mailto:[EMAIL PROTECTED] Wednesday, September 18, 2002, 10:50:58 AM, you wrote: BF cfset foo.1 =rar BF cfoutput#foo.1#/cfoutput BF The same code breaks CF5. It's cool that it works on CFMX. I haven't had a BF chance to use MX yet, but it sounds like the parser is a little more BF forgiving. BF Thanks for the correct syntax (and also from the earlier post from Raymond)! BF -Original Message- BF From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] BF Sent: Wednesday, September 18, 2002 7:41 AM BF To: CF-Talk BF Subject: RE: Using array syntax with a query The variable foo.1 is illegal in ColdFusion. BF cfset foo.1 =rar BF cfoutput#foo.1#/cfoutput BF Works fine here on MX. BF The syntax you want is like qQuery.columname[index] i.e. qList.1[1] BF Thomas Chiverton BF __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Calculating Shipping charges...
Find out what the shipping charges/criteria are and write a function. Then call the function. On Wed, 18 Sep 2002, Yager, Brian T Contractor/Sverdrup wrote: I'm developing a shopping cart. Can anyone give me some ideas as to how to calculate shipping? I know the first question is going to be Who is doing the shipping?. The answer to that is I don't know. Whoever the owner of the shopping cart wants. It could be UPS, Fed Ex, USPS...If there are ways to calculate all of these (based on some criteria), I would love to know. I appreciate any and all help on this. Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFmail inside of CF error page
Erm... I wrote the sites when using 4.5... Now using 5... I'll test see if it still works!!! Does it ignore CFINCLUDE??? Mark Stephenson New Media Director Evolution Internet T: 0870 757 1631 F: 0870 757 1632 W: www.evolutioninternet.co.uk E: [EMAIL PROTECTED] This email, together with any attachments, is for the exclusive and confidential use of the addressee(s). Any other distribution, use or reproduction without the sender's prior consent is unauthorised and strictly prohibited. If you have received this message in error, please notify the sender by email immediately and delete the message from your computer without making any copies. -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: 18 September 2002 16:13 To: CF-Talk Subject: RE: CFmail inside of CF error page How do you send the email? I am not sure if this is a MX thing, but the ALLERRORS.cfm page in your example cannot run any CF code. It ignores tags like CFMail. -Original Message- From: Mark Stephenson - Evolution Internet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 8:19 AM To: CF-Talk Subject: RE: CFmail inside of CF error page I have a few sites that do this... In your application.cfm file put something like cfapplication name=Builda clientmanagement=Yes sessionmanagement=Yes setclientcookies=Yes !--- cferror type=REQUEST template=ALLERRORS.cfm cferror type=EXCEPTION template=ALLERRORS.cfm cferror type=MONITOR template=ALLERRORS.cfm cferror type=VALIDATION template=ALLERRORS.cfm --- Then when an error occurs the ALLERRORS.cfm page runs. Put whatever you like in this Mark Stephenson New Media Director Evolution Internet T: 0870 757 1631 F: 0870 757 1632 W: www.evolutioninternet.co.uk E: [EMAIL PROTECTED] This email, together with any attachments, is for the exclusive and confidential use of the addressee(s). Any other distribution, use or reproduction without the sender's prior consent is unauthorised and strictly prohibited. If you have received this message in error, please notify the sender by email immediately and delete the message from your computer without making any copies. -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: 18 September 2002 14:44 To: CF-Talk Subject: CFmail inside of CF error page I am wondering if there is a way to put a CFMail inside of the error page that CF generates? That way we can be notified if an error occurs on the web site, and email the exact error. Is the error page a CF template? Is it encrypted? We tried wrapping all of the pages with cftry/cfcatch in application.cfm, and onendrequest.com, but CF does not like the tag broken up like that. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Text File Datasources
I defined a datasource using the Merant text file driver. What do I use for table names in the where clause of my query? What would it be if I used the MS driver? TIA Sam Changed your e-mail? Keep your contacts! Use this free e-mail change of address service from Return Path. Register now! __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Returning columns with null values when specific columns are unknown at runtime
SELECT CASE WHEN pk = 1 THEN col3 END AS newcol1, CASE WHEN pk = 1 THEN col4 END AS newcol2, CASE WHEN pk = 2 THEN col1 END AS newcol1, CASE WHEN pk = 2 THEN col2 END AS newcol2 FROM mytable -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:54 AM To: CF-Talk Subject: SQL: Returning columns with null values when specific columns are unknown at runtime Is there a way to write a MSSQL 2k query that will return a result set that contains only columns with null values when you don't know explicitly which columns those will be? So if I have this data pk | col 1 | col 2 | col 3 | col 4| 1 1 2nullnull 2null4 nullnull I'd like a query that would return col 3 and col 4 where pk = 1 or col 1, col 3 and col 4 where pk=2. Is this possible? -Patti __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Returning columns with null values when specific columns are unknown at runtime
How about this or am I still missing something Select * from TABLENAME WHERE col1 IS NULL OR col2 IS NULL OR col3 IS NULL OR col4 IS NULL Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/18/2002 11:17:41 AM Thanks, but that doesn't get me where I want. I ONLY want to return the columns that ARE null, and I never know which ones those are when I run this query... so what I need is something for the select statement. -Patti - Original Message - The only thing I can think to do is create a bunch of OR statements i.e.: WHERE colA IS NULL OR colB IS NULL OR colN IS NULL ~Simon -Original Message- Is there a way to write a MSSQL 2k query that will return a result set that contains only columns with null values when you don't know explicitly which columns those will be? So if I have this data pk | col 1 | col 2 | col 3 | col 4| 1 1 2nullnull 2null4 nullnull I'd like a query that would return col 3 and col 4 where pk = 1 or col 1, col 3 and col 4 where pk=2. Is this possible? -Patti __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Link Buttons That I Control
I have just found this... and this is the kind of thing I am looking for a way of using Javascript to call a cfm file http://fuselets.com/cftips/index.html __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX installation nightmare
Initially it was an upgrade - now I've wiped the old version 4.5 off (client had it) and have tried a number of times from scratch. I have a feeling that if I could get beyond the Error 1303 : The Installer has insufficient privileges to access this directory when installing the CFIDE. I'm going to take a second look at their server when I go over there tomorrow to double check and make sure there are no weird permissions, but I checked last time and didn't see any. -Cameron - Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 11:09 AM To: CF-Talk Subject: Re: CFMX installation nightmare When you say none of the other pages will load, what error are you getting? Also this an ugrade or clean install? Were all other installtions the same - upgrade or clean install? - Original Message - From: Cameron Childress [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 9:59 AM Subject: CFMX installation nightmare Ok, I have installed CFMX on 5 or 6 systems, all without a hitch. Now I go out to a client location today and attempt to install CFMX on an NT4(6a)/IIS4 system and everything goes totally haywire. Problem one: During installation, after choosing all the options, entering the serials etc, it goes into the install. Right as it is about to start copying files, I get error 1303 something to the effect that permissions do not allow the installer to access e:/inetpub/wwwroot/cfide, please login as an administrator and try the install again. Well, I am logged in using the domain admin account, and the permissions on E: are set to allow Domain admins permissions to that directory - and all directories for that matter, there are no special permissions on that volume AFAIK. Problem two: I finally get past this problem after trying the install about 5 times by choosing to install the cfide on c:. No problem, install goes fine... The admin opens, and I think I'm in business... Wrong... None of the other .cfm pages will load. I read an article or two on changing a setting for a multi-homed server (which this is not). Try the suggestions anyway, no help. I really am very frustrated at this point and am sure I'm not considering something right under my nose. It's not like I've never installed CF, or CFMX, this install is just going horribly wrong, and I don't know why... Suggestions? -Cameron - Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
IIS Localhost
How can I restrict IIS access to 127.0.0.1 only running wk2pro? Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFmail inside of CF error page
Actually I started poking around the MX directories and found this folder: \CFusionMX\wwwroot\WEB-INF\exception It appears that all the error templates are open source. I going to start playing with them and see if I can get the results I want. -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:13 AM To: CF-Talk Subject: RE: CFmail inside of CF error page How do you send the email? I am not sure if this is a MX thing, but the ALLERRORS.cfm page in your example cannot run any CF code. It ignores tags like CFMail. -Original Message- From: Mark Stephenson - Evolution Internet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 8:19 AM To: CF-Talk Subject: RE: CFmail inside of CF error page I have a few sites that do this... In your application.cfm file put something like cfapplication name=Builda clientmanagement=Yes sessionmanagement=Yes setclientcookies=Yes !--- cferror type=REQUEST template=ALLERRORS.cfm cferror type=EXCEPTION template=ALLERRORS.cfm cferror type=MONITOR template=ALLERRORS.cfm cferror type=VALIDATION template=ALLERRORS.cfm --- Then when an error occurs the ALLERRORS.cfm page runs. Put whatever you like in this Mark Stephenson New Media Director Evolution Internet T: 0870 757 1631 F: 0870 757 1632 W: www.evolutioninternet.co.uk E: [EMAIL PROTECTED] This email, together with any attachments, is for the exclusive and confidential use of the addressee(s). Any other distribution, use or reproduction without the sender's prior consent is unauthorised and strictly prohibited. If you have received this message in error, please notify the sender by email immediately and delete the message from your computer without making any copies. -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: 18 September 2002 14:44 To: CF-Talk Subject: CFmail inside of CF error page I am wondering if there is a way to put a CFMail inside of the error page that CF generates? That way we can be notified if an error occurs on the web site, and email the exact error. Is the error page a CF template? Is it encrypted? We tried wrapping all of the pages with cftry/cfcatch in application.cfm, and onendrequest.com, but CF does not like the tag broken up like that. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
