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 **********************************************************************
