Never mind. Found the problem. Sorry. Collection name is products, not product. -----Original Message----- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2003 5:53 PM To: CF-Talk Subject: <CFINDEX> problem
Any thoughts why the cfIndex part of this code is bombing out? <cfquery name="findprod" datasource="#variable.DSN#" dbtype="ODBC" username="#request.stcSecPriv["readUser"]#" password="#request.stcSecPriv["SysPassword"]#"> select Item_PK, ID, Name, Desc, ListPrice from tabItems order by (Desc); </cfquery> <cfindex action="update" collection="product" key="ID" type="file" query="findprod"> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4