<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16625"></HEAD>
<BODY style="PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 15px"
id=MailContainerBody leftMargin=0 topMargin=0 CanvasTabStop="true"
name="Compose message area">
<DIV><FONT face=Calibri>Hi</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>I may be on the wrong list but xml and Delphi guys that
know Postgis seem to be few and far between.</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>I`m using the following to display the binary data
on a memo component as text.</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri> PSQLQUery1.SQL.Add('Select the_geom from
p_id.image');<BR> PSQLQUery1.SQL.Add ('where
p_id.image.p_id_id = ''1534''');<BR>
PSQLQUery1.Open;</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>This works fine.</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>When I change it to select AsSvg the xml
consider assvg as another node and the geometry data does not
appear.</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri> PSQLQUery1.SQL.Add('Select AsSvg(the_geom) from
p_id.image');<BR> PSQLQUery1.SQL.Add ('where
p_id.image.p_id_id = ''1534''');<BR>
PSQLQUery1.Open;</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>If any one can suggest a
possible reason for this behavior It would be
appreciated. </FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>Bob</FONT></DIV></BODY></HTML>