*** dimas has quit IRC *** dcmwai has joined #gnuenterprise *** btami has joined #gnuenterprise *** btami has quit IRC *** dcmwai has quit IRC *** dimas has joined #gnuenterprise *** wt has joined #gnuenterprise *** wt has joined #gnuenterprise *** sjc has joined #gnuenterprise *** menomc has joined #gnuenterprise *** mnemoc has quit IRC *** menomc is now known as mnemoc *** btami has joined #gnuenterprise *** aspinformatica has joined #gnuenterprise hello hello I make a soundex_string and change my personal fuzzystring soundex function how can I use this on a gfd file in gnue-designer in pgAdmin sql I use this query select * from people where soundex_string(name) like '%' || soundex('Schneider') || '%' the soundex_string get all soundex for any word I'm trying to use Pre-Query Trigger what it could find for Schneider as an example? Neitzke / Naitzke / Scheibler / Schaibler / Schneider / Schnaider "Edgar Blásio Schneider" "Nicolau Schneider" "Walter Schneider" "Leonardo Schneider" "Hélio Luiz Schneider" "José Ari Schneider" "Sandra Feix" "Roque Schneider" "Claudemir Sander da Silva" "Clarice Schneider" "Clari Schneider" "Ervino Schneider" "Sandro Lowe" "Lotário Schneider" "João Tadeu Schneider Paraíba" "Daniel Schneider" "Albino Ângelo Santarosa" "Aloísio Schneider" "Marcos Aurélio Schneider" "Pedro Canísio Schneider" "Sandra Sofia Schroeder Wissmann" "Carlos Schneider" "Sedemir Schneider" "Perci Delfino Schneider" "Nelson Schneider" "Cláudia Sander da Silva" "José Vicente Santurio Ramos" "Marlene Schneider" "João Leonardo Schneider" its a phonetic search *** dcmwai has joined #gnuenterprise Neitzke / Naitzke / Scheibler / Schaibler / Schneider / Schnaider Eloi / Eloe / Noeli / Noili Algeo / Algeu Moraes / Morais Stuermer / Stiermer / Stüermer (ue=ie=üe) Júlio Basso, Julho Baso, Julio Baço Dresch / Drech / Dreck / Drec / Drek (Sch=Ch/Ck=C ou K) Schenckel / Chenckel / Xenckel / Schenkel (Sch=Ch=X=K) Christian / Cristian Therezinha / Terezinha / Teresinha / Terezina / Teresina / Theresina / Therezina Lehmen / Lehnen / Lenen / Lemen / Lemem / Lehmem Massuchini - Massochini - Massochine - Mazzochini - Mazochini - Masochini - Masoquini Ignacio / Inacio / Inácio / Ignácio Vociechoski = Vociecoski = Vociecoski = Vociecosqui = Vociequosqui aspinformatica: thinking of how to do what you want and no solution that i would like Luís = Luiz ok thanks if somebody know something, please send me a email in andre@aspinformatica.com.br may be discuss some related questions with reinhard and others where here of course :) ok when they'll be around ok thanks very much I will try again tomorrow yes, please I'm converting a CRM ERP from Visual Basic 6.0 to gnue plataform how it's going? I convert the database from SQL Server to PostgreSQL and make some forms address, street, regions, zipcodes and custumers but my client want a phonetic search in the clientes form you do not use appserver? I get many documents in the web about gnue-appserver and gnue-forms I'm using debian linux and Windows 2003 plataform its working fine in both I'm not using becouse I can't delete any record from my database I use a flag to know when somebody deleted a record and I can recover this another time but in the feature maybe I come to use appserver and I'm not know very much about appserver yet to write a complex busines rules its a ideal but not now yet thanks for all I need to go for today i'm just doing first steps myself... with appserver that is I have some troubles to start appserver in debian linux and I don't have many time to finish this project i have it running on two machines with debian malloc troubles ah good luck I need to go bey bye *** aspinformatica has quit IRC *** btami has quit IRC *** btami has joined #gnuenterprise *** btami has quit IRC *** dcmwai has quit IRC *** jcater has joined #gnuenterprise *** jcater__ has quit IRC *** sjc has quit IRC *** gancho has joined #gnuenterprise *** gancho has quit IRC *** wt has quit IRC *** jamest has quit IRC *** reinhard has joined #gnuenterprise good morning all good morning hi reinhard *** johannesV has joined #gnuenterprise good morning hi joh annesV :) i've downgraded the firmware of my router yesterday ... pptpd is working well again :) and tunnel still ok? haven't added the tunnel yet ... other end of the tunnel is not responding ... is it up at your end ? yes, should be *** btami has joined #gnuenterprise *** kilo has joined #gnuenterprise good morning hi btami hi morning *** reinhard is now known as morning hi kilo *** morning is now known as reinhard lol so it IS morning ;) bbl *** sjc has joined #gnuenterprise