I don't think it's a case issue. I tried it with mixed, all lower and all upper and continue to get the same response.
I've also confirmed that spelling is the same in my columnList variable as is in the actually query results. jonese http://www.jonese.us http://twitter.com/jonese On Thu, Sep 4, 2008 at 1:22 PM, <[EMAIL PROTECTED]> wrote: > 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:312038 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
