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
