proximity search
John W. Miescher
miescher at bizdata.com
Tue Jul 26 23:49:31 CDT 2005
Charles Yeomans wrote:
>if you index the field by words, then you can search for "apple" and
>get back fields like "apple crisp", "apple jack", "bad apple", "apple
>of my eye", "brie and apple sandwich", etc.
Yes, but I want ONLY apples. In other words if someone types 'abble', I
would like to ask 'do you mean apple or apply or able?', but since my DB
only contains foodstuffs, I need to ask for 'apple' only.
For the time being I'll concentrate on the first word only of each
record, that will probably cover 85% of all occurrences of apple. Things
get more complex in German and French, as the plural form is not just an
added 's' or 'es', same problem as with 'mouse' and 'mice' (and men, for
that matter ¿-).
rgs, john m.
-----Ursprüngliche Nachricht-----
Von: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] Im Auftrag von
valentina-request at lists.macserve.net
Gesendet: mardi, 26. juillet 2005 19:32
An: valentina at lists.macserve.net
Betreff: Valentina Digest, Vol 31, Issue 29
Send Valentina mailing list submissions to
valentina at lists.macserve.net
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.macserve.net/mailman/listinfo/valentina
or, via email, send a message with subject or body 'help' to
valentina-request at lists.macserve.net
You can reach the person managing the list at
valentina-owner at lists.macserve.net
When replying, please edit your Subject line so it is more specific than
"Re: Contents of Valentina digest..."
Today's Topics:
1. Re: api way (Ruslan Zasukhin)
2. proximity search (John W. Miescher)
3. Re: api way (Jules Jacquot)
4. Re: proximity search (Charles Yeomans)
5. Re: api way (Ruslan Zasukhin)
6. [ANN] Valentina Studio Admin b10 uploaded (Jochen Peters)
7. NOT reproduced: [V4Rb 2] VServer.RegisterDatabase problem
(Ruslan Zasukhin)
8. Re: Valentina Digest, Vol 31, Issue 28 (Bob Keeney)
9. SQL question (Chris Sheffield)
10. Re: SQL question (Ruslan Zasukhin)
11. VServer.ini questions (Charles Yeomans)
----------------------------------------------------------------------
Message: 1
Date: Sat, 23 Jul 2005 19:18:54 +0300
From: Ruslan Zasukhin <sunshine at public.kherson.ua>
Subject: Re: api way
To: "valentina at lists.macserve.net" <valentina at lists.macserve.net>
Message-ID: <BF08489E.38E91%sunshine at public.kherson.ua>
Content-Type: text/plain; charset="US-ASCII"
On 7/23/05 9:48 AM, "Ruslan Zasukhin" <sunshine at public.kherson.ua>
wrote:
>> dg=app.mdatabase.SQLSelect("select RecID,* from Article where BArt
>> like '"+ch+"%' and (JDepArt='C' and Ordart='"+Myord+"') order by
>> BArt")
What about next style?
Foo()
bitset1 = tblAticle.field("BArt").FindLike( ch + "%" )
if bitset1 = nil then return nil
bitset12 = tblAticle.field("JDepArt").FindValue( "C", bitset1 )
if bitset12 = nil then return nil
bitset123 = tblAticle.field("Ordart").FindValue( "Myord", bitset12 )
if bitset123 = nil then return nil
return tblArticle.Sort( bitset123, "BArt" )
end
--
Best regards,
Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information http://www.paradigmasoft.com
[I feel the need: the need for speed]
------------------------------
Message: 2
Date: Sat, 23 Jul 2005 18:34:31 +0200
From: "John W. Miescher" <miescher at bizdata.com>
Subject: proximity search
To: <valentina at lists.macserve.net>
Message-ID: <000001c58fa4$6711de80$0201a8c0 at JOHNHP>
Content-Type: text/plain; charset="us-ascii"
Thanks for a very useful tip from Juan Suros.
I am now trying to reduce it all to a clever REGEX algorithm. However...
Is there an easy way to isolate the searched for word directly from all
found strings? In other terms I'm searching for the word 'apple' which
appears inside numerous strings in the searched field (apple juice,
apple pie, sandwhich with apples, raw apple etc.)?
thanks for your help.
rgs, john m.
------------------------------
Message: 3
Date: Sat, 23 Jul 2005 18:37:44 +0200
From: Jules Jacquot <jules.jacquot at wanadoo.fr>
Subject: Re: api way
To: Valentina Developers <valentina at lists.macserve.net>
Message-ID: <C4F47EBB-A195-4C09-BB51-F264AF0A2254 at wanadoo.fr>
Content-Type: text/plain; charset=ISO-8859-1; delsp=yes; format=flowed
Le 23 juil. 05 à 18:18, Ruslan Zasukhin a écrit :
> On 7/23/05 9:48 AM, "Ruslan Zasukhin" <sunshine at public.kherson.ua>
> wrote:
>
>
>>> dg=app.mdatabase.SQLSelect("select RecID,* from Article where BArt
>>> like '"+ch+"%' and (JDepArt='C' and Ordart='"+Myord+"') order by
>>> BArt")
>>>
>
> What about next style?
>
>
> Foo()
> bitset1 = tblAticle.field("BArt").FindLike( ch + "%" )
> if bitset1 = nil then return nil
>
> bitset12 = tblAticle.field("JDepArt").FindValue( "C", bitset1 )
> if bitset12 = nil then return nil
>
> bitset123 = tblAticle.field("Ordart").FindValue( "Myord",
> bitset12 )
> if bitset123 = nil then return nil
>
> return tblArticle.Sort( bitset123, "BArt" )
> end
>
maybe it's better
i'll try it
but question :
are you sure that this line is correct ?
return tblArticle.Sort( bitset123, "BArt" )
i'll write ' tblarticle.field("Bart") ' instead "BArt" solely
best
jules
--------------------------------------------------
Il n'y a jamais d'autre difficulté dans le devoir que de le faire.
ALAIN
------------------------------
Message: 4
Date: Sat, 23 Jul 2005 12:43:00 -0400
From: Charles Yeomans <yeomans at desuetude.com>
Subject: Re: proximity search
To: Valentina Developers <valentina at lists.macserve.net>
Message-ID: <de15e96dd802b467fa9cdb152d039e14 at desuetude.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed
On Jul 23, 2005, at 12:34 PM, John W. Miescher wrote:
> Thanks for a very useful tip from Juan Suros.
> I am now trying to reduce it all to a clever REGEX algorithm.
> However...
>
> Is there an easy way to isolate the searched for word directly from
all
> found strings? In other terms I'm searching for the word 'apple' which
> appears inside numerous strings in the searched field (apple juice,
> apple pie, sandwhich with apples, raw apple etc.)?
>
if you index the field by words, then you can search for "apple" and
get back fields like "apple crisp", "apple jack", "bad apple", "apple
of my eye", "brie and apple sandwich", etc.
--------------
Charles Yeomans
------------------------------
Message: 5
Date: Sat, 23 Jul 2005 19:59:45 +0300
From: Ruslan Zasukhin <sunshine at public.kherson.ua>
Subject: Re: api way
To: "valentina at lists.macserve.net" <valentina at lists.macserve.net>
Message-ID: <BF085231.38E9F%sunshine at public.kherson.ua>
Content-Type: text/plain; charset="US-ASCII"
On 7/23/05 7:37 PM, "Jules Jacquot" <jules.jacquot at wanadoo.fr> wrote:
> are you sure that this line is correct ?
Not sure. I show general "picture"
> return tblArticle.Sort( bitset123, "BArt" )
>
> i'll write ' tblarticle.field("Bart") ' instead "BArt" solely
--
Best regards,
Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
http://www.paradigmasoft.com
[I feel the need: the need for speed]
------------------------------
Message: 6
Date: Sun, 24 Jul 2005 20:30:35 +0200
From: Jochen Peters <j.peters at valentina-db.de>
Subject: [ANN] Valentina Studio Admin b10 uploaded
To: valentina-studio at lists.macserve.net
Cc: Valentina Beta <valentina-beta at lists.macserve.net>
Message-ID: <D3F02AE8-0163-424B-8D23-B2BEE448BA35 at valentina-db.de>
Content-Type: text/plain; charset=US-ASCII; format=flowed
Hi all,
i have uploaded b10 Mac+Win to both sites:
http://www.paradigmasoft.com
and
http://www.valentina-db.de
This version contains all the latest kernel fixes.
You can see list of other changes in Mantis.
--
Best regards,
Jochen Peters
PIIT GmbH
------------------------------------
http://www.valentina-db.de
------------------------------
Message: 7
Date: Mon, 25 Jul 2005 12:12:03 +0300
From: Ruslan Zasukhin <sunshine at public.kherson.ua>
Subject: NOT reproduced: [V4Rb 2] VServer.RegisterDatabase problem
To: "valentina at lists.macserve.net" <valentina at lists.macserve.net>,
"valentina-beta at lists.macserve.net"
<valentina-beta at lists.macserve.net>
Message-ID: <BF0A8793.39021%sunshine at public.kherson.ua>
Content-Type: text/plain; charset="US-ASCII"
On 7/22/05 5:22 PM, "Charles Yeomans" <yeomans at desuetude.com> wrote:
> On Jul 22, 2005, at 2:59 AM, Ruslan Zasukhin wrote:
>
>> On 7/21/05 10:28 PM, "Charles Yeomans" <yeomans at desuetude.com> wrote:
>>
>>> I'm having a problem with VServer.RegisterDatabase. When I call it,
the app
>>> hangs. It doesn't appear to be using an CPU, but I have to kill the
>>> process. I'm able to reproduce this with the example project
'Valentina
>>> Server Utility', using the latest release and fc versions of
Valentina. Is
>>> anyone seeing this?
>>
>> We will check this Charles.
>>
>> So you try
>>
>> 2.0.4 release ?
>>
>> Or
>>
>> 2.0.5fc2 + fc3
>
> Both.
Hi Charles,
We have test against of
VServer_Office (2.0.5, Protocol 2.0, Kernel 2.0.5fc2)
and V4RB 2.0.5 fc3
Everything works fine. We have test on mac and windows.
Using Examples/Advanced/ValentinaServerUtility
We can register and unregister database.
P.S. Btw, this is third party example, and it show dialog to choose
database
on disk. This is not very correct. It should just ask a name of database
file to be able work remotely.
--
Best regards,
Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
http://www.paradigmasoft.com
[I feel the need: the need for speed]
------------------------------
Message: 8
Date: Mon, 25 Jul 2005 16:17:29 -0500
From: Bob Keeney <bkeeney at everestkc.net>
Subject: Re: Valentina Digest, Vol 31, Issue 28
To: valentina at lists.macserve.net
Message-ID: <2EC9DF9A-64C4-4C22-9601-8DEFFCA3FF79 at everestkc.net>
Content-Type: text/plain; format=flowed; delsp=yes; charset=US-ASCII
> Hmmm. I still cannot. And I have tried the following. I was
able to
> open master.vdb using client-server connection and add a record
for my
> database. After rebooting, I executed the following code.
>
> Valentina.InitClient
> dim server as new VServer("localhost", "sa", "sa")
> server.OpenSession
>
> dim names(-1) as String
> dim paths(-1) as String
>
> For i as Integer = 1 to server.DatabaseCount
> dim dbInfo as VDataBaseInfo = server.DatabaseInfo(i)
> names.Append dbInfo.Name
> paths.Append dbInfo.Path
> Next
> server.CloseSession
> server = nil
>
> dim db as new VDatabase("localhost", "sa", "sa")
> dim f as new FolderItem(names(1))
> db.Open(f)
>
> Upon attempting to execute the last line, my app crashes, and this
> entry appears in the server log file.
>
> 16:04:16.266245 (41990144): (16) ERROR 0xFFFFFFD9: (null)
>
>
> Any suggestions?
> We will make new build tomorrow.
> Then please test it.
> Actually you should not manually edit masterdb.
> Or do this very carefully.
> If you have some simple test project send us.
> Again, we have test with
> a) Valentina Studio
> b) example server utility
> On mac and windows. No problems found.
I can confirm that I have run into this exact same problem using the
Server Utility Project. Mac OS X Tiger, 2.05fc3, RB2005r1.
Bob K.
------------------------------
Message: 9
Date: Mon, 25 Jul 2005 15:45:01 -0600
From: Chris Sheffield <cmsheffield at gmail.com>
Subject: SQL question
To: "valentina at lists.macserve.net Developers"
<valentina at lists.macserve.net>
Message-ID: <697BD836-C39C-47A5-B52B-811BA91BC785 at gmail.com>
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
I hope you all don't mind me asking a basic SQL question, not
necessarily directly related to Valentina.
I have two tables linked in a many-to-many relationship via a third
intersect table. I'm trying to figure out how to retrieve the data I
need from the two tables. After creating the structure and running a
query in MS Access, the SQL is something like:
SELECT Roles.RoleDesc, Tasks.TaskDesc FROM (Roles INNER JOIN
TaskRoles ON Roles.RecID = TaskRoles.RolePtr) INNER JOIN Tasks ON
TaskRoles.TaskPtr = Tasks.RecID
But this gives me a "602: Table Not Fount" error in Valentina. I'm
sure it has something to do with the JOIN syntax, but I'm not really
sure how to change that to make it work for Valentina. I'm hoping
it's not going to require two separate queries. Can someone help?
I'm not very good with joins.
Thanks,
Chris
------------------------------------------
Chris Sheffield
Read Naturally
The Fluency Company
http://www.readnaturally.com
------------------------------------------
------------------------------
Message: 10
Date: Tue, 26 Jul 2005 09:27:21 +0300
From: Ruslan Zasukhin <sunshine at public.kherson.ua>
Subject: Re: SQL question
To: "valentina at lists.macserve.net" <valentina at lists.macserve.net>
Message-ID: <BF0BB279.39207%sunshine at public.kherson.ua>
Content-Type: text/plain; charset="US-ASCII"
On 7/26/05 12:45 AM, "Chris Sheffield" <cmsheffield at gmail.com> wrote:
Hi Chris,
> I hope you all don't mind me asking a basic SQL question, not
> necessarily directly related to Valentina.
Of course
> I have two tables linked in a many-to-many relationship via a third
> intersect table. I'm trying to figure out how to retrieve the data I
> need from the two tables. After creating the structure and running a
> query in MS Access, the SQL is something like:
>
>
> SELECT Roles.RoleDesc, Tasks.TaskDesc FROM (Roles INNER JOIN
> TaskRoles ON Roles.RecID = TaskRoles.RolePtr) INNER JOIN Tasks ON
> TaskRoles.TaskPtr = Tasks.RecID
>
>
> But this gives me a "602: Table Not Fount" error in Valentina.
Looks you use Valentina 1.x
> I'm sure it has something to do with the JOIN syntax, but I'm not
really
> sure how to change that to make it work for Valentina.
1.x do not support such syntax.
Must be
SELECT Roles.RoleDesc, Tasks.TaskDesc
FROM Roles, TaskRoles, Tasks
WHERE
Roles.RecID = TaskRoles.RolePtr AND
TaskRoles.TaskPtr = Tasks.RecID
> I'm hoping it's not going to require two separate queries. Can
someone help?
> I'm not very good with joins.
--
Best regards,
Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
http://www.paradigmasoft.com
[I feel the need: the need for speed]
------------------------------
Message: 11
Date: Tue, 26 Jul 2005 13:31:17 -0400
From: Charles Yeomans <yeomans at desuetude.com>
Subject: VServer.ini questions
To: Valentina Developers <valentina at lists.macserve.net>
Message-ID: <38953b7569f9b32c8f8324e2fb42c9d0 at desuetude.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed
I infer from the default .ini file for VServer that SystemCatalog can
be a path relative to VServer.app; is this so?
Also, VServer doesn't handle paths as well as I'd like. In particular,
I'd think that one should be able to give the path to a directory as
/Library/Foo/Databases/, including the trailing slash. But it looks
like VServer assumes that there will be no trailing slash and always
adds one. At least it's consistent :)
--------------
Charles Yeomans
------------------------------
_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
End of Valentina Digest, Vol 31, Issue 29
*****************************************
More information about the Valentina
mailing list