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.displayColumns[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\DisplayList.cfm:763)
at
cfDisplayList2ecfm2076578473._factor28(C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.cfm:762)
at
cfDisplayList2ecfm2076578473._factor32(C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.cfm:755)
at
cfDisplayList2ecfm2076578473._factor39(C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.cfm:754)
at
cfDisplayList2ecfm2076578473._factor46(C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.cfm:724)
at
cfDisplayList2ecfm2076578473._factor48(C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.cfm:212)
at
cfDisplayList2ecfm2076578473.runPage(C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.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\DisplayList.cfm:763)
at
cfDisplayList2ecfm2076578473._factor28(C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.cfm:762)
at
cfDisplayList2ecfm2076578473._factor32(C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.cfm:755)
at
cfDisplayList2ecfm2076578473._factor39(C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.cfm:754)
at
cfDisplayList2ecfm2076578473._factor46(C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.cfm:724)
at
cfDisplayList2ecfm2076578473._factor48(C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.cfm:212)
at
cfDisplayList2ecfm2076578473.runPage(C:\Inetpub\wwwroot\YPCSA\customtags\DisplayList.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(ClientScopePersistenceFilter.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:115)
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:264)
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
**********************************************************************
