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

2009-01-28 Thread Armin Burger
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

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

2009-01-28 Thread Dejan . Gambin
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 ;-)

[pmapper-users] Attribute query against ODBC MS Access

2009-01-27 Thread Dejan . Gambin
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

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

2009-01-27 Thread Dejan . Gambin
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