Hi Tim, Remember that any columns in a query used by cf_DisplayList have to be aliased as TableName_ColumnName. I'm pretty sure this is the problem you're having. Try changing the selectClause to explicitly name the returned columns and alias each one as TableName_Column; hopefully that will work better for you.
David ----- Original Message ----- From: "Tim Blankenship" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, May 30, 2006 3:36 PM Subject: Re: [plum] Trouble getting database view to populate a list > Code > <cfscript> > // Select data > selectClause = "*"; > fromClause = "VW_BYLOC"; > whereClause = ""; > qry_byloc = Application.DatabaseBlocks.SelectRecords(selectClause:selectClause, > fromClause:fromClause, whereClause:whereClause); > </cfscript> > > > <cf_DisplayList > table = "VW_BYLOC" > query = "#qry_byloc#" > rowsPerPage = "50" > label = "Server Info by Location" > whereClauseExtension = "" > displayALinkToThisSearchForm = "No" > sampleData = "0" > displayAllIfNoSearchCriteria = "No"> > > <cf_DisplayColumnInList column="SN" table="VW_BYLOC" label="SN" > align="Left"></cf_DisplayColumnInList> > <!--- Also tried actual table name (SVR_GENERAL) ---> > </cf_displaylist> > > ERROR PAGE > Error Occurred While Processing RequestServer > Info by Location > > SN > > > The web site you are accessing has experienced an unexpected error. > Please contact the website administrator. > > The following information is meant for the website developer for > debugging > purposes. > > Error Occurred While Processing Request > [Table (rows 629 columns SN, NAME, TYPE, PLATFORM, OS, > MANUFACTURER, > MODEL, IP, SUBNET, GATEWAY, CONSOLE, RACK, LOCATION_CODE): [SN: > [EMAIL PROTECTED] [NAME: > [EMAIL PROTECTED] [TYPE: > [EMAIL PROTECTED] [PLATFORM: > [EMAIL PROTECTED] [OS: > [EMAIL PROTECTED] [MANUFACTURER: > [EMAIL PROTECTED] [MODEL: > [EMAIL PROTECTED] [IP: > [EMAIL PROTECTED] [SUBNET: > [EMAIL PROTECTED] [GATEWAY: > [EMAIL PROTECTED] [CONSOLE: > [EMAIL PROTECTED] [RACK: > [EMAIL PROTECTED] [LOCATION_CODE: > [EMAIL PROTECTED] ] is not indexable by > VW_BYLOC_SN > > > The error occurred in > C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.cfm: line 763 > Called from C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.cfm: > line 762 > Called from C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.cfm: > line 755 > Called from C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.cfm: > line 754 > Called from C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.cfm: > line 724 > Called from C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.cfm: > line 212 > Called from C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.cfm: > line 1 > Called from C:\Inetpub\wwwroot\svrtrak\reports\tst.cfm: line 21 > > 761 : </cfloop> > 762 : <cfelse> > 763 : <cfset value = > Attributes.listQuery[Application.DatabaseBlocks.GetSafeColumnAlias(ThisTag.d isplayColumns[i].table, > ThisTag.displayColumns[i].column)][currentRow]> > 764 : <cfif Len(Trim(ThisTag.displayColumns[i].formatFunction)) GT 0> > 765 : <cfset value = > Application.Formatting.FormatAccordingToFunctionCall(value, > ThisTag.displayColumns[i].formatFunction)> > > > > > Resources: > Check the ColdFusion documentation to verify that you are using > the correct syntax. > Search the Knowledge Base to find a solution to your problem. > > Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; > SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50215) > Remote Address 127.0.0.1 > Referrer http://localhost/svrtrak/login/LoginForm.cfm > Date/Time 30-May-06 02:31 PM > > Stack Trace (click to expand) > at > cfDisplayList2ecfm2076578473._factor27(C:\Inetpub\wwwroot\YPCSA\customtags\D isplayList.cfm:763) > at > cfDisplayList2ecfm2076578473._factor28(C:\Inetpub\wwwroot\YPCSA\customtags\D isplayList.cfm:762) > at > cfDisplayList2ecfm2076578473._factor32(C:\Inetpub\wwwroot\YPCSA\customtags\D isplayList.cfm:755) > at > cfDisplayList2ecfm2076578473._factor39(C:\Inetpub\wwwroot\YPCSA\customtags\D isplayList.cfm:754) > at > cfDisplayList2ecfm2076578473._factor46(C:\Inetpub\wwwroot\YPCSA\customtags\D isplayList.cfm:724) > at > cfDisplayList2ecfm2076578473._factor48(C:\Inetpub\wwwroot\YPCSA\customtags\D isplayList.cfm:212) > at > cfDisplayList2ecfm2076578473.runPage(C:\Inetpub\wwwroot\YPCSA\customtags\Dis playList.cfm:1) > at > cftst2ecfm1658935578.runPage(C:\Inetpub\wwwroot\svrtrak\reports\tst.cfm:21) > > > > java.lang.IllegalArgumentException: [Table (rows 629 columns SN, NAME, > TYPE, PLATFORM, OS, MANUFACTURER, MODEL, IP, SUBNET, GATEWAY, CONSOLE, > RACK, LOCATION_CODE): [SN: [EMAIL PROTECTED] [NAME: > [EMAIL PROTECTED] [TYPE: > [EMAIL PROTECTED] [PLATFORM: > [EMAIL PROTECTED] [OS: > [EMAIL PROTECTED] [MANUFACTURER: > [EMAIL PROTECTED] [MODEL: > [EMAIL PROTECTED] [IP: > [EMAIL PROTECTED] [SUBNET: > [EMAIL PROTECTED] [GATEWAY: > [EMAIL PROTECTED] [CONSOLE: > [EMAIL PROTECTED] [RACK: > [EMAIL PROTECTED] [LOCATION_CODE: > [EMAIL PROTECTED] ] is not indexable by VW_BYLOC_SN > at coldfusion.runtime.CfJspPage.ArrayGetAt(CfJspPage.java:480) > at coldfusion.runtime.CfJspPage._arrayGetAt(CfJspPage.java:516) > at coldfusion.runtime.CfJspPage._arrayGetAt(CfJspPage.java:381) > at cfDisplayList2ecfm2076578473._factor27(C:\Inetpub\wwwroot\YPCSA\customtags\D isplayList.cfm:763) > at cfDisplayList2ecfm2076578473._factor28(C:\Inetpub\wwwroot\YPCSA\customtags\D isplayList.cfm:762) > at cfDisplayList2ecfm2076578473._factor32(C:\Inetpub\wwwroot\YPCSA\customtags\D isplayList.cfm:755) > at cfDisplayList2ecfm2076578473._factor39(C:\Inetpub\wwwroot\YPCSA\customtags\D isplayList.cfm:754) > at cfDisplayList2ecfm2076578473._factor46(C:\Inetpub\wwwroot\YPCSA\customtags\D isplayList.cfm:724) > at cfDisplayList2ecfm2076578473._factor48(C:\Inetpub\wwwroot\YPCSA\customtags\D isplayList.cfm:212) > at cfDisplayList2ecfm2076578473.runPage(C:\Inetpub\wwwroot\YPCSA\customtags\Dis playList.cfm:1) > at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) > at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java: 63) > at coldfusion.tagext.lang.ModuleTag.doAfterBody(ModuleTag.java:333) > at cftst2ecfm1658935578.runPage(C:\Inetpub\wwwroot\svrtrak\reports\tst.cfm:21) > at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) > at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) > at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) > at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210) > at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51) > at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) > at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27) > at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) > at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) > at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) > at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) > at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) > at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) > at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:11 5) > at coldfusion.CfmServlet.service(CfmServlet.java:107) > at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) > at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) > at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) > at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257) > at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) > at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) > at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 318) > at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426 ) > at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:26 4) > at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) > > > > > > Debugging Information ColdFusion Server Developer7,0,1,116466 > Template /svrtrak/reports/tst.cfm > Time Stamp 30-May-06 02:31 PM > Locale English (US) > User Agent Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; > .NET CLR 1.1.4322; .NET CLR 2.0.50215) > Remote IP 127.0.0.1 > Host Name 127.0.0.1 > > > > Execution Time > Total TimeAvg TimeCountTemplate > 731 ms731 ms1C:\Inetpub\wwwroot\svrtrak\reports\tst.cfm > 721 ms721 ms1CFC[ > C:\Inetpub\wwwroot\svrtrak\components\DatabaseBlocks.cfc | > SelectRecords(whereClause = , fromClause = VW_BYLOC, selectClause = > *) ] from C:\Inetpub\wwwroot\svrtrak\components\DatabaseBlocks.cfc > 171 ms171 ms1C:\Inetpub\wwwroot\svrtrak\reports\Application.cfm > 141 ms141 ms1C:\Inetpub\wwwroot\svrtrak\Global.cfm > 50 ms50 ms1CFC[ C:\Inetpub\wwwroot\svrtrak\components\Verity.cfc | > CreateCollectionCheckboxes() ] from > C:\Inetpub\wwwroot\svrtrak\components\Verity.cfc > 31 ms31 ms1CFC[ C:\Inetpub\wwwroot\svrtrak\components\Verity.cfc | > CreateCollectionsObject() ] from > C:\Inetpub\wwwroot\svrtrak\components\Verity.cfc > 10 ms10 ms1C:\Inetpub\wwwroot\svrtrak\Environment.cfm > 0 ms0 ms1C:\Inetpub\wwwroot\YPCSA\customtags\Authorize.cfm > 0 ms0 ms1C:\Inetpub\wwwroot\YPCSA\customtags\DisplayColumnInList.cfm > 0 ms0 ms1C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.cfm > 0 ms0 ms2CFC[ C:\Inetpub\wwwroot\svrtrak\components\CookieAPI.cfc | > GetCookie(AdminLayoutName) ] from > C:\Inetpub\wwwroot\svrtrak\components\CookieAPI.cfc > 0 ms0 ms2CFC[ C:\Inetpub\wwwroot\svrtrak\components\CookieAPI.cfc | > GetCookie(AdminStylesheetName) ] from > C:\Inetpub\wwwroot\svrtrak\components\CookieAPI.cfc > 0 ms0 ms2CFC[ C:\Inetpub\wwwroot\svrtrak\components\CookieAPI.cfc | > GetCookie(HasPrintableStylesheet) ] from > C:\Inetpub\wwwroot\svrtrak\components\CookieAPI.cfc > 0 ms0 ms2CFC[ C:\Inetpub\wwwroot\svrtrak\components\CookieAPI.cfc | > GetCookie(LayoutName) ] from > C:\Inetpub\wwwroot\svrtrak\components\CookieAPI.cfc > 0 ms0 ms2CFC[ C:\Inetpub\wwwroot\svrtrak\components\CookieAPI.cfc | > GetCookie(StylesheetName) ] from > C:\Inetpub\wwwroot\svrtrak\components\CookieAPI.cfc > 0 ms0 ms1CFC[ > C:\Inetpub\wwwroot\svrtrak\components\DatabaseBlocks.cfc | > GetSafeColumnAlias(VW_BYLOC, SN) ] from > C:\Inetpub\wwwroot\svrtrak\components\DatabaseBlocks.cfc > 0 ms0 ms1CFC[ > C:\Inetpub\wwwroot\svrtrak\components\Formatting.cfc | > AlternateRowShading(1) ] from > C:\Inetpub\wwwroot\svrtrak\components\Formatting.cfc > 0 ms0 ms2CFC[ > C:\Inetpub\wwwroot\svrtrak\components\Formatting.cfc | > IsValidType(text) ] from > C:\Inetpub\wwwroot\svrtrak\components\Formatting.cfc > 200 ms STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN > 1102 ms TOTAL EXECUTION TIME > red = over 250 ms average execution time > > > Exceptions > 14:31:01.001 - java.lang.IllegalArgumentException - in > C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.cfm : line 763 > [Table (rows 629 columns SN, NAME, TYPE, PLATFORM, OS, > MANUFACTURER, MODEL, IP, SUBNET, GATEWAY, CONSOLE, RACK, > LOCATION_CODE): [SN: [EMAIL PROTECTED] [NAME: > [EMAIL PROTECTED] [TYPE: > [EMAIL PROTECTED] [PLATFORM: > [EMAIL PROTECTED] [OS: > [EMAIL PROTECTED] [MANUFACTURER: > [EMAIL PROTECTED] [MODEL: > [EMAIL PROTECTED] [IP: > [EMAIL PROTECTED] [SUBNET: > [EMAIL PROTECTED] [GATEWAY: > [EMAIL PROTECTED] [CONSOLE: > [EMAIL PROTECTED] [RACK: > [EMAIL PROTECTED] [LOCATION_CODE: > [EMAIL PROTECTED] ] is not indexable by VW_BYLOC_SN > > > SQL Queries > queryResult (Datasource=svrtrak, Time=0ms, Records=629) in > C:\Inetpub\wwwroot\svrtrak\components\DatabaseBlocks.cfc @ 14:31:01.001 > > SELECT * > FROM VW_BYLOC > WHERE 1 > 0 > > > > > On 5/30/06, David Churvis <[EMAIL PROTECTED]> wrote: > > What problem is Plum having? I see no reason why DisplayList wouldn't work > > with a valid view. > > > > David > > ----- Original Message ----- > > From: "Tim Blankenship" <[EMAIL PROTECTED]> > > To: "Plum Email List" <[email protected]> > > Sent: Thursday, May 25, 2006 11:59 AM > > Subject: [plum] Trouble getting database view to populate a list > > > > > > Hola all, > > DB: Oracle 9 > > > > Alright I have a view in my database that I can retrieve the records > > using database blocks. The trouble is getting the output to display on > > a list. > > > > Does CF_DisplayList work with views? If so for the table I assume the > > view name should be used. Any help appreciated. > > > > QRY > > <cfscript> > > selectClause = "*"; > > fromClause = "VW_BYLOC"; > > qry_byloc = > > Application.DatabaseBlocks.SelectRecords(selectClause:selectClause, > > fromClause:fromClause); > > </cfscript> > > > > PAGE > > <cf_DisplayList > > table = "VW_BYLOC" > > query = "#qry_byloc#" > > rowsPerPage = "50" > > label = "Server Info by Location" > > whereClauseExtension = "" > > displayALinkToThisSearchForm = "No" > > sampleData = "0" > > displayAllIfNoSearchCriteria = "No"> > > <cf_DisplayColumnInList column="SN" table="?" type="varchar(100)"> > > </cf_displaylist> > > > > I thought a view would be the simplest but now I am reconsidering. > > Here is my views SQL. > > > > SELECT > > A.SN , A.NAME , B.TYPE , D.PLATFORM , E.OS > > , G.MANUFACTURER , H.MODEL , I.IP , I.SUBNET , I.GATEWAY > > , I.CONSOLE , K.RACK , K.LOCATION_CODE > > FROM > > SVRTRAK.SVR_GENERAL A > > , SVRTRAK.SVR_SUP_PLATFORM D > > , SVRTRAK.SVR_SUP_OS E > > , SVRTRAK.SVR_SUP_MODEL H > > , SVRTRAK.SVR_LOCATION K > > , SVRTRAK.SVR_SUP_SLATYPE B > > , SVRTRAK.SVR_SOFTWARE C > > , SVRTRAK.SVR_NETWORK I > > , SVRTRAK.SVR_HARDWARE F > > , SVRTRAK.SVR_SUP_MANUFACTURER G > > WHERE > > (A.SLA_ID = B.SLA_ID (+) ) > > AND (C.SN (+) = A.SN) > > AND (C.PLATFORM_ID = D.PLATFORM_ID (+) ) > > AND (C.OS_ID = E.OS_ID (+) ) > > AND (F.SN (+) = A.SN) > > AND (F.MAN_ID = G.MAN_ID (+) ) > > AND (F.MOD_ID = H.MOD_ID (+) ) > > AND (I.SN (+) = A.SN) > > AND (K.SN (+) = A.SN) > > > > Basically I want to list each of the above colums. Ideally a search > > feature that allows search by K.LOCATION_CODE > > -- > > Tim Blankenship > > [EMAIL PROTECTED] > > > > ********************************************************************** > > You can subscribe to and unsubscribe from lists, and you can change > > your subscriptions between normal and digest modes here: > > > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > > ********************************************************************** > > > > > > ********************************************************************** > > You can subscribe to and unsubscribe from lists, and you can change > > your subscriptions between normal and digest modes here: > > > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > > ********************************************************************** > > > > > -- > Tim Blankenship > [EMAIL PROTECTED] > > ********************************************************************** > You can subscribe to and unsubscribe from lists, and you can change > your subscriptions between normal and digest modes here: > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > ********************************************************************** > ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
