Te comento como tengo yo una consulta similar y lo soluciones cambiando esta línea:
<definition type="suggest" connectiontype="db" minlength="2" startleft="0" por esta otra. <definition type="suggest" connectiontype="ms" minlength="3" startleft="0" sort="asc"> En definitiva lo que cambie fue connectiontype de "db" a "ms" Saludos Eduardo 2010/10/21 Gustavo Insaurralde <tavo.guan...@gmail.com> > 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 > -- Edu ------------------------------------------------------------------------------ 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
