Re: [pmapper-users] Attribute query against ODBC MS Access
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
[pmapper-users] Attribute query against ODBC MS Access
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
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 > -- 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] CSV or PEAR Excel Spreadsheet in UTF-8
Hi, there is a long existing patch (which never got in the PEAR package itself) for the UTF-8 XLS files somewhere. You have to patch slightly the Workbook.php of the package. This should help: http://research.elabs.govt.nz/generating-excel-spreadsheets-with-maori-macrons-in-php/ http://pear.php.net/bugs/bug.php?id=1572 For more, google with something like: "workbook.php UTF-8 bug Spreadsheet" frequens On Tue, Jan 27, 2009 at 6:19 PM, Aigars V wrote: > hi. > > I have a problems with my UTF-8 data export to excel and csv. Can't get it > to work. Help me, please. Thanks. > -- > 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
[pmapper-users] CSV or PEAR Excel Spreadsheet in UTF-8
hi. I have a problems with my UTF-8 data export to excel and csv. Can't get it to work. Help me, please. Thanks. -- 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
[pmapper-users] Search OGR layer
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
