On 21/10/2010 17:10, Gustavo Insaurralde wrote: > 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...
http://svn.pmapper.net/trac/search?q=MDB2&wiki=on > > > 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? > inline means just that the search config is in the same file as the main config and not in a separate xml file. Otherwise just see the available examples and check the docs for MDB2 how to define the connection string to the database. > > 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 > ------------------------------------------------------------------------------ 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
