Michelle - here what I Do:
After Uploading I save the following
File Directory is where the file is saved - in my case - it is a preset list
of directories - but you could easily swap that with something like
"/media/files/#variables.ThisPageID#" - I use to do that...
Additionally I have an additional table of FileLinks - that link files to
pages - so one file can be listed on multiple pages...
To Save:
<cfquery datasource="#Application.DSN#" username="#Application.username#"
password="#Application.password#">
INSERT INTO Files (FTID, FileDirectory, Filename, Description,
PostedBy, PostedDate) VALUES (
<cfif IsDefined("FORM.FTID") AND #FORM.FTID# NEQ "">
'#FORM.FTID#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.DestinationDirectory") AND
#FORM.DestinationDirectory# NEQ "">
'#FORM.DestinationDirectory#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.file_path") AND #FORM.file_path# NEQ "">
'#CFFile.ServerFile#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.Description") AND #FORM.Description# NEQ "">
'#FORM.Description#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.PostedBy") AND #FORM.PostedBy# NEQ "">
'#FORM.PostedBy#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.PostedDate") AND #FORM.PostedDate# NEQ "">
'#FORM.PostedDate#'
<cfelse>
NULL
</cfif>
)
</cfquery>
<!--- Step Two: Get new File ID --->
<cfquery name="qryGetNewFileID" datasource="#Application.DSN#"
username="#Application.username#" password="#Application.password#">
SELECT Files.FileID
FROM Files
ORDER BY FileID Desc
LIMIT 1
</cfquery>
<cfset variables.NewFileID = #qryGetNewFileID.FileID#>
<!--- Step Three: Insert Into File Links --->
<cfquery datasource="#Application.DSN#"
username="#Application.username#" password="#Application.password#">
INSERT INTO FileLinks (FileID, Sort, PageID, PageType) VALUES (
# variables.NewFileID#, 1, #FORM.PageID#, #FORM.PageType#
)
</cfquery>
To Retrieve:
<!--- Get Files --->
<cfquery name="qryGetFiles" datasource="#Application.DSN#"
username="#Application.username#" password="#Application.password#">
SELECT Files.*, FileLinks.*
FROM Files, FileLinks
WHERE FileLinks.PageID = #URL.PageID#
AND Files.Active = 1
AND Files.FileID = FileLinks.FileID
ORDER by FileLinks.Sort ASC
</cfquery>
- Nick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5367
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
