Hi, I have solved the problem by using UCASE instead of UPPER in search.php (in getSearchParamsXY_DB function). It works fine, only it is not a generic solution that could identify if odbc is being used or not
regards, dejan [email protected] wrote on 28.01.2009 08:02:09: > Hi, > > I am using p.mapper version 3.2 on Windows XP machine. > > I have successfully displayed points coming from MS Access with two > "spatial" columns, using XY layer. Attributes from the same table are > correctly displayed too, using Info button. > > The problem is the attribute query that somehow doesn't work because of > incorrect sql code. > > The map file part is: > > LAYER > NAME "krk" > TYPE POINT > METADATA > "DESCRIPTION" "KC" > "LAYER_ENCODING" "WINDOWS-1250" > "XYLAYER_PROPERTIES" "odbc://'':''/localh...@krk||baza||x,y,0" > "RESULT_FIELDS" "PREZIME,IME" > "RESULT_HEADERS" "Prezime, Ime" > END # Metadata > CLASS > Name 'Kc broj' > COLOR 0 0 0 > SYMBOL 'circle' > SIZE 10 > TEMPLATE void > END > END > > The search.xml part is: > > <searchitem name="ime" description="Ime"> > <layer type="xy" name="krk"> > <field type="s" name="IME" description="Ime" wildcard="0" /> > </layer> > </searchitem> > > And the error.log is: > > [28-Jan-2009 07:52:03] ===== P.MAPPER: DB ERROR ===== > Standard Message: DB Error: syntax error > DBMS/Debug Message: SELECT x, y, PREZIME,IME FROM baza WHERE UPPER(IME) > LIKE '%ROB%' [nativecode=37000 [Microsoft][ODBC Microsoft Access Driver] > Undefined function 'UPPER' in expression.] > > I have seen a similar post and I suppose I have to somehow change the > UPPER to UCASE. > > Can it be done in a simple way? > > thanks and regards > > dejan > ------------------------------------------------------------------------------ > This SF.net email is sponsored by: > SourcForge Community > SourceForge wants to tell your story. > http://p.sf.net/sfu/sf-spreadtheword > _______________________________________________ > pmapper-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/pmapper-users ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ pmapper-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/pmapper-users
