No. valuelist() requires query.column as a parameter. However, couldn't you simply add a column to your query:
SELECT day(auctiondate) AS AuctionDay Then... valuelist(GetMonth.AuctionDay) Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ ----- Original Message ----- From: "jeremy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, July 03, 2003 6:42 AM Subject: format valuelist > Is it possible to format a valuelist like this, I keep getting errors. > ValueList(day(getmonth.auctiondate)) > > I want to turn output like this > 2003-07-12 00:00:00.0, 2003-07-12 00:00:00.0,3 - 2003-07-19 00:00:00.0 > > to 12,12,19 > > so that I can use a conditional like below > > <cfif ValueList(day(getmonth.auctiondate)) contains Variables.CurrentDay > > > > Where variables.CurrentDay is a single number like 12 that is being > incremented in a loop. > I'm using access 2002, and MX. > > Jeremy > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
