Re: Sort by file extension in CFDIRECTORY

2014-07-31 Thread Nick Voss

It does, unfortunately it doesn't have the file extension as part of the 
object, so you'll need to add that column to the query object and run through 
the results separating the file name and filee xtension out to then sort by 
either column interchangeably.

Nick


  I'd look at putting it into a custom query object and using queries 
 of queries.  So loop over the
  cfdirectory output inserting into a new query object that has file 
 extension as a column and use a call
  like (filename,listLen(filename,.)-1,.) to retrieve the 
 extension.  Once it's stored it's a simple matter
  of query of queries to sort the results.
 
 I'm pretty sure that CFDIRECTORY returns a query object that can
 directly be sorted using query of queries.
 
 Dave Watts, CTO, Fig Leaf Software
 1-202-527-9569
 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:359047
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Sort by file extension in CFDIRECTORY

2014-07-31 Thread Dave Watts

 It does, unfortunately it doesn't have the file extension as part of the 
 object, so you'll need to add that column
 to the query object and run through the results separating the file name and 
 filee xtension out to then sort by
 either column interchangeably.

Good point! Sometimes I forget we can't just use ANSI SQL-92 substring
functions in query of queries.

Dave Watts, CTO, Fig Leaf Software
1-202-527-9569
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:359053
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Sort by file extension in CFDIRECTORY

2014-07-30 Thread Richard Colman

Can anyone point to an  easy way to sort the display of CFDIRECTORY 
filenames by file extension, and then perhaps by name?

-- Rick.

~|
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:359036
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Sort by file extension in CFDIRECTORY

2014-07-30 Thread Robert Harrison

Interesting... 

You might be able to use a query of queries after you gotten the file list...

Or you might recourse the directory to get the extension then do a separate 
query on each extension.  

That's an interesting question... I'm going to watch for what others say.

Robert Harrison 
Director of Interactive Services

Austin  Williams
Advertising I Branding I Digital I Direct  
125 Kennedy Drive,  Suite 100   I  Hauppauge, NY 11788
T 631.231.6600 X 119   F 631.434.7022   
http://www.austin-williams.com

Blog:  http://www.austin-williams.com/blog
Twitter:  http://www.twitter.com/austi

~|
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:359037
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Sort by file extension in CFDIRECTORY

2014-07-30 Thread Nick Voss

I'd look at putting it into a custom query object and using queries of queries. 
 So loop over the cfdirectory output inserting into a new query object that has 
file extension as a column and use a call like 
listGetAt(filename,listLen(filename,.)-1,.) to retrieve the extension.  
Once it's stored it's a simple matter of query of queries to sort the results.

Nick

Can anyone point to an  easy way to sort the display of CFDIRECTORY 
filenames by file extension, and then perhaps by name?

-- Rick. 

~|
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:359042
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Sort by file extension in CFDIRECTORY

2014-07-30 Thread Dave Watts

 I'd look at putting it into a custom query object and using queries of 
 queries.  So loop over the
 cfdirectory output inserting into a new query object that has file extension 
 as a column and use a call
 like (filename,listLen(filename,.)-1,.) to retrieve the extension.  Once 
 it's stored it's a simple matter
 of query of queries to sort the results.

I'm pretty sure that CFDIRECTORY returns a query object that can
directly be sorted using query of queries.

Dave Watts, CTO, Fig Leaf Software
1-202-527-9569
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:359043
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Sort by file extension in CFDIRECTORY

2014-07-30 Thread Claude Schnéegans

I finally solved the problem this way:
1. if the page nb. does not exists:
cfheader statuscode=404 statustext=Page not found
CFABORT

2. in IIS I defined a URL to be called in case of error 404, this page displays 
a friendly message, then it also has to declare
cfheader statuscode=404 statustext=Page not found
(fortunately, IIS won't call the URL a second time, and loop)



~|
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:359044
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Sort by file extension in CFDIRECTORY

2014-07-30 Thread Andrew Scott

I think you replied to the wrong thread there

Regards,
Andrew Scott
WebSite: http://www.andyscott.id.au/
Google+:  http://plus.google.com/113032480415921517411



On Thu, Jul 31, 2014 at 11:49 AM,  wrote:


 I finally solved the problem this way:
 1. if the page nb. does not exists:
 cfheader statuscode=404 statustext=Page not found
 CFABORT

 2. in IIS I defined a URL to be called in case of error 404, this page
 displays a friendly message, then it also has to declare
 cfheader statuscode=404 statustext=Page not found
 (fortunately, IIS won't call the URL a second time, and loop)



 

~|
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:359045
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Sort by file extension in CFDIRECTORY

2014-07-30 Thread Claude Schnéegans

 I think you replied to the wrong thread there

Ooops... sorry ;-)


~|
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:359046
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


cfdirectory issue

2014-06-13 Thread Tim Do

I have some code that's been working for years, but recently starting to act 
strange.

Simple cfdirectory looking in a particular folder and listing out some files. 
Users are saying there are files in there and when I go in and check, there 
are! Cfdirectory returns me 0, no errors and DirectoryExists returns no. The 
strange thing is that nothing changes then suddenly half hr or hr later it 
starts to see it again. I can't imagine it being a permissions issue since it 
works intermittently. Any ideas? Thanks in advance...


Sample disclaimer text




~|
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:358713
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cfdirectory issue

2014-06-13 Thread Russ Michaels

Is the path you are reading from cached in application scope maybe or
another cache method.
In which case trying dumping out thr path when its broke and see if it is
correct.

Russ Michaels
www.michaels.me.uk
cfmldeveloper.com
cflive.net
cfsearch.com
On 13 Jun 2014 23:39, Tim Do t...@wng.com wrote:


 I have some code that's been working for years, but recently starting to
 act strange.

 Simple cfdirectory looking in a particular folder and listing out some
 files. Users are saying there are files in there and when I go in and
 check, there are! Cfdirectory returns me 0, no errors and DirectoryExists
 returns no. The strange thing is that nothing changes then suddenly half hr
 or hr later it starts to see it again. I can't imagine it being a
 permissions issue since it works intermittently. Any ideas? Thanks in
 advance...

 
 Sample disclaimer text




 

~|
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:358714
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cfdirectory issue

2014-06-13 Thread Byron Mann

First I would check the obvious and verify permissions, you just never
know.

Is this anything like a directory on a file share? Could just be an
availability thing then.

Anything new outside of code changes? Patches? Other new software installed
on the server?

Any other software or process possibly locking the directory? Virus
scanning? Some other new code unrelated? Is the directory growing and now
has a large number of files or directories, Windows doesn't like that so
much pre 2008.

My first instinct says that another process is doing something occasionally
to the directory or files.

Might be good to see some code and what version you are on. Are sandboxes
in use?

I have seen things like creating a file or directory via CF and then
accessing that in the next few lines it doesn't exist yet, but that was
previous versions, have not seen that with 10±.

Byron Mann
Lead Engineer  Architect
HostMySite.com
On Jun 13, 2014 6:38 PM, Tim Do t...@wng.com wrote:


 I have some code that's been working for years, but recently starting to
 act strange.

 Simple cfdirectory looking in a particular folder and listing out some
 files. Users are saying there are files in there and when I go in and
 check, there are! Cfdirectory returns me 0, no errors and DirectoryExists
 returns no. The strange thing is that nothing changes then suddenly half hr
 or hr later it starts to see it again. I can't imagine it being a
 permissions issue since it works intermittently. Any ideas? Thanks in
 advance...

 
 Sample disclaimer text




 

~|
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:358732
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: cfdirectory

2012-10-31 Thread Stephens, Larry V

We have it working now. Thanks.

 

-Original Message-
From: Stephens, Larry V [mailto:steph...@iu.edu] 
Sent: Tuesday, October 30, 2012 9:32 AM
To: cf-talk
Subject: RE: cfdirectory


Thanks. We're going to address rights to see if that makes it work.

 

-Original Message-
From: Carl Von Stetten [mailto:vonner.li...@vonner.net] 
Sent: Monday, October 29, 2012 5:04 PM
To: cf-talk
Subject: Re: cfdirectory


This should work, so you need to address the rights issue.  What Windows 
user account is the ColdFusion service running under?  If you have it 
running as a specific Active Directory account, you need to modify the 
fileserver folder to grant Read access to that account.

-Carl V.

On 10/29/2012 2:00 PM, Stephens, Larry V wrote:
 Running CF10 on IIS7.5 on Windows server 2008R2 on Server Z

 Filerserver (O) running on 2008R2

 I want to do a cfdirectory to the fileserver to list the contents of a 
 directory.

 Directory=\\UNC\path... name=MyDir (where \\UNC\path... relates to the 
 fileserver) yields nothing when I dump MyDir.

 We found a note at 
 http://www.asadesigner.com/16-coldfusion/c1788fe8b3536edc.htm tells us this 
 is a rights issue.

 (I'm wanting to list the contents of a specific sub-directory, the name of 
 which I can determine programmatically - and would be photos - so I can 
 display a list of those images and allow my user to click a constructed link 
 and see the image.)

 Other than cfdirectory, is there a good way to display a directory listing 
 that comes back as query results that I can loop and display on a page? 
 Incorporate something in C? In vbScript?



 





~|
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:353035
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: cfdirectory

2012-10-30 Thread Stephens, Larry V

Thanks. We're going to address rights to see if that makes it work.

 

-Original Message-
From: Carl Von Stetten [mailto:vonner.li...@vonner.net] 
Sent: Monday, October 29, 2012 5:04 PM
To: cf-talk
Subject: Re: cfdirectory


This should work, so you need to address the rights issue.  What Windows 
user account is the ColdFusion service running under?  If you have it 
running as a specific Active Directory account, you need to modify the 
fileserver folder to grant Read access to that account.

-Carl V.

On 10/29/2012 2:00 PM, Stephens, Larry V wrote:
 Running CF10 on IIS7.5 on Windows server 2008R2 on Server Z

 Filerserver (O) running on 2008R2

 I want to do a cfdirectory to the fileserver to list the contents of a 
 directory.

 Directory=\\UNC\path... name=MyDir (where \\UNC\path... relates to the 
 fileserver) yields nothing when I dump MyDir.

 We found a note at 
 http://www.asadesigner.com/16-coldfusion/c1788fe8b3536edc.htm tells us this 
 is a rights issue.

 (I'm wanting to list the contents of a specific sub-directory, the name of 
 which I can determine programmatically - and would be photos - so I can 
 display a list of those images and allow my user to click a constructed link 
 and see the image.)

 Other than cfdirectory, is there a good way to display a directory listing 
 that comes back as query results that I can loop and display on a page? 
 Incorporate something in C? In vbScript?



 



~|
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:353020
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cfdirectory

2012-10-30 Thread Dave Watts

 This should work, so you need to address the rights issue.  What Windows
 user account is the ColdFusion service running under?  If you have it
 running as a specific Active Directory account, you need to modify the
 fileserver folder to grant Read access to that account.

And to add to this, if you don't have CF running as a specific AD
account, but as the default (Local System), it will not have rights to
any network resources at all and you can't really change that.

I recommend you read the CF 9 Lockdown document that's on the Adobe
site, and use that as a guide for configuring the service user
account.

http://www.adobe.com/products/coldfusion/whitepapers/pdf/91025512_cf9_lockdownguide_wp_ue.pdf

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:353021
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: cfdirectory

2012-10-30 Thread DURETTE, STEVEN J

Sorry to say that link now takes you to the Adobe ColdFusion 10 product page.  

-Original Message-

And to add to this, if you don't have CF running as a specific AD
account, but as the default (Local System), it will not have rights to
any network resources at all and you can't really change that.

I recommend you read the CF 9 Lockdown document that's on the Adobe
site, and use that as a guide for configuring the service user
account.

http://www.adobe.com/products/coldfusion/whitepapers/pdf/91025512_cf9_lockdownguide_wp_ue.pdf

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:353022
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cfdirectory

2012-10-30 Thread Dave Watts

   And to add to this, if you don't have CF running as a specific AD
   account, but as the default (Local System), it will not have rights to
   any network resources at all and you can't really change that.
 
  I recommend you read the CF 9 Lockdown document that's on the Adobe
  site, and use that as a guide for configuring the service user
  account.
 
  http://www.adobe.com/products/coldfusion/whitepapers/pdf/91025512_cf9_lockdownguide_wp_ue.pdf

 Sorry to say that link now takes you to the Adobe ColdFusion 10 product page.

Here's the new, improved link:

http://wwwimages.adobe.com/www.adobe.com/content/dam/Adobe/en/products/coldfusion/pdfs/91025512-cf9-lockdownguide-wp-ue.pdf

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:353023
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


cfdirectory

2012-10-29 Thread Stephens, Larry V

Running CF10 on IIS7.5 on Windows server 2008R2 on Server Z

Filerserver (O) running on 2008R2

I want to do a cfdirectory to the fileserver to list the contents of a 
directory.

Directory=\\UNC\path... name=MyDir (where \\UNC\path... relates to the 
fileserver) yields nothing when I dump MyDir.

We found a note at 
http://www.asadesigner.com/16-coldfusion/c1788fe8b3536edc.htm tells us this is 
a rights issue.

(I'm wanting to list the contents of a specific sub-directory, the name of 
which I can determine programmatically - and would be photos - so I can display 
a list of those images and allow my user to click a constructed link and see 
the image.)

Other than cfdirectory, is there a good way to display a directory listing that 
comes back as query results that I can loop and display on a page? Incorporate 
something in C? In vbScript?



~|
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:353017
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cfdirectory

2012-10-29 Thread Carl Von Stetten

This should work, so you need to address the rights issue.  What Windows 
user account is the ColdFusion service running under?  If you have it 
running as a specific Active Directory account, you need to modify the 
fileserver folder to grant Read access to that account.

-Carl V.

On 10/29/2012 2:00 PM, Stephens, Larry V wrote:
 Running CF10 on IIS7.5 on Windows server 2008R2 on Server Z

 Filerserver (O) running on 2008R2

 I want to do a cfdirectory to the fileserver to list the contents of a 
 directory.

 Directory=\\UNC\path... name=MyDir (where \\UNC\path... relates to the 
 fileserver) yields nothing when I dump MyDir.

 We found a note at 
 http://www.asadesigner.com/16-coldfusion/c1788fe8b3536edc.htm tells us this 
 is a rights issue.

 (I'm wanting to list the contents of a specific sub-directory, the name of 
 which I can determine programmatically - and would be photos - so I can 
 display a list of those images and allow my user to click a constructed link 
 and see the image.)

 Other than cfdirectory, is there a good way to display a directory listing 
 that comes back as query results that I can loop and display on a page? 
 Incorporate something in C? In vbScript?



 

~|
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:353018
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFDirectory on mapped drives

2011-07-13 Thread Russ Michaels

c:\coldfusion\runtime\lib\wsconfig

or just edit the handler mappings in IIS to see where it points.



On Wed, Jul 13, 2011 at 12:28 AM, Dave Watts dwa...@figleaf.com wrote:


  The ISAPI extensions used by CF... If I used the web connector to tie CF
 to
  IIS do you perchance know where those might be? Just now switching over
 from
  Apache and kind of blind on stuff like this.

 Typically, they're in the CF install directory somewhere, in the
 wsconfig folder.

 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:346212
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFDirectory on mapped drives

2011-07-12 Thread Russ Michaels

sorry should have been this link

http://www.adobe.com/products/coldfusion/whitepapers/pdf/91025512_cf9_lockdownguide_wp_ue.pdf

On Tue, Jul 12, 2011 at 5:18 AM, David McGuigan davidmcgui...@gmail.comwrote:


 Thanks Russ.

 I'm not sure what you wanted me to see in that link, maybe the fact that
 you
 can have multiple admin logins now?

 If it's a totally dedicated box and we only have 1 developer's code
 running,
 is it still a security risk? I tried running it as a limited account and
 even set full permissions on every file in the webroot but still got an
 immediate IIS 500 error until I flipped it to either the local system
 account or an admin.

 Thanks!
 David


 On Mon, Jul 11, 2011 at 11:17 AM, Russ Michaels r...@michaels.me.uk
 wrote:

 
  sorry I didn't read all of your post, I see your final paragraph asking
 if
  you must do this, and the answer is yes.
  however do not run CF as an administrator as this will open up your
  security
  and allow every cfm page to run with administrator access, you need to
 run
  it as a limited user that can only do what you need it to do.
 
  see this security white paper
 
 
 
 http://www.adobe.com/products/coldfusion/pdfs/coldfusion_8_product_security_brief.pdf
 
  Russ
 
  On Mon, Jul 11, 2011 at 6:11 PM, Russ Michaels r...@michaels.me.uk
  wrote:
 
  
   If you are just using the default installation and running cf as
 system
   then you will have problems access network paths.
   You need to set CF to run under a user account that have network
 access.
  
   Russ
  
  
   On Mon, Jul 11, 2011 at 5:40 PM, David McGuigan 
 davidmcgui...@gmail.com
  wrote:
  
  
   I've triple checked that an empty folder on a 2nd server in the same
   datacenter allows full write permissions for any type of user, and
 have
  it
   mapped from the CF server. But when I run cfdirectory calls, for lists
  it
   returns an empty query even if there are subfolders or files there,
 for
   rename calls it claims that the target subfolder doesn't exist, and
 for
   create calls it simply errors: the specified directory could not be
   created.
  
   Is there some best practice way to set this up with CF? Do I have to
   configure the windows service of the CF box to run as an identical
 user
  to
   one on the recipient box? If so other than making sure it's an
   administrator
   is there anything else I need to do?
  
   Thanks guys.
  
  
  
 
 

 

~|
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:346188
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFDirectory on mapped drives

2011-07-12 Thread Dave Watts

 If it's a totally dedicated box and we only have 1 developer's code running,
 is it still a security risk?

Yes, absolutely.

 I tried running it as a limited account and even set full permissions on 
 every file in the
 webroot but still got an immediate IIS 500 error until I flipped it to either 
 the local system
 account or an admin.

You must also set read/execute permissions on the directory containing
the CF install and the directory containing the ISAPI extensions used
by CF.

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:346206
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFDirectory on mapped drives

2011-07-12 Thread David McGuigan

Thanks Dave!

I'll try that out tonight.

The ISAPI extensions used by CF... If I used the web connector to tie CF to
IIS do you perchance know where those might be? Just now switching over from
Apache and kind of blind on stuff like this.


On Tue, Jul 12, 2011 at 4:50 PM, Dave Watts dwa...@figleaf.com wrote:


  If it's a totally dedicated box and we only have 1 developer's code
 running,
  is it still a security risk?

 Yes, absolutely.

  I tried running it as a limited account and even set full permissions on
 every file in the
  webroot but still got an immediate IIS 500 error until I flipped it to
 either the local system
  account or an admin.

 You must also set read/execute permissions on the directory containing
 the CF install and the directory containing the ISAPI extensions used
 by CF.

 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:346207
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFDirectory on mapped drives

2011-07-12 Thread Dave Watts

 The ISAPI extensions used by CF... If I used the web connector to tie CF to
 IIS do you perchance know where those might be? Just now switching over from
 Apache and kind of blind on stuff like this.

Typically, they're in the CF install directory somewhere, in the
wsconfig folder.

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:346209
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


CFDirectory on mapped drives

2011-07-11 Thread David McGuigan

I've triple checked that an empty folder on a 2nd server in the same
datacenter allows full write permissions for any type of user, and have it
mapped from the CF server. But when I run cfdirectory calls, for lists it
returns an empty query even if there are subfolders or files there, for
rename calls it claims that the target subfolder doesn't exist, and for
create calls it simply errors: the specified directory could not be created.

Is there some best practice way to set this up with CF? Do I have to
configure the windows service of the CF box to run as an identical user to
one on the recipient box? If so other than making sure it's an administrator
is there anything else I need to do?

Thanks guys.


~|
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:346178
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFDirectory on mapped drives

2011-07-11 Thread Russ Michaels

If you are just using the default installation and running cf as system
then you will have problems access network paths.
You need to set CF to run under a user account that have network access.

Russ

On Mon, Jul 11, 2011 at 5:40 PM, David McGuigan davidmcgui...@gmail.comwrote:


 I've triple checked that an empty folder on a 2nd server in the same
 datacenter allows full write permissions for any type of user, and have it
 mapped from the CF server. But when I run cfdirectory calls, for lists it
 returns an empty query even if there are subfolders or files there, for
 rename calls it claims that the target subfolder doesn't exist, and for
 create calls it simply errors: the specified directory could not be
 created.

 Is there some best practice way to set this up with CF? Do I have to
 configure the windows service of the CF box to run as an identical user to
 one on the recipient box? If so other than making sure it's an
 administrator
 is there anything else I need to do?

 Thanks guys.


 

~|
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:346181
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFDirectory on mapped drives

2011-07-11 Thread Russ Michaels

sorry I didn't read all of your post, I see your final paragraph asking if
you must do this, and the answer is yes.
however do not run CF as an administrator as this will open up your security
and allow every cfm page to run with administrator access, you need to run
it as a limited user that can only do what you need it to do.

see this security white paper

http://www.adobe.com/products/coldfusion/pdfs/coldfusion_8_product_security_brief.pdf

Russ

On Mon, Jul 11, 2011 at 6:11 PM, Russ Michaels r...@michaels.me.uk wrote:


 If you are just using the default installation and running cf as system
 then you will have problems access network paths.
 You need to set CF to run under a user account that have network access.

 Russ


 On Mon, Jul 11, 2011 at 5:40 PM, David McGuigan 
 davidmcgui...@gmail.comwrote:


 I've triple checked that an empty folder on a 2nd server in the same
 datacenter allows full write permissions for any type of user, and have it
 mapped from the CF server. But when I run cfdirectory calls, for lists it
 returns an empty query even if there are subfolders or files there, for
 rename calls it claims that the target subfolder doesn't exist, and for
 create calls it simply errors: the specified directory could not be
 created.

 Is there some best practice way to set this up with CF? Do I have to
 configure the windows service of the CF box to run as an identical user to
 one on the recipient box? If so other than making sure it's an
 administrator
 is there anything else I need to do?

 Thanks guys.


 

~|
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:346182
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFDirectory on mapped drives

2011-07-11 Thread David McGuigan

Thanks Russ.

I'm not sure what you wanted me to see in that link, maybe the fact that you
can have multiple admin logins now?

If it's a totally dedicated box and we only have 1 developer's code running,
is it still a security risk? I tried running it as a limited account and
even set full permissions on every file in the webroot but still got an
immediate IIS 500 error until I flipped it to either the local system
account or an admin.

Thanks!
David


On Mon, Jul 11, 2011 at 11:17 AM, Russ Michaels r...@michaels.me.uk wrote:


 sorry I didn't read all of your post, I see your final paragraph asking if
 you must do this, and the answer is yes.
 however do not run CF as an administrator as this will open up your
 security
 and allow every cfm page to run with administrator access, you need to run
 it as a limited user that can only do what you need it to do.

 see this security white paper


 http://www.adobe.com/products/coldfusion/pdfs/coldfusion_8_product_security_brief.pdf

 Russ

 On Mon, Jul 11, 2011 at 6:11 PM, Russ Michaels r...@michaels.me.uk
 wrote:

 
  If you are just using the default installation and running cf as system
  then you will have problems access network paths.
  You need to set CF to run under a user account that have network access.
 
  Russ
 
 
  On Mon, Jul 11, 2011 at 5:40 PM, David McGuigan davidmcgui...@gmail.com
 wrote:
 
 
  I've triple checked that an empty folder on a 2nd server in the same
  datacenter allows full write permissions for any type of user, and have
 it
  mapped from the CF server. But when I run cfdirectory calls, for lists
 it
  returns an empty query even if there are subfolders or files there, for
  rename calls it claims that the target subfolder doesn't exist, and for
  create calls it simply errors: the specified directory could not be
  created.
 
  Is there some best practice way to set this up with CF? Do I have to
  configure the windows service of the CF box to run as an identical user
 to
  one on the recipient box? If so other than making sure it's an
  administrator
  is there anything else I need to do?
 
  Thanks guys.
 
 
 

 

~|
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:346186
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


CFDIRECTORY of a mapped network drive

2011-06-29 Thread Terry Troxel

It just might help if I pasted in the code.sorry.

 What am I doing wrong here as nothing shows up even with debugging turned
 on.
 The S drive is a mapped network drive.
 If mapped drive is the issue, is there any way around it?

 Terry


cfset dir=s:\
cfdirectory
   action=list
   directory=#dir#
   filter=*.*
   name=slides
   sort=name
table
cfoutput query=slides
trtd/tdtd#name#/td/tr
/cfoutput
/table


~|
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:345930
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFDIRECTORY of a mapped network drive

2011-06-29 Thread Dave Watts

 What am I doing wrong here as nothing shows up even with debugging turned on.
 The S drive is a mapped network drive. If mapped drive is the issue, is there 
 any way around it?

By default, there are two problems with using mapped drives from CF.

First, CF runs as SYSTEM by default, and SYSTEM has no access to
network resources.

Second, if you run CF as another user with explicit permissions to a
network share, CF can access that network share. But that doesn't mean
that CF can access a drive mapping. For that to work, you'd need to
log in as the user in question and create a persistent drive mapping.
Instead, I'd recommend just accessing the UNC path directly rather
than bothering with a drive mapping.

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:345932
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFDIRECTORY of a mapped network drive

2011-06-29 Thread Leigh

 By default, there are two problems with using mapped drives
 from CF.

Anyone know if those two tips are in the official documentation anywhere? I 
looked, but may have missed it .. 

~|
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:345935
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFDIRECTORY of a mapped network drive

2011-06-29 Thread Dave Watts

  By default, there are two problems with using mapped drives
  from CF.

 Anyone know if those two tips are in the official documentation anywhere? I 
 looked, but may have missed it ..

I would expect that they aren't. They're really not specific to CF,
but rather to how Windows and services work.

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:345937
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFDIRECTORY of a mapped network drive

2011-06-29 Thread Leigh

 They're really not
 specific to CF,
 but rather to how Windows and services work.

True. But the cfdirectory + mapped drive question comes up frequently. Seems 
worthy of a trouble-shooting note or a comment at least. 

~|
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:345938
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


cfdirectory -- Element ROWCOUNT is undefined in MYFILELIST.

2010-11-17 Thread Aaron Renfroe

Hello Everyone!

I'm trying to use the cfdirectory to see if a image file exists on my remote 
server.

Here is my code:

cfdirectory action=list directory=C:/Websites/176663mf4/images/rad_images/ 
filter=#PartNumber#.jpg name=myFileList

cfif myFileList.RowCount gt 0
do something
cfelse
do something else 
/cfif

The site is hosted on a shared server, i took the above path (hoping its my 
absolute path) from the error it threw. I'm trying to get the hosting company 
to supply me with the path. Does the above code look correct? Could it be my 
directory path?

Thanks!

Aaron



~|
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:339309
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cfdirectory -- Element ROWCOUNT is undefined in MYFILELIST.

2010-11-17 Thread Claude Schnéegans

Hi,

Try recordCount instead of rowCount.

~|
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:339310
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cfdirectory -- Element ROWCOUNT is undefined in MYFILELIST.

2010-11-17 Thread Aaron M Renfroe

That was it Thanks!!!

On Wed, Nov 17, 2010 at 10:15 AM,  wrote:


 Hi,

 Try recordCount instead of rowCount.

 

~|
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:339311
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Query of query with cfdirectory

2009-11-17 Thread Stefan Richter

Hi all,
The task at hand is to find a series of orphaned folders. I want to delete all 
folders in a certain directory which do not have a matching DB record.

I was wondering if this is possible (or accept any other tips): 

I have a 'query' which is the result of a cfdirectory action=list. I now 
would like to find any records in that query that do not exist in the resultset 
of a second query (this second one is a database query).
Is there a way to combine these two queries to get a resultset that just holds 
those items which do not exist in the second query? I know i could loop and 
query each record but wondered if there's a more efficient way, maybe a query 
of two other queries?

Cheers 

Stefan






~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328465
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Query of query with cfdirectory

2009-11-17 Thread brad

Try Googling left outer join in a ColdFusion query of query.

If you have the two result sets there, left outer the DB list to the
directory list to find items in the directory for which there is no
matching database record.

As for performance, depending on the size of the result sets (less than
5-6 thousand records), you might get just as much performance by simply
looping over the directory list and doing a q of q for each item on the
database list.

Just try it see how it performs.  If this is just a nightly job you
might not even care how long it takes.


~Brad

 Original Message 
Subject: Query of query with cfdirectory
From: Stefan Richter ste...@flashcomguru.com
Date: Tue, November 17, 2009 10:13 am
To: cf-talk cf-talk@houseoffusion.com


Hi all,
The task at hand is to find a series of orphaned folders. I want to
delete all folders in a certain directory which do not have a matching
DB record.

I was wondering if this is possible (or accept any other tips): 

I have a 'query' which is the result of a cfdirectory action=list. I
now would like to find any records in that query that do not exist in
the resultset of a second query (this second one is a database query).
Is there a way to combine these two queries to get a resultset that just
holds those items which do not exist in the second query? I know i could
loop and query each record but wondered if there's a more efficient way,
maybe a query of two other queries?

Cheers 

Stefan





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328467
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Query of query with cfdirectory

2009-11-17 Thread Stefan Richter

Thank you.

With the help of a friend we've now come up with this which seems to do the job:

cfquery datasource=datasource name=getSlides
SELECT myslide from slides
/cfquery

cfdirectory action=list directory=C:\uploadsdir name=uploads 

cfquery dbtype=query name=orphans
SELECT *
FROM uploads
WHERE uploads.name not in (#QuotedValueList(getSlides.myslide)#)
/cfquery



Stefan



On 17 Nov 2009, at 16:31, b...@bradwood.com wrote:

 
 Try Googling left outer join in a ColdFusion query of query.
 
 If you have the two result sets there, left outer the DB list to the
 directory list to find items in the directory for which there is no
 matching database record.
 
 As for performance, depending on the size of the result sets (less than
 5-6 thousand records), you might get just as much performance by simply
 looping over the directory list and doing a q of q for each item on the
 database list.
 
 Just try it see how it performs.  If this is just a nightly job you
 might not even care how long it takes.
 
 
 ~Brad
 
  Original Message 
 Subject: Query of query with cfdirectory
 From: Stefan Richter ste...@flashcomguru.com
 Date: Tue, November 17, 2009 10:13 am
 To: cf-talk cf-talk@houseoffusion.com
 
 
 Hi all,
 The task at hand is to find a series of orphaned folders. I want to
 delete all folders in a certain directory which do not have a matching
 DB record.
 
 I was wondering if this is possible (or accept any other tips): 
 
 I have a 'query' which is the result of a cfdirectory action=list. I
 now would like to find any records in that query that do not exist in
 the resultset of a second query (this second one is a database query).
 Is there a way to combine these two queries to get a resultset that just
 holds those items which do not exist in the second query? I know i could
 loop and query each record but wondered if there's a more efficient way,
 maybe a query of two other queries?
 
 Cheers 
 
 Stefan
 
 
 
 
 
 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328473
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: using cffile and cfdirectory to create tinyURL-style aliases

2009-03-27 Thread Cameron Johnson

Single quotes. Single quotes. (sigh) Thanks, Barney.

The answer is that I needed the result to be consistent with what I've been 
doing manually for two years: creating directories and index.cfm files on the 
web server to get URLs like www.example.com/go/myURL. I wanted to create a 
quick add/edit/delete form so the marketing staff can manage these aliases 
themselves. Given the correct syntax, I knew this would work and it would 
produce the results I needed.

That said, with this stable, I'll now look at a rewrite script to produce the 
same result. 

Before I dive in, can anyone point me to a good rewrite script that would give 
me: www.example.com/go/myURL 

Thanks for the info, and thanks for the 301 v 302 education. 

Cameron


cfset fileOutput = 'cflocation url=#longURL# addtoken=false /' /

One might ask why you're using directories and CFM files to accomplish
this task.  Every web server supports rewriting engines which would
allow you to use a single script and a database to accomplish this
task in a far more streamlined fashion.

Further, you almost certainly want to be doing a 301 instead of a 302
to the long URL, which CFLOCATION doesn't provide.  If you opt to
continue down this route, probably want to use CFHEADER instead.

cheers,
barneyb

On Thu, Mar 26, 2009 at 4:43 PM, Camer
 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321041
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: using cffile and cfdirectory to create tinyURL-style aliases

2009-03-27 Thread Barney Boisvert

 Before I dive in, can anyone point me to a good rewrite script that would 
 give me: www.example.com/go/myURL

If you're using Apache, mod_rewrite.  If IIS, then isapi_rewrite.
I've not used the latter as Apache is all I use, Linux and Windows.
In either case, you just need this (roughly):

RewriteRule ^/go/([^/])/?$  /go.cfm?key=$1  [PT,L]

cheers,
barneyb

On Fri, Mar 27, 2009 at 8:43 AM, Cameron Johnson john...@nais.org wrote:

 Single quotes. Single quotes. (sigh) Thanks, Barney.

 The answer is that I needed the result to be consistent with what I've been 
 doing manually for two years: creating directories and index.cfm files on the 
 web server to get URLs like www.example.com/go/myURL. I wanted to create a 
 quick add/edit/delete form so the marketing staff can manage these aliases 
 themselves. Given the correct syntax, I knew this would work and it would 
 produce the results I needed.

 That said, with this stable, I'll now look at a rewrite script to produce the 
 same result.

 Before I dive in, can anyone point me to a good rewrite script that would 
 give me: www.example.com/go/myURL

 Thanks for the info, and thanks for the 301 v 302 education.

 Cameron


cfset fileOutput = 'cflocation url=#longURL# addtoken=false /' /

One might ask why you're using directories and CFM files to accomplish
this task.  Every web server supports rewriting engines which would
allow you to use a single script and a database to accomplish this
task in a far more streamlined fashion.

Further, you almost certainly want to be doing a 301 instead of a 302
to the long URL, which CFLOCATION doesn't provide.  If you opt to
continue down this route, probably want to use CFHEADER instead.

cheers,
barneyb

On Thu, Mar 26, 2009 at 4:43 PM, Camer


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321043
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


using cffile and cfdirectory to create tinyURL-style aliases

2009-03-26 Thread Cameron Johnson

Hi, all.

I've been out of coding for too long and I can't figure this one out.

Simple, really: using CFDIRECTORY and CFFILE, I want to create a folder, drop 
in an index.cfm file, then put a cflocation tag in that index.cfm file.

!--- create directory  ---
cfdirectory action=CREATE directory=d:\test\#newDirectory# /

!--- create index.cfm file in new directory  ---
cffile action=WRITE file=d:\test\#newDirectory#\index.cfm 
output=#fileOutput# /

What I can't solve is how to write the CFLOCATION tag into the fileOutput 
variable. The resulting tag will be:

cflocation url=#longURL# addtoken=false /

I tried putting that into a CFSAVECONTENT, but that was actually processing the 
the redirect. 

Any help here? 

Thanks,

Cameron


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321021
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: using cffile and cfdirectory to create tinyURL-style aliases

2009-03-26 Thread brad

Will this work?

cfset myLongPath = http://my.long.path.com/;
cfset fileContents = cflocation url=  myLongPath  
addtoken=false /
cffile action=WRITE file=d:\test\#newDirectory#\index.cfm
output=#fileContents # /

~Brad

 Original Message 
Subject: using cffile and cfdirectory to create tinyURL-style aliases
From: Cameron Johnson john...@nais.org
Date: Thu, March 26, 2009 6:43 pm
To: cf-talk cf-talk@houseoffusion.com


Hi, all.

I've been out of coding for too long and I can't figure this one out.

Simple, really: using CFDIRECTORY and CFFILE, I want to create a folder,
drop in an index.cfm file, then put a cflocation tag in that index.cfm
file.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321022
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: using cffile and cfdirectory to create tinyURL-style aliases

2009-03-26 Thread Barney Boisvert

cfset fileOutput = 'cflocation url=#longURL# addtoken=false /' /

One might ask why you're using directories and CFM files to accomplish
this task.  Every web server supports rewriting engines which would
allow you to use a single script and a database to accomplish this
task in a far more streamlined fashion.

Further, you almost certainly want to be doing a 301 instead of a 302
to the long URL, which CFLOCATION doesn't provide.  If you opt to
continue down this route, probably want to use CFHEADER instead.

cheers,
barneyb

On Thu, Mar 26, 2009 at 4:43 PM, Cameron Johnson john...@nais.org wrote:

 Hi, all.

 I've been out of coding for too long and I can't figure this one out.

 Simple, really: using CFDIRECTORY and CFFILE, I want to create a folder, drop 
 in an index.cfm file, then put a cflocation tag in that index.cfm file.

 !--- create directory  ---
 cfdirectory action=CREATE directory=d:\test\#newDirectory# /

 !--- create index.cfm file in new directory  ---
 cffile action=WRITE file=d:\test\#newDirectory#\index.cfm 
 output=#fileOutput# /

 What I can't solve is how to write the CFLOCATION tag into the fileOutput 
 variable. The resulting tag will be:

 cflocation url=#longURL# addtoken=false /

 I tried putting that into a CFSAVECONTENT, but that was actually processing 
 the the redirect.

 Any help here?

 Thanks,

 Cameron


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321023
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: using cffile and cfdirectory to create tinyURL-style aliases

2009-03-26 Thread Justin Scott

 Further, you almost certainly want to be doing a 301
 instead of a 302 to the long URL, which CFLOCATION
 doesn't provide.  If you opt to continue down this
 route, probably want to use CFHEADER instead.

CFLOCATION supports a statusCode attribute as of ColdFusion 8 which you can
use to return a 301 code instead of the default 302 if needed.


--
Justin Scott | GravityFree
Member of the Technical Staff

1960 Stickney Point Road, Suite 210
Sarasota | FL | 34231 | 800.207.4431
941.927.7674 x115 | f 941.923.5429
www.GravityFree.com


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321028
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: using cffile and cfdirectory to create tinyURL-style aliases

2009-03-26 Thread James Holmes

Actually, as of CF8, CFLOCATION does support status codes other than 302:

http://www.cfquickdocs.com/cf8/?getDoc=cflocation

mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/



2009/3/27 Barney Boisvert bboisv...@gmail.com:
 Further, you almost certainly want to be doing a 301 instead of a 302
 to the long URL, which CFLOCATION doesn't provide.  If you opt to
 continue down this route, probably want to use CFHEADER instead

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321029
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: using cffile and cfdirectory to create tinyURL-style aliases

2009-03-26 Thread Barney Boisvert

Well would you look at that.  Must be learnin' week for Barney this
week.  Thanks for pointing that out, guys.

cheers,
barneyb

On 3/26/09, James Holmes james.hol...@gmail.com wrote:

 Actually, as of CF8, CFLOCATION does support status codes other than 302:

 http://www.cfquickdocs.com/cf8/?getDoc=cflocation

 mxAjax / CFAjax docs and other useful articles:
 http://www.bifrost.com.au/blog/



 2009/3/27 Barney Boisvert bboisv...@gmail.com:
 Further, you almost certainly want to be doing a 301 instead of a 302
 to the long URL, which CFLOCATION doesn't provide.  If you opt to
 continue down this route, probably want to use CFHEADER instead

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321030
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfdirectory directory to a another server

2008-11-26 Thread Dan O'Keefe
On Tue, Nov 25, 2008 at 7:16 PM, Dave Watts [EMAIL PROTECTED] wrote:

  That was my conclusion as well - only way it can work is if a domain is
  involved.

 It is possible, however, to use credentials that aren't valid locally
 to connect to a remote server:

 net use * \\server\share password /user:username


Interesting, that does make a successful connection. I logged into the CF
server with the CFService account and used the following:

net use z: \\192.168.1.160\share1 12345678 /user:CFService /persistent:yes

It creates the Drive Z, which I am using in the CFDirectory command but
still no results.

Dan


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315974
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: cfdirectory directory to a another server

2008-11-25 Thread Jeffrey Lemire
Have you tried something like \\192.168.1.100\d$\ (d$ representing the root
drive you're trying to access)

Shares are usually associated with login accounts.

Jeffrey V. Lemire
Applications Architect / President
http://www.citadelnetworks.net


-Original Message-
From: Dan O'Keefe [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2008 7:01 PM
To: cf-talk
Subject: Re: cfdirectory directory to a another server

Yes, Since I created matching accounts on the two servers, say CFService
and using the same passwords. Even gave the admin privelages so I could log
in with that account and test the share by going to \\192.168.1.100\sharname.
That was successful, but flat out would not work in CF 8.01.
Dan

On Mon, Nov 24, 2008 at 5:46 PM, Dave Watts [EMAIL PROTECTED] wrote:

  I tried this recently myself without success. In my scenario, I had 2
 Win2K3
  standalone servers (not in a domain), so I could not give rights to a
 folder
  on one server from the other. I tried matching up user account 
 passwords
  that the CF Service used to login and applied the rights to the folder to
 be
  written to, but that did not work wither. Tried both a mapped drive and
 UNC.

 Were you able to log into the first server with the account that
 should have access to the other server? Were you able to access the
 share from the first server's console?

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/

 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315867
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfdirectory directory to a another server

2008-11-25 Thread Dan O'Keefe

 In my example, it may be referred to as: \\server1\CFService.

 Then, on \\server2\share, grant access to \\server1\CFService.


That is where the problem is. When trying to give the user from server1
permission on server2, and you click on the Locations button, only the
current server is displayed. So even if I type in server1/CFService, it does
not accept it.

Dan


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315879
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfdirectory directory to a another server

2008-11-25 Thread Dan O'Keefe
On Tue, Nov 25, 2008 at 6:28 AM, Jeffrey Lemire [EMAIL PROTECTED]
 wrote:

 Have you tried something like \\192.168.1.100\d$\ (d$ representing the
 root
 drive you're trying to access)

 Shares are usually associated with login accounts.


Yep, tried every possible combination I could think of.

Dan


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315880
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: cfdirectory directory to a another server

2008-11-25 Thread Dawson, Michael
Try using server\CFService  (Use the other slash)

Mike 

-Original Message-
From: Dan O'Keefe [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 25, 2008 9:04 AM
To: cf-talk
Subject: Re: cfdirectory directory to a another server


 In my example, it may be referred to as: \\server1\CFService.

 Then, on \\server2\share, grant access to \\server1\CFService.


That is where the problem is. When trying to give the user from server1
permission on server2, and you click on the Locations button, only the
current server is displayed. So even if I type in server1/CFService, it
does not accept it.

Dan

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315884
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfdirectory directory to a another server

2008-11-25 Thread Dan O'Keefe
On Tue, Nov 25, 2008 at 10:47 AM, Dawson, Michael [EMAIL PROTECTED]wrote:

 Try using server\CFService  (Use the other slash)

 Mike


That was a type on my part, but just to be sure I tried it again. The Name
not found dialog states The following object is not from a domain listed
in the select location dialog box, and is therefore not valid.

Dan


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315904
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfdirectory directory to a another server

2008-11-25 Thread Dave Watts
 That was a type on my part, but just to be sure I tried it again. The Name
 not found dialog states The following object is not from a domain listed
 in the select location dialog box, and is therefore not valid.

I'm pretty sure you can't refer to local accounts on one machine from
another machine. You can refer to domain accounts if both machines are
within the same domain, or if an appropriate trust relationship has
been created between the domains.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315907
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfdirectory directory to a another server

2008-11-25 Thread Dan O'Keefe
On Tue, Nov 25, 2008 at 3:37 PM, Dave Watts [EMAIL PROTECTED] wrote:

  That was a type on my part, but just to be sure I tried it again. The
 Name
  not found dialog states The following object is not from a domain
 listed
  in the select location dialog box, and is therefore not valid.

 I'm pretty sure you can't refer to local accounts on one machine from
 another machine. You can refer to domain accounts if both machines are
 within the same domain, or if an appropriate trust relationship has
 been created between the domains.


That was my conclusion as well - only way it can work is if a domain is
involved.

Dan


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315935
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfdirectory directory to a another server

2008-11-25 Thread Dave Watts
 That was my conclusion as well - only way it can work is if a domain is
 involved.

It is possible, however, to use credentials that aren't valid locally
to connect to a remote server:

net use * \\server\share password /user:username

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315938
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


cfdirectory directory to a another server

2008-11-24 Thread patrick buch
Hi everyone,

I have a webpage that list everything in a particular folder, see code...

cfdirectory action=LIST name=qCurrent directory=d:\saprepository\current 
sort=datelastmodified desc

I want to change the directory to be another server. The CF Docs show this but 
it's not working...I don't get any results using the absolute addressing.

cfdirectory directory=//12.3.123.123/c_drive/ name=dirQuery action=LIST

Any suggestions?

Thank you in advance for your time and help.





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315842
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfdirectory directory to a another server

2008-11-24 Thread Ian Skinner
patrick buch wrote:
 cfdirectory directory=//12.3.123.123/c_drive/ name=dirQuery 
 action=LIST

 Any suggestions?
   

The user that ColdFusion runs under must have domain permissions to read 
from the remote system over the network.  The default windows user 
localsystem' that the ColdFusion service runs under does not normally 
have any permissions outside of the, ahem... local system.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315844
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfdirectory directory to a another server

2008-11-24 Thread Dave Watts
 I have a webpage that list everything in a particular folder, see code...

 cfdirectory action=LIST name=qCurrent 
 directory=d:\saprepository\current sort=datelastmodified desc

 I want to change the directory to be another server. The CF Docs show this 
 but it's not working...I don't get any results using the absolute addressing.

 cfdirectory directory=//12.3.123.123/c_drive/ name=dirQuery 
 action=LIST

By default, CF runs as SYSTEM, which can't access network resources.
To do this, you'd need to run CF as a user which has permission to
access the remote share. Also, UNC paths use backslashes, not forward
slashes.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315845
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfdirectory directory to a another server

2008-11-24 Thread Dan O'Keefe
I tried this recently myself without success. In my scenario, I had 2 Win2K3
standalone servers (not in a domain), so I could not give rights to a folder
on one server from the other. I tried matching up user account  passwords
that the CF Service used to login and applied the rights to the folder to be
written to, but that did not work wither. Tried both a mapped drive and UNC.
--
Dan O'Keefe


On Mon, Nov 24, 2008 at 5:14 PM, patrick buch [EMAIL PROTECTED]wrote:

 Hi everyone,

 I have a webpage that list everything in a particular folder, see code...

 cfdirectory action=LIST name=qCurrent
 directory=d:\saprepository\current sort=datelastmodified desc

 I want to change the directory to be another server. The CF Docs show this
 but it's not working...I don't get any results using the absolute
 addressing.

 cfdirectory directory=//12.3.123.123/c_drive/ name=dirQuery
 action=LIST

 Any suggestions?

 Thank you in advance for your time and help.





 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315846
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfdirectory directory to a another server

2008-11-24 Thread Wil Genovese
Based on that example it is assuming the other server has windows file
sharing enabled.  You need to setup the other server to have file sharing
enabled and then access the share name.

This may or may not be the best way to do this.  It all depends on your
desired level of security.

Wil Genovese

On Mon, Nov 24, 2008 at 4:14 PM, patrick buch [EMAIL PROTECTED]wrote:

 Hi everyone,

 I have a webpage that list everything in a particular folder, see code...

 cfdirectory action=LIST name=qCurrent
 directory=d:\saprepository\current sort=datelastmodified desc

 I want to change the directory to be another server. The CF Docs show this
 but it's not working...I don't get any results using the absolute
 addressing.

 cfdirectory directory=//12.3.123.123/c_drive/ name=dirQuery
 action=LIST

 Any suggestions?

 Thank you in advance for your time and help.





 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315847
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfdirectory directory to a another server

2008-11-24 Thread Dave Watts
 I tried this recently myself without success. In my scenario, I had 2 Win2K3
 standalone servers (not in a domain), so I could not give rights to a folder
 on one server from the other. I tried matching up user account  passwords
 that the CF Service used to login and applied the rights to the folder to be
 written to, but that did not work wither. Tried both a mapped drive and UNC.

Were you able to log into the first server with the account that
should have access to the other server? Were you able to access the
share from the first server's console?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315851
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfdirectory directory to a another server

2008-11-24 Thread Dan O'Keefe
Yes, Since I created matching accounts on the two servers, say CFService
and using the same passwords. Even gave the admin privelages so I could log
in with that account and test the share by going to \\192.168.1.100\sharname.
That was successful, but flat out would not work in CF 8.01.
Dan

On Mon, Nov 24, 2008 at 5:46 PM, Dave Watts [EMAIL PROTECTED] wrote:

  I tried this recently myself without success. In my scenario, I had 2
 Win2K3
  standalone servers (not in a domain), so I could not give rights to a
 folder
  on one server from the other. I tried matching up user account 
 passwords
  that the CF Service used to login and applied the rights to the folder to
 be
  written to, but that did not work wither. Tried both a mapped drive and
 UNC.

 Were you able to log into the first server with the account that
 should have access to the other server? Were you able to access the
 share from the first server's console?

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/

 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315855
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: cfdirectory directory to a another server

2008-11-24 Thread Dawson, Michael
Setting up matching accounts won't work.  They will have different identities.
 
If you are not on a domain, you should setup a local server account, for 
example CFService.
 
In my example, it may be referred to as: \\server1\CFService.
 
Then, on \\server2\share, grant access to \\server1\CFService.
 
Mike

  _  

From: Dan O'Keefe [mailto:[EMAIL PROTECTED]
Sent: Mon 11/24/2008 4:34 PM
To: cf-talk
Subject: Re: cfdirectory directory to a another server



I tried this recently myself without success. In my scenario, I had 2 Win2K3
standalone servers (not in a domain), so I could not give rights to a folder
on one server from the other. I tried matching up user account  passwords
that the CF Service used to login and applied the rights to the folder to be
written to, but that did not work wither. Tried both a mapped drive and UNC.
--
Dan O'Keefe


On Mon, Nov 24, 2008 at 5:14 PM, patrick buch [EMAIL PROTECTED]wrote:

 Hi everyone,

 I have a webpage that list everything in a particular folder, see code...

 cfdirectory action=LIST name=qCurrent
 directory=d:\saprepository\current sort=datelastmodified desc

 I want to change the directory to be another server. The CF Docs show this
 but it's not working...I don't get any results using the absolute
 addressing.

 cfdirectory directory=//12.3.123.123/c_drive/ name=dirQuery
 action=LIST

 Any suggestions?

 Thank you in advance for your time and help.









~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315857
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Cfdirectory onclick event

2008-09-23 Thread erik tom
I am retriving the file system. From now i need to select a file and populate 
the name of the file to the input box 

cfform format=html action=#cgi.Script_Name#
cfset test=CreateObject(component,Erik.Navigation).directory()

   cftree name=Test_Tree width=300 height=300
  cfloop query=test
 cfif test.Type is Dir
cftreeitem value=#test.Directory#\#test.Name# 
display=#test.Name# parent=#test.Directory# expand=yes
 cfelse
cftreeitem value=#test.Directory#\#test.Directory# 
display=#test.Name# parent=#test.Directory# expand=yes
 /cfif
  /cfloop
   /cftree
   
/cfform

input type=text id=link name=link onclick=ColdFusion.Tree.getTreeObject 
(Test_Tree);/


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312938
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Is it possible to access network drives with CFDIRECTORY and CFCONTENT

2008-07-10 Thread Arden Weiss
I seem to not be able to access a mapped network drive with CFDIRECTORY and 
CFCONTENT. 

The CF7 app needs to be able to access/manage a store of PDF files and display 
them in the user's browser.

Everything works great as long as the PDF files are located in a folder on a 
drive directly attached to the box on which CF7 is installed, but fails when I 
try to access the same files located on a mapped network drive.

The simple solution would be to put the files on one of the drives on the CF 
box, but the network guys are fussy about doing that. 

So any insight on how to access and display the PDF files located on a 
networked drive  would be most helpful.




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308841
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Is it possible to access network drives with CFDIRECTORY and CFCONTENT

2008-07-10 Thread Bobby Hartsfield
I haven't done it with the actual drive letter of a mapped network drive but
we upload and read files at work all the time with a UNC path since our
storage server is a separate machine. Have you tried that instead?

Eg. \\[ipaddress or computer name]\sharename

I will try cfdirectory and cfcontent specifically when I get into the office
today and let you know the results

-Original Message-
From: Arden Weiss [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 10, 2008 2:46 AM
To: CF-Talk
Subject: Is it possible to access network drives with CFDIRECTORY and
CFCONTENT

I seem to not be able to access a mapped network drive with CFDIRECTORY and
CFCONTENT. 

The CF7 app needs to be able to access/manage a store of PDF files and
display them in the user's browser.

Everything works great as long as the PDF files are located in a folder on a
drive directly attached to the box on which CF7 is installed, but fails when
I try to access the same files located on a mapped network drive.

The simple solution would be to put the files on one of the drives on the CF
box, but the network guys are fussy about doing that. 

So any insight on how to access and display the PDF files located on a
networked drive  would be most helpful.






~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308843
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Is it possible to access network drives with CFDIRECTORY and CFCONTENT

2008-07-10 Thread Peterson, Chris
Arden,

This is a permissions issue (almost guarantee it).  Change the
coldfusion service to run as a user in the domain with access to the
shares you need to save/read from, and you will be all set.  Personally,
I create a 'cfUser' or 'coldfusion' user on the domain and give it very
specific permissions to anything it needs to access.

Chris Peterson

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 10, 2008 6:57 AM
To: CF-Talk
Subject: RE: Is it possible to access network drives with CFDIRECTORY
and CFCONTENT

I haven't done it with the actual drive letter of a mapped network drive
but
we upload and read files at work all the time with a UNC path since our
storage server is a separate machine. Have you tried that instead?

Eg. \\[ipaddress or computer name]\sharename

I will try cfdirectory and cfcontent specifically when I get into the
office
today and let you know the results

-Original Message-
From: Arden Weiss [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 10, 2008 2:46 AM
To: CF-Talk
Subject: Is it possible to access network drives with CFDIRECTORY and
CFCONTENT

I seem to not be able to access a mapped network drive with CFDIRECTORY
and
CFCONTENT. 

The CF7 app needs to be able to access/manage a store of PDF files and
display them in the user's browser.

Everything works great as long as the PDF files are located in a folder
on a
drive directly attached to the box on which CF7 is installed, but fails
when
I try to access the same files located on a mapped network drive.

The simple solution would be to put the files on one of the drives on
the CF
box, but the network guys are fussy about doing that. 

So any insight on how to access and display the PDF files located on a
networked drive  would be most helpful.








~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308846
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: copy files with cfdirectory cffil

2008-06-18 Thread Didgiman
Your cffile action=copy should specify the location of the file, not the
directory.

Use this:
CFLOOP QUERY=DropoffDir
  CFFILE ACTION=Copy SOURCE=c:\mylocaldir\dropoff\#DropoffDir.name#
DESTINATION=c:\gal_07\ NAMECONFLICT=Overwrite
/CFLOOP

HTH,
Wim.

On Tue, Jun 17, 2008 at 7:34 PM, thomas v [EMAIL PROTECTED] wrote:

 Hi,

 I have couple of questions to ask:

 1) I can specific copy one file from one folder to another one but I cannot
 copy all files from my 'dropoff' to my 'gal_o7'. What 's wrong with the code
 below?
 2) I am setting up an event gateway and my CFC will do the copying (I have
 no CFML). How do I dump out the cfdirectory list?

 Thanks

 Here is my code:

 cfcomponent
 cffunction name=onAdd
 cffile action=write file=c:/testlog6.txt output=Here I am back to
 sssrootasasay 
 CFDIRECTORY Directory= c:/mylocaldir/dropoff NAME=DropoffDir
 ACTION=List 
 CFTABLE QUERY=DropoffDir HTMLTABLE COLHEADERS
 CFCOL HEADER=Name TEXT=#Name#
 CFCOL HEADER=Type TEXT=#Type#
 CFCOL HEADER=Size TEXT=#Size#
 /CFTABLE

 CFLOOP QUERY=DropoffDir
 CFFILE ACTION=Copy SOURCE=c:\mylocaldir\dropoff\
 DESTINATION=c:\gal_07\ NAMECONFLICT=Overwrite
 /CFLOOP
 /cffunction
 /cfcomponent


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307654
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


copy files with cfdirectory cffile

2008-06-17 Thread thomas v
Hi,

I have couple of questions to ask:

1) I can specific copy one file from one folder to another one but I cannot 
copy all files from my 'dropoff' to my 'gal_o7'. What 's wrong with the code 
below? 
2) I am setting up an event gateway and my CFC will do the copying (I have no 
CFML). How do I dump out the cfdirectory query? 

Thanks

Here is my code:

cfcomponent
cffunction name=onAdd
cffile action=write file=c:/testlog6.txt output=Here I am back to 
sssrootasasay  
CFDIRECTORY Directory= c:/mylocaldir/dropoff NAME=DropoffDir ACTION=List 

CFTABLE QUERY=DropoffDir HTMLTABLE COLHEADERS
CFCOL HEADER=Name TEXT=#Name#
CFCOL HEADER=Type TEXT=#Type#
CFCOL HEADER=Size TEXT=#Size#
/CFTABLE

CFLOOP QUERY=DropoffDir
CFFILE ACTION=Copy SOURCE=c:\mylocaldir\dropoff\ DESTINATION=c:\gal_07\ 
NAMECONFLICT=Overwrite
/CFLOOP
/cffunction
/cfcomponent


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307616
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


copy files with cfdirectory cffile

2008-06-17 Thread thomas v
Hi,

I have couple of questions to ask:

1) I can specific copy one file from one folder to another one but I cannot 
copy all files from my 'dropoff' to my 'gal_o7'. What 's wrong with the code 
below? 
2) I am setting up an event gateway and my CFC will do the copying (I have no 
CFML). How do I dump out the cfdirectory list? 

Thanks

Here is my code:

cfcomponent
cffunction name=onAdd
cffile action=write file=c:/testlog6.txt output=Here I am back to 
sssrootasasay  
CFDIRECTORY Directory= c:/mylocaldir/dropoff NAME=DropoffDir ACTION=List 

CFTABLE QUERY=DropoffDir HTMLTABLE COLHEADERS
CFCOL HEADER=Name TEXT=#Name#
CFCOL HEADER=Type TEXT=#Type#
CFCOL HEADER=Size TEXT=#Size#
/CFTABLE

CFLOOP QUERY=DropoffDir
CFFILE ACTION=Copy SOURCE=c:\mylocaldir\dropoff\ DESTINATION=c:\gal_07\ 
NAMECONFLICT=Overwrite
/CFLOOP
/cffunction
/cfcomponent


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307617
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CFDIRECTORY and Multiple Spaces Between Filename

2008-06-12 Thread Sameer Gupta
What I can suggest you is to surrround your output with pre#name#/pre so 
all spaces are intact in the browser display. 

The issue is only with browser displaying it after ignoring whitespaces.

In HTML, the following will be displayed as breaksplease:

b

breaks

please

/b

You can't expect your manual line-breaks automatically convert to br / tag.

Sam
Adobe Certified Flash and
Advanced ColdFusion Developer


 Running CFMX7.0.2.  Not sure if this applies to other versions, but 
 have you noticed that if you have two files in a directory, say:
 
 whatever whatever.txt (one space between names)
 whatever  whatever.txt (two spaces between names)
 
 and if you do CFDIRECTORY in this directory, the NAME column will list 
 both files as:
 
 whatever whatever.txt
 whatever whatever.txt
 
 I can't possibly be the first one to notice this, right?  And somebody 
 must have a workaround...right?  Please?  Pretty please?
 
 - Sung 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307323
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


CFDIRECTORY and Multiple Spaces Between Filename

2008-06-11 Thread Sung Woo
Running CFMX7.0.2.  Not sure if this applies to other versions, but have you 
noticed that if you have two files in a directory, say:

whatever whatever.txt (one space between names)
whatever  whatever.txt (two spaces between names)

and if you do CFDIRECTORY in this directory, the NAME column will list both 
files as:

whatever whatever.txt
whatever whatever.txt

I can't possibly be the first one to notice this, right?  And somebody must 
have a workaround...right?  Please?  Pretty please?

- Sung 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307289
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CFDIRECTORY and Multiple Spaces Between Filename

2008-06-11 Thread Sung Woo
D'oh, never mind.  It's because the browser kills the spaces.  If I PRE it, 
it comes out fine.

 Running CFMX7.0.2.  Not sure if this applies to other versions, but 
 have you noticed that if you have two files in a directory, say:
 
 whatever whatever.txt (one space between names)
 whatever  whatever.txt (two spaces between names)
 
 and if you do CFDIRECTORY in this directory, the NAME column will list 
 both files as:
 
 whatever whatever.txt
 whatever whatever.txt
 
 I can't possibly be the first one to notice this, right?  And somebody 
 must have a workaround...right?  Please?  Pretty please?
 
 - Sung 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307291
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFDIRECTORY and Multiple Spaces Between Filename

2008-06-11 Thread Didgiman
I'm guessing that it shows on screen like there's only one space, because
html will not show multiple spaces.
View the source of your page, I bet you can see 2 spaces there.

Wim.

On Wed, Jun 11, 2008 at 11:02 PM, Sung Woo [EMAIL PROTECTED] wrote:

 Running CFMX7.0.2.  Not sure if this applies to other versions, but have
 you noticed that if you have two files in a directory, say:

 whatever whatever.txt (one space between names)
 whatever  whatever.txt (two spaces between names)

 and if you do CFDIRECTORY in this directory, the NAME column will list both
 files as:

 whatever whatever.txt
 whatever whatever.txt

 I can't possibly be the first one to notice this, right?  And somebody must
 have a workaround...right?  Please?  Pretty please?

 - Sung

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307293
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFDIRECTORY and Multiple Spaces Between Filename

2008-06-11 Thread Ian Skinner
Sung Woo wrote:
 I can't possibly be the first one to notice this, right?  And somebody must 
 have a workaround...right?  Please?  Pretty please?

Never noticed it, but it is what I would expect.  This it is the HTML 
standard that says all multiple spaces will be collapsed into a single 
space by a browser unless a markup that overrides this expected behavior 
is use, such as the pre.../pre or code.../code tags or using the 
nbsp; (non-breaking space) entity in the string.

I.E. try the following HTML page and see the exact same thing without 
any ColdFusion, let alone the cfdirectory... tag.

html
head
titleMy Space Test/title
/head
body
pwhatever whatever.txt/p!-- One Space --
pwhatever  whatever.txt/p!-- Two Spaces --
/body
html



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307294
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CFDIRECTORY / CFFILE

2008-05-21 Thread Robert Harrison
This seems like it should be easy but I must be missing something.

I have a known directory with a bunch of unknown subdirectories, and
possibly more unknown subdirectories in them.

I want to recurse the known directory and get the name of every file and the
FULL PATH to each file. How do I get the FULL PATH returned to me?

cfdirectory action=list name=dlist directory=#mypath#
recurse=yes

I get back all the file names, but I can't tell what directories they are
in. Any thoughts?

Thanks

Robert B. Harrison
Director of Interactive services
Austin  Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 
F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be .



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305828
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: CFDIRECTORY / CFFILE

2008-05-21 Thread Robert Harrison
This seems like it should be easy but I must be missing something.

I have a known directory with a bunch of unknown subdirectories and possibly
more unknown subdirectories in them.

I want to recurse the known directory and get the name of every file and the
FULL PATH to each file. How do I get the FULL PATH returned to me?

cfdirectory action=list name=dlist directory=#mypath#
recurse=yes

I get back all the file names, but I can't tell what directories they are
in. Any thoughts?

Thanks

Robert B. Harrison
Director of Interactive services
Austin  Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 
F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be .



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305832
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFDIRECTORY / CFFILE

2008-05-21 Thread Ian Skinner
Robert Harrison wrote:
 This seems like it should be easy but I must be missing something.

 I have a known directory with a bunch of unknown subdirectories, and
 possibly more unknown subdirectories in them.

 I want to recurse the known directory and get the name of every file and the
 FULL PATH to each file. How do I get the FULL PATH returned to me?
   

Did you try dumping the query i.e. cfdump var=dlist.

Does the directory column in the query not get you where you need to 
do.  Yes it is not the full path, but combined with the known path it 
should get your there.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305834
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFDIRECTORY / CFFILE

2008-05-21 Thread Massimo Foti
 I want to recurse the known directory and get the name of every file and 
 the
 FULL PATH to each file. How do I get the FULL PATH returned to me?

You could try this CFC:
http://www.massimocorner.com/coldfusion/cfc/tmt_file_io.zip

You can use this method:

getFileList(directoryPath, true)

Hope it will help


Massimo Foti, web-programmer for hire
Tools for ColdFusion, JavaScript and Dreamweaver:
http://www.massimocorner.com



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305838
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFdirectory under ColdFusion 8 (Standard)

2008-05-03 Thread Don L
 On Fri, May 2, 2008 at 3:46 PM, Don L [EMAIL PROTECTED] wrote:
   cfdirectory directory=e:\blabla\bla2bla2\ action=list 
 name=juiceFile type=file sort=directory DESC
   the Sort attribute failed (it did not list files in z to a order).
 
 'directory' is only for recursive CFDIRECTORY calls.  You want 'name'
 field for files within the directory.
 
   cfdirectory directory=e:\blabla\bla2bla2\ action=list 
 name=juiceFile type=file sort=size DESC
   output includes Thumbs.db (the Type Attribute is supposed to 
 eliminate the Thumbs.db or is it my misunderstanding?)
 
 Thumbs.db is a file, not a directory, so it's matched.  You probably
 want filter=*.jpg or something.
 
 cheers,
 barneyb
 
 -- 
 Barney Boisvert
 [EMAIL PROTECTED]
 http://www.barneyb.com/
 Barney Boisvert

Thanks, Barney.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304704
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CFdirectory under ColdFusion 8 (Standard)

2008-05-02 Thread Don L
Oddities with this tag (OS=XP Professional):

cfdirectory directory=e:\blabla\bla2bla2\ action=list name=juiceFile 
type=file sort=directory DESC
the Sort attribute failed (it did not list files in z to a order).


cfdirectory directory=e:\blabla\bla2bla2\ action=list name=juiceFile 
type=file sort=size DESC
output includes Thumbs.db (the Type Attribute is supposed to eliminate the 
Thumbs.db or is it my misunderstanding?)

Thanks.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304694
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFdirectory under ColdFusion 8 (Standard)

2008-05-02 Thread Barney Boisvert
On Fri, May 2, 2008 at 3:46 PM, Don L [EMAIL PROTECTED] wrote:
  cfdirectory directory=e:\blabla\bla2bla2\ action=list name=juiceFile 
 type=file sort=directory DESC
  the Sort attribute failed (it did not list files in z to a order).

'directory' is only for recursive CFDIRECTORY calls.  You want 'name'
field for files within the directory.

  cfdirectory directory=e:\blabla\bla2bla2\ action=list name=juiceFile 
 type=file sort=size DESC
  output includes Thumbs.db (the Type Attribute is supposed to eliminate the 
 Thumbs.db or is it my misunderstanding?)

Thumbs.db is a file, not a directory, so it's matched.  You probably
want filter=*.jpg or something.

cheers,
barneyb

-- 
Barney Boisvert
[EMAIL PROTECTED]
http://www.barneyb.com/

Got Gmail? I have 100 invites.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304696
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Cffile and cfdirectory in CF 8

2008-04-22 Thread Tim Lancaster
I just upgraded from CF7 Standard to CF8 Enterprise.  I have several scheduled 
tasks that run everyday that dump files to mapped network shares.  Since 
upgrading, I only get errors to the effect of the path cannot be found or make 
sure the directory doesn't exist.  I have the CF service using a domain account 
with full permissions on the share.  What else am I missing?  I installed CF8 
on another server just to test and I get the same errors.  I am trying to use 
cfdirectory action=create  and all cffile actions that move or copy files to 
the shares.  I am on windows 2003 with IIS6. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303995
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Cffile and cfdirectory in CF 8

2008-04-22 Thread Brad Wood
Are you by chance using a path relative to the old installation of CF7?

~Brad

-Original Message-
From: Tim Lancaster [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 22, 2008 12:43 PM
To: CF-Talk
Subject: Cffile and cfdirectory in CF 8

I just upgraded from CF7 Standard to CF8 Enterprise.  I have several
scheduled tasks that run everyday that dump files to mapped network
shares.  Since upgrading, I only get errors to the effect of the path
cannot be found or make sure the directory doesn't exist.  I have the CF
service using a domain account with full permissions on the share.  What
else am I missing?  I installed CF8 on another server just to test and I
get the same errors.  I am trying to use cfdirectory action=create
and all cffile actions that move or copy files to the shares.  I am on
windows 2003 with IIS6. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303996
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Cffile and cfdirectory in CF 8

2008-04-22 Thread Tim Lancaster
Actually I misstated that I upgraded, it is a completely new installation.  I 
have a mapped drive in widows pointing to a share on another server.

Are you by chance using a path relative to the old installation of CF7?

~Brad

I just upgraded from CF7 Standard to CF8 Enterprise.  I have several
scheduled tasks that run everyday that dump files to mapped network
shares.  Since upgrading, I only get errors to the effect of the path
cannot be found or make sure the directory doesn't exist.  I have the CF
service using a domain account with full permissions on the share.  What
else am I missing?  I installed CF8 on another server just to test and I
get the same errors.  I am trying to use cfdirectory action=create
and all cffile actions that move or copy files to the shares.  I am on
windows 2003 with IIS6. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304005
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Cffile and cfdirectory in CF 8

2008-04-22 Thread Dave Watts
 Actually I misstated that I upgraded, it is a completely new 
 installation.  I have a mapped drive in widows pointing to a 
 share on another server.

Are you sure you configured the new installation to run as the appropriate
user instead of SYSTEM?

If you use a UNC path instead of a mapped drive, does that work?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304014
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Cffile and cfdirectory in CF 8

2008-04-22 Thread Tim Lancaster
Dave,
Thanks for the reply,
Yes I have setup a user account with all appropriate right to run CF and access 
the shares.  And interestingly, the UNC path does work.  Do you know of a 
reason why mapped drives wouldn't work when they did in CF 7 and earlier?

Tim

 Actually I misstated that I upgraded, it is a completely new 
 installation.  I have a mapped drive in widows pointing to a 
 share on another server.

Are you sure you configured the new installation to run as the appropriate
user instead of SYSTEM?

If you use a UNC path instead of a mapped drive, does that work?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/ 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304017
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Cffile and cfdirectory in CF 8

2008-04-22 Thread Dave Watts
 Yes I have setup a user account with all appropriate right to 
 run CF and access the shares.  And interestingly, the UNC 
 path does work.  Do you know of a reason why mapped drives 
 wouldn't work when they did in CF 7 and earlier?

Perhaps the mapping isn't available for that user. Try logging in
interactively as that user, and see if you can access the drive mapping.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304022
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Cffile and cfdirectory in CF 8

2008-04-22 Thread Tim Lancaster
I have tried that and I can access the drive, create, modify and delete as per 
the given rights.  This has been an issue with any drive that is mapped to 
share on another server, none of them work anymore with CF 8.

 Yes I have setup a user account with all appropriate right to 
 run CF and access the shares.  And interestingly, the UNC 
 path does work.  Do you know of a reason why mapped drives 
 wouldn't work when they did in CF 7 and earlier?

Perhaps the mapping isn't available for that user. Try logging in
interactively as that user, and see if you can access the drive mapping.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/ 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304025
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CFDIRECTORY NUL bug

2008-04-02 Thread Sung Woo
Is it just me or does this produce an error for everyone?

cfdirectory action=create directory=C:\NUL\

It's the word NUL that's giving CF 7.0.2 the heebie-jeebies.  It's not able 
to create it.  Any workarounds?

- Sung 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302521
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: CFDIRECTORY NUL bug

2008-04-02 Thread Dave Francis
It seems to be a Windows problem: at least on XP I can't create/rename a
folder to NUL doing it manually

-Original Message-
From: Sung Woo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2008 2:49 PM
To: CF-Talk
Subject: CFDIRECTORY NUL bug


Is it just me or does this produce an error for everyone?

cfdirectory action=create directory=C:\NUL\

It's the word NUL that's giving CF 7.0.2 the heebie-jeebies.  It's not
able to create it.  Any workarounds?

- Sung



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302524
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFDIRECTORY NUL bug

2008-04-02 Thread Sonny Savage
I read about certain names that can't be used for windows directories and
file names but I can't seem to locate the information right now.  I had to
do with legacy DOS commands or something.

On Wed, Apr 2, 2008 at 4:22 PM, Dave Francis [EMAIL PROTECTED]
wrote:

 It seems to be a Windows problem: at least on XP I can't create/rename a
 folder to NUL doing it manually

 -Original Message-
 From: Sung Woo [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, April 02, 2008 2:49 PM
 To: CF-Talk
 Subject: CFDIRECTORY NUL bug


 Is it just me or does this produce an error for everyone?

 cfdirectory action=create directory=C:\NUL\

 It's the word NUL that's giving CF 7.0.2 the heebie-jeebies.  It's not
 able to create it.  Any workarounds?

 - Sung



 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302529
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFDIRECTORY NUL bug

2008-04-02 Thread Sonny Savage
Found it!
http://rohit11.blogspot.com/2006/04/con-prn-aux-nul.html

On Wed, Apr 2, 2008 at 4:18 PM, Sonny Savage [EMAIL PROTECTED] wrote:

 I read about certain names that can't be used for windows directories and
 file names but I can't seem to locate the information right now.  I had to
 do with legacy DOS commands or something.


 On Wed, Apr 2, 2008 at 4:22 PM, Dave Francis [EMAIL PROTECTED]
 wrote:

  It seems to be a Windows problem: at least on XP I can't create/rename a
  folder to NUL doing it manually
 
  -Original Message-
  From: Sung Woo [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, April 02, 2008 2:49 PM
  To: CF-Talk
  Subject: CFDIRECTORY NUL bug
 
 
  Is it just me or does this produce an error for everyone?
 
  cfdirectory action=create directory=C:\NUL\
 
  It's the word NUL that's giving CF 7.0.2 the heebie-jeebies.  It's not
  able to create it.  Any workarounds?
 
  - Sung
 
 
 
  

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302530
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


url for cfdirectory col name

2007-11-13 Thread Orlini, Robert
Can I add a URL to the #name# field displaying on a cfdirectory?

I want the user to be able to list the .doc files and then click on the doc 
files listed to display them.

Thanks.

RO
HWW

cfdirectory 
   directory=#GetDirectoryFromPath(GetTemplatePath())# 
   name=myDirectory 
   action=list
   filter=*.doc
   sort=name ASC, size DESC
! Output the contents of the cfdirectory as a cftable - 
cftable 
   query=myDirectory 
   htmltable 
   colheaders 
  cfcol 
  header=NAME: 
  text=#Name# 
   cfcol 
  header=SIZE: 
  text=#Size# 
/cftable 


~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293200
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: url for cfdirectory col name

2007-11-13 Thread Raymond Camden
Sure - you can manipulate any query object using queryAddColum,
queryAddRow, querySetCell. Please see the docs. If you wanted to use
it in cftable (holy crap - someone uses cftable!) then you would
modify the query before you run the cftable.

On Nov 13, 2007 9:07 AM, Orlini, Robert [EMAIL PROTECTED] wrote:
 Can I add a URL to the #name# field displaying on a cfdirectory?

 I want the user to be able to list the .doc files and then click on the doc 
 files listed to display them.

 Thanks.

 RO
 HWW

 cfdirectory
directory=#GetDirectoryFromPath(GetTemplatePath())#
name=myDirectory
action=list
filter=*.doc
sort=name ASC, size DESC
 ! Output the contents of the cfdirectory as a cftable -
 cftable
query=myDirectory
htmltable
colheaders
   cfcol
   header=NAME:
   text=#Name#
cfcol
   header=SIZE:
   text=#Size#
 /cftable


 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293210
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: url for cfdirectory col name

2007-11-13 Thread Dave Watts
 Can I add a URL to the #name# field displaying on a cfdirectory?
 
 I want the user to be able to list the .doc files and then 
 click on the doc files listed to display them.
 
 Thanks.
 
 RO
 HWW
 
 cfdirectory 
directory=#GetDirectoryFromPath(GetTemplatePath())# 
name=myDirectory 
action=list
filter=*.doc
sort=name ASC, size DESC
 ! Output the contents of the cfdirectory as a cftable 
 - cftable 
query=myDirectory 
htmltable 
colheaders
   cfcol 
   header=NAME: 
   text=#Name# 
cfcol 
   header=SIZE: 
   text=#Size#
 /cftable 

You could do this by manipulating the query, as Ray suggested, or you could
just manipulate the output:

cfcol header=NAME: text=a
href=http://yourserver/yourdirectory/#Name#;#Name#/a

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!


~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293219
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CFDIRECTORY filter shortcoming

2007-06-26 Thread Claude Schneegans
 filter=*.jpg|*.gif|*.png

No way.
As the docs says: One filter can be applied.

Only one filter, with ? or * wild characters, A la DOS, or even A la 
CP/M should I say...

But with CFX_ListDir, this will work using attribute
EXTENSIONS = *.jpg,*.gif,*.png

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7  
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282267
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CFDIRECTORY filter shortcoming

2007-06-26 Thread Steve Withington
I use CFDIRECTORY all the time to scan the image library for various
maintenance purposes. I want to read and list only image files. These may be
.jpg, .gif, or .png, yet CFDIRECTORY can only filter on one file type. 
 
Does anyone know of a way I can extend the file filter and get what I want
in a single read? Right now I need to run a CFDIRECTORY for each file type I
want and combine outputs. This seems kind of stupid.
 
Thanks
 
 
 
 
Robert B. Harrison
Director of Interactive services
Austin  Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 
F : 631.434.7022
www.austin-williams.com


Robert,

Try something along these lines:

cfset dircur = GetDirectoryFromPath(GetTemplatePath())
cfdirectory
directory=#dircur#
name=dirimg
sort=name ASC
filter=*.jpg|*.gif|*.png
cfif dirimg.recordcount eq 0
Sorry, no images are currently available. Please try again later.
cfelse
cfoutput query=dirimg


Good luck,
Steve Withington

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282255
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CFDIRECTORY filter shortcoming

2007-06-22 Thread Robert Harrrison
I use CFDIRECTORY all the time to scan the image library for various
maintenance purposes. I want to read and list only image files. These may be
..jpg, .gif, or .png, yet CFDIRECTORY can only filter on one file type. 
 
Does anyone know of a way I can extend the file filter and get what I want
in a single read? Right now I need to run a CFDIRECTORY for each file type I
want and combine outputs. This seems kind of stupid.
 
Thanks
 
 
 
 
Robert B. Harrison
Director of Interactive services
Austin  Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 
F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be .
 

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.472 / Virus Database: 269.9.1/857 - Release Date: 6/20/2007
2:18 PM
 


~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281887
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


  1   2   3   4   5   6   7   >