I need to query a database to get the originating path and move ALL files with in that originating path to the destination path(also in the database). Can someone help me out.
Here is what I have but it only moves the files from the first hit in the database query.
<cfquery name="filemove" datasource="server">
select * from filemove
<cfdirectory action="LIST" directory="#origin#" name="directoryList">