<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-15">
<META content="MSHTML 6.00.2900.3243" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px">
<DIV>Hi Greg</DIV>
<DIV> </DIV>
<DIV>Mapserver is correctly passing where conditions containing in-line variables to an external .ovf for me. I am using Mapserver 5.2 as in ms4w. My .ovf uses an ODBC datasource.</DIV>
<DIV> </DIV>
<DIV>Here is part of a layer definition from my mapfile:</DIV>
<DIV> </DIV>
<DIV> LAYER<BR> NAME "main_gates"<BR> GROUP "FMS"<BR> CONNECTION "./main_gates.ovf"<BR> CONNECTIONTYPE OGR<BR> DATA "main_gates"<BR> FILTER "WHERE farm_id = 'úrmid%'"</DIV>
<DIV> </DIV>
<DIV>Robert Sanson<BR><BR>>>> Greg Luker <gluker@scu.edu.au> 12/02/2009 1:15 p.m. >>><BR>Hi mapservers-users,<BR><BR>Thanks Steve W, Pietro, and Andreas for your help!<BR><BR>I have got around some of the problem (MapServer error messages and <BR>MySQL passwords visible in browser View/Source) by moving the OGRVRT <BR>MySQL info from inline in the .map file into an external .ovf file <BR>(Pietro's >1024 characters problem seems right), but two problems remain.<BR><BR>1) I originally abandoned external .ovf file because I can't pass <BR>variables into it like I can when inline (eg can't do <BR>(s.site_num_previous_surveys >= %myvarn%) in external .ovf). Is there <BR>a way to use variables in .ovf file?<BR><BR>2) I am still getting an error in View/Source:<BR><br><!--getString(): Symbol definition error. Parsing error near <BR>(DD):(line 677)--><BR>I've tried finding this problem in SYMBOL-related commands in the <BR>.map file, but no luck. Any ideas?<BR><BR>(I can send .map file if that helps)<BR><BR>Thanks,<BR>Greg Luker.<BR>Australia.<BR><BR><BR><BR><BR>_______________________________________________<BR>mapserver-users mailing list<BR>mapserver-users@lists.osgeo.org<BR><A href="http://lists.osgeo.org/mailman/listinfo/mapserver">http://lists.osgeo.org/mailman/listinfo/mapserver</A>-users<BR><BR></DIV><br><br><table bgcolor=white style="color:black"><tr><td><br>------------------------------------------------------------------<br>
The contents of this email are confidential to AsureQuality. If you have received this communication in error please notify the sender immediately and delete the message and any attachments. The opinions expressed in this email are not necessarily those of AsureQuality. This message has been scanned for known viruses before delivery. AsureQuality supports the Unsolicited Electronic Messages Act 2007. If you do not wish to receive similar communications in future, please notify the sender of this message.<br>
------------------------------------------------------------------</td></tr></table></BODY></HTML>