Re: How do people work around the current limited cfmail
Joseph DeVore wrote: Hey Jochem, Off hand do you know how many email messages your custom tag can handle per day? I like the idea of having the SMTP server do what it does best. What are the cons to using this tag aside from the undeliverables? I have heard numbers between 15 and 40 per second (1 to 3 million a day roughly). If that isn't enough you should have a look at using a RAM-drive for the pickup dir since I/O seems to be the limiting factor. 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: How do people work around the current limited cfmail
That's what I wanted to hear! Thanks~ Joseph DeVore VeloxWeb Technologies -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 1:07 PM To: CF-Talk Subject: Re: How do people work around the current limited cfmail Joseph DeVore wrote: Hey Jochem, Off hand do you know how many email messages your custom tag can handle per day? I like the idea of having the SMTP server do what it does best. What are the cons to using this tag aside from the undeliverables? I have heard numbers between 15 and 40 per second (1 to 3 million a day roughly). If that isn't enough you should have a look at using a RAM-drive for the pickup dir since I/O seems to be the limiting factor. Jochem ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Disconnecting Data Sources for Upload?
This is a bit of a bubblegum solution, but you can have your client run a lock killing query just prior to upload. Just setup a quesry that they can navigate to in their browser (I call it qLockKiller.cfm). The SQL should be something like SELECT something FROM nothing. That will cause a db error and unlock Access (remove the .ldb file). Sometimes the query needs to be run afew times. I'd suggest doing this at non-peak times as somebody could hit the db again in the time it takes to fire up the FTP and send up the db. All that said...clients should not mess with uploading databases over top live ones...transaction will inevitably happen between the download and upload and thus data will be lost. Best solution is to set CF admin to only allow SELECT statements durring this process so no data can be altered. Of course this requires access to CF admin which is not always easy if hosted in a shared environment. HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: John McKown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 12:36 PM Subject: Disconnecting Data Sources for Upload? Customer has Access database that he uploads to CF Server via FTP. Access database is a datasource for his site. When site is being viewed, he cannot upload a newer copy of the database because the file is locked. Any creative solutions besides disconnect the datasource? John McKown, President Delaware.Net, Inc. 28 Old Rudnick Lane Dover, DE 19901 e-mail: [EMAIL PROTECTED] phone: 302-736-5515 toll free: 888-432-7965 fax: 302-736-5945 cell: 302-363-0071 icq: 1812513 ~~ 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: Disconnecting Data Sources for Upload?
Actually, the real solution is to not use shared file base databases on live Web sites. I know Access is cheap and easy, I know all the compelling reasons to use it, but: - administration and updates is a pain - the data file is highly susceptible to corruption - the data file is likely to be stolen too Access (and any other files based DBMS') were never designed for Web use, and really should not be used there. The tough part is explaining that to your client. If you need help convincing him, there is a column I wrote on this (title is Access Denied) at www.forta.com/cf/resources. --- Ben -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 4:13 PM To: CF-Talk Subject: Re: Disconnecting Data Sources for Upload? This is a bit of a bubblegum solution, but you can have your client run a lock killing query just prior to upload. Just setup a quesry that they can navigate to in their browser (I call it qLockKiller.cfm). The SQL should be something like SELECT something FROM nothing. That will cause a db error and unlock Access (remove the .ldb file). Sometimes the query needs to be run afew times. I'd suggest doing this at non-peak times as somebody could hit the db again in the time it takes to fire up the FTP and send up the db. All that said...clients should not mess with uploading databases over top live ones...transaction will inevitably happen between the download and upload and thus data will be lost. Best solution is to set CF admin to only allow SELECT statements durring this process so no data can be altered. Of course this requires access to CF admin which is not always easy if hosted in a shared environment. HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: John McKown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 12:36 PM Subject: Disconnecting Data Sources for Upload? Customer has Access database that he uploads to CF Server via FTP. Access database is a datasource for his site. When site is being viewed, he cannot upload a newer copy of the database because the file is locked. Any creative solutions besides disconnect the datasource? John McKown, President Delaware.Net, Inc. 28 Old Rudnick Lane Dover, DE 19901 e-mail: [EMAIL PROTECTED] phone: 302-736-5515 toll free: 888-432-7965 fax: 302-736-5945 cell: 302-363-0071 icq: 1812513 ~~ 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: UPS Prices
On 12/10/01, Matt Robertson penned: After that experience I decided I can't depend on a 3rd party's good will to let ecommerce sites keep working. Built a tag that uses downloaded/imported rates rather than trying to keep up with UPS, their changing API and usage restrictions (at the time of v1.1 and 2.0 (which was a whole year-and-a-half ago... Now they're on V5??) pulling rates from their site became a violation of their site usage rules. Don't know if they've changed, but from what they told me at the time they were pretty solid in wanting to migrate everyone to their own licensed tools. I hacked Ben's UPSPrice.cfm tag to work with version 1.2, which it still works fine with. As far as licensing, they wouldn't issue me a developer's license (not a big enough fish I guess), but it seems that the tag is OK to use as long as the end user registers. Here is my back and forth with UPS: Me: Why CAN'T I have a developer's license?? UPS: UPS has limited the number of third party developer requests to ensure that it can appropriately manage and support the third party developer program. UPS has received a very large number of requests from developers seeking to license the OnLine Tools. AS the program moves forward and UPS gains additional experience with the program, UPS may have the ability to license a greater number of third party developers. Me: Thanks Renee'. At least it's an explanation, albeit a pretty poor one. :) So, if I build a shopping cart for someone who would like to use UPS, I can develop a module for them to use as long as they register as an end user, correct? UPS: That is correct. You can offer 'custom' work for your clients as long as they license and register for the UPS OnLine Tools. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SandBox Problem
Hi Scott, well, i think it is repuired to use siteminder because we want to protect any bad actions of primary CFFILE-Tag. We want our custmoers not be able to use CFFILE to delete, read out and change any files of other customers. But the main reason was a file, with wich you can browse through the whole server and delete every file you want (including the system-files!) And to protect any attacks with this file or concerning this way, we want to be absolutely sure, that this is impossible. greez, Bastian ~~ 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: Disconnecting Data Sources for Upload?
If I remember correctly the bad query solution was a bug, and stopped working in 4.5. I do remember it not working in 4.5 for me... In versions 4.5+ there is a specific function for this. From the 4.5 Release notes cfset rs = cfusion_disable_dbconnections(myDSN,1) The following line enables the data source named cfmysource: cfset rs = cfusion_disable_dbconnections(myDSN,0) You can also uncheck Maintain Database Connections in the CF admin and the database will never lock. jon - Original Message - From: John McKown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 3:36 PM Subject: Disconnecting Data Sources for Upload? Customer has Access database that he uploads to CF Server via FTP. Access database is a datasource for his site. When site is being viewed, he cannot upload a newer copy of the database because the file is locked. Any creative solutions besides disconnect the datasource? ~~ 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: Disconnecting Data Sources for Upload?
I am trying to create an ecommerce site using a flat file database solution, and I want to know if anyone has had much experience with using Excel or CSV files? I keep hearing about the advantages over Access (no memory leaks, quicker access times, highly portable) and that they can greatly reduce the intiial costs of startup and ownership. My target deployment platform is PWS hooked to an @Home cable modem. What I want to know is: Does quering an Excel file create a persistent ODBC lock on the file? How about raw text? Will I be able to overwrite the file every five minutes if I need to, or will I have to launch a fake query? Mike :^) -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 4:16 PM To: CF-Talk Subject: RE: Disconnecting Data Sources for Upload? Actually, the real solution is to not use shared file base databases on live Web sites. I know Access is cheap and easy, I know all the compelling reasons to use it, but: - administration and updates is a pain - the data file is highly susceptible to corruption - the data file is likely to be stolen too Access (and any other files based DBMS') were never designed for Web use, and really should not be used there. The tough part is explaining that to your client. If you need help convincing him, there is a column I wrote on this (title is Access Denied) at www.forta.com/cf/resources. --- Ben -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 4:13 PM To: CF-Talk Subject: Re: Disconnecting Data Sources for Upload? This is a bit of a bubblegum solution, but you can have your client run a lock killing query just prior to upload. Just setup a quesry that they can navigate to in their browser (I call it qLockKiller.cfm). The SQL should be something like SELECT something FROM nothing. That will cause a db error and unlock Access (remove the .ldb file). Sometimes the query needs to be run afew times. I'd suggest doing this at non-peak times as somebody could hit the db again in the time it takes to fire up the FTP and send up the db. All that said...clients should not mess with uploading databases over top live ones...transaction will inevitably happen between the download and upload and thus data will be lost. Best solution is to set CF admin to only allow SELECT statements durring this process so no data can be altered. Of course this requires access to CF admin which is not always easy if hosted in a shared environment. HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: John McKown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 12:36 PM Subject: Disconnecting Data Sources for Upload? Customer has Access database that he uploads to CF Server via FTP. Access database is a datasource for his site. When site is being viewed, he cannot upload a newer copy of the database because the file is locked. Any creative solutions besides disconnect the datasource? John McKown, President Delaware.Net, Inc. 28 Old Rudnick Lane Dover, DE 19901 e-mail: [EMAIL PROTECTED] phone: 302-736-5515 toll free: 888-432-7965 fax: 302-736-5945 cell: 302-363-0071 icq: 1812513 ~~ 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: UPS Prices
Yeah, that experience pretty much mirrors mine, although it never occurred to me to back-door it like you did. Clever. I'm surprised an earlier API is still working. Probably a heavy hitter somewhere told 'em to leave it alone or else. What creeps me out is not reliability. Its hanging my you-know-whats out, asking for them to get chopped off if UPS decides to revise their API yet again. The first time it happened I had to run around and redo a bunch of sites for free. Should have gotten clients to sign off on the limitations/risks of using a 3rd-party add-in. From my perspective, At least I *know* that I'm good for a year. Last year's rate update was a snap. This year's is going to need some new things given recent rate changes, but it can't be that bad. Hopefully no more than an afternoon's work. --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- -- Original Message -- from: Bud [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 10 Dec 2001 16:21:15 -0500 On 12/10/01, Matt Robertson penned: After that experience I decided I can't depend on a 3rd party's good will to let ecommerce sites keep working. Built a tag that uses downloaded/imported rates rather than trying to keep up with UPS, their changing API and usage restrictions (at the time of v1.1 and 2.0 (which was a whole year-and-a-half ago... Now they're on V5??) pulling rates from their site became a violation of their site usage rules. Don't know if they've changed, but from what they told me at the time they were pretty solid in wanting to migrate everyone to their own licensed tools. I hacked Ben's UPSPrice.cfm tag to work with version 1.2, which it still works fine with. As far as licensing, they wouldn't issue me a developer's license (not a big enough fish I guess), but it seems that the tag is OK to use as long as the end user registers. Here is my back and forth with UPS: Me: Why CAN'T I have a developer's license?? UPS: UPS has limited the number of third party developer requests to ensure that it can appropriately manage and support the third party developer program. UPS has received a very large number of requests from developers seeking to license the OnLine Tools. AS the program moves forward and UPS gains additional experience with the program, UPS may have the ability to license a greater number of third party developers. Me: Thanks Renee'. At least it's an explanation, albeit a pretty poor one. :) So, if I build a shopping cart for someone who would like to use UPS, I can develop a module for them to use as long as they register as an end user, correct? UPS: That is correct. You can offer 'custom' work for your clients as long as they license and register for the UPS OnLine Tools. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RESOLVED: Error clearing dynamic Client Variables.
Hey all, I figured out how to do this, and whew! It wasn't easy. And it doesn't make sense to me..but it works. CFSET CurrentDate= #StartDate# cfloop CONDITION=#CurrentDate# LTE #EndDate# CFIF IsDefined(Client.Comment_#Evaluate(#DateFormat(CurrentDate,'mmdd') #)#) CFSET clientvar = Comment_#Evaluate(#DateFormat(CurrentDate,'mmdd')#)# CFSET temp = DeleteClientVariable(ClientVar) /CFIF CFSET CurrentDate=DATEADD(d,1,#CurrentDate#) !--- Advance the current date by one day --- CFSET CurrentDate = DateFormat(#CurrentDate#,'mm/dd/') /CFLOOP I had to se the variable first, and then call it in the DeleteClientVariable function. Totally crazy, but it worked. Also, in ANOTHER deleteclientvariable statement, I had to use QUOTES around the variable name, whereas you would notice in this one I did not. More weirdness :( Here is the code for the other one which involves a WDDX thingy. (special thanks to Sandy for showing me this neat code :) ) CFIF ISDefined(client.EquipmentForm) !--- Make sure that equipment has been entered --- cfwddx action=WDDX2CFML input=#Client.EquipmentForm# output=EquipmentForm cfloop index=counter from=1 to=5 step=1 !--- CHeck if Select Box is empty. If not then insert values, otherwise loop again --- cfif len(evaluate('EquipmentForm.chooseequip#counter#')) cfquery name=InsertEquipment datasource=relora dbtype=Oracle80 INSERT INTO tblEquipEntry VALUES (tblequipentry_seq.nextval,#TheMainID#,'#Evaluate('EquipmentForm.choosee quip#counter#')#',#Evaluate('EquipmentForm.hours#counter#')#) /cfquery /cfif /CFLOOP CFSET temp = DeleteClientVariable('EquipmentForm') /CFIF See? I had to wrap EquipmentForm in single quotes for it to work! Totally weird! :-\ -Gel ~~ 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: Disconnecting Data Sources for Upload?
Ben, I agree with you. On all of our in-house applications, we use SQL Server. This particular customer is a local chamber of commerce who uses Access internally to maintain their list of members. There are only 500 or so members, and they want the Access database to power the membership directory of their web site. They will never pay for SQL work, and we assist them for exposure in the community. Since the DB that is being uploaded is a copy, and is only used for select queries, there is no worry of corruption. This site is also small enough that simultaneous read-writes are not an issue either. And there is no credit card information or sensitive information in the DB at all. So in this particular case, Access is the best solution. Next time I will offer more data to keep the thread on-track. ;) Cheers. John McKown, President Delaware.Net, Inc. 28 Old Rudnick Lane Dover, DE 19901 e-mail: [EMAIL PROTECTED] phone: 302-736-5515 toll free: 888-432-7965 fax: 302-736-5945 cell: 302-363-0071 icq: 1812513 -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 4:16 PM To: CF-Talk Subject: RE: Disconnecting Data Sources for Upload? Actually, the real solution is to not use shared file base databases on live Web sites. I know Access is cheap and easy, I know all the compelling reasons to use it, but: - administration and updates is a pain - the data file is highly susceptible to corruption - the data file is likely to be stolen too Access (and any other files based DBMS') were never designed for Web use, and really should not be used there. The tough part is explaining that to your client. If you need help convincing him, there is a column I wrote on this (title is Access Denied) at www.forta.com/cf/resources. --- Ben -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 4:13 PM To: CF-Talk Subject: Re: Disconnecting Data Sources for Upload? This is a bit of a bubblegum solution, but you can have your client run a lock killing query just prior to upload. Just setup a quesry that they can navigate to in their browser (I call it qLockKiller.cfm). The SQL should be something like SELECT something FROM nothing. That will cause a db error and unlock Access (remove the .ldb file). Sometimes the query needs to be run afew times. I'd suggest doing this at non-peak times as somebody could hit the db again in the time it takes to fire up the FTP and send up the db. All that said...clients should not mess with uploading databases over top live ones...transaction will inevitably happen between the download and upload and thus data will be lost. Best solution is to set CF admin to only allow SELECT statements durring this process so no data can be altered. Of course this requires access to CF admin which is not always easy if hosted in a shared environment. HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: John McKown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 12:36 PM Subject: Disconnecting Data Sources for Upload? Customer has Access database that he uploads to CF Server via FTP. Access database is a datasource for his site. When site is being viewed, he cannot upload a newer copy of the database because the file is locked. Any creative solutions besides disconnect the datasource? John McKown, President Delaware.Net, Inc. 28 Old Rudnick Lane Dover, DE 19901 e-mail: [EMAIL PROTECTED] phone: 302-736-5515 toll free: 888-432-7965 fax: 302-736-5945 cell: 302-363-0071 icq: 1812513 ~~ 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: Disconnecting Data Sources for Upload?
Thank you, Jon. John McKown, President Delaware.Net, Inc. 28 Old Rudnick Lane Dover, DE 19901 e-mail: [EMAIL PROTECTED] phone: 302-736-5515 toll free: 888-432-7965 fax: 302-736-5945 cell: 302-363-0071 icq: 1812513 -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 4:38 PM To: CF-Talk Subject: Re: Disconnecting Data Sources for Upload? If I remember correctly the bad query solution was a bug, and stopped working in 4.5. I do remember it not working in 4.5 for me... In versions 4.5+ there is a specific function for this. From the 4.5 Release notes cfset rs = cfusion_disable_dbconnections(myDSN,1) The following line enables the data source named cfmysource: cfset rs = cfusion_disable_dbconnections(myDSN,0) You can also uncheck Maintain Database Connections in the CF admin and the database will never lock. jon - Original Message - From: John McKown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 3:36 PM Subject: Disconnecting Data Sources for Upload? Customer has Access database that he uploads to CF Server via FTP. Access database is a datasource for his site. When site is being viewed, he cannot upload a newer copy of the database because the file is locked. Any creative solutions besides disconnect the datasource? ~~ 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: Disconnecting Data Sources for Upload?
Have two databases - one links to the other. Set up the DSN on database 1 (which links to database 2) - upload database 2. Don't have any web based record administration on database2 though. or else you'll have to worry about synchronizing data. Eric Dawson From: John McKown [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Disconnecting Data Sources for Upload? Date: Mon, 10 Dec 2001 15:57:44 -0500 Ben, That sounds like a good solution. Thanks. John McKown, President Delaware.Net, Inc. 28 Old Rudnick Lane Dover, DE 19901 e-mail: [EMAIL PROTECTED] phone: 302-736-5515 toll free: 888-432-7965 fax: 302-736-5945 cell: 302-363-0071 icq: 1812513 -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 3:33 PM To: CF-Talk Subject: Re: Disconnecting Data Sources for Upload? Have two datasources databases. Have person upload datasource 2 while the site uses datasource 1. Do a query of datasource 2, loop through it and update datasource 1. Maybe have a scheduled task do this at a time that would be least disruptive. There are probably better ways to do this, but since you are using an access db in the first place, I imagine that simple is good. John McKown [EMAIL PROTECTED] 12/10/01 03:36PM Customer has Access database that he uploads to CF Server via FTP. Access database is a datasource for his site. When site is being viewed, he cannot upload a newer copy of the database because the file is locked. Any creative solutions besides disconnect the datasource? John McKown, President Delaware.Net, Inc. 28 Old Rudnick Lane Dover, DE 19901 e-mail: [EMAIL PROTECTED] phone: 302-736-5515 toll free: 888-432-7965 fax: 302-736-5945 cell: 302-363-0071 icq: 1812513 ~~ 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
Evaluate Question
Can anyone tell me why the answer to this question is Hello Goodbye? What would the following CFML code output to a user? cfset Temp = Hello cfset x=SetVariable(Temp, Goodbye) cfoutput #Temp# #Evaluate(Temp)# wouldn't it be Goodbye Goodbye since you're setting Temp to Goodbye before you output? thanks for any guidance. d ~~ 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: Evaluate Question
SetVariable uses string functions so the secondline is setting the variable named hello to the value of goodbye it is not setting temp to goodbye to do that you would need setvariable(Temp,Goodbye) - Original Message - From: Baskin, Dave [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 2:53 PM Subject: Evaluate Question Can anyone tell me why the answer to this question is Hello Goodbye? What would the following CFML code output to a user? cfset Temp = Hello cfset x=SetVariable(Temp, Goodbye) cfoutput #Temp# #Evaluate(Temp)# wouldn't it be Goodbye Goodbye since you're setting Temp to Goodbye before you output? thanks for any guidance. d ~~ 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: Evaluate Question
What actually happens is that the value that is assigned to Temp gets assigned the value Goodbye in this case. If you add #Hello# to your cfoutput then you would see Hello Goodbye Goodbye HTH Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 - Original Message - From: Baskin, Dave To: CF-Talk Sent: Monday, December 10, 2001 3:53 PM Subject: Evaluate Question Can anyone tell me why the answer to this question is Hello Goodbye? What would the following CFML code output to a user? cfset Temp = Hello cfset x=SetVariable(Temp, Goodbye) cfoutput #Temp# #Evaluate(Temp)# wouldn't it be Goodbye Goodbye since you're setting Temp to Goodbye before you output? thanks for any guidance. d ~~ 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
Archive and Deploy - Error, process is currently running
Hello, I'm attempting to archive a site and push it to another one of our development servers, but when I click on the Generate Archive button I get an error message that states Another archive/restore process is currently running. You must wait for this process to complete before you may start a new action,. I asked around and no one is currently archiving or deploying anything on this box. The box was restarted this morning, so it's not an idle process that someone left hanging either. The only thing I can remember is a couple of weeks ago we attempted to archive a large portion of this machine and it tanked during that process and we had to reboot in the middle of the archive. So I'm wondering if there is a setting somewhere that says that archive process is still open and therfore blocking others from occuring. And if so, where can that setting be overwritten? Thanks, t ** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.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
OT: Keep search engine spyders from following links
On a couple of web pages, I run links to outside web sites through a CF template that records the click-through along with some browser and referer stats in a table, then redirects the browser to the target URL. Is there any way to prevent search engine spyders from following these links? If I'm not mistaken, there's no way to use a robots.txt to prevent this behavior, or is there? Thanks, Jim ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Keep search engine spyders from following links
what's your web server? You can write an apache module to do this and I would assume you could do the same with ISAPI On Mon, 10 Dec 2001, Jim McAtee wrote: On a couple of web pages, I run links to outside web sites through a CF template that records the click-through along with some browser and referer stats in a table, then redirects the browser to the target URL. Is there any way to prevent search engine spyders from following these links? If I'm not mistaken, there's no way to use a robots.txt to prevent this behavior, or is there? Thanks, Jim ~~ 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
Installing Advanced Sec on Solaris
Hi, Installing CF 5.0 with Advanced Security and I read this KB (http://www.allaire.com/Handlers/index.cfm?ID=15670Method=Full) and it doesn't help me too much. We're asked to provide Directory Manager DN AND a Root DN. What's the relationship between them? My understanding is that we just need the directory manager's DN and the password is for directory manager. What is Root DN? Is it search base? Thanks for any input, I'm new to all of this! Jeff Reilly _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ~~ 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
Help!
Hi, Anyone ever seen the following error message? PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (45:1) to (45:53). Our application has been running fine for 3 months and now this occurs on occasion. Hit refresh on the browser and the page runs fine on the reload. It is a page with multiple queries. It is the index page that you are directed to after a login with application, client and session variables set. I'm wondering if it has to do with system resources? Any help? Thanks, Eric Homa ~~ 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: Help!
What happens when you stop and restart the Cold Fusion Application Server? At 02:52 PM 12/10/2001 -0800, you wrote: Hi, Anyone ever seen the following error message? PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (45:1) to (45:53). Our application has been running fine for 3 months and now this occurs on occasion. Hit refresh on the browser and the page runs fine on the reload. It is a page with multiple queries. It is the index page that you are directed to after a login with application, client and session variables set. I'm wondering if it has to do with system resources? Any help? Thanks, Eric Homa ~~ 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: UPS Prices
On 12/10/01, Matt Robertson penned: Yeah, that experience pretty much mirrors mine, although it never occurred to me to back-door it like you did. Clever. I'm surprised an earlier API is still working. Probably a heavy hitter somewhere told 'em to leave it alone or else. What creeps me out is not reliability. Its hanging my you-know-whats out, asking for them to get chopped off if UPS decides to revise their API yet again. The first time it happened I had to run around and redo a bunch of sites for free. Should have gotten clients to sign off on the limitations/risks of using a 3rd-party add-in. :) Well, what I did with Ben's tag was to build it so it uses the same parameters, then I change them inside the tag. Like GNDRES and GNDCOM aren't supported any more. It's just GND and you have to pass ResidentialInd as 0 or 1 to specify residential or commercial. So I still pass GNDRES or GNDCOM to the tag, then switch it to GND and set ResidentialInd to 0 or 1, accordingly. Same with the rest of the stuff they changed. This way I had only to replace the old tag on all the sites I'd used it with. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.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: Help!
You by chance using Query of Queries on that page? Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: ehoma [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 3:52 PM To: CF-Talk Subject: Help! Hi, Anyone ever seen the following error message? PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (45:1) to (45:53). Our application has been running fine for 3 months and now this occurs on occasion. Hit refresh on the browser and the page runs fine on the reload. It is a page with multiple queries. It is the index page that you are directed to after a login with application, client and session variables set. I'm wondering if it has to do with system resources? Any help? Thanks, Eric Homa ~~ 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: Help!
I've never seen it, what database are you using? - Original Message - From: ehoma [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 4:52 PM Subject: Help! Hi, Anyone ever seen the following error message? PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (45:1) to (45:53). Our application has been running fine for 3 months and now this occurs on occasion. Hit refresh on the browser and the page runs fine on the reload. It is a page with multiple queries. It is the index page that you are directed to after a login with application, client and session variables set. I'm wondering if it has to do with system resources? Any help? Thanks, Eric Homa ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Keep search engine spyders from following links
IIS. What exactly would the ISAPI application do? I suppose within my redirection template I _could_ parse the cgi.useragent string and neither record nor redirect known spyders. Keeping an up-to-date list of agents might be a pain, though. I'd rather just tell the syders (even if only the well-behaved ones) not to follow the link. Jim - Original Message - From: Alex [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 3:39 PM Subject: Re: OT: Keep search engine spyders from following links what's your web server? You can write an apache module to do this and I would assume you could do the same with ISAPI On Mon, 10 Dec 2001, Jim McAtee wrote: On a couple of web pages, I run links to outside web sites through a CF template that records the click-through along with some browser and referer stats in a table, then redirects the browser to the target URL. Is there any way to prevent search engine spyders from following these links? If I'm not mistaken, there's no way to use a robots.txt to prevent this behavior, or is there? Thanks, Jim ~~ 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: Help!
PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag You aren't using an unlocked session or application variable in the query are you? ~~ 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
Page processing twice
Anyone know what might cause a ColdFusion page to process twice? I'm using cflocation to redirect to a page that then does a CFHTTP post request. This page, post request and a subsequent query both get processed twice. I've eliminated all the obvious solutions (no header refresh commands, no multiple requests to any includes) and we've even added a cfabort command at the end of the code and while it does abort the process it still runs the page twice. Any ideas would be greatly appreciated. ~~ 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: Help!
It is most likely comming from a query of query . Make sure that the syntax is correct. Mike - Original Message - From: Zac Belado [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 3:37 PM Subject: RE: Help! PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag You aren't using an unlocked session or application variable in the query are you? ~~ 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: Keep search engine spyders from following links
Use the disallow feature in robots.txt, and make those links all have a similar path. We do something similar at http://bookcrossing.com/ for the links to Amazon... here is our robots.txt file: http://bookcrossing.com/robots.txt More info on robots.txt can be found here: http://www.searchengineworld.com/robots/robots_tutorial.htm -Ron -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 4:28 PM To: CF-Talk Subject: OT: Keep search engine spyders from following links On a couple of web pages, I run links to outside web sites through a CF template that records the click-through along with some browser and referer stats in a table, then redirects the browser to the target URL. Is there any way to prevent search engine spyders from following these links? If I'm not mistaken, there's no way to use a robots.txt to prevent this behavior, or is there? ~~ 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: Anyone else get solicited? FW: CFX ImageCR
Since I had not read/posted a message since February, I was doing some thorough catchup on cf-talk through the mail-archive web interface. I replied to some of the threads by direct email. The mail Kelly received was meant for someone else. I must have miscopied an address in a thread somewhere. Sorry for any headache this has caused, but it was an honest mistake and you are not part of any spam list. Kelly Matthews [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Did anyone else get solicited by these people? They snatched my email address off CF-Talk... not appreciated... really hate it when people do that! -Original Message- From: Efflare Systems [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 09, 2001 11:47 AM To: [EMAIL PROTECTED] Subject: CFX ImageCR Based on your input on the cf-talk mailing list, I thought you might be interested in knowing about the recent public release of cfx ImageCR. http://efflare.com/products/cfx_imagecr/?12 ~~ 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: Page processing twice
Any javascript involved? At 03:42 PM 10/12/01 -0800, you wrote: Anyone know what might cause a ColdFusion page to process twice? I'm using cflocation to redirect to a page that then does a CFHTTP post request. This page, post request and a subsequent query both get processed twice. I've eliminated all the obvious solutions (no header refresh commands, no multiple requests to any includes) and we've even added a cfabort command at the end of the code and while it does abort the process it still runs the page twice. Any ideas would be greatly appreciated. ~~ 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: OT: Keep search engine spyders from following links
Jim, It is possible to UNICODE HREFs and a lot of bots ignore these types of links. I use unicoded HREFs for all of my email addresses so spam bots don't grab them. I haven't tested unicoded HREFs in all browsers, just Netscape 4.08 and IE 4+ on Windows If you want to take a look at a unicoded href you can use this form to generate them: http://cftags.veloxweb.com/unicode/ HTH, Joseph DeVore VeloxWeb Technologies -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 3:35 PM To: CF-Talk Subject: Re: OT: Keep search engine spyders from following links IIS. What exactly would the ISAPI application do? I suppose within my redirection template I _could_ parse the cgi.useragent string and neither record nor redirect known spyders. Keeping an up-to-date list of agents might be a pain, though. I'd rather just tell the syders (even if only the well-behaved ones) not to follow the link. Jim - Original Message - From: Alex [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 3:39 PM Subject: Re: OT: Keep search engine spyders from following links what's your web server? You can write an apache module to do this and I would assume you could do the same with ISAPI On Mon, 10 Dec 2001, Jim McAtee wrote: On a couple of web pages, I run links to outside web sites through a CF template that records the click-through along with some browser and referer stats in a table, then redirects the browser to the target URL. Is there any way to prevent search engine spyders from following these links? If I'm not mistaken, there's no way to use a robots.txt to prevent this behavior, or is there? Thanks, Jim ~~ 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: Page processing twice
Any javascript involved? No. None in any of the pages. ~~ 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: Page processing twice
Are you using CFMODULE or any custom tags? It's possible that it's loading twice because of thistag.executionmode Joseph DeVore VeloxWeb Technologies -Original Message- From: Zac Belado [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 3:43 PM To: CF-Talk Subject: Page processing twice Anyone know what might cause a ColdFusion page to process twice? I'm using cflocation to redirect to a page that then does a CFHTTP post request. This page, post request and a subsequent query both get processed twice. I've eliminated all the obvious solutions (no header refresh commands, no multiple requests to any includes) and we've even added a cfabort command at the end of the code and while it does abort the process it still runs the page twice. Any ideas would be greatly appreciated. ~~ 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: Installing Advanced Sec on Solaris
Jeff, I assume you are using Netscape LDAP Server, if so this article is more current. http://www.allaire.com/Handlers/index.cfm?ID=21731Method=Full Mike Brunt Sempra Energy 213.244.5226 My software never has bugs. It just develops random features. -Original Message- From: Jeff Reilly [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 2:58 PM To: CF-Talk Subject: Installing Advanced Sec on Solaris Hi, Installing CF 5.0 with Advanced Security and I read this KB (http://www.allaire.com/Handlers/index.cfm?ID=15670Method=Full) and it doesn't help me too much. We're asked to provide Directory Manager DN AND a Root DN. What's the relationship between them? My understanding is that we just need the directory manager's DN and the password is for directory manager. What is Root DN? Is it search base? Thanks for any input, I'm new to all of this! Jeff Reilly _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ~~ 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: Keep search engine spyders from following links
Thanks, Ron. That gives me some good ideas. One thing I didn't mention is that multiple web sites use the template (located on another domain). So I have something like: Page on www.domain1.com links to www.domain0.com/redirect.cfm?... Page on www.domain2.com links to www.domain0.com/redirect.cfm?... Page on www.domain3.com links to www.domain0.com/redirect.cfm?... Page on www.domain4.com links to www.domain0.com/redirect.cfm?... Page on www.domain5.com links to www.domain0.com/redirect.cfm?... Since domain0.com needs to be indexed, I'm thinking that I should create a sub-directory and tell the robots not to go in there. Thanks again, Jim - Original Message - From: Ron Hornbaker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 4:43 PM Subject: RE: Keep search engine spyders from following links Use the disallow feature in robots.txt, and make those links all have a similar path. We do something similar at http://bookcrossing.com/ for the links to Amazon... here is our robots.txt file: http://bookcrossing.com/robots.txt More info on robots.txt can be found here: http://www.searchengineworld.com/robots/robots_tutorial.htm -Ron -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 4:28 PM To: CF-Talk Subject: OT: Keep search engine spyders from following links On a couple of web pages, I run links to outside web sites through a CF template that records the click-through along with some browser and referer stats in a table, then redirects the browser to the target URL. Is there any way to prevent search engine spyders from following these links? If I'm not mistaken, there's no way to use a robots.txt to prevent this behavior, or is there? ~~ 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: OT: Keep search engine spyders from following links
Joe, I'll try it out. Since the links all appear on CF-generated pages (pulled from database tables) I think I should be able to just Unicode the links within the CF templates themselves. Is there a CF Unicode tag or function somewhere, or do Unicode'd string simply use the ASCII codes for each character? Jim - Original Message - From: Joseph DeVore [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 5:05 PM Subject: RE: OT: Keep search engine spyders from following links Jim, It is possible to UNICODE HREFs and a lot of bots ignore these types of links. I use unicoded HREFs for all of my email addresses so spam bots don't grab them. I haven't tested unicoded HREFs in all browsers, just Netscape 4.08 and IE 4+ on Windows If you want to take a look at a unicoded href you can use this form to generate them: http://cftags.veloxweb.com/unicode/ HTH, Joseph DeVore VeloxWeb Technologies -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 3:35 PM To: CF-Talk Subject: Re: OT: Keep search engine spyders from following links IIS. What exactly would the ISAPI application do? I suppose within my redirection template I _could_ parse the cgi.useragent string and neither record nor redirect known spyders. Keeping an up-to-date list of agents might be a pain, though. I'd rather just tell the syders (even if only the well-behaved ones) not to follow the link. Jim - Original Message - From: Alex [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 3:39 PM Subject: Re: OT: Keep search engine spyders from following links what's your web server? You can write an apache module to do this and I would assume you could do the same with ISAPI On Mon, 10 Dec 2001, Jim McAtee wrote: On a couple of web pages, I run links to outside web sites through a CF template that records the click-through along with some browser and referer stats in a table, then redirects the browser to the target URL. Is there any way to prevent search engine spyders from following these links? If I'm not mistaken, there's no way to use a robots.txt to prevent this behavior, or is there? Thanks, Jim ~~ 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: Page processing twice
Are you using CFMODULE or any custom tags? It's possible that it's loading twice because of thistag.executionmode I'm using cfmodule in several locations but at no point am I using, setting, or testing executionmode in the site at all ~~ 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
Does anyone see a problem with this query?
I keep getting this error when I run the query. This is a SQL 2K database ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id = subt.id WHERE topc.id = subt.id Thanks Doug ~~ 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: Page processing twice
when you use cfmodule are you using a closing tag? /cfmodule Or are you using closing tags in any of your CT's? If so that will make the page execute twice. HTH, Joseph DeVore VeloxWeb Technologies -Original Message- From: Zac Belado [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 4:25 PM To: CF-Talk Subject: RE: Page processing twice Are you using CFMODULE or any custom tags? It's possible that it's loading twice because of thistag.executionmode I'm using cfmodule in several locations but at no point am I using, setting, or testing executionmode in the site at all ~~ 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: Does anyone see a problem with this query?
P.S This same query works great in query analyzer Doug - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 4:41 PM Subject: Does anyone see a problem with this query? I keep getting this error when I run the query. This is a SQL 2K database ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id = subt.id WHERE topc.id = subt.id Thanks Doug ~~ 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 CFGRAPH Crap?
My experience is that its CRAP! I played with it a lot when it first came out excited to have a built in graphing feature. Very quickly I realized that it doesn't scale very well for real-world applications. If its not like a percentage or value out of 100 or you want to customize the look of this very generic graph, it appears to be impossible. Or I gave up to early. I'm sure someone could build a better graphing tool with DHTML or the Flash Connector Kit. Ben Koshy Technical Manager W3 International Media Ltd. www.w3media.net 'Web Hosting Professionals' [T]604.871.9899 x388 [T]1.866.4.WEB.NOW x388 [F]604.871.1108 -Original Message- From: Jay Jennings [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 9:15 AM To: CF-Talk Subject: Is CFGRAPH Crap? Is the new CFGRAPH tag crap or is it just designed for very basic usage? Specifically, I need to increase the width of the graph -- partly to make more room for the labels in a vertical bar chart (and partly for aesthetics). I've searched the archives and have seen other people asking but no definitive answer. Should I just bag CFGRAPH or is it a little more robust than I'm thinking at this point? Thanks. jay - - - - - - - - - - - - - - - - - - - - - - - - - - Free toys for your kids! Or, earn extra income while you play! http://www.FamilyToysAndGames.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: Page processing twice
when you use cfmodule are you using a closing tag? /cfmodule No closing CFModule tags Or are you using closing tags in any of your CT's? If so that will make the page execute twice. None of the pages use any custom tags either. Any thing that would cause a cfinclude to be executed twice? ~~ 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
getting values from form field
Hi, i'm working on an app now that using dynamically named text boxes. i need to know the name of the text box (which happens to be an ID value) and the value of that text box so i can loop through a query and set the ID to a new value. I can loop through the form fields list to get the ID, but how do i get the value once i know the ID. I tried looping with: cfloop index=i list=#form.fieldnames# cfoutput #i# = #Evaluate(i)# /cfoutput /cfloop but i just get the same value for the two. can anyone tell me how to do this? thanks. d ~~ 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: Help!
It's an Access table datasource. Eric - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 3:20 PM Subject: Re: Help! I've never seen it, what database are you using? - Original Message - From: ehoma [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 4:52 PM Subject: Help! Hi, Anyone ever seen the following error message? PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (45:1) to (45:53). Our application has been running fine for 3 months and now this occurs on occasion. Hit refresh on the browser and the page runs fine on the reload. It is a page with multiple queries. It is the index page that you are directed to after a login with application, client and session variables set. I'm wondering if it has to do with system resources? Any help? Thanks, Eric Homa ~~ 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 CFGRAPH Crap?
As per your need of increasing width, have you used graphWidth? fileFormat = Flash, gif or jpg graphHeight = integer number of pixels graphWidth = integer number of pixels backgroundColor = Web color borderColor = Web color borderWidth = integer number of pixels depth = integer number of pixels colorList = Web color list Doug - Original Message - From: Ben Koshy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 4:37 PM Subject: RE: Is CFGRAPH Crap? My experience is that its CRAP! I played with it a lot when it first came out excited to have a built in graphing feature. Very quickly I realized that it doesn't scale very well for real-world applications. If its not like a percentage or value out of 100 or you want to customize the look of this very generic graph, it appears to be impossible. Or I gave up to early. I'm sure someone could build a better graphing tool with DHTML or the Flash Connector Kit. Ben Koshy Technical Manager W3 International Media Ltd. www.w3media.net 'Web Hosting Professionals' [T]604.871.9899 x388 [T]1.866.4.WEB.NOW x388 [F]604.871.1108 -Original Message- From: Jay Jennings [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 9:15 AM To: CF-Talk Subject: Is CFGRAPH Crap? Is the new CFGRAPH tag crap or is it just designed for very basic usage? Specifically, I need to increase the width of the graph -- partly to make more room for the labels in a vertical bar chart (and partly for aesthetics). I've searched the archives and have seen other people asking but no definitive answer. Should I just bag CFGRAPH or is it a little more robust than I'm thinking at this point? Thanks. jay - - - - - - - - - - - - - - - - - - - - - - - - - - Free toys for your kids! Or, earn extra income while you play! http://www.FamilyToysAndGames.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: Help!
No, in fact there are 7 very simple queries. Some use Count(*) and a few use DISTINCT, other than that it is very basic stuff. Eric - Original Message - From: Zac Belado [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 3:37 PM Subject: RE: Help! PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag You aren't using an unlocked session or application variable in the query are you? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help!
No, it seems that the error message, document position (45:1) to (45:53), is pointing to the offending query. If I comment that query out it no longer causes the error. The query in question is: CFQUERY NAME=DistinctHits DATASOURCE=SonyExcess SELECT DISTINCT IncomingIP FROM SiteHits /CFQUERY Pretty simple. There are about 3,500 records in the table. Eric - Original Message - From: Garza, Jeff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 3:11 PM Subject: RE: Help! You by chance using Query of Queries on that page? Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: ehoma [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 3:52 PM To: CF-Talk Subject: Help! Hi, Anyone ever seen the following error message? PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (45:1) to (45:53). Our application has been running fine for 3 months and now this occurs on occasion. Hit refresh on the browser and the page runs fine on the reload. It is a page with multiple queries. It is the index page that you are directed to after a login with application, client and session variables set. I'm wondering if it has to do with system resources? Any help? Thanks, Eric Homa ~~ 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: Three Selects Related Custom Tag
It should be in allaire's Developer's Exchange. I downloaded from there. -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 12:55 PM To: CF-Talk Subject: Three Selects Related Custom Tag Does anybody have Nate Weiss's Three Selects Related Custom Tag. He is reworking his site and I need to download it. Thanks, James ~~ 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
How to Sort Multidimensional Array
Happy Holidays All, Is it possible to sort a multidimensional array? If what's the syntax? The following doesn't seem to sort: CFSET SortFile = ArraySort(FileArray[1], Text, ASC) Thanks for you help. Regards, Paige ~~ 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: How do u use mySQL with CF on Windows 2000
How do you get CF 4.5 to work with mySQL for Windows? Is there an ODBC driver or is there another way to connect? Thanks, Pardee. ~~ 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
Templates executing twice CF bug
Greetings, I've identified a somewhat minor but possibly damaging bug in CF 5. It's pretty strange, but true. Zac Belado has confirmed that this was also the problem in his case (see his Page Processing Twice message from earlier today). It seems to only affect CF5 (4.5 was also tried) but so far only tested on W2K. The bug causes a template to be executed twice by the CF engine. It literally runs everything connected to the request twice (all includes, parent template, etc). There is no indication of this unless you have data that is noticeably affected (such as inserting DB records). The HTTP request is not doubled, only the actual CF code execution. This is not browser or Web server-related in any way. The cause seems to be missing cfoutput tags around a variable call, and apparently specifically in an IMG tag (some others were tried with no problems surfacing). So some code like this: img src=#variables.someVariable#/test.gif (w/out cfoutput tags anywhere around it) will cause double execution. Wrap it in cfoutputs (or in comments) and the problem goes away. Strange, no? So strange that I wrote a test for this. I've pasted my test template below, but if your email client makes it unreadable then you can also download a version here http://www.WorldDesign.com/CF/BugTest.cfm.txt. Instructions are in the comment. I'll also submit this to MM. Comments welcome. Cheers, -Max BugTest.cfm --- !--- This test template demonstrates an apparent bug in ColdFusion v.5 that causes a template to be executed twice per request. Run this template and look for a file named BugTestLog.txt in the same folder as the template. It should have 2 entries with exact same date/time stamp every time you request this template. As you can see there is no HTTP redirection/reload involved and the browser only requests the template once (check your web server log to verify). There is apparently no way to tell that the execution is happening twice except by looking at external events (like the log file double entry in this example). The cause seems to be missing cfoutput tags around a variable call, and apparently specifically in an IMG tag (some others were tried with no problems surfacing). Putting cfoutput or CF comment tags around the variable call will solve the issue (try it and then check the log file -- you should now only see one time stamp per request). So far this has only been confirmed on CF5 with Windows 2000. CF 4.5 on NT4 was also tried and did not exhibit this behavior. [EMAIL PROTECTED] 12/10/01 --- cfset logDir = GetDirectoryFromPath(GetCurrentTemplatePath()) cfset logFile = logDir BugTestLog.txt cflock timeout=5 throwontimeout=Yes name=writeTestLogFile type=EXCLUSIVE cffile action=APPEND file=#logFile# output=Ran at #Now()# addnewline=Yes /cflock cfset someVariable = test !--- the presence of the following line without cfoutput tags around it will cause this template to execute twice --- img src=#variables.someVariable#/test.gif - Maxim Paperno, CTO World Design Group, Inc. [ CF Development and Hosting since 1996 ] http://www.WorldDesign.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: How do u use mySQL with CF on Windows 2000
You can download myodbc from www.mysql.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 10:24 PM Subject: Re: How do u use mySQL with CF on Windows 2000 How do you get CF 4.5 to work with mySQL for Windows? Is there an ODBC driver or is there another way to connect? Thanks, Pardee. ~~ 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: Templates executing twice CF bug
Ran your test code and I only got a single log entry. Running CF5 Single User on Win2kPro. Will try in the morning on Full Enterprise CF5 on Advanced Server. Jeff Garza Webmaster/Lead Developer Spectrum Astro, Inc. [EMAIL PROTECTED] -Original Message- From: Max Paperno To: CF-Talk Sent: 12/10/01 9:29 PM Subject: Templates executing twice CF bug Greetings, I've identified a somewhat minor but possibly damaging bug in CF 5. It's pretty strange, but true. Zac Belado has confirmed that this was also the problem in his case (see his Page Processing Twice message from earlier today). It seems to only affect CF5 (4.5 was also tried) but so far only tested on W2K. The bug causes a template to be executed twice by the CF engine. It literally runs everything connected to the request twice (all includes, parent template, etc). There is no indication of this unless you have data that is noticeably affected (such as inserting DB records). The HTTP request is not doubled, only the actual CF code execution. This is not browser or Web server-related in any way. The cause seems to be missing cfoutput tags around a variable call, and apparently specifically in an IMG tag (some others were tried with no problems surfacing). So some code like this: img src=#variables.someVariable#/test.gif (w/out cfoutput tags anywhere around it) will cause double execution. Wrap it in cfoutputs (or in comments) and the problem goes away. Strange, no? So strange that I wrote a test for this. I've pasted my test template below, but if your email client makes it unreadable then you can also download a version here http://www.WorldDesign.com/CF/BugTest.cfm.txt. Instructions are in the comment. I'll also submit this to MM. Comments welcome. Cheers, -Max BugTest.cfm --- !--- This test template demonstrates an apparent bug in ColdFusion v.5 that causes a template to be executed twice per request. Run this template and look for a file named BugTestLog.txt in the same folder as the template. It should have 2 entries with exact same date/time stamp every time you request this template. As you can see there is no HTTP redirection/reload involved and the browser only requests the template once (check your web server log to verify). There is apparently no way to tell that the execution is happening twice except by looking at external events (like the log file double entry in this example). The cause seems to be missing cfoutput tags around a variable call, and apparently specifically in an IMG tag (some others were tried with no problems surfacing). Putting cfoutput or CF comment tags around the variable call will solve the issue (try it and then check the log file -- you should now only see one time stamp per request). So far this has only been confirmed on CF5 with Windows 2000. CF 4.5 on NT4 was also tried and did not exhibit this behavior. [EMAIL PROTECTED] 12/10/01 --- cfset logDir = GetDirectoryFromPath(GetCurrentTemplatePath()) cfset logFile = logDir BugTestLog.txt cflock timeout=5 throwontimeout=Yes name=writeTestLogFile type=EXCLUSIVE cffile action=APPEND file=#logFile# output=Ran at #Now()# addnewline=Yes /cflock cfset someVariable = test !--- the presence of the following line without cfoutput tags around it will cause this template to execute twice --- img src=#variables.someVariable#/test.gif - Maxim Paperno, CTO World Design Group, Inc. [ CF Development and Hosting since 1996 ] http://www.WorldDesign.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: Templates executing twice CF bug
I must admit, I was a doubter. Here's how I confirmed your bug: CFPARAM a server variable to zero. Increment it by one, then display it. If you include a non-CFOUTPUTed variable in an image tag, the number is displayed incrementing by two. Take out the mysterious IMG tag, or turn it into a garbage BLAH src=... tag, and the number seems to increment by one. Very bizarre! Norman Elton College of William Mary -Original Message- From: Max Paperno [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 11:29 PM To: CF-Talk Subject: Templates executing twice CF bug Greetings, I've identified a somewhat minor but possibly damaging bug in CF 5. It's pretty strange, but true. Zac Belado has confirmed that this was also the problem in his case (see his Page Processing Twice message from earlier today). It seems to only affect CF5 (4.5 was also tried) but so far only tested on W2K. The bug causes a template to be executed twice by the CF engine. It literally runs everything connected to the request twice (all includes, parent template, etc). There is no indication of this unless you have data that is noticeably affected (such as inserting DB records). The HTTP request is not doubled, only the actual CF code execution. This is not browser or Web server-related in any way. The cause seems to be missing cfoutput tags around a variable call, and apparently specifically in an IMG tag (some others were tried with no problems surfacing). So some code like this: img src=#variables.someVariable#/test.gif (w/out cfoutput tags anywhere around it) will cause double execution. Wrap it in cfoutputs (or in comments) and the problem goes away. Strange, no? So strange that I wrote a test for this. I've pasted my test template below, but if your email client makes it unreadable then you can also download a version here http://www.WorldDesign.com/CF/BugTest.cfm.txt. Instructions are in the comment. I'll also submit this to MM. Comments welcome. Cheers, -Max BugTest.cfm --- !--- This test template demonstrates an apparent bug in ColdFusion v.5 that causes a template to be executed twice per request. Run this template and look for a file named BugTestLog.txt in the same folder as the template. It should have 2 entries with exact same date/time stamp every time you request this template. As you can see there is no HTTP redirection/reload involved and the browser only requests the template once (check your web server log to verify). There is apparently no way to tell that the execution is happening twice except by looking at external events (like the log file double entry in this example). The cause seems to be missing cfoutput tags around a variable call, and apparently specifically in an IMG tag (some others were tried with no problems surfacing). Putting cfoutput or CF comment tags around the variable call will solve the issue (try it and then check the log file -- you should now only see one time stamp per request). So far this has only been confirmed on CF5 with Windows 2000. CF 4.5 on NT4 was also tried and did not exhibit this behavior. [EMAIL PROTECTED] 12/10/01 --- cfset logDir = GetDirectoryFromPath(GetCurrentTemplatePath()) cfset logFile = logDir BugTestLog.txt cflock timeout=5 throwontimeout=Yes name=writeTestLogFile type=EXCLUSIVE cffile action=APPEND file=#logFile# output=Ran at #Now()# addnewline=Yes /cflock cfset someVariable = test !--- the presence of the following line without cfoutput tags around it will cause this template to execute twice --- img src=#variables.someVariable#/test.gif - Maxim Paperno, CTO World Design Group, Inc. [ CF Development and Hosting since 1996 ] http://www.WorldDesign.com/ ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Does anyone see a problem with this query?
leave out the 'AS' in the from line At 04:47 PM 12/10/2001 -0800, you wrote: P.S This same query works great in query analyzer Doug - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 4:41 PM Subject: Does anyone see a problem with this query? I keep getting this error when I run the query. This is a SQL 2K database ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id = subt.id WHERE topc.id = subt.id Thanks Doug ~~ 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: Templates executing twice CF bug
I try it for CF 4.5 Server Prof on Win2K Prof. Have the same problem. Double Log entry for no cfoutput. - Original Message - From: Garza, Jeff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 12:04 PM Subject: RE: Templates executing twice CF bug Ran your test code and I only got a single log entry. Running CF5 Single User on Win2kPro. Will try in the morning on Full Enterprise CF5 on Advanced Server. Jeff Garza Webmaster/Lead Developer Spectrum Astro, Inc. [EMAIL PROTECTED] -Original Message- From: Max Paperno To: CF-Talk Sent: 12/10/01 9:29 PM Subject: Templates executing twice CF bug Greetings, I've identified a somewhat minor but possibly damaging bug in CF 5. It's pretty strange, but true. Zac Belado has confirmed that this was also the problem in his case (see his Page Processing Twice message from earlier today). It seems to only affect CF5 (4.5 was also tried) but so far only tested on W2K. The bug causes a template to be executed twice by the CF engine. It literally runs everything connected to the request twice (all includes, parent template, etc). There is no indication of this unless you have data that is noticeably affected (such as inserting DB records). The HTTP request is not doubled, only the actual CF code execution. This is not browser or Web server-related in any way. The cause seems to be missing cfoutput tags around a variable call, and apparently specifically in an IMG tag (some others were tried with no problems surfacing). So some code like this: img src=#variables.someVariable#/test.gif (w/out cfoutput tags anywhere around it) will cause double execution. Wrap it in cfoutputs (or in comments) and the problem goes away. Strange, no? So strange that I wrote a test for this. I've pasted my test template below, but if your email client makes it unreadable then you can also download a version here http://www.WorldDesign.com/CF/BugTest.cfm.txt. Instructions are in the comment. I'll also submit this to MM. Comments welcome. Cheers, -Max BugTest.cfm --- !--- This test template demonstrates an apparent bug in ColdFusion v.5 that causes a template to be executed twice per request. Run this template and look for a file named BugTestLog.txt in the same folder as the template. It should have 2 entries with exact same date/time stamp every time you request this template. As you can see there is no HTTP redirection/reload involved and the browser only requests the template once (check your web server log to verify). There is apparently no way to tell that the execution is happening twice except by looking at external events (like the log file double entry in this example). The cause seems to be missing cfoutput tags around a variable call, and apparently specifically in an IMG tag (some others were tried with no problems surfacing). Putting cfoutput or CF comment tags around the variable call will solve the issue (try it and then check the log file -- you should now only see one time stamp per request). So far this has only been confirmed on CF5 with Windows 2000. CF 4.5 on NT4 was also tried and did not exhibit this behavior. [EMAIL PROTECTED] 12/10/01 --- cfset logDir = GetDirectoryFromPath(GetCurrentTemplatePath()) cfset logFile = logDir BugTestLog.txt cflock timeout=5 throwontimeout=Yes name=writeTestLogFile type=EXCLUSIVE cffile action=APPEND file=#logFile# output=Ran at #Now()# addnewline=Yes /cflock cfset someVariable = test !--- the presence of the following line without cfoutput tags around it will cause this template to execute twice --- img src=#variables.someVariable#/test.gif - Maxim Paperno, CTO World Design Group, Inc. [ CF Development and Hosting since 1996 ] http://www.WorldDesign.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: Anyone else get solicited? FW: CFX ImageCR
BTW I received the same email -- Massimo Foti [EMAIL PROTECTED] Team Macromedia Member Efflare Systems [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Since I had not read/posted a message since February, I was doing some thorough catchup on cf-talk through the mail-archive web interface. I replied to some of the threads by direct email. The mail Kelly received was meant for someone else. I must have miscopied an address in a thread somewhere. Sorry for any headache this has caused, but it was an honest mistake and you are not part of any spam list. ~~ 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: getting values from form field
cfloop collection=#form# item=i cfoutputThe value for : form.#i# is: #form[i]#br/cfoutput /cfloop -- Massimo Foti [EMAIL PROTECTED] Team Macromedia Member Baskin, Dave [EMAIL PROTECTED] wrote in message Hi, i'm working on an app now that using dynamically named text boxes. i need to know the name of the text box (which happens to be an ID value) and the value of that text box so i can loop through a query and set the ID to a new value. I can loop through the form fields list to get the ID, but how do i get the value once i know the ID. I tried looping with: cfloop index=i list=#form.fieldnames# cfoutput #i# = #Evaluate(i)# /cfoutput /cfloop but i just get the same value for the two. can anyone tell me how to do this? thanks. com/index.cfm?sidebar=lists ~~ 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 CFGRAPH Crap?
I keep getting this error: Could not connect to JRun Connector Proxy But I'm only running 1 report with the new CFGraph on it. Are these not scalable?? -Original Message- From: Ben Koshy [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 4:37 PM To: CF-Talk Subject: RE: Is CFGRAPH Crap? My experience is that its CRAP! I played with it a lot when it first came out excited to have a built in graphing feature. Very quickly I realized that it doesn't scale very well for real-world applications. If its not like a percentage or value out of 100 or you want to customize the look of this very generic graph, it appears to be impossible. Or I gave up to early. I'm sure someone could build a better graphing tool with DHTML or the Flash Connector Kit. Ben Koshy Technical Manager W3 International Media Ltd. www.w3media.net 'Web Hosting Professionals' [T]604.871.9899 x388 [T]1.866.4.WEB.NOW x388 [F]604.871.1108 -Original Message- From: Jay Jennings [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 9:15 AM To: CF-Talk Subject: Is CFGRAPH Crap? Is the new CFGRAPH tag crap or is it just designed for very basic usage? Specifically, I need to increase the width of the graph -- partly to make more room for the labels in a vertical bar chart (and partly for aesthetics). I've searched the archives and have seen other people asking but no definitive answer. Should I just bag CFGRAPH or is it a little more robust than I'm thinking at this point? Thanks. jay - - - - - - - - - - - - - - - - - - - - - - - - - - Free toys for your kids! Or, earn extra income while you play! http://www.FamilyToysAndGames.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: Help!
My guess would be that the SQL server is not returning in a specified time, might pay to also have a look at the resource monitor and see what is happening, memory wise. I say this because it might be a case of too much being held in memory at one time! In this scenario, is this a single hit or is this in a production where it's getting a lot of hits!! You might want to look a caching the query, and maybe making it an application scope variable with the proper locks. This would cut the load to the SQL Server it would also mean that less memory would be being used. Just a few thoughts of the top of my head!! -Original Message- From: ehoma [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 11 December 2001 12:23 PM To: CF-Talk Subject: Re: Help! No, it seems that the error message, document position (45:1) to (45:53), is pointing to the offending query. If I comment that query out it no longer causes the error. The query in question is: CFQUERY NAME=DistinctHits DATASOURCE=SonyExcess SELECT DISTINCT IncomingIP FROM SiteHits /CFQUERY Pretty simple. There are about 3,500 records in the table. Eric ~~ 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: Templates executing twice CF bug
I am not going to sit here, and get lost in this. I tried everyone of your suggestions and must admit it doesn't do it here. I am going to think this might be an IIS problem, because CF would not be passing this bit of code anyway as it would be headed back to the IIS resources. Sorry guys but I tried everything to do what you guys have tried, but remember this if IIS can't handle the #'s then maybe this is another security hole by MS? -Original Message- From: Fisichella [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 11 December 2001 5:09 PM To: CF-Talk Subject: Re: Templates executing twice CF bug I try it for CF 4.5 Server Prof on Win2K Prof. Have the same problem. Double Log entry for no cfoutput. - Original Message - From: Garza, Jeff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 12:04 PM Subject: RE: Templates executing twice CF bug ~~ 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
Page runs twice!!
Guys I want to share something with you!! Depending on your application design, I would be hesitant to say that you either have a case of cfmodule blah= / or cfmodule blah=/cfmodule somewhere as explained for a Tag to run twice it has to be called twice and the above does this. However let me tell you something else that a lot of you newer developers tend to have forgotten. HTML is not parsed via CF they are passed back to IIS to deal with. There has been times I have looked at code and know that it should work. But with the advent of DHTML, each browser does it differently. But there is one tag (I don't recall) I tried to give it an ID attribute and found that I had to make sure it was in a certain spot for the class attribute to work. Anyway I am ranting again, but the point is I could not duplicate it here under W2K Professional and Windows XP but I am also very well patched with MS patches etc so maybe as I stated it is an IIS problem!! Anyone wish to try under Linux/Solaris servers or even Apache? ~~ 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: Templates executing twice CF bug
I just tried this on the following setup: O'Reilly WebSite Pro 2.5.4 ColdFusion 5 Enterprise Windows 2000 Server The first time the template was executed there was only one timestamp. Each additional time there were two timestamps. So, it looks like the problem occurs when the template gets cached by ColdFusion and that it is also not related to IIS. Do you have template caching enabled? Howie - Original Message - From: Andrew Scott [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 2:12 AM Subject: RE: Templates executing twice CF bug I am not going to sit here, and get lost in this. I tried everyone of your suggestions and must admit it doesn't do it here. I am going to think this might be an IIS problem, because CF would not be passing this bit of code anyway as it would be headed back to the IIS resources. Sorry guys but I tried everything to do what you guys have tried, but remember this if IIS can't handle the #'s then maybe this is another security hole by MS? -Original Message- From: Fisichella [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 11 December 2001 5:09 PM To: CF-Talk Subject: Re: Templates executing twice CF bug I try it for CF 4.5 Server Prof on Win2K Prof. Have the same problem. Double Log entry for no cfoutput. - Original Message - From: Garza, Jeff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 12:04 PM Subject: RE: Templates executing twice CF bug ~~ 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