<HTML><HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18702"></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Hi, </DIV>
<DIV>I am attempting to query two columns in a database to extract a shape. </DIV>
<DIV>I want the shape where coupe_id = 'SR015E' and destination_id = 7</DIV>
<DIV> </DIV>
<DIV>This is my DATA statement in the mapfile:</DIV>
<DIV>DATA "SHAPE FROM (SELECT DESTINATION_ID, COUPE_ID, SHAPE FROM ROAD.COUPE_DESTINATION_ROUTE) USING UNIQUE COUPE_ID SRID 28355"</DIV>
<DIV> </DIV>
<DIV>And my URL:</DIV>
<DIV>localhost/cgi-bin/mapserv.exe?map=cart_route.map&layers=all&mode=itemnquery&qlayer=cart_route&mapext=shape&qstring=('[COUPE_ID]'%20IN%20'SR015E'%20AND%20'[DESTINATION_ID]%20IN%207') </DIV>
<DIV> </DIV>
<DIV>Can someone please tell me why I'm getting this error message: </DIV>
<DIV><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: 0px; DISPLAY: inline !important; FONT: medium 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; FLOAT: none; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px"><FONT size=2 face=Tahoma>msQueryByAttributes(): Search returned no results. No matching record(s) found.</FONT></SPAN></DIV>
<DIV><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: 0px; DISPLAY: inline !important; FONT: medium 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; FLOAT: none; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px"></SPAN> </DIV>
<DIV>Or how to see the statement that is compiled by mapserver. There is definitely a single shape that should be returned and therefore a map should be created. </DIV>
<DIV> </DIV>
<DIV>Cheers, </DIV>
<DIV>Jess</DIV>
<DIV> </DIV><BR>
<img src="cid:IAPSGIROUWBR.500528e4.jpg" alt="FT on Facebook" border="0">
<a href="http://twitter.com/forestrytasmania"><img src="cid:MNDJZRQIGBKF.500528e5.jpg" alt="FT on Twitter" border="0">
</a><a href="http://www.youtube.com/user/forestrytas?feature=results_main"><img src="cid:NRCUIRRCHODR.500528e6.jpg" alt="FT You Tube Channel" border="0">
</a><br>
<font face="Arial" size="2">Forestry creates regional employment:<br></font><font size="2" color="#0000ff" face="Arial"><a href="http://youtu.be/UBIUGiCiX00"><u>http://youtu.be/UBIUGiCiX00</u></a></font><br><font face="Arial" size="2">Growing
tomorrow's high conservation value forests:<br></font><font size="2" color="#0000ff" face="Arial"><a href="http://www.youtube.com/watch?v=wP6XCailI-A"><u>http://www.youtube.com/watch?v=wP6XCailI-A</u></a></font>
</BODY></HTML>