You are absolutely right :-) Armin Burger <armin.bur...@gmail.com> wrote on 28.01.2009 18:28:13:
> It's not a question to identify if ODBC is used or not, but if *MS > Access* is the backend ODBC source. Real databases understand correct > SQL via ODBC and not the crude SQL/VBA mix MS defines ;-) > > armin > > On Wed, Jan 28, 2009 at 8:33 AM, <dejan.gam...@pula.hr> wrote: > > 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 > > > > dejan.gam...@pula.hr 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 > >> pmapper-users@lists.sourceforge.net > >> 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 > > pmapper-users@lists.sourceforge.net > > 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 pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
