> Tried Googling this error message I'm getting when I try to update a Verity > index but no joy - can anyone shed any light on it please. > > "Could not find query table column for [1]." > > The query returns results and this is the code where it fall apart. > > <cfindex action="UPDATE" > > collection="SeafoodFrontierCollection" > key="#get_BrandEP_SectionPagesText.SectionPageID#" > type="CUSTOM" > title="#get_BrandEP_SectionPagesText.SectionPageTitle#" > query="get_BrandEP_SectionPagesText" > body="#get_BrandEP_SectionPagesText.SectionPageBody#" > custom1="#get_BrandEP_SectionPagesText.SectionPageID#">
It's been a while since I've worked with Verity - Google is so much nicer! - but I seem to recall that the key, title, body and custom1 values should be literal strings, not CF expressions. The literal strings wouldn't have hash marks around them. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our trainin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337780 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
