<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=299453101-14022006><FONT face=Arial size=2>I've been looking at
the Itasca demo and see how they query a feature from a given layer. I
want to be able to do the same when my information is stored in a database, but
I have been unable to figure out how to do so.</FONT></SPAN></DIV>
<DIV><SPAN class=299453101-14022006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=299453101-14022006><FONT face=Arial size=2>I have the following
layer:</FONT></SPAN></DIV>
<DIV><SPAN class=299453101-14022006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=299453101-14022006><FONT face=Arial size=2>LAYER<BR> NAME
Machine_Outlines<BR> GROUP Machine<BR> CONNECTIONTYPE
postgis<BR> CONNECTION "host=localhost port=5432 dbname=thedatabase
password=thepassword user=testuser"<BR> DATA "outline FROM (SELECT
instance_id AS id, Translate(outline, X(position), Y(position), 0) AS outline
FROM instance INNER JOIN primitive_def_footprint ON
instance.primitive_def_id = primitive_def_footprint.primitive_def_id WHERE
primitive_type = 'machine') AS instance USING UNIQUE id USING SRID=-1"<BR>
TYPE POLYGON<BR> STATUS OFF<BR> CLASS<BR> NAME
'Machine'<BR> OUTLINECOLOR 0 0 0<BR> COLOR
192 64 192</FONT></SPAN></DIV>
<DIV><SPAN class=299453101-14022006><FONT face=Arial size=2>
TEMPLATE templates/Machines.html<BR> END</FONT></SPAN></DIV>
<DIV><SPAN class=299453101-14022006><FONT face=Arial size=2>
</FONT></SPAN></DIV>
<DIV><SPAN class=299453101-14022006><FONT face=Arial size=2> HEADER
"templates/Machines_header.html"<BR> FOOTER
"templates/Machines_footer.html"</FONT></SPAN></DIV><SPAN
class=299453101-14022006>
<DIV><BR><FONT face=Arial size=2>END</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2>A<SPAN class=299453101-14022006>nd then
Machines.html looks like</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=299453101-14022006><tr><td>[lrn]</td><td>[NAME]</td></tr></SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=299453101-14022006></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=299453101-14022006>What I have
been unable to figure out is how to get [NAME] to represent the column 'name'
from the instance table of my database.</SPAN></FONT></FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial size=2>Bryce Bangerter</FONT></DIV>
<DIV> </DIV></BODY></HTML>