[Cartoweb-users] ToolTips plugin

[Oliver Christen]

in the file QueryableLayer.php you have the function getXySqlQuery that 
build the sql query

change it slightly to do a print of the generated sql string before the 
return, so we can see if the query is correct.

regards
Oliver


----- Original Message ----- 
From: "wochter" <wochter at seznam.cz>
To: "Oliver Christen" <oliver.christen at camptocamp.com>
Sent: Friday, April 20, 2007 9:40 AM
Subject: Re: [Cartoweb-users] ToolTips plugin


Hi.
Yes.
SELECT popis FROM swdemo_budovy WHERE the_geom &&
Expand(GeomFromText('POINT(-357344.15238118666
-833211.1333333333)',2065),1);

returns right value

wochter



Oliver Christen  wrote / napísal(a):
> well, it say it all: "AjaxPlugins.ToolTips: no result"
> the request didnt returned any result
>
> do you get any result if you do a query directly in postgres/postgis
> with the coordinates -357344.15238118666, -833211.1333333333 ?
>
> regards
> Oliver
>
>
>
>> Hi,
>> could anybody help me with toolTips plugin please?
>>
>> in tooltips.ini I have defined:
>> timeout_async.swdemo_budovy.label = "Budovy"
>> timeout_async.swdemo_budovy.dsn = "pgsql://s:h@localhost:5432/dbb"
>> timeout_async.swdemo_budovy.dbTableName = swdemo_budovy
>> timeout_async.swdemo_budovy.attributes = "popis"
>>
>> in mapfile is:
>> LAYER
>>  NAME swdemo_budovy
>>  TYPE POLYGON
>>  STATUS ON
>>  CONNECTIONTYPE postgis
>>    CONNECTION 'user=s password=h dbname=dbb host=localhost port=5432'
>>    DATA "the_geom from swdemo_budovy"
>>  CLASS
>>    NAME "Swdemo_budovy"
>>    TEMPLATE "ttt"
>>    COLOR 235 200 120
>>    OUTLINECOLOR 182 130 17
>>  END
>>  METADATA
>>   'id_attribute_string' 'gid|int'
>>  END
>> END
>>
>> When I move mouse over the object jsTrace says:
>> Result initialized
>> AjaxPlugins.ToolTips: sending request for coords -357344.15238118666,
>> -833211.1333333333...
>> Request sent with url
>> :./client.php?toolTips=1&geoX=-357344.15238118666&geoY=-833211.1333333333&charSet=utf-8〈=
>>
>> AjaxPlugins.ToolTips: no result
>> AjaxPlugins.ToolTips: mouse is out map
>> AjaxPlugins.ToolTips: AJAX request aborted!
>> AjaxPlugins.ToolTips: no result
>>
>> This is the same when isn't mouse on object from this layer.
>>
>> What is wrong please?
>>
>> Thank you
>>
>> wochter
>>
>> p.s.
>> I use actual cvs version with  ajaxOn = true
>>
>>
>> _______________________________________________
>> Cartoweb-users mailing list
>> Cartoweb-users at lists.maptools.org
>> http://lists.maptools.org/mailman/listinfo/cartoweb-users
>>
>
>