Re: [pmapper-users] Attribute query against ODBC MS Access
You are absolutely right :-) Armin Burger 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, 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: > >> > >> > >> > >> > /> > >> > >> > >> > >> 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
Re: [pmapper-users] Attribute query against ODBC MS Access
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, 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: >> >> >> >> /> >> >> >> >> 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
Re: [pmapper-users] Search OGR layer
Hi Armin, Thxs I found the problem, in the LAYER CLASS I forgot the sintaxe "TEMPLATE void". > Date: Tue, 27 Jan 2009 19:47:03 +0100 > From: armin.bur...@gmail.com > To: juliano...@hotmail.com > CC: pmapper-users@lists.sourceforge.net > Subject: Re: [pmapper-users] Search OGR layer > > and whats's the problem with your settings? does your listed search > config not work with map info files? do you get errors, no results? I > converted the cities1eu shapefile from the demo data to tab format > and everything works fine as with it in shapefile format. > > armin > > On 27/01/2009 12:36, Juliano Agostinho wrote: > > > > Hi, > > > > I have many layers with OGR connection but i dont know how config the > > search file. > > > > MAPFILE : > > > > LAYER > > NAME "City" > > MAXSCALE 8000 > > TYPE POLYGON > > STATUS ON > > CONNECTIONTYPE OGR > > CONNECTION "City.TAB" > > STYLEITEM "AUTO" > > CLASS > > Name "City" > > END > > METADATA > > "DESCRIPTION" "City" > > "RESULT_FIELDS" "NAME" > > "RESULT_HEADERS" "Name" > > "RESULT_HYPERLINK" "Name" > > "LAYER_ENCODING" "UTF-8" > > "ows_title" "City" > > END > > END > > > > Search file (XML): > > > > > > > > > > > > > > > > I want search in OGR LAYER. > > I dont want convert TAB to SHP, anyone have one suggestion ? > > THX > > > > _ > > Receba GRÁTIS as mensagens do Messenger no seu celular quando você estiver > > offline. Conheça o MSN Mobile! > > http://mobile.live.com/signup/signup2.aspx?lc=pt-br > > -- > > 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 > > > _ Conheça o Windows Live Spaces, a rede de relacionamentos do Messenger! http://www.amigosdomessenger.com.br/ -- 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