This is just a guess, but it looks like it maybe a case sensitivity thing. The error says your table "is not indexable by journalName". Among the list of columns, it has "JOURNALNAME" as a column. A ucase() may be in order.
~Brad -------- Original Message -------- Subject: Ben Nadel's POI.. From: jonese <[EMAIL PROTECTED]> Date: Thu, September 04, 2008 11:54 am To: CF-Talk <[email protected]> Anyone come across this error? [Table (rows 777 columns JOURNALISSN, JOURNALNAME, JOURNALISSUE, JOURNALISOABBREV, JOURNALPUBDATE, JOUNRNALPUBLICATIONTYPE, PUBMEDID, ARTICLETITLE, ARTICLEABSTRACT, TOTALAUTHORS, AUTHORPOSITION, AUTHORTITLE, AUTHORABREVNAME, AUTHORFORENAME, AUTHORFIRSTNAME, AUTHORMIDDLENAME, AUTHORLASTNAME, AUTHORSUFFIX, SUBMISSIONKEY): [JOURNALISSN: [EMAIL PROTECTED] [JOURNALNAME: [EMAIL PROTECTED] ] is not indexable by journalName ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312036 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
