Re: FW: Error Diagnostic Information CF_POOF?
If I remember correctly... I would get these from time to time when my cfml was causing the CFserver to Restart. Usually associated with a query that was upsetting in some way. And always baffling until I tried the queries by pasting into another query tool or some such... Perhaps cf is throwing up on the query result... the error message perhaps ... just wild guesses actually. At 09:50 AM 7/23/02, you wrote: OK. I never ask unless I am stumped. I'm sure somebody has run into this b/c when I do a search on the 'Net for the error, I get links to various other CFM web pages that have thrown the error while being indexed by the search engines. Here goes First the stats: Server: Windows NT 4.0 ~ I suspect with all the most current updates (Shared host~ XO Communications) CF Server: 4.5 ~ patched and updated I hope! Database: Access 2000 (Sorry, I can't afford a Lexus either.) Connection: OC48 dual redundant to the backbone (so they say!) Client: OS: Windows 98/2000/XP Browser: IE6 Connection: DSL Cache: Clear w/ 1 meg storage setting and Every visit... checked. XX ERROR::: XX Error Occurred While Processing Request Error Diagnostic Information An error occurred while attempting to establish a connection to the service. The most likely cause of this problem is that the service is not currently running. You can use the 'Services' Control Panel to verify that the service is running and to restart it if necessary. Windows NT error number 2 occurred. XX PAGE CODE :: XX cfif isdefined (customerid)/cfif cfquery datasource=schome name=getinfo select * from agentid where customerid=#customerid# /cfquery cfoutput query = getinfo This page uses frames, but your browser doesn't support them. /cfoutput I made absolute paths out of the individual frames for ease of lookup... It is broken either way, absolute or relative. This error happens intermittently...sometimes often, other times it takes several refreshes to get it to happenclearing the cache helps ensure the error is seen. Sometimes one frame will work, other times 2 frame pages will resolve and one will not...there is no rhyme or reason I can see. I have tried to isolate this as a browser issue or an OS problem, but I really think it is either a codeing problem or a Server issue. ( I'm praying it's their fault and they can fix it.) The most I could find out about Windows NT error number 2 is that it means Page not found (Duhuh... Another egregious waste of syntax by our good friends at MS!) This, CF Developers, is your missionshould you choose to accept it. This message will self destruct in 5..4...3...2 CF_POOF Thanks. Michael Pool [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: FW: Error Diagnostic Information CF_POOF?
Hi We some times get this under extreme load from running multiple large queries at the same time (hence the reason your search returned the same error message - the sites must have been experiencing high traffic when spidered by the search engine). Check that the web server or coldfusion does not need restarting. It may also be lock related to make sure you're locking all your shared scope variables HTH Kola -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: 23 July 2002 07:37 To: CF-Talk Subject: Re: FW: Error Diagnostic Information CF_POOF? If I remember correctly... I would get these from time to time when my cfml was causing the CFserver to Restart. Usually associated with a query that was upsetting in some way. And always baffling until I tried the queries by pasting into another query tool or some such... Perhaps cf is throwing up on the query result... the error message perhaps ... just wild guesses actually. At 09:50 AM 7/23/02, you wrote: OK. I never ask unless I am stumped. I'm sure somebody has run into this b/c when I do a search on the 'Net for the error, I get links to various other CFM web pages that have thrown the error while being indexed by the search engines. Here goes First the stats: Server: Windows NT 4.0 ~ I suspect with all the most current updates (Shared host~ XO Communications) CF Server: 4.5 ~ patched and updated I hope! Database: Access 2000 (Sorry, I can't afford a Lexus either.) Connection: OC48 dual redundant to the backbone (so they say!) Client: OS: Windows 98/2000/XP Browser: IE6 Connection: DSL Cache: Clear w/ 1 meg storage setting and Every visit... checked. XX ERROR:: : XX Error Occurred While Processing Request Error Diagnostic Information An error occurred while attempting to establish a connection to the service. The most likely cause of this problem is that the service is not currently running. You can use the 'Services' Control Panel to verify that the service is running and to restart it if necessary. Windows NT error number 2 occurred. XX PAGE CODE::: : :: XX cfif isdefined (customerid)/cfif cfquery datasource=schome name=getinfo select * from agentid where customerid=#customerid# /cfquery cfoutput query = getinfo This page uses frames, but your browser doesn't support them. /cfoutput I made absolute paths out of the individual frames for ease of lookup... It is broken either way, absolute or relative. This error happens intermittently...sometimes often, other times it takes several refreshes to get it to happenclearing the cache helps ensure the error is seen. Sometimes one frame will work, other times 2 frame pages will resolve and one will not...there is no rhyme or reason I can see. I have tried to isolate this as a browser issue or an OS problem, but I really think it is either a codeing problem or a Server issue. ( I'm praying it's their fault and they can fix it.) The most I could find out about Windows NT error number 2 is that it means Page not found (Duhuh... Another egregious waste of syntax by our good friends at MS!) This, CF Developers, is your missionshould you choose to accept it. This message will self destruct in 5..4...3...2 CF_POOF Thanks. Michael Pool [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: CF Server Error Msg - unknown exception condition - TagCFX::e xecu te
The tag is a java tag not c++. I'm not sure if it makes a difference. Maybe I don't have the java settings correct in the cf admin page, I'm working off a newly configured server. Thanks, Dave -Original Message- From: Van Vliet, Scott [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 6:14 PM To: CF-Talk Subject: RE: CF Server Error Msg - unknown exception condition - TagCFX::e xecu te The problem is a result of an exception in the execute method of the TagCFX C++ class. I have run accross this before, and it turned out to be system incompatibility (the CFX was built and compiled on NT 4, but we were trying to use it on W2K). You might contact the author of CFX_AUTHSMTP and see if they have any incompatibility issues. Also, Mike Brunt made a good point about locking those CFX calls - especially when using C++ CFX tags. One bad pointer or copy constructor and your overwritting everything! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 2:03 PM To: CF-Talk Subject: CF Server Error Msg - unknown exception condition - TagCFX::execu te Anybody know what causes this error and how I can resolve the issue??? Error Diagnostic Information unknown exception condition TagCFX::execute The error occurred while processing an element with a general identifier of (CFX_AUTHSMTP) Thanks, Dave 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. __ 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: Printing : Revisited
I had another thought on this matter, and was wondering if any one else has tried it. Lets say I had the server generate all of the letters to be printed and copied them to a file print driver, had the client download the file, and then manually send it to the printer? Dan -Original Message- From: Dan O'Keefe [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 5:30 PM To: CF-Talk Subject: RE: Printing You know what though, I need to print to a clients printer, so I assume I will be talking JavaScript and the window.print method. I will need to print a number of letters with the dynamic name and address, similar to a mail merge. Dan -Original Message- From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 3:01 PM To: CF-Talk Subject: RE: Printing copy file.txt lpt1 is it is local or if you have captured the printer in dos to lpt1 if it is networked. I do that exact thing using cffile then exexecute. It sends it through the server to a printer that everyone works on. Joshua Tipton -Original Message- From: Dan O'Keefe [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 2:58 PM To: CF-Talk Subject: Printing What is the easiest way to send a text document to a printer from CFML. I would imagine writing the file out with CFFILE and somehow initiating a DOS command such as: copy file.txt PRN Dan - Dan O'Keefe TriPoint Technologies 954.501.3115 __ 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 CFM/JSP/Servlets/Beans Compile?
Thanks, but it looks like the code is using CFHTTP to run the pages.. i was looking to run some command line code using a *.bat file or some. something like cfexecute name=C:\Compile\*.bat outputFile = F:\Temp\output.txt /cfexecute Save this code to a .bat file (or whatever)... setlocal set NEO_INSTALL=c:\cfusionMX set PATH=%NEO_INSTALL%\runtime\bin;%PATH% java -classpath %NEO_INSTALL%\lib\cfusion.jar coldfusion.tools.Compiler -webroot %NEO_INSTALL%\wwwroot %* endlocal Obviously, change the install paths, as appropriate, depending on your system. Regards, Dave. __ 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
MX inSite Magazine
Is anybody here subscribed to MX inSite Magazine? If so, what do you think? I'd like some feedback before I invest . . . KWIM? Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] If your wife is having fun and you're not, you're still having a lot more fun than if you're having fun and she's not!' - Red Green __ 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
Dubugging CFMX / Breakpoints Help
Trying to debug my app. I've set my breakpoints but it seems as if I cannot get the application to stop on them. The debugger is nice, much improved over the old CF stuff. Any good documentation or articles on the new CFMX debugger? Thanks. Daniel Bogesdorfer Senior Programmer / Analyst Office Of Research Health Sciences University of Pittsburgh 412.648.2366 __ 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: Data out of cfloginuser
cflogin.name and cflogin.username are created by the cflogin and not cfloginuser. Also, these values are available only within the body of the cflogin. HTH Kumaran -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 4:05 PM To: CF-Talk Subject: Re: Data out of cfloginuser Is this a bug? According to the docs it should be cflogin.name and cflogin.password. - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 3:45 PM Subject: RE: Data out of cfloginuser Anyone know if it is possible to read data out of cfloginuser? I have a situation where I would like to add a role for a user 5 to 10 pages after they have logged in. No - however, it's in our enhancement queue. (Doesn't mean it will get added - just that others have asked for it.) Well - correction - you CAN get the current username (getAuthUser()). And, you can count the pages they hit using a sesison var. And you CAN cflogout a user and then log them back in with the new role. That should work. It is possible to run the cfloginuser tag again, but I need to know what the password and roles are so that I can set them again! Do a lookup. I assume you have a username/password table. Just do a look up getAuthUser(). === Raymond Camden, ColdFusion Jedi Master for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda __ 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: Mass Email Solution
Matt; Could you expand on this simplistic answer just a little more please. Could you provide a sample template of what needs to be done by CFFILE in order to write directly to the QMAIL QUEUE. This sounds very intriguing to me. I would be open to anything that makes my outgoing mail work better. Thanks in Advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 1:29 PM To: CF-Talk Subject: RE: Mass Email Solution Go get qmail for free and use cffile to write emails directly to its queue. That will get you an MTA that can easily do a million emails in a day. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 11:27 AM To: CF-Talk Subject: Re: Mass Email Solution The current version is Windows only but we have long-term plans for a Linux version. Regards, Howie - Original Message - From: Chris Edwards [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 2:07 PM Subject: Re: Mass Email Solution I'm looking for a Unix/Windows solution, mainly a Unix one. Will iMS-SE run on Unix? - Original Message - From: Howie Hamlin [EMAIL PROTECTED]; [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 1:14 PM Subject: Re: Mass Email Solution You may want to have a look at iMS-SE for this. iMS-SE is a high-performance mail sending engine for ColdFusion that does not require an external email server like other CFMAIL replacements do. iMS is the mail sending engine behind all of the House of Fusion lists, BTW. Here is a comparison of iMS-SE versus other CFMAIL replacements: http://www.coolfusion.com/imssecomparison.cfm You can download and install a fully-functional 60-day trial from our downloads page. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Chris Edwards [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 12:03 PM Subject: Mass Email Solution Hey, Any suggestions on the best way to manage and send email to a list of about 10,000 in an efficient manner? Would I need to use a high-performance mail build? Should I not use cfmail, but a compiled tag? Thanks. __ 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 CFM/JSP/Servlets/Beans Compile?
Try this: To precompile CF templates: Save the code below as MXCompile.bat in C:\ @setlocal set NEO_INSTALL=c: \cfusionMX set PATH=%NEO_INSTALL% \runtime\bin;%PATH% java -classpath %NEO_INSTALL%\lib\cfusion .jar coldfusion .tools.Compiler -webroot %NEO_INSTALL%\wwwroot %* @endlocal Run with this, pointing to a directory: C:\ MXcompile.bat c:\cfusionMX \wwwroot\CFIDE\administrator -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 2:23 AM To: CF-Talk Subject: RE: CFMX CFM/JSP/Servlets/Beans Compile? Thanks, but it looks like the code is using CFHTTP to run the pages.. i was looking to run some command line code using a *.bat file or some. something like cfexecute name=C:\Compile\*.bat outputFile = F:\Temp\output.txt /cfexecute Joe -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 1:47 AM To: CF-Talk Subject: Re: CFMX CFM/JSP/Servlets/Beans Compile? You can find this discussion in a thread responded to by Pete Ruckelshaus: 'CFMX Spidering for cache' on June 18th... I think it is cfml code that spiders some directories and compiles what it finds. It seems like this is something that should be built into the start procedures for CFMX... perhaps throttled down 50% to allow users to still hit the site. At 08:51 PM 7/22/02, you wrote: Yes there is, and it was posted to this list a while back. I can not find the message though. Try searching the archives. -- jon mailto:[EMAIL PROTECTED] Monday, July 22, 2002, 8:48:05 PM, you wrote: JE Sorry for the Re-Post.. but does anybody have any ideas? JE Hi All, JE I was wondering if there is a Command/Utility to compile JSP/CFM pages JE in CFMX.. like a comand line utility rather than having to RUN the JE the pages. How are Java Beans/Servlets compiled in CFMX? JE Do you have use TOMCAT/JRUN? or just put the Beans/Servlets(classes) in JE the WEB-INF\cfclasses directory? __ 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
Flushing Application scoped vars
Does anyone know of a good way to flush the vars stored in the application scope? I tried setting the applicationtimeout to CreateTimeSpan(0,0,0,0) and that didn't do anything. I'm not sure how cfflush works but I think that has to do with headers and not with ColdFusion cacheing. Anyway, if any of you has a good tip for this I'd appreciate it. Thanks, Jason !--- Jason Dowdell [EMAIL PROTECTED] 321.799.6845 IM AES - Web Developer --- __ 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: Flushing Application scoped vars
Have you tried CFAPPLICATION NAME=YourAppName SESSIONTIMEOUT=#CreateTimeSpan(0,0,0,0)# APPLICATIONTIMEOUT=#CreateTimeSpan(0,0,0,0)# This should work Joe - Original Message - From: Dowdell, Jason G [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 9:37 AM Subject: Flushing Application scoped vars Does anyone know of a good way to flush the vars stored in the application scope? I tried setting the applicationtimeout to CreateTimeSpan(0,0,0,0) and that didn't do anything. I'm not sure how cfflush works but I think that has to do with headers and not with ColdFusion cacheing. Anyway, if any of you has a good tip for this I'd appreciate it. Thanks, Jason !--- Jason Dowdell [EMAIL PROTECTED] 321.799.6845 IM AES - Web Developer --- __ 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: Mass Email Solution
It would be easy if you just did a little research. http://www.google.com http://www.lifewithqmail.com http://cr.yp.to/qmail.html On Tue, 23 Jul 2002, Larry Juncker wrote: Matt; Could you expand on this simplistic answer just a little more please. Could you provide a sample template of what needs to be done by CFFILE in order to write directly to the QMAIL QUEUE. This sounds very intriguing to me. I would be open to anything that makes my outgoing mail work better. Thanks in Advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 1:29 PM To: CF-Talk Subject: RE: Mass Email Solution Go get qmail for free and use cffile to write emails directly to its queue. That will get you an MTA that can easily do a million emails in a day. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 11:27 AM To: CF-Talk Subject: Re: Mass Email Solution The current version is Windows only but we have long-term plans for a Linux version. Regards, Howie - Original Message - From: Chris Edwards [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 2:07 PM Subject: Re: Mass Email Solution I'm looking for a Unix/Windows solution, mainly a Unix one. Will iMS-SE run on Unix? - Original Message - From: Howie Hamlin [EMAIL PROTECTED]; [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 1:14 PM Subject: Re: Mass Email Solution You may want to have a look at iMS-SE for this. iMS-SE is a high-performance mail sending engine for ColdFusion that does not require an external email server like other CFMAIL replacements do. iMS is the mail sending engine behind all of the House of Fusion lists, BTW. Here is a comparison of iMS-SE versus other CFMAIL replacements: http://www.coolfusion.com/imssecomparison.cfm You can download and install a fully-functional 60-day trial from our downloads page. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Chris Edwards [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 12:03 PM Subject: Mass Email Solution Hey, Any suggestions on the best way to manage and send email to a list of about 10,000 in an efficient manner? Would I need to use a high-performance mail build? Should I not use cfmail, but a compiled tag? Thanks. __ 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: CFMX JDBC Drivers
Just a sanity check: be sure your SQL Server is configured to accept TCP/IP socket connections (rather than Named Pipe connections) and is not set to Trusted Authentication Only. __ 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: MX inSite Magazine
The preview issue was pretty cool... I am still waiting for my first print issue to come. Clint -- Original Message -- from: Dave Hannum [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 23 Jul 2002 08:42:03 -0400 Is anybody here subscribed to MX inSite Magazine? If so, what do you think? I'd like some feedback before I invest . . . KWIM? Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] If your wife is having fun and you're not, you're still having a lot more fun than if you're having fun and she's not!' - Red Green __ 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: Flushing Application scoped vars
Hi Hi I think the application scope may be stored internally as a structure so perhaps trying a structclear would achieve this? Also not sure if the presence of cfid and cftoken on the clients machine may still cause the application to persist. Kola -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: 23 July 2002 14:37 To: CF-Talk Subject: Flushing Application scoped vars Does anyone know of a good way to flush the vars stored in the application scope? I tried setting the applicationtimeout to CreateTimeSpan(0,0,0,0) and that didn't do anything. I'm not sure how cfflush works but I think that has to do with headers and not with ColdFusion cacheing. Anyway, if any of you has a good tip for this I'd appreciate it. Thanks, Jason !--- Jason Dowdell [EMAIL PROTECTED] 321.799.6845 IM AES - Web Developer --- __ 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: Flushing Application scoped vars
Since variables in the application scope are stored as a session, I suppose you could do something like this: cfset temp = structkeylist(application) cfloop list=#temp# index=dex cfset temp2 = structdelete(application, dex) /cfloop This will remove all variables from the application scope. M -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 9:37 AM To: CF-Talk Subject: Flushing Application scoped vars Does anyone know of a good way to flush the vars stored in the application scope? I tried setting the applicationtimeout to CreateTimeSpan(0,0,0,0) and that didn't do anything. I'm not sure how cfflush works but I think that has to do with headers and not with ColdFusion cacheing. Anyway, if any of you has a good tip for this I'd appreciate it. Thanks, Jason !--- Jason Dowdell [EMAIL PROTECTED] 321.799.6845 IM AES - Web Developer --- __ 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: Flushing Application scoped vars
Does anyone know of a good way to flush the vars stored in the application scope? I tried setting the applicationtimeout to CreateTimeSpan(0,0,0,0) and that didn't do anything. I'm not sure how cfflush works but I think that has to do with headers and not with ColdFusion cacheing. Anyway, if any of you has a good tip for this I'd appreciate it. Since the APPLICATION scope is a structure, just use StructClear(APPLICATION), and that will do it. Regards, Dave. __ 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 CFM/JSP/Servlets/Beans Compile?
There are a lot of spaces in here, I am having trouble running this batch file, could you rewrite so I know which spaces should be there and which shouldn't. Thanks. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 9:14 AM To: CF-Talk Subject: RE: CFMX CFM/JSP/Servlets/Beans Compile? Try this: To precompile CF templates: Save the code below as MXCompile.bat in C:\ @setlocal set NEO_INSTALL=c: \cfusionMX set PATH=%NEO_INSTALL% \runtime\bin;%PATH% java -classpath %NEO_INSTALL%\lib\cfusion .jar coldfusion .tools.Compiler -webroot %NEO_INSTALL%\wwwroot %* @endlocal Run with this, pointing to a directory: C:\ MXcompile.bat c:\cfusionMX \wwwroot\CFIDE\administrator -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 2:23 AM To: CF-Talk Subject: RE: CFMX CFM/JSP/Servlets/Beans Compile? Thanks, but it looks like the code is using CFHTTP to run the pages.. i was looking to run some command line code using a *.bat file or some. something like cfexecute name=C:\Compile\*.bat outputFile = F:\Temp\output.txt /cfexecute Joe -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 1:47 AM To: CF-Talk Subject: Re: CFMX CFM/JSP/Servlets/Beans Compile? You can find this discussion in a thread responded to by Pete Ruckelshaus: 'CFMX Spidering for cache' on June 18th... I think it is cfml code that spiders some directories and compiles what it finds. It seems like this is something that should be built into the start procedures for CFMX... perhaps throttled down 50% to allow users to still hit the site. At 08:51 PM 7/22/02, you wrote: Yes there is, and it was posted to this list a while back. I can not find the message though. Try searching the archives. -- jon mailto:[EMAIL PROTECTED] Monday, July 22, 2002, 8:48:05 PM, you wrote: JE Sorry for the Re-Post.. but does anybody have any ideas? Hi All, JE I was wondering if there is a Command/Utility to compile JSP/CFM pages JE in CFMX.. like a comand line utility rather than having to JE RUN the JE the pages. How are Java Beans/Servlets compiled in CFMX? JE Do you have use TOMCAT/JRUN? or just put the Beans/Servlets(classes) in JE the WEB-INF\cfclasses directory? __ 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: Flushing Application scoped vars
Jason, You could loop through the scope (it's a structure) and delete the keys - they would be instantiated on the next request. Note: if you have to do this routinely then you are probably using the wrong scope. the Ap scope should be reserved for data that changes very rarely (like lookup queries or Datasource names). -mk Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com ..no more brochures! -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 8:37 AM To: CF-Talk Subject: Flushing Application scoped vars Does anyone know of a good way to flush the vars stored in the application scope? I tried setting the applicationtimeout to CreateTimeSpan(0,0,0,0) and that didn't do anything. I'm not sure how cfflush works but I think that has to do with headers and not with ColdFusion cacheing. Anyway, if any of you has a good tip for this I'd appreciate it. Thanks, Jason !--- Jason Dowdell [EMAIL PROTECTED] 321.799.6845 IM AES - Web Developer --- __ 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: MX inSite Magazine
It's difficult to make a judgement yet since they've only come out with one issue so far and they've yet to come out with a print issue. I believe the first issue is available for free on their website in pdf format. They sent an e-mail out last week saying that the first print issue will be available in early August. It looks promising, but it does seem like a lot of ground to cover in one magazine. -Bryan -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 8:42 AM To: CF-Talk Subject: MX inSite Magazine Is anybody here subscribed to MX inSite Magazine? If so, what do you think? I'd like some feedback before I invest . . . KWIM? Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] If your wife is having fun and you're not, you're still having a lot more fun than if you're having fun and she's not!' - Red Green __ 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
Best way to check if a datasource is valid
Hi Could anyone tell me the best way to verify a datasource without access to the registry? Thanks Kola __ 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: Custom tag length in CFMX?
Anyone at MM know about this? This is a bit of problem, ya know. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 4:03 PM To: CF-Talk Subject: Custom tag length in CFMX? I have a custom tag that's 108kb large. I'm getting an error in CFMX saying that it's over 65kb. Are there any issues with CFMX not handling custom tags larger than 65kb? __ 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: CFMX CFM/JSP/Servlets/Beans Compile?
This is Great.. Thanks Guys..I will try to implement this. MM should have had a tool to implement this is admin. Thanks Joe - Original Message - From: Stacy Young [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 9:14 AM Subject: RE: CFMX CFM/JSP/Servlets/Beans Compile? Try this: To precompile CF templates: Save the code below as MXCompile.bat in C:\ @setlocal set NEO_INSTALL=c: \cfusionMX set PATH=%NEO_INSTALL% \runtime\bin;%PATH% java -classpath %NEO_INSTALL%\lib\cfusion .jar coldfusion .tools.Compiler -webroot %NEO_INSTALL%\wwwroot %* @endlocal Run with this, pointing to a directory: C:\ MXcompile.bat c:\cfusionMX \wwwroot\CFIDE\administrator -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 2:23 AM To: CF-Talk Subject: RE: CFMX CFM/JSP/Servlets/Beans Compile? Thanks, but it looks like the code is using CFHTTP to run the pages.. i was looking to run some command line code using a *.bat file or some. something like cfexecute name=C:\Compile\*.bat outputFile = F:\Temp\output.txt /cfexecute Joe -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 1:47 AM To: CF-Talk Subject: Re: CFMX CFM/JSP/Servlets/Beans Compile? You can find this discussion in a thread responded to by Pete Ruckelshaus: 'CFMX Spidering for cache' on June 18th... I think it is cfml code that spiders some directories and compiles what it finds. It seems like this is something that should be built into the start procedures for CFMX... perhaps throttled down 50% to allow users to still hit the site. At 08:51 PM 7/22/02, you wrote: Yes there is, and it was posted to this list a while back. I can not find the message though. Try searching the archives. -- jon mailto:[EMAIL PROTECTED] Monday, July 22, 2002, 8:48:05 PM, you wrote: JE Sorry for the Re-Post.. but does anybody have any ideas? JE Hi All, JE I was wondering if there is a Command/Utility to compile JSP/CFM pages JE in CFMX.. like a comand line utility rather than having to RUN the JE the pages. How are Java Beans/Servlets compiled in CFMX? JE Do you have use TOMCAT/JRUN? or just put the Beans/Servlets(classes) in JE the WEB-INF\cfclasses directory? __ 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: Printing : Revisited
Dan, Are you use an IE only solution? I have done a similar app where the person could hit the server (via cf pages ;-) input some data (eg event, date etc.). When they submitted the form, the action page would automatically print registration forms (with dynamic info like user name, user stats etc) to their default printer (network or local). So it worked when they were attached to our network OR when they were on the road. If you want an IE tested only solution, let me know and I'll try to dig up the code. SK -Original Message- From: Dan O'Keefe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 8:16 AM To: CF-Talk Subject: RE: Printing : Revisited I had another thought on this matter, and was wondering if any one else has tried it. Lets say I had the server generate all of the letters to be printed and copied them to a file print driver, had the client download the file, and then manually send it to the printer? Dan -Original Message- From: Dan O'Keefe [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 5:30 PM To: CF-Talk Subject: RE: Printing You know what though, I need to print to a clients printer, so I assume I will be talking JavaScript and the window.print method. I will need to print a number of letters with the dynamic name and address, similar to a mail merge. Dan -Original Message- From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 3:01 PM To: CF-Talk Subject: RE: Printing copy file.txt lpt1 is it is local or if you have captured the printer in dos to lpt1 if it is networked. I do that exact thing using cffile then exexecute. It sends it through the server to a printer that everyone works on. Joshua Tipton -Original Message- From: Dan O'Keefe [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 2:58 PM To: CF-Talk Subject: Printing What is the easiest way to send a text document to a printer from CFML. I would imagine writing the file out with CFFILE and somehow initiating a DOS command such as: copy file.txt PRN Dan - Dan O'Keefe TriPoint Technologies 954.501.3115 __ 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: Flushing Application scoped vars
cfscript structclear(application); structclear(session); /cfscript -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 9:37 AM To: CF-Talk Subject: Flushing Application scoped vars Does anyone know of a good way to flush the vars stored in the application scope? I tried setting the applicationtimeout to CreateTimeSpan(0,0,0,0) and that didn't do anything. I'm not sure how cfflush works but I think that has to do with headers and not with ColdFusion cacheing. Anyway, if any of you has a good tip for this I'd appreciate it. Thanks, Jason !--- Jason Dowdell [EMAIL PROTECTED] 321.799.6845 IM AES - Web Developer --- __ 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 CFM/JSP/Servlets/Beans Compile?
Ok I got it to work, for anyone who is paying attention to this thread, here is the correct spacing, minus the line breaks. So what exactly does this do, where does the compiled version go? Is this good even through a reboot, where can I find more info on this? @setlocal set NEO_INSTALL=c:\cfusionMX set PATH=%NEO_INSTALL%\runtime\bin;%PATH% java -classpath %NEO_INSTALL%\lib\cfusion.jar coldfusion.tools.Compiler -webroot %NEO_INSTALL%\wwwroot %* @endlocal Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 9:14 AM To: CF-Talk Subject: RE: CFMX CFM/JSP/Servlets/Beans Compile? Try this: To precompile CF templates: Save the code below as MXCompile.bat in C:\ @setlocal set NEO_INSTALL=c: \cfusionMX set PATH=%NEO_INSTALL% \runtime\bin;%PATH% java -classpath %NEO_INSTALL%\lib\cfusion .jar coldfusion .tools.Compiler -webroot %NEO_INSTALL%\wwwroot %* @endlocal Run with this, pointing to a directory: C:\ MXcompile.bat c:\cfusionMX \wwwroot\CFIDE\administrator -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 2:23 AM To: CF-Talk Subject: RE: CFMX CFM/JSP/Servlets/Beans Compile? Thanks, but it looks like the code is using CFHTTP to run the pages.. i was looking to run some command line code using a *.bat file or some. something like cfexecute name=C:\Compile\*.bat outputFile = F:\Temp\output.txt /cfexecute Joe -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 1:47 AM To: CF-Talk Subject: Re: CFMX CFM/JSP/Servlets/Beans Compile? You can find this discussion in a thread responded to by Pete Ruckelshaus: 'CFMX Spidering for cache' on June 18th... I think it is cfml code that spiders some directories and compiles what it finds. It seems like this is something that should be built into the start procedures for CFMX... perhaps throttled down 50% to allow users to still hit the site. At 08:51 PM 7/22/02, you wrote: Yes there is, and it was posted to this list a while back. I can not find the message though. Try searching the archives. -- jon mailto:[EMAIL PROTECTED] Monday, July 22, 2002, 8:48:05 PM, you wrote: JE Sorry for the Re-Post.. but does anybody have any ideas? Hi All, JE I was wondering if there is a Command/Utility to compile JSP/CFM pages JE in CFMX.. like a comand line utility rather than having to JE RUN the JE the pages. How are Java Beans/Servlets compiled in CFMX? JE Do you have use TOMCAT/JRUN? or just put the Beans/Servlets(classes) in JE the WEB-INF\cfclasses directory? __ 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 JDBC Drivers
At 09:55 AM 7/23/2002 -0400, you wrote: Just a sanity check: be sure your SQL Server is configured to accept TCP/IP socket connections (rather than Named Pipe connections) and is not set to Trusted Authentication Only. Thanksit was configured properly all around. Installing SP2 did the trick! Thanks! __ 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: MX inSite Magazine
I agree 100%. It covers everything MX (Dreamweaver, Flash, Fireworks and so on). Looking forward to the next issue. -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 8:50 AM To: CF-Talk Subject: Re: MX inSite Magazine The preview issue was pretty cool... I am still waiting for my first print issue to come. Clint -- Original Message -- from: Dave Hannum [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 23 Jul 2002 08:42:03 -0400 Is anybody here subscribed to MX inSite Magazine? If so, what do you think? I'd like some feedback before I invest . . . KWIM? Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] If your wife is having fun and you're not, you're still having a lot more fun than if you're having fun and she's not!' - Red Green __ 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
MX question
This is a little off-topic... We are looking to integrate Fusion with Flash MX Server to do online collaboration/meetings. Does anyone out there know if Flash MX Server allows for or has modules to do desktop displaying? The demo on the Macromedia site talks up the online collaboration heavily, but doesn't mention many specifics other than a white board, chat, and video conferencing capabilities. Thanks in advance. Nick __ 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: Flushing Application scoped vars
This is actually a shopping cart structure that displays the items in each category, subcategory or brand. The structure only gets deleted if the owner of the store updates the database of products and then I set a flag. I knew about deleting and clearing the structure but it wasn't working. I think my problem was that I didn't get rid of the cookies on my machine but I'm checking that now. ~Jason -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 10:15 AM To: CF-Talk Subject: RE: Flushing Application scoped vars Jason, You could loop through the scope (it's a structure) and delete the keys - they would be instantiated on the next request. Note: if you have to do this routinely then you are probably using the wrong scope. the Ap scope should be reserved for data that changes very rarely (like lookup queries or Datasource names). -mk Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com .no more brochures! -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 8:37 AM To: CF-Talk Subject: Flushing Application scoped vars Does anyone know of a good way to flush the vars stored in the application scope? I tried setting the applicationtimeout to CreateTimeSpan(0,0,0,0) and that didn't do anything. I'm not sure how cfflush works but I think that has to do with headers and not with ColdFusion cacheing. Anyway, if any of you has a good tip for this I'd appreciate it. Thanks, Jason !--- Jason Dowdell [EMAIL PROTECTED] 321.799.6845 IM AES - Web Developer --- __ 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: Flushing Application scoped vars
Man I hate that, it was the data. There was data corruption in the database and that screwed it all up. thanks guys, Jason -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 10:05 AM To: CF-Talk Subject: Re: Flushing Application scoped vars Does anyone know of a good way to flush the vars stored in the application scope? I tried setting the applicationtimeout to CreateTimeSpan(0,0,0,0) and that didn't do anything. I'm not sure how cfflush works but I think that has to do with headers and not with ColdFusion cacheing. Anyway, if any of you has a good tip for this I'd appreciate it. Since the APPLICATION scope is a structure, just use StructClear(APPLICATION), and that will do it. Regards, Dave. __ 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: Custom tag length in CFMX?
Had a Pascal compiler about 20 years ago that did this. No single file could be over a certain size. Forced you to write modular code. Shawn McKee -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 9:27 AM To: CF-Talk Subject: RE: Custom tag length in CFMX? Anyone at MM know about this? This is a bit of problem, ya know. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 4:03 PM To: CF-Talk Subject: Custom tag length in CFMX? I have a custom tag that's 108kb large. I'm getting an error in CFMX saying that it's over 65kb. Are there any issues with CFMX not handling custom tags larger than 65kb? __ 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: Best way to check if a datasource is valid
In CF5 (and maybe CF 4.5?), one way is to use the undocumented CF_IsColdFusionDataSource function: CFSET DSN = MyDSN CFIF CF_IsColdFusionDataSource(DSN) Valid DSN CFELSE Invalid DSN /CFIF Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 10:23 AM To: CF-Talk Subject: Best way to check if a datasource is valid Hi Could anyone tell me the best way to verify a datasource without access to the registry? Thanks Kola __ 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: MX inSite Magazine
Problem is, they want your credit card to get the FREE issue. I don't want to do that. Dave - Original Message - From: Chambers, Bryan (NE) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 9:54 AM Subject: RE: MX inSite Magazine It's difficult to make a judgement yet since they've only come out with one issue so far and they've yet to come out with a print issue. I believe the first issue is available for free on their website in pdf format. They sent an e-mail out last week saying that the first print issue will be available in early August. It looks promising, but it does seem like a lot of ground to cover in one magazine. -Bryan -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 8:42 AM To: CF-Talk Subject: MX inSite Magazine Is anybody here subscribed to MX inSite Magazine? If so, what do you think? I'd like some feedback before I invest . . . KWIM? Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] If your wife is having fun and you're not, you're still having a lot more fun than if you're having fun and she's not!' - Red Green __ 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
ValueList Conversion -- CFMX Bug Perhaps?
I was using ValueList() on a bit column yesterday and I noticed some weird behavior. When the list returned, it was filled with true and false values, but when I output from the column directly (i.e. just one row at a time), it gives me 1's and 0's. Anybody else run into this? I just tried it on CF 5 and it gives me 1's and 0's all the time. Ben Johnson __ 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: Dubugging CFMX / Breakpoints Help
The breakpoints only work with the javascript debugger. Looks like they've taken away the CF interactive de-bugger. That's a real shame that saved me hours. They're are already plenty of js debuggers out there, but a server-side de-bugger was a real boon. -Original Message- From: Bogesdorfer, Dan [mailto:[EMAIL PROTECTED]] Sent: 23 July 2002 13:49 To: CF-Talk Subject: Dubugging CFMX / Breakpoints Help Trying to debug my app. I've set my breakpoints but it seems as if I cannot get the application to stop on them. The debugger is nice, much improved over the old CF stuff. Any good documentation or articles on the new CFMX debugger? Thanks. Daniel Bogesdorfer Senior Programmer / Analyst Office Of Research Health Sciences University of Pittsburgh 412.648.2366 __ 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: Best way to check if a datasource is valid
In coldFusion I would probably try to connect to a datasource via CFQUERY and use CFTRYCFCATCH if I suspected the datasource wouldn't be there and deal with appropriately. If you're looking for something more elegant, let me know. Gregory Harris [EMAIL PROTECTED] -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 7:23 AM To: CF-Talk Subject: Best way to check if a datasource is valid Hi Could anyone tell me the best way to verify a datasource without access to the registry? Thanks Kola __ 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
CF Journal
Has anyone recieved a July or August issue of Journal or are they just sticking it to me. I paid for a two year sub almost a year ago and I have to call them about every other month to get my mag because for some reason there system doesnt flag me to get one. __ 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: IIS Problem - HELP!
Chris, You were right! (You've got to love it when someone says that.) The client has their 'staging' server - which is actually a single site they test multiple sites on in subdirectories. Whereas their live environment, has the site sitting in it's own directory. Just as you described. Thus, making it impossible to use / root level referencing because your testing on one server that is configured differently than the live server. The client had original informed us their staging enviroment was configured the same as their live enviroment. And this being an internal server, we weren't able to confirm anything. I'm going to work with my Project Manager and the client on possible resolutions. Thanks for all of your help! Keep in touch. - Paul -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 4:46 PM To: CF-Talk Subject: RE: IIS Problem - HELP! I would very much appreciate it if you'd stop reading my mind. :) Seriously, that's exactly it. I'lll await your answer. Good luck. Chris Olive -Original Message- From: Paul Begovich [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 1:59 PM To: CF-Talk Subject: RE: IIS Problem - HELP! Hmm... I think I know where your going - What if their staging IS completely different than their live - and when they are testing, it's on a stripped down version of IIS that supports only one site, with subdirectories, and their testing on that subdirectory. / would be usesless in referencing. Good thought! I'll get back to you with the answer, hopefully that is the issue. Thanks! Paul -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 1:15 PM To: CF-Talk Subject: RE: IIS Problem - HELP! right. are the client's directory structures the same on both machines? i'm looking for something like this... dev box: http://clienturl points to / / - has all root files /images - has all appropriate images staging - http://clienturl points to / /clientname - has all root files /clientname/images - has image files. c -Original Message- From: Paul Begovich [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 12:50 PM To: CF-Talk Subject: RE: IIS Problem - HELP! Yes, the source of the image tag is correct. Everything works fine on our development enviroment for referencing from the root (ie /images/something.gif), however on their staging server it does not. It only works if it is referenced either ../images/something.gif or images/something.gif. It's not a matter of the code, it's a matter of the server settings to get it to accept the / reference for root. - Paul -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 12:31 PM To: CF-Talk Subject: RE: IIS Problem - HELP! take a look at the page. do a view source. look at the SRC of the IMG tag. is it actually correct? __ 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) Slashdot bias
The problem with being biased is that that close-minded way of thinking spills over into other aspects of your life, so they are limiting themselves in many other ways other than ignoring specific programming languages, I'm sure. My way of thinking is the more the better; always something new to learn and different ways in which you have to think. -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 21, 2002 5:34 PM To: CF-Talk Subject: Re: (OT) Slashdot bias Then they are not only biased but also falsely advertising. It should be News for open source nerds and stuff that matters only to a biased segment of the computer world .. slashdot, biased? Uhhh... no offense Michael, but duh! __ 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
Retrieving last inserted Primary Key
I know this topic has been flogged to death, but here it goes again. What is the preferred Method of retrieving the last inserted Primary key? NOT using a stored proc and the Identity method, so what about using CF in line queries. Any suggestions? -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com -- I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world, because they'd never expect it. -- Jack Handy __ 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
apache and cf
I am attempting to set up my workstation with apache 2.0.39, cf 4.5 on a win 2k pro box. I had no problems before when I was using personal web srever on win98. I appear to be serving .htm pages fine via 127.0.0.1 and localhost, so I think I have Apache running fine. I can;t seem to get the cf admin to run though. It keeps downloading and opening up in cf studio. I am thinking apache is not recongnizing the .cfm extension. Could that be it? And if so how do I add .cfm in apache so that it can be recongnized. Cf doesn't appear to be loading at start-up either. ie it is not in the tray. Thanks alot. Jeremy __ 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: Dubugging CFMX / Breakpoints Help
Hi, Dan, I have CF 5.0 which I purchased to just use the debugger. Imagine my disappointment when I found that it failed just like CF 4.5 exactly as you describe. Studying the documentation revealed that while CF 5.0 can RUN on Win 98, if you want to use the debugger, you REALLY need Win XP Pro. That cost more $$$ for a new notebook. One other gotcha: The debugger won't run in a child window opened using a windows.open command. It only runs in the initial parent window configured with an RDS server. Good Luck, Fred Lepow - Original Message - From: Bogesdorfer, Dan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 5:49 AM Subject: Dubugging CFMX / Breakpoints Help Trying to debug my app. I've set my breakpoints but it seems as if I cannot get the application to stop on them. The debugger is nice, much improved over the old CF stuff. Any good documentation or articles on the new CFMX debugger? Thanks. Daniel Bogesdorfer Senior Programmer / Analyst Office Of Research Health Sciences University of Pittsburgh 412.648.2366 __ 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: MX inSite Magazine
At 11:38 AM 7/23/2002 -0400, you wrote: You'd figure the site would run of CFMX...nope! Problem is, they want your credit card to get the FREE issue. I don't want to do that. Dave - Original Message - From: Chambers, Bryan (NE) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 9:54 AM Subject: RE: MX inSite Magazine It's difficult to make a judgement yet since they've only come out with one issue so far and they've yet to come out with a print issue. I believe the first issue is available for free on their website in pdf format. They sent an e-mail out last week saying that the first print issue will be available in early August. It looks promising, but it does seem like a lot of ground to cover in one magazine. -Bryan -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 8:42 AM To: CF-Talk Subject: MX inSite Magazine Is anybody here subscribed to MX inSite Magazine? If so, what do you think? I'd like some feedback before I invest . . . KWIM? Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] If your wife is having fun and you're not, you're still having a lot more fun than if you're having fun and she's not!' - Red Green __ 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: Retrieving last inserted Primary Key
cftransaction do insert select max(id) from table /cftranascation -Original Message- From: chris.alvarado [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 12:05 PM To: CF-Talk Subject: Retrieving last inserted Primary Key I know this topic has been flogged to death, but here it goes again. What is the preferred Method of retrieving the last inserted Primary key? NOT using a stored proc and the @@Identity method, so what about using CF in line queries. Any suggestions? -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com -- I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world, because they'd never expect it. -- Jack Handy __ 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: MX inSite Magazine
No need to give them a CC for the free sample. I am downloading it now. Shawn McKee -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 10:38 AM To: CF-Talk Subject: Re: MX inSite Magazine Problem is, they want your credit card to get the FREE issue. I don't want to do that. Dave - Original Message - From: Chambers, Bryan (NE) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 9:54 AM Subject: RE: MX inSite Magazine It's difficult to make a judgement yet since they've only come out with one issue so far and they've yet to come out with a print issue. I believe the first issue is available for free on their website in pdf format. They sent an e-mail out last week saying that the first print issue will be available in early August. It looks promising, but it does seem like a lot of ground to cover in one magazine. -Bryan -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 8:42 AM To: CF-Talk Subject: MX inSite Magazine Is anybody here subscribed to MX inSite Magazine? If so, what do you think? I'd like some feedback before I invest . . . KWIM? Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] If your wife is having fun and you're not, you're still having a lot more fun than if you're having fun and she's not!' - Red Green __ 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: Retrieving last inserted Primary Key
NOT using a stored proc and the Identity method, so what about using CF in line queries. If you're using SQL Server 2000, you should use the SCOPE_IDENTITY() function because it can't be affected by triggers. However, if you don't want to used stored procedures or the SCOPE_IDENTITY() function, then you could probably do a transaction with a table level lock. and pull the Max(identityColName). Now, whether or not that's the _best_ way... Ben Johnson __ 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: IIS Problem - HELP!
Hey, no problem. After having been wrong so many times in my life, it's nice to hear a dissenting viewpoint. :) (now if i could just get the people to whom i'm emailing my resumes to admit the same...preferably followed by a for the job!)... :) i'm in touch. i've been reading this list for 2+ years. although, feel free to drop me a private line if you need something... Chris Olive -Original Message- From: Paul Begovich [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 12:02 PM To: CF-Talk Subject: RE: IIS Problem - HELP! Chris, You were right! (You've got to love it when someone says that.) The client has their 'staging' server - which is actually a single site they test multiple sites on in subdirectories. Whereas their live environment, has the site sitting in it's own directory. Just as you described. Thus, making it impossible to use / root level referencing because your testing on one server that is configured differently than the live server. The client had original informed us their staging enviroment was configured the same as their live enviroment. And this being an internal server, we weren't able to confirm anything. I'm going to work with my Project Manager and the client on possible resolutions. Thanks for all of your help! Keep in touch. - Paul -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 4:46 PM To: CF-Talk Subject: RE: IIS Problem - HELP! I would very much appreciate it if you'd stop reading my mind. :) Seriously, that's exactly it. I'lll await your answer. Good luck. Chris Olive -Original Message- From: Paul Begovich [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 1:59 PM To: CF-Talk Subject: RE: IIS Problem - HELP! Hmm... I think I know where your going - What if their staging IS completely different than their live - and when they are testing, it's on a stripped down version of IIS that supports only one site, with subdirectories, and their testing on that subdirectory. / would be usesless in referencing. Good thought! I'll get back to you with the answer, hopefully that is the issue. Thanks! Paul -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 1:15 PM To: CF-Talk Subject: RE: IIS Problem - HELP! right. are the client's directory structures the same on both machines? i'm looking for something like this... dev box: http://clienturl points to / / - has all root files /images - has all appropriate images staging - http://clienturl points to / /clientname - has all root files /clientname/images - has image files. c -Original Message- From: Paul Begovich [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 12:50 PM To: CF-Talk Subject: RE: IIS Problem - HELP! Yes, the source of the image tag is correct. Everything works fine on our development enviroment for referencing from the root (ie /images/something.gif), however on their staging server it does not. It only works if it is referenced either ../images/something.gif or images/something.gif. It's not a matter of the code, it's a matter of the server settings to get it to accept the / reference for root. - Paul -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 12:31 PM To: CF-Talk Subject: RE: IIS Problem - HELP! take a look at the page. do a view source. look at the SRC of the IMG tag. is it actually correct? __ 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: Retrieving last inserted Primary Key
declare @max_id int begin select @max_id = max(id) from table if @max_id = NULL select @max_id = 1 else select @max_id = @max_id + 1 end Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: chris.alvarado [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 9:05 AM Subject: Retrieving last inserted Primary Key I know this topic has been flogged to death, but here it goes again. What is the preferred Method of retrieving the last inserted Primary key? NOT using a stored proc and the @@Identity method, so what about using CF in line queries. Any suggestions? -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com -- I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world, because they'd never expect it. -- Jack Handy __ 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
Web Hosting FTP Interface
We need to create an interface for our web hosting customers to login and upload files to their personal web space. Clients will need to browse their local system to select multiple files and ftp them to the server. Can anyone recommend any programs? Thanks, Dave 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
javascript addition
Hello,
Can anybody show me how you would I would validate the sum of several text
boxes? This is what I'm trying to use but not having luck.. thanks in
advance.
function validate()
{
if (document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value !=
document.newBillingInfo.SCEPtotalAmount.value)
{
alert(The total Billing amount does not add up correctly, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
return true;
}
__
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: apache and cf
Jeremy, Bad news, I don't think your ever going to be able to get 4.5 CF working on Apache 2.0.39 unless you have access to the source stub files. CF5 folks have a .dll out there floating around for Apache builds over 2, but .. even then, it's uncertain that Macromedia is ever going to release this (and, I doubt they will, they're on MX already). ~Todd On Tue, 23 Jul 2002, Jeremy wrote: I am attempting to set up my workstation with apache 2.0.39, cf 4.5 on a win 2k pro box. I had no problems before when I was using personal web srever on win98. I appear to be serving .htm pages fine via 127.0.0.1 and localhost, so I think I have Apache running fine. I can;t seem to get the cf admin to run though. It keeps downloading and opening up in cf studio. I am thinking apache is not recongnizing the .cfm extension. Could that be it? And if so how do I add .cfm in apache so that it can be recongnized. Cf doesn't appear to be loading at start-up either. ie it is not in the tray. Thanks alot. Jeremy -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ 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: apache and cf
I believe that the cf module for Apache 2.0 is not compatible with CF server 4.5, and for that matter, with 5.0. There is however some gents that have written their own cf module for Apache 2.0 that is compatible with CF server 5.0. This module can be found at: http://home.nextron.ch/coldfusion/. I am not sure if they(MM) will retro-fit a mod for Apache 2.0 for the various non MX versions of CF(4.5,5.0). This was brought up in the CF-Server list last week. Hope any of this helps, John Ensign www.thebinarylab.com -Original Message- From: Jeremy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 10:04 AM To: CF-Talk Subject: apache and cf I am attempting to set up my workstation with apache 2.0.39, cf 4.5 on a win 2k pro box. I had no problems before when I was using personal web srever on win98. I appear to be serving .htm pages fine via 127.0.0.1 and localhost, so I think I have Apache running fine. I can;t seem to get the cf admin to run though. It keeps downloading and opening up in cf studio. I am thinking apache is not recongnizing the .cfm extension. Could that be it? And if so how do I add .cfm in apache so that it can be recongnized. Cf doesn't appear to be loading at start-up either. ie it is not in the tray. Thanks alot. Jeremy __ 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: javascript addition
Use the function eval() with each textbox value:
Eval(document.newBillingInfo.SCEPbilledAmount.value)
- Matt Small
-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 12:36 PM
To: CF-Talk
Subject: javascript addition
Hello,
Can anybody show me how you would I would validate the sum of several
text boxes? This is what I'm trying to use but not having luck.. thanks
in advance.
function validate()
{
if (document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value !=
document.newBillingInfo.SCEPtotalAmount.value)
{
alert(The total Billing amount does not add up correctly,
Please check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
return true;
}
__
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: apache and cf
I am attempting to set up my workstation with apache 2.0.39, cf 4.5 on a win 2k pro box. I had no problems before when I was using personal web srever on win98. I appear to be serving .htm pages fine via 127.0.0.1 and localhost, so I think I have Apache running fine. I can;t seem to get the cf admin to run though. It keeps downloading and opening up in cf studio. I am thinking apache is not recongnizing the .cfm extension. Could that be it? And if so how do I add .cfm in apache so that it can be recongnized. CF 4.5 doesn't run with Apache 2.0.x. There's no Apache 2-compatible module with CF 4.5. For that matter, if you want to run CF 5 with Apache 2, you have to use a free, third-party module: http://home.nextron.ch/coldfusion/ As an alternative, you can get Apache 1.3.x and use that. In any case, when you do have a version of Apache and a version of CF that will work with each other, you'll have to configure Apache's httpd.conf file manually in most cases. The above link describes how that's done; there's also a document on the Macromedia support site which describes this. Cf doesn't appear to be loading at start-up either. ie it is not in the tray. Is it in the Startup folder? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: CF Server Error Msg - unknown exception condition - TagCFX::e xecu te
Dave, did you try the CFLOCKS I suggested or where they already there anyway? I have had experience with many clients where unlocked CFX tags caused literal havoc. Kind Regards - Mike Brunt, CTO Webapper http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Webapper - Making the NET work -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 5:06 AM To: CF-Talk Subject: RE: CF Server Error Msg - unknown exception condition - TagCFX::e xecu te The tag is a java tag not c++. I'm not sure if it makes a difference. Maybe I don't have the java settings correct in the cf admin page, I'm working off a newly configured server. Thanks, Dave -Original Message- From: Van Vliet, Scott [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 6:14 PM To: CF-Talk Subject: RE: CF Server Error Msg - unknown exception condition - TagCFX::e xecu te The problem is a result of an exception in the execute method of the TagCFX C++ class. I have run accross this before, and it turned out to be system incompatibility (the CFX was built and compiled on NT 4, but we were trying to use it on W2K). You might contact the author of CFX_AUTHSMTP and see if they have any incompatibility issues. Also, Mike Brunt made a good point about locking those CFX calls - especially when using C++ CFX tags. One bad pointer or copy constructor and your overwritting everything! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 2:03 PM To: CF-Talk Subject: CF Server Error Msg - unknown exception condition - TagCFX::execu te Anybody know what causes this error and how I can resolve the issue??? Error Diagnostic Information unknown exception condition TagCFX::execute The error occurred while processing an element with a general identifier of (CFX_AUTHSMTP) Thanks, Dave 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. __ 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: Retrieving last inserted Primary Key
cftransaction do insert select max(id) from table /cftranascation Couldn't this set a page level lock (or possibly a row level lock in SQL Server 2K)? That would still allow another user to add a row in between. You'd probably have to do something like: !--- serializable should hold the lock throughout the transaction (i think.. otherwise, specifiy HOLDLOCK with TABLOCK)--- cftransaction isolation=serializable !--- Can anyone confirm this locking hint syntax? BOL didn't give a good example --- cfquery INSERT INTO myTable WITH TABLOCK (..., ...) VALUES (..., ...) /cfquery cfquery get max /cfquery /cftransaction Ben Johnson __ 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: Mass Email Solution
Obviously you know not what you speak of.. I have spent two hours on your links and have found absolutely NOTHING dealing with Cold Fusion and Qmail. If you can not help someone with pertinent information then why respond at all? Thanks for obviously nothing... -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 8:56 AM To: CF-Talk Subject: RE: Mass Email Solution It would be easy if you just did a little research. http://www.google.com http://www.lifewithqmail.com http://cr.yp.to/qmail.html On Tue, 23 Jul 2002, Larry Juncker wrote: Matt; Could you expand on this simplistic answer just a little more please. Could you provide a sample template of what needs to be done by CFFILE in order to write directly to the QMAIL QUEUE. This sounds very intriguing to me. I would be open to anything that makes my outgoing mail work better. Thanks in Advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 1:29 PM To: CF-Talk Subject: RE: Mass Email Solution Go get qmail for free and use cffile to write emails directly to its queue. That will get you an MTA that can easily do a million emails in a day. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 11:27 AM To: CF-Talk Subject: Re: Mass Email Solution The current version is Windows only but we have long-term plans for a Linux version. Regards, Howie - Original Message - From: Chris Edwards [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 2:07 PM Subject: Re: Mass Email Solution I'm looking for a Unix/Windows solution, mainly a Unix one. Will iMS-SE run on Unix? - Original Message - From: Howie Hamlin [EMAIL PROTECTED]; [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 1:14 PM Subject: Re: Mass Email Solution You may want to have a look at iMS-SE for this. iMS-SE is a high-performance mail sending engine for ColdFusion that does not require an external email server like other CFMAIL replacements do. iMS is the mail sending engine behind all of the House of Fusion lists, BTW. Here is a comparison of iMS-SE versus other CFMAIL replacements: http://www.coolfusion.com/imssecomparison.cfm You can download and install a fully-functional 60-day trial from our downloads page. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Chris Edwards [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 12:03 PM Subject: Mass Email Solution Hey, Any suggestions on the best way to manage and send email to a list of about 10,000 in an efficient manner? Would I need to use a high-performance mail build? Should I not use cfmail, but a compiled tag? Thanks. __ 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
CFMX - Function Best Practice ?
Hello, I'm a little confused with all the new CFFUNCTION ability in CFMX - I know it's more extensible than UDFs as it can be used for WebServices, etc., but what is the best practice for creating functions? Are UDF functions going by the wayside after such a short lifespan or do they serve two seperate purposes now? Is it best to use CFC or UDF when not needing remote consumption or access? Is there a processing difference between the two? Thanks, Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com http://www.eaglewd.com/ [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) __ 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: javascript addition
IMHO...
In terms of interface design, its easier to auto-calc amounts, then you kind
of take out the human element...
And if youre involving 10 fields for some kind of calculation, and the value
they enter is wrong, how do you point to the incorrect amount in the
appropriate field? (assuming youve already set limits, and checked to make
sure the values, if numeric, are within that range).
Its simpler to auto calc it for them. Although, you should also recheck the
math on the server by re-calculating the field amounts again, just to be
sure. )
hope any of this helps,
John Ensign
-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 10:36 AM
To: CF-Talk
Subject: javascript addition
Hello,
Can anybody show me how you would I would validate the sum of several text
boxes? This is what I'm trying to use but not having luck.. thanks in
advance.
function validate()
{
if (document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value !=
document.newBillingInfo.SCEPtotalAmount.value)
{
alert(The total Billing amount does not add up correctly, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
return true;
}
__
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: Retrieving last inserted Primary Key
select max On Tue, 23 Jul 2002, chris.alvarado wrote: I know this topic has been flogged to death, but here it goes again. What is the preferred Method of retrieving the last inserted Primary key? NOT using a stored proc and the Identity method, so what about using CF in line queries. Any suggestions? -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com -- I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world, because they'd never expect it. -- Jack Handy __ 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: Flushing Application scoped vars
Does anyone know of a good way to flush the vars stored in the application scope? I tried setting the applicationtimeout to CreateTimeSpan(0,0,0,0) and that didn't do anything. I'm not sure how cfflush works but I think that has to do with headers and not with ColdFusion cacheing. Anyway, if any of you has a good tip for this I'd appreciate it. cfflush is only indirectly related to headers -- it tells the cfserver to send whatever portion of the page has completed to the browser before continuing processing the page, so the browser gets the page incrementally... The relationship to headers is that you cant use anything on the page after a cfflush tag that would alter the headers like cfheader, cflocation and I think cfcookie and possibly cfform. As to your question, try this: cflock scope=application type=exclusive timeout=10 cfscript temp = application.applicationname; StructClear(application); application.applicationname = temp; /cfscript /cflock That should give you a clean-slate, just as tho the cfapplication tag had just been processed for the first time. Isaac Dealey www.turnkey.to 954-776-0046 __ 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
cfflush fusebox
Has anyone else noticed that the cfflush tag is completely useless if you use the fusebox layout method? ... I'm working on an application that was built by some other folks in fb2 ( though the same would apply if it were fb3 ) and they asked me to add an ALL button to a page which uses pagination... but because the potential exists that the contents of the page could be inordinately large ... ( thousands of results in the list query, with a gratuitous amount of cf code for each result ) , it may not be feasible to display the page without flushing the output buffer ... but cfflush can't be used inside of a cfsavecontent or cf_bodycontent tag, which is where the fusebox layout would necessitate it being, and even if it could, it would either display the content above the top of the layout (where it shouldn't be) or would display nothing at all until the page finished loading anyway, which was the problem necessitating the cfflush solution ... so my options are to leave it alone and risk things blowing up because impatient users continually hit the refresh button before the page finishes loading, or tediously extricate the content from the fusebox architecture and then have to maintain it separately... sigh ... this is very frustrating... Hey Hal, any thoughts on a revision to the fb3 suggested specification for layouts? Isaac Dealey New Epoch www.turnkey.to 954-776-0046 __ 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: Flushing Application scoped vars
the Ap scope should be reserved for data that changes very rarely (like ...snip... Datasource names). ICK! ... I had to clean up someone else's mess recently with this -- they used application variables for all their db accessing variables ( dsn, username and password ) and with zero locking on a heavily trafficked CF5 server... which of course, caused problems... I replaced them all with request variables, which solved the problem. Isaac Dealey www.turnkey.to 954-776-0046 __ 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: CF Journal
I have the same problem, though I have been getting Java Developers Journal (which I didn't sign up for). It's an expensive magazine, I would expect better, and I will not be renewing my subscription. Pete - Original Message - From: Tipton Josh (orl1jdt) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 11:51 AM Subject: CF Journal Has anyone recieved a July or August issue of Journal or are they just sticking it to me. I paid for a two year sub almost a year ago and I have to call them about every other month to get my mag because for some reason there system doesnt flag me to get one. __ 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: Retrieving last inserted Primary Key
Make sure that you use cftransaction and assuming that your IDs are sequential integers, make sure you sort descending. If you could prevent two trips to the database, I would strongly recommend it. At 01:03 PM 7/23/2002 -0400, you wrote: select max On Tue, 23 Jul 2002, chris.alvarado wrote: I know this topic has been flogged to death, but here it goes again. What is the preferred Method of retrieving the last inserted Primary key? NOT using a stored proc and the Identity method, so what about using CF in line queries. Any suggestions? -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com -- I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world, because they'd never expect it. -- Jack Handy __ 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: Mass Email Solution
qmail-inject... For example, to send a blank message to [EMAIL PROTECTED]: echo To: [EMAIL PROTECTED] | /var/qmail/bin/qmail-inject If you want to outsource this there are many people looking for work. On Tue, 23 Jul 2002, Larry Juncker wrote: Obviously you know not what you speak of.. I have spent two hours on your links and have found absolutely NOTHING dealing with Cold Fusion and Qmail. If you can not help someone with pertinent information then why respond at all? Thanks for obviously nothing... -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 8:56 AM To: CF-Talk Subject: RE: Mass Email Solution It would be easy if you just did a little research. http://www.google.com http://www.lifewithqmail.com http://cr.yp.to/qmail.html On Tue, 23 Jul 2002, Larry Juncker wrote: Matt; Could you expand on this simplistic answer just a little more please. Could you provide a sample template of what needs to be done by CFFILE in order to write directly to the QMAIL QUEUE. This sounds very intriguing to me. I would be open to anything that makes my outgoing mail work better. Thanks in Advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 1:29 PM To: CF-Talk Subject: RE: Mass Email Solution Go get qmail for free and use cffile to write emails directly to its queue. That will get you an MTA that can easily do a million emails in a day. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 11:27 AM To: CF-Talk Subject: Re: Mass Email Solution The current version is Windows only but we have long-term plans for a Linux version. Regards, Howie - Original Message - From: Chris Edwards [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 2:07 PM Subject: Re: Mass Email Solution I'm looking for a Unix/Windows solution, mainly a Unix one. Will iMS-SE run on Unix? - Original Message - From: Howie Hamlin [EMAIL PROTECTED]; [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 1:14 PM Subject: Re: Mass Email Solution You may want to have a look at iMS-SE for this. iMS-SE is a high-performance mail sending engine for ColdFusion that does not require an external email server like other CFMAIL replacements do. iMS is the mail sending engine behind all of the House of Fusion lists, BTW. Here is a comparison of iMS-SE versus other CFMAIL replacements: http://www.coolfusion.com/imssecomparison.cfm You can download and install a fully-functional 60-day trial from our downloads page. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Chris Edwards [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 12:03 PM Subject: Mass Email Solution Hey, Any suggestions on the best way to manage and send email to a list of about 10,000 in an efficient manner? Would I need to use a high-performance mail build? Should I not use cfmail, but a compiled tag? Thanks. __ 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: Flushing Application scoped vars
Does anyone know of a good way to flush the vars stored in the application scope? I tried setting the applicationtimeout to CreateTimeSpan(0,0,0,0) and that didn't do anything. I'm not sure how cfflush works but I think that has to do with headers and not with ColdFusion cacheing. Anyway, if any of you has a good tip for this I'd appreciate it. Since the APPLICATION scope is a structure, just use StructClear(APPLICATION), and that will do it. I did this once ... You have to make sure you copy the applicationname into a temp variable and then copy it back into thea applicationscope afterward on the same page... I'm not real certain why, but you get an error on the next page otherwise ... or at least that was the result I got... Isaac Dealey 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: CFMX - Function Best Practice ?
i think something like makeQueryFromList() makes a good function.. cfc's are more for structuring the meat of your application in an OO-ish way. seems like that way basically you'll end up with a cfc for each major db table.. one for users, one for projects, etc. You can use cffunction independant of cfcomponent, though, to make functions that use cf tags.. so you aren't limited by the cfscript syntax. Like the other cfscript functionality, you've got a tag way to do it too. dunno 'bout performance. ken -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 12:52 PM To: CF-Talk Subject: CFMX - Function Best Practice ? Hello, I'm a little confused with all the new CFFUNCTION ability in CFMX - I know it's more extensible than UDFs as it can be used for WebServices, etc., but what is the best practice for creating functions? Are UDF functions going by the wayside after such a short lifespan or do they serve two seperate purposes now? Is it best to use CFC or UDF when not needing remote consumption or access? Is there a processing difference between the two? Thanks, Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com http://www.eaglewd.com/ [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) __ 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: OT javascript addition
Tim,
try adding () around the addition part like so:
if ((document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value) !=
document.newBillingInfo.SCEPtotalAmount.value)
This should force the addition to take place before the comparison.
PS are you checking for numeric input only
This could be done like so:
if ((isNaN(document.newBillingInfo.SCEPbilledAmount.value)) ||
(isNaN(document.newBillingInfo.SCEPpenaltyAmount.value)) ||
(isNaN(document.newBillingInfo.SCEPdelinquentAmount.value)) ||
(isNaN(document.newBillingInfo.SCEPtotalAmount.value))
{
alert(The amounts must be numeric, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
else
{
if ((document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value) !=
document.newBillingInfo.SCEPtotalAmount.value)
{
alert(The total Billing amount does not add up correctly, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
return true;
}
}
or something like that ;-)
this is untested code but hopefully will give you something to work with.
HTH
Stephen
-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 12:36 PM
To: CF-Talk
Subject: javascript addition
Hello,
Can anybody show me how you would I would validate the sum of several text
boxes? This is what I'm trying to use but not having luck.. thanks in
advance.
function validate()
{
if (document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value !=
document.newBillingInfo.SCEPtotalAmount.value)
{
alert(The total Billing amount does not add up correctly, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
return true;
}
__
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 - Function Best Practice ?
UDFs are not going by the wayside, it's still a good thing to use. I just use it for display formatting and things like that. CFModules to me have gone to the wayside as I'm using CFCs more. I haven't figured out what I'm going to be using cfmodule for anymore. ;) ~Todd On Tue, 23 Jul 2002, Joshua Miller wrote: Hello, I'm a little confused with all the new CFFUNCTION ability in CFMX - I know it's more extensible than UDFs as it can be used for WebServices, etc., but what is the best practice for creating functions? Are UDF functions going by the wayside after such a short lifespan or do they serve two seperate purposes now? Is it best to use CFC or UDF when not needing remote consumption or access? Is there a processing difference between the two? Thanks, Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com http://www.eaglewd.com/ [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) __ 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: Flushing Application scoped vars
Isaac, What is wrong with using application scope to hold the user name and password? - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 11:41 AM Subject: RE: Flushing Application scoped vars the Ap scope should be reserved for data that changes very rarely (like ...snip... Datasource names). ICK! ... I had to clean up someone else's mess recently with this -- they used application variables for all their db accessing variables ( dsn, username and password ) and with zero locking on a heavily trafficked CF5 server... which of course, caused problems... I replaced them all with request variables, which solved the problem. Isaac Dealey www.turnkey.to 954-776-0046 __ 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: javascript addition
In terms of interface design, its easier to auto-calc amounts, then you kind of take out the human element... And if youre involving 10 fields for some kind of calculation, and the value they enter is wrong, how do you point to the incorrect amount in the appropriate field? (assuming youve already set limits, and checked to make sure the values, if numeric, are within that range). Its simpler to auto calc it for them. Although, you should also recheck the math on the server by re-calculating the field amounts again, just to be sure. ) hope any of this helps, Hey John, most of the time I agree with you... that is, when you're just summing up values that a user has given you and getting whatever total they produce, i.e. for a mortgage app where the user enters their financial info and all you want to know is their total annual income for their application. The exception is when the user is entering values which must add up to a given total which is required by some other external mechanism, i.e. in a grade-weighting schedule for an electronic report-card where grades for different types of assignments may be weighted differently, but the sum of all wieghts must add up to 100 ( making each point in the weighting schedule exactly 1% ). In order to calculate the percentage, you have to know the total points, so if you want to double-check the teachers to make sure their math adds up, you can enforce a 100pt total and you know that if their numbers don't add up to exactly 100 they need to check their math and make an adjustment. I _think_ he may be doing something similar to this, although I'm not certain of that... Isaac Dealey www.turnkey.to 954-776-0046 __ 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: CFMX - Function Best Practice ?
You can still create a UDF using CFFUNCTION. You're always going to find a use for UDFs, cause even in C++ not *everything* makes sense to have as an object. One key feature to the CFFUNCTION is it allows you to create some UDFs you could never create before. For example, you can now create a UDF that uses the CFWDDX tag (for that matter any other tag that didn't have a CFSCRIPT compatible syntax.) As for which is better, a CFC or a UDF--it depends. CFCs give you many advantages over just creating a UDF, but that may not always mean a CFC is the most appropriate architectural choice. There are times when using an oo-based approach to solve a task may be extreme overkill, and writing a straight UDF makes much more sense. For example, if I just need a function to calculate a value based upon a list, a UDF seems to make more sense than trying to create an object for the one functionality. However, if that list of values relates to some object and there's lots of manipulation required to that same set of data, then creating a re-usable component makes a lot of sense (since you can then use oo-based principles, by creating an instance of that data, which you can manipulate.) In a nutshell, I don't think UDFs are going anywhere and CFCs don't necessarily replace them. -Dan -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 12:52 PM To: CF-Talk Subject: CFMX - Function Best Practice ? Hello, I'm a little confused with all the new CFFUNCTION ability in CFMX - I know it's more extensible than UDFs as it can be used for WebServices, etc., but what is the best practice for creating functions? Are UDF functions going by the wayside after such a short lifespan or do they serve two seperate purposes now? Is it best to use CFC or UDF when not needing remote consumption or access? Is there a processing difference between the two? Thanks, Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com http://www.eaglewd.com/ [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) __ 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
CFLOGIN Issue
Excuse me if dupe:
I am trying out the functionality of the CFLOGIN tsg snf it doesn't seem to work as
advertised.
According to the docs Code in thr cflogin tag only executes if there is no user is
logged in.
The system authenticates and displays the protected page but when accessing another
page in the same dir the same code re-executes and doesn't see the form login vars and
boots me to the login page.
Am I missing something? Here is part of the code in Application.cfm:
Thank you all.
cfset AllowedRoles = Domain Users
cflogin
cfif isdefined(form.password) and isdefined(form.username)
!--- WE NEED TO PROVIDE THIS SOMEHOW. SIMILAR TO NT LOGIN WOULD DO. ---
CFSET Request.myDomain = STS1
!--- TRY TO AUTHENTICATE USER ---
cfinvoke
component = NTSecurity
method = authenticateUser
domain = #Request.myDomain#
userid = #form.username#
passwd = #form.password#
returnVariable = Auth
cfif #Auth# IS True
!--- SUCCESS ---
cfset failed = no
!---NOW LET'S CHECK WHAT GROUPS(roles) I HAVE ---
cfinvoke
component = NTSecurity
method = getUserGroups
domain = #Request.myDomain#
userid = #form.username#
passwd = #form.password#
returnVariable = MyGroups
cfoutput
CFSET TheRoles =#Replace('#MyGroups#',', ',',','All')#
/cfoutput
cfloginuser name=#form.username#
password=#form.password#
roles=#TheRoles#
CFELSE
!Did not pass authentication so redirect with message---
cfset message = There was a problem with your login.
cflocation
url=../../#LOGINPATH#?url=#cgi.script_name##cgi.query_string#message=#message#
addtoken=no
/CFIF
CFELSE
!---No FORM login vars so redirect to login page ---
cfset message =
cflocation
url=../../#LOGINPATH#?url=#cgi.script_name##cgi.query_string#message=#message#
addtoken=no
/CFIF
cflogin
__
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: Mass Email Solution
Thank you for a useful reply Alex. Now I know more of what to look for. I searched on Cold Fusion and QMail many different ways and did not find anything, however now that I know what I SHOULD have been looking for, I would say that my result will be better. Thanks again -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 12:16 PM To: CF-Talk Subject: RE: Mass Email Solution qmail-inject... For example, to send a blank message to [EMAIL PROTECTED]: echo To: [EMAIL PROTECTED] | /var/qmail/bin/qmail-inject If you want to outsource this there are many people looking for work. On Tue, 23 Jul 2002, Larry Juncker wrote: Obviously you know not what you speak of.. I have spent two hours on your links and have found absolutely NOTHING dealing with Cold Fusion and Qmail. If you can not help someone with pertinent information then why respond at all? Thanks for obviously nothing... -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 8:56 AM To: CF-Talk Subject: RE: Mass Email Solution It would be easy if you just did a little research. http://www.google.com http://www.lifewithqmail.com http://cr.yp.to/qmail.html On Tue, 23 Jul 2002, Larry Juncker wrote: Matt; Could you expand on this simplistic answer just a little more please. Could you provide a sample template of what needs to be done by CFFILE in order to write directly to the QMAIL QUEUE. This sounds very intriguing to me. I would be open to anything that makes my outgoing mail work better. Thanks in Advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 1:29 PM To: CF-Talk Subject: RE: Mass Email Solution Go get qmail for free and use cffile to write emails directly to its queue. That will get you an MTA that can easily do a million emails in a day. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 11:27 AM To: CF-Talk Subject: Re: Mass Email Solution The current version is Windows only but we have long-term plans for a Linux version. Regards, Howie - Original Message - From: Chris Edwards [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 2:07 PM Subject: Re: Mass Email Solution I'm looking for a Unix/Windows solution, mainly a Unix one. Will iMS-SE run on Unix? - Original Message - From: Howie Hamlin [EMAIL PROTECTED]; [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 1:14 PM Subject: Re: Mass Email Solution You may want to have a look at iMS-SE for this. iMS-SE is a high-performance mail sending engine for ColdFusion that does not require an external email server like other CFMAIL replacements do. iMS is the mail sending engine behind all of the House of Fusion lists, BTW. Here is a comparison of iMS-SE versus other CFMAIL replacements: http://www.coolfusion.com/imssecomparison.cfm You can download and install a fully-functional 60-day trial from our downloads page. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Chris Edwards [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 12:03 PM Subject: Mass Email Solution Hey, Any suggestions on the best way to manage and send email to a list of about 10,000 in an efficient manner? Would I need to use a high-performance mail build? Should I not use cfmail, but a compiled tag? Thanks. __ 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: javascript addition
You might try adding a ParseInt() function around the value as well:
e.g. ParseInt(document.newBillingInfo.SCEPbilledAmount.value) +
ParseInt(document.newBillingInfo.SCEPpenaltyAmount.value)
etc...
Tim P.
- Original Message -
From: Tim Do [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 23, 2002 12:35 PM
Subject: javascript addition
Hello,
Can anybody show me how you would I would validate the sum of several text
boxes? This is what I'm trying to use but not having luck.. thanks in
advance.
function validate()
{
if (document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value !=
document.newBillingInfo.SCEPtotalAmount.value)
{
alert(The total Billing amount does not add up correctly, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
return true;
}
__
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: Flushing Application scoped vars
Yeah - I do it this way sometimes (holding a lookup query of inventory for
example). Some times I do something like this:
cfif NOT IsDefined('application.*somekey*') OR
IsDefined('url.forceRefresh')
cflock scope=application timeout=10
cfquery name=application.Inventory datasource=MyDsn
SELECT * FROM inventory_table
/cfquery
/cflock
/cfif
Then, I (or even my client) can just hit any page in the ap with
?forcerefresh=true appended to the URL - and viola! the application vars are
refreshed.
-mk
-Original Message-
From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 10:26 AM
To: CF-Talk
Subject: RE: Flushing Application scoped vars
This is actually a shopping cart structure that displays the items
in each category, subcategory or brand. The structure only gets
deleted if the owner of the store updates the database of products
and then I set a flag. I knew about deleting and clearing the
structure but it wasn't working. I think my problem was that I
didn't get rid of the cookies on my machine but I'm checking that now.
~Jason
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 10:15 AM
To: CF-Talk
Subject: RE: Flushing Application scoped vars
Jason,
You could loop through the scope (it's a structure) and delete the keys -
they would be instantiated on the next request. Note: if you have to do
this routinely then you are probably using the wrong scope. the Ap scope
should be reserved for data that changes very rarely (like lookup queries or
Datasource names).
-mk
Mark A. Kruger, MCSE, CFG
www.cfwebtools.com
www.necfug.com
no more brochures!
-Original Message-
From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 8:37 AM
To: CF-Talk
Subject: Flushing Application scoped vars
Does anyone know of a good way to flush the vars stored in the application
scope? I tried setting the applicationtimeout to CreateTimeSpan(0,0,0,0)
and
that didn't do anything. I'm not sure how cfflush works but I think that
has to
do with headers and not with ColdFusion cacheing. Anyway, if any of you has
a good tip for this I'd appreciate it.
Thanks,
Jason
!---
Jason Dowdell
[EMAIL PROTECTED]
321.799.6845
IM AES - Web Developer
---
__
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: CF Journal
I got July... I don't think August is out yet... -Original Message- From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 8:51 AM To: CF-Talk Subject: CF Journal Has anyone recieved a July or August issue of Journal or are they just sticking it to me. I paid for a two year sub almost a year ago and I have to call them about every other month to get my mag because for some reason there system doesnt flag me to get one. __ 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
Maximum value of column in cfoutput
Hello all, I have a column [ lvl ] being returned in a query that is a Count [ count(child.startbranch) AS lvl ]of another column. I need to be able to find the MAX of the returned column so that I can write colspans into a table I am building. Is there a way to get *essentially* MAX(lvl) in my cfoutput? Desired result: A table that builds itself dynamically so the end result will look like this td colspan=*max(lvl)* - lvl (here it'll be 0) 0 level header /td/tr tdnbsp;,/td td colspan=*max(lvl)* - lvl (here it'll be 1) 1 level subhead /td/tr etc. so far the data I need to display is 5 levels deep but that number is variable with new subs. TIA will William H. Bowen Webmaster ALSTOM's TD Energy Automation Information Business Your friendly neighborhood Webmaster [EMAIL PROTECTED] http://www.esca.com/ 425.739.3629 Voice 425.466.7016 Cell 425.739.3690 FAX __ 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 - Function Best Practice ?
I'm coming in mid-thread here so my apologies if this has been covered. AFAIK UDFs generally process fatser than custom tags. Is the same the case when using CFCs instead of a UDF? or does a CFC process slower (like custom tags)? Now isn't using a CFC instead of a UDF just like using a custom tag? We still have a central black box if you will and we still have inputs and outputs? I realize there are some differences revolving around variable scopes when using custom tags, but other than that they all seem to accomplish the same goal (some faster than others). Can you tell I don't come from an OOP background ;-) Thanks for any clarification Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Dan G. Switzer, II [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 11:23 AM Subject: RE: CFMX - Function Best Practice ? You can still create a UDF using CFFUNCTION. You're always going to find a use for UDFs, cause even in C++ not *everything* makes sense to have as an object. One key feature to the CFFUNCTION is it allows you to create some UDFs you could never create before. For example, you can now create a UDF that uses the CFWDDX tag (for that matter any other tag that didn't have a CFSCRIPT compatible syntax.) As for which is better, a CFC or a UDF--it depends. CFCs give you many advantages over just creating a UDF, but that may not always mean a CFC is the most appropriate architectural choice. There are times when using an oo-based approach to solve a task may be extreme overkill, and writing a straight UDF makes much more sense. For example, if I just need a function to calculate a value based upon a list, a UDF seems to make more sense than trying to create an object for the one functionality. However, if that list of values relates to some object and there's lots of manipulation required to that same set of data, then creating a re-usable component makes a lot of sense (since you can then use oo-based principles, by creating an instance of that data, which you can manipulate.) In a nutshell, I don't think UDFs are going anywhere and CFCs don't necessarily replace them. -Dan -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 12:52 PM To: CF-Talk Subject: CFMX - Function Best Practice ? Hello, I'm a little confused with all the new CFFUNCTION ability in CFMX - I know it's more extensible than UDFs as it can be used for WebServices, etc., but what is the best practice for creating functions? Are UDF functions going by the wayside after such a short lifespan or do they serve two seperate purposes now? Is it best to use CFC or UDF when not needing remote consumption or access? Is there a processing difference between the two? Thanks, Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com http://www.eaglewd.com/ [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) __ 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: Maximum value of column in cfoutput
I'm not sure I entirely follow you, but couldn't you ORDER BY lvl DESC to get the MAX lvl as the first record? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: William H. Bowen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 11:29 AM Subject: Maximum value of column in cfoutput Hello all, I have a column [ lvl ] being returned in a query that is a Count [ count(child.startbranch) AS lvl ]of another column. I need to be able to find the MAX of the returned column so that I can write colspans into a table I am building. Is there a way to get *essentially* MAX(lvl) in my cfoutput? Desired result: A table that builds itself dynamically so the end result will look like this td colspan=*max(lvl)* - lvl (here it'll be 0) 0 level header /td/tr tdnbsp;,/td td colspan=*max(lvl)* - lvl (here it'll be 1) 1 level subhead /td/tr etc. so far the data I need to display is 5 levels deep but that number is variable with new subs. TIA will William H. Bowen Webmaster ALSTOM's TD Energy Automation Information Business Your friendly neighborhood Webmaster [EMAIL PROTECTED] http://www.esca.com/ 425.739.3629 Voice 425.466.7016 Cell 425.739.3690 FAX __ 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: javascript addition
JavaScript is case sensitive, so that should be parseInt() rather than
ParseInt().
Chris Lofback
Sr. Web Developer
TRX Integration
28051 US 19 N., Ste. C
Clearwater, FL 33761
www.trxi.com
-Original Message-
From: Tim Painter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 2:37 PM
To: CF-Talk
Subject: Re: javascript addition
You might try adding a ParseInt() function around the value as well:
e.g. ParseInt(document.newBillingInfo.SCEPbilledAmount.value) +
ParseInt(document.newBillingInfo.SCEPpenaltyAmount.value)
etc...
Tim P.
- Original Message -
From: Tim Do [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 23, 2002 12:35 PM
Subject: javascript addition
Hello,
Can anybody show me how you would I would validate the sum of several text
boxes? This is what I'm trying to use but not having luck.. thanks in
advance.
function validate()
{
if (document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value !=
document.newBillingInfo.SCEPtotalAmount.value)
{
alert(The total Billing amount does not add up correctly, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
return true;
}
__
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: Maximum value of column in cfoutput
Unfortunately I don't need the data in that order, I just need the largest value of lvl so that I can use that as the colspan value at the top row of my table. will William H. Bowen Webmaster ALSTOM's TD Energy Automation Information Business Your friendly neighborhood Webmaster [EMAIL PROTECTED] http://www.esca.com/ 425.739.3629 Voice 425.466.7016 Cell 425.739.3690 FAX - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 11:52 AM Subject: Re: Maximum value of column in cfoutput I'm not sure I entirely follow you, but couldn't you ORDER BY lvl DESC to get the MAX lvl as the first record? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: William H. Bowen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 11:29 AM Subject: Maximum value of column in cfoutput Hello all, I have a column [ lvl ] being returned in a query that is a Count [ count(child.startbranch) AS lvl ]of another column. I need to be able to find the MAX of the returned column so that I can write colspans into a table I am building. Is there a way to get *essentially* MAX(lvl) in my cfoutput? Desired result: A table that builds itself dynamically so the end result will look like this td colspan=*max(lvl)* - lvl (here it'll be 0) 0 level header /td/tr tdnbsp;,/td td colspan=*max(lvl)* - lvl (here it'll be 1) 1 level subhead /td/tr etc. so far the data I need to display is 5 levels deep but that number is variable with new subs. TIA will William H. Bowen Webmaster ALSTOM's TD Energy Automation Information Business Your friendly neighborhood Webmaster [EMAIL PROTECTED] http://www.esca.com/ 425.739.3629 Voice 425.466.7016 Cell 425.739.3690 FAX __ 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 javascript addition
Thanks Stephen.. I tried that earlier but that only concatenates it
-Original Message-
From: Stephen Kellogg [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 10:08 AM
To: CF-Talk
Subject: RE: OT javascript addition
Tim,
try adding () around the addition part like so:
if ((document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value) !=
document.newBillingInfo.SCEPtotalAmount.value)
This should force the addition to take place before the comparison.
PS are you checking for numeric input only
This could be done like so:
if ((isNaN(document.newBillingInfo.SCEPbilledAmount.value)) ||
(isNaN(document.newBillingInfo.SCEPpenaltyAmount.value)) ||
(isNaN(document.newBillingInfo.SCEPdelinquentAmount.value)) ||
(isNaN(document.newBillingInfo.SCEPtotalAmount.value))
{
alert(The amounts must be numeric, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
else
{
if ((document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value) !=
document.newBillingInfo.SCEPtotalAmount.value)
{
alert(The total Billing amount does not add up correctly, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
return true;
}
}
or something like that ;-)
this is untested code but hopefully will give you something to work with.
HTH
Stephen
-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 12:36 PM
To: CF-Talk
Subject: javascript addition
Hello,
Can anybody show me how you would I would validate the sum of several text
boxes? This is what I'm trying to use but not having luck.. thanks in
advance.
function validate()
{
if (document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value !=
document.newBillingInfo.SCEPtotalAmount.value)
{
alert(The total Billing amount does not add up correctly, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
return true;
}
__
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
CFMX Error: Index: 163, Size: 156
Running: CFMX with Macromedia Web Server On a series of pages I keep getting the following error: Index: 163, Size: 156 The solution seems to be to just reload as the error never comes up twice in a row. The page has a few includes and about 10 templates in all including cfc's and custom tags and I have heard that MX has problems with too many includes so maybe that is the problem? Anyone got any advice on this error? Thanks, Sam __ 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: MX question
there are a number of Flash Communication Server component avaliable for Flash MX. Flash Communication Server also provides both a client and server side API, so you can program your own functionality. http://radio.weblogs.com/0106797/2002/07/17.html#a209 mike chambers [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 11:05 AM To: CF-Talk Subject: MX question This is a little off-topic... We are looking to integrate Fusion with Flash MX Server to do online collaboration/meetings. Does anyone out there know if Flash MX Server allows for or has modules to do desktop displaying? The demo on the Macromedia site talks up the online collaboration heavily, but doesn't mention many specifics other than a white board, chat, and video conferencing capabilities. Thanks in advance. Nick __ 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: Maximum value of column in cfoutput
If you're using CF 5 just run a query or a query to SELECT MAX(lvl) FROM YourQuery Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: William H. Bowen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 11:59 AM Subject: Re: Maximum value of column in cfoutput Unfortunately I don't need the data in that order, I just need the largest value of lvl so that I can use that as the colspan value at the top row of my table. will William H. Bowen Webmaster ALSTOM's TD Energy Automation Information Business Your friendly neighborhood Webmaster [EMAIL PROTECTED] http://www.esca.com/ 425.739.3629 Voice 425.466.7016 Cell 425.739.3690 FAX - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 11:52 AM Subject: Re: Maximum value of column in cfoutput I'm not sure I entirely follow you, but couldn't you ORDER BY lvl DESC to get the MAX lvl as the first record? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: William H. Bowen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 11:29 AM Subject: Maximum value of column in cfoutput Hello all, I have a column [ lvl ] being returned in a query that is a Count [ count(child.startbranch) AS lvl ]of another column. I need to be able to find the MAX of the returned column so that I can write colspans into a table I am building. Is there a way to get *essentially* MAX(lvl) in my cfoutput? Desired result: A table that builds itself dynamically so the end result will look like this td colspan=*max(lvl)* - lvl (here it'll be 0) 0 level header /td/tr tdnbsp;,/td td colspan=*max(lvl)* - lvl (here it'll be 1) 1 level subhead /td/tr etc. so far the data I need to display is 5 levels deep but that number is variable with new subs. TIA will William H. Bowen Webmaster ALSTOM's TD Energy Automation Information Business Your friendly neighborhood Webmaster [EMAIL PROTECTED] http://www.esca.com/ 425.739.3629 Voice 425.466.7016 Cell 425.739.3690 FAX __ 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: Maximum value of column in cfoutput
and if you're not using CF 5... cfset LevelList = ValueList(YourQuery.Lvl) Then do some list manipulation to get the MAX item in the list Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: William H. Bowen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 11:59 AM Subject: Re: Maximum value of column in cfoutput Unfortunately I don't need the data in that order, I just need the largest value of lvl so that I can use that as the colspan value at the top row of my table. will William H. Bowen Webmaster ALSTOM's TD Energy Automation Information Business Your friendly neighborhood Webmaster [EMAIL PROTECTED] http://www.esca.com/ 425.739.3629 Voice 425.466.7016 Cell 425.739.3690 FAX - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 11:52 AM Subject: Re: Maximum value of column in cfoutput I'm not sure I entirely follow you, but couldn't you ORDER BY lvl DESC to get the MAX lvl as the first record? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: William H. Bowen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 11:29 AM Subject: Maximum value of column in cfoutput Hello all, I have a column [ lvl ] being returned in a query that is a Count [ count(child.startbranch) AS lvl ]of another column. I need to be able to find the MAX of the returned column so that I can write colspans into a table I am building. Is there a way to get *essentially* MAX(lvl) in my cfoutput? Desired result: A table that builds itself dynamically so the end result will look like this td colspan=*max(lvl)* - lvl (here it'll be 0) 0 level header /td/tr tdnbsp;,/td td colspan=*max(lvl)* - lvl (here it'll be 1) 1 level subhead /td/tr etc. so far the data I need to display is 5 levels deep but that number is variable with new subs. TIA will William H. Bowen Webmaster ALSTOM's TD Energy Automation Information Business Your friendly neighborhood Webmaster [EMAIL PROTECTED] http://www.esca.com/ 425.739.3629 Voice 425.466.7016 Cell 425.739.3690 FAX __ 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: Maximum value of column in cfoutput
You can do it in CF after the query is back ... cfset maxLvl = ArrayMax(ListToArray(ValueList(query.column))) Dan -Original Message- From: William H. Bowen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 11:59 AM To: CF-Talk Subject: Re: Maximum value of column in cfoutput Unfortunately I don't need the data in that order, I just need the largest value of lvl so that I can use that as the colspan value at the top row of my table. will William H. Bowen Webmaster ALSTOM's TD Energy Automation Information Business Your friendly neighborhood Webmaster [EMAIL PROTECTED] http://www.esca.com/ 425.739.3629 Voice 425.466.7016 Cell 425.739.3690 FAX - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 11:52 AM Subject: Re: Maximum value of column in cfoutput I'm not sure I entirely follow you, but couldn't you ORDER BY lvl DESC to get the MAX lvl as the first record? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: William H. Bowen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 11:29 AM Subject: Maximum value of column in cfoutput Hello all, I have a column [ lvl ] being returned in a query that is a Count [ count(child.startbranch) AS lvl ]of another column. I need to be able to find the MAX of the returned column so that I can write colspans into a table I am building. Is there a way to get *essentially* MAX(lvl) in my cfoutput? Desired result: A table that builds itself dynamically so the end result will look like this td colspan=*max(lvl)* - lvl (here it'll be 0) 0 level header /td/tr tdnbsp;,/td td colspan=*max(lvl)* - lvl (here it'll be 1) 1 level subhead /td/tr etc. so far the data I need to display is 5 levels deep but that number is variable with new subs. TIA will William H. Bowen Webmaster ALSTOM's TD Energy Automation Information Business Your friendly neighborhood Webmaster [EMAIL PROTECTED] http://www.esca.com/ 425.739.3629 Voice 425.466.7016 Cell 425.739.3690 FAX __ 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: CFMX - Function Best Practice ?
At 01:19 PM 7/23/2002 -0400, you wrote: UDFs are not going by the wayside, it's still a good thing to use. I just use it for display formatting and things like that. CFModules to me have gone to the wayside as I'm using CFCs more. I haven't figured out what I'm going to be using cfmodule for anymore. ;) I had this conversation with Rob Brooks Bilson (I.E. he wrote the O'rielly Programming ColdFusion book and is part maintainer of cflib.org ) during the beta cycle. The thing that you can do with custom tags (When you say cfmodule, I imagine you mean custom tags) that you cannot do with CFCs / user defined functions is create subtags. As an example from the CFML language, you must use cfslider inside a cfform tag. So, cfslider is a subtag of cfform. Or cfqueryparam is a subtag of cfquery. There are some other examples. I have never needed to build a custom tag in this manner, but it is something I cannot do with a CFC or UDF. -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Phone: 1-203-379-0773 -- My CFMX Book: http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20 My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.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: OT javascript addition
Try doing eval(document.newBillingInfo.SCEPbilledAmount.value) +
eval(document.newBillIngo.SCEPpenaltyAmount.value), etc. At least in
ActionScript (Flash) this forces the value to be treated as a number for
addition purposes. A quick test in IE javascript showed it to work there
also.
Dan
-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 11:30 AM
To: CF-Talk
Subject: RE: OT javascript addition
Thanks Stephen.. I tried that earlier but that only concatenates it
-Original Message-
From: Stephen Kellogg [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 10:08 AM
To: CF-Talk
Subject: RE: OT javascript addition
Tim,
try adding () around the addition part like so:
if ((document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value) !=
document.newBillingInfo.SCEPtotalAmount.value)
This should force the addition to take place before the comparison.
PS are you checking for numeric input only
This could be done like so:
if ((isNaN(document.newBillingInfo.SCEPbilledAmount.value)) ||
(isNaN(document.newBillingInfo.SCEPpenaltyAmount.value)) ||
(isNaN(document.newBillingInfo.SCEPdelinquentAmount.value)) ||
(isNaN(document.newBillingInfo.SCEPtotalAmount.value))
{
alert(The amounts must be numeric, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
else
{
if ((document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value) !=
document.newBillingInfo.SCEPtotalAmount.value)
{
alert(The total Billing amount does not add up correctly, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
return true;
}
}
or something like that ;-)
this is untested code but hopefully will give you something to work with.
HTH
Stephen
-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 12:36 PM
To: CF-Talk
Subject: javascript addition
Hello,
Can anybody show me how you would I would validate the sum of several text
boxes? This is what I'm trying to use but not having luck.. thanks in
advance.
function validate()
{
if (document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value !=
document.newBillingInfo.SCEPtotalAmount.value)
{
alert(The total Billing amount does not add up correctly, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
return true;
}
__
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 - Function Best Practice ?
At 02:23 PM 7/23/2002 -0400, you wrote: You can still create a UDF using CFFUNCTION. You're always going to find a use for UDFs, cause even in C++ not *everything* makes sense to have as an object. I would argue against this point. It really depends what type of programming design you are applying to the language. If you are applying true OO design, then it wouldn't make sense to have anything not as an object. If you are applying procedural design, then it doesn't make sense to make anything an object. If you are applying a mix of the two, then what you say is true. In a nutshell, I don't think UDFs are going anywhere and CFCs don't necessarily replace them. I couldn't have said it better myself. :) -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Phone: 1-203-379-0773 -- My CFMX Book: http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20 My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.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: Maximum value of column in cfoutput
We are still on 4.5 ... why won't valuelist work in CF5? -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 12:08 PM To: CF-Talk Subject: Re: Maximum value of column in cfoutput and if you're not using CF 5... cfset LevelList = ValueList(YourQuery.Lvl) Then do some list manipulation to get the MAX item in the list Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: William H. Bowen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 11:59 AM Subject: Re: Maximum value of column in cfoutput Unfortunately I don't need the data in that order, I just need the largest value of lvl so that I can use that as the colspan value at the top row of my table. will William H. Bowen Webmaster ALSTOM's TD Energy Automation Information Business Your friendly neighborhood Webmaster [EMAIL PROTECTED] http://www.esca.com/ 425.739.3629 Voice 425.466.7016 Cell 425.739.3690 FAX - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 11:52 AM Subject: Re: Maximum value of column in cfoutput I'm not sure I entirely follow you, but couldn't you ORDER BY lvl DESC to get the MAX lvl as the first record? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: William H. Bowen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 11:29 AM Subject: Maximum value of column in cfoutput Hello all, I have a column [ lvl ] being returned in a query that is a Count [ count(child.startbranch) AS lvl ]of another column. I need to be able to find the MAX of the returned column so that I can write colspans into a table I am building. Is there a way to get *essentially* MAX(lvl) in my cfoutput? Desired result: A table that builds itself dynamically so the end result will look like this td colspan=*max(lvl)* - lvl (here it'll be 0) 0 level header /td/tr tdnbsp;,/td td colspan=*max(lvl)* - lvl (here it'll be 1) 1 level subhead /td/tr etc. so far the data I need to display is 5 levels deep but that number is variable with new subs. TIA will William H. Bowen Webmaster ALSTOM's TD Energy Automation Information Business Your friendly neighborhood Webmaster [EMAIL PROTECTED] http://www.esca.com/ 425.739.3629 Voice 425.466.7016 Cell 425.739.3690 FAX __ 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: RE: OT javascript addition
You'll have to use parseFloat or parseInt to explicitly cast the value
to a number. Then you'll be able to add them.
However, a BIG word of warning: JavaScript SUCKS at proper floating
point manipulation.
There are functions that you can find that'll clear up the numbers
before you add them that can help, or if you're in using IE only, use
VBScript instead.
- Original Message -
From: Tim Do [EMAIL PROTECTED]
Date: Tuesday, July 23, 2002 12:30 pm
Subject: RE: OT javascript addition
Thanks Stephen.. I tried that earlier but that only concatenates it
-Original Message-
From: Stephen Kellogg [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 10:08 AM
To: CF-Talk
Subject: RE: OT javascript addition
Tim,
try adding () around the addition part like so:
if ((document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value) !=
document.newBillingInfo.SCEPtotalAmount.value)
This should force the addition to take place before the comparison.
PS are you checking for numeric input only
This could be done like so:
if ((isNaN(document.newBillingInfo.SCEPbilledAmount.value)) ||
(isNaN(document.newBillingInfo.SCEPpenaltyAmount.value)) ||
(isNaN(document.newBillingInfo.SCEPdelinquentAmount.value)) ||
(isNaN(document.newBillingInfo.SCEPtotalAmount.value))
{
alert(The amounts must be numeric, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
else
{
if ((document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value) !=
document.newBillingInfo.SCEPtotalAmount.value)
{
alert(The total Billing amount does not add up correctly,
Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
return true;
}
}
or something like that ;-)
this is untested code but hopefully will give you something to
work with.
HTH
Stephen
-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 12:36 PM
To: CF-Talk
Subject: javascript addition
Hello,
Can anybody show me how you would I would validate the sum of
several text
boxes? This is what I'm trying to use but not having luck..
thanks in
advance.
function validate()
{
if (document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value !=
document.newBillingInfo.SCEPtotalAmount.value)
{
alert(The total Billing amount does not add up correctly,
Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
return true;
}
__
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 javascript addition
If that's the case, add a parseInt() or parseFloat() around each variable to
make sure it is in fact a numeric value. Or you may have to do some
validation first (i.e. can the user enter HELLO for a numeric value?).
Also on this note, you might have to strip any formatting (i.e. $1,000.00
and 1,000.00 will not be interpreted as a number by javascript - the comma
and dollar sign need to be stripped).
HTH.
Shawn Grover
-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 12:30 PM
To: CF-Talk
Subject: RE: OT javascript addition
Thanks Stephen.. I tried that earlier but that only concatenates it
-Original Message-
From: Stephen Kellogg [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 10:08 AM
To: CF-Talk
Subject: RE: OT javascript addition
Tim,
try adding () around the addition part like so:
if ((document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value) !=
document.newBillingInfo.SCEPtotalAmount.value)
This should force the addition to take place before the comparison.
PS are you checking for numeric input only
This could be done like so:
if ((isNaN(document.newBillingInfo.SCEPbilledAmount.value)) ||
(isNaN(document.newBillingInfo.SCEPpenaltyAmount.value)) ||
(isNaN(document.newBillingInfo.SCEPdelinquentAmount.value)) ||
(isNaN(document.newBillingInfo.SCEPtotalAmount.value))
{
alert(The amounts must be numeric, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
else
{
if ((document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value) !=
document.newBillingInfo.SCEPtotalAmount.value)
{
alert(The total Billing amount does not add up correctly, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
return true;
}
}
or something like that ;-)
this is untested code but hopefully will give you something to work with.
HTH
Stephen
-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 12:36 PM
To: CF-Talk
Subject: javascript addition
Hello,
Can anybody show me how you would I would validate the sum of several text
boxes? This is what I'm trying to use but not having luck.. thanks in
advance.
function validate()
{
if (document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value !=
document.newBillingInfo.SCEPtotalAmount.value)
{
alert(The total Billing amount does not add up correctly, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
return true;
}
__
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
LoRCAT final Beta available for download
The final Beta of LoRCAT, the Load Reduction and Concentration Analysis Tool for ColdFusion, is now available for download from www.ProductivityEnhancement.com. This is a public Beta. LoRCAT increases the performance of every ColdFusion application on Earth. LoRCAT analyzes your application, precisely discovers your performance bottlenecks, and shows you where your optimization efforts will yield the best results with minimal effort. You will need a License Key to test the Beta. Just email your Installation Code to me at [EMAIL PROTECTED] and I will email back your License Key. If you are a current Beta tester, un-install any earlier Beta you now have and install Beta 5. If your Beta License Key has expired then email us your Installation Code and we'll issue you a new one. Respectfully, Adam Phillip Churvis Advanced Intensive ColdFusion MX Training http://www.ColdFusionTraining.com E-mail: [EMAIL PROTECTED] Phone: 770-446-8866 __ 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 javascript addition
but keep in mind that eval() is a little slower in processing time bacause
you are first converting a string value, then interpreting it.
While I know it's needed quite often, I would try to avoid the use of eval()
whenever possible - especially if you are dealing with numeric values.
Also, in this case if your numbers are formatted, then eval() will end up
raising an error.
My thoughts.
Shawn Grover
-Original Message-
From: Dan Haley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 1:13 PM
To: CF-Talk
Subject: RE: OT javascript addition
Try doing eval(document.newBillingInfo.SCEPbilledAmount.value) +
eval(document.newBillIngo.SCEPpenaltyAmount.value), etc. At least in
ActionScript (Flash) this forces the value to be treated as a number for
addition purposes. A quick test in IE javascript showed it to work there
also.
Dan
-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 11:30 AM
To: CF-Talk
Subject: RE: OT javascript addition
Thanks Stephen.. I tried that earlier but that only concatenates it
-Original Message-
From: Stephen Kellogg [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 10:08 AM
To: CF-Talk
Subject: RE: OT javascript addition
Tim,
try adding () around the addition part like so:
if ((document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value) !=
document.newBillingInfo.SCEPtotalAmount.value)
This should force the addition to take place before the comparison.
PS are you checking for numeric input only
This could be done like so:
if ((isNaN(document.newBillingInfo.SCEPbilledAmount.value)) ||
(isNaN(document.newBillingInfo.SCEPpenaltyAmount.value)) ||
(isNaN(document.newBillingInfo.SCEPdelinquentAmount.value)) ||
(isNaN(document.newBillingInfo.SCEPtotalAmount.value))
{
alert(The amounts must be numeric, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
else
{
if ((document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value) !=
document.newBillingInfo.SCEPtotalAmount.value)
{
alert(The total Billing amount does not add up correctly, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
return true;
}
}
or something like that ;-)
this is untested code but hopefully will give you something to work with.
HTH
Stephen
-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 12:36 PM
To: CF-Talk
Subject: javascript addition
Hello,
Can anybody show me how you would I would validate the sum of several text
boxes? This is what I'm trying to use but not having luck.. thanks in
advance.
function validate()
{
if (document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value !=
document.newBillingInfo.SCEPtotalAmount.value)
{
alert(The total Billing amount does not add up correctly, Please
check the values.)
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
return true;
}
__
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: Custom tag length in CFMX?
I thought this was a pretty interesting question. I quickly looked in the cfmx app dev .pdf file from the Macromedia site. I didn't find anything. If someone knows or finds the answer, I would certainly like to know as well. Yves - Original Message - From: Kwang Suh [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 11:26 AM Subject: RE: Custom tag length in CFMX? Anyone at MM know about this? This is a bit of problem, ya know. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 4:03 PM To: CF-Talk Subject: Custom tag length in CFMX? I have a custom tag that's 108kb large. I'm getting an error in CFMX saying that it's over 65kb. Are there any issues with CFMX not handling custom tags larger than 65kb? __ 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
