Does this work?
<cfset fileNames = ValueList(qGetFilenames.lanesid)>
-----Original Message-----
From: Donna French [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 17, 2004 1:37 PM
To: CF-Talk
Subject: Re: Help! Error on ValueList
I had left the CFAbort from yesterday. Removed that, then the query
name was wrong in part of the output. So I've corrected that and have
the current code and error:
Code:
<html>
<head>
<title>Images Cleanup</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<!--- CONFIGURATION --->
<!--- Change these to suit your server --->
<cfset dsn = "mydsn">
<cfset imagesDirectory = "c:\inetpub\lanescollectibles\images">
<cfset imagesSubdirectories = "400,200,85">
<!--- SQL Server is not case-sensitive, so lanesid = lanesID --->
<cfset imageColumnName = "lanesid">
<!--- Change this to FALSE to really do the deletes... --->
<cfset testMode = true />
<!--- /CONFIGURATION --->
<!--- Get all of the filenames --->
<cfquery datasource="#dsn#" name="qGetFilenames">
SELECT #imageColumnName# FROM products
UNION
SELECT #imageColumnName# FROM dolls
</cfquery>
<!--- Turn the filenames into a list --->
<cfset fileNames = #ValueList(qGetFilenames.imageColumnName)# />
<!---
Loop through the various image subdirectories doing cleanup
--->
<cfloop list="#imagesSubdirectories#" index="i">
<cfdirectory action="list" directory="#imagesDirectory#\#i#"
name="qDirectory">
<!---
Loop over the files in the directory, deleting any that isn't
in the list of existing files
--->
<cfoutput>
<cfloop query="qDirectory">
<cfif not listFind(fileNames, qDirectory.name)>
<cfif not testMode>
<cffile action="delete"
file="#imagesDirectory#\#i#\#qDirectory.name#">
<cfelse>
Test Mode: #imagesDirectory#\#i#\#qDirectory.name# would be
deleted. <br />
</cfif>
</cfif>
</cfloop>
</cfoutput>
</cfloop>
</body>
</html>
Error:
Error Diagnostic Information
An error occurred while evaluating the expression:
fileNames = #ValueList(qGetFilenames.imageColumnName)#
Error near line 30, column 7.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184637
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
