<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
All,
<div class=""><br class="">
</div>
<div class="">I’ve been working with remote WFS feeds a lot lately, and it got me thingking about how to generate a MapServer TEMPLATE that included all the ATTRIBUTE names that are published from a WFS service in an automated way. I could write a Application
service to run a call to the service and report back with a TEMPLATE output, but then I started thinkging about how to do the same thing in a POSTGIS connection. </div>
<div class=""><br class="">
</div>
<div class="">Is anyone attempting to just output the attribute list directly from the SQL call and pass it to a TEMPLATE wrapper perhaps? I would be able to filter in one spot this way, in the SQL for the POSTGIS connection, and all the attributes pulled
from the SQL would automatically be applied in the TEMPLATE ala:</div>
<div class=""><br class="">
</div>
<div class=""> Column Name: <column value></div>
<div class=""><br class="">
</div>
<div class="">I’m really after the auto-population of the TEMPLATE to create the columnName: valueList from the connection. I can build a SQL to generate this even not knowing the original list to start with (SELECT * from . . .) . . .</div>
<div class=""><br class="">
</div>
<div class="">I can get the column names like so:</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">select column_name from information_schema.columns where table_name = 'stpl_swdischargepoint';</div>
</div>
<div class=""><br class="">
</div>
<div class="">Maybe the real question is, how can I generate a TEMPLATE from a pre-sql like this? would this need to happen outside of the MapServer CGI request structure?</div>
<div class=""><br class="">
</div>
<div class="">or is there a method forward for something like:</div>
<div class=""><br class="">
</div>
<div class=""> TEMPLATE = select column_name from information_schema.columns where table_name = ‘stpl_swdischargepoint';</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">Thoughts?</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">bobb</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div class="">
<div style="color: rgb(0, 0, 0); font-family: 'Comic Sans MS'; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<br class="Apple-interchange-newline">
<br class="">
</div>
<div style="color: rgb(0, 0, 0); font-family: 'Comic Sans MS'; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<font size="2" class="">"But what ... is it good for?"<br class="">
--Engineer at the Advanced Computing Systems Division of IBM, 1968, commenting on the microchip.</font></div>
<div style="color: rgb(0, 0, 0); font-family: 'Comic Sans MS'; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<br class="">
</div>
<br class="Apple-interchange-newline">
</div>
<br class="">
</div>
</body>
</html>