> "Element MONTHS is undefined in CONTRACTINFO" in my query. > > So basically at the WHERE part it complaining about: > (#Listfind(contractinfo.months, form.Monthselect, "/")# > 0) > > contractinfo.months are a text list that outputs like: > 1/2/3/4/5 etc form.monthselect is a value from a from usually > like: 2 Select is contractinfo.* > > I tested the #Listfind(contractinfo.months, form.Monthselect, "/")# . > > It works inside the body of the CFOUTPUT, but when I put it > in the Query with that list function it complains that it is > undefined. > > I also checked #contractinfo.months# and I can use it such as > (contractinfo.months <> '') in the where, and it works. > > Is it I can't use a database column in the Database Query?
If you have a question about your code, you should post your code. Without seeing it, I can't say for sure what's causing your problem. That said, you can't refer to a CF value derived from a query within that same query. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295284 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4