Hi there,

pmapper 4.1.0 here


I´m trying to perform a query to a SQL Server

But i receive this error on pm_error.log

"[21-Oct-2010 10:45:33] PHP Warning:  Suggest::require_once(MDB2.php) [<a
href='suggest.require-once'>suggest.require-once</a>]: failed to open
stream: No such file or directory in
C:\ms4w\apps\pmapper-4.0.0\incphp\query\suggest.php on line 129 "

I´ve installed PEAR, but there is no MDB2.php file anywhere on my ms4w
folder...


Also...
is it possible to make a xml file that retrieves the query data to the
suggest option?

Because this is an "inline" search option, right?


CODE:

    <searchlist version="1.0">
        <dataroot>$</dataroot>
<searchitem name="inmuebles" description="Inmuebles">
 <layer type="xy" name="Layer">
 <field type="s" name="inmuebles" description="Plaats: "  wildcard="0" >
 <definition type="suggest" connectiontype="db" minlength="2" startleft="0"
sort="asc" dependfld="CATEGORY">
 <dsn encoding="UTF-8">odbc://'':''/localh...@databasename</dsn>
 <sql>SELECT DISTINCT Adrema FROM INMUEBLES WHERE Adrema LIKE
'[search]%'</sql>
 </definition>
 </field>
 </layer>
 </searchitem>
    </searchlist>

---
Gustavo Insaurralde
Analista Programador en Sistemas
Analista en Informática Aplicada
Maestro Mayor de Obras
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store 
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Reply via email to