I use something like this just after adding a user to the database:
<cfdirectory action="CREATE"
directory="#request.reportfileroot#\#get_max_userid.user_id#">
Shane Witbeck
---------- Original Message ----------------------------------
From: "DeVoil, Nick" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Mon, 6 Nov 2000 14:24:27 -0000
>SQL is for querying/updating/defining databases, not filesystem objects.
>You probably want <CFDIRECTORY ACTION="CREATE">.
>
>Nick
>
>-----Original Message-----
>From: ibtoad [mailto:[EMAIL PROTECTED]]
>Sent: Monday, November 06, 2000 2:18 PM
>To: CF-Talk
>Subject: SQL Stetement Help??
>
>
>How can I create an SQL statement that will create a directory so my users
>can upload to their own directory?
>
>Thanks,
>Rich
>
>
>**********************************************************************
>Information in this email is confidential and may be privileged.
>It is intended for the addressee only. If you have received it in error,
>please notify the sender immediately and delete it from your system.
>You should not otherwise copy it, retransmit it or use or disclose its
>contents to anyone.
>Thank you for your co-operation.
>**********************************************************************
>------------------------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
>with 'unsubscribe' in the body to [EMAIL PROTECTED]
>
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
