RE: A Tip (maybe new, maybe not)
Not having to re-establish the connections repeatedly helps with performance. -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 11:02 PM To: CF-Talk Subject: RE: A Tip (maybe new, maybe not) What's the advantage of locking the server on to the database at all? Is it performance? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Subject: Re: A Tip (maybe new, maybe not) Go into the CF Admin and uncheck maintain database connections and your database wont lock at all unless it's actively being accessed by CF. jon Paul Giesenhagen wrote: I don't know if any of you work with Access much as a database here and there, but I have been developing using an access database and had to upload it to our servers after looking at the data or correcting the data as I was writing scripts ..well as you all know it locks so you cannot FTP over it once it has been accessed. I would stop/start the cf service to get this to run, well it became a pain when my terminal window would timeout and I would have to logg back into my server yadda yadda. __ 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: A Tip (maybe new, maybe not)
Using SQL Server maintaining the connection would be advantageous because their wouldn't be the overhead for making a new connection, logging in, etc. In Access I don't think it matters. It is only Access after all. If I get concerned about performance of a site based on Access, I upgrade the site to SQL Server if CF's query caching wont do the trick. I believe it's actually reccomended that connections to Access databases are not maintained for memory reasons. jon Mike Kear wrote: What's the advantage of locking the server on to the database at all? Is it performance? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Subject: Re: A Tip (maybe new, maybe not) Go into the CF Admin and uncheck maintain database connections and your database wont lock at all unless it's actively being accessed by CF. jon Paul Giesenhagen wrote: I don't know if any of you work with Access much as a database here and there, but I have been developing using an access database and had to upload it to our servers after looking at the data or correcting the data as I was writing scripts ..well as you all know it locks so you cannot FTP over it once it has been accessed. I would stop/start the cf service to get this to run, well it became a pain when my terminal window would timeout and I would have to logg back into my server yadda yadda. __ 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: server crashing... Caught a fatal signal - More Info
Deduced that it only happens when the SQL error is in a table in the same PostgreSQL database as the Client Variable Store. When I switch to another PostgreSQL database or use the Registry(Linux), I get normal CF-SQL errors. too weird At 10:51 PM 5/16/02 -0700, you wrote: Still happening... the server.log file shows: -- Fatal,9225,05/16/02,22:42:12,,Caught a fatal signal (11) - Aborting Information,1024,05/16/02,22:42:16,,The ColdFusion Application Server started. -- any ideas where to look? At 12:54 PM 5/11/02 +0100, you wrote: Brian, A long shot, but have you checked your disk space? Check logs too Dave -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: 11 May 2002 04:52 To: CF-Talk Subject: server crashing... Server keeps crashing suddenly... Because a Simple SELECT Statement with a bad spelling for a column. Usually I get a error message telling me attribute (bad spelling variable) does not exist. But suddenly the last few hours... the CF server is crashing... see error below... I just rebooted the Computer yet... the error persists... I'm baffled. I turned off cfferror to avoid anything there... still not working though. thanks for any ideas. Brian -- Error Msg in IE5.5 - Error Occurred While Processing Request Error Diagnostic Information An error occurred while attempting to establish a connection to the server. The most likely cause of this problem is that the server is not currently running. Verify that the server is running and restart it if necessary. Unix error number 2 occurred: No such file or directory __ 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: apache 2 - windows
I vaguely remember this being discussed a while back and can't find the thread in the archives but... Has anyone built a coldfusion module to load with the new apache windows version ? What version of ColdFusion are you looking to get the shared object for? I'm not sure what the differences are in the Preview Release and Release Candidate versions of CFMX, but CFMX RC 1 does have an SO for Apache 2.x on windoze. - Brandon -- http://spooled.net http://booms.net 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: CFEXECUTE
Ray Bujarski wrote: I am using the cfexecute to execute a local file on the server CFEXECUTE NAME=/pkg/licenses/vendors/globes/bin-5.0/lmstat ARGUMENTS= -a -c /pkg/licenses/vendors/avanti/license_file TIMEOUT=100 Executing... /cfexecute Problem is it just decided to quit with any output! I tried it from a prompt and everything works fine, it executes and shows me everything I don't see when trying with cfexecute. I looked and cfexecute is not disabled on the server. Does anyone know why this wouldn't work? There is a bug in cfexecute that prevents it from returning more as some 2000 characters. If your app tries to do so, make sure you use the outputfile attribue. Jochem __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
File extensions
A very big list.. http://www.ace.net.nz/tech/TechFileFormat.html can't remember who was asking for this. Ade __ 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
cross post, comparison sheets
Has anyone come up with any of those handy little ASP VS. CF VS. blah blah type charts yet? I know it's in Beta/ preview release, I'm not looking for performance numbers. just functionality. I'm pretty familiar with what MX has to offer but not so sure about .NET (ASP.NET) I saw a presentation and have a slight inkling but nothing with which to go into a meeting with. Any MACR people got one yet :-) The reason being is that our subscription is up sometime soon so MX will be a completely new purchase, so in light of that there is talk of maybe choosing a new platform, just want to make sure all sides are equally looked at. Thanks guys. J. John Wilker Codito, ergo sum Web Applications Consultant, and Writer Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com http://www.red-omega.com/ Life is an opportunity, benefit from it. Life is a promise, fulfill it. Life is life, fight for it. __ 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: CFINTERNALDEBUG
Hi Scott I know that the PCODE action is used to recompile a CF template into PCode without executing it - very handy for refreshing a file in the template cache when Trusted Cache is on. You can use it like this: CFINTERNALDEBUG ACTION=pcode OUTVAR=r_var TEMPLATEPATH=#template# Although you have to do a little registry tweaking first - !--- if Trusted Cache is enabled --- CFREGISTRY ACTION=Get BRANCH=HKEY_LOCAL_MACHINE\Software\Allaire\ColdFusion\CurrentVersion\Server ENTRY=AssumeTemplateCacheIsNotDirty TYPE=String VARIABLE=r_value cfif r_value neq 1 !--- update the CF trusted cache setting to 0 --- CFREGISTRY ACTION=Set BRANCH=HKEY_LOCAL_MACHINE\Software\Allaire\ColdFusion\CurrentVersion\Server ENTRY=AssumeTemplateCacheIsNotDirty TYPE=String VALUE=0 !--- have CF reread the registry --- cfset temp = CFUSION_SETTINGS_REFRESH() !--- Refresh the template --- CFINTERNALDEBUG ACTION=pcode OUTVAR=r_var TEMPLATEPATH=#template# !--- turn truested cache back on --- CFREGISTRY ACTION=Set BRANCH=HKEY_LOCAL_MACHINE\Software\Allaire\ColdFusion\CurrentVersion\Server ENTRY=AssumeTemplateCacheIsNotDirty TYPE=String VALUE=1 !--- have CF reread the registry --- cfset temp = CFUSION_SETTINGS_REFRESH() /cfif As this tag is undocumented and unsupported, I've no idea of how safe it is to do this. I've never had any problems doing it, but it's probably worth putting a cflock scope=server around it. HTH Alistair Alistair Davidson Application Developer Freeserve.com PLC www.smartgroups.com -Original Message- From: Boardworks Interactive [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 07:09 To: CF-Talk Subject: CFINTERNALDEBUG Does anyone know what this tag does? I was able to deduce that it had an attribute, ACTION which could be either BREAK, LEAK, PCODE, REPORTSTATE, SETBREAKALLOC and WRITEOUTPUT. Each ACTION has its own attributes, but I don't know what each of these actions does - morever what it outputs (as I would like to view it). I understand the MM doesn't support this tag, but I was wondering if any of you smart folks figured it out. TIA! SCOTT VAN VLIET BRD.WRKS INTERACTIVE T: 714.469.6805 E: [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: MS SQL vs MySQL WAS: [admin] List status
Last time I checked it did not support refrential integrity, you enforce it manually. This and lack of stored procedure support is enough to keep me away (as much as I would like a free/cheap alternative). Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 1:57 PM To: CF-Talk Subject: Re: MS SQL vs MySQL WAS: [admin] List status I should have been more specific, but I mean in terms of features and not just speed. I use stored procs almost exclusively and thats my only main gripe about MySQL. -- Clint Tredway -- Through Him, anything is possible. What about the recent comparison in eWeek between MySQL, Oracl9i and SQL2k? MySQL was neck and neck with Oracle in response time and throughput, both better than SQL2k? I know that MySQL cannot really stand up to MS SQL but when you are talking about the amount that MS SQL costs versus using MySQL, I would us MySQL unless someone just wanted to pay for MS SQL. -- Clint Tredway -- Through Him, anything is possible. Can you say crap. :) I am not a big fan of MySQL. I have to do some work in it and it pales in comparison. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 5:19 PM To: CF-Talk Subject: Re: [admin] List status Can you say MySQL? g - Original Message - From: Margaret Fisk [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 14, 2002 6:10 PM Subject: RE: [admin] List status Actually, we just priced this: It is about $5000 per cpu if you get SQL Server Standard edition and about 20,000 (not sure about this one) per cpu if you want Enterprise edition. The difference between the editions is failover and uptime tools. __ 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: MS SQL vs MySQL WAS: [admin] List status
Justin Greene wrote: Last time I checked it did not support refrential integrity, you enforce it manually. This and lack of stored procedure support is enough to keep me away (as much as I would like a free/cheap alternative). Then pick something else, it is not like MySQL is the only option. FireBird: http://firebird.sourceforge.net/ SAPdb: http://www.sapdb.org/ PostgreSQL: http://postgresql.org/ I only have hands-on experience with PostgreSQL, and it rocks. Extremely stable, standards compliant and feature complete. Not to mention free, and I don't mean as in beer but I mean as in speach (but the beer part is free as well). Jochem __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WAY OT DTS PACKAGE
SQL 2000's DTS package allows you to run any Win32 process or batch file via a Execute Process Task. You can use this to run the unzip program before you import the data. I don't think this is available for SQL 7. --- Joshua Tipton [EMAIL PROTECTED] wrote: Does anyone know via DTS how to open a zip file so that I can attach to a dbf file that is in the zip file? Josh = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.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
banner program
I am looking for a CF based banner ad program. I have looked at all the banner ad programs on the MM developer exchange. Anyone have any comments/recommendations/experiences? 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
CF Based Fax Blast
Has anyone written a CF based fax blast application? If so, how well does it work , meaning how many fax numbers can be blasted at it and is it available as open source? If not, can anyone recommend a good fax balst program that can handle several thousand fax numbers at a time. Thanks in advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential, and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the email listed above. __ 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 2 - windows
Running CF5 which has a dll module for the earlier versions of apache included, but I'm sure this won't work with the new. . BTW, The pre-release of MX detected apache 2 on the system and added the handlers automatically. No manually configuration at all was required. __ 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
cfreport
Hello all, I am having trouble with the cfreport tag. I'm trying to connect to an oracle db, and I have created a dsn using the crystal reports oracle 8 driver, which is verified as working in the cf administrator. this is what the CF5 docs say: cfreport report = '/reports/monthlysales.rpt' {Departments.Department} = 'International' /cfreport and then on the same page but different they say: cfreport report = report_path orderBy = result_order username = username password = password formula = formula /cfreport when i try this: cfreport report=dailytimesheets.rpt username=cf password=fusion/cfreport it can't find the report, even though the cfm and the rpt files are in the same directory. when i do this: cfreport report=D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt username=cf password=fusion/cfreport I get the error: Error occurred while processing CFREPORT An unexpected error occurred while using the Crystal Engine. Error number 692 ocurred (Error in File D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt: Invalid export DLL or export format.). My thinking is that the cfdocs are just plain wrong and my syntax is right.. but I must be missing something. All help is appreciated. Ken Beard __ 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
Email Server
I need an easy to configure email server that will do POP3 and that I can write CF against to create/Delete new accounts and I would like it to be free or very close to free. I downloaded Pegasus/Mercury but I don't care for it and would like somthing else to compare. Exchange and it s Cals are just to much money for what I need. Preferable runms on NT/2000. But if it is real easy then Linux. Rick Eidson __ 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
CFS5 CFMX VTM updater soon available from Macromedia
Hi All! I found out late last night that we've made an updater for the CFMX VTMs for CFStudio 5. This will be available for download very soon - it's in que to be posted by our webteam. It's my understanding that this updater will be linked from a HS+/CFS FAQ, and I'll send that link as soon as I have it. *smiles everyone, smiles!* Vernon Viehe Community Manager Macromedia, Inc. Macromedia Certified Professional http://vvmx.blogspot.com __ 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: cfreport
Don't know if this will help. http://www.macromedia.com/v1/Handlers/index.cfm?ID=16757Method=Full There are undocumented properties of the CFReport Tag. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/17/02 10:02AM Hello all, I am having trouble with the cfreport tag. I'm trying to connect to an oracle db, and I have created a dsn using the crystal reports oracle 8 driver, which is verified as working in the cf administrator. this is what the CF5 docs say: cfreport report = '/reports/monthlysales.rpt' {Departments.Department} = 'International' /cfreport and then on the same page but different they say: cfreport report = report_path orderBy = result_order username = username password = password formula = formula /cfreport when i try this: cfreport report=dailytimesheets.rpt username=cf password=fusion/cfreport it can't find the report, even though the cfm and the rpt files are in the same directory. when i do this: cfreport report=D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt username=cf password=fusion/cfreport I get the error: Error occurred while processing CFREPORT An unexpected error occurred while using the Crystal Engine. Error number 692 ocurred (Error in File D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt: Invalid export DLL or export format.). My thinking is that the cfdocs are just plain wrong and my syntax is right.. but I must be missing something. All help is appreciated. Ken Beard __ 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: CFS5 CFMX VTM updater soon available from Macromedia
BIG SMILE Thanks Vernon! Sandy - Original Message - From: Vernon Viehe [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 17, 2002 10:13 AM Subject: CFS5 CFMX VTM updater soon available from Macromedia Hi All! I found out late last night that we've made an updater for the CFMX VTMs for CFStudio 5. This will be available for download very soon - it's in que to be posted by our webteam. It's my understanding that this updater will be linked from a HS+/CFS FAQ, and I'll send that link as soon as I have it. *smiles everyone, smiles!* Vernon Viehe Community Manager Macromedia, Inc. Macromedia Certified Professional http://vvmx.blogspot.com __ 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: cfreport
nevermind... found this on the crystal reports website Unfortunately there is currently no integration with Crystal Reports 8 and the CF report tag. ColdFusion ships with version 5.0 of Crystal Reports and Macromedia has released patches to allow version 6 and version 7 to work with the CF report tag. As this time there is no fix for Crystal Reports 8 to work with ColdFusion. that sucks. Ken -Original Message- From: Ken Beard [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:03 AM To: CF-Talk Subject: cfreport Hello all, I am having trouble with the cfreport tag. I'm trying to connect to an oracle db, and I have created a dsn using the crystal reports oracle 8 driver, which is verified as working in the cf administrator. this is what the CF5 docs say: cfreport report = '/reports/monthlysales.rpt' {Departments.Department} = 'International' /cfreport and then on the same page but different they say: cfreport report = report_path orderBy = result_order username = username password = password formula = formula /cfreport when i try this: cfreport report=dailytimesheets.rpt username=cf password=fusion/cfreport it can't find the report, even though the cfm and the rpt files are in the same directory. when i do this: cfreport report=D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt username=cf password=fusion/cfreport I get the error: Error occurred while processing CFREPORT An unexpected error occurred while using the Crystal Engine. Error number 692 ocurred (Error in File D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt: Invalid export DLL or export format.). My thinking is that the cfdocs are just plain wrong and my syntax is right.. but I must be missing something. All help is appreciated. Ken Beard __ 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
New Developer resources!
Hi all! The Designer Developer Center on www.macromedia.com/desdev just launched new content, which features a great article by Rob Brooks-Bilson: *Harnessing XML with custom tags or ColdFusion Components http://www.macromedia.com/desdev/mx/coldfusion/articles/custom_cf_tag.html Have you been catching JD's Forum? This regular column features the always colorful John Dowdell. http://www.macromedia.com/desdev/jd_forum/ In this release's column, John addresses such issues as CFMX on MacOSX, does it or doesn't it?, and... (well, ok, that's probably the part that most interests us CF folks, but JD is just darn interesting to read, so I'd bet you'll enjoy the rest of it too!) If you haven't been to The ColdFusion MX Application Development Center, you gotta check it out: http://www.macromedia.com/desdev/mx/coldfusion/ Here are just a few of the great articles and whitepapers about ColdFusion that you'll find there: *Macromedia MX: Components and Web Services Jeremy Allaire explores the simple and elegant programming model of Macromedia MX. *Migrating Your Application to ColdFusion MX Make your transition from ColdFusion 5 to ColdFusion MX trouble-free. *Next-generation UDFs Through the CFFunction Tag The new User Defined Functions (UDFs) break free from CFScript. Find out how to write efficient user-defined functions in CFML. *Java in ColdFusion MX What does ColdFusion MX running on a J2EE platform mean to ColdFusion and Java developers? And lots on CFCs: *ColdFusion Components: The New Architecture Develop applications with strong and flexible architecture. Ben Elmore explains the new and powerful CFC methodology. *CFC Best Practices: Invoking a Security CFC Any Way You Like A showcase series of the newest and coolest ways to use CFCs. This week, implement a Security CFC and invoke any way you like. *Custom Tag or CFC? That is the Question Find out when to use a CFC over a custom tag. Learn how to make an easy transition that will pay off in performance. We're working on a lot of great new content that we hope CF developers will like. If you don't find what you're looking for, please send us your suggestions: http://www.macromedia.com/support/email/desdev/main.cgi?from=desdev. If you're interested in having some of your own writing appear on the Designer Developer Center, please contact me directly: [EMAIL PROTECTED] (or for any other reason!) Happy Coding! Vernon Viehe Community Manager Macromedia, Inc. -- Macromedia Certified Professional http://vvmx.blogspot.com __ 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
cf_HTML2Excel Question
Does anyone have any expeirence with this tag? I have it working almost to where I need it but I'm running into an odd problem. I have a field that is coming in from a SQL Server VarChar with '00' as the value in the field. It is being output to the HTML as 00 in the table but for some reason the excel file is translating it as a numeric value and saving a single 0 in the file. The problem is that it's *supposed* to be a numeric value, so now I guess the question is how to I force the tag (or more to the point, Excel) to save the numbers as characters? TIA! Hatton __ 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
UDFs in a Custom Tag problem
Hello developers, I'm writing a custom tag, and I've written some UDFs to clean up some of the code within the custom tag. Only the custom tag uses these UDFs - they're pretty specialized - so I thought it would be easiest to just put them right inside the template for the custom tag. Here's my general structure: cfif thistag.executionmode EQ start cfscript function IsOperator( value ) { blah blah blah; return something; } /cfscript more code /cfif cfif thistag.executionmode EQ end some output, etc. /cfif I get this error: Routines cannot be declared more than once. The routine IsOperator has been declared twice in different templates. I have found that this error occurs at the very beginning of the end ExecutionMode of the tag. I can't figure out how to stop this error. Any ideas? Thanks Mike Mertsock Alfred University Webteam Outgrown your current e-mail service? Get a 25MB Inbox, POP3 Access, No Ads and No Taglines with LYCOS MAIL PLUS. http://login.mail.lycos.com/brandPage.shtml?pageId=plus 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: cfreport
Rick, thank you, but unfortuanately this solution is not working.. i have 8.5, maybe this only works for 8.0 thanks Ken -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:16 AM To: CF-Talk Subject: Re: cfreport Don't know if this will help. http://www.macromedia.com/v1/Handlers/index.cfm?ID=16757Method=Full There are undocumented properties of the CFReport Tag. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/17/02 10:02AM Hello all, I am having trouble with the cfreport tag. I'm trying to connect to an oracle db, and I have created a dsn using the crystal reports oracle 8 driver, which is verified as working in the cf administrator. this is what the CF5 docs say: cfreport report = '/reports/monthlysales.rpt' {Departments.Department} = 'International' /cfreport and then on the same page but different they say: cfreport report = report_path orderBy = result_order username = username password = password formula = formula /cfreport when i try this: cfreport report=dailytimesheets.rpt username=cf password=fusion/cfreport it can't find the report, even though the cfm and the rpt files are in the same directory. when i do this: cfreport report=D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt username=cf password=fusion/cfreport I get the error: Error occurred while processing CFREPORT An unexpected error occurred while using the Crystal Engine. Error number 692 ocurred (Error in File D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt: Invalid export DLL or export format.). My thinking is that the cfdocs are just plain wrong and my syntax is right.. but I must be missing something. All help is appreciated. Ken Beard __ 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: cfreport
More specifically, Crystal now has it's own webserver. So, the best option seems to be to set up the crystal webserver and then run it in a frame. I'm not fond of it because it sidesteps site security. Unless someone out there has a way to integrate it with existing security, I don't think it's a good way to offer your intellectual property over the web. Crystal has it's own security framework that might be sufficient, but I haven't seen a combined framework that passes parameters in a secure manner between CF applications and CR8. Oh, if anyone is successfully doing this, please tell me. I am aware that the class can be accessed using ASP, I'm looking for a Cold Fusion solution. Maybe someone has a COM object for it, or maybe someone has figured out some LDAP tricks to keep within the security framework. And if so, the next step is to move the crystal server to it's own machine and preserve the security. Crystal's web server is a resource hog. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/17/02 10:25AM nevermind... found this on the crystal reports website Unfortunately there is currently no integration with Crystal Reports 8 and the CF report tag. ColdFusion ships with version 5.0 of Crystal Reports and Macromedia has released patches to allow version 6 and version 7 to work with the CF report tag. As this time there is no fix for Crystal Reports 8 to work with ColdFusion. that sucks. Ken -Original Message- From: Ken Beard [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:03 AM To: CF-Talk Subject: cfreport Hello all, I am having trouble with the cfreport tag. I'm trying to connect to an oracle db, and I have created a dsn using the crystal reports oracle 8 driver, which is verified as working in the cf administrator. this is what the CF5 docs say: cfreport report = '/reports/monthlysales.rpt' {Departments.Department} = 'International' /cfreport and then on the same page but different they say: cfreport report = report_path orderBy = result_order username = username password = password formula = formula /cfreport when i try this: cfreport report=dailytimesheets.rpt username=cf password=fusion/cfreport it can't find the report, even though the cfm and the rpt files are in the same directory. when i do this: cfreport report=D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt username=cf password=fusion/cfreport I get the error: Error occurred while processing CFREPORT An unexpected error occurred while using the Crystal Engine. Error number 692 ocurred (Error in File D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt: Invalid export DLL or export format.). My thinking is that the cfdocs are just plain wrong and my syntax is right.. but I must be missing something. All help is appreciated. Ken Beard __ 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: Email Server
You may want to look at university of washington imap/pop server, which I believe is the default for most linux distos. Its really trivial to configure. If you are wanting some cf application to create mail accounts, that will take a little work. By defaults, mail accounts are created from the user accounts in the shadow file. You will need to be very careful if you are going to write something to do this from a web environment. In my opinion Cyrus is a very good imap server that can be set up as a black box and authenicate from a database instead of the shadow file. __ 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
Deleting variables
How do you delete session and user variables? T __ 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: UDFs in a Custom Tag problem
Dooh, I've heard of this but when I tested it on my machine, it worked fine but I'm running the trial mx. I think the problem was that it gets defined twice on the start and end call. I think the solution was to set them as an include but cant test it out since it works anyway on my machine. Keep us posted. DRE -Original Message- From: heirophant mm [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 8:28 AM To: CF-Talk Subject: UDFs in a Custom Tag problem Hello developers, I'm writing a custom tag, and I've written some UDFs to clean up some of the code within the custom tag. Only the custom tag uses these UDFs - they're pretty specialized - so I thought it would be easiest to just put them right inside the template for the custom tag. Here's my general structure: cfif thistag.executionmode EQ start cfscript function IsOperator( value ) { blah blah blah; return something; } /cfscript more code /cfif cfif thistag.executionmode EQ end some output, etc. /cfif I get this error: Routines cannot be declared more than once. The routine IsOperator has been declared twice in different templates. I have found that this error occurs at the very beginning of the end ExecutionMode of the tag. I can't figure out how to stop this error. Any ideas? Thanks Mike Mertsock Alfred University Webteam Outgrown your current e-mail service? Get a 25MB Inbox, POP3 Access, No Ads and No Taglines with LYCOS MAIL PLUS. http://login.mail.lycos.com/brandPage.shtml?pageId=plus FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get 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: Deleting variables
structdelete(), deleteclientvariable() -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:43 AM To: CF-Talk Subject: Deleting variables How do you delete session and user variables? T __ 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: cfreport
Rick, I've done exactly this. I created a VB com wrapper to access the Crystal Object. Right now, I use the wrapper to pass username, password, dbname, servername, and selection formula and then export the report to a PDF (other formats are available, but mostly prove unusable :) ). After the PDF is generated, I serve it to the user via CFContent. It's kind of a convoluted way of doing things, but I didn't care for the crystal reports server either. Marlon - Original Message - From: Rick Walters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 17, 2002 9:38 AM Subject: RE: cfreport More specifically, Crystal now has it's own webserver. So, the best option seems to be to set up the crystal webserver and then run it in a frame. I'm not fond of it because it sidesteps site security. Unless someone out there has a way to integrate it with existing security, I don't think it's a good way to offer your intellectual property over the web. Crystal has it's own security framework that might be sufficient, but I haven't seen a combined framework that passes parameters in a secure manner between CF applications and CR8. Oh, if anyone is successfully doing this, please tell me. I am aware that the class can be accessed using ASP, I'm looking for a Cold Fusion solution. Maybe someone has a COM object for it, or maybe someone has figured out some LDAP tricks to keep within the security framework. And if so, the next step is to move the crystal server to it's own machine and preserve the security. Crystal's web server is a resource hog. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/17/02 10:25AM nevermind... found this on the crystal reports website Unfortunately there is currently no integration with Crystal Reports 8 and the CF report tag. ColdFusion ships with version 5.0 of Crystal Reports and Macromedia has released patches to allow version 6 and version 7 to work with the CF report tag. As this time there is no fix for Crystal Reports 8 to work with ColdFusion. that sucks. Ken -Original Message- From: Ken Beard [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:03 AM To: CF-Talk Subject: cfreport Hello all, I am having trouble with the cfreport tag. I'm trying to connect to an oracle db, and I have created a dsn using the crystal reports oracle 8 driver, which is verified as working in the cf administrator. this is what the CF5 docs say: cfreport report = '/reports/monthlysales.rpt' {Departments.Department} = 'International' /cfreport and then on the same page but different they say: cfreport report = report_path orderBy = result_order username = username password = password formula = formula /cfreport when i try this: cfreport report=dailytimesheets.rpt username=cf password=fusion/cfreport it can't find the report, even though the cfm and the rpt files are in the same directory. when i do this: cfreport report=D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt username=cf password=fusion/cfreport I get the error: Error occurred while processing CFREPORT An unexpected error occurred while using the Crystal Engine. Error number 692 ocurred (Error in File D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt: Invalid export DLL or export format.). My thinking is that the cfdocs are just plain wrong and my syntax is right.. but I must be missing something. All help is appreciated. Ken Beard __ 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: Deleting variables
I would use something like this: Session variables, cfset StructDelete(SESSION,var) Client variables cfset DeleteClientVariable(var) Hope this helps, Yves - Original Message - From: Thane Sherrington [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 17, 2002 11:43 AM Subject: Deleting variables How do you delete session and user variables? T __ 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: cfreport
CFContent.. hey.. that is a good idea. I thought of calling an asp page with CFHTTP the same way but it's mildly detestable to NEED to use ASP. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/17/02 10:54AM Rick, I've done exactly this. I created a VB com wrapper to access the Crystal Object. Right now, I use the wrapper to pass username, password, dbname, servername, and selection formula and then export the report to a PDF (other formats are available, but mostly prove unusable :) ). After the PDF is generated, I serve it to the user via CFContent. It's kind of a convoluted way of doing things, but I didn't care for the crystal reports server either. Marlon - Original Message - From: Rick Walters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 17, 2002 9:38 AM Subject: RE: cfreport More specifically, Crystal now has it's own webserver. So, the best option seems to be to set up the crystal webserver and then run it in a frame. I'm not fond of it because it sidesteps site security. Unless someone out there has a way to integrate it with existing security, I don't think it's a good way to offer your intellectual property over the web. Crystal has it's own security framework that might be sufficient, but I haven't seen a combined framework that passes parameters in a secure manner between CF applications and CR8. Oh, if anyone is successfully doing this, please tell me. I am aware that the class can be accessed using ASP, I'm looking for a Cold Fusion solution. Maybe someone has a COM object for it, or maybe someone has figured out some LDAP tricks to keep within the security framework. And if so, the next step is to move the crystal server to it's own machine and preserve the security. Crystal's web server is a resource hog. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/17/02 10:25AM nevermind... found this on the crystal reports website Unfortunately there is currently no integration with Crystal Reports 8 and the CF report tag. ColdFusion ships with version 5.0 of Crystal Reports and Macromedia has released patches to allow version 6 and version 7 to work with the CF report tag. As this time there is no fix for Crystal Reports 8 to work with ColdFusion. that sucks. Ken -Original Message- From: Ken Beard [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:03 AM To: CF-Talk Subject: cfreport Hello all, I am having trouble with the cfreport tag. I'm trying to connect to an oracle db, and I have created a dsn using the crystal reports oracle 8 driver, which is verified as working in the cf administrator. this is what the CF5 docs say: cfreport report = '/reports/monthlysales.rpt' {Departments.Department} = 'International' /cfreport and then on the same page but different they say: cfreport report = report_path orderBy = result_order username = username password = password formula = formula /cfreport when i try this: cfreport report=dailytimesheets.rpt username=cf password=fusion/cfreport it can't find the report, even though the cfm and the rpt files are in the same directory. when i do this: cfreport report=D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt username=cf password=fusion/cfreport I get the error: Error occurred while processing CFREPORT An unexpected error occurred while using the Crystal Engine. Error number 692 ocurred (Error in File D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt: Invalid export DLL or export format.). My thinking is that the cfdocs are just plain wrong and my syntax is right.. but I must be missing something. All help is appreciated. Ken Beard __ 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: Anybody have a nice CFERROR page for me?
Here is what I use: In the Application.cfm: !--- Turn on error handling and turn off debugging code for users --- cfif REQUEST.mode IS normal !--- Error handling --- cferror type=exception template=error.cfm mailto=[EMAIL PROTECTED] cfsetting showdebugoutput=no /cfif !--- error.cfm CONTENTS --- cfoutput h1We apologize!/h1p You've encountered an error. form action=error_submit.cfm method=post table border=0 cellpadding=0 cellspacing=0 tr td valign=topYour Email:/td tdimg src=/images/spacer.gif height=1 width=10 border=0/td td valign=topinput type=text name=emailfrom size=20/td /tr tr td valign=topDescribe what you were trying to do:/td tdimg src=/images/spacer.gif height=1 width=10 border=0/td td valign=toptextarea name=description cols=30 rows=4 wrap=virtual/textarea/td /tr tr tdNotify you when fixed?:/td tdimg src=/images/spacer.gif height=1 width=10 border=0/td td valign=topinput type=radio value=yes name=notify checkedYes input type=radio name=notify value=noNo/td /tr tr tdimg src=/images/spacer.gif height=10 width=10 border=0/td /tr tr td colspan=3 input type=hidden name=diagnostics value=#HTMLEditFormat(error.diagnostics)# input type=hidden name=dateTime value=#error.dateTime# input type=hidden name=browser value=#error.browser# input type=hidden name=template value=#error.template# input type=hidden name=remoteAddress value=#error.remoteAddress# input type=submit name=formSubmit value=Notify Webmaster /td /tr /table /form /cfoutput - Note that I allow the user to choose whether or not to submit the error. This does a pretty good job of preventing multiple notifications for the same error. (The average user will try the page again, and choose not to re-submit the error.) !--- error_submit.cfm CONTENTS --- cfif isDefined(FORM.formSubmit) cfmail [EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=ERROR on yourdomain DATE: #FORM.dateTime# EMAIL: #FORM.emailFrom# NOTIFY: #FORM.notify# DESCRIPTION: #FORM.description# TEMPLATE: #FORM.template# DIAGNOSTICS: #FORM.diagnostics# BROWSER: #FORM.browser# REMOTE ADDRESS: #FORM.remoteAddress# /cfmail /cfif /cfsilent h1Thank You/h1p Your help is appreciated. HTH! Sharon - Original Message - From: Jon Block [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 12:48 PM Subject: Anybody have a nice CFERROR page for me? Anybody have a really nice CFERROR page that mails the site administrator all of the error information plus a listing of the variables and database queries etc? Thanks... __ 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: cfreport
Marlon, Any chance you'd share that? Ken -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:55 AM To: CF-Talk Subject: Re: cfreport Rick, I've done exactly this. I created a VB com wrapper to access the Crystal Object. Right now, I use the wrapper to pass username, password, dbname, servername, and selection formula and then export the report to a PDF (other formats are available, but mostly prove unusable :) ). After the PDF is generated, I serve it to the user via CFContent. It's kind of a convoluted way of doing things, but I didn't care for the crystal reports server either. Marlon - Original Message - From: Rick Walters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 17, 2002 9:38 AM Subject: RE: cfreport More specifically, Crystal now has it's own webserver. So, the best option seems to be to set up the crystal webserver and then run it in a frame. I'm not fond of it because it sidesteps site security. Unless someone out there has a way to integrate it with existing security, I don't think it's a good way to offer your intellectual property over the web. Crystal has it's own security framework that might be sufficient, but I haven't seen a combined framework that passes parameters in a secure manner between CF applications and CR8. Oh, if anyone is successfully doing this, please tell me. I am aware that the class can be accessed using ASP, I'm looking for a Cold Fusion solution. Maybe someone has a COM object for it, or maybe someone has figured out some LDAP tricks to keep within the security framework. And if so, the next step is to move the crystal server to it's own machine and preserve the security. Crystal's web server is a resource hog. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/17/02 10:25AM nevermind... found this on the crystal reports website Unfortunately there is currently no integration with Crystal Reports 8 and the CF report tag. ColdFusion ships with version 5.0 of Crystal Reports and Macromedia has released patches to allow version 6 and version 7 to work with the CF report tag. As this time there is no fix for Crystal Reports 8 to work with ColdFusion. that sucks. Ken -Original Message- From: Ken Beard [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:03 AM To: CF-Talk Subject: cfreport Hello all, I am having trouble with the cfreport tag. I'm trying to connect to an oracle db, and I have created a dsn using the crystal reports oracle 8 driver, which is verified as working in the cf administrator. this is what the CF5 docs say: cfreport report = '/reports/monthlysales.rpt' {Departments.Department} = 'International' /cfreport and then on the same page but different they say: cfreport report = report_path orderBy = result_order username = username password = password formula = formula /cfreport when i try this: cfreport report=dailytimesheets.rpt username=cf password=fusion/cfreport it can't find the report, even though the cfm and the rpt files are in the same directory. when i do this: cfreport report=D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt username=cf password=fusion/cfreport I get the error: Error occurred while processing CFREPORT An unexpected error occurred while using the Crystal Engine. Error number 692 ocurred (Error in File D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt: Invalid export DLL or export format.). My thinking is that the cfdocs are just plain wrong and my syntax is right.. but I must be missing something. All help is appreciated. Ken Beard __ 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: cfreport
Sure, but I'm off work today so I can't get to the source right now, and since there's no documentation, you'd probably want that too :-) Does this list support attachments? Ken Beard wrote: Marlon, Any chance you'd share that? Ken -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:55 AM To: CF-Talk Subject: Re: cfreport Rick, I've done exactly this. I created a VB com wrapper to access the Crystal Object. Right now, I use the wrapper to pass username, password, dbname, servername, and selection formula and then export the report to a PDF (other formats are available, but mostly prove unusable :) ). After the PDF is generated, I serve it to the user via CFContent. It's kind of a convoluted way of doing things, but I didn't care for the crystal reports server either. Marlon - Original Message - From: Rick Walters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 17, 2002 9:38 AM Subject: RE: cfreport More specifically, Crystal now has it's own webserver. So, the best option seems to be to set up the crystal webserver and then run it in a frame. I'm not fond of it because it sidesteps site security. Unless someone out there has a way to integrate it with existing security, I don't think it's a good way to offer your intellectual property over the web. Crystal has it's own security framework that might be sufficient, but I haven't seen a combined framework that passes parameters in a secure manner between CF applications and CR8. Oh, if anyone is successfully doing this, please tell me. I am aware that the class can be accessed using ASP, I'm looking for a Cold Fusion solution. Maybe someone has a COM object for it, or maybe someone has figured out some LDAP tricks to keep within the security framework. And if so, the next step is to move the crystal server to it's own machine and preserve the security. Crystal's web server is a resource hog. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/17/02 10:25AM nevermind... found this on the crystal reports website Unfortunately there is currently no integration with Crystal Reports 8 and the CF report tag. ColdFusion ships with version 5.0 of Crystal Reports and Macromedia has released patches to allow version 6 and version 7 to work with the CF report tag. As this time there is no fix for Crystal Reports 8 to work with ColdFusion. that sucks. Ken -Original Message- From: Ken Beard [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:03 AM To: CF-Talk Subject: cfreport Hello all, I am having trouble with the cfreport tag. I'm trying to connect to an oracle db, and I have created a dsn using the crystal reports oracle 8 driver, which is verified as working in the cf administrator. this is what the CF5 docs say: cfreport report = '/reports/monthlysales.rpt' {Departments.Department} = 'International' /cfreport and then on the same page but different they say: cfreport report = report_path orderBy = result_order username = username password = password formula = formula /cfreport when i try this: cfreport report=dailytimesheets.rpt username=cf password=fusion/cfreport it can't find the report, even though the cfm and the rpt files are in the same directory. when i do this: cfreport report=D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt username=cf password=fusion/cfreport I get the error: Error occurred while processing CFREPORT An unexpected error occurred while using the Crystal Engine. Error number 692 ocurred (Error in File D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt: Invalid export DLL or export format.). My thinking is that the cfdocs are just plain wrong and my syntax is right.. but I must be missing something. All help is appreciated. Ken Beard __ 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: cfreport
I'm skeptical that list supports attachements, but if you're willing, I'd love a copy. Copy me. :) Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/17/02 11:11AM Sure, but I'm off work today so I can't get to the source right now, and since there's no documentation, you'd probably want that too :-) Does this list support attachments? Ken Beard wrote: Marlon, Any chance you'd share that? Ken -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:55 AM To: CF-Talk Subject: Re: cfreport Rick, I've done exactly this. I created a VB com wrapper to access the Crystal Object. Right now, I use the wrapper to pass username, password, dbname, servername, and selection formula and then export the report to a PDF (other formats are available, but mostly prove unusable :) ). After the PDF is generated, I serve it to the user via CFContent. It's kind of a convoluted way of doing things, but I didn't care for the crystal reports server either. Marlon - Original Message - From: Rick Walters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 17, 2002 9:38 AM Subject: RE: cfreport More specifically, Crystal now has it's own webserver. So, the best option seems to be to set up the crystal webserver and then run it in a frame. I'm not fond of it because it sidesteps site security. Unless someone out there has a way to integrate it with existing security, I don't think it's a good way to offer your intellectual property over the web. Crystal has it's own security framework that might be sufficient, but I haven't seen a combined framework that passes parameters in a secure manner between CF applications and CR8. Oh, if anyone is successfully doing this, please tell me. I am aware that the class can be accessed using ASP, I'm looking for a Cold Fusion solution. Maybe someone has a COM object for it, or maybe someone has figured out some LDAP tricks to keep within the security framework. And if so, the next step is to move the crystal server to it's own machine and preserve the security. Crystal's web server is a resource hog. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/17/02 10:25AM nevermind... found this on the crystal reports website Unfortunately there is currently no integration with Crystal Reports 8 and the CF report tag. ColdFusion ships with version 5.0 of Crystal Reports and Macromedia has released patches to allow version 6 and version 7 to work with the CF report tag. As this time there is no fix for Crystal Reports 8 to work with ColdFusion. that sucks. Ken -Original Message- From: Ken Beard [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:03 AM To: CF-Talk Subject: cfreport Hello all, I am having trouble with the cfreport tag. I'm trying to connect to an oracle db, and I have created a dsn using the crystal reports oracle 8 driver, which is verified as working in the cf administrator. this is what the CF5 docs say: cfreport report = '/reports/monthlysales.rpt' {Departments.Department} = 'International' /cfreport and then on the same page but different they say: cfreport report = report_path orderBy = result_order username = username password = password formula = formula /cfreport when i try this: cfreport report=dailytimesheets.rpt username=cf password=fusion/cfreport it can't find the report, even though the cfm and the rpt files are in the same directory. when i do this: cfreport report=D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt username=cf password=fusion/cfreport I get the error: Error occurred while processing CFREPORT An unexpected error occurred while using the Crystal Engine. Error number 692 ocurred (Error in File D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt: Invalid export DLL or export format.). My thinking is that the cfdocs are just plain wrong and my syntax is right.. but I must be missing something. All help is appreciated. Ken Beard __ 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: cfreport
Marlon, i'm pretty sure it doesn't support attachments. I'll be happy to wait until you return to work, thanks a bunch. Ken -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 11:11 AM To: CF-Talk Subject: Re: cfreport Sure, but I'm off work today so I can't get to the source right now, and since there's no documentation, you'd probably want that too :-) Does this list support attachments? Ken Beard wrote: Marlon, Any chance you'd share that? Ken -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:55 AM To: CF-Talk Subject: Re: cfreport Rick, I've done exactly this. I created a VB com wrapper to access the Crystal Object. Right now, I use the wrapper to pass username, password, dbname, servername, and selection formula and then export the report to a PDF (other formats are available, but mostly prove unusable :) ). After the PDF is generated, I serve it to the user via CFContent. It's kind of a convoluted way of doing things, but I didn't care for the crystal reports server either. Marlon - Original Message - From: Rick Walters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 17, 2002 9:38 AM Subject: RE: cfreport More specifically, Crystal now has it's own webserver. So, the best option seems to be to set up the crystal webserver and then run it in a frame. I'm not fond of it because it sidesteps site security. Unless someone out there has a way to integrate it with existing security, I don't think it's a good way to offer your intellectual property over the web. Crystal has it's own security framework that might be sufficient, but I haven't seen a combined framework that passes parameters in a secure manner between CF applications and CR8. Oh, if anyone is successfully doing this, please tell me. I am aware that the class can be accessed using ASP, I'm looking for a Cold Fusion solution. Maybe someone has a COM object for it, or maybe someone has figured out some LDAP tricks to keep within the security framework. And if so, the next step is to move the crystal server to it's own machine and preserve the security. Crystal's web server is a resource hog. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/17/02 10:25AM nevermind... found this on the crystal reports website Unfortunately there is currently no integration with Crystal Reports 8 and the CF report tag. ColdFusion ships with version 5.0 of Crystal Reports and Macromedia has released patches to allow version 6 and version 7 to work with the CF report tag. As this time there is no fix for Crystal Reports 8 to work with ColdFusion. that sucks. Ken -Original Message- From: Ken Beard [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:03 AM To: CF-Talk Subject: cfreport Hello all, I am having trouble with the cfreport tag. I'm trying to connect to an oracle db, and I have created a dsn using the crystal reports oracle 8 driver, which is verified as working in the cf administrator. this is what the CF5 docs say: cfreport report = '/reports/monthlysales.rpt' {Departments.Department} = 'International' /cfreport and then on the same page but different they say: cfreport report = report_path orderBy = result_order username = username password = password formula = formula /cfreport when i try this: cfreport report=dailytimesheets.rpt username=cf password=fusion/cfreport it can't find the report, even though the cfm and the rpt files are in the same directory. when i do this: cfreport report=D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt username=cf password=fusion/cfreport I get the error: Error occurred while processing CFREPORT An unexpected error occurred while using the Crystal Engine. Error number 692 ocurred (Error in File D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt: Invalid export DLL or export format.). My thinking is that the cfdocs are just plain wrong and my syntax is right.. but I must be missing something. All help is appreciated. Ken Beard __ 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: CFINTERNALDEBUG
Thanks for the tip! Anyone else know what the other actions do, or how to use them? Happy Programming! -- 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: Alistair Davidson [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 5:10 AM To: CF-Talk Subject: RE: CFINTERNALDEBUG Hi Scott I know that the PCODE action is used to recompile a CF template into PCode without executing it - very handy for refreshing a file in the template cache when Trusted Cache is on. You can use it like this: CFINTERNALDEBUG ACTION=pcode OUTVAR=r_var TEMPLATEPATH=#template# Although you have to do a little registry tweaking first - !--- if Trusted Cache is enabled --- CFREGISTRY ACTION=Get BRANCH=HKEY_LOCAL_MACHINE\Software\Allaire\ColdFusion\Current Version\Server ENTRY=AssumeTemplateCacheIsNotDirty TYPE=String VARIABLE=r_value cfif r_value neq 1 !--- update the CF trusted cache setting to 0 --- CFREGISTRY ACTION=Set BRANCH=HKEY_LOCAL_MACHINE\Software\Allaire\ColdFusion\Current Version\Server ENTRY=AssumeTemplateCacheIsNotDirty TYPE=String VALUE=0 !--- have CF reread the registry --- cfset temp = CFUSION_SETTINGS_REFRESH() !--- Refresh the template --- CFINTERNALDEBUG ACTION=pcode OUTVAR=r_var TEMPLATEPATH=#template# !--- turn truested cache back on --- CFREGISTRY ACTION=Set BRANCH=HKEY_LOCAL_MACHINE\Software\Allaire\ColdFusion\Current Version\Server ENTRY=AssumeTemplateCacheIsNotDirty TYPE=String VALUE=1 !--- have CF reread the registry --- cfset temp = CFUSION_SETTINGS_REFRESH() /cfif As this tag is undocumented and unsupported, I've no idea of how safe it is to do this. I've never had any problems doing it, but it's probably worth putting a cflock scope=server around it. HTH Alistair Alistair Davidson Application Developer Freeserve.com PLC www.smartgroups.com -Original Message- From: Boardworks Interactive [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 07:09 To: CF-Talk Subject: CFINTERNALDEBUG Does anyone know what this tag does? I was able to deduce that it had an attribute, ACTION which could be either BREAK, LEAK, PCODE, REPORTSTATE, SETBREAKALLOC and WRITEOUTPUT. Each ACTION has its own attributes, but I don't know what each of these actions does - morever what it outputs (as I would like to view it). I understand the MM doesn't support this tag, but I was wondering if any of you smart folks figured it out. TIA! SCOTT VAN VLIET BRD.WRKS INTERACTIVE T: 714.469.6805 E: [EMAIL PROTECTED] __ 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
Ways of securing email?
I need to implement a secure email solution, and I know of 2 or 3 ways to do it. S/MIME POP3 over SSL PGP Are their any others that are worth looking into? jon __ 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
Scripting an action using the Excel object (Was: cf_HTML2Excel Question)
Okay, made some progress on this and now have a better understanding of what I need to do. cf_HTML2Excel connects to the Excel COM object which is great, but now I need to figure out how to translate this: Cells.Replace What:=, Replacement:=', LookAt:=xlPart, SearchOrder _ :=xlByRows, MatchCase:=False to run in the cfscript that is interacting with the COM object. I've tried a variety of things but I'm not sure how to proceed. I don't think I can save a macro since the workbook will constantly be changing. Any thoughts or ideas? Thanks! Hatton Hatton Humphrey wrote: Does anyone have any expeirence with this tag? I have it working almost to where I need it but I'm running into an odd problem. I have a field that is coming in from a SQL Server VarChar with '00' as the value in the field. It is being output to the HTML as 00 in the table but for some reason the excel file is translating it as a numeric value and saving a single 0 in the file. The problem is that it's *supposed* to be a numeric value, so now I guess the question is how to I force the tag (or more to the point, Excel) to save the numbers as characters? TIA! Hatton __ 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
Strange SQL error
In all my time developing SQL I have never come across sommat like this - please someone tell me I'm being stoopid as it's a Fri afternoon. I have the following SP which refuses to release - it says it cannot find parameter JuryTitle. If I comment out JuryTitle and the corresponding field insert it works. If I change the name of the variable it doesn'tsomeone slap me with a kipper so I can see where I've gone wrong... CREATE PROCEDURE JuryInsert -- Any parameters here CountryID int , JuryName varchar(100) , JuryTitle varchar(50) , JuryCompanyvarchar(50) , JuryCity varchar(50) , JuryTypeID int AS BEGIN INSERT INTO tblJury ( CountryID , JuryName , JuryTitle , JuryCompany , JuryCity , JuryTypeID ) VALUES ( CountryID , JuryName , test , JuryCompany , JuryCity , JuryTypeID ) IF error 0 BEGIN GOTO ERROR_EXIT END RETURN error ERROR_EXIT: RETURN error END GO -- Andy Ewings Director Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.net Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. __ 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: What is this SQL Error?
I'm trying to figure out if ColdFusion locks the whole table when running a cfquery. I'm getting those deadlock errors in production, where too many people access the same table at the same time. It never happens in the development environment or in the testing environment. But the thing is, I get deadlocks with insert queries! Something simple as insert into sometable (col1, col2, col3) values ('val1','val2','val3') This tells me that the lock is not done on a row level, but on the table level. I'm using MSSQL 7, and the DBA assures me that it would lock at row level, so I'm guessing ColdFusion is requesting a lock at table level somewhere. Is there a CFAdmin setting for this? -Original Message- From: Houk, Gary [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 3:06 PM To: CF-Talk Subject: What is this SQL Error? First time I've seen this one...what does it mean? Diagnostics: ODBC Error Code = 40001 (Serialization failure) [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 60) was deadlocked on {lock} resources with another process and has been chosen as the deadlock victim. Rerun the transaction. __ 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: Strange SQL error
I assume in this bit: VALUES ( @CountryID , @JuryName , @test , @JuryCompany , @JuryCity , @JuryTypeID you're actually using VALUES ( @CountryID , @JuryName , @JuryTitle , @JuryCompany , @JuryCity , @JuryTypeID ? -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 16:56 To: CF-Talk Subject: Strange SQL error In all my time developing SQL I have never come across sommat like this - please someone tell me I'm being stoopid as it's a Fri afternoon. I have the following SP which refuses to release - it says it cannot find parameter @JuryTitle. If I comment out @JuryTitle and the corresponding field insert it works. If I change the name of the variable it doesn'tsomeone slap me with a kipper so I can see where I've gone wrong... CREATE PROCEDURE JuryInsert -- Any parameters here @CountryID int , @JuryName varchar(100) , @JuryTitle varchar(50) , @JuryCompanyvarchar(50) , @JuryCity varchar(50) , @JuryTypeID int AS BEGIN INSERT INTO tblJury ( CountryID , JuryName , JuryTitle , JuryCompany , JuryCity , JuryTypeID ) VALUES ( @CountryID , @JuryName , @test , @JuryCompany , @JuryCity , @JuryTypeID ) IF @@error 0 BEGIN GOTO ERROR_EXIT END RETURN @@error ERROR_EXIT: RETURN @@error END GO -- Andy Ewings Director Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.net Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. __ 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: Strange SQL error
ah - yes sorry - forgot to change it back -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 16:50 To: CF-Talk Subject: RE: Strange SQL error I assume in this bit: VALUES ( @CountryID , @JuryName , @test , @JuryCompany , @JuryCity , @JuryTypeID you're actually using VALUES ( @CountryID , @JuryName , @JuryTitle , @JuryCompany , @JuryCity , @JuryTypeID ? -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 16:56 To: CF-Talk Subject: Strange SQL error In all my time developing SQL I have never come across sommat like this - please someone tell me I'm being stoopid as it's a Fri afternoon. I have the following SP which refuses to release - it says it cannot find parameter @JuryTitle. If I comment out @JuryTitle and the corresponding field insert it works. If I change the name of the variable it doesn'tsomeone slap me with a kipper so I can see where I've gone wrong... CREATE PROCEDURE JuryInsert -- Any parameters here @CountryID int , @JuryName varchar(100) , @JuryTitle varchar(50) , @JuryCompanyvarchar(50) , @JuryCity varchar(50) , @JuryTypeID int AS BEGIN INSERT INTO tblJury ( CountryID , JuryName , JuryTitle , JuryCompany , JuryCity , JuryTypeID ) VALUES ( @CountryID , @JuryName , @test , @JuryCompany , @JuryCity , @JuryTypeID ) IF @@error 0 BEGIN GOTO ERROR_EXIT END RETURN @@error ERROR_EXIT: RETURN @@error END GO -- Andy Ewings Director Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.net Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. __ 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: CFS5 CFMX VTM updater soon available from Macromedia
HUGE SMILES Thanks all around MM for listening to our whines and wants! - Erika L. Walker-Arnold, VP, RUWebby, LLC - Macromedia ColdFusion Alliance Partner Macromedia ColdFusion 5.0 Certified Developer - | -Original Message- | From: Vernon Viehe [mailto:[EMAIL PROTECTED]] | Sent: 17 May 2002 15:14 | To: CF-Talk | Subject: CFS5 CFMX VTM updater soon available from Macromedia | | | Hi All! | | I found out late last night that we've made an updater for | the CFMX VTMs for CFStudio 5. This will be available for | download very soon - it's in que to be posted by our | webteam. It's my understanding that this updater will be | linked from a HS+/CFS FAQ, and I'll send that link as soon | as I have it. | | *smiles everyone, smiles!* | | Vernon Viehe | Community Manager | Macromedia, Inc. | | Macromedia Certified Professional | http://vvmx.blogspot.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
TIP: Checking to see if dynamic variable exists
Hopefully this is useful to some newbies (including myself). Lets say Forms are dynamically created and named on a page..(ex. Form.var_1, Form.var_2, etc.) Lets also say that one of those forms is a checkbox or radio, and they don't have to be checked or clicked...which means that the variable won't exist, (unlike text fields, where the formfield variable will exist even if left blank) So in order to do something with the information passed to the next page, you have to call it by its variablebut you might run into a problem if that variable never existed in the first place. Secondly, you don't know the name of that variable, since it was dynamically created! this is the basic way to check for it... CFIF isdefined(form.var_index) Let's say there are 4 form fields, but only 3 form variables were passed. Form.var_1, form.var_2, and form.var_4 You would put that check inside a loop CFLOOP index=index from=1 to=4 CFIF isdefined(form.var_index) DO and perform stuff /CFIF /CFLOOP thats how ya do it. Although this might not seem like much, you can created a new experience and different way to do things with your web apps! __ 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: What is this SQL Error?
If you're getting a deadlock error, chances are that it has to do with the order that your queries are going. If you have one page with a transaction that starts with an insert to Table A and then updates all the rows in Table B while you have another page with a transaction that inserts into Table B and then updates all the rows in Table A you can have a deadlock. Example: Page 1 BEGIN TRANSACTION INSERT INTO TableA (field1,field2) VALUES ('value1', 'value2') UPDATE TableB SET field1 = 5 COMMIT TRANSACTION Page 2 BEGIN TRANSACTION INSERT INTO TableB (field1,field2) VALUES ('value1', 'value2') UPDATE TableA SET field1 = 5 COMMIT TRANSACTION If both pages run at the same time, page 1 will lock TableA and page 2 will lock TableB. Neither can let go of the lock until the transaction is complete, but they can't get to other table they need until the other page releases its lock. The idea is to put all your tables into the same order so if page 1 works on TableA and then TableB, then page 2 should work on TableA and then TableB as well -- not in reverse order. Does that help? Ben Johnson Hostworks, Inc. __ 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: What is this SQL Error?
I'm trying to figure out if ColdFusion locks the whole table when running a cfquery. This is entirely dependent on the database. CF is just a regular database client, like any other database client. I'm getting those deadlock errors in production, where too many people access the same table at the same time. It never happens in the development environment or in the testing environment. This makes sense, since you're less likely to have collisions with fewer users. But the thing is, I get deadlocks with insert queries! Something simple as insert into sometable (col1, col2, col3) values ('val1','val2','val3') This tells me that the lock is not done on a row level, but on the table level. I'm using MSSQL 7, and the DBA assures me that it would lock at row level, so I'm guessing ColdFusion is requesting a lock at table level somewhere. Is there a CFAdmin setting for this? No, as mentioned above, this isn't specific to CF; there's no CF Admin setting for this. However, I wouldn't be so sure that locking is being done on a row level. If I recall correctly, that's not the default behavior for SQL Server 7. I think that SQL Server 7 locks pages (an internal storage unit) rather than locking individual rows or locking the whole table. Now, here's a problem. You may have several rows within a single page. Also, if you're using an identity column as a primary key, and you've defined a clustered index on that column, each insert will be physically located right after the previous insert. So, if you have one page with one row being inserted, and that page gets locked, and the database wants to write the next row to the same page due to the clustered index (which by definition matches the physical sort order of the column) that second write may be delayed, and if the database is busy enough, that may cause problems. I've heard that problem called a hotspot before. For a solution to this problem, I'm not sure what route would be best to take, in your situation. However, I'm not certain that this, by itself, is the problem you're having; typically, I think that this problem simply causes things to get significantly slower. A deadlock, on the other hand, implies that you have two transactions occurring, and neither can complete until the other has finished. So, the question for you is, are you doing anything else besides the insert here? Are you using CFTRANSACTION or transactional logic within your query/stored procedure also? On the other hand, for all I know, if the hotspot issue gets bad enough, maybe that will return a deadlock error! Your DBA should be able to help determine what's going on at the database level, I hope. 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: Problem with cfhttp
Ben, I ran into the same thing with MX's cfhttp, but I was trying to get slashdot.org's xml feed. So we know it's not just the xml feed at MM. It seems to stop on any given character but it quits about the same place every time. Local calls to xml files seem to work finesounds like the culprit is cfhttp. Ryan Kime -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 2:54 PM To: CF-Talk Subject: Problem with cfhttp Hi all, I was wondering if anyone has experienced this problem with cfhttp in CFMX? I haven't tried it in CF5 so not sure if it's happening there too, but I am using cfhttp to get the xml feed off of MM's site. I run the page that grabs the xml file to get it to my local machine but for some reason it only gets ¾ of the page. So I keep getting an error that there isn't a root node because there isn't a closing tag for the root. Anyone have any ideas what might cause this? Thanks, Ben __ 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: Strange SQL error
Right fixed it - all we did was to move the declaration of the JuryTitle param to the bottom of the list and itr works! SQL schmeequel -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 16:50 To: CF-Talk Subject: RE: Strange SQL error I assume in this bit: VALUES ( @CountryID , @JuryName , @test , @JuryCompany , @JuryCity , @JuryTypeID you're actually using VALUES ( @CountryID , @JuryName , @JuryTitle , @JuryCompany , @JuryCity , @JuryTypeID ? -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 16:56 To: CF-Talk Subject: Strange SQL error In all my time developing SQL I have never come across sommat like this - please someone tell me I'm being stoopid as it's a Fri afternoon. I have the following SP which refuses to release - it says it cannot find parameter @JuryTitle. If I comment out @JuryTitle and the corresponding field insert it works. If I change the name of the variable it doesn'tsomeone slap me with a kipper so I can see where I've gone wrong... CREATE PROCEDURE JuryInsert -- Any parameters here @CountryID int , @JuryName varchar(100) , @JuryTitle varchar(50) , @JuryCompanyvarchar(50) , @JuryCity varchar(50) , @JuryTypeID int AS BEGIN INSERT INTO tblJury ( CountryID , JuryName , JuryTitle , JuryCompany , JuryCity , JuryTypeID ) VALUES ( @CountryID , @JuryName , @test , @JuryCompany , @JuryCity , @JuryTypeID ) IF @@error 0 BEGIN GOTO ERROR_EXIT END RETURN @@error ERROR_EXIT: RETURN @@error END GO -- Andy Ewings Director Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.net Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. __ 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: Strange SQL error
uh? -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 17:18 To: CF-Talk Subject: RE: Strange SQL error Right fixed it - all we did was to move the declaration of the JuryTitle param to the bottom of the list and itr works! SQL schmeequel -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 16:50 To: CF-Talk Subject: RE: Strange SQL error I assume in this bit: VALUES ( @CountryID , @JuryName , @test , @JuryCompany , @JuryCity , @JuryTypeID you're actually using VALUES ( @CountryID , @JuryName , @JuryTitle , @JuryCompany , @JuryCity , @JuryTypeID ? -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 16:56 To: CF-Talk Subject: Strange SQL error In all my time developing SQL I have never come across sommat like this - please someone tell me I'm being stoopid as it's a Fri afternoon. I have the following SP which refuses to release - it says it cannot find parameter @JuryTitle. If I comment out @JuryTitle and the corresponding field insert it works. If I change the name of the variable it doesn'tsomeone slap me with a kipper so I can see where I've gone wrong... CREATE PROCEDURE JuryInsert -- Any parameters here @CountryID int , @JuryName varchar(100) , @JuryTitle varchar(50) , @JuryCompanyvarchar(50) , @JuryCity varchar(50) , @JuryTypeID int AS BEGIN INSERT INTO tblJury ( CountryID , JuryName , JuryTitle , JuryCompany , JuryCity , JuryTypeID ) VALUES ( @CountryID , @JuryName , @test , @JuryCompany , @JuryCity , @JuryTypeID ) IF @@error 0 BEGIN GOTO ERROR_EXIT END RETURN @@error ERROR_EXIT: RETURN @@error END GO -- Andy Ewings Director Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.net Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. __ 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: banner program
Hell, I built a really basic random rotator (uses a list of ad/url values in application.cfm and displays random ads) in about 30 minutes, let me know if you want it. Pete - Original Message - From: Joe Hansen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 17, 2002 9:45 AM Subject: banner program I am looking for a CF based banner ad program. I have looked at all the banner ad programs on the MM developer exchange. Anyone have any comments/recommendations/experiences? 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
False template file ... encrypted and its data has been corrupte d error
I got the error below. I wrote my file in DW4, edited it in CF Studio 4, saved and tested it on an IIS server. When I uploaded it to an HP/UX box running apache I got the error below. I opened up VI, edited the file, everything looks normal, completely normal, and even saved the file. I went through the upload, test, check, test, edit, test scenario twice with the same file, a couple different times with other files. At all times, I get the error below. The files are not encrypted nor are they corrupted. I believe there was a problem with the installation, but I can't figure out what that problem was. I do not have much UNIX experience, but I've been working with CF on windows since 1996. Has anyone run across this error before? Someone has to have seen this before... Thanks, Don Error Diagnostic Information Cannot load template file //newtest3.cfm The template file exists, however, it either cannot be opened for reading, or it is encrypted and its data has been corrupted Date/Time: Fri May 17 09:08:17 2002 Browser: Mozilla/4.79 [en] (Windows NT 5.0; U) Remote Address: 0.0.0.0 HTTP Referer: [unknown origin] __ 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: Problem with cfhttp
Thanks for the info Ryan, I wonder if this should be reported as a bug, if it hasn't been all ready. Ben -Original Message- From: Ryan Kime [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:11 PM To: CF-Talk Subject: RE: Problem with cfhttp Ben, I ran into the same thing with MX's cfhttp, but I was trying to get slashdot.org's xml feed. So we know it's not just the xml feed at MM. It seems to stop on any given character but it quits about the same place every time. Local calls to xml files seem to work finesounds like the culprit is cfhttp. Ryan Kime -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 2:54 PM To: CF-Talk Subject: Problem with cfhttp Hi all, I was wondering if anyone has experienced this problem with cfhttp in CFMX? I haven't tried it in CF5 so not sure if it's happening there too, but I am using cfhttp to get the xml feed off of MM's site. I run the page that grabs the xml file to get it to my local machine but for some reason it only gets ¾ of the page. So I keep getting an error that there isn't a root node because there isn't a closing tag for the root. Anyone have any ideas what might cause this? Thanks, Ben __ 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: Strange SQL error
What Andy meant was that he moved the @JuryTitle param to the bottom of the list like so: -- Any parameters here @CountryID int , @JuryName varchar(100) , @JuryCompanyvarchar(50) , @JuryCity varchar(50) , @JuryTypeID int , @JuryTitle varchar(50) @JuryTitle was originally declared after the second param @JuryName. For some reason the SP then released perfectly. Bizarrely I then moved the @JuryTitle param back to where it was and then the SP relases again. For the last 2 hours the SP would not release and we are at a loss as to why it didn't work. Any Ideas SQL gurus what may have happened? -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 17:10 To: CF-Talk Subject: RE: Strange SQL error uh? -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 17:18 To: CF-Talk Subject: RE: Strange SQL error Right fixed it - all we did was to move the declaration of the JuryTitle param to the bottom of the list and itr works! SQL schmeequel -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 16:50 To: CF-Talk Subject: RE: Strange SQL error I assume in this bit: VALUES ( @CountryID , @JuryName , @test , @JuryCompany , @JuryCity , @JuryTypeID you're actually using VALUES ( @CountryID , @JuryName , @JuryTitle , @JuryCompany , @JuryCity , @JuryTypeID ? -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 16:56 To: CF-Talk Subject: Strange SQL error In all my time developing SQL I have never come across sommat like this - please someone tell me I'm being stoopid as it's a Fri afternoon. I have the following SP which refuses to release - it says it cannot find parameter @JuryTitle. If I comment out @JuryTitle and the corresponding field insert it works. If I change the name of the variable it doesn'tsomeone slap me with a kipper so I can see where I've gone wrong... CREATE PROCEDURE JuryInsert -- Any parameters here @CountryID int , @JuryName varchar(100) , @JuryTitle varchar(50) , @JuryCompanyvarchar(50) , @JuryCity varchar(50) , @JuryTypeID int AS BEGIN INSERT INTO tblJury ( CountryID , JuryName , JuryTitle , JuryCompany , JuryCity , JuryTypeID ) VALUES ( @CountryID , @JuryName , @test , @JuryCompany , @JuryCity , @JuryTypeID ) IF @@error 0 BEGIN GOTO ERROR_EXIT END RETURN @@error ERROR_EXIT: RETURN @@error END GO -- Andy Ewings Director Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.net Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. __ 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: What is this SQL Error?
Thanks, I'll discuss that with our DBA. I'm not using any CFTRANSACTION, though. What might have an impact here is that this is a code that loops up to four times and does an insert every time. The user selects up to four items, and then the code loops through them and inserts a record in the table in each iteration. It's simple as cfif listlen(selectedItems) cfloop list=#selectedItems# index=thisSelectedItem cfquery name=insertItem database=someDatabase insert into someTable (col1,col2) values (#thisUser#,#thisSelectedItem#) /cfquery /cfloop /cfif -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:19 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: What is this SQL Error? I'm trying to figure out if ColdFusion locks the whole table when running a cfquery. This is entirely dependent on the database. CF is just a regular database client, like any other database client. I'm getting those deadlock errors in production, where too many people access the same table at the same time. It never happens in the development environment or in the testing environment. This makes sense, since you're less likely to have collisions with fewer users. But the thing is, I get deadlocks with insert queries! Something simple as insert into sometable (col1, col2, col3) values ('val1','val2','val3') This tells me that the lock is not done on a row level, but on the table level. I'm using MSSQL 7, and the DBA assures me that it would lock at row level, so I'm guessing ColdFusion is requesting a lock at table level somewhere. Is there a CFAdmin setting for this? No, as mentioned above, this isn't specific to CF; there's no CF Admin setting for this. However, I wouldn't be so sure that locking is being done on a row level. If I recall correctly, that's not the default behavior for SQL Server 7. I think that SQL Server 7 locks pages (an internal storage unit) rather than locking individual rows or locking the whole table. Now, here's a problem. You may have several rows within a single page. Also, if you're using an identity column as a primary key, and you've defined a clustered index on that column, each insert will be physically located right after the previous insert. So, if you have one page with one row being inserted, and that page gets locked, and the database wants to write the next row to the same page due to the clustered index (which by definition matches the physical sort order of the column) that second write may be delayed, and if the database is busy enough, that may cause problems. I've heard that problem called a hotspot before. For a solution to this problem, I'm not sure what route would be best to take, in your situation. However, I'm not certain that this, by itself, is the problem you're having; typically, I think that this problem simply causes things to get significantly slower. A deadlock, on the other hand, implies that you have two transactions occurring, and neither can complete until the other has finished. So, the question for you is, are you doing anything else besides the insert here? Are you using CFTRANSACTION or transactional logic within your query/stored procedure also? On the other hand, for all I know, if the hotspot issue gets bad enough, maybe that will return a deadlock error! Your DBA should be able to help determine what's going on at the database level, I hope. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: Strange SQL error
Something that's happened to me before is that, depending on what you used to write the code originally, a hidden illegal character may have been introduced. When you moved it, once again depending on what you were using, the cut and paste would eliminate any illegal characters. I usually pass code through notepad if I've touched anything like Word or Wordpad for example because of the illegal characters. Margaret -Original Message- From: Stephen Galligan [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 9:25 AM To: CF-Talk Subject: RE: Strange SQL error What Andy meant was that he moved the @JuryTitle param to the bottom of the list like so: -- Any parameters here @CountryID int , @JuryName varchar(100) , @JuryCompanyvarchar(50) , @JuryCity varchar(50) , @JuryTypeID int , @JuryTitle varchar(50) @JuryTitle was originally declared after the second param @JuryName. For some reason the SP then released perfectly. Bizarrely I then moved the @JuryTitle param back to where it was and then the SP relases again. For the last 2 hours the SP would not release and we are at a loss as to why it didn't work. Any Ideas SQL gurus what may have happened? -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 17:10 To: CF-Talk Subject: RE: Strange SQL error uh? -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 17:18 To: CF-Talk Subject: RE: Strange SQL error Right fixed it - all we did was to move the declaration of the JuryTitle param to the bottom of the list and itr works! SQL schmeequel -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 16:50 To: CF-Talk Subject: RE: Strange SQL error I assume in this bit: VALUES ( @CountryID , @JuryName , @test , @JuryCompany , @JuryCity , @JuryTypeID you're actually using VALUES ( @CountryID , @JuryName , @JuryTitle , @JuryCompany , @JuryCity , @JuryTypeID ? -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 16:56 To: CF-Talk Subject: Strange SQL error In all my time developing SQL I have never come across sommat like this - please someone tell me I'm being stoopid as it's a Fri afternoon. I have the following SP which refuses to release - it says it cannot find parameter @JuryTitle. If I comment out @JuryTitle and the corresponding field insert it works. If I change the name of the variable it doesn'tsomeone slap me with a kipper so I can see where I've gone wrong... CREATE PROCEDURE JuryInsert -- Any parameters here @CountryID int , @JuryName varchar(100) , @JuryTitle varchar(50) , @JuryCompanyvarchar(50) , @JuryCity varchar(50) , @JuryTypeID int AS BEGIN INSERT INTO tblJury ( CountryID , JuryName , JuryTitle , JuryCompany , JuryCity , JuryTypeID ) VALUES ( @CountryID , @JuryName , @test , @JuryCompany , @JuryCity , @JuryTypeID ) IF @@error 0 BEGIN GOTO ERROR_EXIT END RETURN @@error ERROR_EXIT: RETURN @@error END GO -- Andy Ewings Director Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.net Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy,
Re: CFS5 CFMX VTM updater soon available from Macromedia
uhh why smile any bozo can make VTMs :) They're still getting rid of it lol boo hiss much better! :) i had vtms almost done doing them as i use the commands taking awhile but i havent been doing it full on we can allj ust band together code up our own editor and put MM out of the Editor business *cheers* Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Erika L Walker-Arnold [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 17, 2002 12:04 PM Subject: RE: CFS5 CFMX VTM updater soon available from Macromedia HUGE SMILES Thanks all around MM for listening to our whines and wants! - Erika L. Walker-Arnold, VP, RUWebby, LLC - Macromedia ColdFusion Alliance Partner Macromedia ColdFusion 5.0 Certified Developer - | -Original Message- | From: Vernon Viehe [mailto:[EMAIL PROTECTED]] | Sent: 17 May 2002 15:14 | To: CF-Talk | Subject: CFS5 CFMX VTM updater soon available from Macromedia | | | Hi All! | | I found out late last night that we've made an updater for | the CFMX VTMs for CFStudio 5. This will be available for | download very soon - it's in que to be posted by our | webteam. It's my understanding that this updater will be | linked from a HS+/CFS FAQ, and I'll send that link as soon | as I have it. | | *smiles everyone, smiles!* | | Vernon Viehe | Community Manager | Macromedia, Inc. | | Macromedia Certified Professional | http://vvmx.blogspot.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: What is this SQL Error?
The DBA wants me to call a stored procedure, wait until the stored procedure is done, then continue with the loop to call it again... Is there a way to make sure the store procedure is done before the code continues? -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:27 PM To: CF-Talk Subject: RE: What is this SQL Error? Thanks, I'll discuss that with our DBA. I'm not using any CFTRANSACTION, though. What might have an impact here is that this is a code that loops up to four times and does an insert every time. The user selects up to four items, and then the code loops through them and inserts a record in the table in each iteration. It's simple as cfif listlen(selectedItems) cfloop list=#selectedItems# index=thisSelectedItem cfquery name=insertItem database=someDatabase insert into someTable (col1,col2) values (#thisUser#,#thisSelectedItem#) /cfquery /cfloop /cfif -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:19 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: What is this SQL Error? I'm trying to figure out if ColdFusion locks the whole table when running a cfquery. This is entirely dependent on the database. CF is just a regular database client, like any other database client. I'm getting those deadlock errors in production, where too many people access the same table at the same time. It never happens in the development environment or in the testing environment. This makes sense, since you're less likely to have collisions with fewer users. But the thing is, I get deadlocks with insert queries! Something simple as insert into sometable (col1, col2, col3) values ('val1','val2','val3') This tells me that the lock is not done on a row level, but on the table level. I'm using MSSQL 7, and the DBA assures me that it would lock at row level, so I'm guessing ColdFusion is requesting a lock at table level somewhere. Is there a CFAdmin setting for this? No, as mentioned above, this isn't specific to CF; there's no CF Admin setting for this. However, I wouldn't be so sure that locking is being done on a row level. If I recall correctly, that's not the default behavior for SQL Server 7. I think that SQL Server 7 locks pages (an internal storage unit) rather than locking individual rows or locking the whole table. Now, here's a problem. You may have several rows within a single page. Also, if you're using an identity column as a primary key, and you've defined a clustered index on that column, each insert will be physically located right after the previous insert. So, if you have one page with one row being inserted, and that page gets locked, and the database wants to write the next row to the same page due to the clustered index (which by definition matches the physical sort order of the column) that second write may be delayed, and if the database is busy enough, that may cause problems. I've heard that problem called a hotspot before. For a solution to this problem, I'm not sure what route would be best to take, in your situation. However, I'm not certain that this, by itself, is the problem you're having; typically, I think that this problem simply causes things to get significantly slower. A deadlock, on the other hand, implies that you have two transactions occurring, and neither can complete until the other has finished. So, the question for you is, are you doing anything else besides the insert here? Are you using CFTRANSACTION or transactional logic within your query/stored procedure also? On the other hand, for all I know, if the hotspot issue gets bad enough, maybe that will return a deadlock error! Your DBA should be able to help determine what's going on at the database level, I hope. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: What is this SQL Error?
I'm not using any CFTRANSACTION, though. What might have an impact here is that this is a code that loops up to four times and does an insert every time. The user selects up to four items, and then the code loops through them and inserts a record in the table in each iteration. Well, then, see if you're using a clustered index on your identity column, and find out from your DBA what your lock level really is for inserts, and as a stopgap preventative measure, you may want to do the following: 1. Use CFTRANSACTION around your insert block, if for no other reason than if the thing fails, you won't have some of the records added but not others. Alternatively, keep track of which records have been entered successfully on each loop iteration; this will be a tiny bit of extra coding, but won't have the overhead of CFTRANSACTION if you really don't need it otherwise. 2. Use CFTRY/CFCATCH to catch your deadlock errors, and retry the operation in the CFCATCH block. You may even want to nest another CFTRY within there, so that if the second attempt fails, you can provide an alternative, like prompting the user to try again. Then, it's time to actually fix the problem (note that the above measures are just stopgaps). You may need a faster, or more powerful, database server, you may need to improve the speed of your database connection, you may need to port this logic to stored procedures (along with the rest of your db logic), and so on. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: What is this SQL Error?
I guess you could wait for a return code from the SP and test for it in your code. Used to do this all the time with VB but never done it with CF -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 17:37 To: CF-Talk Subject: RE: What is this SQL Error? The DBA wants me to call a stored procedure, wait until the stored procedure is done, then continue with the loop to call it again... Is there a way to make sure the store procedure is done before the code continues? -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:27 PM To: CF-Talk Subject: RE: What is this SQL Error? Thanks, I'll discuss that with our DBA. I'm not using any CFTRANSACTION, though. What might have an impact here is that this is a code that loops up to four times and does an insert every time. The user selects up to four items, and then the code loops through them and inserts a record in the table in each iteration. It's simple as cfif listlen(selectedItems) cfloop list=#selectedItems# index=thisSelectedItem cfquery name=insertItem database=someDatabase insert into someTable (col1,col2) values (#thisUser#,#thisSelectedItem#) /cfquery /cfloop /cfif -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:19 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: What is this SQL Error? I'm trying to figure out if ColdFusion locks the whole table when running a cfquery. This is entirely dependent on the database. CF is just a regular database client, like any other database client. I'm getting those deadlock errors in production, where too many people access the same table at the same time. It never happens in the development environment or in the testing environment. This makes sense, since you're less likely to have collisions with fewer users. But the thing is, I get deadlocks with insert queries! Something simple as insert into sometable (col1, col2, col3) values ('val1','val2','val3') This tells me that the lock is not done on a row level, but on the table level. I'm using MSSQL 7, and the DBA assures me that it would lock at row level, so I'm guessing ColdFusion is requesting a lock at table level somewhere. Is there a CFAdmin setting for this? No, as mentioned above, this isn't specific to CF; there's no CF Admin setting for this. However, I wouldn't be so sure that locking is being done on a row level. If I recall correctly, that's not the default behavior for SQL Server 7. I think that SQL Server 7 locks pages (an internal storage unit) rather than locking individual rows or locking the whole table. Now, here's a problem. You may have several rows within a single page. Also, if you're using an identity column as a primary key, and you've defined a clustered index on that column, each insert will be physically located right after the previous insert. So, if you have one page with one row being inserted, and that page gets locked, and the database wants to write the next row to the same page due to the clustered index (which by definition matches the physical sort order of the column) that second write may be delayed, and if the database is busy enough, that may cause problems. I've heard that problem called a hotspot before. For a solution to this problem, I'm not sure what route would be best to take, in your situation. However, I'm not certain that this, by itself, is the problem you're having; typically, I think that this problem simply causes things to get significantly slower. A deadlock, on the other hand, implies that you have two transactions occurring, and neither can complete until the other has finished. So, the question for you is, are you doing anything else besides the insert here? Are you using CFTRANSACTION or transactional logic within your query/stored procedure also? On the other hand, for all I know, if the hotspot issue gets bad enough, maybe that will return a deadlock error! Your DBA should be able to help determine what's going on at the database level, I hope. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: What is this SQL Error?
The DBA wants me to call a stored procedure, wait until the stored procedure is done, then continue with the loop to call it again... Is there a way to make sure the store procedure is done before the code continues? I'm pretty sure that CF will handle this for you; CF won't call the next iteration of the loop until the first one has completed. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: What is this SQL Error?
:) yes, I guess I can do that! Thanks -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:40 PM To: CF-Talk Subject: RE: What is this SQL Error? I guess you could wait for a return code from the SP and test for it in your code. Used to do this all the time with VB but never done it with CF -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 17:37 To: CF-Talk Subject: RE: What is this SQL Error? The DBA wants me to call a stored procedure, wait until the stored procedure is done, then continue with the loop to call it again... Is there a way to make sure the store procedure is done before the code continues? -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:27 PM To: CF-Talk Subject: RE: What is this SQL Error? Thanks, I'll discuss that with our DBA. I'm not using any CFTRANSACTION, though. What might have an impact here is that this is a code that loops up to four times and does an insert every time. The user selects up to four items, and then the code loops through them and inserts a record in the table in each iteration. It's simple as cfif listlen(selectedItems) cfloop list=#selectedItems# index=thisSelectedItem cfquery name=insertItem database=someDatabase insert into someTable (col1,col2) values (#thisUser#,#thisSelectedItem#) /cfquery /cfloop /cfif -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:19 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: What is this SQL Error? I'm trying to figure out if ColdFusion locks the whole table when running a cfquery. This is entirely dependent on the database. CF is just a regular database client, like any other database client. I'm getting those deadlock errors in production, where too many people access the same table at the same time. It never happens in the development environment or in the testing environment. This makes sense, since you're less likely to have collisions with fewer users. But the thing is, I get deadlocks with insert queries! Something simple as insert into sometable (col1, col2, col3) values ('val1','val2','val3') This tells me that the lock is not done on a row level, but on the table level. I'm using MSSQL 7, and the DBA assures me that it would lock at row level, so I'm guessing ColdFusion is requesting a lock at table level somewhere. Is there a CFAdmin setting for this? No, as mentioned above, this isn't specific to CF; there's no CF Admin setting for this. However, I wouldn't be so sure that locking is being done on a row level. If I recall correctly, that's not the default behavior for SQL Server 7. I think that SQL Server 7 locks pages (an internal storage unit) rather than locking individual rows or locking the whole table. Now, here's a problem. You may have several rows within a single page. Also, if you're using an identity column as a primary key, and you've defined a clustered index on that column, each insert will be physically located right after the previous insert. So, if you have one page with one row being inserted, and that page gets locked, and the database wants to write the next row to the same page due to the clustered index (which by definition matches the physical sort order of the column) that second write may be delayed, and if the database is busy enough, that may cause problems. I've heard that problem called a hotspot before. For a solution to this problem, I'm not sure what route would be best to take, in your situation. However, I'm not certain that this, by itself, is the problem you're having; typically, I think that this problem simply causes things to get significantly slower. A deadlock, on the other hand, implies that you have two transactions occurring, and neither can complete until the other has finished. So, the question for you is, are you doing anything else besides the insert here? Are you using CFTRANSACTION or transactional logic within your query/stored procedure also? On the other hand, for all I know, if the hotspot issue gets bad enough, maybe that will return a deadlock error! Your DBA should be able to help determine what's going on at the database level, I hope. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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
ISSUE: CFFTP all .txt files in a given directory.
Hello All: ISSUE: CFFTP all .txt files in a given directory. I'm trying to have code that will FTP all the .txt files in a directory to another server. Can anyone help me out here? I would also like to know if the files names are in a date format can I perform a range and have only certain files be selected for the ftp? Example of May 17, 2002 = 05172002.txt Sincerely, James Blaha CFFTP CONNECTION=movefiles USERNAME=anonymous PASSWORD=guest@unknown SERVER=172.17.89.157 ACTION=Open STOPONERROR=Yes !--- Get a File For the get function, both the remote file and the name it will have on the local server must be specified. The transfer mode is set explicitly here for clarity, but cfftp will usually make the right choice based on file extension anyway (and its default list of extensions with which ASCII mode should be used is easily changed). Call this code rget.cfm. --- !--- cfftp connection=movefiles action=GetFile remotefile=untitled.txt localfile=C:\Inetpub\wwwroot\CFFTP\file_folder\untitled.txt transfermode=binary timeout=30 retrycount=3 stoponerror=no failifexists=no --- cfftp connection=movefiles action=GetFile REMOTEFILE=/ localfile=C:\Inetpub\wwwroot\CFFTP\file_folder transfermode=binary timeout=30 retrycount=3 stoponerror=no failifexists=no !--- Delete a Local File The command to delete a local file is actually a one-liner that's pulled out into a separate file for clarity. The file parameter consists of the path to the script (set by view.cfm), the directory below it that holds these files, and the name of the file. Call this code ldel.cfm. cffile action=delete file=#scriptdir#/stuff/#mydel# --- !--- Close a Remote Connection If you don't close the connection, it will tie up resources of two computers until the remote server eventually times it out. Call this code rclose.cfm. --- cfftp connection=movefiles action=close pWhen this page is accesed the text files from quot;cfftpquot; are tranfered to quot;file_folderquot;./p pCFFTP CONNECTION=FTP USERNAME=anonymous PASSWORD=guest@unknown SERVER=172.17.89.157 ACTION=Open STOPONERROR=Yes CFFTP CONNECTION=FTP ACTION=GetCurrentDir STOPONERROR=Yes /pCFOUTPUT FTP directory listing of #cfftp.returnvalue#.p /CFOUTPUT CFOUTPUT Return is #cfftp.returnvalue# /CFOUTPUTBR CFFTP CONNECTION=FTP ACTION=ListDir DIRECTORY=//file_folder NAME=ListFiles STOPONERROR=Yes HR form name=ftpfiles method=post action=ftpfiles.cfm h3FTP Directory Listing:/h3 cftable query=ListFiles HTMLTABLE cfcol header=BName/B text=BName:/B #name# cfcol header=BPath/B text=BPath:/B #path# cfcol header=BURL/B text=BURL:/B #url# cfcol header=BLength/B text=BLength:/B #length# cfcol header=BDate Formted/B text=BDate Formatted:/B #DateFormat(LastModified)# cfcol header=BIsDirectory/B text=BIsDirectory:/B #isdirectory# /cftable __ 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: banner program
I've got a banner program almost done, but it was designed to serve ads for different sites and let people buy those ads directly. I should put it somewhere (it's on my laptop). One of the best ad programs I've seen period is in php. phpAds, free and very well done. Find it on sourceforge. I am looking for a CF based banner ad program. I have looked at all the banner ad programs on the MM developer exchange. Anyone have any comments/recommendations/experiences? Thanks... __ 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: What is this SQL Error?
Yes, but if it calls the database and doesn't wait for anything back, just goes ahead and calls it again... wouldn't it happen the same as when I call the queries - and the loop is faster than the database? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:46 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: What is this SQL Error? The DBA wants me to call a stored procedure, wait until the stored procedure is done, then continue with the loop to call it again... Is there a way to make sure the store procedure is done before the code continues? I'm pretty sure that CF will handle this for you; CF won't call the next iteration of the loop until the first one has completed. 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: False template file ... encrypted and its data has been corrupte d error
Send me one of the files and I'll try it on my Linux CF installation... send one that would run. At 12:20 PM 5/17/02 -0400, you wrote: I got the error below. I wrote my file in DW4, edited it in CF Studio 4, saved and tested it on an IIS server. When I uploaded it to an HP/UX box running apache I got the error below. I opened up VI, edited the file, everything looks normal, completely normal, and even saved the file. I went through the upload, test, check, test, edit, test scenario twice with the same file, a couple different times with other files. At all times, I get the error below. The files are not encrypted nor are they corrupted. I believe there was a problem with the installation, but I can't figure out what that problem was. I do not have much UNIX experience, but I've been working with CF on windows since 1996. Has anyone run across this error before? Someone has to have seen this before... Thanks, Don Error Diagnostic Information Cannot load template file //newtest3.cfm The template file exists, however, it either cannot be opened for reading, or it is encrypted and its data has been corrupted Date/Time: Fri May 17 09:08:17 2002 Browser: Mozilla/4.79 [en] (Windows NT 5.0; U) Remote Address: 0.0.0.0 HTTP Referer: [unknown origin] __ 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: What is this SQL Error?
Yes, but if it calls the database and doesn't wait for anything back, just goes ahead and calls it again... wouldn't it happen the same as when I call the queries - and the loop is faster than the database? It has to wait until the database server returns a message, before continuing. That message needn't be a recordset, but it does signal completion of the SQL batch. In most situations CF doesn't support asynchronous processing - starting something but not waiting around for it to finish. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: What is this SQL Error?
I thought about using cftry/cfcatch, but what if my second attempt is still done before the table is again available... I was wondering if ColdFusion had a timer function - such as, wait 300ms before continuing? -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:50 PM To: CF-Talk Subject: RE: What is this SQL Error? Yes, but if it calls the database and doesn't wait for anything back, just goes ahead and calls it again... wouldn't it happen the same as when I call the queries - and the loop is faster than the database? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:46 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: What is this SQL Error? The DBA wants me to call a stored procedure, wait until the stored procedure is done, then continue with the loop to call it again... Is there a way to make sure the store procedure is done before the code continues? I'm pretty sure that CF will handle this for you; CF won't call the next iteration of the loop until the first one has completed. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: CFS5 CFMX VTM updater soon available from Macromedia
That's what we're here for :) -Original Message- From: Erika L Walker-Arnold To: CF-Talk Sent: 5/17/2002 9:04 AM Subject: RE: CFS5 CFMX VTM updater soon available from Macromedia HUGE SMILES Thanks all around MM for listening to our whines and wants! - Erika L. Walker-Arnold, VP, RUWebby, LLC - Macromedia ColdFusion Alliance Partner Macromedia ColdFusion 5.0 Certified Developer - | -Original Message- | From: Vernon Viehe [mailto:[EMAIL PROTECTED]] | Sent: 17 May 2002 15:14 | To: CF-Talk | Subject: CFS5 CFMX VTM updater soon available from Macromedia | | | Hi All! | | I found out late last night that we've made an updater for | the CFMX VTMs for CFStudio 5. This will be available for | download very soon - it's in que to be posted by our | webteam. It's my understanding that this updater will be | linked from a HS+/CFS FAQ, and I'll send that link as soon | as I have it. | | *smiles everyone, smiles!* | | Vernon Viehe | Community Manager | Macromedia, Inc. | | Macromedia Certified Professional | http://vvmx.blogspot.com | __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What is this SQL Error?
I thought about using cftry/cfcatch, but what if my second attempt is still done before the table is again available... I was wondering if ColdFusion had a timer function - such as, wait 300ms before continuing? No, it doesn't, but I don't think that matters, since CF's processing of queries isn't asynchronous, to the best of my knowledge. That is, it won't continue processing after a CFQUERY tag until the database says I'm all done. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: What is this SQL Error?
But isn't it what's happening with the hotspot problem? - the query is done, but the database still has the page locked. BTW, Thanks bunches Dave, it's great to have a geekguru available like this ;) -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 1:07 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: What is this SQL Error? I thought about using cftry/cfcatch, but what if my second attempt is still done before the table is again available... I was wondering if ColdFusion had a timer function - such as, wait 300ms before continuing? No, it doesn't, but I don't think that matters, since CF's processing of queries isn't asynchronous, to the best of my knowledge. That is, it won't continue processing after a CFQUERY tag until the database says I'm all done. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: ISSUE: CFFTP all .txt files in a given directory.
Here's what I use, straight from my server, so substitute your variables where necessary: CFSET message = !--- GET LIST OF CONFIRM FILES --- CFDIRECTORY ACTION=LIST DIRECTORY=#half_confirmdir_local# NAME=confirmfiles FILTER=*.pdv SORT=datelastmodified ASC CFSET message = message #confirmfiles.recordCount# confirm files found.BR CFIF confirmfiles.recordCount !--- open ftp connection --- CFFTP ACTION=OPEN STOPONERROR=NO CONNECTION=half PASSIVE=NO SERVER=#half_ftpserver# USERNAME=#half_username# PASSWORD=#half_password# CFIF CFFTP.Succeeded CFSET message = message Connection opened to #half_ftpserver#.BR !--- put each order file --- CFLOOP QUERY=confirmfiles CFFTP ACTION=PUTFILE STOPONERROR=NO TRANSFERMODE=ASCII CONNECTION=half PASSIVE=No LOCALFILE=#half_confirmdir_local#\#confirmfiles.name# REMOTEFILE=#half_confirmdir#/#confirmfiles.name# CFIF CFFTP.Succeeded CFSET message = message #name# uploaded to #half_confirmdir#.BR CFFILE ACTION=MOVE SOURCE=#half_confirmdir_local#\#confirmfiles.name# DESTINATION=#half_confirmdir_done#\#confirmfiles.name# CFSET message = message #confirmfiles.name# moved to #half_confirmdir_done#.BR CFELSE Transfer failed!BR /CFIF /CFLOOP CFFTP ACTION=CLOSE STOPONERROR=NO CONNECTION=half CFIF CFFTP.Succeeded CFSET message = message Connection to #half_ftpserver# closed.BR CFELSE CFSET message = message Error closing Connection to #half_ftpserver#.BR /CFIF CFELSE CFSET message = message Failed to open FTP connection to #half_ftpserver#.BR /CFIF /CFIF CFOUTPUTP#message#/P/CFOUTPUT Hello All: ISSUE: CFFTP all .txt files in a given directory. I'm trying to have code that will FTP all the .txt files in a directory to another server. Can anyone help me out here? I would also like to know if the files names are in a date format can I perform a range and have only certain files be selected for the ftp? Example of May 17, 2002 = 05172002.txt Sincerely, James Blaha CFFTP CONNECTION=movefiles USERNAME=anonymous PASSWORD=guest@unknown SERVER=172.17.89.157 ACTION=Open STOPONERROR=Yes !--- Get a File For the get function, both the remote file and the name it will have on the local server must be specified. The transfer mode is set explicitly here for clarity, but cfftp will usually make the right choice based on file extension anyway (and its default list of extensions with which ASCII mode should be used is easily changed). Call this code rget.cfm. --- !--- cfftp connection=movefiles action=GetFile remotefile=untitled.txt localfile=C:\Inetpub\wwwroot\CFFTP\file_folder\untitled.txt transfermode=binary timeout=30 retrycount=3 stoponerror=no failifexists=no --- cfftp connection=movefiles action=GetFile REMOTEFILE=/ localfile=C:\Inetpub\wwwroot\CFFTP\file_folder transfermode=binary timeout=30 retrycount=3 stoponerror=no failifexists=no !--- Delete a Local File The command to delete a local file is actually a one-liner that's pulled out into a separate file for clarity. The file parameter consists of the path to the script (set by view.cfm), the directory below it that holds these files, and the name of the file. Call this code ldel.cfm. cffile action=delete file=#scriptdir#/stuff/#mydel# --- !--- Close a Remote Connection If you don't close the connection, it will tie up resources of two computers until the remote server eventually times it out. Call this code rclose.cfm. --- cfftp connection=movefiles action=close pWhen this page is accesed the text files from quot;cfftpquot; are tranfered to quot;file_folderquot;./p pCFFTP CONNECTION=FTP USERNAME=anonymous PASSWORD=guest@unknown SERVER=172.17.89.157 ACTION=Open STOPONERROR=Yes CFFTP CONNECTION=FTP ACTION=GetCurrentDir STOPONERROR=Yes /pCFOUTPUT FTP directory listing of #cfftp.returnvalue#.p /CFOUTPUT CFOUTPUT Return is #cfftp.returnvalue# /CFOUTPUTBR CFFTP CONNECTION=FTP ACTION=ListDir DIRECTORY=//file_folder NAME=ListFiles STOPONERROR=Yes HR form name=ftpfiles method=post action=ftpfiles.cfm h3FTP Directory Listing:/h3 cftable query=ListFiles HTMLTABLE cfcol header=BName/B text=BName:/B #name# cfcol header=BPath/B text=BPath:/B #path# cfcol header=BURL/B text=BURL:/B #url# cfcol header=BLength/B text=BLength:/B #length# cfcol header=BDate Formted/B text=BDate Formatted:/B #DateFormat(LastModified)# cfcol header=BIsDirectory/B text=BIsDirectory:/B #isdirectory# /cftable __ Structure your
RE: What is this SQL Error?
But isn't it what's happening with the hotspot problem? - the query is done, but the database still has the page locked. I seriously doubt that your problem is occurring because of one individual instance of your page running. However, if you have more than one person adding records at the same time, you could easily run into this. BTW, Thanks bunches Dave, it's great to have a geekguru available like this ;) You're welcome! Can I get a free Lexis-Nexis account out of this? Just kidding. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: Ways of securing email?
what part of the email process do you want to make secure? On Fri, 17 May 2002, Jon Hall wrote: I need to implement a secure email solution, and I know of 2 or 3 ways to do it. S/MIME POP3 over SSL PGP Are their any others that are worth looking into? jon __ 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: TIP: Checking to see if dynamic variable exists
Well that is fine if you know PART of the form.variable name as var_ and that the last part would ALWAYS be a number. Use this case if you do not know at all what the form.variables would be as well as outputting the variable name on the page. cfoutput cfif isdefined(form.fieldnames) cfloop index=frmItem list=#form.fieldnames# !--- Use this to output all elements --- FORM ELEMENT: #frmItem# br FORM VALUE: cfif #Evaluate(form. frmItem)# NEQ '' #Evaluate(form. frmItem)# /cfif /cfloop /cfif /cfoutput Might need to double check the syntax but did that off the top of my head. Randy Adkins [EMAIL PROTECTED] 05/17/02 12:10 PM Hopefully this is useful to some newbies (including myself). Lets say Forms are dynamically created and named on a page..(ex. Form.var_1, Form.var_2, etc.) Lets also say that one of those forms is a checkbox or radio, and they don't have to be checked or clicked...which means that the variable won't exist, (unlike text fields, where the formfield variable will exist even if left blank) So in order to do something with the information passed to the next page, you have to call it by its variablebut you might run into a problem if that variable never existed in the first place. Secondly, you don't know the name of that variable, since it was dynamically created! this is the basic way to check for it... CFIF isdefined(form.var_index) Let's say there are 4 form fields, but only 3 form variables were passed. Form.var_1, form.var_2, and form.var_4 You would put that check inside a loop CFLOOP index=index from=1 to=4 CFIF isdefined(form.var_index) DO and perform stuff /CFIF /CFLOOP thats how ya do it. Although this might not seem like much, you can created a new experience and different way to do things with your web apps! __ 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
How do I encrypt a file
I need to encrypt some custom tags to send to a competitor with other client cfm files. Can someone tell me how I can encrypt *.cfm files? Thanks, Nehal __ 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: CFS5 CFMX VTM updater soon available from Macromedia
uhh why smile any bozo can make VTMs :) They're still getting rid of it lol boo hiss much better! :) i had vtms almost done doing them as i use the commands taking awhile but i havent been doing it full on we can allj ust band together code up our own editor and put MM out of the Editor business *cheers* OK, I'm not sure how much of that is coherent English, but I think you're missing the point. I think the point is that MM listened to the community (specifically, cf-talk), and added something to their release schedule that was not in their orginal plans whatsoever, and was little more than an accomodation for those developers complaining about not wanting to ugrade to DWMX for one reason or another. I'm not entirely sure if your e-mail was sarcastic or not (e-mail can be that way sometimes), but I think you need to give credit where credit is due. The plans for an updater came exclusively from developer feedback, and I think squashes arguments from those who feel that MM is abandoning the developer community. Quite the contrary. Christine and Vernon, I just want to give a public note of thanks for your time and efforts on this issue. I think it has resulted in an upcoming product line that accomodates both upgraders and non-upgraders alike. Regards, Dave. __ 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: Ways of securing email?
I've been looking for a way to do cfmail type actions over a secured pop. Our challenge is no open text passwords can be transmitted on the network, but we would like to use pop authentication to authenticate users for web apps. I've not had much luck in finding pop over ssl solutions that work well with CF. Trey Rouse Internet Project Coordinator Web Services - Rice University MS 119 - 713.348.4799 -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:33 PM To: CF-Talk Subject: Re: Ways of securing email? what part of the email process do you want to make secure? On Fri, 17 May 2002, Jon Hall wrote: I need to implement a secure email solution, and I know of 2 or 3 ways to do it. S/MIME POP3 over SSL PGP Are their any others that are worth looking into? jon __ 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: Email Server
Have you looked at Apache/Jakarta's JAMES server? http://jakarta.apache.org/james/ It's free, open source, and written in Java. You can have it store messages or accounts in a database, and then very easily access it through CF. + Pete Freitag ([EMAIL PROTECTED]) CTO, CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Rick Eidson [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:08 AM To: CF-Talk Subject: Email Server I need an easy to configure email server that will do POP3 and that I can write CF against to create/Delete new accounts and I would like it to be free or very close to free. I downloaded Pegasus/Mercury but I don't care for it and would like somthing else to compare. Exchange and it s Cals are just to much money for what I need. Preferable runms on NT/2000. But if it is real easy then Linux. Rick Eidson __ 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: Ways of securing email?
This might not be applicable in your case, but a technique I use instead of emailing private information (I deal with medical information, where there are strict new rules coming out for how you handle it.. HUGE fines for the non-compliant!) is to allow doctors to log in to a website using SSL, and basically provide a webmail type of interface to data stored in a database. No use of pop boxes. Al a1webs.com I've been looking for a way to do cfmail type actions over a secured pop. Our challenge is no open text passwords can be transmitted on the network, but we would like to use pop authentication to authenticate users for web apps. I've not had much luck in finding pop over ssl solutions that work well with CF. __ 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: How do I encrypt a file
oi Nehal!! there is an executable in the CFUSION/Bin/ directory. sadly though, if they really want the code, they shall have it. -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Friday, May 17, 2002, 1:56:41 PM, you wrote: NF I need to encrypt some custom tags to send to a competitor with other client NF cfm files. Can someone tell me how I can encrypt *.cfm files? NF Thanks, NF Nehal NF __ 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: is CFHTTP illegal?
Read up on copyright law However, under the DMCA http://www.anti-dmca.org technically cfhttp probably is illegal...hehe :) Just wait though...the memory chips that cfhttp uses to store that copyrighted web site will be illegal soon too. http://www.politechbot.com/docs/cbdtpa/hollings.cbdtpa.release.032102.html btw, why is my email in the to field? I take it you didn't send this email to me, but the list did some weirdness... jon - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, May 17, 2002 12:22 PM Subject: is CFHTTP illegal? i was kinda wonderin, cuz you can use CFHTTP to make it look like your site can do seomthing, when instead it is using another site to do that actual work, and then displaying it on their own site... You know, lets know this website built an application that can predict your future precisely, just by knowing your name and age.. on my site, I just provide the interface for my users to put in their name and age, but on the processing side I will use CFHTTP to link to that other site so it can process the information, and then send it back to me so i can display the results to my users. Is this legal use? Or am I obligated to mention that my app is not mine? __ 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
CF_DEBUG Beta 2 Released
CF-Talk, We have created a unique tool for debugging ColdFusion applications, CF_DEBUG. This tag allows developers to organize, manage and maintain their debugging code within an application without placing this information directly in structured HTML layout and CF code. CF_DEBUG will also allow developers to leave debugging information an application when deploying. This can be very helpful for other developers working on an application, as well as aleviating the need to re-write debug code when developing further on an application. Download a copy of the Beta 2 Release here: http://www.brdwrks.com/v4/index.cfm?fuseaction=Developer Here are some examples of the tag in use: http://beta.brdwrks.com/v4/ http://beta.brdwrks.com/v4/index.cfm?fuseaction=DoesNotExist http://beta.brdwrks.com/v4/controller/getimage.cfm?image=../images/dynamic/badimage.gif * NOTE the orange handle at the top left We appreciate feedback, so please let us know what you think. Also, if you have something to contribute to this tool, please let us know. Ps. This tool HAS NOT been tested on Netscape, so beware! Enjoy, Scott Van Vliet BRD.WRKS Interactive [EMAIL PROTECTED] Shawn Regan [EMAIL PROTECTED] Mike Brunt Webapper [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Ways of securing email?
A human person needs to read the mail from their pc without the information being transmitted across an unsecure line. The actual process is flexible really.. for instance having the person connect to a pop3 server via SSL that lives on the same server as the CF program that generated the email would be ok... jon - Original Message - From: Alex [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 17, 2002 1:32 PM Subject: Re: Ways of securing email? what part of the email process do you want to make secure? On Fri, 17 May 2002, Jon Hall wrote: I need to implement a secure email solution, and I know of 2 or 3 ways to do it. S/MIME POP3 over SSL PGP Are their any others that are worth looking into? jon __ 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 or not OT: Voxeo and ColdFusion
I've done some work, what exactly are you looking for? I never had any problems, it was very painless. The Voxeo support is great. -Original Message- From: Erika L Walker-Arnold [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 3:56 PM To: CF-Talk Subject: OT or not OT: Voxeo and ColdFusion Anybody here do anything with Voxeo and ColdFusion? If so, are there any pitfalls to avoid? Words of warning? Some, oh yeah and if you try this it won't work.'s? Thanks in advance Going through the developer's stuff on the site and it's pretty straightforward, I'm just doing some research. Joined the newsgroup, but the archives are huge. - Erika L. Walker-Arnold, VP, RUWebby, LLC - Macromedia ColdFusion Alliance Partner Macromedia ColdFusion 5.0 Certified Developer - __ 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: cfreport
Ken, We gave up on CF Report. It's very limited too. We use Recrystallize from http//:www.recrystallize.com. It's a wizard that produces the input and processing pages in ASP. We scrap the input forms and redo them with CF and point them to the ASP processing pages which cause the report to open with a viewer of your choice -- Java or ActiveX. Note you will need Crystal Developers Edition on your server. Might be worth a look. - Original Message - From: Ken Beard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 17, 2002 10:02 AM Subject: cfreport Hello all, I am having trouble with the cfreport tag. I'm trying to connect to an oracle db, and I have created a dsn using the crystal reports oracle 8 driver, which is verified as working in the cf administrator. this is what the CF5 docs say: cfreport report = '/reports/monthlysales.rpt' {Departments.Department} = 'International' /cfreport and then on the same page but different they say: cfreport report = report_path orderBy = result_order username = username password = password formula = formula /cfreport when i try this: cfreport report=dailytimesheets.rpt username=cf password=fusion/cfreport it can't find the report, even though the cfm and the rpt files are in the same directory. when i do this: cfreport report=D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt username=cf password=fusion/cfreport I get the error: Error occurred while processing CFREPORT An unexpected error occurred while using the Crystal Engine. Error number 692 ocurred (Error in File D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt: Invalid export DLL or export format.). My thinking is that the cfdocs are just plain wrong and my syntax is right.. but I must be missing something. All help is appreciated. Ken Beard __ 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
OT: Windows - pesky folders
Hey gang, Thanks to some annoying French kids, who managed to get access to one of our servers and dump a bunch of files on it, I've got a couple of folders (a Win2k server box, btw) that absolutely refuse to delete. Tried everything I can think of, including going to the command line. Nada. I'm not a big server guy, so I don't know all the tricks here. Can anyone point me in the right direction to clean these folders off my drive? Aside from reformatting. :) Thanks in advance, --Scott __ 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: Ways of securing email?
You can use ssh with port forwarding for this. There are many howtos on the web. Or look at www.stunnel.org which is an SSL tunnel for servesices. On Fri, 17 May 2002, Trey Rouse wrote: I've been looking for a way to do cfmail type actions over a secured pop. Our challenge is no open text passwords can be transmitted on the network, but we would like to use pop authentication to authenticate users for web apps. I've not had much luck in finding pop over ssl solutions that work well with CF. Trey Rouse Internet Project Coordinator Web Services - Rice University MS 119 - 713.348.4799 -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:33 PM To: CF-Talk Subject: Re: Ways of securing email? what part of the email process do you want to make secure? On Fri, 17 May 2002, Jon Hall wrote: I need to implement a secure email solution, and I know of 2 or 3 ways to do it. S/MIME POP3 over SSL PGP Are their any others that are worth looking into? jon __ 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
A little array trouble
Can someone look at this and tell me why it does not want to name my array parts? cfif not ThisType EQ #TypeCode# cfset ThisType = #TypeCode# cfset #TypeCode#=arrayNew(1) cfset ThisTypeCt=1 hr#Thistype#hr cfelse cfset ThisTypeCt = #ThisTypeCt# + 1 /cfif #ThisType#[#Rank#] = #subType# cfset #ThisType#[#Rank#] = #Subtype# #ThisTypeCt# #SubType# #Rank#BR /cfoutput cfoutput PIs Seed an array? #IsArray(Seed)#/P PIt has #ArrayLen(Seed)# elements./P /cfoutput I seem to be running into trouble at this point: cfset #ThisType#[#Rank#] = #Subtype# Thanks In Advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential, and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the email listed above. __ 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: Windows - pesky folders
Similar thing happened to me. I think the reason is that the hacker go into through FTP on a U/Li/nix machine, and name the folders files with invalid characters. Any suggestions? -- 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: Scott Weikert [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 11:37 AM To: CF-Talk Subject: OT: Windows - pesky folders Hey gang, Thanks to some annoying French kids, who managed to get access to one of our servers and dump a bunch of files on it, I've got a couple of folders (a Win2k server box, btw) that absolutely refuse to delete. Tried everything I can think of, including going to the command line. Nada. I'm not a big server guy, so I don't know all the tricks here. Can anyone point me in the right direction to clean these folders off my drive? Aside from reformatting. :) Thanks in advance, --Scott __ 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: is CFHTTP illegal?
- Original Message - From: [EMAIL PROTECTED] i was kinda wonderin, cuz you can use CFHTTP to make it look like your site can do seomthing, when instead it is using another site to do that actual work, and then displaying it on their own site... This subject line is a bit misleading - if CFHTTP was illegal, I can't imagine Allaire would have risked implementing it ;-) The real question you're asking is: Is it illegal to use web applications or content, via CFHTTP, that are not intended for use by third parties, and passing them off as your own? Well, I've no firm idea about the letter of the law on this, but to me you may as well be asking if walking into a supermarket and taking a bag of apples without paying for them is illegal! Further, even if there's some legal loophole you can jump through, IMHO it's *wrong* to do something like this. If you think the people whose stuff you're using wouldn't mind, I'd at least get in touch with them to confirm. If you think they *would* mind... well, you've kind of answered your own question there ;-) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A Tip (maybe new, maybe not)
you are correct, MM/Allaire best practices for Access DBs says not to use connection pooling. see http://www.macromedia.com/v1/Handlers/index.cfm?ID=1540Method=Full /rob -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 2:26 AM To: CF-Talk Subject: Re: A Tip (maybe new, maybe not) Using SQL Server maintaining the connection would be advantageous because their wouldn't be the overhead for making a new connection, logging in, etc. In Access I don't think it matters. It is only Access after all. If I get concerned about performance of a site based on Access, I upgrade the site to SQL Server if CF's query caching wont do the trick. I believe it's actually reccomended that connections to Access databases are not maintained for memory reasons. jon Mike Kear wrote: What's the advantage of locking the server on to the database at all? Is it performance? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Subject: Re: A Tip (maybe new, maybe not) Go into the CF Admin and uncheck maintain database connections and your database wont lock at all unless it's actively being accessed by CF. jon Paul Giesenhagen wrote: I don't know if any of you work with Access much as a database here and there, but I have been developing using an access database and had to upload it to our servers after looking at the data or correcting the data as I was writing scripts ..well as you all know it locks so you cannot FTP over it once it has been accessed. I would stop/start the cf service to get this to run, well it became a pain when my terminal window would timeout and I would have to logg back into my server yadda yadda. __ 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: is CFHTTP illegal?
There are hundreds of uses for cfhttp other than scraping someone else's content. You can use it to grab feeds from other sites, run tasks on another server, pull data from other sites using wddx, etc. Yes, it CAN be used for evil, but so can javascript and it's still legal ;) Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 2:44 PM To: CF-Talk Subject: Re: is CFHTTP illegal? - Original Message - From: [EMAIL PROTECTED] i was kinda wonderin, cuz you can use CFHTTP to make it look like your site can do seomthing, when instead it is using another site to do that actual work, and then displaying it on their own site... This subject line is a bit misleading - if CFHTTP was illegal, I can't imagine Allaire would have risked implementing it ;-) The real question you're asking is: Is it illegal to use web applications or content, via CFHTTP, that are not intended for use by third parties, and passing them off as your own? Well, I've no firm idea about the letter of the law on this, but to me you may as well be asking if walking into a supermarket and taking a bag of apples without paying for them is illegal! Further, even if there's some legal loophole you can jump through, IMHO it's *wrong* to do something like this. If you think the people whose stuff you're using wouldn't mind, I'd at least get in touch with them to confirm. If you think they *would* mind... well, you've kind of answered your own question there ;-) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ 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: Windows - pesky folders
It could be that they installed something that is using those directories and that is why you cannot delete them if your logged in with the admin account. -Shawn Regan -Original Message- From: Van Vliet, Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 11:37 AM To: CF-Talk Subject: RE: Windows - pesky folders Similar thing happened to me. I think the reason is that the hacker go into through FTP on a U/Li/nix machine, and name the folders files with invalid characters. Any suggestions? -- 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: Scott Weikert [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 11:37 AM To: CF-Talk Subject: OT: Windows - pesky folders Hey gang, Thanks to some annoying French kids, who managed to get access to one of our servers and dump a bunch of files on it, I've got a couple of folders (a Win2k server box, btw) that absolutely refuse to delete. Tried everything I can think of, including going to the command line. Nada. I'm not a big server guy, so I don't know all the tricks here. Can anyone point me in the right direction to clean these folders off my drive? Aside from reformatting. :) Thanks in advance, --Scott __ 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: UDFs in a Custom Tag problem
What about this cfif Not IsDefined(IsOperator) cfscript function IsOperator( value ) { blah blah blah; return something; } /cfscript /cfif /rob -Original Message- From: heirophant mm [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:28 AM To: CF-Talk Subject: UDFs in a Custom Tag problem Hello developers, I'm writing a custom tag, and I've written some UDFs to clean up some of the code within the custom tag. Only the custom tag uses these UDFs - they're pretty specialized - so I thought it would be easiest to just put them right inside the template for the custom tag. Here's my general structure: cfif thistag.executionmode EQ start cfscript function IsOperator( value ) { blah blah blah; return something; } /cfscript more code /cfif cfif thistag.executionmode EQ end some output, etc. /cfif I get this error: Routines cannot be declared more than once. The routine IsOperator has been declared twice in different templates. I have found that this error occurs at the very beginning of the end ExecutionMode of the tag. I can't figure out how to stop this error. Any ideas? Thanks Mike Mertsock Alfred University Webteam Outgrown your current e-mail service? Get a 25MB Inbox, POP3 Access, No Ads and No Taglines with LYCOS MAIL PLUS. http://login.mail.lycos.com/brandPage.shtml?pageId=plus FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get 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: Windows - pesky folders
See if you can change the Attributes. Also make sure there are no hidden files or folders in it. Rick -Original Message- From: Van Vliet, Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 1:37 PM To: CF-Talk Subject: RE: Windows - pesky folders Similar thing happened to me. I think the reason is that the hacker go into through FTP on a U/Li/nix machine, and name the folders files with invalid characters. Any suggestions? -- 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: Scott Weikert [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 11:37 AM To: CF-Talk Subject: OT: Windows - pesky folders Hey gang, Thanks to some annoying French kids, who managed to get access to one of our servers and dump a bunch of files on it, I've got a couple of folders (a Win2k server box, btw) that absolutely refuse to delete. Tried everything I can think of, including going to the command line. Nada. I'm not a big server guy, so I don't know all the tricks here. Can anyone point me in the right direction to clean these folders off my drive? Aside from reformatting. :) Thanks in advance, --Scott __ 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: [SOT] CF on OS X... just venting
Can you rack-mount those new iMacs? Yes, now you can... and quite nicely! http://www.apple.com/xserve/ I was counting the minutes until you posted this! I am not up on server prices, but I imagine the latest from apple are competitive on p/p, no? Close, but until the hardware-based SCSI RAID 5 is available (I don't think it is, yet), I reserve judgment. I still don't think these are going to displace Intel or SPARC servers to any significant degree, even if I think they're technically pretty good. I'm waiting to hear how you got CF MX working on OS X, though - we're getting a new OS X TiBook here in a couple of weeks, and I might give it a whirl. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: banner program
I've got one - it uses JavaScript to rotate the ads, has a manager, click tracker and allows for local or affiliate ads from other sources. If you're interested I'll post it somewhere so y'all can take a look ;) Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:45 PM To: CF-Talk Subject: Re: banner program I've got a banner program almost done, but it was designed to serve ads for different sites and let people buy those ads directly. I should put it somewhere (it's on my laptop). One of the best ad programs I've seen period is in php. phpAds, free and very well done. Find it on sourceforge. I am looking for a CF based banner ad program. I have looked at all the banner ad programs on the MM developer exchange. Anyone have any comments/recommendations/experiences? Thanks... __ 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
Want to eliminate the Evaluate
There's got to be another way to do this. Any ideas? cfloop list='#form.fieldNames#' index=x cfset fieldName = '#x#' cfset fieldValue = #evaluate('form.#x#')# #fieldname# = #fieldValue#br /cfloop David DiPietro Systems Developer / Engineer OSU College of Medicine Public Health Voice (614) 292-5960 Fax (614) 292-0745 __ 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