[Cartoweb-users] search plugin result

[Oliver Christen]

Hi
The sql is generated in search/common/Search.php
Could you show me what the actual generated sql look like ?

regards
Oliver
  ----- Original Message ----- 
  From: Volkmar Herbst 
  To: cartoweb-users at lists.maptools.org 
  Sent: Thursday, June 07, 2007 8:59 AM
  Subject: [Cartoweb-users] search plugin result


  Dear all, I encounter a strange problem using the search plug-in. 

  I set it up like it is described in the new example and I can start my site without error but there was no result of the search. I tried to log the event in order to find out which SQl was sent to the pgsql database but the cartoweb.log does not show anything regarding this. 

   

  First question: is there another log somewhere showing the sql??). 

   

  I changed the table name in the database to provoke an error and got finally then sql string sent and found out, that the where clause did not send my search string but the column name with @ like: @<column>@ (@emri@) . This could not return anything of course. I inserted the column name "@<column>@"  in the search field in database and got a hit!

   

  What could this be and where can I find the Script which does the search and builds the sql????

   

  Further the click on the entry does not trigger the re-centre action but if I put manually the ID in the textbox it works. Wonder why.

  Any hints? 

   

  Here the ini file:

  dbType = pgsql

  dsn = pgsql://volkmar:xxxx@localhost:5432/database

  encodingContext = searchDb 

   

  config.streetname.provider.type = fulltextTable

  config.streetname.provider.table = streetname

  config.streetname.provider.id = fid

  config.streetname.provider.columns = emri

  config.streetname.provider.fulltextColumns = emri

  config.streetname.provider.sortColumn = emri

  config.streetname.provider.sortDirection = asc

  config.streetname.provider.sortPriorities = emri

  config.streetname.provider.labels =  emri

  config.streetname.formatter.type = smarty

  config.streetname.formatter.template = search_results

   

   

  the request:

    * array (  'ajaxActionRequest' => 'Search.DoIt',  'posted' => '1',  'js_folder_idx' => '3',  'selection_type' => '',  'selection_coords' => '',  'features' => '',  'project' => 'TiranaP',  'collapse_keymap' => '0',  'fake_reset' => '',  'fake_query' => '',  'outline_label_text' => 'Your label',  'tool' => 'zoomin',  'recenter_doit' => '0',  'openNodes' => '',  'layers_background' => 'qbird',  'outline_mask' => 'no',  'shortcut_doit' => '0',  'recenter_x' => '',  'recenter_y' => '',  'id_recenter_ids' => '',  'search_name' => 'Chestnut Street',  'search_config' => 'streetname',  'search_sort_column' => 'emri',  'search_sort_direction' => 'asc',  'search_number' => '',  'recenter_scale' => '0',  'mapsize' => '1',  'shortcut_id' => '-1',  'id_recenter_layer' => 'parcel',  'LangCookie' => 'en',  'TestCookie' => 'OK',  'PHPSESSID' => '813d2505b2785a868d2ad5fdef4410b6',)

   

   

   

   



------------------------------------------------------------------------------


  _______________________________________________
  Cartoweb-users mailing list
  Cartoweb-users at lists.maptools.org
  http://lists.maptools.org/mailman/listinfo/cartoweb-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-users/attachments/20070607/e2d55f5f/attachment-0001.html