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