Re: CFFILE Issue
Hi Dave, On my dev machine it did not exist, but it worked, and it worked on the live server. The only real change I made was I created a new directory in the admin folder called pdf so that the new one's get generated there. I updated the permissions on my dev machine to read/write for the cf user but no joy even when creating the pdf directory in the tmp directory. When I went the #expandpath()# route though, and pointed the PDF's to the directory where the other one's are written, it worked fine. It's just outside of the admin folder but I really don't care since the other one is also outside of the admin directory. I was just trying to keep add admin stuff inside the admin folder. > > CF often writes files to a local temp directory before putting them in > their final destination. That's probably what's happening here. Does > the temp directory exist? Does CF have permission to write to it? > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > http://training.figleaf.com/ > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > GSA Schedule, and provides the highest caliber vendor-authorized > instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354887 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFFILE Issue
> I am having something strange going on today with my dev machine. I have an > app that writes a PDF: > > nameconflict="make unique"> > > It has been working great, but today when I ran it I was given an java.io > error that a folder did not exist. > Funny thing was that it was looking at the following path: > > ColdFusion10\cfusion\runtime\work\catalina\localhost\tmp\pdf. > But as you can see in my cffile I am pointing to a local folder called PDF > that is in the same directory > as the .CFM file calling it. Any ideas? CF often writes files to a local temp directory before putting them in their final destination. That's probably what's happening here. Does the temp directory exist? Does CF have permission to write to it? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354885 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFFILE Issue
Yeah, I went the expand path route and pointed it to a pdf directory that was already accepting new vouchers and it works. I On Mar 7, 2013, at 4:05 PM, Bobby wrote: > > I'd probably start by trying one of these instead just to see if it made a > difference: > > ./pdf/voucher#user_id#.pdf > > Or > > #expandPath('./pdf/')# & 'voucher#user_id#.pdf' > > > > On 3/7/13 3:41 PM, "Bruce Sorge" wrote: > >> >> I am having something strange going on today with my dev machine. I have >> an app that writes a PDF: >> >> > nameconflict="make unique"> >> >> It has been working great, but today when I ran it I was given an java.io >> error that a folder did not exist. Funny thing was that it was looking at >> the following path: >> >> ColdFusion10\cfusion\runtime\work\catalina\localhost\tmp\pdf. >> But as you can see in my cffile I am pointing to a local folder called >> PDF that is in the same directory as the .CFM file calling it. Any ideas? >> >> Also, this is a duplicate of another app that I have that does the exact >> same thing, and it works fine. That app is in another directory, and the >> only difference is that this new one allows the site admin to generate a >> PDF for one customer where the other app I have sends PDF's to all users >> who bought something the day prior. >> >> Thanks, >> >> Bruce >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354884 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFFILE Issue
I'd probably start by trying one of these instead just to see if it made a difference: ./pdf/voucher#user_id#.pdf Or #expandPath('./pdf/')# & 'voucher#user_id#.pdf' On 3/7/13 3:41 PM, "Bruce Sorge" wrote: > >I am having something strange going on today with my dev machine. I have >an app that writes a PDF: > >nameconflict="make unique"> > >It has been working great, but today when I ran it I was given an java.io >error that a folder did not exist. Funny thing was that it was looking at >the following path: > >ColdFusion10\cfusion\runtime\work\catalina\localhost\tmp\pdf. >But as you can see in my cffile I am pointing to a local folder called >PDF that is in the same directory as the .CFM file calling it. Any ideas? > >Also, this is a duplicate of another app that I have that does the exact >same thing, and it works fine. That app is in another directory, and the >only difference is that this new one allows the site admin to generate a >PDF for one customer where the other app I have sends PDF's to all users >who bought something the day prior. > >Thanks, > >Bruce > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354883 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFFILE Issue
I am having something strange going on today with my dev machine. I have an app that writes a PDF: It has been working great, but today when I ran it I was given an java.io error that a folder did not exist. Funny thing was that it was looking at the following path: ColdFusion10\cfusion\runtime\work\catalina\localhost\tmp\pdf. But as you can see in my cffile I am pointing to a local folder called PDF that is in the same directory as the .CFM file calling it. Any ideas? Also, this is a duplicate of another app that I have that does the exact same thing, and it works fine. That app is in another directory, and the only difference is that this new one allows the site admin to generate a PDF for one customer where the other app I have sends PDF's to all users who bought something the day prior. Thanks, Bruce ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354881 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Variable or CFFILE issue
Thanks, I will have to try that when I get a chance to. >Might I direct you to the post about parsing the iTunes xml file as >that could be a solution to your problem. > >On 8/19/05, David Critchley <[EMAIL PROTECTED]> wrote: >> ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215838 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Variable or CFFILE issue
Might I direct you to the post about parsing the iTunes xml file as that could be a solution to your problem. On 8/19/05, David Critchley <[EMAIL PROTECTED]> wrote: > We tried running CFFILE on a 72mb file and it died. Our server currently has > 4gb of RAM and 2 processors, all of this is dedicated to my work only, so > this was the only large process running on the server at the time. Tried > several times without success to get it to work. > > Dave C > > > Have you found a limit? I would think it would depend mostly upon how > > much RAM you have on you server. The more RAM you have, the larger > > the file you could read in with CFFILE. > > > > Maybe someone else can expound more on this? Now you've got me curious. > > > > > > Dave > > > > -Original Message- > > From: David Critchley [mailto:[EMAIL PROTECTED] > > Sent: Friday, August 19, 2005 2:37 PM > > To: CF-Talk > > Subject: Variable or CFFILE issue > > > > > > I've tried to do a little digging, but with little success. Im > > looking for the Max Size of a file that the CFFILE tag (Or could be > > the variable) can handle. We regularily parse large files (larger > > than 10mb some upwards around 100mb). Currently we have been > > splitting the file into sections using UNIX, however this is tedious, > > and is a poor fix for the problem. Any info you could provide would > > probably help, or just point me towards the documentation. > > > > Thanks, > > Dave > *> > * > > The information contained in this message, including attachments, may > > contain > > privileged or confidential information that is intended to be > > delivered only to the > > person identified above. If you are not the intended recipient, or the > > person > > responsible for delivering this message to the intended recipient, > > ALLTEL requests > > that you immediately notify the sender and asks that you do not read > > the message or its > > attachments, and that you delete them without copying or sending them > > to anyone else. > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215828 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Variable or CFFILE issue
We tried running CFFILE on a 72mb file and it died. Our server currently has 4gb of RAM and 2 processors, all of this is dedicated to my work only, so this was the only large process running on the server at the time. Tried several times without success to get it to work. Dave C > Have you found a limit? I would think it would depend mostly upon how > much RAM you have on you server. The more RAM you have, the larger > the file you could read in with CFFILE. > > Maybe someone else can expound more on this? Now you've got me curious. > > > Dave > > -Original Message- > From: David Critchley [mailto:[EMAIL PROTECTED] > Sent: Friday, August 19, 2005 2:37 PM > To: CF-Talk > Subject: Variable or CFFILE issue > > > I've tried to do a little digging, but with little success. Im > looking for the Max Size of a file that the CFFILE tag (Or could be > the variable) can handle. We regularily parse large files (larger > than 10mb some upwards around 100mb). Currently we have been > splitting the file into sections using UNIX, however this is tedious, > and is a poor fix for the problem. Any info you could provide would > probably help, or just point me towards the documentation. > > Thanks, > Dave *> * > The information contained in this message, including attachments, may > contain > privileged or confidential information that is intended to be > delivered only to the > person identified above. If you are not the intended recipient, or the > person > responsible for delivering this message to the intended recipient, > ALLTEL requests > that you immediately notify the sender and asks that you do not read > the message or its > attachments, and that you delete them without copying or sending them > to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215823 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Variable or CFFILE issue
Have you found a limit? I would think it would depend mostly upon how much RAM you have on you server. The more RAM you have, the larger the file you could read in with CFFILE. Maybe someone else can expound more on this? Now you've got me curious. Dave -Original Message- From: David Critchley [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 2:37 PM To: CF-Talk Subject: Variable or CFFILE issue I've tried to do a little digging, but with little success. Im looking for the Max Size of a file that the CFFILE tag (Or could be the variable) can handle. We regularily parse large files (larger than 10mb some upwards around 100mb). Currently we have been splitting the file into sections using UNIX, however this is tedious, and is a poor fix for the problem. Any info you could provide would probably help, or just point me towards the documentation. Thanks, Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215819 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Variable or CFFILE issue
I've tried to do a little digging, but with little success. Im looking for the Max Size of a file that the CFFILE tag (Or could be the variable) can handle. We regularily parse large files (larger than 10mb some upwards around 100mb). Currently we have been splitting the file into sections using UNIX, however this is tedious, and is a poor fix for the problem. Any info you could provide would probably help, or just point me towards the documentation. Thanks, Dave ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215817 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFFile Issue
Tom, The lock didn't work. Still gave me the append error. Mosh, Your way worked well doing smaller queries but when doing a real large query where the output file would be like 30+ megs it hung, what I may do is write the file out in smaller more manageable chunks... Jeff > -Original Message- > From: Thomas Chiverton [mailto:[EMAIL PROTECTED] > Sent: Friday, November 05, 2004 6:10 AM > To: CF-Talk > Subject: Re: CFFile Issue > > > On Thursday 04 Nov 2004 16:27 pm, Mosh Teitelbaum wrote: > > I've never run across that problem but it may well be as you > > suggest... some sort of locking error. > > Solution, cflock it exclusivly and see what happens. > > -- > Tom Chiverton ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183486 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFFile Issue
On Thursday 04 Nov 2004 16:27 pm, Mosh Teitelbaum wrote: > I've never run across that problem but it may well be as you suggest... > some sort of locking error. Solution, cflock it exclusivly and see what happens. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183460 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFFile Issue
Jeff Waris wrote: > I loop that query to write each record out to a line in a text file. I use > the code CFFILE ACTION="Append" > > After about 70k it errors out. I get this off the cfcatch variables. Jeff: I've never run across that problem but it may well be as you suggest... some sort of locking error. There is a more efficient way of doing what you want that would likely resolve any locking issues too. Instead of writing each line to the file separately, build the contents of the file in memory and then write it all out in one shot. Something like: -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183368 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CFFile Issue
Something is not right... Has anyone else run across this... I have a query that I write the results to a file using CFFILE. Very simple, albeit its a large result set though. I loop that query to write each record out to a line in a text file. I use the code CFFILE ACTION="Append" After about 70k it errors out. I get this off the cfcatch variables. "An error occurred when performing a file operation Append on file C:\Archive\X.txt." "The cause of this exception was: java.io.IOException: Cannot create a file when that file already exists." My feeling is that there is something locking the file not allowing to be appended to. Has anyone else run across this. Is there a timeout setting anywhere that I might be able to set... This is frustrating because this code worked just fine on CF5? Anyone with any ideas? Thanks... Jeff ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183366 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Cffile issue...
Just a thought, but check your disk quotas if there are any. -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 9:58 AM To: CF-Talk Subject: RE: Cffile issue... No one with any ideas?? I'm still pretty much stumped over this one. > -Original Message- > From: Jeff Waris [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 20, 2004 2:17 PM > To: CF-Talk > Subject: Cffile issue... > > > "An error occurred when performing a file operation Append on file." > > Using CFMX 6.1, all I am doing is taking a query and writing > it out to a file, line by line for each record. It writes > about 70K and it errors out with that message at the top. > Once errored, Coldfusion still has the file. The only way for > Coldfusion to release it is to restart services. > > Anyone have anything similar happen to them? Ideas? > > Thanks, > Jeff ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182520 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Cffile issue...
Jeff, Here's 1. Perhaps the request is timing out with the file handle still open and not terminating correctly. Try setting the "requesttimeout" parameter (use ) to something quite high. -Mark -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 8:58 AM To: CF-Talk Subject: RE: Cffile issue... No one with any ideas?? I'm still pretty much stumped over this one. > -Original Message- > From: Jeff Waris [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 20, 2004 2:17 PM > To: CF-Talk > Subject: Cffile issue... > > > "An error occurred when performing a file operation Append on file." > > Using CFMX 6.1, all I am doing is taking a query and writing > it out to a file, line by line for each record. It writes > about 70K and it errors out with that message at the top. > Once errored, Coldfusion still has the file. The only way for > Coldfusion to release it is to restart services. > > Anyone have anything similar happen to them? Ideas? > > Thanks, > Jeff ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182490 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Cffile issue...
No one with any ideas?? I'm still pretty much stumped over this one. > -Original Message- > From: Jeff Waris [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 20, 2004 2:17 PM > To: CF-Talk > Subject: Cffile issue... > > > "An error occurred when performing a file operation Append on file." > > Using CFMX 6.1, all I am doing is taking a query and writing > it out to a file, line by line for each record. It writes > about 70K and it errors out with that message at the top. > Once errored, Coldfusion still has the file. The only way for > Coldfusion to release it is to restart services. > > Anyone have anything similar happen to them? Ideas? > > Thanks, > Jeff ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182489 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Cffile issue...
"An error occurred when performing a file operation Append on file." Using CFMX 6.1, all I am doing is taking a query and writing it out to a file, line by line for each record. It writes about 70K and it errors out with that message at the top. Once errored, Coldfusion still has the file. The only way for Coldfusion to release it is to restart services. Anyone have anything similar happen to them? Ideas? Thanks, Jeff ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182053 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFFile issue
> I'm displaying a list of photos for "approval" (the filenames are in a > db and the actual photo is displayed by url where they reside on a > remote server), and if files are "disapproved" they're put in a list > then I'm accessing a script on the remote server (where the photos > reside) via cfhttp and asking it to delete the list of files. I'm > getting the error that "The process cannot access the file because it is > being used by another process". I can't conceive of the reason for this. > Anyone have an idea? The fact that I did src="10.10.10.1/photos/temp/1234.jpg"> on the previous page isn't a > process that would prohibit the file from being deleted is it? I've heard that there's a setting in IIS that will lock files when accessed for x amount of time, so you can change that duration in IIS, though I don't have specifics on that handy... I remember someone else on this list ( or possibly the cf newsgroup, not sure ) had a similar problem related to that IIS locking several weeks ago and iirc were able to set the duration to 0 seconds to solve the problem. Isaac Dealey www.turnkey.to 954-776-0046 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFFile issue
I'm displaying a list of photos for "approval" (the filenames are in a db and the actual photo is displayed by url where they reside on a remote server), and if files are "disapproved" they're put in a list then I'm accessing a script on the remote server (where the photos reside) via cfhttp and asking it to delete the list of files. I'm getting the error that "The process cannot access the file because it is being used by another process". I can't conceive of the reason for this. Anyone have an idea? The fact that I did on the previous page isn't a process that would prohibit the file from being deleted is it? Greg Luce eDiets.com 3801 W. Hillsboro Blvd Deerfield Beach, FL 33442 [EMAIL PROTECTED] 954.360.9022 x116 __ 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: CFFILE Issue
while we are on the subject, I posted a general question asking if anyone has used the activex control which allows a drag and drop ftp interface via the browser. has anyone worked with this control in conjunction with cf? Shane Witbeck -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 5:39 PM To: CF-Talk Subject: RE: CFFILE Issue Except, CFFTP won't let you upload files from the client to the CF server, unless they exist on another FTP server somewhere. CFFTP only lets the CF Server talk to FTP Servers, not to the client. Evan > -Original Message- > From: Phoeun Pha [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 04, 2000 2:38 PM > To: CF-Talk > Subject: RE: CFFILE Issue > > > U could use CFFTP, but design it in a way that the interface makes it look > like you're using CFFILE > > > > > -Original Message- > From: Terri Stocke [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 04, 2000 12:04 PM > To: CF-Talk > Subject: CFFILE Issue > > > Hey all, > > I spoke with an Allaire regional tech rep last week who told me in no > uncertain terms that we should NOT be using the CFFILE tag at all > until the > issue they have discovered with it has been resolved. Apparently > there is a > memory leak associated with the CFFILE tag that causes it to hog > up all of > the memory on the CF server, eventually causing it to shutdown. I > do seem to > > recall an issue regarding the CFFILE tag awhile back, but I was unable to > locate any associated articles in the Knowledgebase. > > Unfortunately, the app I need to build requires the ability to > copy/rename/upload files to the server. I have been unable to locate any > documentation on this issue, and I don't have one of the Allaire support > plans. Does anyone have any further information on this? > > Also, what are my alternatives for accomplishing my objective? > > Thanks in advance, > > Terri > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFILE Issue
Yes, I found it strange as well. I would think that for such a MAJOR issue as this one, I would have definitely heard about it before--and there DEFINITELY would have been an article on it somewhere! JFYI, for those of you who have asked--I am using CF 4.0.1 (on NT). I agree fully with your analogy, Billy. I am hoping that there is more to this story. Terri Original Message Follows From: Billy Cravens <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: Re: CFFILE Issue Date: Mon, 04 Dec 2000 14:17:06 -0600 That seems a bit strange. I've seen no major announcement from Allaire, and this seems like a MAJOR issue. You could use a file upload COM object (the way you'd do it in ASP; go to any ASP site to find some). Built-in functionality is ColdFusion's strongest selling point; I really don't want to find out that I have to resort to COM objects (otherwise, I'd use ASP). However, I personally find this unacceptable. File uploading is a major piece of ColdFusion functionality; fixing such a bug should be Priority 1 for Allaire. We paid money for the product expecting it to work. This is a bit analogous to buying a new car, and finding out that the windows don't roll up. Response from the dealership would be, "Um, we're working on that. Just duct tape a trash bag to cover up your window." I suspect that you may have been given incorrect information; if not, I would consider it extremely irresponsible of Allaire to not release this information sooner. I know there's some Allaire folks who monitor the list; could someone from Allaire please address this issue? Otherwise I suspect Allaire will have a few thousand (how many people subscribe to this list?) developers confused and/or misinformed and/or angry. -- Billy Cravens [EMAIL PROTECTED] Terri Stocke wrote: > > Hey all, > > I spoke with an Allaire regional tech rep last week who told me in no > uncertain terms that we should NOT be using the CFFILE tag at all until the > issue they have discovered with it has been resolved. Apparently there is a > memory leak associated with the CFFILE tag that causes it to hog up all of > the memory on the CF server, eventually causing it to shutdown. I do seem to > recall an issue regarding the CFFILE tag awhile back, but I was unable to > locate any associated articles in the Knowledgebase. > > Unfortunately, the app I need to build requires the ability to > copy/rename/upload files to the server. I have been unable to locate any > documentation on this issue, and I don't have one of the Allaire support > plans. Does anyone have any further information on this? > > Also, what are my alternatives for accomplishing my objective? > > Thanks in advance, > > Terri > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE Issue
Except, CFFTP won't let you upload files from the client to the CF server, unless they exist on another FTP server somewhere. CFFTP only lets the CF Server talk to FTP Servers, not to the client. Evan > -Original Message- > From: Phoeun Pha [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 04, 2000 2:38 PM > To: CF-Talk > Subject: RE: CFFILE Issue > > > U could use CFFTP, but design it in a way that the interface makes it look > like you're using CFFILE > > > > > -Original Message- > From: Terri Stocke [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 04, 2000 12:04 PM > To: CF-Talk > Subject: CFFILE Issue > > > Hey all, > > I spoke with an Allaire regional tech rep last week who told me in no > uncertain terms that we should NOT be using the CFFILE tag at all > until the > issue they have discovered with it has been resolved. Apparently > there is a > memory leak associated with the CFFILE tag that causes it to hog > up all of > the memory on the CF server, eventually causing it to shutdown. I > do seem to > > recall an issue regarding the CFFILE tag awhile back, but I was unable to > locate any associated articles in the Knowledgebase. > > Unfortunately, the app I need to build requires the ability to > copy/rename/upload files to the server. I have been unable to locate any > documentation on this issue, and I don't have one of the Allaire support > plans. Does anyone have any further information on this? > > Also, what are my alternatives for accomplishing my objective? > > Thanks in advance, > > Terri > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE Issue
Nope. CFFTP does not move files between your local desktop and the server running CF. It's for connecting to a FTP server FROM the CF server. So...if you were running a FTP server on your desktop, you could do it. But CFFTP is not an alternative to CFFILE. -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 11:38 AM To: CF-Talk Subject: RE: CFFILE Issue U could use CFFTP, but design it in a way that the interface makes it look like you're using CFFILE -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 12:04 PM To: CF-Talk Subject: CFFILE Issue Hey all, I spoke with an Allaire regional tech rep last week who told me in no uncertain terms that we should NOT be using the CFFILE tag at all until the issue they have discovered with it has been resolved. Apparently there is a memory leak associated with the CFFILE tag that causes it to hog up all of the memory on the CF server, eventually causing it to shutdown. I do seem to recall an issue regarding the CFFILE tag awhile back, but I was unable to locate any associated articles in the Knowledgebase. Unfortunately, the app I need to build requires the ability to copy/rename/upload files to the server. I have been unable to locate any documentation on this issue, and I don't have one of the Allaire support plans. Does anyone have any further information on this? Also, what are my alternatives for accomplishing my objective? Thanks in advance, Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFILE Issue
CFFTP only works to transfer files from server to server; you can't use CFFTP to transfer files from client to server (unless the client has an FTP server running, which doesn't really fit into the "browser file upload" paradigm). -- Billy Cravens [EMAIL PROTECTED] Phoeun Pha wrote: > > U could use CFFTP, but design it in a way that the interface makes it look > like you're using CFFILE > > -Original Message- > From: Terri Stocke [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 04, 2000 12:04 PM > To: CF-Talk > Subject: CFFILE Issue > > Hey all, > > I spoke with an Allaire regional tech rep last week who told me in no > uncertain terms that we should NOT be using the CFFILE tag at all until the > issue they have discovered with it has been resolved. Apparently there is a > memory leak associated with the CFFILE tag that causes it to hog up all of > the memory on the CF server, eventually causing it to shutdown. I do seem to > > recall an issue regarding the CFFILE tag awhile back, but I was unable to > locate any associated articles in the Knowledgebase. > > Unfortunately, the app I need to build requires the ability to > copy/rename/upload files to the server. I have been unable to locate any > documentation on this issue, and I don't have one of the Allaire support > plans. Does anyone have any further information on this? > > Also, what are my alternatives for accomplishing my objective? > > Thanks in advance, > > Terri > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE Issue
Try the tag. I think it is more cumbersome for simpling uploading files, but it works. craig thomas: pk interactive nyc : www.pkinteractive.com : vox +1 212.273.9623 : fax +1 212.273.9642 -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 1:04 PM To: CF-Talk Subject: CFFILE Issue Hey all, I spoke with an Allaire regional tech rep last week who told me in no uncertain terms that we should NOT be using the CFFILE tag at all until the issue they have discovered with it has been resolved. Apparently there is a memory leak associated with the CFFILE tag that causes it to hog up all of the memory on the CF server, eventually causing it to shutdown. I do seem to recall an issue regarding the CFFILE tag awhile back, but I was unable to locate any associated articles in the Knowledgebase. Unfortunately, the app I need to build requires the ability to copy/rename/upload files to the server. I have been unable to locate any documentation on this issue, and I don't have one of the Allaire support plans. Does anyone have any further information on this? Also, what are my alternatives for accomplishing my objective? Thanks in advance, Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFILE Issue
That seems a bit strange. I've seen no major announcement from Allaire, and this seems like a MAJOR issue. You could use a file upload COM object (the way you'd do it in ASP; go to any ASP site to find some). Built-in functionality is ColdFusion's strongest selling point; I really don't want to find out that I have to resort to COM objects (otherwise, I'd use ASP). However, I personally find this unacceptable. File uploading is a major piece of ColdFusion functionality; fixing such a bug should be Priority 1 for Allaire. We paid money for the product expecting it to work. This is a bit analogous to buying a new car, and finding out that the windows don't roll up. Response from the dealership would be, "Um, we're working on that. Just duct tape a trash bag to cover up your window." I suspect that you may have been given incorrect information; if not, I would consider it extremely irresponsible of Allaire to not release this information sooner. I know there's some Allaire folks who monitor the list; could someone from Allaire please address this issue? Otherwise I suspect Allaire will have a few thousand (how many people subscribe to this list?) developers confused and/or misinformed and/or angry. -- Billy Cravens [EMAIL PROTECTED] Terri Stocke wrote: > > Hey all, > > I spoke with an Allaire regional tech rep last week who told me in no > uncertain terms that we should NOT be using the CFFILE tag at all until the > issue they have discovered with it has been resolved. Apparently there is a > memory leak associated with the CFFILE tag that causes it to hog up all of > the memory on the CF server, eventually causing it to shutdown. I do seem to > recall an issue regarding the CFFILE tag awhile back, but I was unable to > locate any associated articles in the Knowledgebase. > > Unfortunately, the app I need to build requires the ability to > copy/rename/upload files to the server. I have been unable to locate any > documentation on this issue, and I don't have one of the Allaire support > plans. Does anyone have any further information on this? > > Also, what are my alternatives for accomplishing my objective? > > Thanks in advance, > > Terri > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE Issue
Terri: I haven't personally run into any memory hogging problems with cffile but I've never been involved in a project where it is extensively used. A possible alternative for you could be to set up your server to receive ftp requests and use the cfftp tag instead. Andrew Hewitt Web Application Developer webworld studios, inc. www.wwstudios.com "I don't have a solution, but I admire your problem" -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 1:04 PM To: CF-Talk Subject: CFFILE Issue Hey all, I spoke with an Allaire regional tech rep last week who told me in no uncertain terms that we should NOT be using the CFFILE tag at all until the issue they have discovered with it has been resolved. Apparently there is a memory leak associated with the CFFILE tag that causes it to hog up all of the memory on the CF server, eventually causing it to shutdown. I do seem to recall an issue regarding the CFFILE tag awhile back, but I was unable to locate any associated articles in the Knowledgebase. Unfortunately, the app I need to build requires the ability to copy/rename/upload files to the server. I have been unable to locate any documentation on this issue, and I don't have one of the Allaire support plans. Does anyone have any further information on this? Also, what are my alternatives for accomplishing my objective? Thanks in advance, Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFILE Issue
Hmmm... never heard of that one. Which version of CF? 4.5? Could you try downgrading? Our CF server doesn't seem to have that problem, and we're using 4.5. Possibly you could look at a CFX_FILE tag - I know of one which has the added bonus of better security, however it does not set all the attributes which CFFILE does, which is a pain. David Cummins Terri Stocke wrote: > > Hey all, > > I spoke with an Allaire regional tech rep last week who told me in no > uncertain terms that we should NOT be using the CFFILE tag at all until the > issue they have discovered with it has been resolved. Apparently there is a > memory leak associated with the CFFILE tag that causes it to hog up all of > the memory on the CF server, eventually causing it to shutdown. I do seem to > recall an issue regarding the CFFILE tag awhile back, but I was unable to > locate any associated articles in the Knowledgebase. > > Unfortunately, the app I need to build requires the ability to > copy/rename/upload files to the server. I have been unable to locate any > documentation on this issue, and I don't have one of the Allaire support > plans. Does anyone have any further information on this? > > Also, what are my alternatives for accomplishing my objective? > > Thanks in advance, > > Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE Issue
the only work around I can think of, other than the use of Objects (COM, server side java, or CORBA) would be the use of CFHTTP to post the file and CFFTP for file manipulation. In terms of scalability, and general code re-use/maintenance purposes, this does not seem like a very good alternative to me though. Take a look at what these tags can do in your Studio help files though, they may offer you at least one alternative - even if it's not an elegant one. I'd use some other object for this, if at all possible, before I'd resort to such a work around. You might even be better off using CFEXECUTE (if you're running CF 4.5) and running some commandline or other executable, though a COM Object would still be more elegant. ~Simon > Simon Horwith > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 1:04 PM To: CF-Talk Subject: CFFILE Issue Hey all, I spoke with an Allaire regional tech rep last week who told me in no uncertain terms that we should NOT be using the CFFILE tag at all until the issue they have discovered with it has been resolved. Apparently there is a memory leak associated with the CFFILE tag that causes it to hog up all of the memory on the CF server, eventually causing it to shutdown. I do seem to recall an issue regarding the CFFILE tag awhile back, but I was unable to locate any associated articles in the Knowledgebase. Unfortunately, the app I need to build requires the ability to copy/rename/upload files to the server. I have been unable to locate any documentation on this issue, and I don't have one of the Allaire support plans. Does anyone have any further information on this? Also, what are my alternatives for accomplishing my objective? Thanks in advance, Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFILE Issue
Where is the bug? 4.5.1 ? 4.5.1 SP1 ? 4.5.1 SP2 ? With SP2 I imagine but I wanted to make sure. I thought SP2 was still in beta but maybe its not... Thanks, Ryan At 18:04 12/4/00 -, you wrote: >Hey all, > >I spoke with an Allaire regional tech rep last week who told me in no >uncertain terms that we should NOT be using the CFFILE tag at all until the >issue they have discovered with it has been resolved. Apparently there is a >memory leak associated with the CFFILE tag that causes it to hog up all of >the memory on the CF server, eventually causing it to shutdown. I do seem to >recall an issue regarding the CFFILE tag awhile back, but I was unable to >locate any associated articles in the Knowledgebase. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE Issue
Is this for a particular CF release? I use CFFILE all the time on 4.0.1 Ent ... 2 years now ... and haven't had those problems. -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 10:04 AM To: CF-Talk Subject: CFFILE Issue Hey all, I spoke with an Allaire regional tech rep last week who told me in no uncertain terms that we should NOT be using the CFFILE tag at all until the issue they have discovered with it has been resolved. Apparently there is a memory leak associated with the CFFILE tag that causes it to hog up all of the memory on the CF server, eventually causing it to shutdown. I do seem to recall an issue regarding the CFFILE tag awhile back, but I was unable to locate any associated articles in the Knowledgebase. Unfortunately, the app I need to build requires the ability to copy/rename/upload files to the server. I have been unable to locate any documentation on this issue, and I don't have one of the Allaire support plans. Does anyone have any further information on this? Also, what are my alternatives for accomplishing my objective? Thanks in advance, Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE Issue
U could use CFFTP, but design it in a way that the interface makes it look like you're using CFFILE -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 12:04 PM To: CF-Talk Subject: CFFILE Issue Hey all, I spoke with an Allaire regional tech rep last week who told me in no uncertain terms that we should NOT be using the CFFILE tag at all until the issue they have discovered with it has been resolved. Apparently there is a memory leak associated with the CFFILE tag that causes it to hog up all of the memory on the CF server, eventually causing it to shutdown. I do seem to recall an issue regarding the CFFILE tag awhile back, but I was unable to locate any associated articles in the Knowledgebase. Unfortunately, the app I need to build requires the ability to copy/rename/upload files to the server. I have been unable to locate any documentation on this issue, and I don't have one of the Allaire support plans. Does anyone have any further information on this? Also, what are my alternatives for accomplishing my objective? Thanks in advance, Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFFILE Issue
Hey all, I spoke with an Allaire regional tech rep last week who told me in no uncertain terms that we should NOT be using the CFFILE tag at all until the issue they have discovered with it has been resolved. Apparently there is a memory leak associated with the CFFILE tag that causes it to hog up all of the memory on the CF server, eventually causing it to shutdown. I do seem to recall an issue regarding the CFFILE tag awhile back, but I was unable to locate any associated articles in the Knowledgebase. Unfortunately, the app I need to build requires the ability to copy/rename/upload files to the server. I have been unable to locate any documentation on this issue, and I don't have one of the Allaire support plans. Does anyone have any further information on this? Also, what are my alternatives for accomplishing my objective? Thanks in advance, Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists