Re: [pmapper-users] Attribute query against ODBC MS Access

[Armin B. <arm...@gm...>]

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,  <Dej...@pu...> 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
>
> Dej...@pu... 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://'':''/localhost@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
>> pma...@li...
>> 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
> pma...@li...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>