Re: Ben Nadel's POI..
Thanks C S Looks like it was the spaces between the comma's in my column listing jonese http://www.jonese.us http://twitter.com/jonese On Thu, Sep 4, 2008 at 10:09 PM, C S <[EMAIL PROTECTED]> wrote: >>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. > > Do any of these apply? > http://www.bennadel.com/blog/80-ColdFusion-SQL-Error-Table-Is-Not-Indexable-By-Name.htm > > ~| 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:312201 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Ben Nadel's POI..
>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. Do any of these apply? http://www.bennadel.com/blog/80-ColdFusion-SQL-Error-Table-Is-Not-Indexable-By-Name.htm ~| 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:312058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Ben Nadel's POI..
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 > > 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
RE: Ben Nadel's POI..
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 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
Ben Nadel's POI..
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] [JOURNALISSUE: [EMAIL PROTECTED] [JOURNALISOABBREV: [EMAIL PROTECTED] [JOURNALPUBDATE: [EMAIL PROTECTED] [JOUNRNALPUBLICATIONTYPE: [EMAIL PROTECTED] [PUBMEDID: [EMAIL PROTECTED] [ARTICLETITLE: [EMAIL PROTECTED] [ARTICLEABSTRACT: [EMAIL PROTECTED] [TOTALAUTHORS: [EMAIL PROTECTED] [AUTHORPOSITION: [EMAIL PROTECTED] [AUTHORTITLE: [EMAIL PROTECTED] [AUTHORABREVNAME: [EMAIL PROTECTED] [AUTHORFORENAME: [EMAIL PROTECTED] [AUTHORFIRSTNAME: [EMAIL PROTECTED] [AUTHORMIDDLENAME: [EMAIL PROTECTED] [AUTHORLASTNAME: [EMAIL PROTECTED] [AUTHORSUFFIX: [EMAIL PROTECTED] [SUBMISSIONKEY: [EMAIL PROTECTED] ] is not indexable by journalName The error occurred in C:\working\kol.nucleusclient.com\www\com\nucleusclient\utility\POIUtility.cfc: line 1714 Called from C:\working\kol.nucleusclient.com\www\com\nucleusclient\utility\POIUtility.cfc: line 1405 Called from C:\working\kol.nucleusclient.com\www\pubmedReportBuilder\includes\makeExcel.cfm: line 65 Called from C:\working\kol.nucleusclient.com\www\pubmedReportBuilder\includes\pubmedThread.cfm: line 97 Called from C:\working\kol.nucleusclient.com\www\pubmedReportBuilder\index.cfm: line 34 1712 : LOCAL.CellValue = ARGUMENTS.Query[ 1713 : LOCAL.Columns[ LOCAL.ColumnIndex ] 1714 : ][ LOCAL.RowIndex ]; 1715 : 1716 : // Check to see how we want to set the value. Meaning, what Got any idea what i'm doing wrong? I moved from querying a Table to querying a view in SQL. I changed up my columnList and ColumnNames as well. Afaik everything else stayed the same... thoughts? jonese http://www.jonese.us http://twitter.com/jonese ~| 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:312035 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4